"""bigint_last_heart_count

Revision ID: 2808ec2d3193
Revises: 73df31b6963d
Create Date: 2020-05-05 14:37:27.189497

"""

# revision identifiers, used by Alembic.
revision = '2808ec2d3193'
down_revision = '73df31b6963d'
branch_labels = None
depends_on = None

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

# create table tiktok_users
# (
# 	ttid varchar not null
# 		constraint tiktok_users_pkey
# 			primary key,
# 	unique_id varchar not null,
# 	signature varchar,
# 	nickname varchar,
# 	first_seen timestamp default CURRENT_TIMESTAMP not null,
# 	last_visited timestamp,
# 	last_follower_count integer,
# 	last_following_count integer,
# 	last_heart_count integer,
# 	is_influencer boolean default false not null,
# 	cover_image_url varchar,
# 	active boolean default true not null
# );
#
# alter table tiktok_users owner to bot;
#
# create index ix_tiktok_users_unique_id
# 	on tiktok_users (unique_id);
#


def upgrade():
    op.execute('alter table tiktok_users alter column last_heart_count type bigint')
    op.execute('alter table tiktok_users alter column last_follower_count type bigint')


def downgrade():
    op.execute('alter table tiktok_users alter column last_heart_count type int')
    op.execute('alter table tiktok_users alter column last_follower_count type int')