def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('TrangThaiUser',
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('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.NCHAR(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.NCHAR(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.NCHAR(length=20), nullable=True),
sa.Column('email', sa.NCHAR(length=120), nullable=True),
sa.Column('password_hash', sa.NCHAR(length=128), nullable=True),
sa.Column('is_admin', sa.Boolean(), nullable=False),
sa.ForeignKeyConstraint(['trang_thai_user_id'], ['NhanSu.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('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'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'types', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.NVARCHAR(length=100), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'products', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('typeId', sa.Integer(), nullable=False),
sa.Column('name', sa.NVARCHAR(length=100), nullable=False),
sa.Column('description', sa.NVARCHAR(length=500), nullable=True),
sa.Column('photo', sa.NVARCHAR(length=100), nullable=True),
sa.ForeignKeyConstraint(
['typeId'],
['types.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_foreign_key(None, 'options', 'products', ['productId'], ['id'])
op.create_foreign_key(None, 'orders', 'products', ['productId'], ['id'])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('test', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('ten', sa.NVARCHAR(length=25), nullable=True),
sa.ForeignKeyConstraint(
['id'],
['NhanSu.User.id'],
), sa.PrimaryKeyConstraint('id'))
op.drop_table('sysdiagrams')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'User',
sa.Column('dantoc',
sa.NVARCHAR(length=20),
autoincrement=False,
nullable=True))
op.drop_column('User', 'dan_toc')
def test_mssql_nvarchar_length_downsize(self, writer):
with writer:
if 'odbc' not in writer.connection.engine.driver:
return
# Initialize a table with NVARCHAR(max), and make sure smaller data
# doesn't reduce the size of the column
metadata = sqlalchemy.MetaData()
create_sql = sqlalchemy.schema.CreateTable(
sqlalchemy.Table(
'mssql_nvarchar_length_downsize',
metadata,
sqlalchemy.Column('id',
sqlalchemy.NVARCHAR(length=100),
primary_key=True),
sqlalchemy.Column('some_data',
sqlalchemy.NVARCHAR(length=None)),
)).compile(writer.connection.engine)
metadata.create_all(writer.connection.engine)
writer.write_table(
TableSpec(
**{
'name':
'mssql_nvarchar_length',
'headings': ['id', 'some_data'],
'rows': [
[
'bizzle', (b'\0' *
800).decode('utf-8'), (
b'\0' * 800).decode('utf-8')
],
[
'bazzle', (b'\0' *
500).decode('utf-8'), (
b'\0' * 800).decode('utf-8')
],
]
}))
result = self._get_column_lengths(
writer.connection, 'mssql_nvarchar_length_downsize')
assert result['some_data'] == ('some_data', 'nvarchar', -1)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('CoSoDaoTao',
sa.Column('id', sa.SMALLINT(), nullable=False),
sa.Column('ten', sa.NVARCHAR(length=100), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='NhanSu')
op.create_table('TrinhDoNghiepVu',
sa.Column('id', sa.SMALLINT(), nullable=False),
sa.Column('ten', sa.NVARCHAR(length=20), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='NhanSu')
op.create_table('TrinhDoNghiepVuCanBo',
sa.Column('id', sa.SMALLINT(), nullable=False),
sa.Column('can_bo_id', sa.INTEGER(), nullable=True),
sa.Column('trinh_do_nghiep_vu_id',
sa.SMALLINT(),
nullable=True),
sa.Column('co_so_dao_tao_id', sa.SMALLINT(),
nullable=True),
sa.Column('chuyen_nganh',
sa.NVARCHAR(length=50),
nullable=True),
sa.Column('ngay_bat_dau', sa.DATE(), nullable=True),
sa.Column('ngay_ket_thuc', sa.DATE(), nullable=True),
sa.Column('ket_qua', sa.NVARCHAR(length=50),
nullable=True),
sa.Column('ghi_chu', sa.NVARCHAR(), nullable=True),
sa.ForeignKeyConstraint(
['can_bo_id'],
['NhanSu.CanBo.id'],
),
sa.ForeignKeyConstraint(
['co_so_dao_tao_id'],
['NhanSu.CoSoDaoTao.id'],
),
sa.ForeignKeyConstraint(
['trinh_do_nghiep_vu_id'],
['NhanSu.TrinhDoNghiepVu.id'],
),
sa.PrimaryKeyConstraint('id'),
schema='NhanSu')
class Album(Base):
__tablename__ = 'albums'
album_id = sa.Column('AlbumId', sa.Integer, primary_key=True)
title = sa.Column('Title', sa.NVARCHAR(160), nullable=False)
artist_id = sa.Column('ArtistId',
sa.ForeignKey('artists.ArtistId'),
nullable=False,
index=True)
artist = sa.orm.relationship('Artist')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
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')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
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(), autoincrement=True, nullable=False, mssql_identity_start=1, mssql_identity_increment=1),
sa.Column('version', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('definition', mssql.VARBINARY(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('diagram_id', name='PK__sysdiagr__C2B05B61856219B5')
)
op.drop_table('HeSoLuongUser', schema='NhanSu')
class GeographicNE(Base):
'''
classdocs
'''
__tablename__ = 'GeographicNE'
index = sqla.Column(sqla.Integer)
continent = sqla.Column(sqla.NVARCHAR(50))
gdp_md_est = sqla.Column(sqla.Float)
iso_a3 = sqla.Column(sqla.NVARCHAR(50), primary_key=True)
name = sqla.Column(sqla.NVARCHAR(50))
pop_est = sqla.Column(sqla.Float)
geometry = sqla.Column(Geometry("POLYGON"))
def __init__(self, params):
'''
Constructor
'''
def __repr__(self):
#"(id='%s', Date='%s', Type='%s', Value='%s')" % (self.id, self.Date, self.Type, self.Value)
return ""
class Track(Base):
__tablename__ = 'tracks'
track_id = sa.Column('TrackId', sa.Integer, primary_key=True)
name = sa.Column('Name', sa.NVARCHAR(200), nullable=False)
album_id = sa.Column('AlbumId', sa.ForeignKey('albums.AlbumId'), index=True)
media_type_id = sa.Column(
'MediaTypeId',
sa.ForeignKey('media_types.MediaTypeId'),
nullable=False,
index=True
)
genre_id = sa.Column('GenreId', sa.ForeignKey('genres.GenreId'), index=True)
composer = sa.Column('Composer', sa.NVARCHAR(220))
milliseconds = sa.Column('Milliseconds', sa.Integer, nullable=False)
bytes_size = sa.Column('Bytes', sa.Integer)
unit_price = sa.Column('UnitPrice', sa.Numeric(10, 2), nullable=False)
album = sa.orm.relationship('Album')
genre = sa.orm.relationship('Genre')
media_type = sa.orm.relationship('MediaType')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('ViTri',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('bo_phan_id', sa.Integer(), nullable=True),
sa.Column('cong_viec', sa.NVARCHAR(length=100), 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'], ['BoPhan.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['User.id'], ),
sa.PrimaryKeyConstraint('id')
)
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('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'], ['ChucDanhCongTac.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['User.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.drop_table('Dm_ChucDanhCongTac')
op.add_column('ChucDanhCongTac', sa.Column('ten', sa.NVARCHAR(length=100), nullable=True))
op.drop_constraint('FK__ChucDanhC__Chuc___0C85DE4D', 'ChucDanhCongTac', type_='foreignkey')
op.drop_constraint('FK__ChucDanhC__user___0B91BA14', 'ChucDanhCongTac', type_='foreignkey')
op.drop_column('ChucDanhCongTac', 'ngay_bat_dau')
op.drop_column('ChucDanhCongTac', 'Chuc_Danh_Cong_Tac_id')
op.drop_column('ChucDanhCongTac', 'user_id')
def best_type_for(self, val):
if isinstance(val, bool):
return sqlalchemy.Boolean()
elif isinstance(val, datetime.datetime):
return sqlalchemy.DateTime()
elif isinstance(val, datetime.date):
return sqlalchemy.Date()
if isinstance(val, int):
return sqlalchemy.Integer()
elif isinstance(val, six.string_types):
if self.is_postgres:
# PostgreSQL is the best; you can use TEXT everywhere and it works like a charm.
return sqlalchemy.UnicodeText(collation=self.collation)
elif self.is_mysql:
# MySQL cannot build an index on TEXT due to the lack of a field length, so we
# try to use VARCHAR when possible.
if len(
val
) < self.MAX_VARCHAR_LEN: # FIXME: Is 255 an interesting cutoff?
return sqlalchemy.Unicode(max(len(val),
self.MIN_VARCHAR_LEN),
collation=self.collation)
else:
return sqlalchemy.UnicodeText(collation=self.collation)
elif self.is_mssql:
# MSSQL (pre 2016) doesn't allow indices on columns longer than 900 bytes
# - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-index-transact-sql
# If any of our data is bigger than this, then set the column to NVARCHAR(max)
# `length` here is the size in bytes - https://docs.sqlalchemy.org/en/13/core/type_basics.html#sqlalchemy.types.String.params.length
length_in_bytes = len(val.encode('utf-8'))
column_length_in_bytes = None if length_in_bytes > 900 else 900
return sqlalchemy.NVARCHAR(length=column_length_in_bytes,
collation=self.collation)
if self.is_oracle:
return sqlalchemy.Unicode(4000, collation=self.collation)
else:
raise Exception("Unknown database dialect: {}".format(
self.db_url))
else:
# We do not have a name for "bottom" in SQL aka the type whose least upper bound
# with any other type is the other type.
return sqlalchemy.UnicodeText(collation=self.collation)
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 upgrade():
# ### commands auto generated by Alembic - please adjust! ###
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.drop_table('TrangThaiUser', schema='NhanSu')
op.add_column('User',
sa.Column('trang_thai_cong_tac_id',
sa.SMALLINT(),
nullable=True),
schema='NhanSu')
op.create_foreign_key(None,
'User',
'TrangThaiCongTac', ['trang_thai_cong_tac_id'],
['id'],
source_schema='NhanSu',
referent_schema='NhanSu')
op.drop_column('User', 'trang_thai_user_id', schema='NhanSu')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
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('CapBacUser',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('user_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(
['cap_bac_id'],
['NhanSu.CapBac.id'],
),
sa.ForeignKeyConstraint(
['user_id'],
['NhanSu.User.id'],
),
sa.PrimaryKeyConstraint('id'),
schema='NhanSu')
op.drop_table('sysdiagrams')
def best_type_for(self, val):
if isinstance(val, bool):
return sqlalchemy.Boolean()
elif isinstance(val, datetime.datetime):
return sqlalchemy.DateTime()
elif isinstance(val, datetime.date):
return sqlalchemy.Date()
if isinstance(val, int):
return sqlalchemy.Integer()
elif isinstance(val, six.string_types):
if self.is_postgres:
# PostgreSQL is the best; you can use TEXT everywhere and it works like a charm.
return sqlalchemy.UnicodeText(collation=self.collation)
elif self.is_mysql:
# MySQL cannot build an index on TEXT due to the lack of a field length, so we
# try to use VARCHAR when possible.
if len(
val
) < self.MAX_VARCHAR_LEN: # FIXME: Is 255 an interesting cutoff?
return sqlalchemy.Unicode(max(len(val),
self.MIN_VARCHAR_LEN),
collation=self.collation)
else:
return sqlalchemy.UnicodeText(collation=self.collation)
elif self.is_mssql:
return sqlalchemy.NVARCHAR(collation=self.collation)
if self.is_oracle:
return sqlalchemy.Unicode(4000, collation=self.collation)
else:
raise Exception("Unknown database dialect: {}".format(
self.db_url))
else:
# We do not have a name for "bottom" in SQL aka the type whose least upper bound
# with any other type is the other type.
return sqlalchemy.UnicodeText(collation=self.collation)
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.create_table(
'tblSQDetails',
sa.Column('DocEntry',
sa.INTEGER(),
autoincrement=False,
nullable=False),
sa.Column('DocNum', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('DocDate', sa.DATE(), autoincrement=False, nullable=True),
sa.Column('Cancelled',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('DocStatus',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('CardCode',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('CardName',
sa.NVARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('RowNum', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('ItemCode',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('ItemName',
sa.NVARCHAR(length=150),
autoincrement=False,
nullable=True),
sa.Column('Quantity',
sa.DECIMAL(precision=18, scale=4),
autoincrement=False,
nullable=True),
sa.Column('Warehouse',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Sales_Employee',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Sales_Contact',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Customer_Recipient',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Customer_Number',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isCEF_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isTruck_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isStock_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isPrice_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('SMSNotification',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Remarks',
sa.NVARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('Delivery_Date',
sa.NVARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('ManuallyClosed',
sa.NVARCHAR(length=10),
autoincrement=False,
nullable=True),
sa.Column('OpenQty',
sa.DECIMAL(precision=18, scale=4),
autoincrement=False,
nullable=True))
op.create_table(
'tblSODetails',
sa.Column('DocEntry',
sa.INTEGER(),
autoincrement=False,
nullable=False),
sa.Column('DocNum', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('DocDate', sa.DATE(), autoincrement=False, nullable=True),
sa.Column('Cancelled',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('DocStatus',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('CardCode',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('CardName',
sa.NVARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('RowNum', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('ItemCode',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('ItemName',
sa.NVARCHAR(length=150),
autoincrement=False,
nullable=True),
sa.Column('Quantity',
sa.DECIMAL(precision=18, scale=4),
autoincrement=False,
nullable=True),
sa.Column('Warehouse',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Sales_Employee',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Sales_Contact',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Customer_Recipient',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Customer_Number',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isCEF_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isTruck_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isStock_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isPrice_Approved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('SMSNotification',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Remarks',
sa.NVARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('Delivery_Date',
sa.NVARCHAR(length=250),
autoincrement=False,
nullable=True),
sa.Column('ManuallyClosed',
sa.NVARCHAR(length=10),
autoincrement=False,
nullable=True),
sa.Column('BaseQty',
sa.DECIMAL(precision=18, scale=4),
autoincrement=False,
nullable=True),
sa.Column('BaseDocNum',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.Column('BaseObjtype',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.Column('BaseDocEntry',
sa.INTEGER(),
autoincrement=False,
nullable=True))
op.create_table(
'tblSQ',
sa.Column('DocNum', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('DocDate', sa.DATE(), autoincrement=False, nullable=True),
sa.Column('CardCode',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('CardName',
sa.NVARCHAR(),
autoincrement=False,
nullable=True),
sa.Column('ItemCode',
sa.NVARCHAR(),
autoincrement=False,
nullable=True),
sa.Column('ItemName',
sa.NVARCHAR(length=150),
autoincrement=False,
nullable=True),
sa.Column('Quantity',
sa.DECIMAL(precision=18, scale=4),
autoincrement=False,
nullable=True),
sa.Column('warehouse',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isApproved',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('Sales_Employee',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isSent',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('cust_number',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('recipient',
sa.NVARCHAR(length=100),
autoincrement=False,
nullable=True),
sa.Column('isApprovedStock',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.Column('isApprovedTruck',
sa.NVARCHAR(length=50),
autoincrement=False,
nullable=True))
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 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.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():
op.add_column('data_species_check_list',
sa.Column('priority', sa.NVARCHAR(255), nullable=True))
op.add_column('data_habitats_check_list',
sa.Column('priority', sa.NVARCHAR(255), nullable=True))
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')
lambda v: f"TIMESTAMP {repr(str(v))}",
),
(
sqlalchemy.DATETIME,
datetime.datetime(2021, 2, 3, 4, 5, 8, 123456),
"DATETIME",
dtrepr,
),
(sqlalchemy.DATE, datetime.date(2021, 2, 4), "DATE", dtrepr),
(sqlalchemy.TIME, datetime.time(4, 5, 7, 123456), "TIME", dtrepr),
(sqlalchemy.TIME, datetime.time(4, 5, 7), "TIME", dtrepr),
(sqlalchemy.TEXT, "myTEXT", "STRING", repr),
(sqlalchemy.VARCHAR, "myVARCHAR", "STRING", repr),
(sqlalchemy.NVARCHAR, "myNVARCHAR", "STRING", repr),
(sqlalchemy.VARCHAR(42), "myVARCHAR", "STRING(42)", repr),
(sqlalchemy.NVARCHAR(42), "myNVARCHAR", "STRING(42)", repr),
(sqlalchemy.CHAR, "myCHAR", "STRING", repr),
(sqlalchemy.NCHAR, "myNCHAR", "STRING", repr),
(sqlalchemy.BINARY, b"myBINARY", "BYTES", repr),
(sqlalchemy.VARBINARY, b"myVARBINARY", "BYTES", repr),
(sqlalchemy.VARBINARY(42), b"myVARBINARY", "BYTES(42)", repr),
(sqlalchemy.BOOLEAN, False, "BOOL", "false"),
(sqlalchemy.ARRAY(sqlalchemy.Integer), [1, 2, 3], "ARRAY<INT64>", repr),
(
sqlalchemy.ARRAY(sqlalchemy.DATETIME),
[
datetime.datetime(2021, 2, 3, 4, 5, 6),
datetime.datetime(2021, 2, 3, 4, 5, 7, 123456),
datetime.datetime(2021, 2, 3, 4, 5, 8, 123456),
],
"ARRAY<DATETIME>",
class Genre(Base):
__tablename__ = 'genres'
genre_id = sa.Column('GenreId', sa.Integer, primary_key=True)
name = sa.Column('Name', sa.NVARCHAR(120))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('ChucDanhNghiepVu',
sa.Column('id', sa.SMALLINT(), nullable=False),
sa.Column('ten', sa.NVARCHAR(length=100), nullable=True),
sa.PrimaryKeyConstraint('id'))
