"""Init

Revision ID: 9e4a4117ff62
Revises: 
Create Date: 2016-07-30 13:53:43.513795

"""

# revision identifiers, used by Alembic.
revision = '9e4a4117ff62'
down_revision = None
branch_labels = None
depends_on = None

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

def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_table('data_sources',
    sa.Column('name', sa.String(length=30), nullable=False),
    sa.Column('meta', postgresql.JSONB(), nullable=True),
    sa.PrimaryKeyConstraint('name')
    )
    op.create_table('metric_values',
    sa.Column('eid', sa.Integer(), nullable=False),
    sa.Column('mcode', sa.String(length=16), nullable=False),
    sa.Column('tracked_time', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('value', postgresql.JSONB(), nullable=False),
    sa.PrimaryKeyConstraint('eid', 'mcode', 'tracked_time')
    )
    op.create_table('metrics',
    sa.Column('mcode', sa.String(length=16), nullable=False),
    sa.Column('name', sa.String(), nullable=True),
    sa.PrimaryKeyConstraint('mcode')
    )
    op.create_table('tracked_entities',
    sa.Column('eid', sa.Integer(), nullable=False),
    sa.Column('name', sa.String(), nullable=True),
    sa.Column('first_seen', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('twitter_id', sa.String(), nullable=True),
    sa.Column('soundcloud_id', sa.String(), nullable=True),
    sa.Column('description_data', postgresql.JSONB(), nullable=True),
    sa.Column('is_influencer', sa.Boolean(), server_default=sa.text('false'), nullable=False),
    sa.Column('is_artist', sa.Boolean(), server_default=sa.text('false'), nullable=False),
    sa.Column('is_excluded', sa.Boolean(), server_default=sa.text('false'), nullable=False),
    sa.Column('signing_data', postgresql.JSONB(), nullable=True),
    sa.PrimaryKeyConstraint('eid'),
    sa.UniqueConstraint('soundcloud_id'),
    sa.UniqueConstraint('twitter_id')
    )
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('tracked_entities')
    op.drop_table('metrics')
    op.drop_table('metric_values')
    op.drop_table('data_sources')
    ### end Alembic commands ###