add shared schema changes for b137

[dbsnp.git] / schema / shared_schema / dbSNP_main_table_postgresql.sql

diff --git a/schema/shared_schema/dbSNP_main_table_postgresql.sql b/schema/shared_schema/dbSNP_main_table_postgresql.sql
index 210b47058386e3a7ed9aa508389791d6d77a6e33..e9cf36b343206f8538d7c07c68d6323568d8e310 100644 (file)
--- a/schema/shared_schema/dbSNP_main_table_postgresql.sql
+++ b/schema/shared_schema/dbSNP_main_table_postgresql.sql
@@ -308,8 +308,9 @@ create_time TIMESTAMP NOT NULL ,
 top_level_class char(5) NOT NULL ,
 is_coding smallint NOT NULL ,
 is_exon bit NULL ,
-var_prop_loc_code int NULL ,
-var_prop_effect_code int NULL
+var_prop_effect_code int NULL ,
+var_prop_gene_loc_code int NULL ,
+SO_id varchar(32) NULL
 );
 CREATE TABLE SnpValidationCode
 (
@@ -330,7 +331,7 @@ create_time TIMESTAMP NOT NULL
 CREATE TABLE SubSNPDelComm
 (
 comment_id smallint NOT NULL ,
-comment varchar(255) NOT NULL ,
+comment varchar(400) NOT NULL ,
 create_time TIMESTAMP NULL
 );
 CREATE TABLE SubSNPSeqTypeCode