diff options
Diffstat (limited to 'contrib/realtime/oracle/oracle_voicemail.sql')
-rw-r--r-- | contrib/realtime/oracle/oracle_voicemail.sql | 48 |
1 files changed, 0 insertions, 48 deletions
diff --git a/contrib/realtime/oracle/oracle_voicemail.sql b/contrib/realtime/oracle/oracle_voicemail.sql deleted file mode 100644 index 12133ea8c..000000000 --- a/contrib/realtime/oracle/oracle_voicemail.sql +++ /dev/null @@ -1,48 +0,0 @@ -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' - -/ - |