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=9a76dddc8e4d189fdd01ee0480042fad04099798;hpb=77ec8a32a887e1eb6364f327f55049cae8e69f95;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 9a76ddd..ab67e49 100644
--- a/schema/human_9606_schema/human_9606_table_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_table_postgresql.sql
@@ -353,15 +353,13 @@ 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,
                 create_time TIMESTAMP NULL,
                 last_update_time TIMESTAMP NULL,
-PRIMARY KEY (
-                code)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON PRIMARY
-) ON PRIMARY
+PRIMARY KEY (code));
 CREATE TABLE SNPVal
 (
 batch_id int NOT NULL ,
@@ -614,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 ,
@@ -655,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 ,