Add asterisk-stat 2.0.1, ASTERISK Call Detail Records Analizer.

PR:		ports/113738
Submitted by:	Fumihiko Kimura <jfkimura at yahoo.com>

1 files changed, 23 insertions, 0 deletions

diff --git a/www/asterisk-stat/files/cdr_pgsql.tbl b/www/asterisk-stat/files/cdr_pgsql.tbl
new file mode 100644
index 000000000000..ff668d27e7eb
--- /dev/null
+++ b/www/asterisk-stat/files/cdr_pgsql.tbl
@@ -0,0 +1,23 @@
+
+CREATE TABLE cdr (
+  calldate timestamp with time zone DEFAULT now() NOT NULL,
+  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 ''
+);
+
+CREATE INDEX calldate_ind ON cdr USING btree (calldate);
+CREATE INDEX dst_ind ON cdr USING btree (dst);
+CREATE INDEX accountcode_ind ON cdr USING btree (accountcode);