2 # Create the operations history table
4 CREATE TABLE `operationshistory`
7 `closedLoopName` varchar(255) not null,
8 `requestId` varchar(50) not null,
9 `subrequestId` varchar(50) not null,
10 `actor` varchar(50) not null,
11 `operation` varchar(50) not null,
12 `target` varchar(50) not null,
13 `starttime` timestamp not null,
14 `outcome` varchar(50) not null,
15 `message` varchar(255) not null,
16 `endtime` timestamp not null);