+create table schedule (
+ name varchar (255) not null,
+ task varchar (255) not null,
+ notification varchar (255) not null,
+ frequency tinytext,
+ active enum (
+ 'true',
+ 'false'
+ ) not null default 'true',
+ lastrunid int,
+
+ primary key (name),
+ foreign key taskLink (task) references task (name)
+ on delete cascade
+ on update cascade,
+ foreign key notificationLink (notification) references notification (name)
+ on delete cascade
+ on update cascade
+) engine=innodb; -- schedule
+
+create table alertlog (