1 files changed, 24 insertions, 0 deletions
diff --git a/www/asterisk-stat/files/cdr_mysql.tbl b/www/asterisk-stat/files/cdr_mysql.tbl
new file mode 100644
index 000000000000..78a5f2021e54
--- /dev/null
+++ b/www/asterisk-stat/files/cdr_mysql.tbl
@@ -0,0 +1,24 @@
+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` );