2 drop trigger if exists triggerinsertp1;
3 drop trigger if exists triggerupdatep1;
4 drop trigger if exists triggerdeletep1;
7 create trigger triggerinsertp1
11 Insert into csql_log_int (tablename, pkid, operation,cacheid) values ('p1', NEW.f1, 1,1);
14 create trigger triggerupdatep1
18 Insert into csql_log_int (tablename, pkid, operation,cacheid) values ('p1', OLD.f1, 2,1);
19 Insert into csql_log_int (tablename, pkid, operation,cacheid) values ('p1', NEW.f1, 1,1);
22 create trigger triggerdeletep1
26 Insert into csql_log_int (tablename, pkid, operation,cacheid) values ('p1', OLD.f1, 2,1);