From 8a082cb9ef0b96a06760ee10233c629d12fab9cd Mon Sep 17 00:00:00 2001 From: zhaoyehua Date: Mon, 25 Oct 2021 14:56:56 +0800 Subject: fix:The query mode and operation mode are optimized MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Issue-ID: USECASEUI-605 Signed-off-by: ’zhaoyh6‘ Change-Id: Ib4c81d42897e420b68c65686ed3efe5d985b3d62 Signed-off-by: ’zhaoyh6‘ --- .../resources/dbscripts/postgres/uui_create_table.sql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'standalone/src') diff --git a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql index 1a29c372..e6a4c1ed 100644 --- a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql +++ b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql @@ -153,13 +153,14 @@ CREATE TABLE sort_master ( DROP TABLE IF EXISTS instance_performance; CREATE TABLE instance_performance ( - id integer not null, + id serial not null + constraint instance_performance_pk + primary key, job_id varchar(36), resource_instance_id varchar(36), bandwidth numeric, - date date, - max_bandwidth numeric, - CONSTRAINT instance_performance_pk PRIMARY KEY (id) + date timestamp, + max_bandwidth numeric ); -- ---------------------------- @@ -174,7 +175,7 @@ CREATE TABLE intent_instance instance_id varchar(16), job_id varchar(36), progress integer, - status char, + status char default 0, resource_instance_id varchar(36), name varchar(255), cloud_point_name varchar(255), -- cgit 1.2.3-korg