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_voicemail.sql | |
parent | 546ec4b038ac3d750c5138d7fbb8e3ce93f482df (diff) |
Update for 13.12.0-rc113.12.0-rc1
Diffstat (limited to 'contrib/realtime/oracle/oracle_voicemail.sql')
-rw-r--r-- | contrib/realtime/oracle/oracle_voicemail.sql | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/contrib/realtime/oracle/oracle_voicemail.sql b/contrib/realtime/oracle/oracle_voicemail.sql new file mode 100644 index 000000000..12133ea8c --- /dev/null +++ b/contrib/realtime/oracle/oracle_voicemail.sql @@ -0,0 +1,48 @@ +CREATE TABLE alembic_version ( + version_num VARCHAR2(32 CHAR) NOT NULL +) + +/ + +-- Running upgrade -> a2e9769475e + +CREATE TABLE voicemail_messages ( + dir VARCHAR2(255 CHAR) NOT NULL, + msgnum INTEGER NOT NULL, + context VARCHAR2(80 CHAR), + macrocontext VARCHAR2(80 CHAR), + callerid VARCHAR2(80 CHAR), + origtime INTEGER, + duration INTEGER, + recording BLOB, + flag VARCHAR2(30 CHAR), + category VARCHAR2(30 CHAR), + mailboxuser VARCHAR2(30 CHAR), + mailboxcontext VARCHAR2(30 CHAR), + msg_id VARCHAR2(40 CHAR) +) + +/ + +ALTER TABLE voicemail_messages ADD CONSTRAINT voicemail_messages_dir_msgnum PRIMARY KEY (dir, msgnum) + +/ + +CREATE INDEX voicemail_messages_dir ON voicemail_messages (dir) + +/ + +INSERT INTO alembic_version (version_num) VALUES ('a2e9769475e') + +/ + +-- Running upgrade a2e9769475e -> 39428242f7f5 + +ALTER TABLE voicemail_messages MODIFY recording BLOB + +/ + +UPDATE alembic_version SET version_num='39428242f7f5' WHERE alembic_version.version_num = 'a2e9769475e' + +/ + |