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)