X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fhuman_9606_schema%2Fhuman_9606_table_postgresql.sql;h=ab67e49241212a76f15006bbb77a7fd8328e01d2;hb=ce0a637afd7f53101cc1c53c6d853814cf477bac;hp=7dc165a636cf8df45da5d8d08347e3a0d7ce00e2;hpb=4e1aef4e26dfe4994f405c448538d9e1d034b242;p=dbsnp.git

diff --git a/schema/human_9606_schema/human_9606_table_postgresql.sql b/schema/human_9606_schema/human_9606_table_postgresql.sql
index 7dc165a..ab67e49 100644
--- a/schema/human_9606_schema/human_9606_table_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_table_postgresql.sql
@@ -353,7 +353,7 @@ snp_id int NOT NULL ,
 reason_code int NULL ,
 upd_time TIMESTAMP NULL
 );
-CREATE TABLE dbo.SuspectReasonCode(
+CREATE TABLE SuspectReasonCode(
                 code int NOT NULL,
                 abbrev varchar(64) NULL,
                 descrip varchar(255) NULL,
@@ -612,7 +612,7 @@ snp_type char(2) NOT NULL ,
 snp_id int NULL ,
 gi int NULL ,
 accession_how_cd int NOT NULL ,
-'offset' int NULL ,
+offset_ int NULL ,
 asn_to int NULL ,
 lf_ngbr int NULL ,
 rf_ngbr int NULL ,
@@ -653,7 +653,7 @@ snp_type char(2) NOT NULL ,
 snp_id int NULL ,
 gi int NULL ,
 accession_how_cd int NULL ,
-'offset' int NULL ,
+offset_ int NULL ,
 asn_to int NULL ,
 lf_ngbr int NULL ,
 rf_ngbr int NULL ,