update to build 135 schema

[dbsnp.git] / schema / human_9606_schema / human_gty1_index_postgresql.sql

diff --git a/schema/human_9606_schema/human_gty1_index_postgresql.sql b/schema/human_9606_schema/human_gty1_index_postgresql.sql
deleted file mode 100644 (file)
index 0c98d90..0000000
--- a/schema/human_9606_schema/human_gty1_index_postgresql.sql
+++ /dev/null
@@ -1,49 +0,0 @@
- CREATE  INDEX ON SubInd_ch1(batch_id, subsnp_id)
-;
- CREATE  INDEX ON SubInd_ch1(submitted_ind_id, subsnp_id, gty_id)
-;
-CREATE INDEX ON SubInd_ch1(subsnp_id);
-CREATE INDEX ON SubInd_ch2(subsnp_id);
-CREATE INDEX ON SubInd_ch3(subsnp_id);
-CREATE INDEX ON SubInd_ch4(subsnp_id);
-CREATE INDEX ON SubInd_ch5(subsnp_id);
-CREATE INDEX ON SubInd_ch6(subsnp_id);
-CREATE INDEX ON SubInd_ch7(subsnp_id);
-CREATE INDEX ON SubInd_ch8(subsnp_id);
-CREATE INDEX ON SubInd_ch9(subsnp_id);
-
-
- CREATE  INDEX ON SubInd_ch2(batch_id, subsnp_id)
-;
- CREATE  INDEX ON SubInd_ch2(submitted_ind_id, subsnp_id, gty_id)
-;
-
-
- CREATE  INDEX ON SubInd_ch3(batch_id, subsnp_id)
-;
- CREATE  INDEX ON SubInd_ch3(submitted_ind_id, subsnp_id, gty_id)
-;
-
- CREATE  INDEX ON SubInd_ch4(batch_id, subsnp_id)
-;
- CREATE  INDEX ON SubInd_ch4(submitted_ind_id, subsnp_id, gty_id)
-;
-
- CREATE  INDEX ON SubInd_ch5(batch_id, subsnp_id)
-;
- CREATE  INDEX ON SubInd_ch5(submitted_ind_id, subsnp_id, gty_id)
-;
-
- CREATE  INDEX ON SubInd_ch6(batch_id, subsnp_id)
-;
- CREATE  INDEX ON SubInd_ch6(submitted_ind_id, subsnp_id, gty_id)
-;
-
- CREATE  INDEX ON SubInd_ch7(batch_id, subsnp_id)
-;
- CREATE  INDEX ON SubInd_ch7(submitted_ind_id, subsnp_id, gty_id)
-;
-
- CREATE    INDEX ON dn_table_rowcount(build_id DESC , reserved_KB_spaceused DESC )
-;
-