def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.execute("ALTER TABLE notification ADD status text")
op.execute("update notification set status='unread' where read=false")
op.execute("update notification set status='read' where read=true")
op.execute("ALTER TABLE notification drop column read")
op.drop_index('notification_read_idx')
def downgrade():
for index in indexes:
op.drop_index(index[0], index[1])
op.execute('alter table application_route drop constraint if exists uniq_app_route_appid_rule')
op.execute('alter table application_static_content drop constraint if exists uniq_app_static_content_appid_resource_key')
op.execute('alter table application_static_file drop constraint if exists uniq_app_static_file_appid_resource_key')
op.execute('alter table application_template drop constraint if exists uniq_app_template_appid_key')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index(
op.f('ix_installation_structures_release'),
table_name='installation_structures'
)
op.drop_column('installation_structures', 'release')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('userdays')
op.drop_index(op.f('ix_days_sys_name'), table_name='days')
op.drop_table('days')
op.drop_table('facts')
op.drop_table('users')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.alter_column('users', 'game_id',
existing_type=sa.INTEGER(),
nullable=False)
op.create_unique_constraint(u'games_api_key_key', 'games', ['api_key'])
op.drop_index(op.f('ix_games_api_key'), table_name='games')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_column('series', 'analytic_context_key')
op.drop_index('ix_homepath_census_block', table_name='homepath_listing')
op.drop_index(op.f('ix_craigslist_listing_subdomain'), table_name='craigslist_listing')
op.create_table('census_block_series',
sa.Column('state_fp', sa.VARCHAR(length=2), autoincrement=False, nullable=False),
sa.Column('county_fp', sa.VARCHAR(length=3), autoincrement=False, nullable=False),
sa.Column('tract_ce', sa.VARCHAR(length=6), autoincrement=False, nullable=False),
sa.Column('block_ce', sa.VARCHAR(length=1), autoincrement=False, nullable=False),
sa.Column('series_key', sa.VARCHAR(length=40), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['series_key'], [u'series.key'], name=u'fk_census_block_series_series_key_series'),
sa.ForeignKeyConstraint(['state_fp', 'county_fp', 'tract_ce', 'block_ce'], [u'census_block.state_fp', u'census_block.county_fp', u'census_block.tract_ce', u'census_block.block_ce'], name=u'fk_census_block_series'),
sa.PrimaryKeyConstraint('state_fp', 'county_fp', 'tract_ce', 'block_ce', 'series_key', name=u'pk_census_block_series')
)
op.create_table('series_segment',
sa.Column('series_key', sa.VARCHAR(length=40), autoincrement=False, nullable=False),
sa.Column('dimension_id', sa.VARCHAR(length=20), autoincrement=False, nullable=False),
sa.Column('segment_id', sa.VARCHAR(length=20), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['dimension_id', 'segment_id'], [u'segment.dimension_id', u'segment.id'], name=u'fk_series_segment'),
sa.ForeignKeyConstraint(['dimension_id'], [u'dimension.id'], name=u'fk_series_segment_dimension_id_dimension'),
sa.ForeignKeyConstraint(['series_key'], [u'series.key'], name=u'fk_series_segment_series_key_series'),
sa.PrimaryKeyConstraint('series_key', 'dimension_id', 'segment_id', name=u'pk_series_segment')
)
op.drop_index('ix_census_block_segment_census_block', table_name='census_block_segment')
op.drop_table('census_block_segment')
op.drop_index(op.f('ix_analytic_context_segment_analytic_context_key'), table_name='analytic_context_segment')
op.drop_index('ix_analytic_context_segment', table_name='analytic_context_segment')
op.drop_table('analytic_context_segment')
op.drop_table('analytic_context')
op.execute(segment.delete(segment.c.dimension_id == 'census_block'))
op.alter_column('segment', 'sort_value', type_=sa.Unicode(10))
def downgrade():
for index_name, table_name in [
('ix_tag_suggestion_parent_id', 'tag_suggestion'),
('ix_tag_suggestion_child_id', 'tag_suggestion'),
('ix_tag_name_tag_id', 'tag_name'),
('ix_tag_implication_parent_id', 'tag_implication'),
('ix_tag_implication_child_id', 'tag_implication'),
('ix_tag_category_id', 'tag'),
('ix_snapshot_resource_type', 'snapshot'),
('ix_snapshot_resource_id', 'snapshot'),
('ix_post_tag_tag_id', 'post_tag'),
('ix_post_tag_post_id', 'post_tag'),
('ix_post_score_user_id', 'post_score'),
('ix_post_score_post_id', 'post_score'),
('ix_post_relation_parent_id', 'post_relation'),
('ix_post_relation_child_id', 'post_relation'),
('ix_post_note_post_id', 'post_note'),
('ix_post_feature_user_id', 'post_feature'),
('ix_post_feature_post_id', 'post_feature'),
('ix_post_favorite_user_id', 'post_favorite'),
('ix_post_favorite_post_id', 'post_favorite'),
('ix_post_user_id', 'post'),
('ix_comment_score_user_id', 'comment_score'),
('ix_comment_user_id', 'comment'),
('ix_comment_post_id', 'comment')]:
op.drop_index(op.f(index_name), table_name=table_name)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('job_organism_to_delete')
op.drop_table('genbank_file')
op.drop_table('job')
op.drop_index(op.f('ix_database_display_name'), table_name='database')
op.drop_table('database')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('unsaved_form')
op.drop_table('action_log')
op.drop_table('patient_referral')
op.drop_table('sliding_scale_fee')
op.drop_table('roles_users')
op.drop_table('patient_screening_result')
op.drop_table('service_translation')
op.drop_table('income_source')
op.drop_table('app_user')
op.drop_table('phone_number')
op.drop_table('household_member')
op.drop_table('sliding_scale')
op.drop_table('service_location')
op.drop_table('service_referral_email')
op.drop_table('address')
op.drop_table('referral_permission')
op.drop_table('emergency_contact')
op.drop_table('employer')
op.drop_table('document_image')
op.drop_table('patient')
op.drop_index(op.f('ix_role_default'), table_name='role')
op.drop_table('role')
op.drop_table('service')
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_index(op.f('ix_binaries_regex_id'), 'binaries', ['regex_id'], unique=False)
op.create_index(op.f('ix_categories_parent_id'), 'categories', ['parent_id'], unique=False)
op.create_index(op.f('ix_episodes_tvshow_id'), 'episodes', ['tvshow_id'], unique=False)
op.create_index(op.f('ix_files_release_id'), 'files', ['release_id'], unique=False)
op.create_index(op.f('ix_groups_active'), 'groups', ['active'], unique=False)
op.create_index(op.f('ix_movies_name'), 'movies', ['name'], unique=False)
op.create_index(op.f('ix_parts_binary_id'), 'parts', ['binary_id'], unique=False)
op.create_index(op.f('ix_parts_group_name'), 'parts', ['group_name'], unique=False)
op.create_index(op.f('ix_parts_posted'), 'parts', ['posted'], unique=False)
op.create_index(op.f('ix_parts_total_segments'), 'parts', ['total_segments'], unique=False)
op.drop_index('ix_parts_subject', table_name='parts')
op.create_index(op.f('ix_releases_category_id'), 'releases', ['category_id'], unique=False)
op.create_index(op.f('ix_releases_episode_id'), 'releases', ['episode_id'], unique=False)
op.create_index(op.f('ix_releases_group_id'), 'releases', ['group_id'], unique=False)
op.create_index(op.f('ix_releases_movie_id'), 'releases', ['movie_id'], unique=False)
op.create_index(op.f('ix_releases_movie_metablack_id'), 'releases', ['movie_metablack_id'], unique=False)
op.create_index(op.f('ix_releases_nfo_id'), 'releases', ['nfo_id'], unique=False)
op.create_index(op.f('ix_releases_nfo_metablack_id'), 'releases', ['nfo_metablack_id'], unique=False)
op.create_index(op.f('ix_releases_nzb_id'), 'releases', ['nzb_id'], unique=False)
op.create_index(op.f('ix_releases_rar_metablack_id'), 'releases', ['rar_metablack_id'], unique=False)
op.create_index(op.f('ix_releases_regex_id'), 'releases', ['regex_id'], unique=False)
op.create_index(op.f('ix_releases_search_name'), 'releases', ['search_name'], unique=False)
op.create_index(op.f('ix_releases_tvshow_id'), 'releases', ['tvshow_id'], unique=False)
op.create_index(op.f('ix_releases_tvshow_metablack_id'), 'releases', ['tvshow_metablack_id'], unique=False)
op.create_index(op.f('ix_releases_unwanted'), 'releases', ['unwanted'], unique=False)
op.create_index(op.f('ix_segments_part_id'), 'segments', ['part_id'], unique=False)
op.create_index(op.f('ix_segments_segment'), 'segments', ['segment'], unique=False)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index('tweet_by_tweet_id', table_name='tweet')
op.create_index('tweet_by_tweet_id', 'tweet', ['tweet_id'], unique=False)
op.drop_index('tweetentity_by_tweet_id', table_name='tweet_entity')
op.drop_table('tweet_entity')
op.drop_table('tuser_tuser')
def remove_index(index):
bind = op.get_bind()
insp = sqlalchemy.engine.reflection.Inspector.from_engine(bind)
index_names = [idx["name"] for idx in insp.get_indexes(index.table.name)]
fk_names = [i["name"] for i in insp.get_foreign_keys(index.table.name)]
if index.name in index_names and index.name not in fk_names:
op.drop_index(index.name, index.table.name)
def downgrade():
op.drop_index(op.f('ix_team_domain'), table_name='team')
op.drop_column('team', 'domain')
op.drop_constraint('organization_members_id_fkey', 'organization', type_='foreignkey')
op.drop_column('organization', 'members_id')
op.drop_constraint('organization_owners_id_fkey', 'organization', type_='foreignkey')
op.create_foreign_key('fk_organization_owners_id', 'organization', 'team', ['owners_id'], ['id'])
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('tasks')
op.create_table('tasks',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('task_name', sa.Text(), nullable=True),
sa.Column('task_desc', sa.Text(), nullable=True),
sa.Column('start_date', sa.Date(), nullable=False),
sa.Column('end_date', sa.Date(), nullable=True),
sa.Column('creator_id', sa.Integer(), nullable=True),
sa.Column('case_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['case_id'], ['cases.id'], ),
sa.ForeignKeyConstraint(['creator_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id'),
sqlite_autoincrement=True
)
op.create_index(op.f('ix_tasks_end_date'), 'tasks', ['end_date'],
unique=False)
op.create_index(op.f('ix_tasks_start_date'), 'tasks', ['start_date'],
unique=False)
op.create_index(op.f('ix_tasks_task_name'), 'tasks', ['task_name'],
unique=False)
# 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_project_user_map_user_id'), table_name='project_user_map')
op.drop_index(op.f('ix_project_user_map_project_id'), table_name='project_user_map')
op.drop_table('project_user_map')
op.drop_index(op.f('ix_projects_start_date'), table_name='projects')
op.drop_index(op.f('ix_projects_project_name'), table_name='projects')
op.drop_index(op.f('ix_projects_end_date'), table_name='projects')
op.drop_table('projects')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_defect_kind'), table_name='defect')
op.drop_table('defect')
op.drop_table('story')
op.drop_index(op.f('ix_project_name'), table_name='project')
op.drop_table('project')
def index_cleanup(engine_names, table_name, uniq_name, columns, create,
unique, limited):
bind = op.get_bind()
engine = bind.engine
if engine.name not in engine_names:
return
if create:
if limited and engine.name == 'mysql':
# For some versions of mysql we can get an error
# "Specified key was too long; max key length is 1000 bytes".
# We should create an index by hand in this case with limited
# length of columns.
meta = sa.MetaData()
meta.bind = engine
table = sa.Table(table_name, meta, autoload=True)
columns_mysql = ",".join((c + "(100)" for c in columns))
sql = ("create index %s ON %s (%s)" % (uniq_name, table,
columns_mysql))
engine.execute(sql)
else:
op.create_index(uniq_name, table_name, columns, unique=unique)
else:
if unique:
op.drop_constraint(uniq_name, table_name, type='unique')
else:
op.drop_index(uniq_name, table_name=table_name)
def downgrade():
op.create_table('version')
op.create_index('ix_user_user_id', 'user', ['_user_id'], unique=False)
op.drop_index(op.f('ix_user__user_id'), table_name='user')
op.add_column(
'mailinglist',
sa.Column('acceptable_aliases_id', sa.INTEGER(), nullable=True))
def upgrade():
op.create_index('banner_time', 'banner', ['added', 'removed'], unique=False)
op.create_index(op.f('ix_tbt_book_buyer'), 'tbt_book', ['buyer'], unique=False)
op.create_index(op.f('ix_tbt_book_seller'), 'tbt_book', ['seller'], unique=False)
op.create_index('tbt_book_course_code_idx', 'tbt_book_course', ['code', 'bookid'], unique=False)
op.create_index('tbt_book_course_code_revidx', 'tbt_book_course', ['bookid', 'code'], unique=False)
op.drop_index('ix_tbt_book_course_code', table_name='tbt_book_course')
def downgrade():
op.create_index('ix_tbt_book_course_code', 'tbt_book_course', ['code'], unique=False)
op.drop_index('tbt_book_course_code_revidx', table_name='tbt_book_course')
op.drop_index('tbt_book_course_code_idx', table_name='tbt_book_course')
op.drop_index(op.f('ix_tbt_book_seller'), table_name='tbt_book')
op.drop_index(op.f('ix_tbt_book_buyer'), table_name='tbt_book')
op.drop_index('banner_time', table_name='banner')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('follows')
op.drop_table('best_friends')
op.drop_index('ix_monkeys_monkeyname', table_name='monkeys')
op.drop_index('ix_monkeys_email', table_name='monkeys')
op.drop_table('monkeys')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_selector_text'), table_name='selector')
op.drop_index(op.f('ix_selector_normalized'), table_name='selector')
op.drop_table('selector')
op.drop_table('source_user')
op.drop_table('alert')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('followers')
op.drop_table('post')
op.drop_index('ix_user_nickname', 'user')
op.drop_index('ix_user_email', 'user')
op.drop_table('user')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column(u'votes', sa.Column('date', postgresql.TIMESTAMP(), autoincrement=False, nullable=True))
op.drop_column(u'votes', 'time_stamp')
op.drop_index(op.f('ix_comments_user_id'), table_name='comments')
op.drop_index(op.f('ix_comments_site_id'), table_name='comments')
op.drop_table('comments')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column(
u"opportunity",
sa.Column(
"created_by", sa.INTEGER(), autoincrement=False, nullable=False, server_default=sa.schema.DefaultClause("1")
),
)
op.add_column(u"opportunity", sa.Column("document", sa.VARCHAR(length=255), autoincrement=False, nullable=True))
op.add_column(
u"opportunity",
sa.Column("documents_needed", postgresql.ARRAY(sa.INTEGER()), autoincrement=False, nullable=True),
)
op.add_column(
u"opportunity", sa.Column("document_href", sa.VARCHAR(length=255), autoincrement=False, nullable=True)
)
op.drop_constraint("opportunity_created_by_id_user_id_fkey", "opportunity", type_="foreignkey")
op.create_foreign_key(u"opportunity_created_by_user_id_fkey", "opportunity", "users", ["created_by"], ["id"])
op.alter_column(u"opportunity", "planned_open", existing_type=postgresql.TIMESTAMP(), nullable=True)
op.alter_column(u"opportunity", "planned_deadline", existing_type=postgresql.TIMESTAMP(), nullable=True)
op.drop_column(u"opportunity", "vendor_documents_needed")
op.drop_column(u"opportunity", "planned_advertise")
op.drop_column(u"opportunity", "created_by_id")
op.drop_index(op.f("ix_opportunity_document_id"), table_name="opportunity_document")
op.drop_table("opportunity_document")
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index('ix_users_email', table_name='users')
op.drop_column('users', 'email')
op.drop_table('user_groups')
op.drop_index('ix_groups_name', table_name='groups')
op.drop_table('groups')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('roles_users')
op.drop_index(op.f('ix_posts_author_id'), table_name='posts')
op.drop_table('posts')
op.drop_table('users')
op.drop_table('roles')
def downgrade(pyramid_env):
with context.begin_transaction():
op.drop_index("%s_%s_ix_social_auth_code_code" % (
config.get('db_schema'), config.get('db_user')),
"social_auth_code")
op.drop_constraint(
"%s_%s_social_auth_nonce_UNQC_server_url_timestamp_salt" % (
config.get('db_schema'), config.get('db_user')),
"social_auth_nonce")
op.drop_constraint(
"%s_%s_social_auth_code_UNQC_code_email" % (
config.get('db_schema'), config.get('db_user')),
"social_auth_code")
op.drop_constraint(
"%s_%s_social_auth_association_UNQC_server_url_handle" % (
config.get('db_schema'), config.get('db_user')),
"social_auth_association")
op.drop_constraint(
"%s_%s_social_auth_account_UNQC_provider_id_uid" % (
config.get('db_schema'), config.get('db_user')),
"social_auth_account")
op.drop_table('social_auth_nonce')
op.drop_table('social_auth_code')
op.drop_table('social_auth_association')
op.drop_table('social_auth_account')
op.execute("DELETE FROM abstract_agent_account"
" WHERE type = 'social_auth_account'")
def downgrade():
op.drop_table('recipe_reservation')
op.drop_table('job_activity')
op.drop_table('openstack_region')
op.drop_column('virt_resource', 'kernel_options')
op.drop_column('virt_resource', 'instance_id')
op.drop_column('tg_user', 'openstack_tenant_name')
op.drop_column('tg_user', 'openstack_password')
op.drop_column('tg_user', 'openstack_username')
op.drop_index('email_address', 'tg_user')
op.create_unique_constraint('email_address', 'tg_user', ['email_address'])
# We want to replace the unique constraint on lab_controller.user_id with
# an ordinary index. The constraint will be called 'uc_user_id' if it was
# created by following the original 0.17 upgrade notes, otherise it will be
# called 'user_id'.
unique_name = find_unique('lab_controller', ['user_id'])
op.execute("ALTER TABLE lab_controller "
"DROP KEY %s, ADD KEY user_id (user_id)" % unique_name)
op.execute("ALTER TABLE job "
"DROP ntasks,"
"MODIFY status ENUM('New', 'Processed', 'Queued', 'Scheduled',"
"'Waiting', 'Running', 'Completed', 'Cancelled', 'Aborted') NOT NULL")
op.execute("ALTER TABLE recipe_set "
"DROP ntasks,"
"MODIFY status ENUM('New', 'Processed', 'Queued', 'Scheduled',"
"'Waiting', 'Running', 'Completed', 'Cancelled', 'Aborted') NOT NULL")
op.execute("ALTER TABLE recipe "
"DROP ntasks,"
"MODIFY status ENUM('New', 'Processed', 'Queued', 'Scheduled',"
"'Waiting', 'Running', 'Completed', 'Cancelled', 'Aborted') NOT NULL")
op.alter_column('recipe_task', u'status',
existing_type=sa.Enum(u'New', u'Processed', u'Queued', u'Scheduled', u'Waiting', u'Running', u'Completed', u'Cancelled', u'Aborted'),
nullable=False)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('user')
op.drop_table('story')
op.drop_table('step')
op.drop_index(op.f('ix_role_default'), table_name='role')
op.drop_table('role')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('event')
op.drop_index(op.f('ix_game_date_start'), table_name='game')
op.drop_table('game')
op.drop_table('team')
op.drop_table('player')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('user', 'n_games')
op.drop_column('user', 'elo')
op.drop_index(op.f('ix_agent_type_name'), table_name='agent_type')
op.drop_table('agent_type')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_user_username'), table_name='user')
op.drop_index(op.f('ix_user_email'), table_name='user')
op.drop_table('user')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_post_timestamp'), table_name='post')
op.drop_table('post')
def downgrade():
op.drop_index(op.f("ix_venues_name"), table_name="venues")
op.drop_table("venues")
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f("ix_day_off_person_id"), table_name="day_off")
op.drop_table("day_off")
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_comment_user_id'), table_name='comment')
op.drop_index(op.f('ix_comment_news_id'), table_name='comment')
op.drop_table('comment')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_roles_default'), table_name='roles')
op.drop_column('roles', 'permissions')
op.drop_column('roles', 'default')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_companies_symbol'), table_name='companies')
op.drop_index(op.f('ix_companies_companyName'), table_name='companies')
op.drop_table('companies')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_users_ipn'), table_name='users')
op.drop_column('users', 'ipn')
op.alter_column('users', 'ipn_hash', type_=sa.String(length=32))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_doctors_department'), table_name='doctors')
op.drop_table('doctors')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_courses_teacher'), table_name='courses')
op.drop_index(op.f('ix_courses_code'), table_name='courses')
op.drop_table('courses')
def downgrade():
op.drop_index('ix_thread_subject', table_name='thread')
op.drop_index('ix_message_subject', table_name='message')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_unsubscribe_sf_response'), table_name='unsubscribe')
op.drop_column('unsubscribe', 'sf_response')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_person_slack_user_id'), table_name='person')
op.drop_table('person')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('order_detail')
op.drop_index(op.f('ix_product_productname'), table_name='product')
op.drop_table('product')
op.drop_index(op.f('ix_post_timestamp'), table_name='post')
op.drop_table('post')
op.drop_table('order')
op.drop_table('followers')
op.drop_index(op.f('ix_user_username'), table_name='user')
op.drop_index(op.f('ix_user_postalcode'), table_name='user')
op.drop_index(op.f('ix_user_email'), table_name='user')
op.drop_index(op.f('ix_user_customername'), table_name='user')
op.drop_index(op.f('ix_user_country'), table_name='user')
op.drop_index(op.f('ix_user_city'), table_name='user')
op.drop_index(op.f('ix_user_address'), table_name='user')
op.drop_table('user')
op.drop_index(op.f('ix_supplier_suppliername'), table_name='supplier')
op.drop_index(op.f('ix_supplier_postalcode'), table_name='supplier')
op.drop_index(op.f('ix_supplier_phone'), table_name='supplier')
op.drop_index(op.f('ix_supplier_country'), table_name='supplier')
op.drop_index(op.f('ix_supplier_contactname'), table_name='supplier')
op.drop_index(op.f('ix_supplier_city'), table_name='supplier')
op.drop_index(op.f('ix_supplier_address'), table_name='supplier')
op.drop_table('supplier')
op.drop_index(op.f('ix_shipper_shippername'), table_name='shipper')
op.drop_index(op.f('ix_shipper_phone'), table_name='shipper')
op.drop_table('shipper')
op.drop_index(op.f('ix_employee_lastname'), table_name='employee')
op.drop_index(op.f('ix_employee_firstname'), table_name='employee')
op.drop_index(op.f('ix_employee_employeeID'), table_name='employee')
op.drop_table('employee')
op.drop_index(op.f('ix_category_categoryname'), table_name='category')
op.drop_table('category')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index('my_user_index', table_name='users')
op.drop_table('users')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f("ix_response_target_item"), table_name="response")
op.drop_table("response")
op.drop_table("questiontag")
op.drop_index("fk_questionanswer_answer1_idx", table_name="questionanswer")
op.drop_table("questionanswer")
op.drop_index(op.f("ix_menuwelcome_language_code"),
table_name="menuwelcome")
op.drop_index(op.f("ix_menuwelcome_audio_id"), table_name="menuwelcome")
op.drop_table("menuwelcome")
op.drop_index(op.f("ix_ivrlog_item_id"), table_name="ivrlog")
op.drop_index("fk_ivrlog_member1_idx", table_name="ivrlog")
op.drop_table("ivrlog")
op.drop_index(op.f("ix_itemaudio_language_code"), table_name="itemaudio")
op.drop_index(op.f("ix_itemaudio_audio_id"), table_name="itemaudio")
op.drop_table("itemaudio")
op.drop_table("question")
op.drop_index(op.f("ix_menuitem_next_item"), table_name="menuitem")
op.drop_index("fk_menuitem_ivrmenu1_idx", table_name="menuitem")
op.drop_table("menuitem")
op.drop_index(op.f("ix_language_audio_id"), table_name="language")
op.drop_table("language")
op.drop_index(op.f("ix_answeraudio_audio_id"), table_name="answeraudio")
op.drop_table("answeraudio")
op.drop_table("member")
op.drop_table("ivrmenu")
op.drop_index(op.f("ix_groupuser_user_id"), table_name="groupuser")
op.drop_table("groupuser")
op.drop_index(op.f("ix_audio_group_id"), table_name="audio")
op.drop_table("audio")
op.drop_index(op.f("ix_answer_user_id"), table_name="answer")
op.drop_index(op.f("ix_answer_group_id"), table_name="answer")
op.drop_table("answer")
op.drop_index("fk_user_subcounty1_idx", table_name="user")
op.drop_table("user")
op.drop_index("fk_advgroup_subcounty1_idx", table_name="advgroup")
op.drop_table("advgroup")
op.drop_table("subcounty")
op.drop_table("county")
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_light_vals_color'), table_name='light_vals')
op.drop_table('light_vals')
op.drop_index(op.f('ix_light_config_name'), table_name='light_config')
op.drop_table('light_config')
def downgrade():
op.drop_index('ix_useremail_email_lower')
op.execute(
sa.DDL(
'CREATE INDEX ix_useremail_email_lower ON useremail (lower(email) text_pattern_ops);'
))
def downgrade():
op.drop_index("idx_status_type", table_name="actionlog")
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('user', 'last_message_read_time')
op.drop_index(op.f('ix_message_timestamp'), table_name='message')
op.drop_table('message')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'user', sa.Column('logfilesize', sa.String(length=30), nullable=True))
op.drop_index('ix_user_sshkeyhash', table_name='user')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_blacklist_userid'), table_name='blacklist')
op.drop_index(op.f('ix_blacklist_blacklist'), table_name='blacklist')
op.drop_table('blacklist')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('page_tag')
op.drop_table('page_file')
op.drop_table('menu_page')
op.drop_index(op.f('ix_page_page_visible'), table_name='page')
op.drop_index(op.f('ix_page_page_title'), table_name='page')
op.drop_index(op.f('ix_page_page_timestamp'), table_name='page')
op.drop_table('page')
op.drop_index(op.f('ix_user_user_login'), table_name='user')
op.drop_table('user')
op.drop_table('role_perm')
op.drop_table('menu_link')
op.drop_index(op.f('ix_tag_tag_name'), table_name='tag')
op.drop_table('tag')
op.drop_index(op.f('ix_role_role_name'), table_name='role')
op.drop_table('role')
op.drop_index(op.f('ix_perm_perm_name'), table_name='perm')
op.drop_table('perm')
op.drop_index(op.f('ix_menu_item_item_name'), table_name='menu_item')
op.drop_table('menu_item')
op.drop_table('file')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_users_username'), table_name='users')
op.drop_column('users', 'username')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_brew_name'), table_name='brew')
op.drop_table('brew')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('transfer_card', '_amount_offset')
op.drop_constraint('credit_transfer_transfer_card_fkey', 'credit_transfer', type_='foreignkey')
op.drop_index(op.f('ix_credit_transfer_sender_transfer_card_id'), table_name='credit_transfer')
op.drop_column('credit_transfer', 'sender_transfer_card_id')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_forum__role_default'), table_name='forum__role')
op.drop_table('forum__role')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_index('ix_request_permissions_lt_local_identifier', table_name='request_permissions_lt')
op.drop_index('ix_request_permissions_lt_accessible', table_name='request_permissions_lt')
op.drop_index('ix_permissions2ltuser_permission_to_lt_id', table_name='permissions2ltuser')
op.drop_index('ix_permissions2ltuser_lt_user_id', table_name='permissions2ltuser')
op.drop_index('ix_permissions2lt_local_identifier', table_name='permissions2lt')
op.drop_index('ix_permissions2lt_accessible', table_name='permissions2lt')
op.drop_index('ix_lt_users_login', table_name='lt_users')
op.drop_index('ix_learning_tools_name', table_name='learning_tools')
op.drop_index('ix_learning_tools_full_name', table_name='learning_tools')
op.drop_index('ix_laboratories_visibility', table_name='laboratories')
op.drop_index('ix_laboratories_publicly_available', table_name='laboratories')
op.drop_index('ix_laboratories_available', table_name='laboratories')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index(op.f('ix_users_username'), table_name='users')
op.drop_index(op.f('ix_users_l_name'), table_name='users')
op.drop_index(op.f('ix_users_f_name'), table_name='users')
op.drop_index(op.f('ix_users_email'), table_name='users')
op.drop_table('users')
op.drop_index(op.f('ix_clients_room'), table_name='clients')
op.drop_index(op.f('ix_clients_medication'), table_name='clients')
op.drop_index(op.f('ix_clients_l_name'), table_name='clients')
op.drop_index(op.f('ix_clients_f_name'), table_name='clients')
op.drop_table('clients')
