def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.drop_column('vuls', 'repair') op.add_column( 'tasks', sa.Column('filename', mysql.VARCHAR(length=255), nullable=True)) op.add_column( 'tasks', sa.Column('task_type', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False)) op.add_column('tasks', sa.Column('url', mysql.VARCHAR(length=255), nullable=True)) op.alter_column('tasks', 'updated_at', existing_type=mysql.DATETIME(), nullable=False) op.alter_column('tasks', 'scan_way', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('tasks', 'created_at', existing_type=mysql.DATETIME(), nullable=False) op.drop_column('tasks', 'time_start') op.drop_column('tasks', 'time_end') op.drop_column('tasks', 'time_consume') op.drop_column('tasks', 'target') op.drop_column('tasks', 'file_count') op.drop_column('rules', 'status') op.drop_column('rules', 'repair') op.drop_column('rules', 'regex_confirm')
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column(u'whitelist', sa.Column('file', mysql.VARCHAR(length=512), nullable=True)) op.drop_column(u'whitelist', 'status') op.drop_column(u'whitelist', 'path') op.add_column(u'projects', sa.Column('branch', mysql.VARCHAR(length=128), nullable=True)) op.add_column(u'projects', sa.Column('scan_at', mysql.DATETIME(), nullable=True)) op.add_column(u'projects', sa.Column('password', mysql.VARCHAR(length=128), nullable=True)) op.add_column(u'projects', sa.Column('repo_type', mysql.TINYINT(display_width=2), autoincrement=False, nullable=False)) op.add_column(u'projects', sa.Column('username', mysql.VARCHAR(length=128), nullable=True)) op.drop_column(u'projects', 'remark') op.drop_column(u'projects', 'last_scan') op.drop_column(u'projects', 'author') op.add_column(u'languages', sa.Column('suffix', mysql.VARCHAR(length=256), nullable=False)) op.drop_column(u'languages', 'extensions') op.create_table('cobra_task_info', sa.Column('id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('task_type', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False), sa.Column('create_time', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False), sa.Column('filename', mysql.VARCHAR(length=255), nullable=True), sa.Column('level', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('new_version', mysql.VARCHAR(length=40), nullable=True), sa.Column('old_version', mysql.VARCHAR(length=40), nullable=True), sa.Column('password', mysql.VARCHAR(length=255), nullable=True), sa.Column('scan_type', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('scan_way', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('url', mysql.VARCHAR(length=255), nullable=True), sa.Column('username', mysql.VARCHAR(length=255), nullable=True), sa.Column('branch', mysql.VARCHAR(length=64), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_default_charset=u'utf8', mysql_engine=u'InnoDB' ) op.drop_table('tasks') op.drop_table('results')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('watch_target', sa.Column('ip_scan_id', sa.BigInteger(), nullable=True)) op.add_column( 'watch_target', sa.Column('manual_dns', sa.SmallInteger(), nullable=False, server_default='0')) op.alter_column('watch_target', 'is_ip_host', existing_type=mysql.SMALLINT(display_width=6), nullable=False, server_default='0') op.alter_column('watch_target', 'last_scan_state', existing_type=mysql.SMALLINT(display_width=6), nullable=False, server_default='0') op.alter_column('watch_target', 'scan_connect', existing_type=mysql.SMALLINT(display_width=6), nullable=False, server_default='0') op.create_index(op.f('ix_watch_target_ip_scan_id'), 'watch_target', ['ip_scan_id'], unique=False) op.create_foreign_key('wt_ip_scan_record_id', 'watch_target', 'ip_scan_record', ['ip_scan_id'], ['id'], ondelete='SET NULL')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('user', sa.Column('name', mysql.VARCHAR(length=128), nullable=False)) op.alter_column('user', 'status', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('user', 'role', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('user', 'phone', existing_type=mysql.VARCHAR(length=128), nullable=False) op.alter_column('user', 'last_name', existing_type=mysql.VARCHAR(length=128), nullable=False) op.alter_column('user', 'first_name', existing_type=mysql.VARCHAR(length=128), nullable=False) op.alter_column('user', 'address', existing_type=mysql.VARCHAR(length=128), nullable=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('TaskCount', sa.Column('todolist_id', sa.CHAR(length=36), nullable=False), sa.Column('quantity', mysql.SMALLINT(unsigned=True), nullable=False), sa.ForeignKeyConstraint(['todolist_id'], ['TodoList.todolist_id'], name=op.f('fk_TaskCount_todolist_id_TodoList'), ondelete='cascade'), sa.PrimaryKeyConstraint('todolist_id', name=op.f('pk_TaskCount')) ) op.create_table('TaskDepth', sa.Column('task_id', sa.CHAR(length=36), nullable=False), sa.Column('depth', mysql.SMALLINT(unsigned=True), nullable=False), sa.ForeignKeyConstraint(['task_id'], ['Task.task_id'], name=op.f('fk_TaskDepth_task_id_Task'), ondelete='cascade'), sa.PrimaryKeyConstraint('task_id', name=op.f('pk_TaskDepth')) ) op.add_column('Role', sa.Column('task_count_limit', mysql.SMALLINT(unsigned=True), nullable=True)) op.add_column('Role', sa.Column('task_depth_limit', mysql.SMALLINT(unsigned=True), nullable=True)) op.add_column('Role', sa.Column('todolist_count_limit', mysql.SMALLINT(unsigned=True), nullable=True)) bind = op.get_bind() # metadata for current connection meta = sa.MetaData(bind=bind) # tuple with tables to reflect meta.reflect() # update limits op.execute('UPDATE Role SET todolist_count_limit = 10, task_count_limit = 100, ' 'task_depth_limit = 10 WHERE role = "owner"') op.execute('UPDATE Role SET task_count_limit = 80, task_depth_limit = 8 WHERE role = "admin"')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('certificates', 'is_ev') op.drop_column('certificates', 'is_cn_wildcard') op.drop_column('certificates', 'is_alt_wildcard') op.create_table('user_ip_scan_record', sa.Column('id', mysql.BIGINT(display_width=20), nullable=False), sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=False), sa.Column('ip_scan_record_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False), sa.Column('created_at', mysql.DATETIME(), nullable=True), sa.Column('updated_at', mysql.DATETIME(), nullable=True), sa.Column('deleted_at', mysql.DATETIME(), nullable=True), sa.Column('disabled_at', mysql.DATETIME(), nullable=True), sa.Column('scan_periodicity', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True), sa.Column('auto_fill_watches', mysql.SMALLINT(display_width=6), server_default=sa.text(u"'0'"), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['ip_scan_record_id'], [u'ip_scan_record.id'], name=u'fk_ip_scan_record_ip_scan_record_id', ondelete=u'CASCADE'), sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'fk_user_ip_scan_record_users_id', ondelete=u'CASCADE'), sa.PrimaryKeyConstraint('id'), mysql_default_charset=u'utf8', mysql_engine=u'InnoDB' ) op.create_table('user_subdomain_watch_target', sa.Column('id', mysql.BIGINT(display_width=20), nullable=False), sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=False), sa.Column('watch_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False), sa.Column('created_at', mysql.DATETIME(), nullable=True), sa.Column('updated_at', mysql.DATETIME(), nullable=True), sa.Column('deleted_at', mysql.DATETIME(), nullable=True), sa.Column('disabled_at', mysql.DATETIME(), nullable=True), sa.Column('auto_scan_added_at', mysql.DATETIME(), nullable=True), sa.Column('scan_periodicity', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True), sa.Column('scan_type', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('auto_fill_watches', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'wa_sub_users_id', ondelete=u'CASCADE'), sa.ForeignKeyConstraint(['watch_id'], [u'subdomain_watch_target.id'], name=u'wa_sub_watch_target_id', ondelete=u'CASCADE'), sa.PrimaryKeyConstraint('id'), mysql_default_charset=u'utf8', mysql_engine=u'InnoDB' ) op.create_table('user_watch_target', sa.Column('id', mysql.BIGINT(display_width=20), nullable=False), sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=False), sa.Column('watch_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False), sa.Column('created_at', mysql.DATETIME(), nullable=True), sa.Column('updated_at', mysql.DATETIME(), nullable=True), sa.Column('deleted_at', mysql.DATETIME(), nullable=True), sa.Column('scan_periodicity', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True), sa.Column('scan_type', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('auto_scan_added_at', mysql.DATETIME(), nullable=True), sa.Column('disabled_at', mysql.DATETIME(), nullable=True), sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'wa_users_id', ondelete=u'CASCADE'), sa.ForeignKeyConstraint(['watch_id'], [u'watch_target.id'], name=u'wa_watch_target_id', ondelete=u'CASCADE'), sa.PrimaryKeyConstraint('id'), mysql_default_charset=u'utf8', mysql_engine=u'InnoDB' )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('auth_user', 'status', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('auth_user', 'role', existing_type=mysql.SMALLINT(display_width=6), nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('fp_product', sa.Column('low_stock', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True)) op.add_column('fp_product', sa.Column('mini_cnt', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True)) op.add_column('fp_product', sa.Column('shipping', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.add_column('fp_product', sa.Column('recommend', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True)) op.add_column('fp_product', sa.Column('subtract', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.drop_column('fp_product', 'mini_quantity') op.drop_column('fp_product', 'lowest_stock') op.drop_column('fp_product', 'is_subtract') op.drop_column('fp_product', 'is_shipping') op.drop_column('fp_product', 'is_recommend')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('bao_cate', 'cate_update_time') op.drop_column('bao_cate', 'cate_create_time') op.create_table('bao_common_attribute_value', sa.Column('value_id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('attr_key_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False), sa.Column('value', mysql.VARCHAR(length=255), nullable=False), sa.Column('value_create_time', sa.DATE(), nullable=False), sa.Column('value_update_time', sa.DATE(), nullable=True), sa.Column('value_is_delete', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('value_id'), mysql_default_charset='utf8', mysql_engine='InnoDB' ) op.create_table('Bao_user_login_record', sa.Column('v_id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('v_host', mysql.TEXT(), nullable=True), sa.Column('v_time', mysql.TEXT(), nullable=True), sa.Column('v_agent', mysql.TEXT(), nullable=True), sa.Column('v_referer', mysql.TEXT(), nullable=True), sa.Column('v_encoding', mysql.TEXT(), nullable=True), sa.Column('v_language', mysql.TEXT(), nullable=True), sa.Column('v_ip', mysql.TEXT(), nullable=True), sa.Column('v_user_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('v_id'), mysql_default_charset='utf8', mysql_engine='InnoDB' ) op.create_table('bao_common_attribute_key', sa.Column('attr_id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('cate_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False), sa.Column('attr_name', mysql.VARCHAR(length=64), nullable=False), sa.Column('attr_index', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('attr_order', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('is_linked', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('attr_input_type', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('attr_values', mysql.TEXT(), nullable=False), sa.Column('attr_group', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('attr_can_muti', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.Column('attr_create_time', sa.DATE(), nullable=False), sa.Column('attr_update_time', sa.DATE(), nullable=True), sa.Column('attr_is_delete', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('attr_id'), mysql_default_charset='utf8', mysql_engine='InnoDB' ) op.create_table('bao_blog_detail', sa.Column('blog_id', mysql.INTEGER(display_width=11), nullable=False), sa.Column('blog_title', mysql.TEXT(), nullable=False), sa.Column('blog_subheading', mysql.TEXT(), nullable=True), sa.Column('blog_create_time_tuple', mysql.VARCHAR(length=32), nullable=False), sa.Column('blog_current_edit_tuple', mysql.VARCHAR(length=32), nullable=False), sa.Column('blog_content', mysql.TEXT(), nullable=True), sa.Column('blog_creater_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False), sa.PrimaryKeyConstraint('blog_id'), mysql_default_charset='utf8', mysql_engine='InnoDB' )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('ip_info', 'lock_status', existing_type=sa.CHAR(length=1), type_=mysql.SMALLINT(display_width=6), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint(None, 'sell_order', type_='unique') op.alter_column('sell_order', 'status', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.drop_column('sell_order', 'side') op.drop_column('sell_order', 'number') op.drop_column('sell_order', 'amount') op.add_column('order', sa.Column('payment_amount', mysql.DECIMAL(precision=24, scale=8), nullable=False)) op.add_column('order', sa.Column('proof_img', mysql.TEXT(), nullable=True)) op.add_column('order', sa.Column('match_user_id', mysql.VARCHAR(length=36), nullable=True)) op.add_column('order', sa.Column('current_price', mysql.DECIMAL(precision=24, scale=8), nullable=False)) op.add_column('order', sa.Column('hold_amount', mysql.DECIMAL(precision=24, scale=8), nullable=False)) op.add_column('order', sa.Column('details', mysql.VARCHAR(length=255), nullable=True)) op.add_column('order', sa.Column('match_at', mysql.DATETIME(), nullable=True)) op.add_column('order', sa.Column('payment_id', mysql.VARCHAR(length=36), nullable=True)) op.add_column('order', sa.Column('fee', mysql.DECIMAL(precision=24, scale=8), nullable=False)) op.drop_constraint(None, 'order', type_='foreignkey') op.create_foreign_key('order_ibfk_1', 'order', 'user', ['match_user_id'], ['id']) op.create_foreign_key('order_ibfk_3', 'order', 'payment', ['payment_id'], ['id']) op.drop_constraint(None, 'order', type_='unique') op.create_index('number', 'order', ['number'], unique=True) op.drop_column('order', 'side') op.drop_column('order', 'priority') op.drop_column('order', 'match_order_id') op.drop_column('assets', 'community_today_balance') op.drop_table('match_order_task') op.drop_table('match_order') op.drop_table('confirm_order') op.drop_table('buy_order')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('bbs_posts', 'price', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('bbs_posts', 'istop', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('bbs_posts', 'ishot', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('bbs_posts', 'iselite', existing_type=mysql.INTEGER(display_width=11), nullable=False) op.alter_column('bbs_posts', 'isdel', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('bbs_posts', 'hits', existing_type=mysql.INTEGER(display_width=11), nullable=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('user', 'is_disable') op.add_column('dilivery', sa.Column('status', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.alter_column('company', 'logo', existing_type=mysql.VARCHAR(length=128), nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('tb_student_course', sa.Column('student_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.Column('course_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['course_id'], ['courses.id'], name='tb_student_course_ibfk_2'), sa.ForeignKeyConstraint(['student_id'], ['students.id'], name='tb_student_course_ibfk_1'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_table('Person', sa.Column('Id', mysql.INTEGER(display_width=5), autoincrement=False, nullable=True), sa.Column('Emaile', mysql.VARCHAR(length=25), nullable=True), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_table('first', sa.Column('id', mysql.SMALLINT(display_width=11), autoincrement=True, nullable=False), sa.Column('age', mysql.TINYINT(display_width=4), autoincrement=False, nullable=False, comment='??'), sa.PrimaryKeyConstraint('id'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_table('courses', sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('name', mysql.VARCHAR(length=64), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_index('name', 'courses', ['name'], unique=True) op.create_table('students', sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('name', mysql.VARCHAR(length=64), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_index('name', 'students', ['name'], unique=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'ip_code_info', sa.Column('unlock_count_1m', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.add_column( 'ip_code_info', sa.Column('unlock_count_30m', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.drop_column('ip_code_info', 'lock_max_30m') op.drop_column('ip_code_info', 'lock_max_1m')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column( "page_view", "req_method", existing_type=mysql.SMALLINT(display_width=6), nullable=True, )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'wishes', sa.Column('status', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.alter_column('wishes', 'created_time', existing_type=mysql.DATETIME(), nullable=True) op.drop_column('wishes', 'is_deleted') op.add_column( 'users', sa.Column('status', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.alter_column('users', 'created_time', existing_type=mysql.DATETIME(), nullable=True) op.drop_column('users', 'is_deleted') op.add_column( 'gifts', sa.Column('status', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.alter_column('gifts', 'created_time', existing_type=mysql.DATETIME(), nullable=True) op.drop_column('gifts', 'is_deleted') op.add_column( 'books', sa.Column('status', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.alter_column('books', 'created_time', existing_type=mysql.DATETIME(), nullable=True) op.drop_column('books', 'is_deleted')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'user', sa.Column('status', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'training_session_exercises', sa.Column('training_part', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('property_type', 'name', existing_type=mysql.VARCHAR(length=255), nullable=True) op.alter_column('accommodation', 'special_notices', existing_type=mysql.TEXT(), nullable=False) op.alter_column('accommodation', 'room_type_id', existing_type=mysql.INTEGER(display_width=11), nullable=True) op.alter_column('accommodation', 'property_type_id', existing_type=mysql.INTEGER(display_width=11), nullable=True) op.alter_column('accommodation', 'num_beds', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('accommodation', 'num_bedrooms', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('accommodation', 'num_bathrooms', existing_type=mysql.SMALLINT(display_width=6), nullable=False) op.alter_column('accommodation', 'member_id', existing_type=mysql.VARCHAR(length=36), nullable=True) op.alter_column('accommodation', 'direction_manual', existing_type=mysql.TEXT(), nullable=False) op.alter_column('accommodation', 'description', existing_type=mysql.TEXT(), nullable=False) op.alter_column('accommodation', 'checkin_guide', existing_type=mysql.TEXT(), nullable=False) op.alter_column('accommodation', 'apartment_rule', existing_type=mysql.TEXT(), nullable=False) op.alter_column('accommodation', 'apartment_manual', existing_type=mysql.TEXT(), nullable=False) op.alter_column('accommodation', 'address', existing_type=mysql.VARCHAR(length=255), nullable=False) op.drop_column('accommodation', 'standard_guess')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'plan', sa.Column('turbo', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.drop_column('plan', 'MonthStartDate')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'samples', sa.Column('type', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.drop_column('samples', 'amount_type')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'financial_product', sa.Column('type', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.drop_table('fp_type')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### with op.batch_alter_table('com_sign', schema=None) as batch_op: batch_op.add_column( sa.Column('isVerify', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True, comment='是否通过审核 1-通过 0-未通过'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('jobs', sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('cron_time', mysql.VARCHAR(length=64), nullable=False), sa.Column('content', mysql.VARCHAR(length=64), nullable=False), sa.Column('status', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True), sa.Column('name', mysql.VARCHAR(length=64), nullable=False), sa.PrimaryKeyConstraint('id'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_table('history', sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('hostname', mysql.VARCHAR(length=32), nullable=False), sa.Column('checktime', mysql.VARCHAR(length=64), nullable=False), sa.Column('type', mysql.VARCHAR(length=32), nullable=False), sa.PrimaryKeyConstraint('id'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_table('host', sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False), sa.Column('type', mysql.VARCHAR(length=32), nullable=False), sa.Column('cluster', mysql.VARCHAR(length=32), nullable=False), sa.Column('hostname', mysql.VARCHAR(length=32), nullable=False), sa.PrimaryKeyConstraint('id'), mysql_default_charset='utf8', mysql_engine='InnoDB') op.create_index('ix_host_type', 'host', ['type'], unique=False) op.create_index('ix_host_cluster', 'host', ['cluster'], unique=False) op.create_index('hostname', 'host', ['hostname'], unique=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( "page_view", sa.Column( "req_method", mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False, ), )
def downgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column('invtypes', sa.Column('portionSize', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True)) op.add_column('invtypes', sa.Column('basePrice', mysql.DECIMAL(precision=19, scale=4), nullable=True)) op.add_column('invtypes', sa.Column('mass', mysql.DOUBLE(asdecimal=True), nullable=True)) op.add_column('invtypes', sa.Column('soundID', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True)) op.add_column('invtypes', sa.Column('volume', mysql.DOUBLE(asdecimal=True), nullable=True)) op.add_column('invtypes', sa.Column('published', mysql.TINYINT(display_width=4), autoincrement=False, nullable=True)) op.add_column('invtypes', sa.Column('iconID', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True)) op.add_column('invtypes', sa.Column('raceID', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.add_column('invtypes', sa.Column('capacity', mysql.DOUBLE(asdecimal=True), nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint('wt_ip_scan_record_id', 'watch_target', type_='foreignkey') op.drop_index(op.f('ix_watch_target_ip_scan_id'), table_name='watch_target') op.alter_column('watch_target', 'scan_connect', existing_type=mysql.SMALLINT(display_width=6), nullable=True) op.alter_column('watch_target', 'last_scan_state', existing_type=mysql.SMALLINT(display_width=6), nullable=True) op.alter_column('watch_target', 'is_ip_host', existing_type=mysql.SMALLINT(display_width=6), nullable=True) op.drop_column('watch_target', 'manual_dns') op.drop_column('watch_target', 'ip_scan_id')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'PerinatalDeathCertificate', sa.Column('motherDOB_D', mysql.TINYINT(unsigned=True), nullable=True)) op.add_column( 'PerinatalDeathCertificate', sa.Column('motherDOB_M', mysql.TINYINT(unsigned=True), nullable=True)) op.add_column( 'PerinatalDeathCertificate', sa.Column('motherDOB_Y', mysql.SMALLINT(unsigned=True), nullable=True)) op.drop_column('PerinatalDeathCertificate', 'motherDOB')
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('manage_user', 'is_super') op.add_column( 'manage_access', sa.Column('level', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True)) op.create_index('ix_manage_access_level', 'manage_access', ['level'], unique=False)