X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2FdbSNP_sup_table.sql;h=3e43612d8c2b1292f7bfab0033c80b2fb1a2b8ca;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=0e0915dc2b41d350ed219543ce92ee7975c215da;hpb=ea7460b34b8123c023d3f73296a9cb5f7703abbe;p=dbsnp.git

diff --git a/schema/human_9606_schema/dbSNP_sup_table.sql b/schema/human_9606_schema/dbSNP_sup_table.sql
index 0e0915d..3e43612 100644
--- a/schema/human_9606_schema/dbSNP_sup_table.sql
+++ b/schema/human_9606_schema/dbSNP_sup_table.sql
@@ -1,119 +1,119 @@
-CREATE TABLE [SubSNPAcc_p1_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[acc_type_ind] [char] (1) NOT NULL ,
-	[acc_part] [varchar] (16) NOT NULL ,
-	[acc_ver] [int] NULL 
-)
+CREATE TABLE [SubSNPAcc_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[acc_type_ind] [char](1) NOT NULL ,
+[acc_part] [varchar](16) NOT NULL ,
+[acc_ver] [int] NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPAcc_p2_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[acc_type_ind] [char] (1) NOT NULL ,
-	[acc_part] [varchar] (16) NOT NULL ,
-	[acc_ver] [int] NULL 
-)
+CREATE TABLE [SubSNPAcc_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[acc_type_ind] [char](1) NOT NULL ,
+[acc_part] [varchar](16) NOT NULL ,
+[acc_ver] [int] NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPAcc_p3_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[acc_type_ind] [char] (1) NOT NULL ,
-	[acc_part] [varchar] (16) NOT NULL ,
-	[acc_ver] [int] NULL 
-)
+CREATE TABLE [SubSNPAcc_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[acc_type_ind] [char](1) NOT NULL ,
+[acc_part] [varchar](16) NOT NULL ,
+[acc_ver] [int] NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPCommLine_p1_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPCommLine_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPCommLine_p2_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPCommLine_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPCommLine_p3_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPCommLine_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPSeq3_p1_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[type] [tinyint] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPSeq3_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPSeq3_p2_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[type] [tinyint] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPSeq3_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPSeq3_p3_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[type] [tinyint] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPSeq3_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPSeq5_p1_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[type] [tinyint] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPSeq5_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPSeq5_p2_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[type] [tinyint] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPSeq5_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)
 GO
 
-
-CREATE TABLE [SubSNPSeq5_p3_human] (
-	[subsnp_id] [int] NOT NULL ,
-	[type] [tinyint] NOT NULL ,
-	[line_num] [tinyint] NOT NULL ,
-	[line] [varchar] (255) NOT NULL 
-)
+CREATE TABLE [SubSNPSeq5_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT 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
 
-