thingsboard-developers

Update schema-ts.sql

12/20/2018 11:54:44 AM

Andreas Schönebeck

Commit: e0a2725

Tree: 999bec4

Parents: 80af7eb

Changes

dao/src/main/resources/sql/schema-ts.sql 4(+2 -2)

Details

dao/src/main/resources/sql/schema-ts.sql 4(+2 -2)

diff --git a/dao/src/main/resources/sql/schema-ts.sql b/dao/src/main/resources/sql/schema-ts.sql
index 53bc15a..821e297 100644
--- a/dao/src/main/resources/sql/schema-ts.sql
+++ b/dao/src/main/resources/sql/schema-ts.sql
@@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS ts_kv (
     str_v varchar(10000000),
     long_v bigint,
     dbl_v double precision,
-    CONSTRAINT ts_kv_unq_key UNIQUE (entity_type, entity_id, key, ts)
+    CONSTRAINT ts_kv_pkey PRIMARY KEY (entity_type, entity_id, key, ts)
 );
 
 CREATE TABLE IF NOT EXISTS ts_kv_latest (
@@ -35,5 +35,5 @@ CREATE TABLE IF NOT EXISTS ts_kv_latest (
     str_v varchar(10000000),
     long_v bigint,
     dbl_v double precision,
-    CONSTRAINT ts_kv_latest_unq_key UNIQUE (entity_type, entity_id, key)
+    CONSTRAINT ts_kv_latest_pkey PRIMARY KEY (entity_type, entity_id, key)
 );