def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('project_parameters', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=128), nullable=False), sa.Column('value', sa.String(length=128), nullable=False), sa.Column('type', sa.SmallInteger(), nullable=False), sa.Column('project_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['project_id'], ['projects.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('job', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('creator', sa.BigInteger(), nullable=True, comment='创建人'), sa.Column('creatTime', sa.Integer(), nullable=True, comment='创建时间'), sa.Column('reviseTime', sa.Integer(), nullable=True, comment='更新时间'), sa.Column('reviser', sa.BigInteger(), nullable=True, comment='修改人'), sa.Column('isDel', sa.SmallInteger(), nullable=True, comment='是否删除 1-删除 0-未删除'), sa.Column('tittle', sa.String(length=50), nullable=True, comment='工作的标题'), sa.Column('reward', sa.String(length=20), nullable=True, comment='报酬'), sa.Column('place', sa.String(length=20), nullable=True, comment='地点'), sa.Column('settlement', sa.SmallInteger(), nullable=False, comment='工作结算方式 1-日结 2-周结 3-完工结'), sa.Column('isBagEating', sa.SmallInteger(), nullable=False, comment='是否包吃 1-是 2-否'), sa.Column('encase', sa.SmallInteger(), nullable=False, comment='是否包住 1-是 2-否'), sa.Column('isTrafficSubsidy', sa.SmallInteger(), nullable=False, comment='是否有交通补贴 1-是 2-否'), sa.Column('royalty', sa.SmallInteger(), nullable=False, comment='是否有提成 1-是 2-否'), sa.PrimaryKeyConstraint('id'), comment='300 工作表') op.drop_table('myjob')
def upgrade(): op.create_table('market_track', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date_time', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id', name=op.f('pk_market_track')) ) op.create_table('personal_market_stat', sa.Column('id', sa.Integer(), nullable=False), sa.Column('item_type', sa.SmallInteger(), nullable=True), sa.Column('price', sa.Integer(), nullable=True), sa.Column('market_track_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['market_track_id'], ['market_track.id'], name=op.f('fk_personal_market_stat_market_track_id_market_track')), sa.PrimaryKeyConstraint('id', name=op.f('pk_personal_market_stat')) ) op.create_table('state_market_stat', sa.Column('id', sa.Integer(), nullable=False), sa.Column('item_type', sa.SmallInteger(), nullable=True), sa.Column('price', sa.Integer(), nullable=True), sa.Column('market_track_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['market_track_id'], ['market_track.id'], name=op.f('fk_state_market_stat_market_track_id_market_track')), sa.PrimaryKeyConstraint('id', name=op.f('pk_state_market_stat')) )
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( 'component_update', sa.Column('id', sa.Integer(), nullable=False), sa.Column('component', sa.String(length=128), nullable=True), sa.Column('label', sa.String(length=128), nullable=True), sa.Column('status', sa.String(length=64), nullable=True), sa.Column('status_description', sa.Text(), nullable=True), sa.Column('health', sa.SmallInteger(), nullable=True), sa.Column('tags', sa.Text(), nullable=True), sa.Column('time', sa.Integer(), nullable=True), sa.Column('lifetime', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=50), nullable=True), sa.Column('email', sa.String(length=120), nullable=True), sa.Column('password', sa.String(length=120), nullable=True), sa.Column('role', sa.SmallInteger(), nullable=True), sa.Column('status', sa.SmallInteger(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('name')) op.create_table('todos', sa.Column('id', sa.Integer(), nullable=False), sa.Column('body', sa.Text(), nullable=True), sa.Column('priority', sa.String(length=50), nullable=True), sa.Column('tags', sa.String(length=50), nullable=True), sa.Column('user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.drop_table('users_user') op.drop_table('todos_todo')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('article', sa.Column('create_time', sa.DateTime(), nullable=False, comment='创建时间'), sa.Column('update_time', sa.DateTime(), nullable=False, comment='更新时间'), sa.Column('is_delete', sa.SmallInteger(), nullable=True, comment='删除标识'), sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('title', sa.String(length=255), nullable=False, comment='文章标题'), sa.Column('content', sa.Text(), nullable=True, comment='文章内容'), sa.Column('comment', sa.Integer(), nullable=True, comment='评论人数'), sa.Column('agree', sa.Integer(), nullable=True, comment='点赞人数'), sa.Column('click', sa.Integer(), nullable=True, comment='浏览次数'), sa.Column('recom', sa.SmallInteger(), nullable=True, comment='是否推荐,0否1是'), sa.Column('published', sa.SmallInteger(), nullable=True, comment='是否发布0否1是'), sa.Column('publish_date', sa.DateTime(), nullable=False, comment='发布时间'), sa.Column('cover_id', sa.Integer(), nullable=True, comment='封面'), sa.Column('category_id', sa.Integer(), nullable=True, comment='栏目'), sa.ForeignKeyConstraint(['category_id'], ['category.id'], ), sa.ForeignKeyConstraint(['cover_id'], ['upload.id'], ), sa.PrimaryKeyConstraint('id') ) op.drop_table('artice')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('volunteer_role_interest_version', sa.Column('volunteer_id', sa.Integer(), autoincrement=False, nullable=False), sa.Column('role_id', sa.Integer(), autoincrement=False, nullable=False), sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False), sa.Column('operation_type', sa.SmallInteger(), nullable=False), sa.PrimaryKeyConstraint('volunteer_id', 'role_id', 'transaction_id', name=op.f('pk_volunteer_role_interest_version')) ) op.create_index(op.f('ix_volunteer_role_interest_version_operation_type'), 'volunteer_role_interest_version', ['operation_type'], unique=False) op.create_index(op.f('ix_volunteer_role_interest_version_transaction_id'), 'volunteer_role_interest_version', ['transaction_id'], unique=False) op.create_table('volunteer_role_training_version', sa.Column('volunteer_id', sa.Integer(), autoincrement=False, nullable=False), sa.Column('role_id', sa.Integer(), autoincrement=False, nullable=False), sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False), sa.Column('operation_type', sa.SmallInteger(), nullable=False), sa.PrimaryKeyConstraint('volunteer_id', 'role_id', 'transaction_id', name=op.f('pk_volunteer_role_training_version')) ) op.create_index(op.f('ix_volunteer_role_training_version_operation_type'), 'volunteer_role_training_version', ['operation_type'], unique=False) op.create_index(op.f('ix_volunteer_role_training_version_transaction_id'), 'volunteer_role_training_version', ['transaction_id'], unique=False) op.create_table('volunteer_role_interest', sa.Column('volunteer_id', sa.Integer(), nullable=False), sa.Column('role_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['role_id'], ['volunteer_role.id'], name=op.f('fk_volunteer_role_interest_role_id_volunteer_role')), sa.ForeignKeyConstraint(['volunteer_id'], ['volunteer.id'], name=op.f('fk_volunteer_role_interest_volunteer_id_volunteer')), sa.PrimaryKeyConstraint('volunteer_id', 'role_id', name=op.f('pk_volunteer_role_interest')) ) op.create_table('volunteer_role_training', sa.Column('volunteer_id', sa.Integer(), nullable=False), sa.Column('role_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['role_id'], ['volunteer_role.id'], name=op.f('fk_volunteer_role_training_role_id_volunteer_role')), sa.ForeignKeyConstraint(['volunteer_id'], ['volunteer.id'], name=op.f('fk_volunteer_role_training_volunteer_id_volunteer')), sa.PrimaryKeyConstraint('volunteer_id', 'role_id', name=op.f('pk_volunteer_role_training')) ) op.drop_table('volunteer_role_mapping') op.drop_index('ix_volunteer_role_mapping_version_operation_type', table_name='volunteer_role_mapping_version') op.drop_index('ix_volunteer_role_mapping_version_transaction_id', table_name='volunteer_role_mapping_version') op.drop_table('volunteer_role_mapping_version') op.drop_table('volunteer_user_role')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'bookmark', sa.Column('id', sa.BigInteger(), autoincrement=True, nullable=False), sa.Column('domain', sa.String(length=100), nullable=True), sa.Column('base_url', sa.String(length=256), nullable=True), sa.Column('url', sa.String(length=512), nullable=True), sa.Column('title', sa.String(length=128), nullable=True), sa.Column('image_url', sa.String(length=256), nullable=True), sa.Column('post_count', sa.Integer(), nullable=True), sa.Column('hidden', sa.SmallInteger(), nullable=True), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('course_action', sa.Column('id', sa.Integer(), nullable=False), sa.Column('type', sa.SmallInteger(), nullable=False), sa.Column('course_id', sa.Integer(), nullable=False), sa.Column('card_id', sa.Integer(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.ForeignKeyConstraint( ['course_id'], ['course.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('chrism_notes', sa.Column('id', postgresql.UUID(as_uuid=True), nullable=False), sa.Column('person_id', postgresql.UUID(as_uuid=True), nullable=False), sa.Column('best_man', postgresql.UUID(as_uuid=True), nullable=True), sa.Column('status', sa.SmallInteger(), server_default='1', nullable=False), sa.Column('created_at', sa.DateTime(), nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.ForeignKeyConstraint(['best_man'], ['persons.id'], ), sa.ForeignKeyConstraint(['person_id'], ['persons.id'], ), sa.PrimaryKeyConstraint('id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'host', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('type', sa.String(length=32), nullable=False), sa.Column('cluster', sa.String(length=32), nullable=False), sa.Column('hostname', sa.String(length=32), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('hostname')) op.create_index(op.f('ix_host_cluster'), 'host', ['cluster'], unique=False) op.create_index(op.f('ix_host_type'), 'host', ['type'], unique=False) op.add_column('user', sa.Column('status', sa.SmallInteger(), nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('character', sa.Column('classname', sa.String(length=10), nullable=True)) op.add_column( 'character', sa.Column('level', sa.SmallInteger(), nullable=False, server_default="1")) op.add_column( 'character', sa.Column('xp', sa.Integer(), nullable=False, server_default="0"))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'test_category', sa.Column('id', postgresql.UUID(as_uuid=True), nullable=False), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('status', sa.SmallInteger(), server_default='1', nullable=False), sa.Column('updated_at', sa.DateTime(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=False), sa.PrimaryKeyConstraint('id'))
def upgrade(): op.add_column('jobpost', sa.Column('pay_cash_max', sa.Integer(), nullable=True)) op.add_column('jobpost', sa.Column('pay_cash_min', sa.Integer(), nullable=True)) op.add_column('jobpost', sa.Column('pay_currency', sa.CHAR(length=3), nullable=True)) op.add_column('jobpost', sa.Column('pay_equity_max', sa.Numeric(), nullable=True)) op.add_column('jobpost', sa.Column('pay_equity_min', sa.Numeric(), nullable=True)) op.add_column('jobpost', sa.Column('pay_type', sa.SmallInteger(), nullable=True))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('block', sa.Column('id', sa.Integer(), nullable=False), sa.Column('hash', sa.LargeBinary(length=64), nullable=True), sa.Column('height', sa.Integer(), nullable=False), sa.Column('ntime', sa.DateTime(), nullable=False), sa.Column('orphan', sa.Boolean(), nullable=True), sa.Column('total_in', lincoln.model_lib.SqliteNumeric(precision=1000, scale=28), nullable=True), sa.Column('total_out', lincoln.model_lib.SqliteNumeric(precision=1000, scale=28), nullable=True), sa.Column('difficulty', sa.Float(), nullable=False), sa.Column('currency', sa.String(), nullable=False), sa.Column('algo', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('hash') ) op.create_table('transaction', sa.Column('id', sa.Integer(), nullable=False), sa.Column('txid', sa.LargeBinary(length=64), nullable=True), sa.Column('network_fee', lincoln.model_lib.SqliteNumeric(precision=1000, scale=28), nullable=True), sa.Column('coinbase', sa.Boolean(), nullable=True), sa.Column('block_id', sa.Integer(), nullable=True), sa.Column('total_in', lincoln.model_lib.SqliteNumeric(precision=1000, scale=28), nullable=True), sa.Column('total_out', lincoln.model_lib.SqliteNumeric(precision=1000, scale=28), nullable=True), sa.ForeignKeyConstraint(['block_id'], ['block.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('txid') ) op.create_table('output', sa.Column('type', sa.SmallInteger(), nullable=True), sa.Column('origin_tx_hash', sa.LargeBinary(length=64), nullable=False), sa.Column('amount', lincoln.model_lib.SqliteNumeric(precision=1000, scale=28), nullable=True), sa.Column('index', sa.SmallInteger(), nullable=False), sa.Column('dest_address', sa.LargeBinary(), nullable=True), sa.Column('spend_tx_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['origin_tx_hash'], ['transaction.txid'], ), sa.ForeignKeyConstraint(['spend_tx_id'], ['transaction.id'], ), sa.PrimaryKeyConstraint('origin_tx_hash', 'index') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('ohho_map_information', sa.Column('building', sa.String(length=16), nullable=True)) op.add_column('ohho_map_information', sa.Column('location_type', sa.Integer(), nullable=True)) op.drop_column('ohho_map_information', 'building_id') op.add_column('ohho_user_accuracy_extension', sa.Column('able2match', sa.Integer(), nullable=True)) op.add_column('ohho_user_accuracy_extension', sa.Column('degree_id', sa.Integer(), nullable=True)) op.add_column( 'ohho_user_accuracy_extension', sa.Column('favourite_live_city', sa.String(length=64), nullable=True)) op.add_column('ohho_user_accuracy_extension', sa.Column('occupation_id', sa.Integer(), nullable=True)) op.add_column('ohho_user_accuracy_extension', sa.Column('position_id', sa.Integer(), nullable=True)) op.create_foreign_key(None, 'ohho_user_accuracy_extension', 'ohho_interest', ['degree_id'], ['id'], onupdate='CASCADE', ondelete='CASCADE') op.create_foreign_key(None, 'ohho_user_accuracy_extension', 'ohho_interest', ['occupation_id'], ['id'], onupdate='CASCADE', ondelete='CASCADE') op.create_foreign_key(None, 'ohho_user_accuracy_extension', 'ohho_interest', ['position_id'], ['id'], onupdate='CASCADE', ondelete='CASCADE') op.drop_column('ohho_user_accuracy_extension', 'current') op.drop_column('ohho_user_accuracy_extension', 'source_icon') op.drop_column('ohho_user_accuracy_extension', 'weight') op.drop_column('ohho_user_accuracy_extension', 'icon') op.drop_column('ohho_user_accuracy_extension', 'education') op.drop_column('ohho_user_accuracy_extension', 'email') op.drop_column('ohho_user_accuracy_extension', 'marriage') op.drop_column('ohho_user_accuracy_extension', 'resume') op.drop_column('ohho_user_accuracy_extension', 'blood') op.drop_column('ohho_user_accuracy_extension', 'interest') op.add_column('test_rssi', sa.Column('real_distance', sa.Float(), nullable=True)) op.add_column('test_rssi_distance', sa.Column('compute_distance', sa.Float(), nullable=True)) op.add_column('test_rssi_distance', sa.Column('compute_type', sa.SmallInteger(), nullable=True)) op.add_column('test_rssi_distance', sa.Column('real_distance', sa.Float(), nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('test_phone_position', sa.Column('address', sa.String(length=128), nullable=True)) op.add_column('test_phone_position', sa.Column('altitude', sa.Float(), nullable=True)) op.add_column('test_phone_position', sa.Column('angle', sa.Float(), nullable=True)) op.add_column('test_phone_position', sa.Column('aoi', sa.String(length=64), nullable=True)) op.add_column('test_phone_position', sa.Column('area', sa.String(length=32), nullable=True)) op.add_column('test_phone_position', sa.Column('area_code', sa.String(length=32), nullable=True)) op.add_column('test_phone_position', sa.Column('building_id', sa.Integer(), nullable=True)) op.add_column('test_phone_position', sa.Column('city', sa.String(length=32), nullable=True)) op.add_column('test_phone_position', sa.Column('city_code', sa.String(length=32), nullable=True)) op.add_column('test_phone_position', sa.Column('country', sa.String(length=32), nullable=True)) op.add_column('test_phone_position', sa.Column('floor', sa.String(length=16), nullable=True)) op.add_column( 'test_phone_position', sa.Column('interest_point', sa.String(length=64), nullable=True)) op.add_column('test_phone_position', sa.Column('position_time', sa.DateTime(), nullable=True)) op.add_column('test_phone_position', sa.Column('province', sa.String(length=32), nullable=True)) op.add_column('test_phone_position', sa.Column('satellite_number', sa.Integer(), nullable=True)) op.add_column('test_phone_position', sa.Column('speed', sa.String(length=16), nullable=True)) op.add_column('test_phone_position', sa.Column('supplier', sa.String(length=32), nullable=True)) op.add_column('test_phone_position', sa.Column('type', sa.Integer(), nullable=True)) op.add_column('test_rssi', sa.Column('device', sa.String(length=64), nullable=True)) op.add_column('test_rssi', sa.Column('phone', sa.String(length=64), nullable=True)) op.add_column('test_rssi', sa.Column('rssi', sa.Integer(), nullable=True)) op.add_column('test_rssi', sa.Column('type', sa.SmallInteger(), nullable=True)) op.drop_column('test_rssi', 'self_rssi') op.drop_column('test_rssi', 'user') op.drop_column('test_rssi', 'other_rssi') op.add_column('test_rssi_distance', sa.Column('phone', sa.String(length=128), nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'user', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=32), nullable=False), sa.Column('email', sa.String(length=64), nullable=False), sa.Column('password', sa.String(length=256), nullable=False), sa.Column('role', sa.SmallInteger(), nullable=True), sa.Column('job', sa.String(length=64), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=True) op.create_index(op.f('ix_user_username'), 'user', ['username'], unique=True) op.create_table( 'course', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=128), nullable=False), sa.Column('description', sa.String(length=256), nullable=True), sa.Column('image_url', sa.String(length=256), nullable=True), sa.Column('author_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['author_id'], ['user.id'], ondelete='SET NULL'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_course_name'), 'course', ['name'], unique=True) op.create_table( 'live', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=128), nullable=True), sa.Column('url', sa.String(length=256), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['user_id'], ['user.id'], ondelete='SET NULL'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_live_name'), 'live', ['name'], unique=True) op.create_table( 'chapter', sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=128), nullable=False), sa.Column('description', sa.String(length=256), nullable=True), sa.Column('video_url', sa.String(length=256), nullable=True), sa.Column('video_duration', sa.String(length=24), nullable=True), sa.Column('course_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['course_id'], ['course.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_chapter_name'), 'chapter', ['name'], unique=True)
def upgrade(): """Upgrade database model.""" op.create_table( 'leadorder_version', sa.Column('id', types.uuid.UUIDType(), autoincrement=False, nullable=False), sa.Column('transaction_id', sa.BigInteger(), autoincrement=False, nullable=False), sa.Column('end_transaction_id', sa.BigInteger(), nullable=True), sa.Column('operation_type', sa.SmallInteger(), nullable=False), sa.PrimaryKeyConstraint('id', 'transaction_id')) op.create_index(op.f('ix_leadorder_version_end_transaction_id'), 'leadorder_version', ['end_transaction_id'], unique=False) op.create_index(op.f('ix_leadorder_version_id'), 'leadorder_version', ['id'], unique=False) op.create_index(op.f('ix_leadorder_version_operation_type'), 'leadorder_version', ['operation_type'], unique=False) op.create_index(op.f('ix_leadorder_version_transaction_id'), 'leadorder_version', ['transaction_id'], unique=False) op.create_table('leadorder', sa.Column('id', types.uuid.UUIDType(), nullable=False), sa.ForeignKeyConstraint( ['id'], ['orders.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_leadorder_id'), 'leadorder', ['id'], unique=True) op.add_column('orders', sa.Column('type', sa.String(), nullable=True)) op.add_column( 'orders_version', sa.Column('type', sa.String(), autoincrement=False, nullable=True)) op.add_column( 'projects', sa.Column('order_type', types.choice.ChoiceType(OrderTypeChoices, impl=sa.String()), server_default='order', nullable=False)) op.add_column( 'projects_version', sa.Column('order_type', types.choice.ChoiceType(OrderTypeChoices, impl=sa.String()), server_default='order', autoincrement=False, nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('message', sa.Column('mxid', sa.String(length=255), nullable=True), sa.Column('mx_room', sa.String(length=255), nullable=True), sa.Column('gid', sa.String(length=255), nullable=False), sa.PrimaryKeyConstraint('gid'), sa.UniqueConstraint('mxid', 'mx_room', name='_mx_id_room')) op.create_table( 'mx_room_state', sa.Column('room_id', sa.String(length=255), nullable=False), sa.Column('power_levels', PowerLevelType(), nullable=True), sa.PrimaryKeyConstraint('room_id')) op.create_table( 'mx_user_profile', sa.Column('room_id', sa.String(length=255), nullable=False), sa.Column('user_id', sa.String(length=255), nullable=False), sa.Column('membership', sa.Enum('JOIN', 'LEAVE', 'INVITE', 'BAN', 'KNOCK', name='membership'), nullable=False), sa.Column('displayname', sa.String(), nullable=True), sa.Column('avatar_url', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('room_id', 'user_id')) op.create_table( 'portal', sa.Column('gid', sa.String(length=255), nullable=False), sa.Column('conv_type', sa.SmallInteger(), nullable=False), sa.Column('other_user_id', sa.String(length=255), nullable=True), sa.Column('mxid', sa.String(length=255), nullable=True), sa.Column('name', sa.String(), nullable=True), sa.PrimaryKeyConstraint('gid'), sa.UniqueConstraint('mxid')) op.create_table( 'puppet', sa.Column('gid', sa.String(length=255), nullable=False), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('photo_url', sa.String(length=255), nullable=True), sa.Column('matrix_registered', sa.Boolean(), server_default=sa.text('false'), nullable=False), sa.Column('custom_mxid', sa.String(length=255), nullable=True), sa.Column('access_token', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('gid')) op.create_table( 'user', sa.Column('mxid', sa.String(length=255), nullable=False), sa.Column('gid', sa.String(length=255), nullable=True), sa.Column('refresh_token', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('mxid'))
def upgrade(): op.create_table('factory', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('player_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['player_id'], ['player.id'], name=op.f('fk_factory_player_id_player')), sa.PrimaryKeyConstraint('id', name=op.f('pk_factory')) ) op.create_table('factory_track', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date_time', sa.DateTime(), nullable=True), sa.Column('state_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['state_id'], ['state.id'], name=op.f('fk_factory_track_state_id_state')), sa.PrimaryKeyConstraint('id', name=op.f('pk_factory_track')) ) op.create_table('military_academy', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date_time', sa.DateTime(), nullable=True), sa.Column('player_id', sa.Integer(), nullable=True), sa.Column('region_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['player_id'], ['player.id'], name=op.f('fk_military_academy_player_id_player')), sa.ForeignKeyConstraint(['region_id'], ['region.id'], name=op.f('fk_military_academy_region_id_region')), sa.PrimaryKeyConstraint('id', name=op.f('pk_military_academy')) ) op.create_table('factory_stat', sa.Column('id', sa.Integer(), nullable=False), sa.Column('level', sa.SmallInteger(), nullable=True), sa.Column('workers', sa.SmallInteger(), nullable=True), sa.Column('experience', sa.Integer(), nullable=True), sa.Column('wage', sa.Integer(), nullable=True), sa.Column('factory_id', sa.Integer(), nullable=True), sa.Column('factory_track_id', sa.Integer(), nullable=True), sa.Column('region_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['factory_id'], ['factory.id'], name=op.f('fk_factory_stat_factory_id_factory')), sa.ForeignKeyConstraint(['factory_track_id'], ['factory_track.id'], name=op.f('fk_factory_stat_factory_track_id_factory_track')), sa.ForeignKeyConstraint(['region_id'], ['region.id'], name=op.f('fk_factory_stat_region_id_region')), sa.PrimaryKeyConstraint('id', name=op.f('pk_factory_stat')) )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('dj_agent_apply', sa.Column('agentId', sa.String(length=64), nullable=False), sa.Column('applyTime', sa.Integer(), nullable=False), sa.Column('qq', sa.String(length=64), nullable=False), sa.Column('website', sa.String(length=255), nullable=True), sa.Column('introduction', sa.Text(length=65536), nullable=False), sa.Column('status', sa.SmallInteger(), nullable=False), sa.PrimaryKeyConstraint('agentId') ) op.add_column('dj_admin_action', sa.Column('testAA', sa.Integer(), nullable=True)) op.add_column('dj_agent_commission', sa.Column('platformCost', sa.Integer(), nullable=False)) op.add_column('dj_agent_commission', sa.Column('winLoss', sa.Integer(), nullable=False))
def upgrade(): op.create_table( "taxref", sa.Column("REGNE", sa.String(18), nullable=True), sa.Column("PHYLUM", sa.String(50), nullable=True), sa.Column("CLASSE", sa.String(50), nullable=True), sa.Column("ORDRE", sa.String(60), nullable=True), sa.Column("FAMILLE", sa.String(72), nullable=True), sa.Column("SOUS_FAMILLE", sa.String(50), nullable=True), sa.Column("TRIBU", sa.String(44), nullable=True), sa.Column("GROUP1_INPN", sa.String(34), nullable=True), sa.Column("GROUP2_INPN", sa.String(54), nullable=True), sa.Column("CD_NOM", sa.Integer(), nullable=False), sa.Column("CD_TAXSUP", sa.Integer(), nullable=True), sa.Column("CD_SUP", sa.Integer(), nullable=True), sa.Column("CD_REF", sa.Integer(), nullable=True), sa.Column("RANG", sa.String(8), nullable=True), sa.Column("LB_NOM", sa.String(174), nullable=False), sa.Column("LB_AUTEUR", sa.String(952), nullable=True), sa.Column("NOM_COMPLET", sa.String(980), nullable=True), sa.Column("NOM_COMPLET_HTML", sa.String(980), nullable=True), sa.Column("NOM_VALIDE", sa.String(980), nullable=True), sa.Column("NOM_VERN", sa.String(1248), nullable=True), sa.Column("NOM_VERN_ENG", sa.String(282), nullable=True), sa.Column("HABITAT", sa.SmallInteger(), nullable=True), sa.Column("FR", sa.String(2), nullable=True), sa.Column("GF", sa.String(2), nullable=True), sa.Column("MAR", sa.String(2), nullable=True), sa.Column("GUA", sa.String(2), nullable=True), sa.Column("SM", sa.String(2), nullable=True), sa.Column("SB", sa.String(2), nullable=True), sa.Column("SPM", sa.String(2), nullable=True), sa.Column("MAY", sa.String(2), nullable=True), sa.Column("EPA", sa.String(2), nullable=True), sa.Column("REU", sa.String(2), nullable=True), sa.Column("SA", sa.String(2), nullable=True), sa.Column("TA", sa.String(2), nullable=True), sa.Column("TAAF", sa.String(2), nullable=True), sa.Column("PF", sa.String(2), nullable=True), sa.Column("NC", sa.String(2), nullable=True), sa.Column("WF", sa.String(2), nullable=True), sa.Column("CLI", sa.String(2), nullable=True), sa.Column("URL", sa.String(82), nullable=True), sa.PrimaryKeyConstraint("CD_NOM"), ) op.create_index(op.f("ix_taxref_CD_NOM"), "taxref", ["CD_NOM"], unique=True) op.create_index(op.f("ix_taxref_LB_NOM"), "taxref", ["LB_NOM"]) op.create_index(op.f("ix_taxref_NOM_VERN"), "taxref", ["NOM_VERN"])
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'board', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(length=200), nullable=False), sa.Column('description', sa.String(length=200), nullable=True), sa.Column('status', sa.SmallInteger(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): op.create_table('player_market_stat', sa.Column('id', sa.Integer(), nullable=False), sa.Column('item_type', sa.SmallInteger(), nullable=True), sa.Column('price', sa.Integer(), nullable=True), sa.Column('amount', sa.BigInteger(), nullable=True), sa.Column('total_offers', sa.Integer(), nullable=True), sa.Column('player_id', sa.Integer(), nullable=True), sa.Column('market_track_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['market_track_id'], ['market_track.id'], name=op.f('fk_player_market_stat_market_track_id_market_track')), sa.ForeignKeyConstraint(['player_id'], ['player.id'], name=op.f('fk_player_market_stat_player_id_player')), sa.PrimaryKeyConstraint('id', name=op.f('pk_player_market_stat')) ) op.drop_table('personal_market_stat')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'tb_product', sa.Column('description', sa.String(length=128), nullable=True, comment='SKU描述')) op.add_column( 'tb_product', sa.Column('keywords', sa.String(length=128), nullable=True, comment='关键词')) op.add_column( 'tb_product', sa.Column('name', sa.String(length=128), nullable=True, comment='产品标题')) op.add_column( 'tb_product', sa.Column('price', sa.DECIMAL(precision=5, scale=2), nullable=True, comment='商品最低价格,保留2位小数')) op.add_column( 'tb_product', sa.Column('rating', sa.Float(precision=2), nullable=True, comment='商品评分')) op.add_column( 'tb_product', sa.Column('review_count', sa.Integer(), nullable=True, comment='评论数量')) op.add_column( 'tb_product', sa.Column('sales_volume', sa.Integer(), nullable=True, comment='销售量')) op.add_column( 'tb_product', sa.Column('status', sa.SmallInteger(), nullable=True, comment='是否在售')) op.add_column( 'tb_product', sa.Column('thumbnail', sa.String(length=255), nullable=True, comment='缩略图')) op.alter_column('tb_product', 'title', existing_type=mysql.VARCHAR(length=64), comment='url_标题', existing_nullable=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'fp_currency', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(length=32), nullable=False), sa.Column('code', sa.String(length=3), nullable=False), sa.Column('symbol_left', sa.String(length=12), nullable=True), sa.Column('symbol_right', sa.String(length=12), nullable=True), sa.Column('decimal_place', sa.String(length=1), nullable=False), sa.Column('value', sa.Float(precision=15, asdecimal=8), nullable=False), sa.Column('status', sa.SmallInteger(), nullable=True), sa.Column('updated_at', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('title'))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('available_users', sa.Column('username', sa.String(), nullable=False), sa.Column('joined', sa.DateTime(), nullable=True), sa.Column('tile_id', sa.String(), nullable=True), sa.Column('tile_name', sa.String(), nullable=True), sa.Column('lat', sa.Float(), nullable=True), sa.Column('lon', sa.Float(), nullable=True), sa.PrimaryKeyConstraint('username')) op.create_table('tiles', sa.Column('id', sa.String(), nullable=False), sa.Column('name', sa.String(), nullable=False), sa.Column('lat', sa.Float(), nullable=False), sa.Column('lon', sa.Float(), nullable=False), sa.PrimaryKeyConstraint('id')) op.add_column('locations', sa.Column('lon', sa.Float(), nullable=False)) op.drop_column('locations', 'long') op.add_column('proposals', sa.Column('delay', sa.SmallInteger(), nullable=False)) op.add_column('proposals', sa.Column('tile', sa.String(), nullable=False)) op.add_column('proposals', sa.Column('user1_accepted', sa.Boolean(), nullable=True)) op.add_column('proposals', sa.Column('user1_id', sa.String(), nullable=False)) op.add_column('proposals', sa.Column('user2_accpeted', sa.Boolean(), nullable=True)) op.add_column('proposals', sa.Column('user2_id', sa.String(), nullable=False)) op.drop_constraint(u'proposals_proposer_id_fkey', 'proposals', type_='foreignkey') op.drop_constraint(u'proposals_recipient_id_fkey', 'proposals', type_='foreignkey') op.drop_column('proposals', 'proposer_id') op.drop_column('proposals', 'recipient_id') op.drop_column('proposals', 'accepted') op.drop_column('proposals', 'meeting_time') op.drop_constraint(u'questions_question_key', 'questions', type_='unique') op.alter_column('users', 'created', existing_type=postgresql.TIMESTAMP(), nullable=True) op.alter_column('users', 'username', existing_type=sa.VARCHAR(length=36), nullable=False) op.create_unique_constraint(None, 'users', ['email'])
class posts(Base): """Class Info, functionality, purpose""" __tablename__ = "posts" # Columns # Local stuff post_id = sqlalchemy.Column(sqlalchemy.BigInteger(), primary_key=True)# referenced by sub-tables date_saved = sqlalchemy.Column(sqlalchemy.BigInteger())# The unix time the post was saved blog_id = sqlalchemy.Column(sqlalchemy.BigInteger(), sqlalchemy.ForeignKey("blogs.blog_id")) # source_id = sqlalchemy.Column(sqlalchemy.BigInteger()) # ID number tumblr gave us for the post post_type = sqlalchemy.Column(sqlalchemy.SmallInteger()) # numerical identifier for what kind of post this is source_url = sqlalchemy.Column(sqlalchemy.UnicodeText()) # post_dict["post_url"] timestamp = sqlalchemy.Column(sqlalchemy.BigInteger()) # timestamp of post as given by API tags = sqlalchemy.Column(sqlalchemy.UnicodeText())# Comma seperated tags hidden = sqlalchemy.Column(sqlalchemy.Boolean())# Should this be hidden from users?
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column('jobpost', sa.Column('pay_cash_max', sa.Integer(), nullable=True)) op.add_column('jobpost', sa.Column('pay_cash_min', sa.Integer(), nullable=True)) op.add_column('jobpost', sa.Column('pay_currency', sa.CHAR(length=3), nullable=True)) op.add_column('jobpost', sa.Column('pay_equity_max', sa.Numeric(), nullable=True)) op.add_column('jobpost', sa.Column('pay_equity_min', sa.Numeric(), nullable=True)) op.add_column('jobpost', sa.Column('pay_type', sa.SmallInteger(), nullable=True))