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'), )