1
0
forked from s26450/hurtownia
hurtownia/sql/indexes.sql
2018-12-02 11:13:40 +01:00

32 lines
1.6 KiB
SQL

DROP INDEX IF EXISTS expected_response_time_fk_ft1_index ON FT_Registration;
-- CREATE INDEX expected_response_time_fk_ft1_index ON FT_Registration(expected_response_time_fk);
DROP INDEX IF EXISTS submission_date_fk_ft1_index ON FT_Registration;
-- CREATE INDEX submission_date_fk_ft1_index ON FT_Registration(submission_date_fk);
DROP INDEX IF EXISTS submission_date_fk_ft1_index ON FT_Registration;
-- CREATE INDEX submission_date_fk_ft1_index ON FT_Registration(submission_date_fk);
DROP INDEX IF EXISTS response_time_fk_ft1_index ON FT_Registration;
-- CREATE INDEX response_time_fk_ft1_index ON FT_Registration(response_time_fk);
DROP INDEX IF EXISTS drug_fk_ft1_index ON FT_Registration;
-- CREATE INDEX drug_fk_ft1_index ON FT_Registration(drug_fk);
DROP INDEX IF EXISTS factory_API_fk_ft1_index ON FT_Registration;
-- CREATE INDEX factory_API_fk_ft1_index ON FT_Registration(factory_API_fk);
DROP INDEX IF EXISTS factory_bulk_fk_ft1_index ON FT_Registration;
-- CREATE INDEX factory_bulk_fk_ft1_index ON FT_Registration(factory_bulk_fk);
DROP INDEX IF EXISTS factory_package_fk_ft1_index ON FT_Registration;
-- CREATE INDEX factory_package_fk_ft1_index ON FT_Registration(factory_package_fk);
DROP INDEX IF EXISTS country_fk_ft1_index ON FT_Registration;
-- CREATE INDEX country_fk_ft1_index ON FT_Registration(country_fk);
DROP INDEX IF EXISTS claim_status_fk_ft1_index ON FT_Registration;
-- CREATE INDEX claim_status_fk_ft1_index ON FT_Registration(claim_status_fk);
DROP INDEX IF EXISTS indication_fk_ft1_index ON FT_Registration;
-- CREATE INDEX indication_fk_ft1_index ON FT_Registration(indication_fk);