aboutsummaryrefslogtreecommitdiffstats
path: root/standalone
diff options
context:
space:
mode:
authorzhaoyehua <zhaoyh6@asiainfo.com>2021-10-25 14:56:56 +0800
committer’zhaoyh6‘ <zhaoyh6@asiainfo.com>2021-10-25 14:59:26 +0800
commit8a082cb9ef0b96a06760ee10233c629d12fab9cd (patch)
treef773bce211e22b47d64a2f6ac6bf98effb6ea89c /standalone
parentdcbfd5f2e9f4a16d90c4e49aeed2c5278dbf8f47 (diff)
fix:The query mode and operation mode are optimized
Issue-ID: USECASEUI-605 Signed-off-by: ’zhaoyh6‘ <zhaoyh6@asiainfo.com> Change-Id: Ib4c81d42897e420b68c65686ed3efe5d985b3d62 Signed-off-by: ’zhaoyh6‘ <zhaoyh6@asiainfo.com>
Diffstat (limited to 'standalone')
-rw-r--r--standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql11
1 files changed, 6 insertions, 5 deletions
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),