[OpenSIPS-Users] CDRTool 6.9.1 prepaid error and info

[Carlo Dimaggio]

Il giorno 04/set/09, alle ore 18:24, Adrian Georgescu ha scritto:

> You probably did not read the changelog carefully and did not apply
> the changes from setup/mysql/alter_tables.mysql

Hi Adrian,

I have installed cdrtool 6.9.1 in a new system without upgrading from  
an old version, so I think there is no need to apply  
alter_tables.mysql...
In the create_table.mysql of 6.9.1 I see:

--
-- Table structure for table `prepaid`
--

DROP TABLE IF EXISTS `prepaid`;
CREATE TABLE `prepaid` (
   `id` int(10) unsigned NOT NULL auto_increment,
   `reseller_id` int(10) unsigned not NULL,
   `account` varchar(255) NOT NULL default '',
   `balance` decimal(10,4) NOT NULL default '0.0000',
   `change_date` datetime NOT NULL default '0000-00-00 00:00:00',
   `active_sessions` text NOT NULL,
   `session_counter` int(10) unsigned NOT NULL,
   PRIMARY KEY  (`id`),
   KEY `reseller_idx` (`reseller_id`),
   UNIQUE KEY `acc_id` (`account`)
)  DEFAULT CHARSET=latin1;

Is there an error in this script (no column domain)?
What about "last_call_price, destination" field?


Thank you
Carlo Dimaggio