* Created "old" branch and moved stuff

[gosa.git] / branches / old / gosa-plugins / gofon / contrib / gofon.sql

diff --git a/branches/old/gosa-plugins/gofon/contrib/gofon.sql b/branches/old/gosa-plugins/gofon/contrib/gofon.sql
new file mode 100644 (file)
index 0000000..584bcc9
--- /dev/null
+++ b/branches/old/gosa-plugins/gofon/contrib/gofon.sql
@@ -0,0 +1,24 @@
+create database gophone;
+use gophone;
+
+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 integer NOT NULL default '0',
+  billsec integer NOT NULL default '0',
+  disposition varchar(45) NOT NULL default '',
+  amaflags integer NOT NULL default '0',
+  accountcode varchar(20) NOT NULL default '',
+  uniqueid varchar(32) NOT NULL default '',
+  userfield varchar(255) NOT NULL default ''
+);
+
+GRANT INSERT,SELECT ON gophone.cdr TO asterisk@localhost IDENTIFIED BY 'somemysqlpass';
+