summaryrefslogtreecommitdiff
path: root/www/asterisk-stat/files/cdr_mysql.tbl
diff options
context:
space:
mode:
Diffstat (limited to 'www/asterisk-stat/files/cdr_mysql.tbl')
-rw-r--r--www/asterisk-stat/files/cdr_mysql.tbl24
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` );