Code: Select all
CREATE TABLE IF NOT EXISTS `phpjobscheduler_logs` (
id int(11) NOT NULL auto_increment,
date_added int(11),
script varchar(128) default NULL,
output text default NULL,
execution_time varchar(60) default NULL,
PRIMARY KEY (id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `phpjobscheduler` (
id int(11) NOT NULL auto_increment,
scriptpath varchar(255) default NULL,
name varchar(128) default NULL,
time_interval int(11) default NULL,
fire_time int(11) NOT NULL default '0',
time_last_fired int(11) default NULL,
run_only_once tinyint(1) NOT NULL DEFAULT '0',
currently_running BOOLEAN NOT NULL DEFAULT '0',
paused BOOLEAN NOT NULL DEFAULT '0',
PRIMARY KEY (id),
KEY fire_time (fire_time)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Thanks for this suggestion go to: Gerbrand van der Haak
We hope it helps you!
All the best
Dave