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 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |