"""Add agents table

Revision ID: 3fc9915f0c3c
Revises: 25f82595b715
Create Date: 2015-11-17 18:41:35.059670

"""

# revision identifiers, used by Alembic.
revision = '3fc9915f0c3c'
down_revision = '450b127cfd47'
branch_labels = None
depends_on = None

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


def upgrade():
    op.create_table('agents',
                    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('firstname', sa.VARCHAR(length=128),
                              autoincrement=False,
                              nullable=False),
                    sa.Column('lastname', sa.VARCHAR(length=128),
                              autoincrement=False,
                              nullable=False),
                    sa.Column('title', sa.VARCHAR(length=128),
                              autoincrement=False,
                              nullable=True),
                    sa.Column('email', sa.VARCHAR(length=254),
                              autoincrement=False,
                              nullable=False),
                    sa.Column('phonenumber', sa.VARCHAR(length=20),
                              autoincrement=False, nullable=False),
                    sa.Column('extension', sa.INTEGER(),
                              autoincrement=False,
                              nullable=True),
                    sa.Column('department', sa.VARCHAR(length=64),
                              autoincrement=False,
                              nullable=False),
                    sa.PrimaryKeyConstraint('id', name=u'agents_pkey'),
                    sa.ForeignKeyConstraint(['user_id'], [u'users.id'],
                                            name=u'agents_user_id_fkey',
                                            onupdate=u'CASCADE',
                                            ondelete=u'CASCADE'),
                    sa.Index('agent_id_index', 'id', unique=True),
                    sa.Index('agent_user_id_index', 'user_id')
                    )

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