"""Added Reports table

Revision ID: 4765d4cf656b
Revises: 0f2e4322d649
Create Date: 2016-08-30 17:44:40.988641

"""

# revision identifiers, used by Alembic.
revision = '4765d4cf656b'
down_revision = '0f2e4322d649'
branch_labels = None
depends_on = None

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


def upgrade():
    op.create_table('reports',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('name', sa.VARCHAR(length=255), autoincrement=False, nullable=True),
    sa.PrimaryKeyConstraint('id', name=u'reports_pkey'),
    )

    op.create_table('report_user_tie',
    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('user_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('report_id', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'reports_user_tie_user_id_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'),
    sa.ForeignKeyConstraint(['report_id'], [u'reports.id'], name=u'reports_user_tie_report_id_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'),
    )
    op.create_primary_key(
        "pk_user_reports", "report_user_tie",
        ["user_id", "report_id"]
    )


def downgrade():
    op.drop_table('report_user_tie')
    op.drop_table('reports')