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