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 markets_table(metadata): return sa.Table( MARKETS, metadata, sa.Column(ID, sa.INTEGER, primary_key=True, nullable=False), sa.Column(NAME, sa.NCHAR(10), nullable=False), )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('User', sa.Column('nam_gioi', sa.NCHAR(length=1), autoincrement=False, nullable=True), schema='NhanSu') op.drop_column('User', 'gioi_tinh', schema='NhanSu')
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( 'Student', sa.Column('sname', sa.NCHAR(length=10), autoincrement=False, nullable=False), sa.Column('sex', sa.NCHAR(length=2), autoincrement=False, nullable=False), sa.Column('bir', sa.DATETIME(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('sname', name=u'PK__Student__0F1ED58278C86C61')) op.create_table( 'sysdiagrams', sa.Column('name', sa.NVARCHAR(length=128), autoincrement=False, nullable=False), sa.Column('principal_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('diagram_id', sa.INTEGER(), nullable=False), sa.Column('version', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('definition', mssql.VARBINARY(length='max'), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('diagram_id', name=u'PK__sysdiagr__C2B05B618078E22A')) op.create_table( 'Table1', sa.Column('id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('name', sa.NCHAR(length=10), autoincrement=False, nullable=True)) op.drop_index(op.f('ix_users_username'), table_name='users') op.drop_table('users') op.drop_table('roles')
def assets_table(metadata): bundle_id_fk = sa.ForeignKey(BUNDLES + '.' + ID) return sa.Table( ASSETS, metadata, sa.Column(ID, sa.INTEGER, primary_key=True, nullable=False), sa.Column(BUNDLE_ID, sa.INTEGER, bundle_id_fk, nullable=False), sa.Column(NAME, sa.NCHAR(10), nullable=False), sa.Column(ORDER_ID, sa.INTEGER, nullable=False), )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### 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('dan_toc', 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('noi_o', sa.NVARCHAR(length=100), nullable=True), sa.Column('so_hieu', sa.String(length=6), nullable=True), sa.Column('ngay_vao_cong_an', 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.Column('is_admin', sa.Boolean(), nullable=False), sa.ForeignKeyConstraint( ['trang_thai_user_id'], ['TrangThaiUser.id'], ), sa.PrimaryKeyConstraint('id'), schema='nhansu') op.create_index(op.f('ix_nhansu_User_email'), 'User', ['email'], unique=True, schema='nhansu') op.create_index(op.f('ix_nhansu_User_ten'), 'User', ['ten'], unique=False, schema='nhansu') op.create_index(op.f('ix_nhansu_User_username'), 'User', ['username'], unique=True, schema='nhansu') op.drop_index('ix_User_ten', table_name='User') op.drop_table('User') op.drop_constraint('FK__ChucDanhC__user___245D67DE', 'ChucDanhCongTacUser', type_='foreignkey') op.create_foreign_key(None, 'ChucDanhCongTacUser', 'User', ['user_id'], ['id'], referent_schema='nhansu') op.drop_constraint('FK__ChucDanhN__user___2A164134', 'ChucDanhNghiepVuUser', type_='foreignkey') op.create_foreign_key(None, 'ChucDanhNghiepVuUser', 'User', ['user_id'], ['id'], referent_schema='nhansu') op.drop_constraint('FK__SoDienTho__user___66603565', 'SoDienThoai', type_='foreignkey') op.create_foreign_key(None, 'SoDienThoai', 'User', ['user_id'], ['id'], referent_schema='nhansu') op.drop_constraint('FK__ViTri__user_id__6A30C649', 'ViTri', type_='foreignkey') op.create_foreign_key(None, 'ViTri', 'User', ['user_id'], ['id'], referent_schema='nhansu')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'ViTri', type_='foreignkey') op.create_foreign_key('FK__ViTri__user_id__6A30C649', 'ViTri', 'User', ['user_id'], ['id']) op.drop_constraint(None, 'SoDienThoai', type_='foreignkey') op.create_foreign_key('FK__SoDienTho__user___66603565', 'SoDienThoai', 'User', ['user_id'], ['id']) op.drop_constraint(None, 'ChucDanhNghiepVuUser', type_='foreignkey') op.create_foreign_key('FK__ChucDanhN__user___2A164134', 'ChucDanhNghiepVuUser', 'User', ['user_id'], ['id']) op.drop_constraint(None, 'ChucDanhCongTacUser', type_='foreignkey') op.create_foreign_key('FK__ChucDanhC__user___245D67DE', 'ChucDanhCongTacUser', 'User', ['user_id'], ['id']) op.create_table( 'User', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('ho_dem', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), sa.Column('ten', sa.NVARCHAR(length=15), autoincrement=False, nullable=True), sa.Column('ngay_sinh', sa.DATE(), autoincrement=False, nullable=True), sa.Column('nam_gioi', sa.NCHAR(length=1), autoincrement=False, nullable=True), sa.Column('nhom_mau', sa.VARCHAR(length=10, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), sa.Column('dan_toc', sa.NVARCHAR(length=20), autoincrement=False, nullable=True), sa.Column('que', sa.NVARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('dktt', sa.NVARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('noi_o', sa.NVARCHAR(length=100), autoincrement=False, nullable=True), sa.Column('so_hieu', sa.VARCHAR(length=6, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), sa.Column('ngay_vao_cong_an', sa.DATE(), autoincrement=False, nullable=True), sa.Column('nganh_ngoai', mssql.BIT(), autoincrement=False, nullable=True), sa.Column('trinh_do_chinh_tri', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), sa.Column('trinh_do_ngoai_ngu', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), sa.Column('trinh_do_tin_hoc', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), sa.Column('trang_thai_user_id', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('username', sa.VARCHAR(length=20, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), sa.Column('email', sa.VARCHAR(length=120, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), sa.Column('password_hash', sa.VARCHAR(length=128, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), sa.Column('is_admin', mssql.BIT(), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['trang_thai_user_id'], ['TrangThaiUser.id'], name='FK__User__trang_thai__656C112C'), sa.PrimaryKeyConstraint('id', name='PK__User__3213E83F405FB3BD')) op.create_index('ix_User_ten', 'User', ['ten'], unique=False) op.drop_index(op.f('ix_nhansu_User_username'), table_name='User', schema='nhansu') op.drop_index(op.f('ix_nhansu_User_ten'), table_name='User', schema='nhansu') op.drop_index(op.f('ix_nhansu_User_email'), table_name='User', schema='nhansu') op.drop_table('User', schema='nhansu')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('BoPhan', sa.Column('id', sa.SMALLINT(), 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'), schema='NhanSu') op.create_table('ChucDanhCongTac', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhNghiepVu', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhTuPhap', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') 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('dan_toc', 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('noi_o', sa.NVARCHAR(length=100), nullable=True), sa.Column('so_hieu', sa.String(length=6), nullable=True), sa.Column('ngay_vao_cong_an', 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.Column('is_admin', sa.Boolean(), nullable=False), sa.ForeignKeyConstraint( ['trang_thai_user_id'], ['TrangThaiUser.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_index(op.f('ix_NhanSu_User_email'), 'User', ['email'], unique=True, schema='NhanSu') op.create_index(op.f('ix_NhanSu_User_ten'), 'User', ['ten'], unique=False, schema='NhanSu') op.create_index(op.f('ix_NhanSu_User_username'), 'User', ['username'], unique=True, schema='NhanSu') op.create_table('ChucDanhCongTacUser', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('chuc_danh_cong_tac_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['chuc_danh_cong_tac_id'], ['NhanSu.ChucDanhCongTac.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['NhanSu.User.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhNghiepVuUser', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('chuc_danh_nghiep_vu_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['chuc_danh_nghiep_vu_id'], ['NhanSu.ChucDanhNghiepVu.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['NhanSu.User.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhTuPhapUser', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('chuc_danh_tu_phap_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.Column('ngay_ket_thuc', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['chuc_danh_tu_phap_id'], ['NhanSu.ChucDanhTuPhap.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['NhanSu.User.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') 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'], ['NhanSu.User.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ViTri', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('bo_phan_id', sa.SMALLINT(), nullable=False), sa.Column('cong_viec', sa.NVARCHAR(length=255), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.Column('ngay_ket_thuc', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['bo_phan_id'], ['NhanSu.BoPhan.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['NhanSu.User.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('BoPhan', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=50), nullable=False), sa.Column('ma', sa.VARCHAR(length=3), nullable=True), sa.Column('khoi', sa.VARCHAR(length=20), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('CapBac', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhCongTac', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhNghiepVu', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhTuPhap', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('GiayTo', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('HinhThucKhenThuong', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=100), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('NhomViTri', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=250), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('PltdTapThe', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('nam', sa.SMALLINT(), nullable=True), sa.Column('phan_loai', sa.NVARCHAR(length=100), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('TrangThaiCongTac', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('ten', sa.NVARCHAR(length=25), nullable=True), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('User', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('username', sa.VARCHAR(length=20), nullable=True), sa.Column('email', sa.VARCHAR(length=120), nullable=True), sa.Column('password_hash', sa.VARCHAR(length=128), nullable=True), sa.Column('is_admin', sa.Boolean(), nullable=False), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_index(op.f('ix_NhanSu_User_email'), 'User', ['email'], unique=True, schema='NhanSu') op.create_index(op.f('ix_NhanSu_User_username'), 'User', ['username'], unique=True, schema='NhanSu') op.create_table('CanBo', 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('gioi_tinh', sa.NCHAR(length=1), nullable=True), sa.Column('nhom_mau', sa.VARCHAR(length=10), nullable=True), sa.Column('dan_toc', 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('noi_o', sa.NVARCHAR(length=100), nullable=True), sa.Column('so_hieu', sa.VARCHAR(length=6), nullable=True), sa.Column('ngay_vao_cong_an', 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_cong_tac_id', sa.SMALLINT(), nullable=True), sa.ForeignKeyConstraint( ['trang_thai_cong_tac_id'], ['NhanSu.TrangThaiCongTac.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_index(op.f('ix_NhanSu_CanBo_ten'), 'CanBo', ['ten'], unique=False, schema='NhanSu') op.create_table('KhenThuongTapThe', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('ten_tap_the', sa.NVARCHAR(), nullable=True), sa.Column('hinh_thuc_khen_thuong_id', sa.SMALLINT(), nullable=True), sa.Column('so_quyet_dinh', sa.NVARCHAR(length=50), nullable=True), sa.Column('ngay_quyet_dinh', sa.DATE(), nullable=True), sa.Column('don_vi_khen', sa.NVARCHAR(length=250), nullable=True), sa.Column('noi_dung', sa.NVARCHAR(length=250), nullable=True), sa.Column('so_tien', sa.INTEGER(), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.ForeignKeyConstraint( ['hinh_thuc_khen_thuong_id'], ['NhanSu.HinhThucKhenThuong.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('CapBacCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('cap_bac_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint( ['cap_bac_id'], ['NhanSu.CapBac.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhCongTacCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('chuc_danh_cong_tac_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint( ['chuc_danh_cong_tac_id'], ['NhanSu.ChucDanhCongTac.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhNghiepVuCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('chuc_danh_nghiep_vu_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint( ['chuc_danh_nghiep_vu_id'], ['NhanSu.ChucDanhNghiepVu.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ChucDanhTuPhapCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('chuc_danh_tu_phap_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.Column('ngay_ket_thuc', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint( ['chuc_danh_tu_phap_id'], ['NhanSu.ChucDanhTuPhap.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('DangDoanThe', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('ngay_vao_dang_lan_dau', sa.DATE(), nullable=True), sa.Column('ngay_vao_dang_chinh_thuc', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('GiayToCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('giay_to_id', sa.SMALLINT(), nullable=True), sa.Column('so', sa.NVARCHAR(length=50), nullable=True), sa.Column('ngay_cap', sa.DATE(), nullable=True), sa.Column('tinh_trang', sa.NVARCHAR(length=30), nullable=True), sa.Column('loai_cap', sa.NVARCHAR(length=30), nullable=True), sa.Column('ngay_thu', sa.DATE(), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint( ['giay_to_id'], ['NhanSu.GiayTo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('HeSoLuongCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('he_so', sa.DECIMAL(precision=4, scale=2), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('KhenThuongCaNhan', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('hinh_thuc_khen_thuong_id', sa.SMALLINT(), nullable=True), sa.Column('so_quyet_dinh', sa.NVARCHAR(length=50), nullable=True), sa.Column('ngay_quyet_dinh', sa.DATE(), nullable=True), sa.Column('don_vi_khen', sa.NVARCHAR(length=250), nullable=True), sa.Column('noi_dung', sa.NVARCHAR(length=250), nullable=True), sa.Column('so_tien', sa.INTEGER(), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint( ['hinh_thuc_khen_thuong_id'], ['NhanSu.HinhThucKhenThuong.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('KiLuat', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('hinh_thuc', sa.NVARCHAR(), nullable=True), sa.Column('so_quyet_dinh', sa.NVARCHAR(length=50), nullable=True), sa.Column('ngay_quyet_dinh', sa.DATE(), nullable=True), sa.Column('noi_dung', sa.NVARCHAR(length=250), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('PlcbTheoNam', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('nam', sa.SMALLINT(), nullable=True), sa.Column('phan_loai', sa.NVARCHAR(length=50), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('PltdCaNhanTheoNam', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('nam', sa.SMALLINT(), nullable=True), sa.Column('phan_loai', sa.NVARCHAR(length=5), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('PltdCaNhanTheoThang', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('thang', sa.DATE(), nullable=True), sa.Column('phan_loai', sa.NVARCHAR(length=5), nullable=True), sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('SoDienThoai', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=True), sa.Column('so_dien_thoai', sa.VARCHAR(length=10), nullable=True), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu') op.create_table('ViTri', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.INTEGER(), nullable=False), sa.Column('bo_phan_id', sa.SMALLINT(), nullable=False), sa.Column('cong_viec', sa.NVARCHAR(length=255), nullable=True), sa.Column('nhom_vi_tri_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.Column('ngay_ket_thuc', sa.DATE(), nullable=True), sa.ForeignKeyConstraint( ['bo_phan_id'], ['NhanSu.BoPhan.id'], ), sa.ForeignKeyConstraint( ['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint( ['nhom_vi_tri_id'], ['NhanSu.NhomViTri.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('CanBo', 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('gioi_tinh', sa.NCHAR(length=1), nullable=True), sa.Column('nhom_mau', sa.VARCHAR(length=10), nullable=True), sa.Column('dan_toc', 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('noi_o', sa.NVARCHAR(length=100), nullable=True), sa.Column('so_hieu', sa.VARCHAR(length=6), nullable=True), sa.Column('ngay_vao_cong_an', 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_cong_tac_id', sa.SMALLINT(), nullable=True), sa.ForeignKeyConstraint(['trang_thai_cong_tac_id'], ['NhanSu.TrangThaiCongTac.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu' ) op.create_index(op.f('ix_NhanSu_CanBo_ten'), 'CanBo', ['ten'], unique=False, schema='NhanSu') op.create_table('CapBacCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.Integer(), nullable=True), sa.Column('cap_bac_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint(['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint(['cap_bac_id'], ['NhanSu.CapBac.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu' ) op.create_table('ChucDanhCongTacCanBo', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('can_bo_id', sa.Integer(), nullable=True), sa.Column('chuc_danh_cong_tac_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint(['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint(['chuc_danh_cong_tac_id'], ['NhanSu.ChucDanhCongTac.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu' ) op.create_table('ChucDanhNghiepVuCanBo', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('can_bo_id', sa.Integer(), nullable=True), sa.Column('chuc_danh_nghiep_vu_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint(['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint(['chuc_danh_nghiep_vu_id'], ['NhanSu.ChucDanhNghiepVu.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu' ) op.create_table('ChucDanhTuPhapCanBo', sa.Column('id', sa.SMALLINT(), nullable=False), sa.Column('can_bo_id', sa.Integer(), nullable=True), sa.Column('chuc_danh_tu_phap_id', sa.SMALLINT(), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.Column('ngay_ket_thuc', sa.DATE(), nullable=True), sa.ForeignKeyConstraint(['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.ForeignKeyConstraint(['chuc_danh_tu_phap_id'], ['NhanSu.ChucDanhTuPhap.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu' ) op.create_table('HeSoLuongCanBo', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('can_bo_id', sa.Integer(), nullable=True), sa.Column('he_so', sa.DECIMAL(precision=4, scale=2), nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), nullable=True), sa.ForeignKeyConstraint(['can_bo_id'], ['NhanSu.CanBo.id'], ), sa.PrimaryKeyConstraint('id'), schema='NhanSu' ) op.drop_table('ChucDanhCongTacUser', schema='NhanSu') op.drop_table('CapBacUser', schema='NhanSu') op.drop_table('ChucDanhNghiepVuUser', schema='NhanSu') op.drop_table('ChucDanhTuPhapUser', schema='NhanSu') op.drop_table('HeSoLuongUser', schema='NhanSu') op.add_column('SoDienThoai', sa.Column('can_bo_id', sa.Integer(), nullable=True), schema='NhanSu') op.drop_constraint('FK__SoDienTho__user___44CA3770', 'SoDienThoai', schema='NhanSu', type_='foreignkey') op.create_foreign_key(None, 'SoDienThoai', 'CanBo', ['can_bo_id'], ['id'], source_schema='NhanSu', referent_schema='NhanSu') op.drop_column('SoDienThoai', 'user_id', schema='NhanSu') op.drop_index('ix_NhanSu_User_ten', table_name='User', schema='NhanSu') op.drop_constraint('FK__User__trang_thai__2FCF1A8A', 'User', schema='NhanSu', type_='foreignkey') op.drop_column('User', 'so_hieu', schema='NhanSu') op.drop_column('User', 'nganh_ngoai', schema='NhanSu') op.drop_column('User', 'ngay_vao_cong_an', schema='NhanSu') op.drop_column('User', 'trinh_do_tin_hoc', schema='NhanSu') op.drop_column('User', 'trang_thai_cong_tac_id', schema='NhanSu') op.drop_column('User', 'ho_dem', schema='NhanSu') op.drop_column('User', 'dktt', schema='NhanSu') op.drop_column('User', 'dan_toc', schema='NhanSu') op.drop_column('User', 'ngay_sinh', schema='NhanSu') op.drop_column('User', 'ten', schema='NhanSu') op.drop_column('User', 'trinh_do_ngoai_ngu', schema='NhanSu') op.drop_column('User', 'trinh_do_chinh_tri', schema='NhanSu') op.drop_column('User', 'gioi_tinh', schema='NhanSu') op.drop_column('User', 'nhom_mau', schema='NhanSu') op.drop_column('User', 'que', schema='NhanSu') op.drop_column('User', 'noi_o', schema='NhanSu') op.add_column('ViTri', sa.Column('can_bo_id', sa.Integer(), nullable=False), schema='NhanSu') op.drop_constraint('FK__ViTri__user_id__489AC854', 'ViTri', schema='NhanSu', type_='foreignkey') op.create_foreign_key(None, 'ViTri', 'CanBo', ['can_bo_id'], ['id'], source_schema='NhanSu', referent_schema='NhanSu') op.drop_column('ViTri', 'user_id', schema='NhanSu')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('ViTri', sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False), schema='NhanSu') op.drop_constraint(None, 'ViTri', schema='NhanSu', type_='foreignkey') op.create_foreign_key('FK__ViTri__user_id__489AC854', 'ViTri', 'User', ['user_id'], ['id'], source_schema='NhanSu', referent_schema='NhanSu') op.drop_column('ViTri', 'can_bo_id', schema='NhanSu') op.add_column('User', sa.Column('noi_o', sa.NVARCHAR(length=100), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('que', sa.NVARCHAR(length=100), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('nhom_mau', sa.VARCHAR(length=10, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('gioi_tinh', sa.NCHAR(length=1), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('trinh_do_chinh_tri', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('trinh_do_ngoai_ngu', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('ten', sa.NVARCHAR(length=15), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('ngay_sinh', sa.DATE(), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('dan_toc', sa.NVARCHAR(length=20), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('dktt', sa.NVARCHAR(length=100), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('ho_dem', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('trang_thai_cong_tac_id', sa.SMALLINT(), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('trinh_do_tin_hoc', sa.NVARCHAR(length=30), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('ngay_vao_cong_an', sa.DATE(), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('nganh_ngoai', mssql.BIT(), autoincrement=False, nullable=True), schema='NhanSu') op.add_column('User', sa.Column('so_hieu', sa.VARCHAR(length=6, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), schema='NhanSu') op.create_foreign_key('FK__User__trang_thai__2FCF1A8A', 'User', 'TrangThaiCongTac', ['trang_thai_cong_tac_id'], ['id'], source_schema='NhanSu', referent_schema='NhanSu') op.create_index('ix_NhanSu_User_ten', 'User', ['ten'], unique=False, schema='NhanSu') op.add_column('SoDienThoai', sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), schema='NhanSu') op.drop_constraint(None, 'SoDienThoai', schema='NhanSu', type_='foreignkey') op.create_foreign_key('FK__SoDienTho__user___44CA3770', 'SoDienThoai', 'User', ['user_id'], ['id'], source_schema='NhanSu', referent_schema='NhanSu') op.drop_column('SoDienThoai', 'can_bo_id', schema='NhanSu') op.create_table('HeSoLuongUser', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('he_so', sa.DECIMAL(precision=4, scale=2), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['user_id'], ['NhanSu.User.id'], name='FK__HeSoLuong__user___41EDCAC5'), sa.PrimaryKeyConstraint('id', name='PK__HeSoLuon__3213E83F3D9EB5CD'), schema='NhanSu' ) op.create_table('ChucDanhTuPhapUser', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('chuc_danh_tu_phap_id', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.Column('ngay_ket_thuc', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['chuc_danh_tu_phap_id'], ['NhanSu.ChucDanhTuPhap.id'], name='FK__ChucDanhT__chuc___3E1D39E1'), sa.ForeignKeyConstraint(['user_id'], ['NhanSu.User.id'], name='FK__ChucDanhT__user___3F115E1A'), sa.PrimaryKeyConstraint('id', name='PK__ChucDanh__3213E83F44920B68'), schema='NhanSu' ) op.create_table('ChucDanhNghiepVuUser', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('chuc_danh_nghiep_vu_id', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['chuc_danh_nghiep_vu_id'], ['NhanSu.ChucDanhNghiepVu.id'], name='FK__ChucDanhN__chuc___3A4CA8FD'), sa.ForeignKeyConstraint(['user_id'], ['NhanSu.User.id'], name='FK__ChucDanhN__user___3B40CD36'), sa.PrimaryKeyConstraint('id', name='PK__ChucDanh__3213E83F66F9C81E'), schema='NhanSu' ) op.create_table('CapBacUser', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('cap_bac_id', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['cap_bac_id'], ['NhanSu.CapBac.id'], name='FK__CapBacUse__cap_b__32AB8735'), sa.ForeignKeyConstraint(['user_id'], ['NhanSu.User.id'], name='FK__CapBacUse__user___339FAB6E'), sa.PrimaryKeyConstraint('id', name='PK__CapBacUs__3213E83F71EF910A'), schema='NhanSu' ) op.create_table('ChucDanhCongTacUser', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('chuc_danh_cong_tac_id', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['chuc_danh_cong_tac_id'], ['NhanSu.ChucDanhCongTac.id'], name='FK__ChucDanhC__chuc___367C1819'), sa.ForeignKeyConstraint(['user_id'], ['NhanSu.User.id'], name='FK__ChucDanhC__user___37703C52'), sa.PrimaryKeyConstraint('id', name='PK__ChucDanh__3213E83FB6B44B67'), schema='NhanSu' ) op.drop_table('HeSoLuongCanBo', schema='NhanSu') op.drop_table('ChucDanhTuPhapCanBo', schema='NhanSu') op.drop_table('ChucDanhNghiepVuCanBo', schema='NhanSu') op.drop_table('ChucDanhCongTacCanBo', schema='NhanSu') op.drop_table('CapBacCanBo', schema='NhanSu') op.drop_index(op.f('ix_NhanSu_CanBo_ten'), table_name='CanBo', schema='NhanSu') op.drop_table('CanBo', schema='NhanSu')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('ChucDanhNghiepVuUser', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('chuc_danh_nghiep_vu_id', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['chuc_danh_nghiep_vu_id'], ['ChucDanhNghiepVu.id'], name='FK__ChucDanhN__chuc___571DF1D5'), sa.ForeignKeyConstraint(['user_id'], ['nhansu.User.id'], name='FK__ChucDanhN__user___5812160E'), sa.PrimaryKeyConstraint('id', name='PK__ChucDanh__3213E83F467ECA3B') ) op.create_table('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__ChucDanh__3213E83F6438590F') ) op.create_table('ViTri', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('bo_phan_id', sa.SMALLINT(), autoincrement=False, nullable=False), sa.Column('cong_viec', sa.NVARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.Column('ngay_ket_thuc', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['bo_phan_id'], ['BoPhan.id'], name='FK__ViTri__bo_phan_i__5DCAEF64'), sa.ForeignKeyConstraint(['user_id'], ['nhansu.User.id'], name='FK__ViTri__user_id__5EBF139D'), sa.PrimaryKeyConstraint('id', name='PK__ViTri__3213E83FFA7F9022') ) op.create_table('SoDienThoai', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('so_dien_thoai', sa.NCHAR(length=10), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['user_id'], ['nhansu.User.id'], name='FK__SoDienTho__user___5AEE82B9'), sa.PrimaryKeyConstraint('id', name='PK__SoDienTh__3213E83F31D011AD') ) op.create_table('ChucDanhCongTacUser', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('chuc_danh_cong_tac_id', sa.SMALLINT(), autoincrement=False, nullable=True), sa.Column('ngay_bat_dau', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['chuc_danh_cong_tac_id'], ['ChucDanhCongTac.id'], name='FK__ChucDanhC__chuc___534D60F1'), sa.ForeignKeyConstraint(['user_id'], ['nhansu.User.id'], name='FK__ChucDanhC__user___5441852A'), sa.PrimaryKeyConstraint('id', name='PK__ChucDanh__3213E83F8C8ABA94') ) op.create_table('ChucDanhNghiepVu', 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__ChucDanh__3213E83F04F57BB6') ) op.create_table('BoPhan', sa.Column('id', sa.SMALLINT(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1), sa.Column('ten', sa.NVARCHAR(length=50), autoincrement=False, nullable=False), sa.Column('ma', sa.VARCHAR(length=3, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), sa.Column('khoi', sa.VARCHAR(length=20, collation='SQL_Latin1_General_CP1_CI_AS'), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id', name='PK__BoPhan__3213E83F93E28526') ) op.drop_table('ViTri', schema='nhansu') op.drop_table('SoDienThoai', schema='nhansu') op.drop_table('ChucDanhNghiepVuUser', schema='nhansu') op.drop_table('ChucDanhCongTacUser', schema='nhansu') op.drop_index(op.f('ix_nhansu_User_username'), table_name='User', schema='nhansu') op.drop_index(op.f('ix_nhansu_User_ten'), table_name='User', schema='nhansu') op.drop_index(op.f('ix_nhansu_User_email'), table_name='User', schema='nhansu') op.drop_table('User', schema='nhansu') op.drop_table('ChucDanhNghiepVu', schema='nhansu') op.drop_table('ChucDanhCongTac', schema='nhansu') op.drop_table('BoPhan', schema='nhansu')