"""Add caller id column to phonenumbers table

Revision ID: 573236b1a626
Revises: 3ae25604b68c
Create Date: 2017-03-21 09:08:48.080043

"""

# revision identifiers, used by Alembic.
revision = '573236b1a626'
down_revision = '3ae25604b68c'
branch_labels = None
depends_on = None

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


def upgrade():
    op.add_column('phonenumbers', sa.Column('is_callerid',
                                     sa.Boolean(),
                                     nullable=False,
                                     server_default='1')),


def downgrade():
    op.drop_column('phonenumbers', 'is_callerid'),