"""add_lead_note_table

Revision ID: 442b61353cc2
Revises: 179e7a7457f2
Create Date: 2017-01-10 09:07:56.678237

"""

# revision identifiers, used by Alembic.
revision = '442b61353cc2'
down_revision = '179e7a7457f2'
branch_labels = None
depends_on = None

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


def upgrade():
    op.create_table('lead_notes',
                    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('lead_id', sa.INTEGER(),
                              autoincrement=False,
                              nullable=False),
                    sa.Column('phonenumber', sa.VARCHAR(length=20),
                              autoincrement=False, nullable=False),
                    sa.Column('text', sa.TEXT(),
                              server_default="",
                              nullable=False),
                    sa.PrimaryKeyConstraint('id', name=u'lead_notes_pkey'),
                    sa.ForeignKeyConstraint(['user_id'], [u'users.id'],
                                            name=u'lead_notes_user_id_fkey',
                                            onupdate=u'CASCADE',
                                            ondelete=u'CASCADE'),
                    sa.ForeignKeyConstraint(['lead_id'], [u'leads.id'],
                                            name=u'lead_notes_leads_id_fkey',
                                            onupdate=u'CASCADE',
                                            ondelete=u'CASCADE'),
                    sa.Index('lead_note_id_index', 'id', unique=True),
                    sa.Index('lead_phonenumber_index', 'phonenumber'),
                    sa.Index('lead_user_id_index', 'user_id')
                    )


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