applications/guard/src/test/resources/META-INF/createtest.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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);