def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('carpools', sa.Column('id', sa.Integer(), nullable=False), sa.Column('uid', sa.Integer(), nullable=False), sa.Column('driver', sa.VARCHAR(length=50), nullable=True), sa.Column('contact', sa.VARCHAR(length=200), nullable=True), sa.Column('source', sa.VARCHAR(length=50), nullable=False), sa.Column('destination', sa.VARCHAR(length=50), nullable=False), sa.Column('departure_time', sa.TIMESTAMP(), nullable=True), sa.Column('notice', sa.VARCHAR(length=200), nullable=True), sa.Column('max_people', sa.SMALLINT(), nullable=True), sa.Column('people_count', sa.SMALLINT(), nullable=True), sa.ForeignKeyConstraint(['uid'], ['users.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('passengers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('uid', sa.Integer(), nullable=False), sa.Column('carpool_id', sa.Integer(), nullable=False), sa.Column('join_time', sa.TIMESTAMP(), nullable=True), sa.Column('contact', sa.VARCHAR(length=200), nullable=True), sa.ForeignKeyConstraint(['carpool_id'], ['carpools.id'], ), sa.ForeignKeyConstraint(['uid'], ['users.id'], ), sa.PrimaryKeyConstraint('id') )
def downgrade_(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'order_tst_gid', sa.Column('create_time', sa.INTEGER(), nullable=False), sa.Column('update_time', sa.INTEGER(), nullable=False), sa.Column('uid', sa.INTEGER(), nullable=False), sa.Column('sys_tx_id', sa.VARCHAR(length=128), nullable=False), sa.Column('mch_tx_id', sa.VARCHAR(length=128), nullable=False), sa.Column('channel_tx_id', sa.VARCHAR(length=128), nullable=True), sa.Column('amount', sa.INTEGER(), nullable=False), sa.Column('tx_amount', sa.INTEGER(), nullable=True), sa.Column('source', sa.SMALLINT(), nullable=False), sa.Column('p_method', sa.SMALLINT(), nullable=True), sa.Column('state', sa.SMALLINT(), nullable=False), sa.Column('settle', sa.SMALLINT(), nullable=False), sa.Column('deliver', sa.SMALLINT(), nullable=False), sa.Column('channel_id', sa.INTEGER(), nullable=True), sa.Column('mch_fee_id', sa.INTEGER(), nullable=True), sa.Column('notify_url', sa.VARCHAR(length=256), nullable=True), sa.Column('extra', sa.TEXT(), nullable=True), sa.Column('merchant', sa.INTEGER(), nullable=False), sa.Column('id', sa.INTEGER(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('mch_tx_id'), sa.UniqueConstraint('sys_tx_id')) op.drop_table('order_tst_gidX')
def downgrade(): op.create_table( 'premiumpurchase', sa.Column('token', sa.VARCHAR(), autoincrement=False, nullable=False), sa.Column('email', sa.VARCHAR(length=254), autoincrement=False, nullable=False), sa.Column('terms', sa.SMALLINT(), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('token', name=u'premiumpurchase_pkey')) op.create_table( 'userpremium', sa.Column('userid', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('unixtime', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('terms', sa.SMALLINT(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['userid'], [u'login.userid'], name=u'userpremium_userid_fkey', onupdate=u'CASCADE', ondelete=u'CASCADE'), sa.PrimaryKeyConstraint('userid', name=u'userpremium_pkey')) op.execute( "UPDATE login SET settings = login.settings || 'd' FROM profile WHERE login.settings !~ 'd' AND login.userid = profile.userid AND profile.config ~ 'd'" )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('User', sa.Column('trang_thai_user_id', sa.SMALLINT(), autoincrement=False, nullable=True), schema='NhanSu') op.drop_constraint(None, 'User', schema='NhanSu', type_='foreignkey') op.create_foreign_key('FK__User__trang_thai__4CA06362', 'User', 'TrangThaiUser', ['trang_thai_user_id'], ['id'], source_schema='NhanSu', referent_schema='NhanSu') op.drop_column('User', 'trang_thai_cong_tac_id', schema='NhanSu') op.create_table('TrangThaiUser', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('ten', sa.NVARCHAR(length=25), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint( 'id', name='PK__TrangTha__3213E83F2A7935EA'), schema='NhanSu') op.drop_table('TrangThaiCongTac', schema='NhanSu')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('shopping_orders', 'type') op.create_table('consumption_plans', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('consumption_plans_id_seq'::regclass)"), nullable=False), sa.Column('creator_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('user_group_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['creator_id'], ['users.id'], name='consumption_plans_creator_id_fkey'), sa.ForeignKeyConstraint(['user_group_id'], ['user_groups.id'], name='consumption_plans_user_group_id_fkey'), sa.PrimaryKeyConstraint('id', name='consumption_plans_pkey'), postgresql_ignore_search_path=False ) op.create_table('consumption_plan_items', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('consumption_plan_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('inventory_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('material_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('type', sa.SMALLINT(), autoincrement=False, nullable=False), sa.Column('quantity', postgresql.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=False), sa.Column('plan_date', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True), sa.Column('period', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('weekday', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('day_in_month', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('end_date', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True), sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['consumption_plan_id'], ['consumption_plans.id'], name='consumption_plan_items_consumption_plan_id_fkey'), sa.ForeignKeyConstraint(['inventory_id'], ['inventories.id'], name='consumption_plan_items_inventory_id_fkey'), sa.ForeignKeyConstraint(['material_id'], ['materials.id'], name='consumption_plan_items_material_id_fkey'), sa.PrimaryKeyConstraint('id', name='consumption_plan_items_pkey') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('ip_code_info', sa.Column('lock_max_1m', sa.SMALLINT(), nullable=True)) op.add_column('ip_code_info', sa.Column('lock_max_30m', sa.SMALLINT(), nullable=True)) op.drop_column('ip_code_info', 'unlock_count_30m') op.drop_column('ip_code_info', 'unlock_count_1m')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('companies', 'company_full_name') op.create_table( 'code_orders', sa.Column('id', sa.BIGINT(), autoincrement=True, nullable=False), sa.Column('code_sn', sa.VARCHAR(length=64), autoincrement=False, nullable=True, comment='生码编号'), sa.Column('company_code', sa.VARCHAR(length=64), autoincrement=False, nullable=True, comment='商户名称'), sa.Column('relevance_type', sa.SMALLINT(), autoincrement=False, nullable=True, comment='关联 before 1 前关联 after 2 后关联'), sa.Column('code_type', sa.SMALLINT(), autoincrement=False, nullable=True, comment='码类型 standard 1 标准码 group 2 套标'), sa.Column('code_config', sa.TEXT(), autoincrement=False, nullable=True, comment='码配置'), sa.Column( 'status', sa.SMALLINT(), autoincrement=False, nullable=True, comment='生码状态 wait 0 等待 begin 1 开始 done 2 完成 cancel 3 取消 fail 4 失败' ), sa.Column('created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True, comment='创建时间'), sa.Column('updated_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True, comment='更新时间'), sa.ForeignKeyConstraint(['company_code'], ['companies.company_code'], name='code_orders_company_code_fkey'), sa.PrimaryKeyConstraint('id', name='code_orders_pkey')) op.create_index('ix_code_orders_id', 'code_orders', ['id'], unique=False) op.create_index('ix_code_orders_code_sn', 'code_orders', ['code_sn'], unique=True) op.drop_index(op.f('ix_orders_id'), table_name='orders') op.drop_index(op.f('ix_orders_code_sn'), table_name='orders') op.drop_table('orders')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('notoriousmonster', sa.Column('id', sa.Integer(), nullable=False), sa.Column('bnpcbase', sa.Text(), nullable=True), sa.Column('rank', sa.SMALLINT(), nullable=True), sa.Column('bnpcname', sa.Text(), nullable=True), sa.Column('unk3', sa.SMALLINT(), nullable=True), sa.PrimaryKeyConstraint('id'))
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.alter_column('node', 'min_num', existing_type=sa.SMALLINT(), nullable=False) op.alter_column('node', 'max_num', existing_type=sa.SMALLINT(), nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'item', sa.Column('isequippable', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column( 'item', sa.Column('unk49', sa.SMALLINT(), autoincrement=False, nullable=True)) op.add_column( 'item', sa.Column('unk40', sa.SMALLINT(), autoincrement=False, nullable=True)) op.add_column( 'item', sa.Column('unk88', sa.SMALLINT(), autoincrement=False, nullable=True)) op.add_column( 'item', sa.Column('unk53', sa.SMALLINT(), autoincrement=False, nullable=True)) op.drop_column('item', 'unk89') op.drop_column('item', 'unk54') op.drop_column('item', 'unk50') op.drop_column('item', 'unk41') op.drop_column('item', 'unk36') op.drop_column('item', 'lot') op.drop_column('action', 'vfx') op.drop_column('action', 'unk9') op.drop_column('action', 'unk64') op.drop_column('action', 'unk63') op.drop_column('action', 'unk62') op.drop_column('action', 'unk61') op.drop_column('action', 'unk60') op.drop_column('action', 'unk59') op.drop_column('action', 'unk58') op.drop_column('action', 'unk57') op.drop_column('action', 'unk56') op.drop_column('action', 'unk55') op.drop_column('action', 'unk54') op.drop_column('action', 'unk50') op.drop_column('action', 'unk49') op.drop_column('action', 'unk45') op.drop_column('action', 'unk40') op.drop_column('action', 'unk4') op.drop_column('action', 'unk30') op.drop_column('action', 'unk26') op.drop_column('action', 'unk24') op.drop_column('action', 'unk23') op.drop_column('action', 'unk22') op.drop_column('action', 'unk20') op.drop_column('action', 'unk19') op.drop_column('action', 'unk1') op.drop_column('action', 'animationstart') op.drop_column('action', 'animationend') op.drop_column('action', 'actiontimelinehit')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('ChucDanhCongTac', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('Dm_Chuc_Danh_Cong_Tac_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint(['Dm_Chuc_Danh_Cong_Tac_id'], ['Dm_ChucDanhCongTac.id'], ), sa.ForeignKeyConstraint(['user_id'], ['User.id'], ), sa.PrimaryKeyConstraint('id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_table('recipetemp') op.add_column('item', sa.Column('unk36', sa.SMALLINT(), nullable=True)) op.add_column('item', sa.Column('unk41', sa.SMALLINT(), nullable=True)) op.add_column('item', sa.Column('unk50', sa.SMALLINT(), nullable=True)) op.add_column('item', sa.Column('unk54', sa.SMALLINT(), nullable=True)) op.add_column('item', sa.Column('unk89', sa.SMALLINT(), nullable=True)) op.drop_column('item', 'unk88') op.drop_column('item', 'unk49') op.drop_column('item', 'unk40') op.drop_column('item', 'unk53')
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( 'auth_user', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('date_created', sa.DATETIME(), nullable=True), sa.Column('date_modified', sa.DATETIME(), nullable=True), sa.Column('name', sa.VARCHAR(length=128), nullable=False), sa.Column('email', sa.VARCHAR(length=128), nullable=False), sa.Column('password', sa.VARCHAR(length=192), nullable=False), sa.Column('role', sa.SMALLINT(), nullable=False), sa.Column('status', sa.SMALLINT(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'))
def downgrade(): op.add_column( 'resource_stat', sa.Column('percentage_explored', sa.SMALLINT(), autoincrement=False, nullable=True)) op.add_column( 'resource_stat', sa.Column('percentage_total', sa.SMALLINT(), autoincrement=False, nullable=True)) op.drop_column('resource_stat', 'limit_left')
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 upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('BoPhan', sa.Column('id', sa.Integer(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=50), nullable=False), sa.Column('ma', sa.String(length=3), nullable=True), sa.Column('khoi', sa.String(length=20), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('TrangThaiUser', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=25), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'User', sa.Column('id', sa.Integer(), nullable=False), sa.Column('ho_dem', sa.NVARCHAR(length=30), nullable=True), sa.Column('ten', sa.NVARCHAR(length=15), nullable=True), sa.Column('ngay_sinh', sa.Date(), nullable=True), sa.Column('nam_gioi', sa.NCHAR(length=1), nullable=True), sa.Column('nhom_mau', sa.String(length=10), nullable=True), sa.Column('dantoc', sa.NVARCHAR(length=20), nullable=True), sa.Column('que', sa.NVARCHAR(length=100), nullable=True), sa.Column('dktt', sa.NVARCHAR(length=100), nullable=True), sa.Column('noio', sa.NVARCHAR(length=100), nullable=True), sa.Column('so_hieu', sa.String(length=6), nullable=True), sa.Column('ngay_vao_ca', sa.Date(), nullable=True), sa.Column('nganh_ngoai', sa.Boolean(), nullable=True), sa.Column('trinh_do_chinh_tri', sa.NVARCHAR(length=30), nullable=True), sa.Column('trinh_do_ngoai_ngu', sa.NVARCHAR(length=30), nullable=True), sa.Column('trinh_do_tin_hoc', sa.NVARCHAR(length=30), nullable=True), sa.Column('trang_thai_user_id', sa.SMALLINT(), nullable=True), sa.Column('username', sa.String(length=20), nullable=True), sa.Column('email', sa.String(length=120), nullable=True), sa.Column('password_hash', sa.String(length=128), nullable=True), sa.ForeignKeyConstraint( ['trang_thai_user_id'], ['TrangThaiUser.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_User_email'), 'User', ['email'], unique=True) op.create_index(op.f('ix_User_ten'), 'User', ['ten'], unique=False) op.create_index(op.f('ix_User_username'), 'User', ['username'], unique=True) op.create_table( 'SoDienThoai', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('so_dien_thoai', sa.NCHAR(length=10), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['User.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'Owners', sa.Column('owner_id', postgresql.UUID(as_uuid=True), nullable=False), sa.Column('owner_name', sa.VARCHAR(length=50), nullable=False), sa.Column('phone', sa.VARCHAR(length=15), nullable=False), sa.PrimaryKeyConstraint('owner_id')) op.create_table( 'Pets', sa.Column('pet_id', postgresql.UUID(as_uuid=True), nullable=False), sa.Column('pet_name', sa.VARCHAR(length=20), nullable=True), sa.Column('booking_time', postgresql.TIMESTAMP(), nullable=False), sa.Column('room_num', sa.SMALLINT(), nullable=False), sa.Column('owner_id', postgresql.UUID(as_uuid=True), nullable=False), sa.ForeignKeyConstraint( ['owner_id'], ['Owners.owner_id'], ), sa.PrimaryKeyConstraint('pet_id')) op.create_table( 'Activities', sa.Column('activity_id', postgresql.UUID(as_uuid=True), nullable=False), sa.Column('activity_time', postgresql.TIMESTAMP(), nullable=False), sa.Column('activity_type', sa.VARCHAR(length=20), nullable=False), sa.Column('pet_id', postgresql.UUID(as_uuid=True), nullable=False), sa.ForeignKeyConstraint( ['pet_id'], ['Pets.pet_id'], ), sa.PrimaryKeyConstraint('activity_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'query', sa.Column('query_id', sa.Integer(), nullable=False), sa.Column('query_string', sa.Text(), nullable=False), sa.Column('project_id', sa.Integer(), nullable=False), sa.Column('execution_status', sa.SMALLINT(), nullable=False), sa.Column('db_connection_id', sa.Integer(), nullable=False), sa.Column('owner_id', sa.Integer(), nullable=False), sa.Column('query_result', postgresql.JSON(astext_type=sa.Text()), nullable=True), sa.Column('is_deleted', sa.Boolean(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('modified_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['db_connection_id'], ['db_connection.db_connection_id'], ), sa.ForeignKeyConstraint( ['owner_id'], ['user.user_id'], ), sa.ForeignKeyConstraint( ['project_id'], ['project.project_id'], ), sa.PrimaryKeyConstraint('query_id')) op.create_index(op.f('ix_query_db_connection_id'), 'query', ['db_connection_id'], unique=False) op.create_index(op.f('ix_query_project_id'), 'query', ['project_id'], unique=False) op.add_column('organization', sa.Column('org_description', sa.Text(), nullable=True)) op.add_column('project', sa.Column('project_description', sa.Text(), nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('volunteer_user_role', sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('role_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['role_id'], ['volunteer_role.id'], name='fk_volunteer_user_role_role_id_volunteer_role'), sa.ForeignKeyConstraint(['user_id'], ['user.id'], name='fk_volunteer_user_role_user_id_user'), sa.PrimaryKeyConstraint('user_id', 'role_id', name='pk_volunteer_user_role') ) op.create_table('volunteer_role_mapping_version', sa.Column('volunteer_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('role_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('transaction_id', sa.BIGINT(), autoincrement=False, nullable=False), sa.Column('operation_type', sa.SMALLINT(), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('volunteer_id', 'role_id', 'transaction_id', name='pk_volunteer_role_mapping_version') ) op.create_index('ix_volunteer_role_mapping_version_transaction_id', 'volunteer_role_mapping_version', ['transaction_id'], unique=False) op.create_index('ix_volunteer_role_mapping_version_operation_type', 'volunteer_role_mapping_version', ['operation_type'], unique=False) op.create_table('volunteer_role_mapping', sa.Column('volunteer_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('role_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['role_id'], ['volunteer_role.id'], name='fk_volunteer_role_mapping_role_id_volunteer_role'), sa.ForeignKeyConstraint(['volunteer_id'], ['volunteer.id'], name='fk_volunteer_role_mapping_volunteer_id_volunteer'), sa.PrimaryKeyConstraint('volunteer_id', 'role_id', name='pk_volunteer_role_mapping') ) op.drop_table('volunteer_role_training') op.drop_table('volunteer_role_interest') op.drop_index(op.f('ix_volunteer_role_training_version_transaction_id'), table_name='volunteer_role_training_version') op.drop_index(op.f('ix_volunteer_role_training_version_operation_type'), table_name='volunteer_role_training_version') op.drop_table('volunteer_role_training_version') op.drop_index(op.f('ix_volunteer_role_interest_version_transaction_id'), table_name='volunteer_role_interest_version') op.drop_index(op.f('ix_volunteer_role_interest_version_operation_type'), table_name='volunteer_role_interest_version') op.drop_table('volunteer_role_interest_version')
def upgrade(): op.create_table('raw_data', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created_ts', sa.TIMESTAMP(), default=datetime.datetime.utcnow), sa.Column('updated_ts', sa.TIMESTAMP(), onupdate=datetime.datetime.utcnow), sa.Column('domain', sa.String(length=100), nullable=False, index=True), sa.Column('url', sa.String(length=255), nullable=False), sa.Column('depth', sa.SMALLINT(), nullable=False), sa.Column('http_status', sa.String(3), nullable=True, index=True), sa.Column('html', LONGTEXT(), nullable=True), sa.Column('parsed_as_entry', sa.Boolean(), default=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('url'), mysql_charset='utf8', mysql_engine='InnoDB') pass
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('post', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('post_id_seq'::regclass)"), autoincrement=True, nullable=False), sa.Column('title', sa.VARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('slug', sa.VARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('body', sa.TEXT(), autoincrement=False, nullable=True), sa.Column('status', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('created_timestamp', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('modified_timestamp', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='post_pkey'), sa.UniqueConstraint('slug', name='post_slug_key'), postgresql_ignore_search_path=False ) op.create_table('tag', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('tag_id_seq'::regclass)"), autoincrement=True, nullable=False), sa.Column('name', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('slug', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='tag_pkey'), sa.UniqueConstraint('slug', name='tag_slug_key'), postgresql_ignore_search_path=False ) op.create_table('post_tags', sa.Column('tag_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('post_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['post_id'], ['post.id'], name='post_tags_post_id_fkey'), sa.ForeignKeyConstraint(['tag_id'], ['tag.id'], name='post_tags_tag_id_fkey') )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'flasklogin-users', type_='unique') op.create_index('idx_16710_sqlite_autoindex_flasklogin-users_1', 'flasklogin-users', ['email'], unique=True) op.alter_column('flasklogin-users', 'write_permission', existing_type=sa.BOOLEAN(), nullable=True) op.alter_column('flasklogin-users', 'password', existing_type=sa.TEXT(), nullable=True) op.alter_column('flasklogin-users', 'last_name', existing_type=sa.TEXT(), nullable=True) op.alter_column('flasklogin-users', 'first_name', existing_type=sa.TEXT(), nullable=True) op.alter_column('flasklogin-users', 'email', existing_type=sa.TEXT(), nullable=True) op.alter_column('flasklogin-users', 'created_on', existing_type=postgresql.TIMESTAMP(timezone=True), nullable=True) op.create_index('idx_16704_ix_film_segment_version_transaction_id', 'film_segment_version', ['transaction_id'], unique=False) op.create_index('idx_16704_ix_film_segment_version_operation_type', 'film_segment_version', ['operation_type'], unique=False) op.create_index('idx_16704_ix_film_segment_version_end_transaction_id', 'film_segment_version', ['end_transaction_id'], unique=False) op.drop_index(op.f('ix_film_segment_version_transaction_id'), table_name='film_segment_version') op.drop_index(op.f('ix_film_segment_version_operation_type'), table_name='film_segment_version') op.drop_index(op.f('ix_film_segment_version_end_transaction_id'), table_name='film_segment_version') op.alter_column('film_segment_version', 'operation_type', existing_type=sa.SMALLINT(), nullable=True) op.drop_constraint(None, 'film_segment', type_='unique') op.create_index('idx_16698_sqlite_autoindex_film_segment_1', 'film_segment', ['path'], unique=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('users', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('users_id_seq'::regclass)"), autoincrement=True, nullable=False), sa.Column('email', sa.VARCHAR(length=60), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('id', name='users_pkey'), sa.UniqueConstraint('email', name='users_email_key'), postgresql_ignore_search_path=False ) op.create_table('questions', sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('questions_id_seq'::regclass)"), autoincrement=True, nullable=False), sa.Column('prompt', sa.VARCHAR(), autoincrement=False, nullable=False), sa.Column('answer_as_query', sa.VARCHAR(), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('id', name='questions_pkey'), postgresql_ignore_search_path=False ) op.create_table('tests', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('question_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('time_started', postgresql.TIMESTAMP(), server_default=sa.text('now()'), autoincrement=False, nullable=False), sa.Column('time_submitted', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('user_submitted_query', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('result', sa.SMALLINT(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['question_id'], ['questions.id'], name='tests_question_id_fkey', ondelete='CASCADE'), sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='tests_user_id_fkey', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id', name='tests_pkey') ) op.drop_table('tests', schema='private') op.drop_table('users', schema='private') op.drop_table('questions', schema='private')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('rss', sa.Column('rss_id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('rss_link', sa.String(length=255), nullable=True), sa.Column('rss_title', sa.String(length=255), nullable=True, comment='订阅的标题'), sa.Column('rss_subtitle', sa.String(length=255), nullable=True), sa.Column('create_date', sa.DateTime(), nullable=False), sa.Column('rss_version', sa.String(length=10), nullable=True), sa.Column('rss_state', sa.SMALLINT(), nullable=True), sa.PrimaryKeyConstraint('rss_id'), sa.UniqueConstraint('rss_link') ) op.create_table('rss_content', sa.Column('content_id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('content_base', sa.String(length=255), nullable=True), sa.Column('content_link', sa.String(length=512), nullable=True), sa.Column('content_title', sa.String(length=255), nullable=True), sa.Column('content_description', sa.TEXT(), nullable=True), sa.Column('content_image_cover', sa.String(length=255), nullable=True), sa.Column('published_time', sa.DateTime(), nullable=True), sa.Column('create_date', sa.DateTime(), nullable=False), sa.Column('rss_id', sa.INTEGER(), nullable=True), sa.ForeignKeyConstraint(['rss_id'], ['rss.rss_id'], ), sa.PrimaryKeyConstraint('content_id'), sa.UniqueConstraint('content_link') )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('ip_info', 'lock_status', existing_type=sa.SMALLINT(), type_=mysql.CHAR(length=1), existing_nullable=True)
def downgrade(): op.add_column( 'post', sa.Column('pinned', sa.BOOLEAN(), autoincrement=False, nullable=False)) op.add_column( 'post', sa.Column('visibility', sa.SMALLINT(), autoincrement=False, nullable=False), ) op.add_column( 'post', sa.Column('message_html', sa.TEXT(), autoincrement=False, nullable=False), ) op.add_column( 'post', sa.Column('message_text', sa.TEXT(), autoincrement=False, nullable=False), ) op.drop_index(op.f('ix_post_visibility_state'), table_name='post') op.drop_index(op.f('ix_post_state'), table_name='post') op.drop_column('post', 'visibility_state') op.drop_column('post', 'url_id') op.drop_column('post', 'title') op.drop_column('post', 'name') op.drop_column('post', 'is_pinned') op.drop_column('post', 'body_text') op.drop_column('post', 'body_html')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('t_organization', sa.Column('id', sa.Integer(), nullable=False), sa.Column('serial_no', sa.String(length=32), nullable=True), sa.Column('grade', sa.String(length=20), nullable=True), sa.Column('academy', sa.String(length=64), nullable=True), sa.Column('major', sa.String(length=64), nullable=True), sa.Column('class_name', sa.String(length=64), nullable=True), sa.Column('remark', sa.String(length=128), nullable=True), sa.Column('create_time', sa.DATETIME(), nullable=False), sa.Column('update_time', sa.DATETIME(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('serial_no') ) op.create_table('t_student', sa.Column('id', sa.Integer(), nullable=False), sa.Column('id_card_no', sa.String(length=20), nullable=True), sa.Column('exam_no', sa.String(length=32), nullable=True), sa.Column('student_no', sa.String(length=24), nullable=True), sa.Column('name', sa.String(length=24), nullable=True), sa.Column('sex', sa.SMALLINT(), nullable=True), sa.Column('mobile', sa.String(length=11), nullable=True), sa.Column('teacher_name', sa.String(length=24), nullable=True), sa.Column('teacher_mobile', sa.String(length=11), nullable=True), sa.Column('dorm_no', sa.String(length=32), nullable=True), sa.Column('cloth_id', sa.Integer(), nullable=True), sa.Column('org_no', sa.String(length=32), nullable=True), sa.Column('remark', sa.String(length=128), nullable=True), sa.Column('create_time', sa.DATETIME(), nullable=False), sa.Column('update_time', sa.DATETIME(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id_card_no') )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('disorder_prediction_raw', 'data', existing_type=sa.Float(), type_=postgresql.ARRAY(sa.SMALLINT()), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('shopping_orders', sa.Column('plan_date_end', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True)) op.add_column('shopping_orders', sa.Column('plan_date_start', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True)) op.alter_column('shopping_orders', 'status', existing_type=sa.SMALLINT(), nullable=True) op.drop_column('shopping_orders', 'plan_forecast_days')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('user', sa.Column('role', sa.SMALLINT(), autoincrement=False, nullable=True)) op.drop_column('user', 'password') op.drop_column('user', 'confirmed_at') op.drop_column('user', 'active') op.drop_table('roles_users') op.drop_table('role')