def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('fiets',
sa.Column('Datum_verwijderd', sa.DATE(), nullable=True))
op.add_column(
'fiets',
sa.Column('aangepast_door',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True))
op.create_foreign_key('fiets_ibfk_2', 'fiets', 'user', ['aangepast_door'],
['id'])
op.drop_table('verwijderd')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'question',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('title', sa.String(length=100), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('create_time', sa.DATE(), nullable=True),
sa.Column('author_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['author_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('conditioning',
sa.Column('workout_id', sa.Integer(), nullable=True))
op.create_foreign_key(None, 'conditioning', 'workout', ['workout_id'],
['id'])
op.drop_column('conditioning', 'workout')
op.drop_column('result', 'description')
op.alter_column('session',
'account_id',
existing_type=sa.INTEGER(),
nullable=False)
op.alter_column('session', 'date', existing_type=sa.DATE(), nullable=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'comments',
sa.Column('date_created',
sa.DATE(),
autoincrement=False,
nullable=True))
op.create_index('ix_comments_date_created',
'comments', ['date_created'],
unique=False)
op.drop_index(op.f('ix_comments_timestamp'), table_name='comments')
op.drop_column('comments', 'timestamp')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column("user", "last_update")
op.add_column(
"poll",
sa.Column(
"current_date",
sa.DATE(),
server_default=sa.text("now()"),
autoincrement=False,
nullable=False,
),
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'highscore',
sa.Column('date', sa.DATE(), autoincrement=False, nullable=True))
op.add_column(
'highscore',
sa.Column('total', sa.INTEGER(), autoincrement=False, nullable=True))
op.drop_column('highscore', 'rebounds')
op.drop_column('highscore', 'ppg')
op.drop_column('highscore', 'picture_url')
op.drop_column('highscore', 'per')
op.drop_column('highscore', 'assists')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'Venue', type_='unique')
op.drop_constraint(None, 'Venue', type_='unique')
op.drop_constraint(None, 'Venue', type_='unique')
op.drop_constraint(None, 'Venue', type_='unique')
op.alter_column('Venue', 'name',
existing_type=sa.VARCHAR(),
nullable=True)
op.add_column('Show', sa.Column('end_date', sa.DATE(), autoincrement=False, nullable=True))
op.alter_column('Show', 'venue_id',
existing_type=sa.INTEGER(),
nullable=True)
op.alter_column('Show', 'start_date',
existing_type=sa.DATE(),
nullable=True)
op.alter_column('Show', 'artist_id',
existing_type=sa.INTEGER(),
nullable=True)
op.alter_column('Artist', 'name',
existing_type=sa.VARCHAR(),
nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('giftee', schema=None) as batch_op:
batch_op.add_column(
sa.Column('test',
sa.VARCHAR(length=120),
autoincrement=False,
nullable=True))
batch_op.add_column(
sa.Column('send_gift_date',
sa.DATE(),
autoincrement=False,
nullable=True))
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('username', sa.String(), nullable=False))
op.alter_column('user', 'geb', existing_type=sa.DATE(), nullable=False)
op.alter_column('user',
'nachname',
existing_type=sa.VARCHAR(length=32),
nullable=False)
op.alter_column('user',
'vorname',
existing_type=sa.VARCHAR(length=32),
nullable=False)
op.create_unique_constraint(None, 'user', ['username'])
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'user', type_='unique')
op.alter_column('user',
'vorname',
existing_type=sa.VARCHAR(length=32),
nullable=True)
op.alter_column('user',
'nachname',
existing_type=sa.VARCHAR(length=32),
nullable=True)
op.alter_column('user', 'geb', existing_type=sa.DATE(), nullable=True)
op.drop_column('user', 'username')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'blacklist',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('party_id', mysql.TEXT(), nullable=True),
sa.Column('created_at', mysql.DATETIME(), nullable=True),
sa.Column('until', sa.DATE(), nullable=True),
sa.Column('party_name', mysql.CHAR(length=20), nullable=True),
sa.Column('kind', mysql.CHAR(length=10), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'oauth_apple',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('party_id', mysql.CHAR(length=80), nullable=False),
sa.Column('party_name', mysql.TEXT(), nullable=False),
sa.Column('party_email', mysql.TEXT(), nullable=True),
sa.Column('party_picture', mysql.TEXT(), nullable=True),
sa.Column('refresh_token', mysql.TEXT(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('party_id'))
op.create_table(
'oauth_facebook',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('party_id', mysql.CHAR(length=50), nullable=False),
sa.Column('party_name', mysql.TEXT(), nullable=False),
sa.Column('party_picture', mysql.TEXT(), nullable=True),
sa.Column('party_email', mysql.TEXT(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('party_id'))
op.create_table(
'oauth_google',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('party_id', mysql.CHAR(length=50), nullable=False),
sa.Column('party_name', mysql.TEXT(), nullable=False),
sa.Column('party_email', mysql.TEXT(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('party_id'))
op.create_table(
'oauth_kakao',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('party_id', mysql.CHAR(length=50), nullable=False),
sa.Column('party_name', mysql.TEXT(), nullable=False),
sa.Column('party_email', mysql.TEXT(), nullable=True),
sa.Column('party_picture', mysql.TEXT(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('party_id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('users',
sa.Column('Username',
mysql.VARCHAR(length=50),
nullable=False),
sa.Column('Password',
mysql.VARCHAR(length=45),
nullable=False),
sa.Column('Email',
mysql.VARCHAR(length=45),
nullable=False),
sa.Column('Avatar',
mysql.VARCHAR(length=200),
nullable=True),
sa.PrimaryKeyConstraint('Username'),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
op.create_table('payment',
sa.Column('username',
mysql.VARCHAR(length=100),
nullable=False),
sa.Column('creditc',
mysql.VARCHAR(length=45),
nullable=False),
sa.Column('exdate', sa.DATE(), nullable=False),
sa.ForeignKeyConstraint(['username'], ['users.Username'],
name='payment_ibfk_1'),
sa.PrimaryKeyConstraint('username'),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
op.create_table('lobbies',
sa.Column('id',
mysql.INTEGER(display_width=11),
nullable=False),
sa.Column('type', mysql.VARCHAR(length=45),
nullable=False),
sa.Column('buyin',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.Column('maxbuyin',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.Column('owner',
mysql.VARCHAR(length=100),
nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'statement_settings',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('frequency', sa.String(length=50), nullable=True),
sa.Column('payment_account_id', sa.Integer(), nullable=True),
sa.Column('from_date', sa.Date(), nullable=False),
sa.Column('to_date', sa.Date(), nullable=False),
sa.ForeignKeyConstraint(
['payment_account_id'],
['payment_account.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_statement_settings_frequency'),
'statement_settings', ['frequency'],
unique=False)
op.create_index(op.f('ix_statement_settings_payment_account_id'),
'statement_settings', ['payment_account_id'],
unique=False)
op.add_column('statement',
sa.Column('created_on', sa.Date(), nullable=False))
op.add_column(
'statement',
sa.Column('statement_settings_id', sa.Integer(), nullable=True))
op.alter_column('statement',
'to_date',
existing_type=sa.DATE(),
nullable=False)
op.create_index(op.f('ix_statement_statement_settings_id'),
'statement', ['statement_settings_id'],
unique=False)
op.drop_index('ix_statement_payment_account_id', table_name='statement')
op.drop_index('ix_statement_status', table_name='statement')
op.drop_constraint('statement_payment_account_id_fkey',
'statement',
type_='foreignkey')
op.create_foreign_key(None, 'statement', 'statement_settings',
['statement_settings_id'], ['id'])
op.drop_column('statement', 'status')
op.drop_column('statement', 'payment_account_id')
op.add_column('statement_invoices',
sa.Column('invoice_id', sa.Integer(), nullable=False))
op.drop_index('ix_statement_invoices_status',
table_name='statement_invoices')
op.drop_constraint('statement_invoices_inovice_id_fkey',
'statement_invoices',
type_='foreignkey')
op.create_foreign_key(None, 'statement_invoices', 'invoice',
['invoice_id'], ['id'])
op.drop_column('statement_invoices', 'status')
op.drop_column('statement_invoices', 'inovice_id')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'article', type_='unique')
op.alter_column('article', 'url',
existing_type=sa.VARCHAR(),
nullable=True,
comment=None,
existing_comment='Адрес страницы')
op.alter_column('article', 'updated_at',
existing_type=sa.DATE(),
comment=None,
existing_comment='',
existing_nullable=True)
op.alter_column('article', 'headline',
existing_type=sa.VARCHAR(),
comment=None,
existing_comment='Заголовок статьи',
existing_nullable=True)
op.alter_column('article', 'date_published',
existing_type=sa.DATE(),
comment=None,
existing_comment='Дата обновления статьи',
existing_nullable=True)
op.alter_column('article', 'created_at',
existing_type=sa.DATE(),
comment=None,
existing_comment='',
existing_nullable=True)
op.alter_column('article', 'category',
existing_type=sa.VARCHAR(),
comment=None,
existing_comment='Категория статьи',
existing_nullable=True)
op.alter_column('article', 'body',
existing_type=sa.VARCHAR(),
comment=None,
existing_comment='Текст статьи',
existing_nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'material_forecasts',
sa.Column('plan_date',
postgresql.TIMESTAMP(timezone=True),
autoincrement=False,
nullable=True))
op.add_column(
'material_forecasts',
sa.Column('from_regular_consumption',
sa.BOOLEAN(),
autoincrement=False,
nullable=True))
op.drop_column('material_forecasts', 'type')
op.create_table(
'planing_period_templates',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('start_date', sa.DATE(), autoincrement=False, nullable=True),
sa.Column('end_date', sa.DATE(), autoincrement=False, nullable=True),
sa.Column('week_no', sa.SMALLINT(), autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('id', name='planing_period_templates_pkey'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('ChucDanhCongTac', sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True))
op.add_column('ChucDanhCongTac', sa.Column('Chuc_Danh_Cong_Tac_id', sa.SMALLINT(), autoincrement=False, nullable=True))
op.add_column('ChucDanhCongTac', sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True))
op.create_foreign_key('FK__ChucDanhC__user___0B91BA14', 'ChucDanhCongTac', 'User', ['user_id'], ['id'])
op.create_foreign_key('FK__ChucDanhC__Chuc___0C85DE4D', 'ChucDanhCongTac', 'Dm_ChucDanhCongTac', ['Chuc_Danh_Cong_Tac_id'], ['id'])
op.drop_column('ChucDanhCongTac', 'ten')
op.create_table('Dm_ChucDanhCongTac',
sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1),
sa.Column('ten', sa.NVARCHAR(length=100), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='PK__Dm_ChucD__3213E83F9C8A3A7C')
)
op.drop_table('ChucDanhCongTacUser')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('seance',
'time',
existing_type=postgresql.TIME(),
nullable=True)
op.alter_column('seance', 'date', existing_type=sa.DATE(), nullable=True)
op.add_column(
'movie',
sa.Column('availability',
sa.BOOLEAN(),
autoincrement=False,
nullable=True))
op.drop_column('movie', 'close_date')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('classify',
sa.Column('id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('uuid', mysql.VARCHAR(length=36), nullable=False),
sa.Column('name', mysql.VARCHAR(length=10), nullable=True),
sa.Column('create_time', sa.DATE(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_index('uuid', 'classify', ['uuid'], unique=True)
op.create_index('name', 'classify', ['name'], unique=True)
op.create_index('ix_classify_create_time', 'classify', ['create_time'], unique=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_foreign_key(None, 'workout', 'result', ['id'], ['id'])
op.alter_column('session', 'date', existing_type=sa.DATE(), nullable=True)
op.alter_column('session',
'account_id',
existing_type=sa.INTEGER(),
nullable=True)
op.add_column(
'result',
sa.Column('description', sa.VARCHAR(length=144), nullable=True))
op.add_column('conditioning',
sa.Column('workout', sa.VARCHAR(), nullable=False))
op.drop_constraint(None, 'conditioning', type_='foreignkey')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('stock_transaction',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('date', sa.DATE(), nullable=True),
sa.Column('symbol', sa.VARCHAR(length=60), nullable=True),
sa.Column('quantity', sa.FLOAT(), nullable=True),
sa.Column('price_per_share', sa.FLOAT(), nullable=True),
sa.Column('transaction_fee', sa.FLOAT(), nullable=True),
sa.Column('transaction_type', sa.VARCHAR(length=60), nullable=True),
sa.Column('user_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
def downgrade():
try:
op.drop_table("crawl_job")
except sa.exc.OperationalError:
pass
op.create_table(
'crawl_job', sa.Column('flight_date', sa.DATE(), nullable=False),
sa.Column('airline', sa.CHAR(length=32), nullable=False),
sa.Column('origin', sa.CHAR(length=3), nullable=False),
sa.Column('destination', sa.CHAR(length=3), nullable=False),
sa.Column('next_run_after', sa.BigInteger(), nullable=False),
sa.Column('updated_at_timestamp', sa.BigInteger(), nullable=False),
sa.Column('id', sa.BigInteger(), nullable=False),
sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('package_versions', schema=None) as batch_op:
batch_op.alter_column(
'size',
existing_type=sa.BigInteger(),
type_=sa.INTEGER(),
existing_nullable=True,
)
with op.batch_alter_table('channels', schema=None) as batch_op:
batch_op.alter_column(
'size_limit',
existing_type=sa.BigInteger(),
type_=sa.INTEGER(),
existing_nullable=True,
)
batch_op.alter_column(
'size',
existing_type=sa.BigInteger(),
type_=sa.INTEGER(),
existing_nullable=True,
)
op.create_table(
'repodata_signing_keys',
sa.Column('id', sa.BLOB(), nullable=False),
sa.Column('private_key', sa.VARCHAR(), nullable=True),
sa.Column(
'time_created',
sa.DATE(),
server_default=sa.text('(CURRENT_TIMESTAMP)'),
nullable=False,
),
sa.Column('user_id', sa.BLOB(), nullable=True),
sa.Column('channel_name', sa.VARCHAR(), nullable=True),
sa.ForeignKeyConstraint(
['channel_name'],
['channels.name'],
),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
),
sa.PrimaryKeyConstraint('id'),
)
op.drop_table('delegations_keys')
op.drop_table('signing_keys')
op.drop_table('role_delegations')
op.drop_table('content_trust_roles')
def upgrade():
op.create_table('raw_adi',
sa.Column('adi_count', sa.INTEGER(), nullable=True),
sa.Column('date', sa.DATE(), nullable=True),
sa.Column('product_name', sa.TEXT(), nullable=True),
sa.Column('product_os_platform', sa.TEXT(), nullable=True),
sa.Column('product_os_version', sa.TEXT(), nullable=True),
sa.Column('product_version', sa.TEXT(), nullable=True),
sa.Column('build', sa.TEXT(), nullable=True),
sa.Column('product_guid', sa.TEXT(), nullable=True),
sa.Column('update_channel', sa.TEXT(), nullable=True),
sa.Column('received_at', postgresql.TIMESTAMP(timezone=True), server_default='NOW()', nullable=True)
)
op.create_index('raw_adi_1_idx', 'raw_adi', ['date', 'product_name', 'product_version', 'product_os_platform', 'product_os_version'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'ChucDanhNghiepVuUser', sa.Column('id', sa.SMALLINT(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('chuc_danh_nghiep_vu_id', sa.SMALLINT(), nullable=True),
sa.Column('ngay_bat_dau', sa.DATE(), nullable=True),
sa.ForeignKeyConstraint(
['chuc_danh_nghiep_vu_id'],
['ChucDanhNghiepVu.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['User.id'],
), sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'subscriptions',
sa.Column('conversion_emails_sent',
sa.INTEGER(),
autoincrement=False,
nullable=True))
op.add_column(
'subscriptions',
sa.Column('converted_date',
sa.DATE(),
autoincrement=False,
nullable=True))
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('tbl_users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('userid', sa.String(length=250), nullable=False),
sa.Column('email', sa.String(length=250), nullable=False),
sa.Column('password', sa.String(length=35), nullable=False),
sa.Column('firstname', sa.String(length=150), nullable=True),
sa.Column('lastname', sa.String(length=150), nullable=False),
sa.Column('birthdate', sa.DATE(), nullable=False),
sa.Column('registerdate', sa.TIMESTAMP(), nullable=False),
sa.Column('isactive', sa.Boolean(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('payment',
sa.Column('id', mysql.INTEGER(), autoincrement=True, nullable=False),
sa.Column('booking_id', mysql.INTEGER(), autoincrement=False, nullable=True),
sa.Column('amount', mysql.DECIMAL(precision=10, scale=2), nullable=True),
sa.Column('date_received', sa.DATE(), nullable=True),
sa.ForeignKeyConstraint(['booking_id'], ['booking.id'], name='payment_ibfk_1'),
sa.PrimaryKeyConstraint('id'),
mysql_collate='utf8_bin',
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.drop_table('billing')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'pays', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('amount',
sa.NUMERIC(precision=20, scale=10),
autoincrement=False,
nullable=True),
sa.Column('p_month', sa.DATE(), autoincrement=False, nullable=True),
sa.Column('p_age', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('p_gender', sa.VARCHAR(), autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('id', name='pays_pkey'))
op.drop_table('paystats')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'shop_sales_data', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('date', sa.DATE(), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('shop_id', sa.String(length=64), nullable=True),
sa.Column('bill_number', sa.String(length=64), nullable=True),
sa.Column('barcode', sa.String(length=64), nullable=True),
sa.Column('product_description', sa.String(length=1024),
nullable=True),
sa.Column('sales_quantity', sa.Integer(), nullable=True),
sa.Column('amount', sa.Float(), nullable=True),
sa.PrimaryKeyConstraint('id'))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('sessions', schema=None) as batch_op:
batch_op.add_column(sa.Column('date', sa.DATE(), nullable=True))
batch_op.drop_index(batch_op.f('ix_sessions_timestamp'))
batch_op.alter_column('start_time',
existing_type=sa.DateTime(),
type_=sa.TIME(),
existing_nullable=True)
batch_op.alter_column('end_time',
existing_type=sa.DateTime(),
type_=sa.TIME(),
existing_nullable=True)
batch_op.drop_column('timestamp')
