def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'users', sa.Column('user_md5', mysql.VARCHAR(length=45),
nullable=True))
op.create_index('user_md5_UNIQUE', 'users', ['user_md5'], unique=True)
op.drop_index(op.f('ix_ratings_user_id'), table_name='ratings')
op.drop_index(op.f('ix_ratings_m_id'), table_name='ratings')
op.create_table('ratings2',
sa.Column('rating_id',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True),
sa.Column('user_md5', mysql.TEXT(), nullable=True),
sa.Column('m_id',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True),
sa.Column('rating',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True),
sa.Column('rating_time', mysql.TEXT(), nullable=True),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'discord_server_lists',
sa.Column('id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('invite_id', sa.String(length=45), nullable=False),
sa.Column('category_id',
mysql.INTEGER(display_width=11),
nullable=True), sa.PrimaryKeyConstraint('id'))
op.create_table(
'discord_server_categories',
sa.Column('id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('guild_id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('channel_id', mysql.BIGINT(display_width=20),
nullable=False),
sa.Column('category_title', sa.String(length=200), nullable=False),
sa.Column('category_description', sa.String(length=200),
nullable=True), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_audit_generated_games_hash_id'),
'audit_generated_games', ['hash_id'],
unique=False)
op.drop_index('idx_audit_generated_games_hash_id',
table_name='audit_generated_games')
op.create_index(op.f('ix_audit_messages_message_id'),
'audit_messages', ['message_id'],
unique=False)
op.drop_index('idx_audit_messages_message_id', table_name='audit_messages')
op.create_index(op.f('ix_srlnick_srl_nick'),
'srlnick', ['srl_nick'],
unique=False)
op.create_index(op.f('ix_srlnick_twitch_name'),
'srlnick', ['twitch_name'],
unique=False)
op.drop_index('idx_srlnick_srl_nick', table_name='srlnick')
op.drop_index('idx_srlnick_twitch_name', table_name='srlnick')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint('fk_urf_resources_fulfilled', 'user_resource_fulfillment', type_='foreignkey')
op.drop_constraint('fk_urf_resources_fulfilling', 'user_resource_fulfillment', type_='foreignkey')
op.create_foreign_key('user_resource_fulfillment_ibfk_1', 'user_resource_fulfillment', 'user_resources', ['fulfilled_resource_id'], ['id'], onupdate='CASCADE')
op.create_foreign_key('user_resource_fulfillment_ibfk_2', 'user_resource_fulfillment', 'user_resources', ['fulfilling_resource_id'], ['id'], onupdate='CASCADE')
op.create_table('user_resources',
sa.Column('created_at', mysql.DATETIME(), nullable=False),
sa.Column('updated_at', mysql.DATETIME(), nullable=False),
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('user_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('type', mysql.VARCHAR(length=8), nullable=True),
sa.Column('quantity_available', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('quantity_needed', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('fulfilled', mysql.TINYINT(display_width=1), server_default=sa.text("'0'"), autoincrement=False, nullable=False),
sa.Column('category_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['category_id'], ['categories.id'], name='fk_user_resources_categories', onupdate='CASCADE'),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='user_resources_ibfk_2', onupdate='CASCADE', ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.drop_index(op.f('ix_resources_updated_at'), table_name='resources')
op.drop_index(op.f('ix_resources_type'), table_name='resources')
op.drop_index(op.f('ix_resources_created_at'), table_name='resources')
op.drop_table('resources')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('series',
'name',
existing_type=mysql.VARCHAR(length=255),
nullable=True)
op.alter_column('series',
'igdb_id',
existing_type=mysql.BIGINT(display_width=20),
nullable=True)
op.alter_column('genres',
'name',
existing_type=mysql.VARCHAR(length=255),
nullable=True)
op.alter_column('genres',
'igdb_id',
existing_type=mysql.BIGINT(display_width=20),
nullable=True)
op.alter_column('games',
'name',
existing_type=mysql.VARCHAR(length=255),
nullable=True)
op.alter_column('games',
'igdb_id',
existing_type=mysql.BIGINT(display_width=20),
nullable=True)
op.alter_column('companies',
'name',
existing_type=mysql.VARCHAR(length=255),
nullable=True)
op.alter_column('companies',
'igdb_id',
existing_type=mysql.BIGINT(display_width=20),
nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'video',
sa.Column('thanks',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True))
op.add_column(
'video',
sa.Column('unlike',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True))
op.drop_index(op.f('ix_user_log_ip'), table_name='user_log')
op.drop_column('user_log', 'info')
op.add_column(
'user',
sa.Column('like_num',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True))
op.add_column(
'user',
sa.Column('thanks_num',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True))
op.drop_column('user', 'get_like_num')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('migrations')
op.drop_index('source_index', table_name='source')
op.create_unique_constraint(None, 'source', ['url'])
op.create_unique_constraint(None, 'source', ['feed_link'])
op.drop_index('source_subscription_index', table_name='source_subscription')
op.alter_column('user', 'email',
existing_type=mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=255),
nullable=True)
op.drop_index('user_index', table_name='user')
op.create_unique_constraint(None, 'user', ['social_id'])
# ### end Alembic commands ###
op.create_table('post',
sa.Column('id', mysql.BIGINT(display_width=20, unsigned=True), autoincrement=True, nullable=False),
sa.Column('source_id', mysql.BIGINT(display_width=20, unsigned=True), nullable=False),
sa.Column('title', mysql.VARCHAR(length=255), nullable=False),
sa.Column('content', mysql.TEXT(), nullable=False),
sa.Column('link', mysql.VARCHAR(length=2000), nullable=False),
sa.Column('author', mysql.VARCHAR(length=255), nullable=False),
sa.Column('fetched_at', mysql.TIMESTAMP(), nullable=True),
sa.Column('published_at', mysql.TIMESTAMP(), nullable=True),
sa.Column('updated_at', mysql.TIMESTAMP(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.create_index('post_index', 'post', ['source_id', 'fetched_at', 'published_at'])
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'permissions',
sa.Column('id', mysql.BIGINT(), nullable=False, autoincrement=False),
sa.Column('permission', sa.VARCHAR(length=100), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_permissions_permission'),
'permissions', ['permission'],
unique=True)
op.create_table(
'agent_permission',
sa.Column('agent_id', mysql.INTEGER(), nullable=True),
sa.Column('permission_id', mysql.BIGINT(), nullable=True),
sa.ForeignKeyConstraint(
['agent_id'],
['tokens.agent_id'],
), sa.ForeignKeyConstraint(
['permission_id'],
['permissions.id'],
))
op.create_index('agent_id_permission_id',
'agent_permission', ['agent_id', 'permission_id'],
unique=False)
query = 'INSERT INTO `permissions` (`id`, `permission`) VALUES (4, "apply_voucher"), (3, "check_voucher"), (1, "create_voucher"), (5, "fetch_voucher"),(0, "no_permission_required"), (7, "test"), (6, "update_order_status"), (2, "update_voucher")'
op.execute(text(query))
query = 'delete from tokens where agent_id=0'
op.execute(text(query))
query = 'INSERT INTO `tokens` (`token`, `agent_id`, `agent_name`, `created_at`, `last_accessed_at`) VALUES ("anonymous", 0, "anonymous", "2016-06-10 13:53:53.000000", "2016-06-10 13:53:53.000000")'
op.execute(text(query))
query = 'INSERT INTO `agent_permission` (`agent_id`, `permission_id`) VALUES (0, 1),(0, 2),(0, 5),(0, 6)'
op.execute(text(query))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_column('ns_users', 'password_hash')
op.create_table('ns_rooms',
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('number', mysql.VARCHAR(length=5), nullable=True),
sa.Column('name', mysql.VARCHAR(length=20), nullable=True),
sa.Column('created_at', mysql.DATETIME(), nullable=True),
sa.Column('updated_at', mysql.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('ns_books',
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('room_count', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('checkin_on', sa.DATE(), nullable=True),
sa.Column('checkout_on', sa.DATE(), nullable=True),
sa.Column('user_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('created_at', mysql.DATETIME(), nullable=True),
sa.Column('updated_at', mysql.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], [u'ns_users.id'], name=u'ns_books_ibfk_1'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('ns_room_books',
sa.Column('room_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('book_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['book_id'], [u'ns_books.id'], name=u'ns_room_books_ibfk_2'),
sa.ForeignKeyConstraint(['room_id'], [u'ns_rooms.id'], name=u'ns_room_books_ibfk_1'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
class User(BASE):
__tablename__ = "users_main"
id = Column("ID", mysql.INTEGER(10, unsigned=True), primary_key=True)
username = Column('Username', mysql.VARCHAR(20))
email = Column('Email', mysql.VARCHAR(255))
pass_hash = Column('PassHash', mysql.VARCHAR(60))
secret = Column('Secret', mysql.VARCHAR(32))
irc_key = Column('IRCKey', mysql.CHAR(32))
last_login = Column('LastLogin', mysql.DATETIME)
last_access = Column('LastAccess', mysql.DATETIME)
ip = Column('IP', mysql.VARCHAR(15))
class_id = Column('Class', mysql.TINYINT(2))
uploaded = Column('Uploaded', mysql.BIGINT(20, unsigned=True))
downloaded = Column('Downloaded', mysql.BIGINT(20, unsigned=True))
title = Column('Title', mysql.TEXT)
enabled = Column('Enabled', mysql.ENUM('0', '1', '2'))
paranoia = Column('Paranoia', mysql.TEXT)
visible = Column('Visible', mysql.ENUM('1', '0'))
invites = Column('Invites', mysql.INTEGER(10, unsigned=True))
permission_id = Column('PermissionID', mysql.INTEGER(10, unsigned=True),
ForeignKey('permissions.ID'))
custom_permissions = Column('CustomPermissions', mysql.TEXT)
can_leech = Column('can_leech', mysql.TINYINT(4))
torrent_pass = Column('torrent_pass', mysql.CHAR(32))
required_ratio = Column('RequiredRatio', mysql.DOUBLE(10, 8))
required_ratio_work = Column('RequiredRatioWork', mysql.DOUBLE(10, 8))
ipcc = Column('ipcc', mysql.VARCHAR(2))
fl_tokens = Column('FLTokens', mysql.INTEGER(10))
permission_class = relationship("Permissions")
info = relationship("UsersInfo")
def get_paranoia(self):
return dict_to_list(unserialize(bytes(str(self.paranoia), 'utf-8')))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('cart_products',
sa.Column('id',
mysql.BIGINT(display_width=20, unsigned=True),
autoincrement=True,
nullable=False),
sa.Column('cart_id',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.Column('product_id',
mysql.BIGINT(display_width=20, unsigned=True),
autoincrement=False,
nullable=False),
sa.Column('quantity',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.ForeignKeyConstraint(['cart_id'], ['cart.id'],
name='cart_products_ibfk_1'),
sa.ForeignKeyConstraint(['product_id'], ['product.id'],
name='cart_products_ibfk_2'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='latin1',
mysql_engine='InnoDB')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('department_tree',
sa.Column('id',
mysql.BIGINT(display_width=20, unsigned=True),
nullable=False),
sa.Column('department_id',
mysql.BIGINT(display_width=20, unsigned=True),
autoincrement=False,
nullable=False),
sa.Column('parent_id',
mysql.BIGINT(display_width=20, unsigned=True),
autoincrement=False,
nullable=False),
sa.Column('depth',
mysql.BIGINT(display_width=20, unsigned=True),
autoincrement=False,
nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_index('idx_department_tree_p',
'department_tree', ['parent_id'],
unique=False)
op.create_index('idx_department_tree_d',
'department_tree', ['department_id'],
unique=False)
op.drop_index('idx_department_tree_p', table_name='department_closure')
op.drop_index('idx_department_tree_d', table_name='department_closure')
op.drop_table('department_closure')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('employee', 'department_id')
op.add_column(
'department_tree',
sa.Column('parent_path', mysql.VARCHAR(length=128), nullable=False))
op.drop_index('idx_department_tree_p', table_name='department_tree')
op.drop_index('idx_department_tree_d', table_name='department_tree')
op.drop_column('department_tree', 'parent_id')
op.drop_column('department_tree', 'depth')
op.drop_column('department_tree', 'department_id')
op.add_column(
'department_permission',
sa.Column('leader_only',
mysql.TINYINT(display_width=1),
autoincrement=False,
nullable=False))
op.drop_index('idx_department_permission_d',
table_name='department_permission')
op.create_table('employee_department',
sa.Column('employee_id',
mysql.BIGINT(display_width=20, unsigned=True),
nullable=False),
sa.Column('department_id',
mysql.BIGINT(display_width=20, unsigned=True),
autoincrement=False,
nullable=False),
sa.PrimaryKeyConstraint('employee_id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.drop_index('idx_leader_permission_d', table_name='leader_permission')
op.drop_table('leader_permission')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('tb_file',
sa.Column('id',
mysql.BIGINT(display_width=20),
autoincrement=True,
nullable=False),
sa.Column('mission_url',
mysql.VARCHAR(length=128),
nullable=True),
sa.Column('mission_name',
mysql.VARCHAR(length=64),
nullable=True),
sa.Column('file_url',
mysql.VARCHAR(length=128),
nullable=True),
sa.Column('file_name',
mysql.VARCHAR(length=64),
nullable=True),
sa.Column('student_id',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True),
sa.ForeignKeyConstraint(['student_id'], ['tb_student.id'],
name='tb_file_ibfk_1'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='gb2312',
mysql_engine='InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'smz3_multiworld',
sa.Column('message_id', mysql.BIGINT(display_width=20),
nullable=False),
sa.Column('owner_id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('status', mysql.VARCHAR(length=20), nullable=False),
sa.PrimaryKeyConstraint('message_id'))
def upgrade():
op.create_table(
'perf_importer_cycle_infos',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('execution_date', mysql.DATETIME(), nullable=True),
sa.Column('prediction_start_date', mysql.DATETIME(), nullable=True),
sa.Column('prediction_end_date', mysql.DATETIME(), nullable=True),
sa.Column('file_name', mysql.TEXT(collation='utf8mb4_unicode_ci'), nullable=True),
sa.Column('computed', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True),
sa.Column('on_google_sheets', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.create_table(
'perf_division_per_rome',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('importer_cycle_infos_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('codenaf', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=False),
sa.Column('coderome', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=False),
sa.Column('threshold_lbb', mysql.FLOAT(), nullable=True),
sa.Column('threshold_lba', mysql.FLOAT(), nullable=True),
sa.Column('nb_bonne_boites_lbb', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('nb_bonne_boites_lba', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['importer_cycle_infos_id'], ['perf_importer_cycle_infos.id'], name='perf_division_per_rome_ibfk_1', ondelete='SET NULL'),
sa.PrimaryKeyConstraint('id'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.create_table(
'perf_prediction_and_effective_hirings',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('importer_cycle_infos_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('siret', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True),
sa.Column('codenaf', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=True),
sa.Column('codecommune', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True),
sa.Column('codepostal', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=True),
sa.Column('departement', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=8), nullable=True),
sa.Column('raisonsociale', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True),
sa.Column('enseigne', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=191), nullable=True),
sa.Column('lbb_nb_predicted_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('lba_nb_predicted_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('lbb_nb_predicted_hirings_score', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('lba_nb_predicted_hirings_score', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('lbb_nb_effective_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('lba_nb_effective_hirings', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('is_a_bonne_boite', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True),
sa.Column('is_a_bonne_alternance', mysql.TINYINT(display_width=1), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['importer_cycle_infos_id'], ['perf_importer_cycle_infos.id'], name='perf_prediction_and_effective_hirings_ibfk_1', ondelete='SET NULL'),
sa.PrimaryKeyConstraint('id'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('all_vouchers_log_sequence',
sa.Column('id', mysql.BIGINT(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'all_vouchers_log', sa.Column('auto_id',
mysql.BIGINT(),
nullable=False),
sa.Column('change_id', mysql.BIGINT(), nullable=False),
sa.Column('changed_on', mysql.DATETIME(fsp=6), nullable=False),
sa.Column('id', sa.BINARY(length=16), nullable=True),
sa.Column('code', sa.VARCHAR(length=200), nullable=False),
sa.Column('rules', sa.VARCHAR(length=150), nullable=False),
sa.Column('custom', sa.VARCHAR(length=1000), nullable=True),
sa.Column('description', sa.VARCHAR(length=255), nullable=True),
sa.Column('from', mysql.DATETIME(fsp=6), nullable=True),
sa.Column('to', mysql.DATETIME(fsp=6), nullable=True),
sa.Column('schedule', sa.VARCHAR(length=250), nullable=True),
sa.Column('mutable',
mysql.TINYINT(display_width=3, unsigned=True),
nullable=True),
sa.Column('is_active',
mysql.TINYINT(display_width=3, unsigned=True),
nullable=False),
sa.Column('type', mysql.TINYINT(unsigned=True), nullable=False),
sa.Column('created_by', sa.VARCHAR(length=32), nullable=False),
sa.Column('updated_by', sa.VARCHAR(length=32), nullable=False),
sa.Column('created_at', mysql.DATETIME(fsp=6), nullable=False),
sa.Column('updated_at', mysql.DATETIME(fsp=6), nullable=False),
sa.Column('agent_id', mysql.INTEGER(), nullable=True),
sa.PrimaryKeyConstraint('auto_id'))
op.create_index(op.f('ix_all_vouchers_log_change_id'),
'all_vouchers_log', ['change_id'],
unique=False)
op.create_index(op.f('ix_all_vouchers_log_changed_on'),
'all_vouchers_log', ['changed_on'],
unique=False)
op.create_index(op.f('ix_all_vouchers_log_code'),
'all_vouchers_log', ['code'],
unique=False)
op.create_index(op.f('ix_all_vouchers_log_id'),
'all_vouchers_log', ['id'],
unique=False)
op.add_column(u'all_vouchers',
sa.Column('is_active', sa.BOOLEAN(), nullable=False))
op.create_index(op.f('ix_all_vouchers_from'),
'all_vouchers', ['from'],
unique=False)
op.create_index(op.f('ix_all_vouchers_to'),
'all_vouchers', ['to'],
unique=False)
op.create_index('user_voucher_transaction_log_order_id',
'user_voucher_transaction_log', ['order_id'],
unique=False)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('invtypes', sa.Column('portionSize', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('basePrice', mysql.DECIMAL(precision=19, scale=4), nullable=True))
op.add_column('invtypes', sa.Column('mass', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column('invtypes', sa.Column('soundID', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('volume', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column('invtypes', sa.Column('published', mysql.TINYINT(display_width=4), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('iconID', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('raceID', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('capacity', mysql.DOUBLE(asdecimal=True), nullable=True))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column(
'session',
sa.Column(u'end_time', mysql.BIGINT(display_width=20), nullable=True))
op.add_column(
'session',
sa.Column(u'start_time', mysql.BIGINT(display_width=20),
nullable=True))
op.drop_column('session', 'start')
op.drop_column('session', 'end')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('cart_products',
sa.Column('id', mysql.BIGINT(unsigned=True), nullable=False),
sa.Column('cart_id', sa.Integer(), nullable=False),
sa.Column('product_id', mysql.BIGINT(unsigned=True), nullable=False),
sa.Column('quantity', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['cart_id'], ['cart.id'], ),
sa.ForeignKeyConstraint(['product_id'], ['product.id'], ),
sa.PrimaryKeyConstraint('id')
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('games',
sa.Column('gameID',
mysql.BIGINT(display_width=20),
autoincrement=True,
nullable=False),
sa.Column('key',
mysql.VARCHAR(collation='utf8mb4_unicode_ci',
length=255),
nullable=True),
sa.Column('name',
mysql.VARCHAR(collation='utf8mb4_unicode_ci',
length=255),
nullable=True),
sa.Column('roleID',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('gameID'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_table('applications',
sa.Column('applicationID',
mysql.BIGINT(display_width=20),
autoincrement=True,
nullable=False),
sa.Column('name',
mysql.VARCHAR(collation='utf8mb4_unicode_ci',
length=255),
nullable=True),
sa.PrimaryKeyConstraint('applicationID'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_table('applications_games',
sa.Column('applicationID',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=False),
sa.Column('gameID',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=False),
sa.ForeignKeyConstraint(['applicationID'],
['applications.applicationID'],
name='applications_games_ibfk_1'),
sa.ForeignKeyConstraint(['gameID'], ['games.gameID'],
name='applications_games_ibfk_2'),
sa.PrimaryKeyConstraint('applicationID', 'gameID'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'messenger_user',
sa.Column('id', mysql.BIGINT(unsigned=True), nullable=False),
sa.Column('sender_id', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('sender_id'))
op.alter_column('product',
'category_id',
existing_type=mysql.BIGINT(display_width=20,
unsigned=True),
nullable=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('delivery_order',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('user_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('order_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('pickup_address', mysql.VARCHAR(length=255), nullable=False),
sa.Column('pickup_contact', mysql.VARCHAR(length=255), nullable=False),
sa.Column('pickup_contact_number', mysql.VARCHAR(length=255), nullable=False),
sa.Column('dropoff_address', mysql.VARCHAR(length=255), nullable=False),
sa.Column('dropoff_contact', mysql.VARCHAR(length=255), nullable=False),
sa.Column('dropoff_contact_number', mysql.VARCHAR(length=255), nullable=False),
sa.Column('item_value_cost', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('notes', mysql.TEXT(), nullable=False),
sa.Column('delivery_fee', mysql.DOUBLE(asdecimal=True), nullable=False),
sa.Column('invoice_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('mpesa_payment_id', mysql.VARCHAR(length=255), nullable=True),
sa.Column('date_created', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('order_status', mysql.VARCHAR(length=255), server_default=sa.text("'New'"), nullable=True),
sa.Column('rider_id', mysql.VARCHAR(length=255), nullable=True),
sa.Column('rider_pickup_date', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('rider_delivery_date', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('rider_notes', mysql.TEXT(), nullable=True),
sa.Column('user_feedback', mysql.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.create_table('user',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('user_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('firstname', mysql.VARCHAR(length=255), nullable=False),
sa.Column('lastname', mysql.VARCHAR(length=255), nullable=False),
sa.Column('email', mysql.VARCHAR(length=255), nullable=False),
sa.Column('phone_number', mysql.VARCHAR(length=255), nullable=False),
sa.Column('push_notificaiton_id', mysql.TEXT(), nullable=True),
sa.Column('date_created', mysql.VARCHAR(length=255), nullable=False),
sa.Column('phone_number_verified', mysql.INTEGER(display_width=11), server_default=sa.text('0'), autoincrement=False, nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.create_table('login',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('user_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('email_address', mysql.VARCHAR(length=255), nullable=False),
sa.Column('password', mysql.VARCHAR(length=255), nullable=False),
sa.Column('role', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('status', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('date_created', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('last_login', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.drop_table('users')
op.drop_table('blacklist_tokens')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('certificates', 'is_ev')
op.drop_column('certificates', 'is_cn_wildcard')
op.drop_column('certificates', 'is_alt_wildcard')
op.create_table('user_ip_scan_record',
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=False),
sa.Column('ip_scan_record_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('created_at', mysql.DATETIME(), nullable=True),
sa.Column('updated_at', mysql.DATETIME(), nullable=True),
sa.Column('deleted_at', mysql.DATETIME(), nullable=True),
sa.Column('disabled_at', mysql.DATETIME(), nullable=True),
sa.Column('scan_periodicity', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('auto_fill_watches', mysql.SMALLINT(display_width=6), server_default=sa.text(u"'0'"), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['ip_scan_record_id'], [u'ip_scan_record.id'], name=u'fk_ip_scan_record_ip_scan_record_id', ondelete=u'CASCADE'),
sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'fk_user_ip_scan_record_users_id', ondelete=u'CASCADE'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('user_subdomain_watch_target',
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=False),
sa.Column('watch_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('created_at', mysql.DATETIME(), nullable=True),
sa.Column('updated_at', mysql.DATETIME(), nullable=True),
sa.Column('deleted_at', mysql.DATETIME(), nullable=True),
sa.Column('disabled_at', mysql.DATETIME(), nullable=True),
sa.Column('auto_scan_added_at', mysql.DATETIME(), nullable=True),
sa.Column('scan_periodicity', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('scan_type', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('auto_fill_watches', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'wa_sub_users_id', ondelete=u'CASCADE'),
sa.ForeignKeyConstraint(['watch_id'], [u'subdomain_watch_target.id'], name=u'wa_sub_watch_target_id', ondelete=u'CASCADE'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('user_watch_target',
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=False),
sa.Column('watch_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('created_at', mysql.DATETIME(), nullable=True),
sa.Column('updated_at', mysql.DATETIME(), nullable=True),
sa.Column('deleted_at', mysql.DATETIME(), nullable=True),
sa.Column('scan_periodicity', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('scan_type', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('auto_scan_added_at', mysql.DATETIME(), nullable=True),
sa.Column('disabled_at', mysql.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], [u'users.id'], name=u'wa_users_id', ondelete=u'CASCADE'),
sa.ForeignKeyConstraint(['watch_id'], [u'watch_target.id'], name=u'wa_watch_target_id', ondelete=u'CASCADE'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('last_record_cache',
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('record_key', mysql.VARCHAR(length=191), nullable=False),
sa.Column('record_at', mysql.DATETIME(), nullable=True),
sa.Column('record_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('record_aux', mysql.TEXT(), nullable=True),
sa.Column('created_at', mysql.DATETIME(), nullable=True),
sa.Column('updated_at', mysql.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'product', sa.Column('id', mysql.BIGINT(unsigned=True),
nullable=False),
sa.Column('name', sa.String(length=30), nullable=False),
sa.Column('description', sa.String(length=255), nullable=False),
sa.Column('price', sa.Float(), nullable=False),
sa.Column('img_url', sa.String(length=255), nullable=False),
sa.Column('category_id', mysql.BIGINT(unsigned=True), nullable=True),
sa.ForeignKeyConstraint(
['category_id'],
['category.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
def downgrade():
op.create_table(
"gmailauthcredentials",
sa.Column(
"created_at",
mysql.DATETIME(),
server_default=sa.text("CURRENT_TIMESTAMP"),
nullable=False,
),
sa.Column("updated_at", mysql.DATETIME(), nullable=False),
sa.Column("deleted_at", mysql.DATETIME(), nullable=True),
sa.Column("id", mysql.BIGINT(display_width=20), nullable=False),
sa.Column(
"gmailaccount_id",
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=False,
),
sa.Column(
"refresh_token_id",
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=False,
),
sa.Column("scopes", mysql.VARCHAR(length=512), nullable=False),
sa.Column("g_id_token", mysql.VARCHAR(length=2048), nullable=False),
sa.Column("client_id", mysql.VARCHAR(length=256), nullable=False),
sa.Column("client_secret", mysql.VARCHAR(length=256), nullable=False),
sa.Column(
"is_valid",
mysql.TINYINT(display_width=1),
autoincrement=False,
nullable=False,
),
sa.ForeignKeyConstraint(
["gmailaccount_id"],
[u"gmailaccount.id"],
name=u"gmailauthcredentials_ibfk_1",
ondelete=u"CASCADE",
),
sa.ForeignKeyConstraint(
["refresh_token_id"],
[u"secret.id"],
name=u"gmailauthcredentials_ibfk_2",
ondelete=u"CASCADE",
),
sa.PrimaryKeyConstraint("id"),
mysql_default_charset=u"utf8mb4",
mysql_engine=u"InnoDB",
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user_resources', sa.Column('resource_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False))
op.drop_constraint('fk_user_resources_categories', 'user_resources', type_='foreignkey')
op.create_foreign_key('user_resources_ibfk_1', 'user_resources', 'resources', ['resource_id'], ['id'], onupdate='CASCADE')
op.drop_column('user_resources', 'category_id')
op.create_table('resources',
sa.Column('id', mysql.BIGINT(display_width=20), nullable=False),
sa.Column('name', mysql.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.drop_table('categories')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('notes',
sa.Column('id', mysql.BIGINT(unsigned=True), nullable=False),
sa.Column('user_id', mysql.BIGINT(unsigned=True), nullable=False),
sa.Column('title', sa.String(length=255), nullable=True),
sa.Column('body', sa.Text(), nullable=False),
sa.Column('created_at', mysql.TIMESTAMP(), server_default=sa.text('now()'), nullable=False),
sa.Column('updated_at', mysql.TIMESTAMP(), server_default=sa.text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_notes_created_at'), 'notes', ['created_at'], unique=False)
op.create_index(op.f('ix_notes_title'), 'notes', ['title'], unique=False)
op.create_index(op.f('ix_notes_updated_at'), 'notes', ['updated_at'], unique=False)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index('agent_id_permission_id', table_name='agent_permission')
op.drop_constraint(u'agent_permission_ibfk_2',
'agent_permission',
type_='foreignkey')
op.drop_constraint(u'agent_permission_ibfk_1',
'agent_permission',
type_='foreignkey')
op.alter_column('agent_permission',
'permission_id',
existing_type=mysql.BIGINT(display_width=20),
nullable=True)
op.alter_column('agent_permission',
'agent_id',
existing_type=mysql.INTEGER(display_width=11),
nullable=True)
op.create_index(op.f('ix_permissions_permission'),
'permissions', ['permission'],
unique=True)
op.create_foreign_key(u'agent_permission_ibfk_1', 'agent_permission',
'tokens', ['agent_id'], ['agent_id'])
op.create_foreign_key(u'agent_permission_ibfk_2', 'agent_permission',
'permissions', ['permission_id'], ['id'])
op.create_index('agent_id_permission_id',
'agent_permission', ['agent_id', 'permission_id'],
unique=False)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_column('waitlist_entries', 'inviteCount')
op.create_table('send_invite',
sa.Column('sendInviteID',
mysql.INTEGER(display_width=11),
nullable=False),
sa.Column('characterID',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('fleetID',
mysql.BIGINT(display_width=20),
autoincrement=False,
nullable=True),
sa.Column('inviteCount',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('sendAt', mysql.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(['characterID'],
[u'characters.id'],
name=u'send_invite_ibfk_1'),
sa.ForeignKeyConstraint(['fleetID'],
[u'crest_fleets.fleetID'],
name=u'send_invite_ibfk_2'),
sa.PrimaryKeyConstraint('sendInviteID'),
mysql_default_charset=u'utf8mb4',
mysql_engine=u'InnoDB')