X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;ds=sidebyside;f=schema%2Fshared_schema%2FdbSNP_main_table_postgresql.sql;h=e9cf36b343206f8538d7c07c68d6323568d8e310;hb=71dd006316add35b0740e9ecc8f81b67c0c3f736;hp=210b47058386e3a7ed9aa508389791d6d77a6e33;hpb=9612a14433017a940cb34f070609ea96870a4351;p=dbsnp.git

diff --git a/schema/shared_schema/dbSNP_main_table_postgresql.sql b/schema/shared_schema/dbSNP_main_table_postgresql.sql
index 210b470..e9cf36b 100644
--- 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