"""cm_insta_stat

Revision ID: ac95633efe60
Revises: 40c74dc37bbd
Create Date: 2020-09-21 13:23:48.603470

"""

# revision identifiers, used by Alembic.
revision = 'ac95633efe60'
down_revision = '40c74dc37bbd'
branch_labels = None
depends_on = None

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

def upgrade():
    op.create_table('chart_metric_insta_stats',
    sa.Column('insta_numeric_id', sa.BigInteger(), nullable=False),
    sa.Column('as_of', sa.Date(), nullable=False),
    sa.Column('followers', sa.Integer(), nullable=False),
    sa.PrimaryKeyConstraint('insta_numeric_id', 'as_of')
    )



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