summaryrefslogtreecommitdiff
path: root/contrib/realtime/oracle/oracle_voicemail.sql
diff options
context:
space:
mode:
authorRichard Mudgett <rmudgett@digium.com>2016-12-02 12:04:31 -0600
committerRichard Mudgett <rmudgett@digium.com>2016-12-02 12:05:44 -0600
commit580f83dac713614bd8904f8722a900299ff4f8bc (patch)
tree212c21e5366c1926c30ad07fc19f418141f29be2 /contrib/realtime/oracle/oracle_voicemail.sql
parent8d56016ae475f90b3a5745cfcaa604089e1db659 (diff)
Remove files that got merged in error somehow to the 13 branch.
Change-Id: Id79e2226c31084f9252d5aede9050d3cf13322c8
Diffstat (limited to 'contrib/realtime/oracle/oracle_voicemail.sql')
-rw-r--r--contrib/realtime/oracle/oracle_voicemail.sql48
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'
-
-/
-