aboutsummaryrefslogtreecommitdiffstats
path: root/intentanalysis/src/test/resources/intentdb-test-init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'intentanalysis/src/test/resources/intentdb-test-init.sql')
-rw-r--r--intentanalysis/src/test/resources/intentdb-test-init.sql23
1 files changed, 22 insertions, 1 deletions
diff --git a/intentanalysis/src/test/resources/intentdb-test-init.sql b/intentanalysis/src/test/resources/intentdb-test-init.sql
index 1741585..25dc9ba 100644
--- a/intentanalysis/src/test/resources/intentdb-test-init.sql
+++ b/intentanalysis/src/test/resources/intentdb-test-init.sql
@@ -67,7 +67,8 @@ create table if not exists fulfillment_info
fulfillment_info_id varchar(255) primary key,
fulfillment_info_status varchar(255),
not_fulfilled_state varchar(255),
- not_fulfilled_reason varchar(255)
+ not_fulfilled_reason varchar(255),
+ achieve_value varchar(255)
);
create table if not exists condition
@@ -97,3 +98,23 @@ create table if not exists intent_Event_Record(
operateType varchar (225),
parent_id varchar(255)
);
+
+create table if not exists intent_report(
+ intent_report_id varchar(255) primary key,
+ intent_reference varchar(255),
+ report_time varchar(255)
+ );
+
+create table if not exists intent_report_fulfillment_info(
+ parent_id varchar(255),
+ fulfillment_info_id varchar(255),
+ fulfillment_info_status varchar(255),
+ not_fulfilled_state varchar(255),
+ not_fulfilled_reason varchar(255),
+ achieve_value varchar(255)
+ );
+
+create table if not exists object_instance(
+ parent_id varchar(255),
+ object_instance varchar(255)
+ ); \ No newline at end of file