* ditch dbo. in suspectreasoncode

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

diff --git a/schema/human_9606_schema/human_9606_table_postgresql.sql b/schema/human_9606_schema/human_9606_table_postgresql.sql
index 7dc165a636cf8df45da5d8d08347e3a0d7ce00e2..ab67e49241212a76f15006bbb77a7fd8328e01d2 100644 (file)
--- 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 ,