[OpenSIPS-Users] CDRTool 6.9.1 prepaid error and info
Carlo Dimaggio
jaasmailing at gmail.com
Fri Sep 4 21:25:13 CEST 2009
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
More information about the Users
mailing list