Page 1 of 1

failing to create tables

Posted: Mon Mar 09, 2015 7:56 pm
by davidgwalker
If your install is not creating the tables for you, try running this SQL to create the tables for you:

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