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/oracle/oracle_cdr.sql | |
parent | 546ec4b038ac3d750c5138d7fbb8e3ce93f482df (diff) |
Update for 13.12.0-rc113.12.0-rc1
Diffstat (limited to 'contrib/realtime/oracle/oracle_cdr.sql')
-rw-r--r-- | contrib/realtime/oracle/oracle_cdr.sql | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/contrib/realtime/oracle/oracle_cdr.sql b/contrib/realtime/oracle/oracle_cdr.sql new file mode 100644 index 000000000..81d599ae6 --- /dev/null +++ b/contrib/realtime/oracle/oracle_cdr.sql @@ -0,0 +1,38 @@ +CREATE TABLE alembic_version ( + version_num VARCHAR2(32 CHAR) NOT NULL +) + +/ + +-- Running upgrade -> 210693f3123d + +CREATE TABLE cdr ( + accountcode VARCHAR2(20 CHAR), + src VARCHAR2(80 CHAR), + dst VARCHAR2(80 CHAR), + dcontext VARCHAR2(80 CHAR), + clid VARCHAR2(80 CHAR), + channel VARCHAR2(80 CHAR), + dstchannel VARCHAR2(80 CHAR), + lastapp VARCHAR2(80 CHAR), + lastdata VARCHAR2(80 CHAR), + "start" DATE, + answer DATE, + end DATE, + duration INTEGER, + billsec INTEGER, + disposition VARCHAR2(45 CHAR), + amaflags VARCHAR2(45 CHAR), + userfield VARCHAR2(256 CHAR), + uniqueid VARCHAR2(150 CHAR), + linkedid VARCHAR2(150 CHAR), + peeraccount VARCHAR2(20 CHAR), + sequence INTEGER +) + +/ + +INSERT INTO alembic_version (version_num) VALUES ('210693f3123d') + +/ + |