remove gty2 postgresql tables

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

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