diff options
author | Mark Michelson <mmichelson@digium.com> | 2016-10-17 14:08:19 -0500 |
---|---|---|
committer | Mark Michelson <mmichelson@digium.com> | 2016-10-17 14:08:19 -0500 |
commit | df75b647da03eba6920020bac0cc950032a1e930 (patch) | |
tree | 732e40d620f6085acc0c0e4723218da64bae15ec /contrib/realtime/mssql/mssql_cdr.sql | |
parent | 546ec4b038ac3d750c5138d7fbb8e3ce93f482df (diff) |
Update for 13.12.0-rc113.12.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 + |