alembic: Remove batch operations (and sqlite support)
[asterisk/asterisk.git] / contrib / ast-db-manage / config / versions / 1c688d9a003c_pjsip_voicemail_extension.py
1 """pjsip voicemail extension
2
3 Revision ID: 1c688d9a003c
4 Revises: 5813202e92be
5 Create Date: 2016-03-24 22:31:45.537895
6
7 """
8
9 # revision identifiers, used by Alembic.
10 revision = '1c688d9a003c'
11 down_revision = '5813202e92be'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
17 def upgrade():
18     op.add_column('ps_globals', sa.Column('default_voicemail_extension', sa.String(40)))
19     op.add_column('ps_aors', sa.Column('voicemail_extension', sa.String(40)))
20     op.add_column('ps_endpoints', sa.Column('voicemail_extension', sa.String(40)))
21     op.add_column('ps_endpoints', sa.Column('mwi_subscribe_replaces_unsolicited', sa.Integer))
22
23
24 def downgrade():
25     op.drop_column('ps_globals', 'default_voicemail_extension')
26     op.drop_column('ps_aors', 'voicemail_extension')
27     op.drop_column('ps_endpoints', 'voicemail_extension')
28     op.drop_column('ps_endpoints', 'mwi_subscribe_replaces_unsolicited')