From 06f62f698348399434df4301de6fcac73b5bb777 Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Mon, 12 Dec 2011 14:27:27 -0800 Subject: [PATCH] remove gty2 postgresql tables --- .../human_9606_table_postgresql.sql | 4 +- .../human_gty2_constraint_postgresql.sql | 24 -- .../human_gty2_index_postgresql.sql | 49 ---- .../human_gty2_table_postgresql.sql | 276 ------------------ 4 files changed, 1 insertion(+), 352 deletions(-) delete mode 100644 schema/human_9606_schema/human_gty2_constraint_postgresql.sql delete mode 100644 schema/human_9606_schema/human_gty2_index_postgresql.sql delete mode 100644 schema/human_9606_schema/human_gty2_table_postgresql.sql diff --git a/schema/human_9606_schema/human_9606_table_postgresql.sql b/schema/human_9606_schema/human_9606_table_postgresql.sql index 9a76ddd..41f089b 100644 --- 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 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 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 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 -); -- 2.39.2