summaryrefslogtreecommitdiffstats
path: root/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql
diff options
context:
space:
mode:
author’zhaoyh6‘ <zhaoyh6@asiainfo.com>2022-03-10 17:22:54 +0800
committerzhao yehua <zhaoyh6@asiainfo.com>2022-03-11 06:02:40 +0000
commit608d55685d920851c25523c2418b249811dbf0b7 (patch)
tree476585dff19b4b9ac7d9b5a8c0ae970cab50e0e7 /standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql
parentaa8f3448bab8a457ca96a43c3f0b0d615bdd871b (diff)
feat:Create an entry for the unified intent instance, save the instance information to AAI, and add test code.
Issue-ID: REQ-1075 Signed-off-by: ’zhaoyh6‘ <zhaoyh6@asiainfo.com> Change-Id: Iae5d246441d06b8ba30cdde5b14ae2202d46b85a
Diffstat (limited to 'standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql')
-rw-r--r--standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql5
1 files changed, 3 insertions, 2 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 6a3cf87c..d7201f51 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
@@ -170,7 +170,7 @@ DROP TABLE IF EXISTS ccvpn_instance;
CREATE TABLE ccvpn_instance
(
id serial not null
- constraint intent_instance_pk
+ constraint ccvpn_instance_pk
primary key,
instance_id varchar(16),
job_id varchar(36),
@@ -182,7 +182,8 @@ CREATE TABLE ccvpn_instance
access_point_one_name varchar(255),
access_point_one_band_width integer,
line_num varchar(64),
- delete_state integer default 0
+ delete_state integer default 0,
+ protect_status integer default 0
);
-- ----------------------------