diff options
Diffstat (limited to 'www/asterisk-stat/files/cdr_mysql.tbl')
-rw-r--r-- | www/asterisk-stat/files/cdr_mysql.tbl | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/www/asterisk-stat/files/cdr_mysql.tbl b/www/asterisk-stat/files/cdr_mysql.tbl deleted file mode 100644 index 78a5f2021e54..000000000000 --- a/www/asterisk-stat/files/cdr_mysql.tbl +++ /dev/null @@ -1,24 +0,0 @@ -USE asterisk; - -CREATE TABLE cdr ( - calldate datetime NOT NULL default '0000-00-00 00:00:00', - clid varchar(80) NOT NULL default '', - src varchar(80) NOT NULL default '', - dst varchar(80) NOT NULL default '', - dcontext varchar(80) NOT NULL default '', - channel varchar(80) NOT NULL default '', - dstchannel varchar(80) NOT NULL default '', - lastapp varchar(80) NOT NULL default '', - lastdata varchar(80) NOT NULL default '', - duration int(11) NOT NULL default '0', - billsec int(11) NOT NULL default '0', - disposition varchar(45) NOT NULL default '', - amaflags int(11) NOT NULL default '0', - accountcode varchar(20) NOT NULL default '', - uniqueid varchar(32) NOT NULL default '', - userfield varchar(255) NOT NULL default '' -); - -ALTER TABLE `cdr` ADD INDEX ( `calldate` ); -ALTER TABLE `cdr` ADD INDEX ( `dst` ); -ALTER TABLE `cdr` ADD INDEX ( `accountcode` ); |