"""add phonenumber table

Revision ID: 2f02917e6
Revises: 2902eb1fbe4b
Create Date: 2016-01-19 16:34:51.931992

"""

# revision identifiers, used by Alembic.
revision = '2f02917e6'
down_revision = '2902eb1fbe4b'
branch_labels = None
depends_on = None

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


def upgrade():
    op.create_table('phonenumbers',
                    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('user_id', sa.INTEGER(),
                              autoincrement=False,
                              nullable=False),
                    sa.Column('phonenumber', sa.VARCHAR(length=20),
                              autoincrement=False, nullable=False),
                    sa.Column('is_local', sa.BOOLEAN(),
                              nullable=False),
                    sa.Column('is_tollfree', sa.BOOLEAN(),
                              nullable=False),

                    sa.PrimaryKeyConstraint('id', name=u'phonenumber_pkey'),
                    sa.ForeignKeyConstraint(['user_id'], [u'users.id'],
                                            name=u'phonenumber_user_id_fkey',
                                            onupdate=u'CASCADE',
                                            ondelete=u'CASCADE'),
                    sa.Index('phonenumber_id_index', 'id', unique=True)
                    )


def downgrade():
    op.drop_table('phonenumbers')
    op.drop_index('phonenumber_id_index')