add shared schema changes for b137

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

diff --git a/schema/shared_schema/dbSNP_main_table.sql b/schema/shared_schema/dbSNP_main_table.sql
index ddfe6cf99acd8a9efca3af7ec6ec24a767fc9998..21f1a8cdd70b2a6f10f4f1ef1077037c1fa63bd7 100644 (file)
--- a/schema/shared_schema/dbSNP_main_table.sql
+++ b/schema/shared_schema/dbSNP_main_table.sql
@@ -372,8 +372,9 @@ CREATE TABLE [SnpFunctionCode]
 [top_level_class] [char](5) NOT NULL ,
 [is_coding] [tinyint] 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
 )\r
 GO
 
@@ -400,7 +401,7 @@ GO
 CREATE TABLE [SubSNPDelComm]
 (
 [comment_id] [smallint] NOT NULL ,
-[comment] [varchar](255) NOT NULL ,
+[comment] [varchar](400) NULL ,
 [create_time] [smalldatetime] NULL
 )\r
 GO