1 files changed, 42 insertions, 0 deletions
diff --git a/intentanalysis/src/test/resources/intentdb-test-init.sql b/intentanalysis/src/test/resources/intentdb-test-init.sql
new file mode 100644
index 0000000..b84f8e3
--- /dev/null
+++ b/intentanalysis/src/test/resources/intentdb-test-init.sql
@@ -0,0 +1,42 @@
+/*
+ Navicat Premium Data Transfer
+
+ Source Server         : 1
+ Source Server Type    : PostgreSQL
+ Source Server Version : 100011
+ Source Host           : localhost:5432
+ Source Catalog        : exampledb
+ Source Schema         : mec
+
+ Target Server Type    : PostgreSQL
+ Target Server Version : 100011
+ File Encoding         : 65001
+
+ Date: 30/12/2019 14:40:23
+*/
+DROP TABLE IF  EXISTS intent;
+DROP TABLE IF  EXISTS  expectation;
+DROP TABLE  IF  EXISTS state;
+
+CREATE TABLE if NOT EXISTS intent(
+    intent_id varchar(255),
+    intent_name varchar(255),
+    CONSTRAINT intent_test_task_pkey PRIMARY KEY (intent_id)
+);
+
+create table if not exists expectation(
+    expectation_id varchar(255),
+    expectation_name varchar(255),
+    target_moi varchar(255),
+    intent_id varchar(255),
+    CONSTRAINT expectation_test_task_pkey PRIMARY KEY (expectation_id)
+);
+
+create table if not exists state(
+    state_id varchar(255),
+    state_name varchar(255),
+    is_satisfied boolean,
+    condition varchar(255),
+    expectation_id varchar(255),
+    CONSTRAINT state_test_task_pkey PRIMARY KEY (state_id)
+);