remove gty2 postgresql tables

diff --git a/schema/human_9606_schema/human_9606_table_postgresql.sql b/schema/human_9606_schema/human_9606_table_postgresql.sql
index 9a76dddc8e4d189fdd01ee0480042fad04099798..41f089be9ada121f8aec6bc308376cfafea13df8 100644 (file)
--- a/schema/human_9606_schema/human_9606_table_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_table_postgresql.sql
@@ -359,9 +359,7 @@ CREATE TABLE dbo.SuspectReasonCode(
                 descrip varchar(255) NULL,
                 create_time TIMESTAMP NULL,
                 last_update_time TIMESTAMP NULL,
-PRIMARY KEY (
-                code)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON PRIMARY
-) ON PRIMARY
+PRIMARY KEY (code));
 CREATE TABLE SNPVal
 (
 batch_id int NOT NULL ,

diff --git a/schema/human_9606_schema/human_gty2_constraint_postgresql.sql b/schema/human_9606_schema/human_gty2_constraint_postgresql.sql
deleted file mode 100644 (file)
index 2b26122..0000000
--- a/schema/human_9606_schema/human_gty2_constraint_postgresql.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-ALTER TABLE SubInd_ch10 ADD CONSTRAINT pk_ch_t_SubInd_ch10  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch11 ADD CONSTRAINT pk_ch_t_SubInd_ch11  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch12 ADD CONSTRAINT pk_ch_t_SubInd_ch12  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch13 ADD CONSTRAINT pk_ch_t_SubInd_ch13  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch14 ADD CONSTRAINT pk_ch_t_SubInd_ch14  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch15 ADD CONSTRAINT pk_ch_t_SubInd_ch15  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch16 ADD CONSTRAINT pk_ch_t_SubInd_ch16  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch17 ADD CONSTRAINT pk_ch_t_SubInd_ch17  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch18 ADD CONSTRAINT pk_ch_t_SubInd_ch18  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch19 ADD CONSTRAINT pk_ch_t_SubInd_ch19  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch20 ADD CONSTRAINT pk_ch_t_SubInd_ch20  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch21 ADD CONSTRAINT pk_ch_t_SubInd_ch21  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch22 ADD CONSTRAINT pk_ch_t_SubInd_ch22  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch8 ADD CONSTRAINT pk_ch_t_SubInd_ch8  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_ch9 ADD CONSTRAINT pk_ch_t_SubInd_ch9  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chAltOnly ADD CONSTRAINT pk_SubInd_chAltOnly  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chMT ADD CONSTRAINT pk_ch_t_SubInd_chMT  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chMulti ADD CONSTRAINT pk_SubInd_chMulti  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chNewSs ADD CONSTRAINT pk_SubInd_chNewSs  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chNotOn ADD CONSTRAINT pk_SubInd_chNotOn  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chPAR ADD CONSTRAINT pk_SubInd_chPAR  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chUn ADD CONSTRAINT pk_SubInd_chUn  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chX ADD CONSTRAINT pk_ch_t_SubInd_chX  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);
-ALTER TABLE SubInd_chY ADD CONSTRAINT pk_ch_t_SubInd_chY  PRIMARY KEY  (chr,batch_id,subsnp_id,submitted_ind_id);

diff --git a/schema/human_9606_schema/human_gty2_index_postgresql.sql b/schema/human_9606_schema/human_gty2_index_postgresql.sql
deleted file mode 100644 (file)
index bd28e29..0000000
--- a/schema/human_9606_schema/human_gty2_index_postgresql.sql
+++ /dev/null
@@ -1,49 +0,0 @@
-CREATE INDEX ON SubInd_ch10 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch10 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch11 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch11 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch12 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch12 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch13 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch13 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch14 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch14 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch15 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch15 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch16 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch16 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch17 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch17 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch18 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch18 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch19 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch19 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch20 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch20 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch21 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch21 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch22 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch22 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch8 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch8 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_ch9 (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_ch9 (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chAltOnly (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chAltOnly (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chMT (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chMT (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chMulti (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chMulti (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chNewSs (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chNewSs (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chNotOn (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chNotOn (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chPAR (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chPAR (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chUn (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chUn (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chX (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chX (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON SubInd_chY (batch_id,subsnp_id);
-CREATE INDEX ON SubInd_chY (submitted_ind_id,subsnp_id,gty_id);
-CREATE INDEX ON dn_table_rowcount (build_id DESC,reserved_KB_spaceused DESC);

diff --git a/schema/human_9606_schema/human_gty2_table_postgresql.sql b/schema/human_9606_schema/human_gty2_table_postgresql.sql
deleted file mode 100644 (file)
index c4714cd..0000000
--- a/schema/human_9606_schema/human_gty2_table_postgresql.sql
+++ /dev/null
@@ -1,276 +0,0 @@
-CREATE TABLE SubInd_ch10
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch11
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch12
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch13
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch14
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch15
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch16
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch17
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch18
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch19
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch20
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch21
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch22
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch8
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_ch9
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chAltOnly
-(
-chr varchar(8) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chMT
-(
-chr varchar(8) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chMulti
-(
-chr varchar(8) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chNewSs
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag smallint NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chNotOn
-(
-chr varchar(8) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chPAR
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chUn
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chX
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE SubInd_chY
-(
-chr varchar(3) NOT NULL ,
-batch_id int NOT NULL ,
-subsnp_id int NOT NULL ,
-submitted_ind_id int NOT NULL ,
-submitted_strand_code int NULL ,
-allele_flag int NULL ,
-gty_id int NULL ,
-submitted_rs int NULL
-);
-CREATE TABLE dn_table_rowcount
-(
-tabname varchar(64) NOT NULL ,
-row_cnt int NOT NULL ,
-build_id int NOT NULL ,
-update_time TIMESTAMP NOT NULL ,
-rows_in_spaceused int NULL ,
-reserved_KB_spaceused int NULL ,
-data_KB_spaceused int NULL ,
-index_size_KB_spaceused int NULL ,
-unused_KB_spaceused int NULL
-);