diff options
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.sql | 10 |
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, |