3 create table if not exists operationshistory (
4 id int(11) not null auto_increment,
5 closedLoopName varchar(255) not null,
7 actor varchar(50) not null,
8 operation varchar(50) not null,
9 target varchar(50) not null,
10 starttime timestamp not null,
11 outcome varchar(50) not null,
13 subrequestId varchar(50),
14 endtime timestamp not null default current_timestamp,
18 insert into operationshistory (`closedLoopName`,`requestId`,`actor`,`operation`,`target`,`starttime`,`outcome`,`message`,`subrequestId`,`endtime`)
19 VALUES('ControlLoop-vDNS-6f37f56d-a87d-4b85-b6a9-cc953cf779b3','test001122','SO','VF Module Create','.*',NOW() - INTERVAL 1 HOUR,'SUCCESS',null,null,Now());