From df75b647da03eba6920020bac0cc950032a1e930 Mon Sep 17 00:00:00 2001 From: Mark Michelson Date: Mon, 17 Oct 2016 14:08:19 -0500 Subject: Update for 13.12.0-rc1 --- contrib/realtime/mssql/mssql_voicemail.sql | 54 ++++++++++++++++++++++++++++++ 1 file changed, 54 insertions(+) create mode 100644 contrib/realtime/mssql/mssql_voicemail.sql (limited to 'contrib/realtime/mssql/mssql_voicemail.sql') diff --git a/contrib/realtime/mssql/mssql_voicemail.sql b/contrib/realtime/mssql/mssql_voicemail.sql new file mode 100644 index 000000000..75cf56ac6 --- /dev/null +++ b/contrib/realtime/mssql/mssql_voicemail.sql @@ -0,0 +1,54 @@ +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 + -- cgit v1.2.3