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/mssql/mssql_cdr.sql | |
parent | f1b34e6eb465221902baf4dc9f8979201472202c (diff) |
Update for 13.15.0-rc113.15.0-rc1
Diffstat (limited to 'contrib/realtime/mssql/mssql_cdr.sql')
-rw-r--r-- | contrib/realtime/mssql/mssql_cdr.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/contrib/realtime/mssql/mssql_cdr.sql b/contrib/realtime/mssql/mssql_cdr.sql new file mode 100644 index 000000000..d342515cd --- /dev/null +++ b/contrib/realtime/mssql/mssql_cdr.sql @@ -0,0 +1,44 @@ +BEGIN TRANSACTION; + +CREATE TABLE alembic_version ( + version_num VARCHAR(32) NOT NULL +); + +GO + +-- Running upgrade -> 210693f3123d + +CREATE TABLE cdr ( + accountcode VARCHAR(20) NULL, + src VARCHAR(80) NULL, + dst VARCHAR(80) NULL, + dcontext VARCHAR(80) NULL, + clid VARCHAR(80) NULL, + channel VARCHAR(80) NULL, + dstchannel VARCHAR(80) NULL, + lastapp VARCHAR(80) NULL, + lastdata VARCHAR(80) NULL, + start DATETIME NULL, + answer DATETIME NULL, + [end] DATETIME NULL, + duration INTEGER NULL, + billsec INTEGER NULL, + disposition VARCHAR(45) NULL, + amaflags VARCHAR(45) NULL, + userfield VARCHAR(256) NULL, + uniqueid VARCHAR(150) NULL, + linkedid VARCHAR(150) NULL, + peeraccount VARCHAR(20) NULL, + sequence INTEGER NULL +); + +GO + +INSERT INTO alembic_version (version_num) VALUES ('210693f3123d'); + +GO + +COMMIT; + +GO + |