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