Rafael R. GV wrote:
PS: mysql-schema does not work properly in mysql 5.0.x because only one
timestamp with default now() in a table its allowed as you told me and
also I´ve found other issue related to auto_increment value:
ERROR 1064 (42000) at line 87: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'call (
id BIGINT NOT NULL AUTO_INCREMENT,
sessionid CHAR(40) NOT NULL,
' at line 1
This works:
CREATE TABLE `calls` (
`id` bigint(20) NOT NULL auto_increment,
`sessionid` char(40) NOT NULL,
`uniqueid` char(30) NOT NULL,
`username` char(40) NOT NULL,
`nasipaddress` char(30) default NULL,
`starttime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`stoptime` timestamp NOT NULL default '0000-00-00 00:00:00',
`sessiontime` int(11) default NULL,
`calledstation` char(30) default NULL,
`startdelay` int(11) default NULL,
`stopdelay` int(11) default NULL,
`terminatecause` char(20) default NULL,
`usertariff` char(20) default NULL,
`calledprovider` char(20) default NULL,
`calledcountry` char(30) default NULL,
`calledsub` char(20) default NULL,
`calledrate` float default NULL,
`sessionbill` float default NULL,
`destination` char(40) default NULL,
`id_tariffgroup` int(11) default NULL,
`id_tariffplan` int(11) default NULL,
`id_ratecard` int(11) default NULL,
`id_trunk` int(11) default NULL,
`sipiax` int(11) default '0',
`src` char(40) default NULL,
PRIMARY KEY (`id`)
)
hth,
Vahan Yerkanian
_______________________________________________
--Bandwidth and Colocation sponsored by Easynews.com --
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users