"""Add audio_url tables

Revision ID: 973fd190104
Revises: 53e65f86b2fd
Create Date: 2017-02-14 08:00:18.176364

"""

# revision identifiers, used by Alembic.
revision = '973fd190104'
down_revision = '53e65f86b2fd'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql


def upgrade():
    op.create_table('audio_urls',
                    sa.Column('created_on',
                              postgresql.TIMESTAMP(timezone=True),
                              autoincrement=False, nullable=True),
                    sa.Column('updated_on',
                              postgresql.TIMESTAMP(timezone=True),
                              autoincrement=False, nullable=True),
                    sa.Column('id', sa.INTEGER(), nullable=False),
                    sa.Column('inbound_id', sa.INTEGER(),
                              autoincrement=False,
                              nullable=True),
                    sa.Column('widget_guid', sa.VARCHAR(length=128),
                              autoincrement=False,
                              nullable=True),
                    sa.Column('whisper_message_type', sa.VARCHAR(length=128),
                              autoincrement=False,
                              nullable=False),
                    sa.Column('audio_url', sa.VARCHAR(length=256),
                              autoincrement=False,
                              nullable=False),
                    sa.Column('is_enabled', sa.Boolean(),
                              nullable=False,
                              server_default='f'),
                    sa.PrimaryKeyConstraint('id', name=u'audio_url_pkey'),
                    sa.Index('audio_url_index', 'id', unique=True)
                    )


def downgrade():
    op.drop_table('audio_urls')