Add database code.

Issue-ID: USECASEUI-696
Change-Id: I1c8ce807ca1f2aaeebc8646d8a14df9f4b27a436
Signed-off-by: hekeguang <hekeguang@chinamobile.com>

1 files changed, 22 insertions, 4 deletions

diff --git a/intentanalysis/src/main/resources/intent-analysis-init.sql b/intentanalysis/src/main/resources/intent-analysis-init.sql
index 3e34576..727e0c6 100644
--- a/intentanalysis/src/main/resources/intent-analysis-init.sql
+++ b/intentanalysis/src/main/resources/intent-analysis-init.sql
@@ -19,15 +19,12 @@ create table if not exists expectation_object(
 create table if not exists expectation_target(
     target_id varchar(255) primary key,
     target_name varchar(255),
-    target_condition varchar(255),
     expectation_id varchar(255)
 );
 
 create table if not exists context(
     context_id varchar(255) primary key,
-    context_name varchar(255),
-    context_type varchar(255),
-    context_condition varchar(255)
+    context_name varchar(255)
 );
 
 create table if not exists context_mapping(
@@ -50,3 +47,24 @@ create table if not exists state(
     condition varchar(255),
     expectation_id varchar(255)
 );
+
+create table if not exists condition(
+    condition_id varchar(255) primary key,
+    condition_name varchar(255),
+    operator_type varchar(255),
+    condition_value varchar(255)
+);
+
+create table if not exists condition_mapping(
+    condition_id varchar(255) primary key,
+    parent_type varchar(255),
+    parent_id varchar(255)
+    );
+
+create table if not exists intent_management_function_reg_info{
+    imfr_info_id varchar(255) primary key,
+    imfr_info_description varchar(255),
+    support_model varchar(255),
+    handle_name varchar(255),
+    intent_function_type varchar(255)
+    };
\ No newline at end of file