Chetan Gaonker | 7f4bf74 | 2016-05-04 15:56:08 -0700 | [diff] [blame^] | 1 | CREATE TABLE `cui` ( |
2 | `clientipaddress` varchar(46) NOT NULL default '', | ||||
3 | `callingstationid` varchar(50) NOT NULL default '', | ||||
4 | `username` varchar(64) NOT NULL default '', | ||||
5 | `cui` varchar(32) NOT NULL default '', | ||||
6 | `creationdate` timestamp NOT NULL default CURRENT_TIMESTAMP, | ||||
7 | `lastaccounting` timestamp NOT NULL default '0000-00-00 00:00:00', | ||||
8 | PRIMARY KEY (`username`,`clientipaddress`,`callingstationid`) | ||||
9 | ); |