summaryrefslogtreecommitdiffstats
path: root/applications/guard/src/test/resources/META-INF/createtest.sql
diff options
context:
space:
mode:
Diffstat (limited to 'applications/guard/src/test/resources/META-INF/createtest.sql')
-rw-r--r--applications/guard/src/test/resources/META-INF/createtest.sql16
1 files changed, 16 insertions, 0 deletions
diff --git a/applications/guard/src/test/resources/META-INF/createtest.sql b/applications/guard/src/test/resources/META-INF/createtest.sql
new file mode 100644
index 00000000..c7389f33
--- /dev/null
+++ b/applications/guard/src/test/resources/META-INF/createtest.sql
@@ -0,0 +1,16 @@
+#
+# Create the operations history table
+#
+CREATE TABLE `operationshistory`
+ (
+ `id` bigint not null,
+ `closedLoopName` varchar(255) not null,
+ `requestId` varchar(50) not null,
+ `subrequestId` varchar(50) not null,
+ `actor` varchar(50) not null,
+ `operation` varchar(50) not null,
+ `target` varchar(50) not null,
+ `starttime` timestamp not null,
+ `outcome` varchar(50) not null,
+ `message` varchar(255) not null,
+ `endtime` timestamp not null);