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