def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'device', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('adb_sn', sa.VARCHAR(length=128), nullable=True),
sa.Column('constructor', sa.VARCHAR(length=64), nullable=True),
sa.Column('model', sa.VARCHAR(length=64), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('imei', sa.VARCHAR(length=128), nullable=True),
sa.Column('project_id', sa.INTEGER(), nullable=True),
sa.Column('status', sa.VARCHAR(length=128), nullable=True),
sa.ForeignKeyConstraint(
['project_id'],
[u'project.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index('ix_device_timestamp',
'device', ['timestamp'],
unique=False)
op.create_index('ix_device_imei', 'device', ['imei'], unique=1)
op.create_index('ix_device_adb_sn', 'device', ['adb_sn'], unique=1)
op.drop_index(op.f('ix_device_model_timestamp'), table_name='device_model')
op.drop_index(op.f('ix_device_model_imei'), table_name='device_model')
op.drop_index(op.f('ix_device_model_adb_sn'), table_name='device_model')
op.drop_table('device_model')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.execute("ALTER TABLE NodeState DROP PRIMARY KEY;")
op.drop_index('ix_NodeState_time', table_name='NodeState')
op.drop_index('ix_NodeState_seq_num', table_name='NodeState')
#op.drop_index('ix_NodeState_nodeId', table_name='NodeState')
op.alter_column('NodeState',
'time',
existing_type=sa.DATETIME(),
nullable=True)
op.alter_column('NodeState',
'seq_num',
existing_type=mysql.INTEGER(display_width=11),
nullable=True)
op.alter_column('NodeState',
'nodeId',
existing_type=mysql.INTEGER(display_width=11),
nullable=True)
#F**k this
#op.add_column('NodeState', sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False))
#op.create_primary_key(None, "NodeState", ["id"]) #Doesnt work complains about multiple PK's
op.execute(
"ALTER TABLE NodeState ADD COLUMN id INT NOT NULL AUTO_INCREMENT PRIMARY KEY"
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('news',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('type', sa.VARCHAR(length=140), nullable=False),
sa.Column('title', sa.VARCHAR(length=140), nullable=False),
sa.Column('author', sa.VARCHAR(length=140), nullable=False),
sa.Column('content', sa.VARCHAR(length=1000), nullable=False),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('title')
)
op.create_index('ix_news_timestamp', 'news', ['timestamp'], unique=False)
op.create_table('users',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('username', sa.VARCHAR(length=64), nullable=True),
sa.Column('email', sa.VARCHAR(length=120), nullable=True),
sa.Column('password_hash', sa.VARCHAR(length=128), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index('ix_users_username', 'users', ['username'], unique=1)
op.create_index('ix_users_email', 'users', ['email'], unique=1)
op.drop_index(op.f('ix_comments_timestamp'), table_name='comments')
op.drop_table('comments')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('Sensors', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=30), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_table('association',
sa.Column('Users_id', sa.INTEGER(), nullable=True),
sa.Column('Sensors_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['Sensors_id'],
['Sensors.id'],
), sa.ForeignKeyConstraint(
['Users_id'],
['Users.id'],
))
op.create_table('Readings', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('value', sa.VARCHAR(length=30), nullable=True),
sa.Column('unit', sa.VARCHAR(length=5), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('sensor_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['sensor_id'],
['Sensors.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index('ix_Readings_timestamp',
'Readings', ['timestamp'],
unique=False)
op.create_table(
'Users', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=120), nullable=True),
sa.Column('email', sa.VARCHAR(length=120), nullable=True),
sa.Column('priviledged', sa.BOOLEAN(), nullable=True),
sa.Column('password', sa.VARCHAR(length=30), nullable=True),
sa.CheckConstraint('priviledged IN (0, 1)'),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('name'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('user', schema=None) as batch_op:
batch_op.add_column(sa.Column('about_me', sa.VARCHAR(length=140), nullable=True))
op.create_table('timelog',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('user_id', sa.INTEGER(), nullable=True),
sa.Column('count', sa.INTEGER(), nullable=True),
sa.Column('activity', sa.VARCHAR(length=64), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], [u'user.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table(u'timelog', schema=None) as batch_op:
batch_op.create_index('ix_timelog_timestamp', ['timestamp'], unique=False)
batch_op.create_index('ix_timelog_activity', ['activity'], unique=False)
with op.batch_alter_table('activity_log', schema=None) as batch_op:
batch_op.drop_index(batch_op.f('ix_activity_log_username'))
batch_op.drop_index(batch_op.f('ix_activity_log_timestamp'))
batch_op.drop_index(batch_op.f('ix_activity_log_activity'))
op.drop_table('activity_log')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'track_library', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('artist', sa.VARCHAR(length=140), nullable=True),
sa.Column('album', sa.VARCHAR(length=140), nullable=True),
sa.Column('track', sa.VARCHAR(length=140), nullable=True),
sa.Column('filelocation', sa.VARCHAR(length=140), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('request_log', sa.Column('id',
sa.INTEGER(),
nullable=False),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('user_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index('ix_request_log_timestamp',
'request_log', ['timestamp'],
unique=False)
op.drop_index(op.f('ix_requests_timestamp'), table_name='requests')
op.drop_table('requests')
op.drop_table('tracks')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('course_material', schema=None) as batch_op:
batch_op.add_column(sa.Column('data', sa.BLOB(), nullable=True))
batch_op.drop_column('filename')
op.create_table(
'message_history', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('course_id', sa.INTEGER(), nullable=True),
sa.Column('receiver_id', sa.INTEGER(), nullable=True),
sa.Column('sender_id', sa.INTEGER(), nullable=True),
sa.Column('created_on', sa.DATETIME(), nullable=False),
sa.Column('message', sa.VARCHAR(length=1000), nullable=False),
sa.ForeignKeyConstraint(
['course_id'],
['course.id'],
), sa.ForeignKeyConstraint(
['receiver_id'],
['user.id'],
), sa.ForeignKeyConstraint(
['sender_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.drop_table('message')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('BlogTagAssociation',
sa.Column('Id', sa.INTEGER(), nullable=False),
sa.Column('BlogId', sa.INTEGER(), nullable=True),
sa.Column('TagId', sa.INTEGER(), nullable=True),
sa.Column('DateAddedUtc', sa.DATETIME(), nullable=False),
sa.ForeignKeyConstraint(
['BlogId'],
['BlogModel.Id'],
), sa.ForeignKeyConstraint(
['TagId'],
['TagModel.Id'],
), sa.PrimaryKeyConstraint('Id'))
op.create_table('TagModel', sa.Column('Id', sa.INTEGER(), nullable=False),
sa.Column('Tag', sa.VARCHAR(length=128), nullable=False),
sa.Column('DateAddedUtc', sa.DATETIME(), nullable=False),
sa.PrimaryKeyConstraint('Id'), sa.UniqueConstraint('Tag'))
op.create_table(
'UserModel', sa.Column('Id', sa.INTEGER(), nullable=False),
sa.Column('Username', sa.VARCHAR(length=32), nullable=False),
sa.Column('Salt', sa.VARCHAR(length=32), nullable=False),
sa.Column('Hash', sa.VARCHAR(length=128), nullable=False),
sa.Column('Token', sa.VARCHAR(length=32), nullable=True),
sa.Column('RegistrationDateUtc', sa.DATETIME(), nullable=True),
sa.Column('LoginDateUtc', sa.DATETIME(), nullable=True),
sa.Column('ExpiryDateUtc', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('Id'), sa.UniqueConstraint('Username'))
op.create_table(
'BlogModel', sa.Column('Id', sa.INTEGER(), nullable=False),
sa.Column('AuthorId', sa.INTEGER(), nullable=True),
sa.Column('Title', sa.VARCHAR(length=128), nullable=False),
sa.Column('Text', sa.TEXT(), nullable=True),
sa.Column('LastUpdateDateUtc', sa.DATETIME(), nullable=False),
sa.ForeignKeyConstraint(
['AuthorId'],
['UserModel.Id'],
), sa.PrimaryKeyConstraint('Id'))
op.drop_table('BlogTagAssociationTable')
op.drop_table('BlogModelTable')
op.drop_table('UserModelTable')
op.drop_table('TagModelTable')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'action_log', sa.Column('status', sa.Integer(), nullable=True),
sa.Column('created_time', sa.DATETIME(), nullable=True),
sa.Column('creater', sa.String(length=45), nullable=True),
sa.Column('modified_time', sa.DATETIME(), nullable=True),
sa.Column('modifier', sa.String(length=45), nullable=True),
sa.Column('id', sa.String(length=45), nullable=False),
sa.Column('action_name', sa.String(length=128), nullable=True),
sa.Column('client_ip', sa.String(length=128), nullable=True),
sa.Column('action_time', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'attach_resources', sa.Column('status', sa.Integer(), nullable=True),
sa.Column('created_time', sa.DATETIME(), nullable=True),
sa.Column('creater', sa.String(length=45), nullable=True),
sa.Column('modified_time', sa.DATETIME(), nullable=True),
sa.Column('modifier', sa.String(length=45), nullable=True),
sa.Column('id', sa.String(length=45), nullable=False),
sa.Column('attach_name', sa.String(length=255), nullable=True),
sa.Column('path', sa.Text(), nullable=True),
sa.Column('belong_type', sa.String(length=45), nullable=True),
sa.Column('belong_id', sa.String(length=45), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'user_group', sa.Column('status', sa.Integer(), nullable=True),
sa.Column('created_time', sa.DATETIME(), nullable=True),
sa.Column('creater', sa.String(length=45), nullable=True),
sa.Column('modified_time', sa.DATETIME(), nullable=True),
sa.Column('modifier', sa.String(length=45), nullable=True),
sa.Column('id', sa.String(length=45), nullable=False),
sa.Column('group_name', sa.String(length=64), nullable=True),
sa.Column('parent_id', sa.String(length=45), nullable=True),
sa.Column('comments', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('last_senn', sa.DATETIME(), nullable=True))
op.drop_column('user', 'last_seen')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('courses',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.Column('name', sa.String(length=100), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('token_blacklist',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('jti', sa.String(length=36), nullable=False),
sa.Column('token_type', sa.String(length=10), nullable=False),
sa.Column('user_id', mysql.INTEGER(), nullable=False),
sa.Column('revoked', sa.BOOLEAN(), nullable=False),
sa.Column('expires', sa.DATETIME(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('users',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.Column('nick_name', sa.String(length=20), nullable=True),
sa.Column('real_name', sa.String(length=20), nullable=True),
sa.Column('phone', sa.String(length=20), nullable=True),
sa.Column('email', sa.String(length=50), nullable=True),
sa.Column('pwhash', sa.String(length=200), nullable=True),
sa.Column('register_time', sa.DATETIME(), nullable=True),
sa.Column('roles', mysql.INTEGER(), nullable=True),
sa.Column('avatar', sa.String(length=200), nullable=True),
sa.Column('openid', sa.String(length=100), nullable=True),
sa.Column('session_key', sa.String(length=200), nullable=True),
sa.Column('gender', sa.BOOLEAN(), nullable=True),
sa.Column('language', sa.String(length=20), nullable=True),
sa.Column('city', sa.String(length=20), nullable=True),
sa.Column('province', sa.String(length=20), nullable=True),
sa.Column('country', sa.String(length=100), nullable=True),
sa.Column('validated', mysql.INTEGER(), nullable=True),
sa.Column('approve_time', sa.DATETIME(), nullable=True),
sa.Column('approver_id', mysql.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(['approver_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('classSessions',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('series_id', sa.String(length=200), nullable=True),
sa.Column('course_id', mysql.INTEGER(), nullable=True),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.Column('start_time', sa.DATETIME(), nullable=True),
sa.Column('duration', mysql.INTEGER(), nullable=True),
sa.Column('info', sa.String(length=500), nullable=True),
sa.Column('attendance_call', sa.BOOLEAN(), nullable=True),
sa.Column('attendance_teacher_id', mysql.INTEGER(), nullable=True),
sa.Column('attendance_time', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(['attendance_teacher_id'], ['users.id'], ),
sa.ForeignKeyConstraint(['course_id'], ['courses.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('modificationLog',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('operator', mysql.INTEGER(), nullable=True),
sa.Column('modification_time', sa.DATETIME(), nullable=True),
sa.Column('table', sa.String(length=50), nullable=True),
sa.Column('entry', mysql.INTEGER(), nullable=True),
sa.Column('column', sa.String(length=50), nullable=True),
sa.Column('original', sa.String(length=50), nullable=True),
sa.Column('new', sa.String(length=50), nullable=True),
sa.ForeignKeyConstraint(['operator'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('students',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.Column('real_name', sa.String(length=20), nullable=True),
sa.Column('dob', sa.DATETIME(), nullable=True),
sa.Column('gender', sa.BOOLEAN(), nullable=True),
sa.Column('creator_id', mysql.INTEGER(), nullable=True),
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('qr_code', sa.BLOB(), nullable=True),
sa.ForeignKeyConstraint(['creator_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('courseCreditAccounts',
sa.Column('account_no', mysql.INTEGER(), nullable=False),
sa.Column('student_id', mysql.INTEGER(), nullable=True),
sa.Column('course_id', mysql.INTEGER(), nullable=True),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.ForeignKeyConstraint(['course_id'], ['courses.id'], ),
sa.ForeignKeyConstraint(['student_id'], ['students.id'], ),
sa.PrimaryKeyConstraint('account_no')
)
op.create_table('parenthoods',
sa.Column('student_id', mysql.INTEGER(), nullable=False),
sa.Column('parent_id', mysql.INTEGER(), nullable=False),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.Column('relation', mysql.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(['parent_id'], ['users.id'], ),
sa.ForeignKeyConstraint(['student_id'], ['students.id'], ),
sa.PrimaryKeyConstraint('student_id', 'parent_id')
)
op.create_table('takingClasses',
sa.Column('session_id', mysql.INTEGER(), nullable=False),
sa.Column('student_id', mysql.INTEGER(), nullable=False),
sa.Column('attended', sa.BOOLEAN(), nullable=True),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.Column('comments', sa.String(length=500), nullable=True),
sa.ForeignKeyConstraint(['session_id'], ['classSessions.id'], ),
sa.ForeignKeyConstraint(['student_id'], ['students.id'], ),
sa.PrimaryKeyConstraint('session_id', 'student_id')
)
op.create_table('teachings',
sa.Column('session_id', mysql.INTEGER(), nullable=False),
sa.Column('teacher_id', mysql.INTEGER(), nullable=False),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.Column('comments', sa.String(length=500), nullable=True),
sa.Column('attended', sa.BOOLEAN(), nullable=True),
sa.ForeignKeyConstraint(['session_id'], ['classSessions.id'], ),
sa.ForeignKeyConstraint(['teacher_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('session_id', 'teacher_id')
)
op.create_table('courseCreditStatements',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('account_no', mysql.INTEGER(), nullable=True),
sa.Column('statement_time', sa.DATETIME(), nullable=False),
sa.Column('closing_balance', mysql.INTEGER(), nullable=False),
sa.Column('total_debit', mysql.INTEGER(), nullable=False),
sa.Column('total_credit', mysql.INTEGER(), nullable=False),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.ForeignKeyConstraint(['account_no'], ['courseCreditAccounts.account_no'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('courseCreditTransactions',
sa.Column('id', mysql.INTEGER(), nullable=False),
sa.Column('account_no', mysql.INTEGER(), nullable=True),
sa.Column('operator_id', mysql.INTEGER(), nullable=False),
sa.Column('time', sa.DATETIME(), nullable=False),
sa.Column('transaction_type', mysql.INTEGER(), nullable=False),
sa.Column('amount', mysql.INTEGER(unsigned=True), nullable=False),
sa.Column('comment', sa.String(length=200), nullable=True),
sa.Column('deleted', sa.BOOLEAN(), nullable=True),
sa.ForeignKeyConstraint(['account_no'], ['courseCreditAccounts.account_no'], ),
sa.ForeignKeyConstraint(['operator_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('tag', schema=None) as batch_op:
batch_op.add_column(sa.Column('timestamp', sa.DATETIME(), nullable=True))
batch_op.create_index('ix_tag_timestamp', ['timestamp'], unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
# *********************************
# xignite_security_headline schema
# *********************************
op.add_column(
'xignite_security_headline',
sa.Column('summary', mysql.TEXT(convert_unicode=True), nullable=True))
op.add_column('xignite_security_headline',
sa.Column('orig_pub_time', sa.DATETIME(), nullable=True))
op.add_column(
'xignite_security_headline',
sa.Column('orig_source',
mysql.TEXT(convert_unicode=True),
nullable=True))
op.add_column('xignite_security_headline',
sa.Column('details_proc_dur', sa.FLOAT(), nullable=True))
#
# Add source column to primary key
#
# Create temporary index on foreign key symbol before dropping primary key
# to work around bug in mysql; see http://bugs.mysql.com/bug.php?id=20525
op.create_index('symbol_temp_idx',
'xignite_security_headline', ['symbol'],
unique=False)
# Add source column to primary key
op.drop_constraint('primary', 'xignite_security_headline', type_='primary')
# `source` column was too big for primary key at 500 utf8 chars
op.alter_column('xignite_security_headline',
'source',
type_=mysql.VARCHAR(length=190),
existing_nullable=False)
op.create_primary_key('xignite_security_headline_pk',
'xignite_security_headline',
['symbol', 'local_pub_date', 'url', 'source'])
op.drop_index('symbol_temp_idx', 'xignite_security_headline')
#
# Add index on discovered_at column
#
op.create_index('discovered_at_idx',
'xignite_security_headline', ['discovered_at'],
unique=False)
# *********************************
# xignite_security_release schema
# *********************************
op.add_column(
'xignite_security_release',
sa.Column('summary', mysql.TEXT(convert_unicode=True), nullable=True))
op.add_column('xignite_security_release',
sa.Column('orig_pub_time', sa.DATETIME(), nullable=True))
op.add_column(
'xignite_security_release',
sa.Column('orig_source',
mysql.TEXT(convert_unicode=True),
nullable=True))
op.add_column('xignite_security_release',
sa.Column('details_proc_dur', sa.FLOAT(), nullable=True))
#
# Add source column to primary key
#
# Create temporary index on foreign key symbol before dropping primary key
# to work around bug in mysql; see http://bugs.mysql.com/bug.php?id=20525
op.create_index('symbol_temp_idx',
'xignite_security_release', ['symbol'],
unique=False)
op.drop_constraint('primary', 'xignite_security_release', type_='primary')
# `source` column was too big for primary key at 500 utf8 chars
op.alter_column('xignite_security_release',
'source',
type_=mysql.VARCHAR(length=190),
existing_nullable=False)
op.create_primary_key('xignite_security_release_pk',
'xignite_security_release',
['symbol', 'local_pub_date', 'url', 'source'])
op.drop_index('symbol_temp_idx', 'xignite_security_release')
#
# Add index on discovered_at column
#
op.create_index('discovered_at_idx',
'xignite_security_release', ['discovered_at'],
unique=False)
def upgrade():
"""Apply compare types between ORM and DB"""
conn = op.get_bind()
with op.batch_alter_table('connection', schema=None) as batch_op:
batch_op.alter_column(
'extra',
existing_type=sa.TEXT(),
type_=sa.Text(),
existing_nullable=True,
)
with op.batch_alter_table('log_template', schema=None) as batch_op:
batch_op.alter_column('created_at',
existing_type=sa.DateTime(),
type_=TIMESTAMP(),
existing_nullable=False)
with op.batch_alter_table('serialized_dag', schema=None) as batch_op:
# drop server_default
batch_op.alter_column(
'dag_hash',
existing_type=sa.String(32),
server_default=None,
type_=sa.String(32),
existing_nullable=False,
)
with op.batch_alter_table('trigger', schema=None) as batch_op:
batch_op.alter_column('created_date',
existing_type=sa.DateTime(),
type_=TIMESTAMP(),
existing_nullable=False)
if conn.dialect.name != 'sqlite':
return
with op.batch_alter_table('serialized_dag', schema=None) as batch_op:
batch_op.alter_column('fileloc_hash',
existing_type=sa.Integer,
type_=sa.BigInteger())
# Some sqlite date are not in db_types.TIMESTAMP. Convert these to TIMESTAMP.
with op.batch_alter_table('dag', schema=None) as batch_op:
batch_op.alter_column('last_pickled',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('last_expired',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('dag_pickle', schema=None) as batch_op:
batch_op.alter_column('created_dttm',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('dag_run', schema=None) as batch_op:
batch_op.alter_column('execution_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=False)
batch_op.alter_column('start_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('end_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('import_error', schema=None) as batch_op:
batch_op.alter_column('timestamp',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('job', schema=None) as batch_op:
batch_op.alter_column('start_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('end_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('latest_heartbeat',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('log', schema=None) as batch_op:
batch_op.alter_column('dttm',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('execution_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('serialized_dag', schema=None) as batch_op:
batch_op.alter_column('last_updated',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=False)
with op.batch_alter_table('sla_miss', schema=None) as batch_op:
batch_op.alter_column('execution_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=False)
batch_op.alter_column('timestamp',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('task_fail', schema=None) as batch_op:
batch_op.alter_column('start_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('end_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
with op.batch_alter_table('task_instance', schema=None) as batch_op:
batch_op.alter_column('start_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('end_date',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
batch_op.alter_column('queued_dttm',
existing_type=sa.DATETIME(),
type_=TIMESTAMP(),
existing_nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('kb_users', 'registered_on',
existing_type=sa.DATETIME(),
nullable=False,
existing_server_default=sa.text(u'CURRENT_TIMESTAMP'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('user', 'isAdmin')
op.add_column('table', sa.Column('timestamp', sa.DATETIME(),
nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('type',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('user_type', sa.VARCHAR(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('election',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('owner', sa.INTEGER(), nullable=True),
sa.Column('name_of_election', sa.VARCHAR(), nullable=False),
sa.Column('description', sa.VARCHAR(), nullable=True),
sa.Column('created_at', sa.DATETIME(), nullable=True),
sa.Column('modified_at', sa.DATETIME(), nullable=True),
sa.Column('date_of_election', sa.DATETIME(), nullable=True),
sa.Column('time_of_election', sa.DATETIME(), nullable=True),
sa.Column('link', sa.VARCHAR(), nullable=True),
sa.Column('status_id', sa.INTEGER(), nullable=False),
sa.Column('number_of_voters', sa.VARCHAR(), nullable=False),
sa.Column('password', sa.VARCHAR(), nullable=True),
sa.Column('user_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(['owner'], ['user.id'], ),
sa.ForeignKeyConstraint(['status_id'], ['status.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('election', schema=None) as batch_op:
batch_op.create_index('ix_election_time_of_election', ['time_of_election'], unique=False)
batch_op.create_index('ix_election_name_of_election', ['name_of_election'], unique=False)
batch_op.create_index('ix_election_date_of_election', ['date_of_election'], unique=False)
op.create_table('user',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('email', sa.VARCHAR(length=120), nullable=False),
sa.Column('user_type', sa.INTEGER(), nullable=False),
sa.Column('verified', sa.BOOLEAN(), nullable=True),
sa.CheckConstraint('verified IN (0, 1)'),
sa.ForeignKeyConstraint(['user_type'], ['type.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email')
)
op.create_table('vote',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('user_id', sa.INTEGER(), nullable=True),
sa.Column('election_id', sa.INTEGER(), nullable=False),
sa.Column('candidate_id', sa.INTEGER(), nullable=False),
sa.Column('password', sa.VARCHAR(), nullable=True),
sa.ForeignKeyConstraint(['candidate_id'], ['candidate.id'], ),
sa.ForeignKeyConstraint(['election_id'], ['election.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('candidate',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(), nullable=False),
sa.Column('image', sa.VARCHAR(), nullable=False),
sa.Column('bio', sa.TEXT(), nullable=True),
sa.Column('position', sa.VARCHAR(length=200), nullable=False),
sa.Column('election_id', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(['election_id'], ['election.id'], ),
sa.PrimaryKeyConstraint('id')
)
with op.batch_alter_table('candidate', schema=None) as batch_op:
batch_op.create_index('ix_candidate_name', ['name'], unique=False)
op.create_table('status',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('status', sa.VARCHAR(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user',
sa.Column('confirmed_on', sa.DATETIME(), nullable=True))
op.add_column('user', sa.Column('confirmed', sa.BOOLEAN(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('comment', schema=None) as batch_op:
batch_op.alter_column('modify_date',
existing_type=sa.DATETIME(),
nullable=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'abbonamenti', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('tipo',
sa.Enum('one', 'two', 'three', 'four', name='abbonamentot'),
nullable=True), sa.Column('costo', sa.REAL(), nullable=True),
sa.CheckConstraint('"costo" > 0'), sa.PrimaryKeyConstraint('id'))
op.create_table('giorni', sa.Column('data', sa.Date(), nullable=False),
sa.PrimaryKeyConstraint('data'))
op.create_table('salepesi', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('dimensione', sa.Integer(), nullable=True),
sa.CheckConstraint('"dimensione" > 0'),
sa.PrimaryKeyConstraint('id'))
op.create_table('stanze', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('dimensione', sa.Integer(), nullable=True),
sa.CheckConstraint('"dimensione" > 0'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'altri', sa.Column('id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['id'], ['utenti.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'clienti', sa.Column('id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['id'], ['utenti.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'istruttori', sa.Column('id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['id'], ['utenti.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'slot', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('personeMax', sa.Integer(), nullable=True),
sa.Column('giorno', sa.Date(), nullable=False),
sa.Column('oraInizio', sa.DateTime(), nullable=True),
sa.Column('oraFine', sa.DateTime(), nullable=True),
sa.CheckConstraint('"oraFine"> "oraInizio"'),
sa.ForeignKeyConstraint(['giorno'], ['giorni.data'],
ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'abbonati', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('abbonamento', sa.Integer(), nullable=False),
sa.Column('dataInizioAbbonamento', sa.Date(), nullable=True),
sa.Column('dataFineAbbonamento', sa.Date(), nullable=True),
sa.CheckConstraint('"dataFineAbbonamento" > "dataInizioAbbonamento"'),
sa.ForeignKeyConstraint(
['abbonamento'],
['abbonamenti.id'],
), sa.ForeignKeyConstraint(['id'], ['clienti.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'corsi', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('nome', sa.String(), nullable=True),
sa.Column('iscrittiMax', sa.Integer(), nullable=True),
sa.Column('istruttore', sa.Integer(), nullable=False),
sa.Column('stanza', sa.Integer(), nullable=False),
sa.CheckConstraint('"iscrittiMax" > 0'),
sa.ForeignKeyConstraint(
['istruttore'],
['istruttori.id'],
),
sa.ForeignKeyConstraint(['stanza'], ['stanze.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'nonabbonati', sa.Column('id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['id'], ['clienti.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'salepesislot', sa.Column('salaPesi', sa.Integer(), nullable=False),
sa.Column('slot', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['salaPesi'], ['salepesi.id'],
ondelete='cascade'),
sa.ForeignKeyConstraint(['slot'], ['slot.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('salaPesi', 'slot'))
op.create_table(
'corsislot', sa.Column('corso', sa.Integer(), nullable=False),
sa.Column('slot', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['corso'], ['corsi.id'], ondelete='cascade'),
sa.ForeignKeyConstraint(['slot'], ['slot.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('corso', 'slot'))
op.create_table(
'prenotazioni', sa.Column('abbonato', sa.Integer(), nullable=False),
sa.Column('slot', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['abbonato'], ['abbonati.id'],
ondelete='cascade'),
sa.ForeignKeyConstraint(['slot'], ['slot.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('abbonato', 'slot'))
op.create_table(
'sedute', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('corso', sa.Integer(), nullable=False),
sa.Column('dataSeduta', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(['corso'], ['corsi.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'abbonatisedute', sa.Column('abbonato', sa.Integer(), nullable=False),
sa.Column('seduta', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['abbonato'], ['abbonati.id'],
ondelete='cascade'),
sa.ForeignKeyConstraint(['seduta'], ['sedute.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('abbonato', 'seduta'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user',
sa.Column('member_since', sa.DATETIME(), nullable=True))
op.drop_constraint(None, 'user', type_='unique')
op.drop_column('user', 'last_name')
op.drop_column('user', 'first_name')
op.drop_column('user', 'email')
op.drop_column('user', 'creation_date')
op.create_table(
'flight', sa.Column('flight_num',
sa.VARCHAR(length=64),
nullable=False),
sa.Column('price', sa.FLOAT(), nullable=False),
sa.Column('airline_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('airplane_model', sa.VARCHAR(length=64), nullable=False),
sa.Column('airplane_id', sa.VARCHAR(length=64), nullable=False),
sa.Column('arrival', sa.VARCHAR(length=64), nullable=False),
sa.Column('departure', sa.VARCHAR(length=64), nullable=False),
sa.Column('arrival_date', sa.DATETIME(), nullable=False),
sa.Column('departure_date', sa.DATETIME(), nullable=False),
sa.ForeignKeyConstraint(
['airline_name'],
['airline_stock.airline_name'],
),
sa.ForeignKeyConstraint(
['airplane_id'],
['airline_stock.unique_id'],
),
sa.ForeignKeyConstraint(
['airplane_model'],
['airline_stock.model'],
), sa.ForeignKeyConstraint(
['arrival'],
['airport.name'],
), sa.ForeignKeyConstraint(
['departure'],
['airport.name'],
), sa.PrimaryKeyConstraint('flight_num', 'airline_name'))
op.create_table('airport',
sa.Column('name', sa.VARCHAR(length=64), nullable=False),
sa.Column('code', sa.VARCHAR(length=3), nullable=True),
sa.Column('city', sa.VARCHAR(length=64), nullable=True),
sa.Column('country', sa.VARCHAR(length=64), nullable=True),
sa.Column('latitude', sa.FLOAT(), nullable=True),
sa.Column('longitude', sa.FLOAT(), nullable=True),
sa.PrimaryKeyConstraint('name'),
sa.UniqueConstraint('code'))
op.create_table(
'airline_stock',
sa.Column('airline_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('model', sa.VARCHAR(length=3), nullable=False),
sa.Column('unique_id', sa.VARCHAR(length=64), nullable=False),
sa.ForeignKeyConstraint(
['airline_name'],
['airline.name'],
), sa.ForeignKeyConstraint(
['model'],
['airplane.id_num'],
), sa.PrimaryKeyConstraint('airline_name', 'model', 'unique_id'))
op.create_table(
'ticket', sa.Column('ticket_id', sa.VARCHAR(length=64),
nullable=False),
sa.Column('customer_email', sa.VARCHAR(length=64), nullable=False),
sa.Column('airline_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('flight_num', sa.VARCHAR(length=64), nullable=False),
sa.Column('booking_agent_ID', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['airline_name'],
['airline.name'],
),
sa.ForeignKeyConstraint(
['booking_agent_ID'],
['booking_agent.booking_agent_id'],
), sa.ForeignKeyConstraint(
['customer_email'],
['customer.email'],
), sa.ForeignKeyConstraint(
['flight_num'],
['flight.flight_num'],
), sa.PrimaryKeyConstraint('ticket_id'))
op.create_table('airline',
sa.Column('name', sa.VARCHAR(length=64), nullable=False),
sa.PrimaryKeyConstraint('name'))
op.create_table(
'Prescription',
sa.Column('medication', sa.VARCHAR(length=64), nullable=False),
sa.Column('date_prescribed', sa.DATETIME(), nullable=False),
sa.Column('date_expired', sa.DATETIME(), nullable=False),
sa.Column('description', sa.TEXT(), nullable=False),
sa.Column('patient_id', sa.INTEGER(), nullable=False),
sa.Column('physician_id', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['patient_id'],
['Patient.id'],
), sa.ForeignKeyConstraint(
['physician_id'],
['Physician.id'],
),
sa.PrimaryKeyConstraint('medication', 'date_prescribed', 'patient_id',
'physician_id'))
op.create_table(
'booking_agent', sa.Column('user_id', sa.INTEGER(), nullable=False),
sa.Column('booking_agent_id', sa.VARCHAR(length=64), nullable=False),
sa.Column('email', sa.VARCHAR(length=64), nullable=False),
sa.Column('password', sa.VARCHAR(length=64), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['user.user_id'],
), sa.PrimaryKeyConstraint('booking_agent_id'),
sa.UniqueConstraint('email'))
op.create_table('phone_number',
sa.Column('email', sa.VARCHAR(length=64), nullable=False),
sa.Column('number', sa.VARCHAR(length=64), nullable=False),
sa.ForeignKeyConstraint(
['email'],
['customer.email'],
), sa.PrimaryKeyConstraint('email', 'number'))
op.create_table(
'Hospital', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=64), nullable=False),
sa.Column('country', sa.VARCHAR(length=64), nullable=False),
sa.Column('state', sa.VARCHAR(length=64), nullable=False),
sa.Column('city', sa.VARCHAR(length=64), nullable=False),
sa.Column('zipcode', sa.VARCHAR(length=64), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'customer', sa.Column('user_id', sa.INTEGER(), nullable=False),
sa.Column('email', sa.VARCHAR(length=64), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('last_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('middle_name', sa.VARCHAR(length=64), nullable=True),
sa.Column('passport_num', sa.VARCHAR(length=64), nullable=False),
sa.Column('passport_expir', sa.DATE(), nullable=False),
sa.Column('passport_country', sa.VARCHAR(length=64), nullable=False),
sa.Column('date_of_birth', sa.DATE(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['user.user_id'],
), sa.PrimaryKeyConstraint('email'))
op.create_table(
'Room', sa.Column('room_number', sa.INTEGER(), nullable=False),
sa.Column('building', sa.VARCHAR(length=64), nullable=False),
sa.Column('hospital', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['hospital'],
['Hospital.name'],
), sa.PrimaryKeyConstraint('room_number'))
op.create_table(
'address', sa.Column('email', sa.VARCHAR(length=64), nullable=False),
sa.Column('building_num', sa.VARCHAR(length=64), nullable=False),
sa.Column('street', sa.VARCHAR(length=64), nullable=False),
sa.Column('city', sa.VARCHAR(length=64), nullable=False),
sa.Column('state', sa.VARCHAR(length=64), nullable=False),
sa.Column('zip_code', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['email'],
['customer.email'],
),
sa.PrimaryKeyConstraint('email', 'building_num', 'street', 'city',
'state', 'zip_code'))
op.create_table(
'Patient', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('last_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('email', sa.VARCHAR(length=64), nullable=False),
sa.Column('password', sa.VARCHAR(length=64), nullable=False),
sa.Column('ssn', sa.INTEGER(), nullable=False),
sa.Column('dob', sa.DATETIME(), nullable=True),
sa.Column('physician_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['physician_id'],
['Physician.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('ssn'))
op.create_table(
'Appointment', sa.Column('appointment_id',
sa.INTEGER(),
nullable=False),
sa.Column('start_time', sa.DATETIME(), nullable=False),
sa.Column('end_time', sa.DATETIME(), nullable=False),
sa.Column('physician_id', sa.INTEGER(), nullable=True),
sa.Column('patient_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['patient_id'],
['Patient.id'],
), sa.ForeignKeyConstraint(
['physician_id'],
['Physician.id'],
), sa.PrimaryKeyConstraint('appointment_id'))
op.create_table(
'airline_staff', sa.Column('user_id', sa.INTEGER(), nullable=False),
sa.Column('username', sa.VARCHAR(length=64), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('last_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('date_of_birth', sa.DATETIME(), nullable=False),
sa.Column('airline', sa.VARCHAR(length=64), nullable=False),
sa.ForeignKeyConstraint(
['airline'],
['airline.name'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.user_id'],
), sa.PrimaryKeyConstraint('username'))
op.create_table(
'airplane', sa.Column('id_num', sa.VARCHAR(length=3), nullable=False),
sa.Column('aircraft_name', sa.VARCHAR(length=128), nullable=False),
sa.Column('seat_capacity', sa.INTEGER(), nullable=False),
sa.PrimaryKeyConstraint('id_num'),
sa.UniqueConstraint('aircraft_name'))
op.create_table(
'Physician', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('last_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('email', sa.VARCHAR(length=64), nullable=False),
sa.Column('password', sa.VARCHAR(length=64), nullable=False),
sa.Column('hospital', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['hospital'],
['Hospital.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'))
op.drop_table('appointment')
op.drop_table('prescription')
op.drop_table('physician_schedule')
op.drop_table('physician')
op.drop_table('patient')
op.drop_table('nurse')
op.drop_index(op.f('ix_facility_hospital_id'), table_name='facility')
op.drop_index(op.f('ix_facility_facility_num'), table_name='facility')
op.drop_table('facility')
op.drop_table('insurance')
op.drop_table('hospital')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('observations', schema=None) as batch_op:
batch_op.add_column(sa.Column('date_time', sa.DATETIME(), nullable=True))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('upvoted',
sa.Column('timestamp', sa.DATETIME(), nullable=True))
op.add_column('downvoted',
sa.Column('timestamp', sa.DATETIME(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('ihome_city',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_facility',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('css', sa.String(length=30), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_user',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
sa.Column('phone', sa.String(length=11), nullable=True),
sa.Column('pwd_hash', sa.String(length=200), nullable=True),
sa.Column('name', sa.String(length=30), nullable=True),
sa.Column('avatar', sa.String(length=100), nullable=True),
sa.Column('id_name', sa.String(length=30), nullable=True),
sa.Column('id_card', sa.String(length=18), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('id_card'),
sa.UniqueConstraint('name'),
sa.UniqueConstraint('phone')
)
op.create_table('ihome_area',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('city_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['city_id'], ['ihome_city.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_house',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('area', sa.String(length=10), nullable=False),
sa.Column('city', sa.String(length=10), nullable=False),
sa.Column('street', sa.String(length=10), nullable=False),
sa.Column('village', sa.String(length=10), nullable=False),
sa.Column('title', sa.String(length=64), nullable=False),
sa.Column('price', sa.Integer(), nullable=True),
sa.Column('address', sa.String(length=512), nullable=True),
sa.Column('room_count', sa.Integer(), nullable=True),
sa.Column('acreage', sa.Integer(), nullable=True),
sa.Column('unit', sa.String(length=32), nullable=True),
sa.Column('direction', sa.String(length=64), nullable=True),
sa.Column('floor', sa.String(length=64), nullable=True),
sa.Column('index_image_url', sa.String(length=256), nullable=True),
sa.Column('desc', sa.String(length=256), nullable=True),
sa.Column('have_cook_bath', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['ihome_user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_house_facility',
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('facility_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['facility_id'], ['ihome_facility.id'], ),
sa.ForeignKeyConstraint(['house_id'], ['ihome_house.id'], ),
sa.PrimaryKeyConstraint('house_id', 'facility_id')
)
op.create_table('ihome_house_image',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('url', sa.String(length=256), nullable=False),
sa.ForeignKeyConstraint(['house_id'], ['ihome_house.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_order',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('begin_date', sa.DateTime(), nullable=False),
sa.Column('end_date', sa.DateTime(), nullable=False),
sa.Column('days', sa.Integer(), nullable=False),
sa.Column('house_price', sa.Integer(), nullable=False),
sa.Column('amount', sa.Integer(), nullable=False),
sa.Column('status', sa.Enum('WAIT_ACCEPT', 'WAIT_PAYMENT', 'PAID', 'WAIT_COMMENT', 'COMPLETE', 'CANCELED', 'REJECTED'), nullable=True),
sa.Column('comment', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['house_id'], ['ihome_house.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['ihome_user.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_ihome_order_status'), 'ihome_order', ['status'], unique=False)
op.create_table('ihome_street',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('area_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['area_id'], ['ihome_area.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_village',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('other', sa.String(length=100), nullable=True),
sa.Column('street_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['street_id'], ['ihome_street.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_factory',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=100), nullable=False),
sa.Column('content', sa.String(length=1000), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('city_id', sa.Integer(), nullable=False),
sa.Column('area_id', sa.Integer(), nullable=False),
sa.Column('street_id', sa.Integer(), nullable=False),
sa.Column('village_id', sa.Integer(), nullable=False),
sa.Column('address', sa.String(length=512), nullable=True),
sa.Column('acreage', sa.Integer(), nullable=True),
sa.Column('price', sa.Integer(), nullable=True),
sa.Column('unit', sqlalchemy_utils.types.choice.ChoiceType(Factory.UNIT_TYPE), nullable=True),
sa.Column('room_count', sa.Integer(), nullable=True),
sa.Column('contact_person', sa.String(length=10), nullable=False),
sa.Column('contact_mobile', sa.String(length=15), nullable=False),
sa.Column('index_image_url', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(['area_id'], ['ihome_area.id'], ),
sa.ForeignKeyConstraint(['city_id'], ['ihome_city.id'], ),
sa.ForeignKeyConstraint(['street_id'], ['ihome_street.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['ihome_user.id'], ),
sa.ForeignKeyConstraint(['village_id'], ['ihome_village.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ihome_factory_facility',
sa.Column('factory_id', sa.Integer(), nullable=False),
sa.Column('facility_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['facility_id'], ['ihome_facility.id'], ),
sa.ForeignKeyConstraint(['factory_id'], ['ihome_factory.id'], ),
sa.PrimaryKeyConstraint('factory_id', 'facility_id')
)
op.create_table('ihome_factory_image',
sa.Column('create_time', sa.DATETIME(), nullable=True),
sa.Column('update_time', sa.DATETIME(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('factory_id', sa.Integer(), nullable=False),
sa.Column('url', sa.String(length=256), nullable=False),
sa.ForeignKeyConstraint(['factory_id'], ['ihome_factory.id'], ),
sa.PrimaryKeyConstraint('id')
)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_column('member', 'lecture_num')
op.create_table(
'comment', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('content', sa.TEXT(), nullable=True),
sa.Column('voice_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'faq', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('number', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=256), nullable=False),
sa.Column('content_filename', sa.VARCHAR(length=64), nullable=False),
sa.Column('content_url', sa.VARCHAR(length=256), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'reservation', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('arrival_date', sa.DATE(), nullable=True),
sa.Column('departure_date', sa.DATE(), nullable=True),
sa.Column('guest_id', sa.INTEGER(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('checkout_time', sa.TIME(), nullable=True),
sa.Column('checkin_time', sa.TIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['guest_id'],
['guest.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('room',
sa.Column('number', sa.VARCHAR(length=64), nullable=False),
sa.Column('type', sa.VARCHAR(length=64), nullable=False),
sa.Column('tower', sa.VARCHAR(length=32), nullable=True),
sa.Column('floor', sa.VARCHAR(length=32), nullable=True),
sa.PrimaryKeyConstraint('number'))
op.create_table(
'signage_play_time', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('signage_group_id', sa.INTEGER(), nullable=False),
sa.Column('play_time', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['signage_group_id'],
['signage_group.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('play_time'))
op.create_table(
'service_class', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'chat_message', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('sender_id', sa.INTEGER(), nullable=True),
sa.Column('channel_id', sa.INTEGER(), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('voice_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=False),
sa.Column('content_english', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.ForeignKeyConstraint(
['channel_id'],
['chat_channel.id'],
), sa.ForeignKeyConstraint(
['sender_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'chat_member', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('channel_id', sa.INTEGER(), nullable=True),
sa.Column('person_id', sa.INTEGER(), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['channel_id'],
['chat_channel.id'],
), sa.ForeignKeyConstraint(
['person_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'requirement', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('content_english', sa.TEXT(), nullable=False),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('status', sa.INTEGER(), nullable=True),
sa.Column('priority', sa.INTEGER(), nullable=True),
sa.Column('wip_employee_id', sa.INTEGER(), nullable=True),
sa.Column('done_employee_id', sa.INTEGER(), nullable=True),
sa.Column('wip_timestamp', sa.DATETIME(), nullable=True),
sa.Column('done_timestamp', sa.DATETIME(), nullable=True),
sa.Column('sender_employee_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['done_employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['sender_employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['wip_employee_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'attraction_class', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'location_log', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('phone_id', sa.INTEGER(), nullable=False),
sa.Column('lat', sa.FLOAT(), nullable=True),
sa.Column('lng', sa.FLOAT(), nullable=True),
sa.Column('accuracy', sa.FLOAT(), nullable=True),
sa.Column('ap_name', sa.VARCHAR(length=128), nullable=True),
sa.Column('recent_ap_name', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['phone_id'],
['phone.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'clean', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=False),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('assign_date', sa.DATE(), nullable=False),
sa.Column('status', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'phone', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('uuid', sa.VARCHAR(length=128), nullable=True),
sa.Column('gcm_register_id', sa.VARCHAR(length=256), nullable=True),
sa.Column('name', sa.VARCHAR(length=64), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('phone_model', sa.VARCHAR(length=64), nullable=True),
sa.Column('floor', sa.VARCHAR(length=32), nullable=True),
sa.Column('recent_notice_timestamp', sa.DATETIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('clean_date_time', sa.TIME(), nullable=True),
sa.Column('recent_heartbeat_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_ap_name', sa.VARCHAR(length=64), nullable=True),
sa.Column('is_paired', sa.BOOLEAN(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'),
sa.UniqueConstraint('room_number'))
op.create_table(
'attraction', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('attraction_class_id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('content', sa.TEXT(), nullable=True),
sa.Column('content_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('phone_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('website_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['attraction_class_id'],
['attraction_class.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('survey', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=256), nullable=True),
sa.Column('max_point', sa.FLOAT(), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'push_notification', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('success', sa.BOOLEAN(), nullable=False),
sa.Column('msg', sa.TEXT(), nullable=False),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'room_status', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=False),
sa.Column('fo_status', sa.VARCHAR(length=32), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'guest_requirement', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('content_english', sa.TEXT(), nullable=False),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('floor', sa.VARCHAR(length=64), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('status', sa.INTEGER(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('authority',
sa.Column('label', sa.VARCHAR(length=64), nullable=False),
sa.PrimaryKeyConstraint('label'))
op.create_table(
'inspection_result', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('point', sa.INTEGER(), nullable=True),
sa.Column('comment_id', sa.INTEGER(), nullable=True),
sa.Column('inspection_id', sa.INTEGER(), nullable=False),
sa.Column('inspection_form_id', sa.INTEGER(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['comment_id'],
['comment.id'],
),
sa.ForeignKeyConstraint(
['inspection_form_id'],
['inspection_form.id'],
), sa.ForeignKeyConstraint(
['inspection_id'],
['inspection.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'positionAuthority',
sa.Column('position_label', sa.VARCHAR(length=64), nullable=False),
sa.Column('authority_label', sa.VARCHAR(length=64), nullable=False),
sa.ForeignKeyConstraint(
['authority_label'],
['authority.label'],
), sa.ForeignKeyConstraint(
['position_label'],
['position.label'],
), sa.PrimaryKeyConstraint('position_label', 'authority_label'))
op.create_table('guest', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('level', sa.VARCHAR(length=64), nullable=True),
sa.Column('state', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['id'],
['person.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'person', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('middle_name', sa.VARCHAR(length=64), nullable=True),
sa.Column('last_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_login_timestamp', sa.DATETIME(), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'hotel', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('phone_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('website_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('facebook_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('twitter_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('tripadvisor_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('yelp_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('instagram_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('pinterest_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('content_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('content_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'push', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('person_id', sa.INTEGER(), nullable=False),
sa.Column('register_id', sa.VARCHAR(length=128), nullable=False),
sa.Column('device_type', sa.VARCHAR(length=64), nullable=True),
sa.Column('region_id', sa.VARCHAR(length=32), nullable=True),
sa.ForeignKeyConstraint(
['person_id'],
['person.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'inspection', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('clean_id', sa.INTEGER(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=False),
sa.Column('assign_date', sa.DATE(), nullable=False),
sa.Column('max_point', sa.INTEGER(), nullable=True),
sa.Column('received_point', sa.INTEGER(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('complete_timestamp', sa.DATETIME(), nullable=True),
sa.Column('inspection_type', sa.VARCHAR(length=32), nullable=True),
sa.Column('inspection_status', sa.VARCHAR(length=32), nullable=True),
sa.Column('comment_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['clean_id'],
['clean.id'],
), sa.ForeignKeyConstraint(
['comment_id'],
['comment.id'],
), sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'signage_group', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=256), nullable=True),
sa.Column('signage_number', sa.INTEGER(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('inspection_form',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('type', sa.VARCHAR(length=64), nullable=False),
sa.Column('description', sa.TEXT(), nullable=False),
sa.Column('point', sa.INTEGER(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'signage', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('signage_group_id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=256), nullable=True),
sa.Column('duration', sa.INTEGER(), nullable=True),
sa.Column('status', sa.VARCHAR(length=16), nullable=True),
sa.Column('title_content', sa.VARCHAR(length=256), nullable=True),
sa.Column('title_typeface', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_weight', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_color', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_size', sa.VARCHAR(length=32), nullable=True),
sa.Column('title_alignment', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_line_height', sa.VARCHAR(length=32), nullable=True),
sa.Column('title_box_width', sa.FLOAT(), nullable=True),
sa.Column('title_box_height', sa.FLOAT(), nullable=True),
sa.Column('title_box_left', sa.FLOAT(), nullable=True),
sa.Column('title_box_top', sa.FLOAT(), nullable=True),
sa.Column('text_content', sa.TEXT(), nullable=True),
sa.Column('text_typeface', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_weight', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_color', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_size', sa.VARCHAR(length=32), nullable=True),
sa.Column('text_alignment', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_line_height', sa.VARCHAR(length=32), nullable=True),
sa.Column('text_box_width', sa.FLOAT(), nullable=True),
sa.Column('text_box_height', sa.FLOAT(), nullable=True),
sa.Column('text_box_left', sa.FLOAT(), nullable=True),
sa.Column('text_box_top', sa.FLOAT(), nullable=True),
sa.Column('signage_filename', sa.VARCHAR(length=64), nullable=True),
sa.Column('signage_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('thumbnail_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('thumbnail_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('link_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('signage_number', sa.INTEGER(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['signage_group_id'],
['signage_group.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('position',
sa.Column('label', sa.VARCHAR(length=64), nullable=False),
sa.PrimaryKeyConstraint('label'))
op.create_table(
'survey_answer', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('guest_requirement_id', sa.INTEGER(), nullable=False),
sa.Column('survey_id', sa.INTEGER(), nullable=False),
sa.Column('point', sa.FLOAT(), nullable=True),
sa.Column('comment', sa.TEXT(), nullable=True),
sa.ForeignKeyConstraint(
['guest_requirement_id'],
['guest_requirement.id'],
), sa.ForeignKeyConstraint(
['survey_id'],
['survey.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('chat_channel',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=64), nullable=False),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'service', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('service_class_id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('content', sa.TEXT(), nullable=True),
sa.Column('content_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('phone_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('website_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['service_class_id'],
['service_class.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'requirement_employee',
sa.Column('requirement_id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['requirement_id'],
['requirement.id'],
), sa.PrimaryKeyConstraint('requirement_id', 'employee_id'))
op.create_table(
'chat_read', sa.Column('message_id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=False),
sa.Column('token', sa.VARCHAR(length=64), nullable=False),
sa.Column('is_read', sa.BOOLEAN(), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['message_id'],
['chat_message.id'],
), sa.PrimaryKeyConstraint('message_id', 'employee_id'))
op.create_table(
'notice', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'memo', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('content_english', sa.TEXT(), nullable=True),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'employee', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('userid', sa.VARCHAR(length=256), nullable=True),
sa.Column('password_hash', sa.VARCHAR(length=256), nullable=False),
sa.Column('position', sa.VARCHAR(length=64), nullable=False),
sa.Column('state', sa.VARCHAR(length=64), nullable=False),
sa.Column('department', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['id'],
['person.id'],
), sa.ForeignKeyConstraint(
['position'],
['position.label'],
), sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('result', sa.Column('date_modified', sa.DATETIME(), nullable=True))
op.add_column('result', sa.Column('rndTesti', sa.VARCHAR(length=144), nullable=True))
op.add_column('result', sa.Column('date', sa.DATETIME(), nullable=True))
op.drop_constraint(None, 'result', type_='foreignkey')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('test_table', sa.Column('id', sa.INTEGER(),
nullable=False),
sa.Column('last_seen', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
def upgrade():
op.create_table(
'wishlist', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(), nullable=False),
sa.Column('description', sa.VARCHAR(), nullable=True),
sa.Column('no_of_votes', sa.INTEGER(), nullable=True),
sa.Column('categoryid', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['categoryid'],
['menu_category.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('restaurant', sa.Column('id', sa.INTEGER(),
nullable=False),
sa.Column('name', sa.VARCHAR(), nullable=False),
sa.Column('address', sa.VARCHAR(), nullable=True),
sa.Column('open_time', sa.DATETIME(), nullable=True),
sa.Column('close_time', sa.DATETIME(), nullable=True),
sa.Column('rating', sa.INTEGER(), nullable=True),
sa.Column('average_cost', sa.INTEGER(), nullable=False),
sa.Column('userid', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['userid'],
['user.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('address'))
op.create_table('orders', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('userid', sa.INTEGER(), nullable=False),
sa.Column('restid', sa.INTEGER(), nullable=False),
sa.Column('description', sa.VARCHAR(), nullable=True),
sa.Column('date', sa.DATETIME(), nullable=False),
sa.Column('itemid', sa.INTEGER(), nullable=False),
sa.Column('quantity', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['itemid'],
['menu_item.id'],
), sa.ForeignKeyConstraint(
['restid'],
['restaurant.id'],
), sa.ForeignKeyConstraint(
['userid'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'inventory',
sa.Column('id', sa.INTEGER(), nullable=False),
# sa.Column('name', sa.VARCHAR(), nullable=False),
sa.Column('quantity', sa.INTEGER(), nullable=False),
sa.Column('itemid', sa.VARCHAR(), nullable=False),
sa.Column('restaurantid', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['itemid'],
['menu_item.id'],
),
sa.ForeignKeyConstraint(
['restaurantid'],
['restaurant.id'],
),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'menu_item', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('categid', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(), nullable=False),
sa.Column('description', sa.VARCHAR(), nullable=True),
sa.Column('cost', sa.INTEGER(), nullable=False),
sa.Column('gluten_free', sa.VARCHAR(), nullable=True),
sa.Column('vegetarian', sa.VARCHAR(), nullable=True),
sa.ForeignKeyConstraint(
['categid'],
['menu_category.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_table('menu_category',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(), nullable=False),
sa.Column('description', sa.VARCHAR(), nullable=True),
sa.Column('restid', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['restid'],
['restaurant.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'user', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(), nullable=False),
sa.Column('email', sa.VARCHAR(), nullable=False, unique=True),
sa.Column('password', sa.VARCHAR(), nullable=False),
sa.Column('age', sa.INTEGER(), nullable=True),
sa.Column('mobile', sa.INTEGER(), nullable=True, unique=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('mobile'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('project', sa.Column('created_on', sa.DATE(), nullable=True))
op.add_column('project',
sa.Column('creation_date', sa.DATETIME(), nullable=False))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('sessions', schema=None) as batch_op:
batch_op.alter_column('start',
existing_type=sa.DATETIME(),
nullable=True)
