48nd9J2Y

1USE asteriskcdrdb;
2DROP TABLE IF EXISTS `autodial`;
3CREATE TABLE IF NOT EXISTS `autodial` (
4`id` int NOT NULL AUTO_INCREMENT,
5`add_date` timestamp DEFAULT CURRENT_TIMESTAMP,
6`number` varchar(80) NOT NULL DEFAULT '',
7`uniqueid` varchar(80) NOT NULL DEFAULT '',
8`call_retry` int(2) NOT NULL DEFAULT '0',
9`is_active` tinyint(1) NOT NULL DEFAULT '1',
10`call_result` varchar(32) NOT NULL DEFAULT '',
11`first_calldate` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
12`success_calldate` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
13`agent_answered` varchar(80) NOT NULL DEFAULT '',
14`call_duration` int(11) NOT NULL DEFAULT '0',
15`call_billsec` int(11) NOT NULL DEFAULT '0',
16PRIMARY KEY (id),
17KEY `uniqueid` (`uniqueid`)
18) 
19ENGINE=InnoDB DEFAULT CHARSET=utf8;