aboutsummaryrefslogtreecommitdiffstats
path: root/applications/guard/src/test/resources/META-INF/createtest.sql
blob: c7389f33944e2da3502e1bdcfdcee5061db03258 (plain)
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);