def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('expenditures',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('parent_id', sa.String(length=15), nullable=False),
sa.Column('description', sa.String(), nullable=False),
sa.Column('name', sa.String(length=256), nullable=False),
sa.Column('date_opened', sa.DateTime(), nullable=False),
sa.Column('date_closed', sa.DateTime(), nullable=True),
sa.Column('deadline', sa.DateTime(), nullable=True),
sa.Column('status', sa.String(length=9), nullable=True),
sa.Column('type', sa.String(length=9), nullable=True),
sa.Column('cost_amount', sa.DECIMAL(), nullable=True),
sa.Column('cost_currency', sa.String(length=3), nullable=True),
sa.Column('created_on', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_expenditures_parent_id'), 'expenditures', ['parent_id'], unique=False)
op.create_table('timesheets',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('parent_id', sa.String(length=15), nullable=False),
sa.Column('description', sa.String(length=256), nullable=False),
sa.Column('duration', sa.DECIMAL(), nullable=False),
sa.Column('date_opened', sa.DateTime(), nullable=False),
sa.Column('created_on', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_timesheets_parent_id'), 'timesheets', ['parent_id'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'tesco_bought_next',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('product_id', sa.Integer(), nullable=True),
sa.Column('product_url', sa.String(length=2048), nullable=True),
sa.Column('product_title', sa.String(length=4096), nullable=True),
sa.Column('product_image_url', sa.String(length=2048), nullable=True),
sa.Column('price', sa.DECIMAL(precision=10, scale=2), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'tesco_products', sa.Column('product_id', sa.Integer(),
nullable=False),
sa.Column('product_url', sa.String(length=2048), nullable=True),
sa.Column('image_url', sa.String(length=2048), nullable=True),
sa.Column('product_title', sa.String(length=4096), nullable=True),
sa.Column('category', sa.String(length=1024), nullable=True),
sa.Column('price', sa.DECIMAL(precision=10, scale=2), nullable=True),
sa.Column('product_description', sa.Text(), nullable=True),
sa.Column('name_and_address', sa.Text(), nullable=True),
sa.Column('return_address', sa.Text(), nullable=True),
sa.Column('net_contents', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('product_id'))
op.create_table(
'tesco_reviews',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('product_id', sa.Integer(), nullable=True),
sa.Column('review_title', sa.String(length=2048), nullable=True),
sa.Column('stars_count', sa.Integer(), nullable=True),
sa.Column('date', sa.String(length=64), nullable=True),
sa.Column('review_text', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('payments',
sa.Column('base_amount', sa.DECIMAL(), nullable=False))
op.add_column('payments',
sa.Column('total_price', sa.DECIMAL(), nullable=False))
op.drop_column('payments', 'amount')
def schema_upgrades():
op.create_table(
'product', sa.Column('id', sa.Integer, nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.Column('label', sa.String(length=64), nullable=False),
sa.UniqueConstraint('label'),
sa.Column('like_or', sa.String(length=256), nullable=True),
sa.Column('like_and', sa.String(length=256), nullable=True),
sa.Column('color', sa.Integer(), nullable=True),
sa.Column('process', sa.String(length=32), nullable=True),
sa.Column('type', sa.String(length=32), nullable=True),
sa.Column('show_in_abstract', sa.String(length=32), nullable=False),
sa.Column('created_at', sa.DateTime, nullable=False),
sa.Column('updated_at', sa.DateTime, nullable=True))
op.create_table(
'report_products', sa.Column('id', sa.Integer, nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.Column('brand', sa.String(length=128), nullable=False),
sa.Column('label', sa.String(length=128), nullable=False),
sa.Column('status', sa.Enum('OPENED', 'CLOSED'), nullable=False),
sa.Column('business_code', sa.Integer(), nullable=False),
sa.Column('month', sa.Integer(), nullable=False),
sa.Column('latest_year', sa.Integer(), nullable=False),
sa.Column('current_year', sa.Integer(), nullable=False),
sa.Column('qtd_latest_year', sa.Integer(), nullable=False),
sa.Column('value_latest_year',
sa.DECIMAL(precision=17, scale=2),
nullable=False),
sa.Column('qtd_current_year', sa.Integer(), nullable=False),
sa.Column('value_current_year',
sa.DECIMAL(precision=17, scale=2),
nullable=False),
sa.Column('created_at', sa.DateTime, nullable=False),
sa.Column('updated_at', sa.DateTime, nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'Order', sa.Column('id', postgresql.UUID(), nullable=False),
sa.Column('desc', sa.String(length=200), nullable=True),
sa.Column('customer', sa.String(length=80), nullable=False),
sa.Column('totalpayment',
sa.DECIMAL(precision=14, scale=2),
nullable=False),
sa.Column('status', sa.String(length=30), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'Order_item',
sa.Column('id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('product_id', postgresql.UUID(), nullable=True),
sa.Column('amount', sa.Integer(), nullable=False),
sa.Column('item_price',
sa.DECIMAL(precision=10, scale=2),
nullable=False),
sa.Column('order_id', postgresql.UUID(), nullable=True),
sa.ForeignKeyConstraint(
['order_id'],
['Order.id'],
), sa.ForeignKeyConstraint(
['product_id'],
['Product.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
op.create_table(
'location',
sa.Column(
'Id',
sa.Integer,
primary_key=True,
autoincrement=True),
sa.Column(
'Place',
sa.String(45),
nullable=False),
sa.Column(
'Longitude',
sa.DECIMAL(18, 15),
nullable=False),
sa.Column(
'Latitude',
sa.DECIMAL(17, 15),
nullable=False),
sa.Column(
'Name',
sa.String(45),
nullable=False),
sa.Column(
'UserId',
sa.Integer,
sa.ForeignKey('user.Id', ondelete='SET NULL'),
nullable=True),
sa.Column(
'CategoryId',
sa.Integer,
sa.ForeignKey('category.Id', ondelete='SET NULL'),
nullable=True)
)
class Wallet(db.Model):
__tablename__ = 'wallets'
pub_key = sa.Column(sa.String(52), primary_key=True)
tx_count = sa.Column(sa.BigInteger, nullable=False, server_default='0')
mile_balance = sa.Column(sa.DECIMAL(19, 5), nullable=False, server_default='0')
mile_staked = sa.Column(sa.DECIMAL(19, 5), nullable=False, server_default='0')
xdr_balance = sa.Column(sa.DECIMAL(19, 2), nullable=False, server_default='0')
xdr_staked = sa.Column(sa.DECIMAL(19, 2), nullable=False, server_default='0')
created_at = sa.Column(TIMESTAMP(precision=0, timezone=False), nullable=False)
balance_updated_at = sa.Column(TIMESTAMP(precision=0, timezone=False), default=None)
valid_before_block = sa.Column(sa.BigInteger, nullable=True)
is_node = sa.Column(sa.Boolean, nullable=False, default=False, server_default='false')
node_address = sa.Column(sa.String(255), default=None)
_idx1 = sa.Index('transactions__mile_balance', 'mile_balance')
_idx2 = sa.Index('transactions__xdr_balance', 'xdr_balance')
_idx3 = sa.Index('transactions__mile_staked', 'mile_staked')
_idx4 = sa.Index('transactions__xdr_staked', 'xdr_staked')
_idx5 = sa.Index('transactions__created_at', 'created_at')
_idx6 = sa.Index('transactions__valid_before_block', 'valid_before_block')
_idx7 = sa.Index('transactions__is_node', 'is_node')
def __str__(self):
return self.pub_key
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'Coupon',
sa.Column('isdelete', sa.Boolean(), nullable=True, comment='是否删除'),
sa.Column('createtime', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('updatetime', sa.DateTime(), nullable=True, comment='更新时间'),
sa.Column('COid', sa.String(length=64), nullable=False),
sa.Column('COstatus',
sa.Integer(),
nullable=True,
comment='状态501可领取502已结束'),
sa.Column('COstarttime',
sa.DateTime(),
nullable=True,
comment='有效起始时间'),
sa.Column('COendtime', sa.DateTime(), nullable=True,
comment='有效期结束时间'),
sa.Column('COdownline',
sa.DECIMAL(scale=2),
nullable=True,
comment='使用最低金额限制,0 为无限制'),
sa.Column('COsubtration',
sa.DECIMAL(scale=2),
nullable=True,
comment='优惠价格'),
sa.Column('COlimitnum', sa.Integer(), nullable=True, comment='发放数量'),
sa.Column('COgetnum', sa.Integer(), nullable=True, comment='已领数量'),
sa.PrimaryKeyConstraint('COid'))
op.create_table(
'CouponUser',
sa.Column('isdelete', sa.Boolean(), nullable=True, comment='是否删除'),
sa.Column('createtime', sa.DateTime(), nullable=True, comment='创建时间'),
sa.Column('updatetime', sa.DateTime(), nullable=True, comment='更新时间'),
sa.Column('UCid', sa.String(length=64), nullable=False),
sa.Column('COid',
sa.String(length=64),
nullable=False,
comment='优惠券id'),
sa.Column('USid', sa.String(length=64), nullable=False,
comment='用户id'),
sa.Column('COstatus',
sa.Integer(),
nullable=True,
comment='状态501可领取502已结束'),
sa.Column('COstarttime',
sa.DateTime(),
nullable=True,
comment='有效起始时间'),
sa.Column('COendtime', sa.DateTime(), nullable=True,
comment='有效期结束时间'),
sa.Column('COdownline',
sa.DECIMAL(scale=2),
nullable=True,
comment='使用最低金额限制,0 为无限制'),
sa.Column('UCalreadyuse',
sa.Integer(),
nullable=True,
comment='是否已经使用 601已使用602未使用603已过期'),
sa.PrimaryKeyConstraint('UCid'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'OrderPart',
sa.Column('SkudevideRate', sa.DECIMAL(scale=2), nullable=True))
op.add_column(
'ProductSku',
sa.Column('SkudevideRate', sa.DECIMAL(scale=2), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('turbinehealth',
sa.Column('downtime', sa.Float(), nullable=True))
op.add_column('turbinehealth',
sa.Column('failure_cost', sa.DECIMAL(), nullable=True))
op.add_column('turbinehealth',
sa.Column('revenue_loss', sa.DECIMAL(), nullable=True))
def create_table_odds(engine, metadata):
if not engine.dialect.has_table(engine, 'odds'):
sql.Table(
'odds', metadata,
sql.Column('game_id', sql.VARCHAR(12), index=True, nullable=False),
sql.Column('home_odds', sql.DECIMAL(4, 2)),
sql.Column('away_odds', sql.DECIMAL(4, 2)))
metadata.create_all()
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'roles', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('description', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
op.create_table(
'users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=100), nullable=True),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('password', sa.String(length=255), nullable=True),
sa.Column('created_on', sa.DateTime(), nullable=True),
sa.Column('updated_on', sa.DateTime(), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['role_id'],
['roles.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('name'))
op.add_column('diecuts',
sa.Column('cf2', sa.String(length=255), nullable=True))
op.add_column('diecuts',
sa.Column('hcountitem', sa.Integer(), nullable=False))
op.add_column(
'diecuts',
sa.Column('hgap', sa.DECIMAL(precision=10, scale=4), nullable=False))
op.add_column('diecuts',
sa.Column('mfg', sa.String(length=255), nullable=True))
op.add_column('diecuts',
sa.Column('slug', sa.String(length=50), nullable=True))
op.add_column('diecuts',
sa.Column('vcountitem', sa.Integer(), nullable=False))
op.add_column(
'diecuts',
sa.Column('vgap', sa.DECIMAL(precision=10, scale=4), nullable=False))
op.add_column('diecuts', sa.Column('vsheet', sa.Integer(), nullable=False))
op.add_column('diecuts', sa.Column('zub_num', sa.Integer(),
nullable=False))
op.create_foreign_key(None, 'diecuts', 'zubs', ['zub_num'], ['zub_num'])
op.add_column(
'zubs',
sa.Column('hpolimer',
sa.DECIMAL(precision=10, scale=4),
nullable=False))
op.add_column(
'zubs',
sa.Column('hpolimer_17',
sa.DECIMAL(precision=10, scale=4),
nullable=False))
op.add_column(
'zubs',
sa.Column('hprint', sa.DECIMAL(precision=10, scale=4), nullable=False))
op.create_unique_constraint(None, 'zubs', ['hpolimer_17'])
op.create_unique_constraint(None, 'zubs', ['hprint'])
op.create_unique_constraint(None, 'zubs', ['zub_num'])
op.create_unique_constraint(None, 'zubs', ['hpolimer'])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('app', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('key', sa.String(length=16), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('key'))
op.create_table(
'bank', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('balance', sa.DECIMAL(precision=10, scale=2),
nullable=False), sa.PrimaryKeyConstraint('id'))
op.create_table('client', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=False),
sa.Column('email', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('status_payment',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'invoice', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('num', sa.String(length=5), nullable=False),
sa.Column('balance', sa.DECIMAL(precision=10, scale=2),
nullable=False),
sa.Column('bank_id', sa.Integer(), nullable=False),
sa.Column('client_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['bank_id'],
['bank.id'],
), sa.ForeignKeyConstraint(
['client_id'],
['client.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'payment', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('key', sa.String(length=5), nullable=False),
sa.Column('amount_money',
sa.DECIMAL(precision=10, scale=2),
nullable=False),
sa.Column('number_invoice_provider',
sa.String(length=5),
nullable=False),
sa.Column('number_invoice_reciever',
sa.String(length=5),
nullable=False),
sa.Column('code_confirm', sa.Integer(), nullable=True),
sa.Column('status_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['status_id'],
['status_payment.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_payment_code_confirm'),
'payment', ['code_confirm'],
unique=False)
op.create_index(op.f('ix_payment_number_invoice_provider'),
'payment', ['number_invoice_provider'],
unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'hydro_sensors',
sa.Column('latitude', sa.DECIMAL(precision=8, scale=6), nullable=True))
op.add_column(
'hydro_sensors',
sa.Column('longitude', sa.DECIMAL(precision=9, scale=6),
nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'submission',
sa.Column('full_score',
sa.DECIMAL(precision=6, scale=2),
nullable=True))
op.add_column(
'submission',
sa.Column('score', sa.DECIMAL(precision=6, scale=2), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'bill', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('due_date', sa.DateTime(), nullable=False),
sa.Column('minimum_payment', sa.DECIMAL(), nullable=False),
sa.Column('balance', sa.DECIMAL(), nullable=False),
sa.Column('status',
sa.Enum('CANCELLED', 'PENDING', 'PAID', name='billstatus'),
nullable=True), sa.PrimaryKeyConstraint('id'))
op.create_table('customer', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('name', sa.String(length=250), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'risk_type', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('table_name', sa.String(length=250), nullable=False),
sa.Column('risk_type_id', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('payment', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('paid_date', sa.DateTime(), nullable=False),
sa.Column('amount', sa.DECIMAL(), nullable=False),
sa.Column('bill_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['bill_id'],
['bill.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'policy', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('effective_date', sa.DateTime(), nullable=False),
sa.Column('expiry_date', sa.DateTime(), nullable=True),
sa.Column('total_amount', sa.DECIMAL(), nullable=False),
sa.Column('is_active', sa.Boolean(), nullable=True),
sa.Column('customer_id', sa.Integer(), nullable=False),
sa.Column('risk_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['customer_id'],
['customer.id'],
), sa.ForeignKeyConstraint(
['risk_id'],
['risk_type.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('policy_edit_log',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('policy_id', sa.Integer(), nullable=False),
sa.Column('edited_on', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(
['policy_id'],
['policy.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('profit',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('income', sa.DECIMAL(precision=20, scale=8), nullable=False),
sa.Column('cost', sa.DECIMAL(precision=20, scale=8), nullable=False),
sa.Column('year', sa.Date(), nullable=False),
sa.Column('request_id', sa.String(length=36), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_profit_request_id'), 'profit', ['request_id'], unique=False)
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 upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('assetlocation',
sa.Column('pri_id', sa.INTEGER(), nullable=False),
sa.Column('id', sa.Integer(), nullable=True),
sa.Column('description', sa.VARCHAR(length=30), nullable=True),
sa.Column('data_time', sa.TIMESTAMP(), nullable=True),
sa.Column('longitude', sa.DECIMAL(precision=18, scale=12), nullable=True),
sa.Column('latitude', sa.DECIMAL(precision=18, scale=12), nullable=True),
sa.Column('elevation', sa.INTEGER(), nullable=True),
sa.PrimaryKeyConstraint('pri_id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'equipment',
sa.Column('gaode_latitude',
sa.DECIMAL(precision='15,8'),
nullable=True))
op.add_column(
'equipment',
sa.Column('gaode_longitude',
sa.DECIMAL(precision='15,8'),
nullable=True))
def upgrade():
op.create_table(
'products',
sa.Column('productCode', sa.String(15), primary_key=True),
sa.Column('productName', sa.String(70), nullable=False),
sa.Column('productLine', sa.String(50), nullable=False),
sa.Column('productScale', sa.String(10), nullable=False),
sa.Column('productVendor', sa.String(50), nullable=False),
sa.Column('productDescription', sa.Text, nullable=False),
sa.Column('quantityInStock', sa.SmallInteger, nullable=False),
sa.Column('buyPrice', sa.DECIMAL(10, 2), nullable=False),
sa.Column('MSRP', sa.DECIMAL(10, 2), nullable=False),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('exchanges',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('currency', sa.String(length=3), nullable=False),
sa.Column('amount', sa.DECIMAL(precision=24, scale=8), nullable=False),
sa.Column('exchange_rate', sa.DECIMAL(precision=24, scale=8), nullable=False),
sa.Column('amount_usd', sa.DECIMAL(precision=24, scale=8), nullable=False),
sa.Column('creation_date', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_exchanges_creation_date'), 'exchanges', ['creation_date'], unique=False)
op.create_index(op.f('ix_exchanges_currency'), 'exchanges', ['currency'], unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'items', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=80), nullable=False),
sa.Column('image_url', sa.String(length=100), nullable=False),
sa.Column('expiration_time', sa.DECIMAL(precision=16), nullable=False),
sa.Column('min_bid', sa.DECIMAL(precision=8), nullable=False),
sa.Column('min_increment_bid',
sa.DECIMAL(precision=8), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('expiration_time'),
sa.UniqueConstraint('image_url'), sa.UniqueConstraint('min_bid'),
sa.UniqueConstraint('min_increment_bid'), sa.UniqueConstraint('name'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('insider',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('ticker',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('code', sa.String(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('code')
)
op.create_table('transaction_type',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('code', sa.String(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('code')
)
op.create_table('insider_ticker',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('insider_id', sa.Integer(), nullable=False),
sa.Column('ticker_id', sa.Integer(), nullable=False),
sa.Column('relation', sa.String(), nullable=True),
sa.Column('owner_type', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['insider_id'], ['insider.id'], ),
sa.ForeignKeyConstraint(['ticker_id'], ['ticker.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('price',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('ticker_id', sa.Integer(), nullable=False),
sa.Column('price_date', sa.Date(), nullable=False),
sa.Column('start', sa.DECIMAL(), nullable=True),
sa.Column('high', sa.DECIMAL(), nullable=True),
sa.Column('low', sa.DECIMAL(), nullable=True),
sa.Column('last', sa.DECIMAL(), nullable=True),
sa.ForeignKeyConstraint(['ticker_id'], ['ticker.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('trade',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('insider_ticker_id', sa.Integer(), nullable=False),
sa.Column('transaction_type_id', sa.Integer(), nullable=False),
sa.Column('shares_traded', sa.Integer(), nullable=True),
sa.Column('last_price', sa.DECIMAL(), nullable=True),
sa.Column('shares_held', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['insider_ticker_id'], ['insider_ticker.id'], ),
sa.ForeignKeyConstraint(['transaction_type_id'], ['transaction_type.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('funds',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('code', sa.String(length=20), nullable=True),
sa.Column('title', sa.String(length=50), nullable=True),
sa.Column('category', sa.String(length=50), nullable=True),
sa.Column('annualizedRate', sa.DECIMAL(precision=22, scale=18), nullable=True),
sa.Column('unitNav', sa.DECIMAL(precision=14, scale=10), nullable=True),
sa.Column('navDate', sa.DateTime(), nullable=True),
sa.Column('subCategory', sa.String(length=20), nullable=True),
sa.Column('acquisitionTime', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('WalletRecord',
sa.Column('isdelete', sa.Boolean(), nullable=True),
sa.Column('createtime', sa.DateTime(), nullable=True),
sa.Column('updatetime', sa.DateTime(), nullable=True),
sa.Column('WRid', sa.String(length=64), nullable=False),
sa.Column('USid', sa.String(length=64), nullable=True),
sa.Column('WRcash', sa.DECIMAL(precision=28, scale=2), nullable=True),
sa.Column('WRtype', sa.Integer(), nullable=True),
sa.Column('ContentId', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('WRid')
)
op.add_column('User', sa.Column('USbalance', sa.DECIMAL(precision=28, scale=2), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'kosts',
sa.Column('Klat', sa.DECIMAL(precision=10, scale=8), nullable=True))
op.add_column(
'kosts',
sa.Column('Klng', sa.DECIMAL(precision=11, scale=8), nullable=True))
op.create_index(op.f('ix_kosts_Kaddress'),
'kosts', ['Kaddress'],
unique=False)
op.create_index(op.f('ix_kosts_Kname'), 'kosts', ['Kname'], unique=False)
op.drop_index('ix_kosts_Kaddress', table_name='kosts')
op.drop_index('ix_kosts_Kname', table_name='kosts')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('cab_booking',
sa.Column('total_days', sa.Integer(), nullable=True))
op.add_column(
'cab_deal',
sa.Column('driver_daily_allowance_charge', sa.DECIMAL(),
nullable=True))
op.add_column(
'cab_deal',
sa.Column('driver_per_hr_allowance_charge',
sa.DECIMAL(),
nullable=True))
op.drop_column('cab_deal', 'driver_night_allowance_charge')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'parks', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('pname', sa.String(length=100), nullable=False),
sa.Column('address', sa.String(length=100), nullable=False),
sa.Column('pnum', sa.Integer(), nullable=False),
sa.Column('price', sa.DECIMAL(precision=2, scale=1), nullable=True),
sa.Column('coordi_x', sa.DECIMAL(precision=4, scale=2),
nullable=False),
sa.Column('coordi_y', sa.DECIMAL(precision=4, scale=2),
nullable=False),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.Column('is_Active', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('address'),
sa.UniqueConstraint('coordi_y'), sa.UniqueConstraint('pname'))
op.create_index(op.f('ix_parks_addtime'),
'parks', ['addtime'],
unique=False)
op.create_table(
'record', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uname', sa.String(length=100), nullable=False),
sa.Column('pname', sa.String(length=100), nullable=False),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.Column('startT', sa.DateTime(), nullable=False),
sa.Column('endT', sa.DateTime(), nullable=False),
sa.Column('totalT', sa.String(length=100), nullable=False),
sa.Column('spend', sa.DECIMAL(precision=5, scale=2), nullable=False),
sa.Column('is_Delete', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('pname'),
sa.UniqueConstraint('uname'))
op.create_table('tourist', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uname', sa.String(length=100), nullable=False),
sa.Column('pwd1', sa.String(length=100), nullable=False),
sa.Column('pwd2', sa.String(length=100), nullable=False),
sa.Column('email', sa.String(length=100), nullable=False),
sa.Column('phone', sa.String(length=11), nullable=False),
sa.Column('ucard', sa.String(length=100), nullable=False),
sa.Column('addtime', sa.DateTime(), nullable=True),
sa.Column('is_Active', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'), sa.UniqueConstraint('phone'),
sa.UniqueConstraint('ucard'), sa.UniqueConstraint('uname'))
op.create_index(op.f('ix_users_addtime'),
'users', ['addtime'],
unique=False)
def upgrade():
op.create_table(
modelTable,
sa.Column('id', sa.Integer, primary_key=True, nullable=False),
sa.Column('idProject',
sa.Integer,
sa.ForeignKey(projectTable + '.id', name='fk_modelProject'),
nullable=False),
sa.Column('idOperationType',
sa.Integer,
sa.ForeignKey(operationTypeTable + '.id',
name='fk_modelOperationType'),
nullable=False),
sa.Column('idPropertyType',
sa.Integer,
sa.ForeignKey(propertyTypeTable + '.id',
name='fk_modelPropertyType'),
nullable=False),
sa.Column('name', sa.String(255), nullable=False),
sa.Column('bedroom', sa.Integer),
sa.Column('bathroom', sa.Integer),
sa.Column('halfBathroom', sa.Integer),
sa.Column('totalArea', sa.DECIMAL(10, 2)),
sa.Column(
'view',
sa.Integer,
comment='1:Frente,2:Contrafrente,3:Interno,4:Lateral,5:Esquina'),
sa.Column('unity', sa.Integer),
sa.Column('floor', sa.Integer),
sa.Column('garage', sa.Integer),
sa.Column('price', sa.DECIMAL(10, 2)),
sa.Column('currency',
sa.SmallInteger,
server_default='1',
comment='1:PEN,2:USD'),
sa.Column('dateCreate',
sa.DateTime,
server_default=sa.sql.expression.text('NOW()'),
comment='Fecha creación'),
sa.Column('dateUpdate',
sa.TIMESTAMP,
server_default=sa.sql.expression.text('CURRENT_TIMESTAMP'),
nullable=False,
comment='Fecha actualización'),
sa.Column('state',
sa.SmallInteger,
server_default='1',
comment='1:Activo,2:Desactivo,3:Eliminado'),
)
