* 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 9a76dddc8e4d189fdd01ee0480042fad04099798..ab67e49241212a76f15006bbb77a7fd8328e01d2 100644 (file)
--- 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 ,