summaryrefslogtreecommitdiff
path: root/contrib/realtime/mysql/voicemail_data.sql
diff options
context:
space:
mode:
authorMatthew Jordan <mjordan@digium.com>2013-08-28 20:55:53 +0000
committerMatthew Jordan <mjordan@digium.com>2013-08-28 20:55:53 +0000
commit629f43d2b637b8515939097fa8e89fd42df4fa23 (patch)
treeda957fa2e7f771577dbf675c7280a4ccd6c0f407 /contrib/realtime/mysql/voicemail_data.sql
parentb7ec25ec2e98e5e4bb26edacb855602541e30b7f (diff)
Add database schema management using Alembic
This patch replaces contrib/realtime/ with a new setup for managing the database schema required for database integration with Asterisk. In addition to initializing a database with the proper schema, alembic can do a database migration to assist with upgrading Asterisk in the future. Hopefully this helps make setting up and operating Asterisk with a database easier. With this the schema only needs to be maintained in one place instead of once per database. The schemas I have added here have a bit of improvement over the examples that were there before (some added consistency and added some missing indexes). Managing the schema in one place here also applies to all databases supported by SQLAlchemy. See contrib/ast-db-manage/README.md for more details. Review: https://reviewboard.asterisk.org/r/2731 patch by Russell Bryant (license 6300) ........ Merged revisions 397874 from http://svn.asterisk.org/svn/asterisk/branches/12 git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@397875 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/realtime/mysql/voicemail_data.sql')
-rw-r--r--contrib/realtime/mysql/voicemail_data.sql29
1 files changed, 0 insertions, 29 deletions
diff --git a/contrib/realtime/mysql/voicemail_data.sql b/contrib/realtime/mysql/voicemail_data.sql
index 743bd4492..e69de29bb 100644
--- a/contrib/realtime/mysql/voicemail_data.sql
+++ b/contrib/realtime/mysql/voicemail_data.sql
@@ -1,29 +0,0 @@
-DROP TABLE IF EXISTS voicemail_data;
-CREATE TABLE voicemail_data (
- -- Path to the recording
- filename CHAR(255) NOT NULL PRIMARY KEY,
- -- Mailbox number (without context)
- origmailbox CHAR(80),
- -- Dialplan context
- context CHAR(80),
- -- Dialplan context, if voicemail was invoked from a macro
- macrocontext CHAR(80),
- -- Dialplan extension
- exten CHAR(80),
- -- Dialplan priority
- priority INT(5),
- -- Name of the channel, when message was left
- callerchan CHAR(80),
- -- CallerID on the channel, when message was left
- callerid CHAR(80),
- -- Contrary to the name, origdate is a full datetime, in localized format
- origdate CHAR(30),
- -- Same date as origdate, but in Unixtime
- origtime INT(11),
- -- Value of the channel variable VM_CATEGORY, if set
- category CHAR(30),
- -- Length of the message, in seconds
- duration INT(11)
-);
-
-