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')