diff options
| author | Dominic Guss | 2017-02-16 16:47:13 +0000 |
|---|---|---|
| committer | David Miller | 2017-02-17 17:12:55 +0000 |
| commit | a1abe91311c70688b0d8e1e4f31b4e176a150122 (patch) | |
| tree | 60fae718d23c02adf368147b91a4351b0e5b2635 /plugins/org.eclipse.osee.orcs.db/src/org | |
| parent | ab4ddfaabdcde8fa33c096854bd20ea0b3ad2a60 (diff) | |
| download | org.eclipse.osee-a1abe91311c70688b0d8e1e4f31b4e176a150122.tar.gz org.eclipse.osee-a1abe91311c70688b0d8e1e4f31b4e176a150122.tar.xz org.eclipse.osee-a1abe91311c70688b0d8e1e4f31b4e176a150122.zip | |
bug[ats_ATS320463]: Postgres Demo DB init fails; no synonym
Change-Id: I547b26743123a4289fdab38f3157c5171e853216
Signed-off-by: Dominic Guss <Dominic.Guss@boeing.com>
Diffstat (limited to 'plugins/org.eclipse.osee.orcs.db/src/org')
| -rw-r--r-- | plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/resource/migration/V0.25.0_2016_04_21_1243__Osee_Tuple_Schema.sql | 17 |
1 files changed, 2 insertions, 15 deletions
diff --git a/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/resource/migration/V0.25.0_2016_04_21_1243__Osee_Tuple_Schema.sql b/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/resource/migration/V0.25.0_2016_04_21_1243__Osee_Tuple_Schema.sql index b7699199c87..7f6d1d3316c 100644 --- a/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/resource/migration/V0.25.0_2016_04_21_1243__Osee_Tuple_Schema.sql +++ b/plugins/org.eclipse.osee.orcs.db/src/org/eclipse/osee/orcs/db/internal/resource/migration/V0.25.0_2016_04_21_1243__Osee_Tuple_Schema.sql @@ -9,9 +9,6 @@ CREATE TABLE OSEE_TUPLE2 ( CREATE INDEX OSEE_TUPLE2__G_IDX ON OSEE_TUPLE2 (GAMMA_ID); -${db.synonym2} -${db.grant2} - -- 3 Element Tuple CREATE TABLE OSEE_TUPLE3 ( TUPLE_TYPE ${db.bigint} NOT NULL, @@ -24,9 +21,6 @@ CREATE TABLE OSEE_TUPLE3 ( CREATE INDEX OSEE_TUPLE3__G_IDX ON OSEE_TUPLE3 (GAMMA_ID); -${db.synonym3} -${db.grant3} - -- 4 Element Tuple CREATE TABLE OSEE_TUPLE4 ( TUPLE_TYPE ${db.bigint} NOT NULL, @@ -40,19 +34,12 @@ CREATE TABLE OSEE_TUPLE4 ( CREATE INDEX OSEE_TUPLE4__G_IDX ON OSEE_TUPLE4 (GAMMA_ID); -${db.synonym3} -${db.grant3} - CREATE TABLE OSEE_KEY_VALUE ( - KEY ${db.bigint} NOT NULL, - VALUE varchar(4000) NOT NULL, - CONSTRAINT OSEE_KEY_VALUE PRIMARY KEY (KEY)) + KEY ${db.bigint} PRIMARY KEY NOT NULL, + VALUE varchar(4000) NOT NULL) ${db.tablespace} ${db.pctthreshold} ${db.overflow} ${db.organization_index_key_value}; CREATE INDEX OSEE_KEY_VALUE__V_IDX ON OSEE_KEY_VALUE (VALUE); - -${db.synonym_key_value} -${db.grant_key_value}
\ No newline at end of file |