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)
