diff options
author | Kevin Harwell <kharwell@digium.com> | 2017-03-23 15:33:40 -0500 |
---|---|---|
committer | Kevin Harwell <kharwell@digium.com> | 2017-03-23 15:33:40 -0500 |
commit | 552cf009c0939c8b6597708135412bdc596df4bb (patch) | |
tree | cc461fe481f77ddf96063a0fec5b360541b05c86 /contrib/realtime/mysql/mysql_cdr.sql | |
parent | f1b34e6eb465221902baf4dc9f8979201472202c (diff) |
Update for 13.15.0-rc113.15.0-rc1
Diffstat (limited to 'contrib/realtime/mysql/mysql_cdr.sql')
-rw-r--r-- | contrib/realtime/mysql/mysql_cdr.sql | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/contrib/realtime/mysql/mysql_cdr.sql b/contrib/realtime/mysql/mysql_cdr.sql new file mode 100644 index 000000000..972f69a97 --- /dev/null +++ b/contrib/realtime/mysql/mysql_cdr.sql @@ -0,0 +1,32 @@ +CREATE TABLE alembic_version ( + version_num VARCHAR(32) NOT NULL +); + +-- Running upgrade -> 210693f3123d + +CREATE TABLE cdr ( + accountcode VARCHAR(20), + src VARCHAR(80), + dst VARCHAR(80), + dcontext VARCHAR(80), + clid VARCHAR(80), + channel VARCHAR(80), + dstchannel VARCHAR(80), + lastapp VARCHAR(80), + lastdata VARCHAR(80), + start DATETIME, + answer DATETIME, + end DATETIME, + duration INTEGER, + billsec INTEGER, + disposition VARCHAR(45), + amaflags VARCHAR(45), + userfield VARCHAR(256), + uniqueid VARCHAR(150), + linkedid VARCHAR(150), + peeraccount VARCHAR(20), + sequence INTEGER +); + +INSERT INTO alembic_version (version_num) VALUES ('210693f3123d'); + |