-- //Copyright 2006-2008 Acelet Corporation. All rights reserved.

CREATE TABLE `logMessage` (
  `id` int(11) NOT NULL auto_increment,
  `timemark` decimal(20),
  `hostname` varchar(100),
  `threadName` varchar(100),
  `whereabouts` varchar(200),
  `why` varchar(100),
  `msg` varchar(1024),
  PRIMARY KEY  (`id`),
  KEY `logMessageTm` (`timemark`),
  KEY `logMessageHn` (`hostname`),
  KEY `logMessageTn` (`threadName`),
  KEY `logMessageWhy` (`why`)
);


-- MOONSPA: I didn't found any occurance of these tables within the source code of opensource edition
-- and so I commented it out due tuo the not existing dirrect alternative of OBJECT type in MySQL

-- Copyright Acelet Corp. 2001-2005. All rights reserved
-- Web site: http://www.acelet.com

-- GlobalProperties database script for oracle.
-- Version 1.1
-- 
-- You can change the size of columns (if it is applicable). 
-- The size of columns affects the limitation of the program.
--


-- CREATE TABLE `globalDouble` (
--   `theKey` varchar(500) NOT NULL,
--   `theValue` decimal(10,0),
--   PRIMARY KEY  (`theKey`)
-- );
-- CREATE TABLE globalHashtable 
--   (theKey OBJECT NOT NULL,
--    theValue OBJECT); 
-- CREATE TABLE globalLong 
--   (theKey VARCHAR(500) NOT NULL,
--    theValue NUMBER(20), 
--    PRIMARY KEY (theKey));
-- CREATE TABLE globalObject 
--   (theKey VARCHAR(500) NOT NULL,
--    theValue OBJECT, 
--    PRIMARY KEY (theKey));
-- CREATE TABLE globalProperties 
--   (theKey VARCHAR(500) NOT NULL,
--    theValue VARCHAR(500), 
--    PRIMARY KEY (theKey));
-- Copyright Acelet Corp. 2000-2009. All rights reserved
-- Web site: http://www.acelet.com


--
-- SuperScheduler database script for MySQL.
--
CREATE TABLE `superSchedulerSchema` (
  `theVersion` varchar(100) NOT NULL,
  PRIMARY KEY  (`theVersion`)
);
INSERT INTO `superSchedulerSchema` (`theVersion`) VALUES 
('8.0');


CREATE TABLE `tasks` (
  `id` decimal(20) NOT NULL,
  `name` varchar(100),
  `job` blob,
  `jobType` int(11),
  `repeating` int(11),
  `startTime` decimal(20),
  `minutelyPeriod` int(11),
  `hourlyPeriod` int(11),
  `dailyPeriod` int(11),
  `weeklyPeriod` int(11),
  `weeklyWeekDay` int(11),
  `monthlyPeriod` int(11),
  `monthlyTheDay` int(11),
  `monthlyWhichWeek` int(11),
  `monthlyWhichWeekWeekDay` int(11),
  `specifiedTimes` varchar(400),
  `wouldbe` decimal(20),
  `holidayPolicy` int(11),
  `holidaySet` varchar(32),
  `expiration` decimal(20),
  `duration` decimal(20),
  `killIfExceedsDuration` int(11),
  `hostname` varchar(32),
  `club` varchar(100),
  `description` varchar(100),
  `comments` varchar(200),
  `status` int(11),
  `nextRunTime` decimal(20),
  `lastRunTime` decimal(20),
  `creator` varchar(100),
  `alarmEmail` varchar(100),
  `modifiedAt` decimal(20),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `task_name` (`name`)
);


CREATE TABLE `working_tasks` (
  `id` int(11) NOT NULL auto_increment,
  `id0` decimal(20),
  `name` varchar(100),
  `job` blob,
  `jobType` int(11),
  `oneShot` int(11),
  `realHost` varchar(100),
  `club` varchar(100),
  `status` int(11),
  `taskBrief` varchar(1000),
  `nextRunTime` decimal(20),
  `lastRunTime` decimal(20),
  `lastResult` varchar(3000),
  `modifiedAt` decimal(20),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `working_tasks2` (`id0`,`nextRunTime`),
  KEY `working3` (`lastRunTime`),
  KEY `working4` (`modifiedAt`)
);


CREATE TABLE `candidate_tasks` (
  `id` decimal(20) NOT NULL,
  `name` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
);


CREATE TABLE `schedulerPreference` (
  `theKey` varchar(100) NOT NULL,
  `theValue` varchar(100),
  PRIMARY KEY  (`theKey`)
);
INSERT INTO `schedulerPreference` (`theKey`, `theValue`) VALUES 
('interval', '2000'),
('extraIntervalForGateway', '20000'),
('workingTaskDisplayMax', '20'),
('workingTaskRetireTime', '172800000'),
('queryTimeout', '15'),
('logIncludesResult', 'false'),
('logAgentTimeout', '15000'),
('logAgentName', ''),
('schedulingMode', '2'),
('minimumDuration', '3000'),
('logHistoryTimeout', '30'),
('maxHeartbeatMiss', '3'),
('defaultDatabaseCompressTime', ''),
('defaultDatabaseBackupTime', '');


CREATE TABLE `schedulerRefresh` (
  `refreshTime` varchar(200)
);
INSERT INTO `schedulerRefresh` (`refreshTime`) VALUES 
('0 0 0 0');


CREATE TABLE `holiday` (
  `id` decimal(20) NOT NULL,
  `setName` varchar(32) NOT NULL,
  `name` varchar(32) NOT NULL,
  `theday` varchar(15) NOT NULL,
  `comments` varchar(100),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `holiday` (`setName`,`theday`)
);


CREATE TABLE `holiday_rule` (
  `id` decimal(20) NOT NULL,
  `setName` varchar(32) NOT NULL,
  `name` varchar(32) NOT NULL,
  `holidaying` varchar(100) NOT NULL,
  `fixMonth` int(11) NOT NULL,
  `fixDay` int(11) NOT NULL,
  `monthlyMonth` int(11) NOT NULL,
  `monthlyWhichWeek` int(11) NOT NULL,
  `monthlyWhichWeekWeekDay` int(11) NOT NULL,
  `comments` varchar(100),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `holiday_rule` (`setName`,`name`,`holidaying`,`fixMonth`,`fixDay`,`monthlyMonth`,`monthlyWhichWeek`,`monthlyWhichWeekWeekDay`)
);

   
CREATE TABLE `doerTalkers` (
  `name` varchar(100) NOT NULL,
  `checkinTime` decimal(20),
  PRIMARY KEY  (`name`)
);

   
CREATE TABLE `schedulerSettings` (
  `theKey` varchar(127) NOT NULL,
  `theValue` varchar(2000),
  PRIMARY KEY  (`theKey`)
);
INSERT INTO `schedulerSettings` (`theKey`, `theValue`) VALUES 
('transactionIsolation', 'TRANSACTION_READ_COMMITTED');


CREATE TABLE `entitlements` (
  `role` varchar(100) NOT NULL,
  `entitlement` int(11),
  PRIMARY KEY  (`role`)
);
INSERT INTO `entitlements` (`role`, `entitlement`) VALUES 
('Admin', 511),
('Operator', 484),
('Manager', 347);


CREATE TABLE roles (
  `name` varchar(100) NOT NULL,
  `role` varchar(100),
  PRIMARY KEY (`name`)
);


CREATE TABLE `working_jobs` (
  `id` int(11) NOT NULL auto_increment,
  `id0` decimal(20) NOT NULL,
  `name` varchar(100),
  `job` blob,
  `jobType` int(11),
  `lastRunTime` decimal(20),
  `taskChore` int(11),
  `modifiedAt` decimal(20),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `working_job2` (`id0`,`name`),
  KEY `working_jobs3` (`modifiedAt`)
);

--
-- SuperWatchdog database script for MySQL.
--
CREATE TABLE `superWatchdogSchema` (
  `theVersion` varchar(100) NOT NULL,
  PRIMARY KEY  (`theVersion`)
);
INSERT INTO `superWatchdogSchema` (`theVersion`) VALUES 
('6.0');


CREATE TABLE `chores` (
  `id` decimal(20) NOT NULL,
  `name` varchar(100),
  `job` blob,
  `jobType` int(11),
  `triggerObject` varchar(4000),
  `triggerType` int(11),
  `delay` int(11),
  `fromPeriod` decimal(20),
  `toPeriod` decimal(20),
  `duration` decimal(20),
  `killIfExceedsDuration` int(11),
  `hostname` varchar(32),
  `club` varchar(100),
  `description` varchar(100),
  `comments` varchar(200),
  `status` int(11),
  `lastTriggerTime` decimal(20),
  `lastRunTime` decimal(20),
  `creator` varchar(100),
  `alarmEmail` varchar(100),
  `modifiedAt` decimal(20),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `chore_name` (`name`)
);

-- Due the limitations of MySAM DB Engine size of stamp column has been decreesed from "1000" to "970"
CREATE TABLE `working_chores` (
  `id` int(11) NOT NULL auto_increment,
  `id0` decimal(20),
  `name` varchar(100),
  `stamp` varchar(970),
  `job` blob,
  `jobType` int(11),
  `oneShot` int(11),
  `realHost` varchar(32),
  `club` varchar(100),
  `status` int(11),
  `choreBrief` varchar(1000),
  `lastTriggerTime` decimal(20),
  `lastRunTime` decimal(20),
  `lastResult` varchar(3000),
  `modifiedAt` decimal(20),
  PRIMARY KEY  (`id`),
  UNIQUE KEY `working_chores2` (`id0`,`lastTriggerTime`,`stamp`),
  KEY `workingChore3` (`lastRunTime`),
  KEY `workingChore4` (`modifiedAt`)
);


CREATE TABLE candidate_chores (
  `id` decimal(20) NOT NULL, 
  `name` varchar(200) NOT NULL, 
  PRIMARY KEY (`id`)
);


CREATE TABLE `watchdogPreference` (
  `theKey` varchar(100) NOT NULL,
  `theValue` varchar(100),
  PRIMARY KEY  (`theKey`)
);
INSERT INTO `watchdogPreference` (`theKey`, `theValue`) VALUES 
('interval', '2000'),
('extraIntervalForGateway', '20000'),
('workingChoreDisplayMax', '20'),
('workingChoreRetireTime', '172800000'),
('queryTimeout', '15'),
('logIncludesResult', 'false'),
('logAgentTimeout', '15000'),
('minimumDuration', '3000'),
('logHistoryTimeout', '30'),
('maxHeartbeatMiss', '3');


CREATE TABLE `watchdogRefresh` (
  `refreshTime` varchar(200)
);
INSERT INTO `watchdogRefresh` (`refreshTime`) VALUES 
('0 0 0 0');


CREATE TABLE `watchdogDoerTalker` (
  `name` varchar(100) NOT NULL,
  `checkinTime` decimal(20),
  PRIMARY KEY (`name`)
);


CREATE TABLE `watchdogSettings` (
  `theKey` varchar(127) NOT NULL,
  `theValue` varchar(2000),
  PRIMARY KEY  (`theKey`)
);
INSERT INTO `watchdogSettings` (`theKey`, `theValue`) VALUES 
('transactionIsolation', 'TRANSACTION_READ_COMMITTED');