"""removed Line Staff Account as it is unused.

Revision ID: 0b69e8396630
Revises: 4eed9877f681
Create Date: 2020-01-03 16:11:35.963009

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '0b69e8396630'
down_revision = '4eed9877f681'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('staff_line_account')
    op.add_column('staff_account', sa.Column('line_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_staff_account_line_id'), 'staff_account', ['line_id'], unique=True)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_staff_account_line_id'), table_name='staff_account')
    op.drop_column('staff_account', 'line_id')
    op.create_table('staff_line_account',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('staff_account_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('line_id', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('picture_url', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('display_name', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['staff_account_id'], [u'staff_account.id'], name=u'staff_line_account_staff_account_id_fkey'),
    sa.PrimaryKeyConstraint('id', name=u'staff_line_account_pkey')
    )
    # ### end Alembic commands ###

ca420c24ed5527d4d6841462254e5589419c7291
<mask token>


def upgrade():
    op.drop_table('staff_line_account')
    op.add_column('staff_account', sa.Column('line_id', sa.String(),
        nullable=True))
    op.create_index(op.f('ix_staff_account_line_id'), 'staff_account', [
        'line_id'], unique=True)


<mask token>

<mask token>


def upgrade():
    op.drop_table('staff_line_account')
    op.add_column('staff_account', sa.Column('line_id', sa.String(),
        nullable=True))
    op.create_index(op.f('ix_staff_account_line_id'), 'staff_account', [
        'line_id'], unique=True)


def downgrade():
    op.drop_index(op.f('ix_staff_account_line_id'), table_name='staff_account')
    op.drop_column('staff_account', 'line_id')
    op.create_table('staff_line_account', sa.Column('id', sa.INTEGER(),
        nullable=False), sa.Column('staff_account_id', sa.INTEGER(),
        autoincrement=False, nullable=True), sa.Column('line_id', sa.
        VARCHAR(), autoincrement=False, nullable=False), sa.Column(
        'picture_url', sa.VARCHAR(), autoincrement=False, nullable=True),
        sa.Column('display_name', sa.VARCHAR(), autoincrement=False,
        nullable=True), sa.ForeignKeyConstraint(['staff_account_id'], [
        u'staff_account.id'], name=
        u'staff_line_account_staff_account_id_fkey'), sa.
        PrimaryKeyConstraint('id', name=u'staff_line_account_pkey'))

<mask token>
revision = '0b69e8396630'
down_revision = '4eed9877f681'
branch_labels = None
depends_on = None


def upgrade():
    op.drop_table('staff_line_account')
    op.add_column('staff_account', sa.Column('line_id', sa.String(),
        nullable=True))
    op.create_index(op.f('ix_staff_account_line_id'), 'staff_account', [
        'line_id'], unique=True)


def downgrade():
    op.drop_index(op.f('ix_staff_account_line_id'), table_name='staff_account')
    op.drop_column('staff_account', 'line_id')
    op.create_table('staff_line_account', sa.Column('id', sa.INTEGER(),
        nullable=False), sa.Column('staff_account_id', sa.INTEGER(),
        autoincrement=False, nullable=True), sa.Column('line_id', sa.
        VARCHAR(), autoincrement=False, nullable=False), sa.Column(
        'picture_url', sa.VARCHAR(), autoincrement=False, nullable=True),
        sa.Column('display_name', sa.VARCHAR(), autoincrement=False,
        nullable=True), sa.ForeignKeyConstraint(['staff_account_id'], [
        u'staff_account.id'], name=
        u'staff_line_account_staff_account_id_fkey'), sa.
        PrimaryKeyConstraint('id', name=u'staff_line_account_pkey'))

<mask token>
from alembic import op
import sqlalchemy as sa
revision = '0b69e8396630'
down_revision = '4eed9877f681'
branch_labels = None
depends_on = None


def upgrade():
    op.drop_table('staff_line_account')
    op.add_column('staff_account', sa.Column('line_id', sa.String(),
        nullable=True))
    op.create_index(op.f('ix_staff_account_line_id'), 'staff_account', [
        'line_id'], unique=True)


def downgrade():
    op.drop_index(op.f('ix_staff_account_line_id'), table_name='staff_account')
    op.drop_column('staff_account', 'line_id')
    op.create_table('staff_line_account', sa.Column('id', sa.INTEGER(),
        nullable=False), sa.Column('staff_account_id', sa.INTEGER(),
        autoincrement=False, nullable=True), sa.Column('line_id', sa.
        VARCHAR(), autoincrement=False, nullable=False), sa.Column(
        'picture_url', sa.VARCHAR(), autoincrement=False, nullable=True),
        sa.Column('display_name', sa.VARCHAR(), autoincrement=False,
        nullable=True), sa.ForeignKeyConstraint(['staff_account_id'], [
        u'staff_account.id'], name=
        u'staff_line_account_staff_account_id_fkey'), sa.
        PrimaryKeyConstraint('id', name=u'staff_line_account_pkey'))

"""removed Line Staff Account as it is unused.

Revision ID: 0b69e8396630
Revises: 4eed9877f681
Create Date: 2020-01-03 16:11:35.963009

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '0b69e8396630'
down_revision = '4eed9877f681'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('staff_line_account')
    op.add_column('staff_account', sa.Column('line_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_staff_account_line_id'), 'staff_account', ['line_id'], unique=True)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_staff_account_line_id'), table_name='staff_account')
    op.drop_column('staff_account', 'line_id')
    op.create_table('staff_line_account',
    sa.Column('id', sa.INTEGER(), nullable=False),
    sa.Column('staff_account_id', sa.INTEGER(), autoincrement=False, nullable=True),
    sa.Column('line_id', sa.VARCHAR(), autoincrement=False, nullable=False),
    sa.Column('picture_url', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.Column('display_name', sa.VARCHAR(), autoincrement=False, nullable=True),
    sa.ForeignKeyConstraint(['staff_account_id'], [u'staff_account.id'], name=u'staff_line_account_staff_account_id_fkey'),
    sa.PrimaryKeyConstraint('id', name=u'staff_line_account_pkey')
    )
    # ### end Alembic commands ###
