1 CREATE TABLE `finished` (
2 `call_id` int(11) NOT NULL AUTO_INCREMENT,
3 `call_start` datetime NOT NULL,
4 `call_end` datetime NOT NULL,
5 `call_type` varchar(1) NOT NULL,
6 `call_from` varchar(32) DEFAULT NULL,
7 `call_from_name` varchar(32) DEFAULT NULL,
8 `call_from_location` varchar(32) DEFAULT NULL,
9 `call_to` varchar(32) DEFAULT NULL,
10 `call_to_name` varchar(32) DEFAULT NULL,
11 `call_to_location` varchar(32) DEFAULT NULL,
12 `call_length` int(11) NOT NULL,
13 PRIMARY KEY (`call_id`)
14 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='finished calls';