def downgrade(): op.create_table( 'server_status', sa.Column('avg_process_sec', sa.REAL(), autoincrement=False, nullable=True), sa.Column('avg_wait_sec', sa.REAL(), autoincrement=False, nullable=True), sa.Column('date_created', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=False), sa.Column('date_oldest_job_queued', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True), sa.Column('date_recently_completed', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True), sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('processors_count', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('waiting_job_count', sa.INTEGER(), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('id', name=u'server_status_pkey'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('credits', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('value', sa.REAL(), autoincrement=False, nullable=True), sa.Column('active', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='credits_pkey') ) op.create_table('debits', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('value', sa.REAL(), autoincrement=False, nullable=True), sa.Column('active', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='debits_pkey') ) op.create_table('balances', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('value', sa.REAL(), autoincrement=False, nullable=True), sa.Column('active', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='balances_pkey') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('device', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('cur_session', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_device_name'), 'device', ['name'], unique=True) op.create_table('log', sa.Column('id', sa.Integer(), nullable=False), sa.Column('device', sa.Integer(), nullable=True), sa.Column('session', sa.Integer(), nullable=True), sa.Column('bat_v', sa.REAL(), nullable=True), sa.Column('temp_f', sa.REAL(), nullable=True), sa.Column('light_vis', sa.REAL(), nullable=True), sa.Column('light_ir', sa.REAL(), nullable=True), sa.Column('light_uv', sa.REAL(), nullable=True), sa.Column('accel_x', sa.REAL(), nullable=True), sa.Column('accel_y', sa.REAL(), nullable=True), sa.Column('accel_z', sa.REAL(), nullable=True), sa.Column('tilt', sa.REAL(), nullable=True), sa.Column('wifi_conn_fail', sa.Integer(), nullable=True), sa.Column('mqtt_conn_fail', sa.Integer(), nullable=True), sa.Column('last_run_time', sa.REAL(), nullable=True), sa.Column('timestamp', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['device'], ['device.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_log_timestamp'), 'log', ['timestamp'], unique=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'USER', type_='unique') op.alter_column('USER', 'password', existing_type=sa.VARCHAR(length=60), nullable=True) op.drop_constraint(None, 'TOUR', type_='unique') op.alter_column('TOUR', 'upload_time', existing_type=postgresql.TIMESTAMP(), nullable=False, existing_server_default=sa.text('now()')) op.alter_column('TOUR', 'title', existing_type=sa.VARCHAR(length=32), nullable=False) op.alter_column('TOUR', 'rating', existing_type=sa.REAL(), nullable=False) op.alter_column('TOUR', 'price', existing_type=sa.REAL(), nullable=False) op.alter_column('TOUR', 'guide_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('TOUR', 'duration', existing_type=postgresql.INTERVAL(), nullable=False) op.create_index('LANGUAGE_pkey', 'LANGUAGE', ['id'], unique=True) op.drop_table('TOUR_DATE')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('drugType', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=50), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_table( 'account', sa.Column('id', sa.Integer(), nullable=False), sa.Column('accountNo', sa.String(length=50), nullable=False), sa.Column('time', sa.DateTime(), nullable=False), sa.Column('accountMoney', sa.REAL(), nullable=False), sa.Column('userId', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['userId'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('drug', sa.Column('id', sa.Integer(), nullable=False), sa.Column('num', sa.String(length=50), nullable=False), sa.Column('name', sa.String(length=50), nullable=False), sa.Column('count', sa.Integer(), nullable=False), sa.Column('saleCount', sa.Integer(), nullable=False), sa.Column('price', sa.REAL(), nullable=False), sa.Column('desc', sa.String(length=500), nullable=False), sa.Column('drugTypeId', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['drugTypeId'], ['drugType.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('sale', sa.Column('id', sa.Integer(), nullable=False), sa.Column('time', sa.DateTime(), nullable=False), sa.Column('saleCount', sa.Integer(), nullable=False), sa.Column('saleMoney', sa.REAL(), nullable=False), sa.Column('userId', sa.Integer(), nullable=True), sa.Column('accountId', sa.Integer(), nullable=True), sa.Column('drugId', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['accountId'], ['account.id'], ), sa.ForeignKeyConstraint( ['drugId'], ['drug.id'], ), sa.ForeignKeyConstraint( ['userId'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('stock', sa.Column('id', sa.Integer(), nullable=False), sa.Column('stockDate', sa.DateTime(), nullable=False), sa.Column('stockPrice', sa.REAL(), nullable=False), sa.Column('stockCount', sa.Integer(), nullable=False), sa.Column('stockMoney', sa.REAL(), nullable=False), sa.Column('drugId', sa.Integer(), nullable=True), sa.Column('userId', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['drugId'], ['drug.id'], ), sa.ForeignKeyConstraint( ['userId'], ['user.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): op.add_column( "comment_tags", sa.Column("weight", sa.REAL(), server_default=sa.text("1.0"), nullable=False), ) op.add_column("users", sa.Column("comment_tag_weight", sa.REAL(), nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('Environemnt', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('timestamp', sa.TIMESTAMP(), nullable=True), sa.Column('temperature', sa.REAL(), nullable=True), sa.Column('humidity', sa.REAL(), nullable=True), sa.PrimaryKeyConstraint('id')) op.drop_table('environment')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('items', sa.Column('wholesale_price', sa.REAL(), autoincrement=False, nullable=False)) op.add_column('items', sa.Column('exp_date', postgresql.TIMESTAMP(), autoincrement=False, nullable=False)) op.add_column('items', sa.Column('item_code', sa.INTEGER(), autoincrement=False, nullable=False)) op.add_column('items', sa.Column('mfd_date', postgresql.TIMESTAMP(), autoincrement=False, nullable=False)) op.add_column('items', sa.Column('retail_price', sa.REAL(), autoincrement=False, nullable=False)) op.add_column('items', sa.Column('qty', sa.INTEGER(), autoincrement=False, nullable=False)) op.add_column('items', sa.Column('discount', sa.REAL(), autoincrement=False, nullable=True)) op.drop_table('stock')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('group', sa.Column('group_id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('name', sa.String(length=30), nullable=False), sa.PrimaryKeyConstraint('group_id') ) op.create_table('user', sa.Column('user_id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('username', sa.String(length=20), nullable=False), sa.Column('pw_hash', sa.String(length=64), nullable=False), sa.Column('name', sa.String(length=50), nullable=False), sa.PrimaryKeyConstraint('user_id'), sa.UniqueConstraint('username') ) op.create_table('expense', sa.Column('expense_id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('title', sa.String(length=50), nullable=True), sa.Column('total', sa.REAL(), nullable=False), sa.Column('payer', sa.Integer(), nullable=False), sa.Column('group_id', sa.Integer(), nullable=True), sa.Column('split', sa.Enum('EQUAL', 'EXACT', 'PERCENTAGE', name='splittype'), nullable=False), sa.Column('timestamp', sa.TIMESTAMP(timezone=True), nullable=False), sa.ForeignKeyConstraint(['group_id'], ['group.group_id'], ), sa.ForeignKeyConstraint(['payer'], ['user.user_id'], ), sa.PrimaryKeyConstraint('expense_id') ) op.create_table('group_membership', sa.Column('group_id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['group_id'], ['group.group_id'], ), sa.ForeignKeyConstraint(['user_id'], ['user.user_id'], ), sa.PrimaryKeyConstraint('group_id', 'user_id') ) op.create_table('payment', sa.Column('payment_id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('note', sa.String(length=50), nullable=True), sa.Column('amount', sa.REAL(), nullable=False), sa.Column('payer', sa.Integer(), nullable=False), sa.Column('payee', sa.Integer(), nullable=False), sa.Column('group_id', sa.Integer(), nullable=True), sa.Column('timestamp', sa.TIMESTAMP(timezone=True), nullable=False), sa.ForeignKeyConstraint(['group_id'], ['group.group_id'], ), sa.ForeignKeyConstraint(['payee'], ['user.user_id'], ), sa.ForeignKeyConstraint(['payer'], ['user.user_id'], ), sa.PrimaryKeyConstraint('payment_id') ) op.create_table('expense_share', sa.Column('expense_id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('share', sa.REAL(), nullable=False), sa.ForeignKeyConstraint(['expense_id'], ['expense.expense_id'], ), sa.ForeignKeyConstraint(['user_id'], ['user.user_id'], ), sa.PrimaryKeyConstraint('expense_id', 'user_id') )
class Session(Base): __tablename__ = "session" session_id = sa.Column(sa.Integer, primary_key=True) start_time = sa.Column(sa.TIMESTAMP(timezone=True), unique=True) datasource = sa.Column(sa.String()) author = sa.Column(sa.String()) file_version = sa.Column(sa.REAL()) title = sa.Column(sa.String()) lat = sa.Column(sa.REAL()) lon = sa.Column(sa.REAL()) client_version = sa.Column(sa.String()) status = sa.Column(sa.String())
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('appliance_type', sa.Column('max_power', sa.REAL(), nullable=True)) op.add_column('appliance_type', sa.Column('min_off_duration', sa.REAL(), nullable=True)) op.add_column('appliance_type', sa.Column('min_on_duration', sa.REAL(), nullable=True)) op.add_column('appliance_type', sa.Column('on_power_threshold', sa.REAL(), nullable=True)) op.drop_index('sample_power_source_id_timestamp_physical_quantity_id_idx', table_name='sample')
class Impact(Base): __tablename__ = "impact" id = sa.Column(sa.Integer, primary_key=True) session_id = sa.Column( sa.INTEGER(), sa.ForeignKey("session.session_id", ondelete="CASCADE"), index=True, ) killer = sa.Column(sa.INTEGER(), sa.ForeignKey("object.id")) target = sa.Column(sa.INTEGER(), sa.ForeignKey("object.id")) weapon = sa.Column(sa.INTEGER(), sa.ForeignKey("object.id")) time_offset = sa.Column(sa.REAL()) impact_dist = sa.Column(sa.REAL(), index=True)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'TOUR_DATE', sa.Column('id', sa.Integer(), server_default=FetchedValue(), nullable=False), sa.Column('tour_id', sa.Integer(), nullable=True), sa.Column('tour_date', sa.DateTime(), server_default=FetchedValue(), nullable=True), sa.ForeignKeyConstraint( ['tour_id'], ['TOUR.id'], ), sa.PrimaryKeyConstraint('id')) op.drop_index('LANGUAGE_pkey', table_name='LANGUAGE') op.alter_column('TOUR', 'duration', existing_type=postgresql.INTERVAL(), nullable=True) op.alter_column('TOUR', 'guide_id', existing_type=sa.INTEGER(), nullable=True) op.alter_column('TOUR', 'price', existing_type=sa.REAL(), nullable=True) op.alter_column('TOUR', 'rating', existing_type=sa.REAL(), nullable=True) op.alter_column('TOUR', 'title', existing_type=sa.VARCHAR(length=32), nullable=True) op.alter_column('TOUR', 'upload_time', existing_type=postgresql.TIMESTAMP(), nullable=True, existing_server_default=sa.text('now()')) op.create_unique_constraint(None, 'TOUR', ['uuid']) op.alter_column('USER', 'email', existing_type=sa.VARCHAR(length=60), nullable=True) op.alter_column('USER', 'firstname', existing_type=sa.VARCHAR(length=32), nullable=True) op.alter_column('USER', 'lastname', existing_type=sa.VARCHAR(length=32), nullable=True) op.create_unique_constraint(None, 'USER', ['uuid'])
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('statusdb', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('sitename', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('sectionname', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('statustext', sa.TEXT(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='statusdb_pkey'), sa.UniqueConstraint('sitename', 'sectionname', name='statusdb_sitename_sectionname_key') ) op.create_table('retrieved_pages', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('sitename', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('artistname', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('pageurl', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('retreivaltime', sa.REAL(), autoincrement=False, nullable=False), sa.Column('downloadpath', sa.TEXT(), autoincrement=False, nullable=True), sa.Column('itempagecontent', sa.TEXT(), autoincrement=False, nullable=True), sa.Column('itempagetitle', sa.TEXT(), autoincrement=False, nullable=True), sa.Column('seqnum', sa.INTEGER(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='retrieved_pages_pkey'), sa.UniqueConstraint('sitename', 'artistname', 'pageurl', 'seqnum', name='retrieved_pages_sitename_artistname_pageurl_seqnum_key') ) op.create_table('retreival_times', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('sitename', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('artistname', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('retreivaltime', sa.REAL(), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('id', name='retreival_times_pkey'), sa.UniqueConstraint('sitename', 'artistname', name='retreival_times_sitename_artistname_key') ) op.create_table('siteartistnames', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('sitename', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('artistname', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('uploadeh', sa.INTEGER(), server_default=sa.text('0'), autoincrement=False, nullable=True), sa.Column('last_fetched', postgresql.DOUBLE_PRECISION(precision=53), server_default=sa.text('0'), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='siteartistnames_pkey'), sa.UniqueConstraint('sitename', 'artistname', name='siteartistnames_sitename_artistname_key') ) op.create_table('errored_pages', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('sitename', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('artistname', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('pageurl', sa.TEXT(), autoincrement=False, nullable=False), sa.Column('retreivaltime', sa.REAL(), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('id', name='errored_pages_pkey'), sa.UniqueConstraint('sitename', 'artistname', 'pageurl', name='errored_pages_sitename_artistname_pageurl_key') )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('sps_camera', 'sps_module_name') op.drop_column('sps_camera', 'sps_camera_name') op.alter_column('agc_data', 'image_moment_00_pix', existing_type=sa.REAL(), comment=None, existing_comment='', existing_nullable=True) op.create_table('test', sa.Column('id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('value', sa.REAL(), autoincrement=False, nullable=True) ) op.drop_table('iic_sequence_status') op.drop_table('iic_sequence')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('item', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('app.item_id_seq'::regclass)"), autoincrement=True, nullable=False), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('name', sa.CHAR(length=255), autoincrement=False, nullable=True), sa.Column('code', sa.CHAR(length=255), autoincrement=False, nullable=True), sa.Column('price', sa.REAL(), autoincrement=False, nullable=True), sa.Column('count', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('image', sa.CHAR(length=255), autoincrement=False, nullable=True), sa.Column('measure', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('ball', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('nds', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('sale', sa.CHAR(length=1), autoincrement=False, nullable=True), sa.Column('cat', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('office', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('desc', sa.TEXT(), autoincrement=False, nullable=True), sa.Column('sect', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('test', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('modif', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='item_pkey'), schema='app' ) op.drop_table('product', schema='app')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('substance', 'unit', existing_type=sa.VARCHAR(length=16), nullable=False) op.alter_column('substance', 'title', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('substance', 'sort', existing_type=sa.INTEGER(), nullable=False) op.alter_column('substance', 'precision', existing_type=sa.INTEGER(), nullable=False) op.alter_column('substance', 'hard_ref', existing_type=sa.INTEGER(), nullable=False) op.alter_column('substance', 'criteria', existing_type=sa.REAL(), nullable=False) op.alter_column('substance', 'cas', existing_type=sa.VARCHAR(length=255), nullable=False) op.alter_column('substance', 'active', existing_type=sa.BOOLEAN(), nullable=False) op.drop_column('substance', 'cas_sanitized') op.alter_column('criteria', 'state_id', existing_type=sa.INTEGER(), nullable=False) op.alter_column('criteria', 'active', existing_type=sa.BOOLEAN(), nullable=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'bid_document', sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('deleted_at', sa.DateTime(), nullable=True), sa.Column('public_id', sa.String(length=100), nullable=False), sa.Column('status', sa.Integer(), nullable=False), sa.Column('deletion_marker', sa.Integer(), nullable=True), sa.Column('created_by', sa.String(length=200), nullable=True), sa.Column('updated_by', sa.String(length=200), nullable=True), sa.Column('deleted_by', sa.String(length=200), nullable=True), sa.Column('bid_id', sa.String(length=100), nullable=False), sa.Column('doc_type', sa.String(length=100), nullable=True), sa.Column('doc_url', sa.String(length=100), nullable=False), sa.ForeignKeyConstraint( ['bid_id'], ['bid.public_id'], ), sa.PrimaryKeyConstraint('public_id')) op.create_index(op.f('ix_bid_document_created_by'), 'bid_document', ['created_by'], unique=False) op.create_index(op.f('ix_bid_document_deleted_by'), 'bid_document', ['deleted_by'], unique=False) op.create_index(op.f('ix_bid_document_updated_by'), 'bid_document', ['updated_by'], unique=False) op.alter_column('bid', 'amount', existing_type=sa.REAL(), nullable=True)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('galaxy', sa.Column('bands', sa.String(length=64), nullable=True)) op.add_column('galaxy', sa.Column('fov', sa.REAL(), nullable=True)) op.create_index(op.f('ix_galaxy_bands'), 'galaxy', ['bands'], unique=False) op.create_index(op.f('ix_galaxy_fov'), 'galaxy', ['fov'], unique=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('product', 'price', existing_type=sa.Float(precision=2), type_=sa.REAL(), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'mcs_pfi_transformation', type_='unique') op.drop_constraint(None, 'cobra_target', type_='unique') op.drop_constraint(None, 'cobra_match', type_='unique') op.drop_constraint(None, 'agc_exposure', type_='unique') op.drop_constraint(None, 'agc_data', type_='unique') op.alter_column('agc_data', 'image_moment_00_pix', existing_type=sa.REAL(), comment=None, existing_comment='', existing_nullable=True) op.create_table('test', sa.Column('id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('value', sa.REAL(), autoincrement=False, nullable=True) )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( "rate", sa.Column("rateid", postgresql.UUID(), autoincrement=False, nullable=False), sa.Column("stars", sa.REAL(), autoincrement=False, nullable=False), sa.Column("review", sa.TEXT(), autoincrement=False, nullable=False), sa.Column("report", sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column("reviewed", sa.TEXT(), autoincrement=False, nullable=False), sa.Column("reviewer", sa.TEXT(), autoincrement=False, nullable=False), sa.CheckConstraint( "reviewed ~* '^[\\w\\-\\.]+@([\\w-]+\\.)+[\\w-]{2,4}$'::text", name="valid_reviewed_email", ), sa.CheckConstraint( "reviewer ~* '^[\\w\\-\\.]+@([\\w-]+\\.)+[\\w-]{2,4}$'::text", name="valid_reviewer_email", ), sa.CheckConstraint( "(stars >= (0)::double precision) AND (stars <= (5)::double precision)", name="valid_stars", ), sa.CheckConstraint("reviewed <> reviewer", name="valid_lender_user"), sa.PrimaryKeyConstraint("rateid", name="rate_pk"), )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('hotel', 'site_id', existing_type=sa.INTEGER(), nullable=True) op.alter_column('hotel', 'estrelas', existing_type=sa.Float(precision=1), type_=sa.REAL(), existing_nullable=False) op.alter_column('hotel', 'diaria', existing_type=sa.Float(precision=2), type_=sa.REAL(), existing_nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('price_history', sa.Column('open', sa.REAL(), autoincrement=False, nullable=True)) op.add_column('price_history', sa.Column('low', sa.REAL(), autoincrement=False, nullable=True)) op.add_column('price_history', sa.Column('high', sa.REAL(), autoincrement=False, nullable=True)) op.add_column('price_history', sa.Column('close', sa.REAL(), autoincrement=False, nullable=True)) op.add_column('price_history', sa.Column('adj close', sa.REAL(), autoincrement=False, nullable=True)) op.drop_column('price_history', 'value') op.drop_column('price_history', 'action') op.create_unique_constraint('fiscal_year_unique', 'ms_financials', ['ticker', 'exchange', 'fiscal_year', 'period']) op.create_table('migrate_version', sa.Column('repository_id', sa.VARCHAR(length=250), autoincrement=False, nullable=False), sa.Column('repository_path', sa.TEXT(), autoincrement=False, nullable=True), sa.Column('version', sa.INTEGER(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('repository_id', name='migrate_version_pkey') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('product', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('name', sa.CHAR(length=255), nullable=True), sa.Column('code', sa.CHAR(length=255), nullable=True), sa.Column('price', sa.REAL(), nullable=True), sa.Column('count', sa.Integer(), nullable=True), sa.Column('image', sa.CHAR(length=255), nullable=True), sa.Column('measure', sa.Integer(), nullable=True), sa.Column('ball', sa.Integer(), nullable=True), sa.Column('nds', sa.Integer(), nullable=True), sa.Column('sale', sa.CHAR(length=1), nullable=True), sa.Column('cat', sa.Integer(), nullable=True), sa.Column('office', sa.Integer(), nullable=True), sa.Column('desc', sa.Text(), nullable=True), sa.Column('sect', sa.Integer(), nullable=True), sa.Column('test', sa.Integer(), nullable=True), sa.Column('created', sa.DateTime(), nullable=True), sa.Column('modif', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), schema='app' ) op.drop_table('item', schema='app')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'savings_goals', sa.Column('current_savings', sa.REAL(), autoincrement=False, nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('bills', sa.Column('name', sa.VARCHAR(length=20), autoincrement=False, nullable=False)) op.add_column('bills', sa.Column('amount', sa.REAL(), autoincrement=False, nullable=False)) op.add_column('bills', sa.Column('due_date', sa.DATE(), autoincrement=False, nullable=True)) op.drop_column('bills', 'bill_name') op.drop_column('bills', 'bill_due_date') op.drop_column('bills', 'bill_amount')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'debtor', sa.Column('interest_rate', sa.REAL(), autoincrement=False, nullable=False))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'savings_entry', sa.Column('id', postgresql.UUID(), autoincrement=False, nullable=False), sa.Column('savings_date', sa.DATE(), autoincrement=False, nullable=False), sa.Column('transaction_type', sa.VARCHAR(length=10), autoincrement=False, nullable=False), sa.Column('amount', sa.REAL(), autoincrement=False, nullable=False), sa.Column('user_id', postgresql.UUID(), autoincrement=False, nullable=True), sa.Column('total', sa.REAL(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='savings_entry_user_id_fkey'), sa.PrimaryKeyConstraint('id', name='savings_entry_pkey')) op.create_table( 'savings_goal', sa.Column('id', postgresql.UUID(), autoincrement=False, nullable=False), sa.Column('start_date', sa.DATE(), autoincrement=False, nullable=False), sa.Column('end_date', sa.DATE(), autoincrement=False, nullable=False), sa.Column('amount', sa.REAL(), autoincrement=False, nullable=False), sa.Column('user_id', postgresql.UUID(), autoincrement=False, nullable=True), sa.Column('previous_amount', sa.REAL(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='savings_goal_user_id_fkey'), sa.PrimaryKeyConstraint('id', name='savings_goal_pkey')) op.drop_table('savings_goals') op.drop_table('total_savings_log') op.drop_table('savings_entries')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('mcs_exposure', 'version_instdata') op.drop_column('mcs_exposure', 'version_actor') op.drop_column('mcs_exposure', 'measurement_algorithm') op.drop_column('agc_exposure', 'version_instdata') op.drop_column('agc_exposure', 'version_actor') op.drop_column('agc_exposure', 'measurement_algorithm') op.alter_column('agc_data', 'image_moment_00_pix', existing_type=sa.REAL(), comment=None, existing_comment='', existing_nullable=True) op.create_table('test', sa.Column('id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('value', sa.REAL(), autoincrement=False, nullable=True) ) op.drop_table('agc_guide_offset')