def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_users_email'), table_name='users')
op.drop_column('users', 'email')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('HouseKeeper', sa.Column('id',
sa.INTEGER(),
nullable=False),
sa.Column('moduleId', sa.INTEGER(), nullable=False),
sa.Column('courseId', sa.INTEGER(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'User', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('uname', sa.TEXT(), nullable=False),
sa.Column('pwd', sa.TEXT(), nullable=False),
sa.Column('email', sa.TEXT(), nullable=False),
sa.Column('phone', sa.TEXT(), nullable=True),
sa.Column('is_authenticated', sa.INTEGER(), nullable=False),
sa.Column('is_active', sa.INTEGER(), nullable=False),
sa.Column('is_anonymous', sa.INTEGER(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('tb1', sa.Column('name', sa.TEXT(), nullable=True),
sa.Column('age', sa.INTEGER(), nullable=True))
op.create_table('Module', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.TEXT(), nullable=False),
sa.Column('description', sa.TEXT(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
op.drop_index(op.f('ix_reasons_reason_id'), table_name='reasons')
op.drop_table('reasons')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'todo', type_='foreignkey')
op.drop_column('todo', 'author_id')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
op.drop_table('post')
op.drop_table('user')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
op.drop_index('ix_loguser2_sloupec3', table_name='loguser2')
op.drop_table('loguser2')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'blind', type_='unique')
op.drop_constraint(None, 'assistant', type_='unique')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'users', type_='unique')
op.drop_constraint(None, 'users', type_='unique')
op.drop_column('matchLog', 'winner')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_stat1',
sa.Column('tbl', sa.NullType(), nullable=True),
sa.Column('idx', sa.NullType(), nullable=True),
sa.Column('stat', sa.NullType(), nullable=True)
)
op.drop_table('users')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True)
)
op.drop_index('ix_tasks_TaskName', table_name='tasks')
op.drop_index('ix_tasks_Description', table_name='tasks')
op.drop_table('tasks')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('users',
'created_at',
existing_type=sa.TEXT(),
nullable=True)
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'prefix', type_='unique')
op.drop_index(op.f('ix_prefix_id'), table_name='prefix')
op.drop_column('prefix', 'version')
op.drop_index(op.f('ix_autonomous_system_asn'), table_name='autonomous_system')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True)
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('gameweek_performance',
'element_id',
existing_type=sa.INTEGER(),
nullable=False)
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
op.drop_table('fine')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
op.drop_index(op.f('ix_employees_username'), table_name='employees')
op.drop_index(op.f('ix_employees_last_name'), table_name='employees')
op.drop_index(op.f('ix_employees_first_name'), table_name='employees')
op.drop_index(op.f('ix_employees_email'), table_name='employees')
op.drop_table('employees')
op.drop_table('roles')
op.drop_table('departments')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('users', 'bio')
op.add_column('tweets', sa.Column('sentiment', sa.INTEGER(),
nullable=True))
op.add_column('tweets', sa.Column('labeller', sa.INTEGER(), nullable=True))
op.add_column(
'tweets',
sa.Column('reason_for_sentiment', sa.TEXT(length=64), nullable=True))
op.drop_index(op.f('ix_tweets_instance_id'), table_name='tweets')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('users_trial',
sa.Column('User_id_ID', sa.INTEGER(), nullable=False),
sa.Column('User_FIRST_NAME', sa.VARCHAR(), nullable=False),
sa.Column('User_LAST_NAME', sa.VARCHAR(), nullable=False),
sa.PrimaryKeyConstraint('User_id_ID'))
op.create_table('Users', sa.Column('ID', sa.INTEGER(), nullable=False),
sa.Column('username', sa.VARCHAR(), nullable=False),
sa.Column('password_hash', sa.VARCHAR(), nullable=True),
sa.PrimaryKeyConstraint('ID'))
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'posts', sa.Column('id', sa.INTEGER(), nullable=True),
sa.Column('created',
sa.TIMESTAMP(),
server_default=sa.text('(CURRENT_TIMESTAMP)'),
nullable=False), sa.Column('title',
sa.TEXT(),
nullable=False),
sa.Column('content', sa.TEXT(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_column('fields', 'job_status')
op.create_table('geom',
sa.Column('g', sa.NullType(), nullable=True),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('candidates',
sa.Column('candidate_id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('lang', mysql.TINYTEXT(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('user_name', mysql.TINYTEXT(), nullable=True),
sa.Column('user_registration',
sa.DateTime(),
nullable=True),
sa.Column('user_editcount', sa.Integer(), nullable=True),
sa.Column('user_experience_level',
mysql.TINYTEXT(),
nullable=True),
sa.Column('thanks_sent', sa.Integer(), nullable=True),
sa.Column('thanks_received', sa.Integer(), nullable=True),
sa.Column('has_email', sa.Boolean(), nullable=True),
sa.Column('user_thanked', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('candidate_id'),
mysql_charset='utf8',
mysql_collate='utf8_general_ci',
mysql_engine='InnoDB')
op.create_index(op.f('ix_candidates_created_at'),
'candidates', ['created_at'],
unique=False)
op.create_index(op.f('ix_candidates_user_id'),
'candidates', ['user_id'],
unique=False)
op.create_table('edits',
sa.Column('edit_id', sa.Integer(), nullable=False),
sa.Column('candidate_id', sa.Integer(), nullable=True),
sa.Column('lang', mysql.TINYTEXT(), nullable=True),
sa.Column('rev_id', sa.Integer(), nullable=True),
sa.Column('page_name', sa.TEXT(), nullable=True),
sa.Column('page_id', sa.Integer(), nullable=True),
sa.Column('ores_damaging', sa.Boolean(), nullable=True),
sa.Column('ores_goodfaith', sa.Boolean(), nullable=True),
sa.Column('de_flagged', sa.Boolean(), nullable=True),
sa.Column('de_flagged_algo_version',
sa.Boolean(),
nullable=True),
sa.Column('edit_deleted', sa.NullType(), nullable=True),
sa.Column('diffHTML', mysql.MEDIUMTEXT(), nullable=True),
sa.Column('newRevId', sa.Integer(), nullable=True),
sa.Column('newRevDate', mysql.TINYTEXT(), nullable=True),
sa.Column('newRevUser', mysql.TINYTEXT(), nullable=True),
sa.Column('newRevComment', sa.TEXT(), nullable=True),
sa.Column('oldRevId', sa.Integer(), nullable=True),
sa.Column('oldRevDate', mysql.TINYTEXT(), nullable=True),
sa.Column('oldRevUser', mysql.TINYTEXT(), nullable=True),
sa.Column('oldRevComment', sa.TEXT(), nullable=True),
sa.ForeignKeyConstraint(
['candidate_id'],
['candidates.candidate_id'],
),
sa.PrimaryKeyConstraint('edit_id'),
mysql_charset='utf8',
mysql_collate='utf8_general_ci',
mysql_engine='InnoDB')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'organizations', type_='unique')
op.drop_constraint(None, 'organizations', type_='unique')
op.drop_column('organizations', 'longitude')
op.drop_column('organizations', 'latitude')
op.alter_column('neighborhoods',
'SHAPE',
existing_type=sa.NullType(),
nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('dados', 'check')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
op.create_table(
'celery_tasksetmeta', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('taskset_id', sa.VARCHAR(length=155), nullable=True),
sa.Column('result', sa.BLOB(), nullable=True),
sa.Column('date_done', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('taskset_id'))
op.create_table(
'celery_taskmeta', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('task_id', sa.VARCHAR(length=155), nullable=True),
sa.Column('status', sa.VARCHAR(length=50), nullable=True),
sa.Column('result', sa.BLOB(), nullable=True),
sa.Column('date_done', sa.DATETIME(), nullable=True),
sa.Column('traceback', sa.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('task_id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('degree', sa.TEXT(), nullable=True))
op.add_column('user', sa.Column('department', sa.TEXT(), nullable=True))
op.drop_index(op.f('ix_user_zip'), table_name='user')
op.drop_index(op.f('ix_user_state'), table_name='user')
op.drop_index(op.f('ix_user_lname'), table_name='user')
op.drop_index(op.f('ix_user_fname'), table_name='user')
op.drop_index(op.f('ix_user_city'), table_name='user')
op.drop_index(op.f('ix_user_address2'), table_name='user')
op.drop_index(op.f('ix_user_address1'), table_name='user')
op.drop_index(op.f('ix_enroll_list_sid'), table_name='enroll_list')
op.drop_index(op.f('ix_enroll_list_cid'), table_name='enroll_list')
op.alter_column('enroll_list', 'sid',
existing_type=sa.INTEGER(),
nullable=False)
op.alter_column('enroll_list', 'cid',
existing_type=sa.INTEGER(),
nullable=False)
op.add_column('course', sa.Column('student', sa.INTEGER(), nullable=True))
op.drop_constraint(None, 'course', type_='foreignkey')
op.drop_index(op.f('ix_course_time2'), table_name='course')
op.drop_index(op.f('ix_course_time1'), table_name='course')
op.drop_index(op.f('ix_course_name'), table_name='course')
op.drop_index(op.f('ix_course_department'), table_name='course')
op.alter_column('course', 'time2',
existing_type=sa.INTEGER(),
nullable=False)
op.alter_column('course', 'time1',
existing_type=sa.INTEGER(),
nullable=False)
op.alter_column('course', 'name',
existing_type=sa.TEXT(),
nullable=False)
op.alter_column('course', 'department',
existing_type=sa.TEXT(),
nullable=False)
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True)
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True))
op.create_table('User', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('username', sa.TEXT(), nullable=True),
sa.Column('password', sa.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('Student_Result',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('student_id', sa.INTEGER(), nullable=True),
sa.Column('quiz_id', sa.INTEGER(), nullable=True),
sa.Column('marks', sa.INTEGER(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('Quizzes', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('subject', sa.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('Student', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('first_name', sa.TEXT(), nullable=True),
sa.Column('last_name', sa.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('timezones_world',
sa.Column('gid', sa.INTEGER(), autoincrement=True, nullable=False),
sa.Column('tzid', sa.VARCHAR(length=30), autoincrement=False, nullable=True),
sa.Column('geom', sa.NullType(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('gid', name=u'timezones_world_mp_pkey')
)
op.create_index('timezones_world_mp_geom_idx', 'timezones_world', ['geom'], unique=False)
op.create_table('dateline',
sa.Column('gid', sa.INTEGER(), autoincrement=True, nullable=False),
sa.Column('scalerank', sa.VARCHAR(length=254), autoincrement=False, nullable=True),
sa.Column('name', sa.VARCHAR(length=254), autoincrement=False, nullable=True),
sa.Column('name_long', sa.VARCHAR(length=254), autoincrement=False, nullable=True),
sa.Column('abbrev', sa.VARCHAR(length=254), autoincrement=False, nullable=True),
sa.Column('note', sa.VARCHAR(length=254), autoincrement=False, nullable=True),
sa.Column('featurecla', sa.VARCHAR(length=254), autoincrement=False, nullable=True),
sa.Column('geom', sa.NullType(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('gid', name=u'dateline_pkey')
)
op.create_index('dateline_geom_idx', 'dateline', ['geom'], unique=False)
op.create_table('timezones_utc',
sa.Column('gid', sa.INTEGER(), autoincrement=True, nullable=False),
sa.Column('name', sa.VARCHAR(length=254), autoincrement=False, nullable=True),
sa.Column('geom', sa.NullType(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('gid', name=u'all_tz_pkey')
)
op.create_index('all_tz_geom_idx', 'timezones_utc', ['geom'], unique=False)
op.create_table('spatial_ref_sys',
sa.Column('srid', sa.INTEGER(), autoincrement=False, nullable=False),
sa.Column('auth_name', sa.VARCHAR(length=256), autoincrement=False, nullable=True),
sa.Column('auth_srid', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('srtext', sa.VARCHAR(length=2048), autoincrement=False, nullable=True),
sa.Column('proj4text', sa.VARCHAR(length=2048), autoincrement=False, nullable=True),
sa.CheckConstraint(u'(srid > 0) AND (srid <= 998999)', name=u'spatial_ref_sys_srid_check'),
sa.PrimaryKeyConstraint('srid', name=u'spatial_ref_sys_pkey')
)
op.drop_table('books')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('users', schema=None) as batch_op:
batch_op.create_index('uix_users_name', ['name'], unique=1)
batch_op.drop_index(batch_op.f('idx_users_name'))
batch_op.drop_column('password')
with op.batch_alter_table('user_groups', schema=None) as batch_op:
batch_op.create_index('uix_usergroups_name', ['name'], unique=1)
batch_op.drop_constraint(batch_op.f('uix_user_groups_name'), type_='unique')
with op.batch_alter_table('ssh_keys', schema=None) as batch_op:
batch_op.create_index('uix_keys_name', ['name'], unique=1)
batch_op.drop_constraint(batch_op.f('uix_ssh_keys_name'), type_='unique')
with op.batch_alter_table('settings', schema=None) as batch_op:
batch_op.drop_constraint(batch_op.f('uix_settings_name'), type_='unique')
batch_op.create_index('uix_settings_name', ['name'], unique=1)
with op.batch_alter_table('hosts', schema=None) as batch_op:
batch_op.drop_constraint(batch_op.f('uix_hosts_name'), type_='unique')
batch_op.create_index('uix_hosts_name', ['name'], unique=1)
with op.batch_alter_table('host_groups', schema=None) as batch_op:
batch_op.create_index('uix_hostgroups_name', ['name'], unique=1)
batch_op.drop_constraint(batch_op.f('uix_host_groups_name'), type_='unique')
op.create_table('sqlite_sequence',
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('seq', sa.NullType(), nullable=True)
)
op.create_table('migrations',
sa.Column('id', sa.VARCHAR(length=255), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.drop_table('revoked_tokens')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('',
sa.Column('column1', sa.NullType(), nullable=True),
sa.Column('column2', sa.NullType(), nullable=True),
sa.Column('column3', sa.NullType(), nullable=True),
sa.Column('column4', sa.NullType(), nullable=True),
sa.Column('column5', sa.NullType(), nullable=True),
sa.Column('column6', sa.NullType(), nullable=True)
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('freelist', sa.Column('pgno', sa.INTEGER(),
nullable=False),
sa.PrimaryKeyConstraint('pgno'))
op.create_table('map', sa.Column('pgno', sa.INTEGER(), nullable=False),
sa.Column('maxlen', sa.INTEGER(), nullable=True),
sa.Column('intkey', sa.NullType(), nullable=True),
sa.Column('root', sa.INTEGER(), nullable=True),
sa.PrimaryKeyConstraint('pgno'))
op.create_table('dbptr', sa.Column('pgno', sa.NullType(), nullable=False),
sa.Column('child', sa.NullType(), nullable=False),
sa.PrimaryKeyConstraint('pgno', 'child'))
op.create_table('schema', sa.Column('type', sa.NullType(), nullable=True),
sa.Column('name', sa.NullType(), nullable=True),
sa.Column('tbl_name', sa.NullType(), nullable=True),
sa.Column('rootpage', sa.NullType(), nullable=True),
sa.Column('sql', sa.NullType(), nullable=True))
op.create_index('schema_rootpage', 'schema', ['rootpage'], unique=False)
op.drop_table('lesson')
op.drop_table('user')
op.drop_table('course')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('workouts', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('date', sa.DateTime(), nullable=True),
sa.Column('notes', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('exercises', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('exname', sa.String(), nullable=True),
sa.Column('workout_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['workout_id'],
['workouts.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'entries', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('weight', sa.Float(), nullable=True),
sa.Column('reps', sa.Integer(), nullable=True),
sa.Column('sets', sa.NullType(), nullable=True),
sa.Column('exercise_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['exercise_id'],
['exercises.id'],
), sa.PrimaryKeyConstraint('id'))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'requests',
sa.Column(
'id',
sa.INTEGER(),
server_default=sa.text("nextval('requests_id_seq'::regclass)"),
nullable=False),
sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('status',
postgresql.ENUM('draft', 'posted', name='requests_status'),
autoincrement=False,
nullable=False),
sa.Column('posted',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=False),
sa.Column('character_id',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.Column('name',
sa.VARCHAR(length=50),
autoincrement=False,
nullable=False),
sa.Column('acronym',
sa.VARCHAR(length=15),
autoincrement=False,
nullable=False),
sa.Column('color',
sa.VARCHAR(length=6),
autoincrement=False,
nullable=False),
sa.Column('quirk_prefix',
sa.VARCHAR(length=2000),
autoincrement=False,
nullable=False),
sa.Column('quirk_suffix',
sa.VARCHAR(length=2000),
autoincrement=False,
nullable=False),
sa.Column('case', sa.NullType(), autoincrement=False, nullable=False),
sa.Column('replacements',
sa.TEXT(),
autoincrement=False,
nullable=False),
sa.Column('regexes', sa.TEXT(), autoincrement=False, nullable=False),
sa.Column('scenario', sa.TEXT(), autoincrement=False, nullable=False),
sa.Column('prompt', sa.TEXT(), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['character_id'], ['characters.id'],
name='requests_character_id_fkey'),
sa.ForeignKeyConstraint(['user_id'], ['users.id'],
name='requests_user_id_fkey'),
sa.PrimaryKeyConstraint('id', name='requests_pkey'),
postgresql_ignore_search_path=False)
op.create_table(
'request_tags',
sa.Column('request_id',
sa.INTEGER(),
autoincrement=False,
nullable=False),
sa.Column('tag_id', sa.INTEGER(), autoincrement=False, nullable=False),
sa.Column('alias',
sa.VARCHAR(length=50),
autoincrement=False,
nullable=True),
sa.ForeignKeyConstraint(['request_id'], ['requests.id'],
name='request_tags_request_id_fkey'),
sa.ForeignKeyConstraint(['tag_id'], ['tags.id'],
name='request_tags_tag_id_fkey'),
sa.PrimaryKeyConstraint('request_id',
'tag_id',
name='request_tags_pkey'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sqlite_stat1',
sa.Column('tbl', sa.NullType(), nullable=True),
sa.Column('idx', sa.NullType(), nullable=True),
sa.Column('stat', sa.NullType(), nullable=True)
)
op.create_table('hbu_algeria',
sa.Column('Respondent', sa.BIGINT(), nullable=True),
sa.Column('RLH', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF 960G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF 600G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF 300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF MOZZARELLA 300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF NOIRES OLIVES 300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF CAMEMBERT300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF GREEN OLIVES 300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF AIL/HERBES 300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR EMTL 300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF GRILLE 300G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF Nat 450G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF fromages 450G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF 3poivres 450G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF fromages 200G', sa.FLOAT(), nullable=True),
sa.Column('LVQR CHEF 3poivres 200G', sa.FLOAT(), nullable=True),
sa.Column('LVQR ORG 8TP 120G', sa.FLOAT(), nullable=True),
sa.Column('LVQR ORG 24P 360G', sa.FLOAT(), nullable=True),
sa.Column('LVQR ORG 16P 240G', sa.FLOAT(), nullable=True),
sa.Column('LVQR ORG 32P 480G', sa.FLOAT(), nullable=True),
sa.Column('LVQR EMTL 16P 240G', sa.FLOAT(), nullable=True),
sa.Column('LVQR EMTL 8P 120G', sa.FLOAT(), nullable=True),
sa.Column('LVQR EDAM 16P 240G', sa.FLOAT(), nullable=True),
sa.Column('LVQR EDAM 8P 120G', sa.FLOAT(), nullable=True),
sa.Column('LVQR SIMPLY 8P 110G', sa.FLOAT(), nullable=True),
sa.Column('LVQR SIMPLY 16P 220G', sa.FLOAT(), nullable=True),
sa.Column('LVQR SIMPLY 24P 330G', sa.FLOAT(), nullable=True),
sa.Column('LVQR SIMPLY 32P 440G', sa.FLOAT(), nullable=True),
sa.Column('LVQR koul youm 200G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY 8P 110G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY 16P 220G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY EDAM 16P 220G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY CHED 16P 220G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY 24P 330G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY 900G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY 320G', sa.FLOAT(), nullable=True),
sa.Column('CHEEZY 480G', sa.FLOAT(), nullable=True),
sa.Column('EL MOUTAMAYEZ 16P 240G', sa.FLOAT(), nullable=True),
sa.Column('EL MOUTAMAYEZ 24P 360G', sa.FLOAT(), nullable=True),
sa.Column('EL MOUTAMAYEZ 8P 120G', sa.FLOAT(), nullable=True),
sa.Column('LA NOUVELLE VACHE 16P 220G', sa.FLOAT(), nullable=True),
sa.Column('LA NOUVELLE VACHE 24P 330G', sa.FLOAT(), nullable=True),
sa.Column('LA NOUVELLE VACHE 8P 110G', sa.FLOAT(), nullable=True),
sa.Column('LE BERBERE ORG 8P 120G', sa.FLOAT(), nullable=True),
sa.Column('LE BERBERE ORG 16P 240G', sa.FLOAT(), nullable=True),
sa.Column('LE BERBERE ORG 24P 360G', sa.FLOAT(), nullable=True),
sa.Column('LE BERBERE MON FRMG Nat 150G', sa.FLOAT(), nullable=True),
sa.Column('LE BERBERE 300G', sa.FLOAT(), nullable=True),
sa.Column('LE BERBERE 600G', sa.FLOAT(), nullable=True),
sa.Column('LE BERBERE 1.8KG', sa.FLOAT(), nullable=True),
sa.Column('OKIDS 16P 240G', sa.FLOAT(), nullable=True),
sa.Column('OKIDS 600G', sa.FLOAT(), nullable=True),
sa.Column('PICON 8P 110G', sa.FLOAT(), nullable=True),
sa.Column('PICON 16P 200G', sa.FLOAT(), nullable=True),
sa.Column('PICON 24P 330G', sa.FLOAT(), nullable=True),
sa.Column('PICON 32P 440G', sa.FLOAT(), nullable=True),
sa.Column('TARTINO 320G', sa.FLOAT(), nullable=True),
sa.Column('TARTINO GOUDA 320G', sa.FLOAT(), nullable=True),
sa.Column('TARTINO FRMG Rouge 320G', sa.FLOAT(), nullable=True),
sa.Column('TARTINO JUNIOR 16P 220G', sa.FLOAT(), nullable=True),
sa.Column('TARTINO JUNIOR 24P 330G', sa.FLOAT(), nullable=True),
sa.Column('TARTINO EXC. CHED 16P 240G', sa.FLOAT(), nullable=True),
sa.Column('TARTINO EXC. CHED 24P 360G', sa.FLOAT(), nullable=True),
sa.Column('WALID 270G', sa.FLOAT(), nullable=True),
sa.Column('KIRI CREME 4P 64G', sa.FLOAT(), nullable=True),
sa.Column('KIRI CREME 6P 96G', sa.FLOAT(), nullable=True),
sa.Column('KIRI CREME 12P 192G', sa.FLOAT(), nullable=True),
sa.Column('KIRI DELICE 350G', sa.FLOAT(), nullable=True),
sa.Column('KIRI DELICE 190G', sa.FLOAT(), nullable=True),
sa.Column('KIRI TARTINE Nat 120G', sa.FLOAT(), nullable=True),
sa.Column('KIRI TARTINE AIL/HERBES 120G', sa.FLOAT(), nullable=True),
sa.Column('KIRI GREEK 6P 90GR', sa.FLOAT(), nullable=True),
sa.Column('KIRI GREEK BRQT 190G', sa.FLOAT(), nullable=True),
sa.Column('KIRI YAOUMI 6P 90G', sa.FLOAT(), nullable=True),
sa.Column('KIRI YAOUMI 4P 60G', sa.FLOAT(), nullable=True),
sa.Column('DIALNA 16P 220G', sa.FLOAT(), nullable=True),
sa.Column('TOP SOUMA16P 220G', sa.FLOAT(), nullable=True),
sa.Column('FONDELICE CHED 125G', sa.FLOAT(), nullable=True),
sa.Column('FONDELICE Alg. 125G', sa.FLOAT(), nullable=True),
sa.Column('FONDELICE GRILLE 125G', sa.FLOAT(), nullable=True),
sa.Column('FONDELICE EMTL 340G', sa.FLOAT(), nullable=True),
sa.Column('FONDELICE Nat 340G', sa.FLOAT(), nullable=True),
sa.Column('FONDELICE AIL/Herbes 340G', sa.FLOAT(), nullable=True),
sa.Column('-0.5', sa.FLOAT(), nullable=True),
sa.Column('-0.45', sa.FLOAT(), nullable=True),
sa.Column('-0.4', sa.FLOAT(), nullable=True),
sa.Column('-0.35', sa.FLOAT(), nullable=True),
sa.Column('-0.3', sa.FLOAT(), nullable=True),
sa.Column('-0.25', sa.FLOAT(), nullable=True),
sa.Column('-0.2', sa.FLOAT(), nullable=True),
sa.Column('-0.15', sa.FLOAT(), nullable=True),
sa.Column('-0.1', sa.FLOAT(), nullable=True),
sa.Column('-0.05', sa.FLOAT(), nullable=True),
sa.Column('0', sa.FLOAT(), nullable=True),
sa.Column('0.05', sa.FLOAT(), nullable=True),
sa.Column('0.1', sa.FLOAT(), nullable=True),
sa.Column('0.15', sa.FLOAT(), nullable=True),
sa.Column('0.2', sa.FLOAT(), nullable=True),
sa.Column('0.25', sa.FLOAT(), nullable=True),
sa.Column('0.3', sa.FLOAT(), nullable=True),
sa.Column('0.35', sa.FLOAT(), nullable=True),
sa.Column('0.4', sa.FLOAT(), nullable=True),
sa.Column('0.45', sa.FLOAT(), nullable=True),
sa.Column('0.5', sa.FLOAT(), nullable=True)
)
op.create_table('sqlite_stat4',
sa.Column('tbl', sa.NullType(), nullable=True),
sa.Column('idx', sa.NullType(), nullable=True),
sa.Column('neq', sa.NullType(), nullable=True),
sa.Column('nlt', sa.NullType(), nullable=True),
sa.Column('ndlt', sa.NullType(), nullable=True),
sa.Column('sample', sa.NullType(), nullable=True)
)
op.create_table('hbu_saudi',
sa.Column('RespondentID', sa.BIGINT(), nullable=True),
sa.Column('RespondentWeight', sa.BIGINT(), nullable=True),
sa.Column('ALMARAI TR.P 480GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI TR.P 120GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI TR.P 240GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI TR.P 360GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI SQ 108GX3 (2+1 FR)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI SQ.P 432GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI SQ 216GX3 (SP.PR)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAISQ 108G BOX', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI SQ.P 216GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI BLU 500GX2 GLASS L/C(SP', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI BLU 900GX2 GLASS(SP.PR)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI GOLD 500GX2 GLASS (SP.PR)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI GOLD 900GX2 GLASS (SP.PR)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI GLASS BLU 500GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI GLASS BLU 900GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI GLASS GOLD 500GR', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI SQ 432G (SP.PRICE)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI SQ 432GX2 (SP.PRICE)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI TR 120GX5 (1 Fr', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI TR 480GX2 (SP)', sa.FLOAT(), nullable=True),
sa.Column('ALMARAI BLU 500GX2 GLASS(SP.PR)', sa.FLOAT(), nullable=True),
sa.Column('LVQR TR.P 120GR', sa.FLOAT(), nullable=True),
sa.Column('LVQR TR.P 480GR', sa.FLOAT(), nullable=True),
sa.Column('LVQR TR.P 360GR', sa.FLOAT(), nullable=True),
sa.Column('LVQR TR.P 240GR', sa.FLOAT(), nullable=True),
sa.Column('LVQR TR 120GX5 (4+1 FR)', sa.FLOAT(), nullable=True),
sa.Column('LVQR TR 480GX2(SP.PRICE)', sa.FLOAT(), nullable=True),
sa.Column('LVQR TUB 200GR', sa.FLOAT(), nullable=True),
sa.Column('LVQR TUB 500GR', sa.FLOAT(), nullable=True),
sa.Column('JAW TUB480GR', sa.FLOAT(), nullable=True),
sa.Column('JAW TR.P 480GR', sa.FLOAT(), nullable=True),
sa.Column('JAW TR.P 120GR', sa.FLOAT(), nullable=True),
sa.Column('JAW TR.P 240GR', sa.FLOAT(), nullable=True),
sa.Column('JAW TR 120GX4 (S.P)', sa.FLOAT(), nullable=True),
sa.Column('JAW TR 120GX5 (8PO)(SP)', sa.FLOAT(), nullable=True),
sa.Column('PUCK SQ.P 108GR', sa.FLOAT(), nullable=True),
sa.Column('PUCK SQ.P 216GR', sa.FLOAT(), nullable=True),
sa.Column('PUCK SQ.P 432GR', sa.FLOAT(), nullable=True),
sa.Column('PUCK 500GX2 GLASS BLUE(SP.PRICE)', sa.FLOAT(), nullable=True),
sa.Column('PUCK 910GX2 JAR BLUE (SP.PRICE)', sa.FLOAT(), nullable=True),
sa.Column('PUCK GLASS BLU 240GR', sa.FLOAT(), nullable=True),
sa.Column('PUCK GLASS BLU 500GR', sa.FLOAT(), nullable=True),
sa.Column('PUCK GLASS BLU 910GR', sa.FLOAT(), nullable=True),
sa.Column('PUCK GLASS BLU 1100GR', sa.FLOAT(), nullable=True),
sa.Column('PUCK TR 120GX5 (4+1 FREE)', sa.FLOAT(), nullable=True),
sa.Column('PUCK 650GR JAR(30% EXTR A) (BLUE)', sa.FLOAT(), nullable=True),
sa.Column('SALIM TR.P 120GR', sa.FLOAT(), nullable=True),
sa.Column('PRESIDENT TR 120GX5 (4+1FR)', sa.FLOAT(), nullable=True),
sa.Column('NADEC TR.P 120GR', sa.FLOAT(), nullable=True),
sa.Column('NADEC 500GX2 GLASS BLUE (SP.PRICE)', sa.FLOAT(), nullable=True),
sa.Column('NADEC 500GX2 GLASS GOLD (SP PRICE)', sa.FLOAT(), nullable=True),
sa.Column('NADEC GLASS BLU 500GR', sa.FLOAT(), nullable=True),
sa.Column('NADEC TR 120GX5 (4+1 FREE)', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ 216GX3 (SP. PRICE)', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ 432GX2 (SP.P)', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ 108GX5 (SP.P)', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ.P 324GR', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ.P 432GR', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ.P 108GR', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ.P 216GR', sa.FLOAT(), nullable=True),
sa.Column('KIRI TUB 350GR', sa.FLOAT(), nullable=True),
sa.Column('KIRI TUB 500GR', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ 108GX5 (1 FREE)', sa.FLOAT(), nullable=True),
sa.Column('KIRI SQ 432GX3(24P)(SP.P)', sa.FLOAT(), nullable=True),
sa.Column('KRAFT GLASS480GX2 GOLD JAR(SP)', sa.FLOAT(), nullable=True),
sa.Column('KRAFT 870GX2GOLD JAR(SP)', sa.FLOAT(), nullable=True),
sa.Column('PHILADELPHIA TUB 200GR', sa.FLOAT(), nullable=True),
sa.Column('PHILADELPHIA TUB 300GR', sa.FLOAT(), nullable=True),
sa.Column('PHILADELPHIA TUB 300GR', sa.FLOAT(), nullable=True),
sa.Column('PHILADELPHIA TUB 500GR', sa.FLOAT(), nullable=True),
sa.Column('PHILADELPHIA TUB 1650GR', sa.FLOAT(), nullable=True),
sa.Column('PHILADELPHIA TUB 200GR', sa.FLOAT(), nullable=True),
sa.Column('JAW 8 PIECES 120 GR', sa.FLOAT(), nullable=True),
sa.Column('JAW 480X2 32X2', sa.FLOAT(), nullable=True),
sa.Column('KIRI SP Greek Style 6p', sa.FLOAT(), nullable=True),
sa.Column('KIRI SP Greek style 24p', sa.FLOAT(), nullable=True),
sa.Column('KIRI Jars 240g', sa.FLOAT(), nullable=True),
sa.Column('KIRI Jars 440g', sa.FLOAT(), nullable=True),
sa.Column('KIRI Jars 600g', sa.FLOAT(), nullable=True),
sa.Column('KIRI Tubs Greek style 200g', sa.FLOAT(), nullable=True),
sa.Column('KIRI Tubs Greek style 500g', sa.FLOAT(), nullable=True),
sa.Column('JAW Jar 240g', sa.FLOAT(), nullable=True),
sa.Column('JAW Jar 500g', sa.FLOAT(), nullable=True),
sa.Column('JAW Jar 900g', sa.FLOAT(), nullable=True),
sa.Column('LVQR TR.P Organic 8p', sa.FLOAT(), nullable=True),
sa.Column('-0.4', sa.FLOAT(), nullable=True),
sa.Column('-0.35', sa.FLOAT(), nullable=True),
sa.Column('-0.3', sa.FLOAT(), nullable=True),
sa.Column('-0.25', sa.FLOAT(), nullable=True),
sa.Column('-0.2', sa.FLOAT(), nullable=True),
sa.Column('-0.15', sa.FLOAT(), nullable=True),
sa.Column('-0.1', sa.FLOAT(), nullable=True),
sa.Column('-0.05', sa.FLOAT(), nullable=True),
sa.Column('0', sa.FLOAT(), nullable=True),
sa.Column('0.05', sa.FLOAT(), nullable=True),
sa.Column('0.1', sa.FLOAT(), nullable=True),
sa.Column('0.15', sa.FLOAT(), nullable=True),
sa.Column('0.2', sa.FLOAT(), nullable=True),
sa.Column('0.25', sa.FLOAT(), nullable=True),
sa.Column('0.3', sa.FLOAT(), nullable=True),
sa.Column('0.35', sa.FLOAT(), nullable=True),
sa.Column('0.4', sa.FLOAT(), nullable=True)
)
op.create_table('zero_price_level',
sa.Column('sku_name', sa.TEXT(), nullable=True),
sa.Column('zero_percent', sa.FLOAT(), nullable=True),
sa.Column('project_id', sa.BIGINT(), nullable=True)
)
op.drop_table('init_data')
