"""tiktok_relations

Revision ID: 2f254779e793
Revises: b6083d2a167e
Create Date: 2019-06-28 11:00:40.616533

"""

# revision identifiers, used by Alembic.
revision = '2f254779e793'
down_revision = 'b6083d2a167e'
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('tiktok_tags',
    sa.Column('name', sa.String(), nullable=False),
    sa.Column('last_visited', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('name')
    )
    op.create_table('tiktok_users',
    sa.Column('ttid', sa.String(), nullable=False),
    sa.Column('unique_id', sa.String(), nullable=False),
    sa.Column('signature', sa.String(), nullable=True),
    sa.Column('nickname', sa.String(), nullable=True),
    sa.Column('first_seen', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('last_visited', sa.DateTime(), nullable=True),
    sa.Column('last_follower_count', sa.Integer(), nullable=True),
    sa.Column('last_following_count', sa.Integer(), nullable=True),
    sa.Column('last_heart_count', sa.Integer(), nullable=True),
    sa.PrimaryKeyConstraint('ttid'),
    )
    op.create_table('tiktok_videos',
    sa.Column('ttid', sa.String(), nullable=False),
    sa.Column('author_ttid', sa.String(), nullable=True),
    sa.Column('sound_ttid', sa.String(), nullable=True),
    sa.Column('tags', postgresql.JSONB(none_as_null=True), nullable=True),
    sa.Column('first_seen', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('last_visited', sa.DateTime(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=True),
    sa.Column('caption', sa.String(), nullable=True),
    sa.Column('last_comment_count', sa.Integer(), nullable=True),
    sa.Column('last_share_count', sa.Integer(), nullable=True),
    sa.Column('last_digg_count', sa.Integer(), nullable=True),
    sa.ForeignKeyConstraint(['author_ttid'], ['tiktok_users.ttid'], ),
    sa.ForeignKeyConstraint(['sound_ttid'], ['tiktok_sounds.ttid'], ),
    sa.PrimaryKeyConstraint('ttid')
    )
        ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('tiktok_videos')
    op.drop_table('tiktok_users')
    op.drop_table('tiktok_tags')
    ### end Alembic commands ###