X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_gty1_table.sql;h=cd45ba248bd4b5d9ba576af00e311dc5a76d4057;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=4e8e9d566b72a593331f58e3ba30ab1eb56d6ac7;hpb=6e51d2d339036d36e6294b1bbed27e5c18a6a2f5;p=dbsnp.git

diff --git a/schema/human_9606_schema/human_gty1_table.sql b/schema/human_9606_schema/human_gty1_table.sql
index 4e8e9d5..cd45ba2 100644
--- a/schema/human_9606_schema/human_gty1_table.sql
+++ b/schema/human_9606_schema/human_gty1_table.sql
@@ -1,105 +1,105 @@
-CREATE TABLE [SubInd_ch1] (
-	[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_ch1]
+(
+[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
+)
 GO
 
-
-CREATE TABLE [SubInd_ch2] (
-	[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_ch2]
+(
+[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
+)
 GO
 
-
-CREATE TABLE [SubInd_ch3] (
-	[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_ch3]
+(
+[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
+)
 GO
 
-
-CREATE TABLE [SubInd_ch4] (
-	[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_ch4]
+(
+[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
+)
 GO
 
-
-CREATE TABLE [SubInd_ch5] (
-	[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_ch5]
+(
+[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
+)
 GO
 
-
-CREATE TABLE [SubInd_ch6] (
-	[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_ch6]
+(
+[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
+)
 GO
 
-
-CREATE TABLE [SubInd_ch7] (
-	[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_ch7]
+(
+[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
+)
 GO
 
-
-CREATE TABLE [dn_table_rowcount] (
-	[tabname] [varchar] (64) NOT NULL ,
-	[row_cnt] [int] NOT NULL ,
-	[build_id] [int] NOT NULL ,
-	[update_time] [datetime] 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 
-)
+CREATE TABLE [dn_table_rowcount]
+(
+[tabname] [varchar](64) NOT NULL ,
+[row_cnt] [int] NOT NULL ,
+[build_id] [int] NOT NULL ,
+[update_time] [datetime] 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
+)
 GO
 
-