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