| 123456789101112131415161718192021222324252627282930313233 |
- """remove telegram verification
- Revision ID: 9524fe8e91f0
- Revises: 97d0cf5e4bb0
- Create Date: 2020-02-11 00:03:26.671954
- """
- from alembic import op
- import sqlalchemy as sa
- from sqlalchemy.dialects import postgresql
- # revision identifiers, used by Alembic.
- revision = '9524fe8e91f0'
- down_revision = '97d0cf5e4bb0'
- branch_labels = None
- depends_on = None
- def upgrade():
- op.drop_table('telegram_verification')
- def downgrade():
- op.create_table('telegram_verification',
- sa.Column('player_id', sa.BIGINT(), autoincrement=False, nullable=False),
- sa.Column('telegram_id', sa.BIGINT(), autoincrement=False, nullable=False),
- sa.Column('code', sa.VARCHAR(), autoincrement=False, nullable=True),
- sa.Column('date_time', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
- sa.Column('confirmed', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=True),
- sa.ForeignKeyConstraint(['player_id'], ['player.id'], name='fk_telegram_verification_player_id_player'),
- sa.ForeignKeyConstraint(['telegram_id'], ['telegram_account.id'], name='fk_telegram_verification_telegram_id_telegram_account'),
- sa.PrimaryKeyConstraint('player_id', 'telegram_id', name='pk_telegram_verification')
- )
|
