summaryrefslogtreecommitdiff
path: root/contrib/realtime/mssql/mssql_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/mssql/mssql_voicemail.sql
parent8d56016ae475f90b3a5745cfcaa604089e1db659 (diff)
Remove files that got merged in error somehow to the 13 branch.
Change-Id: Id79e2226c31084f9252d5aede9050d3cf13322c8
Diffstat (limited to 'contrib/realtime/mssql/mssql_voicemail.sql')
-rw-r--r--contrib/realtime/mssql/mssql_voicemail.sql54
1 files changed, 0 insertions, 54 deletions
diff --git a/contrib/realtime/mssql/mssql_voicemail.sql b/contrib/realtime/mssql/mssql_voicemail.sql
deleted file mode 100644
index 75cf56ac6..000000000
--- a/contrib/realtime/mssql/mssql_voicemail.sql
+++ /dev/null
@@ -1,54 +0,0 @@
-BEGIN TRANSACTION;
-
-CREATE TABLE alembic_version (
- version_num VARCHAR(32) NOT NULL
-);
-
-GO
-
--- Running upgrade -> a2e9769475e
-
-CREATE TABLE voicemail_messages (
- dir VARCHAR(255) NOT NULL,
- msgnum INTEGER NOT NULL,
- context VARCHAR(80) NULL,
- macrocontext VARCHAR(80) NULL,
- callerid VARCHAR(80) NULL,
- origtime INTEGER NULL,
- duration INTEGER NULL,
- recording IMAGE NULL,
- flag VARCHAR(30) NULL,
- category VARCHAR(30) NULL,
- mailboxuser VARCHAR(30) NULL,
- mailboxcontext VARCHAR(30) NULL,
- msg_id VARCHAR(40) NULL
-);
-
-GO
-
-ALTER TABLE voicemail_messages ADD CONSTRAINT voicemail_messages_dir_msgnum PRIMARY KEY (dir, msgnum);
-
-GO
-
-CREATE INDEX voicemail_messages_dir ON voicemail_messages (dir);
-
-GO
-
-INSERT INTO alembic_version (version_num) VALUES ('a2e9769475e');
-
-GO
-
--- Running upgrade a2e9769475e -> 39428242f7f5
-
-ALTER TABLE voicemail_messages ALTER COLUMN recording IMAGE;
-
-GO
-
-UPDATE alembic_version SET version_num='39428242f7f5' WHERE alembic_version.version_num = 'a2e9769475e';
-
-GO
-
-COMMIT;
-
-GO
-