a2e9769475e_create_tables.py

Go to the documentation of this file.
00001 #
00002 # Asterisk -- An open source telephony toolkit.
00003 #
00004 # Copyright (C) 2013, Russell Bryant
00005 #
00006 # Russell Bryant <russell@rusellbryant.net>
00007 #
00008 # See http://www.asterisk.org for more information about
00009 # the Asterisk project. Please do not directly contact
00010 # any of the maintainers of this project for assistance;
00011 # the project provides a web site, mailing lists and IRC
00012 # channels for your use.
00013 #
00014 # This program is free software, distributed under the terms of
00015 # the GNU General Public License Version 2. See the LICENSE file
00016 # at the top of the source tree.
00017 #
00018 
00019 """Create tables
00020 
00021 Revision ID: a2e9769475e
00022 Revises: None
00023 Create Date: 2013-07-29 23:43:09.431668
00024 
00025 """
00026 
00027 # revision identifiers, used by Alembic.
00028 revision = 'a2e9769475e'
00029 down_revision = None
00030 
00031 from alembic import op
00032 import sqlalchemy as sa
00033 
00034 
00035 def upgrade():
00036     op.create_table(
00037         'voicemail_messages',
00038         sa.Column('dir', sa.String(255), nullable=False),
00039         sa.Column('msgnum', sa.Integer, nullable=False),
00040         sa.Column('context', sa.String(80)),
00041         sa.Column('macrocontext', sa.String(80)),
00042         sa.Column('callerid', sa.String(80)),
00043         sa.Column('origtime', sa.Integer),
00044         sa.Column('duration', sa.Integer),
00045         sa.Column('recording', sa.LargeBinary),
00046         sa.Column('flag', sa.String(30)),
00047         sa.Column('category', sa.String(30)),
00048         sa.Column('mailboxuser', sa.String(30)),
00049         sa.Column('mailboxcontext', sa.String(30)),
00050         sa.Column('msg_id', sa.String(40))
00051     )
00052     op.create_primary_key('voicemail_messages_dir_msgnum',
00053             'voicemail_messages', ['dir', 'msgnum'])
00054     op.create_index('voicemail_messages_dir', 'voicemail_messages', ['dir'])
00055 
00056 
00057 def downgrade():
00058     op.drop_table('voicemail_messages')

Generated on Thu Apr 16 06:27:05 2015 for Asterisk - The Open Source Telephony Project by  doxygen 1.5.6