def downgrade_account():
### commands auto generated by Alembic - please adjust! ###
op.alter_column('service_usage',
'cost',
existing_type=sa.DECIMAL(precision=28, scale=20),
type_=mysql.DECIMAL(precision=20, scale=6),
existing_nullable=True)
op.alter_column('service_price',
'price',
existing_type=sa.DECIMAL(precision=28, scale=20),
type_=mysql.DECIMAL(precision=20, scale=6),
existing_nullable=True)
op.drop_constraint(None, 'customer', type_='foreignkey')
op.alter_column('account_history',
'delta',
existing_type=sa.DECIMAL(precision=28, scale=20),
type_=mysql.DECIMAL(precision=20, scale=6),
existing_nullable=True)
op.alter_column('account',
'withdraw',
existing_type=sa.DECIMAL(precision=28, scale=20),
type_=mysql.DECIMAL(precision=20, scale=6),
existing_nullable=True)
op.alter_column('account',
'balance',
existing_type=sa.DECIMAL(precision=28, scale=20),
type_=mysql.DECIMAL(precision=20, scale=6),
existing_nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
't_tdtc_orders',
sa.Column('should_pay_amt',
mysql.DECIMAL(precision=12, scale=2),
nullable=True))
op.add_column('t_tdtc_orders',
sa.Column('pay_time', mysql.DATETIME(), nullable=True))
op.add_column(
't_tdtc_orders',
sa.Column('real_pay_amt',
mysql.DECIMAL(precision=12, scale=2),
nullable=True))
op.add_column('t_tdtc_orders',
sa.Column('status', mysql.VARCHAR(length=24), nullable=True))
op.drop_constraint(None, 't_tdtc_orders', type_='unique')
op.drop_column('t_tdtc_orders', 'year')
op.drop_column('t_tdtc_orders', 'refund_amt')
op.drop_column('t_tdtc_orders', 'paid_amt')
op.drop_column('t_tdtc_orders', 'loan_amt')
op.drop_column('t_tdtc_orders', 'fee_no')
op.drop_column('t_tdtc_orders', 'fee_desc')
op.drop_column('t_tdtc_orders', 'detect_amt')
op.drop_column('t_tdtc_orders', 'begin_time')
op.drop_column('t_tdtc_orders', 'amt')
def downgrade_ganglia():
### commands auto generated by Alembic - please adjust! ###
op.add_column(
'ram',
sa.Column('time_date',
mysql.DECIMAL(precision=13, scale=6),
server_default=sa.text(u"'0.000000'"),
nullable=False))
op.drop_column('ram', 'timestamp')
op.add_column(
'monitor',
sa.Column('time_date',
mysql.DECIMAL(precision=13, scale=6),
nullable=True))
op.drop_column('monitor', 'timestamp')
op.add_column(
'iostat',
sa.Column('time_date',
mysql.DECIMAL(precision=13, scale=6),
server_default=sa.text(u"'0.000000'"),
nullable=False))
op.drop_column('iostat', 'timestamp')
op.add_column(
'filesystem',
sa.Column('time_date', mysql.BIGINT(display_width=20), nullable=False))
op.drop_column('filesystem', 'timestamp')
op.add_column(
'cpu',
sa.Column('time_date',
mysql.DECIMAL(precision=13, scale=6),
server_default=sa.text(u"'0.000000'"),
nullable=False))
op.drop_column('cpu', 'timestamp')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('grid_cellx',
sa.Column('id',
mysql.INTEGER(display_width=11),
nullable=False),
sa.Column('north_latitude',
mysql.DECIMAL(precision=12, scale=8),
nullable=False),
sa.Column('south_latitude',
mysql.DECIMAL(precision=12, scale=8),
nullable=False),
sa.Column('east_longitude',
mysql.DECIMAL(precision=12, scale=8),
nullable=False),
sa.Column('west_longitude',
mysql.DECIMAL(precision=12, scale=8),
nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB')
op.drop_table('result')
op.drop_table('grid_cell')
op.drop_table('experiment')
op.drop_table('city')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('trade',
sa.Column('id',
mysql.INTEGER(display_width=4, unsigned=True),
nullable=False),
sa.Column('name', mysql.VARCHAR(length=6), nullable=False),
sa.Column('account',
mysql.VARCHAR(length=11),
nullable=False),
sa.Column('saving',
mysql.DECIMAL(unsigned=True,
precision=8,
scale=2),
server_default=sa.text("'0.00'"),
nullable=False),
sa.Column('expend',
mysql.DECIMAL(unsigned=True,
precision=8,
scale=2),
server_default=sa.text("'0.00'"),
nullable=False),
sa.Column('income',
mysql.DECIMAL(unsigned=True,
precision=8,
scale=2),
server_default=sa.text("'0.00'"),
nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
op.drop_table('article')
def upgrade_account():
### commands auto generated by Alembic - please adjust! ###
op.alter_column('account',
'balance',
existing_type=mysql.DECIMAL(precision=20, scale=6),
type_=sa.DECIMAL(precision=28, scale=20),
existing_nullable=True)
op.alter_column('account',
'withdraw',
existing_type=mysql.DECIMAL(precision=20, scale=6),
type_=sa.DECIMAL(precision=28, scale=20),
existing_nullable=True)
op.alter_column('account_history',
'delta',
existing_type=mysql.DECIMAL(precision=20, scale=6),
type_=sa.DECIMAL(precision=28, scale=20),
existing_nullable=True)
op.create_foreign_key(None, 'customer', 'tenant', ['os_tenant_id'],
['tenant_id'])
op.alter_column('service_price',
'price',
existing_type=mysql.DECIMAL(precision=20, scale=6),
type_=sa.DECIMAL(precision=28, scale=20),
existing_nullable=True)
op.alter_column('service_usage',
'cost',
existing_type=mysql.DECIMAL(precision=20, scale=6),
type_=sa.DECIMAL(precision=28, scale=20),
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.add_column(
'funds',
sa.Column('unitNav',
mysql.DECIMAL(precision=14, scale=10),
nullable=True))
op.add_column(
'funds',
sa.Column('annualizedRate',
mysql.DECIMAL(precision=22, scale=18),
nullable=True))
op.add_column('funds', sa.Column('navDate',
mysql.DATETIME(),
nullable=True))
op.add_column(
'funds', sa.Column('acquisitionTime', mysql.DATETIME(), nullable=True))
op.create_index('ix_id_code_acquisitionTime',
'funds', ['id', 'code', 'acquisitionTime'],
unique=False)
op.create_index('ix_acquisitionTime',
'funds', ['acquisitionTime'],
unique=False)
op.drop_index('ix_mechanismCode', table_name='funds')
op.drop_index('ix_id_code_createTime', table_name='funds')
op.drop_index('ix_createTime', table_name='funds')
op.drop_column('funds', 'createTime')
op.drop_index('ix_navDate', table_name='fundsnetvalue')
op.drop_index('ix_id_navDate', table_name='fundsnetvalue')
op.drop_index('ix_createTime', table_name='fundsnetvalue')
op.drop_table('fundsnetvalue')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('event', 'lat',
existing_type=mysql.DECIMAL(precision=11, scale=8),
type_=sa.Numeric(precision=11, scale=6),
existing_nullable=True)
op.alter_column('event', 'long',
existing_type=mysql.DECIMAL(precision=11, scale=8),
type_=sa.Numeric(precision=11, scale=6),
existing_nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'products',
sa.Column('Special_price',
mysql.DECIMAL(precision=15, scale=2),
nullable=True))
op.add_column(
'products',
sa.Column('Original_price',
mysql.DECIMAL(precision=15, scale=2),
nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'shaker',
sa.Column('win_value',
mysql.DECIMAL(precision=20, scale=18),
nullable=True))
op.add_column(
'handshake',
sa.Column('win_value',
mysql.DECIMAL(precision=20, scale=18),
nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_index('user_id_UNIQUE', 'vote', ['user_id'], unique=True)
op.create_index('event_id_UNIQUE', 'vote', ['event_id'], unique=True)
op.alter_column('event', 'long',
existing_type=sa.Numeric(precision=11, scale=6),
type_=mysql.DECIMAL(precision=11, scale=8),
existing_nullable=True)
op.alter_column('event', 'lat',
existing_type=sa.Numeric(precision=11, scale=6),
type_=mysql.DECIMAL(precision=11, scale=8),
existing_nullable=True)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.alter_column('transaction',
'amount',
existing_type=sa.DECIMAL(precision=19, scale=2),
type_=mysql.DECIMAL(precision=19, scale=4),
existing_nullable=True)
op.alter_column('recurring_group',
'amount',
existing_type=sa.DECIMAL(precision=19, scale=2),
type_=mysql.DECIMAL(precision=19, scale=4),
existing_nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('t_tdtc_orders',
sa.Column('id',
mysql.INTEGER(display_width=11),
nullable=False),
sa.Column('order_no',
mysql.VARCHAR(length=32),
nullable=True),
sa.Column('fee_name',
mysql.VARCHAR(length=32),
nullable=True),
sa.Column('student_no',
mysql.VARCHAR(length=24),
nullable=True),
sa.Column('create_time', mysql.DATETIME(), nullable=False),
sa.Column('update_time', mysql.DATETIME(), nullable=False),
sa.Column('remark',
mysql.VARCHAR(length=128),
nullable=True),
sa.Column('amt',
mysql.DECIMAL(precision=12, scale=2),
nullable=True),
sa.Column('begin_time', mysql.DATETIME(), nullable=True),
sa.Column('detect_amt',
mysql.DECIMAL(precision=12, scale=2),
nullable=True),
sa.Column('fee_desc',
mysql.VARCHAR(length=128),
nullable=True),
sa.Column('fee_no',
mysql.VARCHAR(length=32),
nullable=True),
sa.Column('loan_amt',
mysql.DECIMAL(precision=12, scale=2),
nullable=True),
sa.Column('paid_amt',
mysql.DECIMAL(precision=12, scale=2),
nullable=True),
sa.Column('refund_amt',
mysql.DECIMAL(precision=12, scale=2),
nullable=True),
sa.Column('year', mysql.VARCHAR(length=8), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB')
op.create_index('order_no', 't_tdtc_orders', ['order_no'], unique=True)
op.create_index('fee_no', 't_tdtc_orders', ['fee_no'], unique=True)
op.drop_table('t_tdtc_fees')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('users', sa.Column('location', mysql.VARCHAR(length=64), nullable=True))
op.add_column('users', sa.Column('about_me', mysql.TEXT(), nullable=True))
op.add_column('users', sa.Column('avatar_hash', mysql.VARCHAR(length=32), nullable=True))
op.create_table('douban_movie_profile_copy',
sa.Column('id', mysql.INTEGER(display_width=11, unsigned=True), nullable=False),
sa.Column('movie_title', mysql.VARCHAR(length=80), nullable=False),
sa.Column('year', mysql.VARCHAR(length=8), nullable=False),
sa.Column('intro', mysql.TEXT(), nullable=True),
sa.Column('credit', mysql.DECIMAL(precision=2, scale=1), nullable=True),
sa.Column('judge_crowd', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('img_src', mysql.VARCHAR(length=255), nullable=True),
sa.Column('status', mysql.VARCHAR(length=5), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.drop_index(op.f('ix_short_comments_timestamp'), table_name='short_comments')
op.drop_table('short_comments')
op.drop_index(op.f('ix_movie_comments_timestamp'), table_name='movie_comments')
op.drop_table('movie_comments')
op.drop_index(op.f('ix_reviews_timestamp'), table_name='reviews')
op.drop_table('reviews')
op.drop_table('douban_movie_profile')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'produto',
sa.Column('preco', mysql.DECIMAL(precision=10, scale=2),
nullable=True))
op.drop_column('produto', 'preco_un')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.alter_column(u'post',
'price',
existing_type=mysql.DECIMAL(precision=10, scale=2),
nullable=False)
op.drop_column(u'post', 'type_code')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('country',
sa.Column('country_id',
mysql.INTEGER(display_width=11),
autoincrement=True,
nullable=False),
sa.Column('country_name',
mysql.VARCHAR(length=100),
nullable=False),
sa.Column('country_code',
mysql.VARCHAR(length=2),
nullable=False),
sa.Column('nationality',
mysql.VARCHAR(length=50),
nullable=False),
sa.PrimaryKeyConstraint('country_id'),
mysql_collate='utf8mb4_0900_ai_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_index('ix_country_country_code',
'country', ['country_code'],
unique=False)
op.create_table('temp',
sa.Column('id',
mysql.DECIMAL(precision=10, scale=0),
nullable=True),
sa.Column('data', mysql.VARCHAR(length=100),
nullable=True),
mysql_collate='utf8mb4_0900_ai_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('submission',
'score',
existing_type=sa.Text(),
type_=mysql.DECIMAL(precision=6, scale=2),
existing_nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'run',
sa.Column('distance',
mysql.DECIMAL(precision=10, scale=0),
nullable=True))
def upgrade():
op.add_column(
'price__list',
sa.Column('discount_amount_2_weeks',
mysql.DECIMAL(precision=10, scale=2),
nullable=True))
op.add_column(
'price__list',
sa.Column('discount_amount_3_weeks',
mysql.DECIMAL(precision=10, scale=2),
nullable=True))
op.add_column(
'price__list',
sa.Column('discount_amount_4_weeks',
mysql.DECIMAL(precision=10, scale=2),
nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('CashNotes',
sa.Column('isdelete',
mysql.TINYINT(display_width=1),
autoincrement=False,
nullable=True),
sa.Column('createtime', mysql.DATETIME(), nullable=True),
sa.Column('updatetime', mysql.DATETIME(), nullable=True),
sa.Column('CNid', mysql.VARCHAR(length=64),
nullable=False),
sa.Column('USid', mysql.VARCHAR(length=64), nullable=True),
sa.Column('CNbankName', mysql.TEXT(), nullable=True),
sa.Column('CNbankDetail', mysql.TEXT(), nullable=True),
sa.Column('CNcardNo',
mysql.VARCHAR(length=32),
nullable=True),
sa.Column('CNcashNum',
mysql.DECIMAL(precision=28, scale=2),
nullable=True),
sa.Column('CNstatus',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('CNid'),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
op.drop_table('cash_notes')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('progressive_payments',
sa.Column('price_list_id',
mysql.INTEGER(),
autoincrement=False,
nullable=True),
sa.Column('due_by', sa.DATE(), nullable=True),
sa.Column('amount_due',
mysql.DECIMAL(precision=10, scale=2),
nullable=True),
sa.Column('first_payment',
mysql.TINYINT(display_width=1),
autoincrement=False,
nullable=True),
sa.Column('id',
mysql.INTEGER(),
autoincrement=False,
nullable=False),
sa.CheckConstraint('(`first_payment` in (0,1))',
name='progressive_payments_chk_1'),
sa.ForeignKeyConstraint(
['price_list_id'], ['price__list.id'],
name='progressive_payments_ibfk_1'),
mysql_collate='utf8_bin',
mysql_default_charset='utf8',
mysql_engine='InnoDB')
op.drop_table('progressive__payment')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('user', 'is_superuser',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=False)
op.alter_column('user', 'is_active',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=False)
op.drop_constraint(None, 'product', type_='foreignkey')
op.drop_index(op.f('ix_product_department_id'), table_name='product')
op.alter_column('product', 'physical_count',
existing_type=mysql.INTEGER(display_width=11),
nullable=False)
op.alter_column('product', 'expiration_count',
existing_type=mysql.INTEGER(display_width=11),
nullable=False)
op.alter_column('product', 'cost',
existing_type=mysql.DECIMAL(precision=10, scale=2),
nullable=False)
op.alter_column('product', 'category_id',
existing_type=mysql.INTEGER(display_width=11),
nullable=False)
op.drop_column('product', 'department_id')
op.drop_index(op.f('ix_department_id'), table_name='department')
op.drop_table('department')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('department',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('description', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_index(op.f('ix_department_id'), 'department', ['id'], unique=False)
op.add_column('product', sa.Column('department_id', sa.Integer(), nullable=True))
op.alter_column('product', 'category_id',
existing_type=mysql.INTEGER(display_width=11),
nullable=True)
op.alter_column('product', 'cost',
existing_type=mysql.DECIMAL(precision=10, scale=2),
nullable=True)
op.alter_column('product', 'expiration_count',
existing_type=mysql.INTEGER(display_width=11),
nullable=True)
op.alter_column('product', 'physical_count',
existing_type=mysql.INTEGER(display_width=11),
nullable=True)
op.create_index(op.f('ix_product_department_id'), 'product', ['department_id'], unique=False)
op.create_foreign_key(None, 'product', 'department', ['department_id'], ['id'])
op.alter_column('user', 'is_active',
existing_type=mysql.TINYINT(display_width=1),
type_=sa.Boolean(),
existing_nullable=False)
op.alter_column('user', 'is_superuser',
existing_type=mysql.TINYINT(display_width=1),
type_=sa.Boolean(),
existing_nullable=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('mf_goods', 'price',
existing_type=mysql.DECIMAL(precision=7, scale=2),
comment='商品价格',
existing_comment='商品价格[余额]',
existing_nullable=True)
op.drop_column('mf_goods', 'credit')
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column(u'post',
sa.Column('type_code', sa.SmallInteger(), nullable=True))
op.alter_column(u'post',
'price',
existing_type=mysql.DECIMAL(precision=10, scale=2),
nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'pay_mode',
sa.Column('name',
mysql.VARCHAR(collation=u'utf8_unicode_ci', length=100),
nullable=False))
op.drop_column('pay_mode', 'names')
op.alter_column('document',
'url',
existing_type=mysql.VARCHAR(collation=u'utf8_unicode_ci',
length=200),
nullable=False)
op.alter_column('document',
'name',
existing_type=mysql.VARCHAR(collation=u'utf8_unicode_ci',
length=100),
nullable=False)
op.alter_column('commodity',
'unit_price',
existing_type=mysql.DECIMAL(precision=10, scale=4),
nullable=False)
op.alter_column('commodity',
'total_price',
existing_type=mysql.DECIMAL(precision=10, scale=2),
nullable=False)
op.alter_column('commodity',
'quantity_and_unit',
existing_type=mysql.VARCHAR(collation=u'utf8_unicode_ci',
length=100),
nullable=False)
op.alter_column('commodity',
'hs_code',
existing_type=mysql.VARCHAR(collation=u'utf8_unicode_ci',
length=10),
nullable=False)
op.alter_column('commodity',
'commodity_type',
existing_type=mysql.VARCHAR(collation=u'utf8_unicode_ci',
length=200),
nullable=False)
op.alter_column('commodity',
'commodity_name',
existing_type=mysql.VARCHAR(collation=u'utf8_unicode_ci',
length=200),
nullable=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'delete__price__list',
sa.Column('no_discount_price_3_weeks',
mysql.DECIMAL(precision=10, scale=2),
nullable=True))
op.add_column(
'delete__price__list',
sa.Column('no_discount_price_2_weeks',
mysql.DECIMAL(precision=10, scale=2),
nullable=True))
op.add_column(
'delete__price__list',
sa.Column('no_discount_price_4_weeks',
mysql.DECIMAL(precision=10, scale=2),
nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'salary',
sa.Column('base_wage',
mysql.DECIMAL(precision=10, scale=2),
nullable=True))
op.drop_column('salary', 'base_salary')
