Skip to main content
summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat (limited to 'openk-platform/openk-eisman-portlet/src/main/resources/flyway-migration/V01/_00/OPENK_EISMAN_V01_00_001__init.sql')
-rw-r--r--openk-platform/openk-eisman-portlet/src/main/resources/flyway-migration/V01/_00/OPENK_EISMAN_V01_00_001__init.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/openk-platform/openk-eisman-portlet/src/main/resources/flyway-migration/V01/_00/OPENK_EISMAN_V01_00_001__init.sql b/openk-platform/openk-eisman-portlet/src/main/resources/flyway-migration/V01/_00/OPENK_EISMAN_V01_00_001__init.sql
index 940a9a4d..19e652b1 100644
--- a/openk-platform/openk-eisman-portlet/src/main/resources/flyway-migration/V01/_00/OPENK_EISMAN_V01_00_001__init.sql
+++ b/openk-platform/openk-eisman-portlet/src/main/resources/flyway-migration/V01/_00/OPENK_EISMAN_V01_00_001__init.sql
@@ -69,7 +69,7 @@ ALTER TABLE ACTIVITY OWNER TO eisman;
CREATE TABLE EQUIPMENT_CONTAINER
(
ID INTEGER NOT NULL,
- MRID VARCHAR(16) NOT NULL,
+ MRID VARCHAR(16) NOT NULL UNIQUE ,
NAME VARCHAR(64),
HIGH_VOLTAGE_LIMIT_VALUE NUMERIC,
HIGH_VOLTAGE_LIMIT_UNIT_MULTIPLIER VARCHAR(12),
@@ -89,7 +89,7 @@ ALTER TABLE EQUIPMENT_CONTAINER OWNER TO eisman;
CREATE TABLE SUBGEOGRAPHICAL_REGION
(
ID INTEGER NOT NULL,
- MRID VARCHAR(16),
+ MRID VARCHAR(16) UNIQUE ,
NAME VARCHAR(64),
ACTIVITY_ID INTEGER,
-- GEOGRAPHICAL_REGION_ID INTEGER,
@@ -120,7 +120,7 @@ CREATE TABLE SYNCHRONOUS_MACHINE
(
ID INTEGER NOT NULL,
MRID VARCHAR(16) NOT NULL,
- NAME VARCHAR(64),
+ NAME VARCHAR(64) UNIQUE ,
NORMALLY_IN_SERVICE VARCHAR(5),
SYNCHRONOUS_MACHINE_KIND VARCHAR(32),
CURRENT_REDUCTION_SETTING_PER_CENT INTEGER,
@@ -177,7 +177,7 @@ ALTER TABLE GENERATING_UNIT OWNER TO cachedb;
CREATE TABLE MEASUREMENT_ANALOG
(
ID INTEGER NOT NULL,
- MRID VARCHAR(16),
+ MRID VARCHAR(16) UNIQUE ,
MEASUREMENT_TYPE VARCHAR(16),
MEASUREMENT_UNIT_MULTIPLIER VARCHAR(12),
MEASUREMENT_UNIT_SYMBOL VARCHAR(12),
@@ -208,7 +208,7 @@ ALTER TABLE MEASUREMENT_ANALOG_VALUE OWNER TO eisman;
CREATE TABLE PSR_EVENT
(
ID INTEGER NOT NULL,
- MRID VARCHAR(16),
+ MRID VARCHAR(16) UNIQUE ,
PSR_EVENT_KIND VARCHAR(16),
TIMESTAMP_CREATED VARCHAR(30),
SYNCHRONOUS_MACHINE_ID INTEGER,

Back to the top