update to build 135 schema

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

diff --git a/schema/human_9606_schema/dbSNP_sup_table_postgresql.sql b/schema/human_9606_schema/dbSNP_sup_table_postgresql.sql
index 8ef049183e2a373cbda408df8248cb635a5d05e8..cce3306c86bcfc20a142d1d3a44e61aae3155820 100644 (file)
--- a/schema/human_9606_schema/dbSNP_sup_table_postgresql.sql
+++ b/schema/human_9606_schema/dbSNP_sup_table_postgresql.sql
@@ -1,106 +1,93 @@
-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_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_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 SubSNPCommLine_p1_human (
-       subsnp_id int NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPCommLine_p2_human (
-       subsnp_id int NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPCommLine_p3_human (
-       subsnp_id int NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPSeq3_p1_human (
-       subsnp_id int NOT NULL ,
-       type smallint NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPSeq3_p2_human (
-       subsnp_id int NOT NULL ,
-       type smallint NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPSeq3_p3_human (
-       subsnp_id int NOT NULL ,
-       type smallint NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPSeq5_p1_human (
-       subsnp_id int NOT NULL ,
-       type smallint NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPSeq5_p2_human (
-       subsnp_id int NOT NULL ,
-       type smallint NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT NULL 
-)
-;
-
-CREATE TABLE SubSNPSeq5_p3_human (
-       subsnp_id int NOT NULL ,
-       type smallint NOT NULL ,
-       line_num smallint NOT NULL ,
-       line varchar (255) NOT 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 
-)
-;
-
+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_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_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 SubSNPCommLine_p1_human
+(
+subsnp_id int NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPCommLine_p2_human
+(
+subsnp_id int NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPCommLine_p3_human
+(
+subsnp_id int NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPSeq3_p1_human
+(
+subsnp_id int NOT NULL ,
+type smallint NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPSeq3_p2_human
+(
+subsnp_id int NOT NULL ,
+type smallint NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPSeq3_p3_human
+(
+subsnp_id int NOT NULL ,
+type smallint NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPSeq5_p1_human
+(
+subsnp_id int NOT NULL ,
+type smallint NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPSeq5_p2_human
+(
+subsnp_id int NOT NULL ,
+type smallint NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT NULL
+);
+CREATE TABLE SubSNPSeq5_p3_human
+(
+subsnp_id int NOT NULL ,
+type smallint NOT NULL ,
+line_num smallint NOT NULL ,
+line varchar(255) NOT 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
+);