remove gty2 postgresql tables

[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..41f089be9ada121f8aec6bc308376cfafea13df8 100644 (file)
--- a/schema/human_9606_schema/human_9606_table_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_table_postgresql.sql
@@ -359,9 +359,7 @@ CREATE TABLE dbo.SuspectReasonCode(
                 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 ,