diff options
| author |   zhaoyehua <zhaoyh6@asiainfo.com> | 2021-10-25 14:56:56 +0800 |
|---|---|---|
| committer | ’zhaoyh6‘ <zhaoyh6@asiainfo.com> | 2021-10-25 14:59:26 +0800 |
| commit | 8a082cb9ef0b96a06760ee10233c629d12fab9cd (patch) | |
| tree | f773bce211e22b47d64a2f6ac6bf98effb6ea89c /standalone/src/main/assembly | |
| parent | dcbfd5f2e9f4a16d90c4e49aeed2c5278dbf8f47 (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/src/main/assembly')
| -rw-r--r-- | standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql | 11 |
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), |