USE mysql

DELETE FROM user WHERE user = 'BOSSv3_3manager';
DELETE FROM db WHERE user = 'BOSSv3_3manager';
DELETE FROM tables_priv WHERE user = 'BOSSv3_3manager';
DELETE FROM columns_priv WHERE user = 'BOSSv3_3manager';
DELETE FROM user WHERE user = 'BOSSv3_3monitor';
DELETE FROM db WHERE user = 'BOSSv3_3monitor';
DELETE FROM tables_priv WHERE user = 'BOSSv3_3monitor';
DELETE FROM columns_priv WHERE user = 'BOSSv3_3monitor';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON boss_v3_3.* TO 'BOSSv3_3manager'@localhost IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON boss_v3_3.* TO 'BOSSv3_3manager'@'gateway' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
GRANT SELECT ON boss_v3_3.* TO 'BOSSv3_3monitor'@localhost IDENTIFIED BY 'PASSWORD';
GRANT SELECT ON boss_v3_3.* TO 'BOSSv3_3monitor'@'gateway' IDENTIFIED BY 'PASSWORD';
CREATE DATABASE IF NOT EXISTS boss_v3_3;
USE boss_v3_3
CREATE TABLE IF NOT EXISTS SCHEDULER (
NAME 		CHAR(30) BINARY NOT NULL PRIMARY KEY, 
DEF 		CHAR(1) NOT NULL DEFAULT "N", 
TOP_WORK_DIR 	VARCHAR(100) BINARY NOT NULL DEFAULT "NONE",
SUBMIT_BIN	MEDIUMBLOB NOT NULL DEFAULT "",
KILL_BIN	MEDIUMBLOB NOT NULL DEFAULT "",
QUERY_BIN	MEDIUMBLOB NOT NULL DEFAULT ""
);
CREATE TABLE IF NOT EXISTS JOBTYPE (
NAME 		CHAR(30) BINARY NOT NULL PRIMARY KEY, 
SCHEMA 		BLOB NOT NULL DEFAULT "", 
COMMENT 	VARCHAR(100) NOT NULL DEFAULT "",
PRE_BIN		MEDIUMBLOB NOT NULL DEFAULT "",
RUN_BIN		MEDIUMBLOB NOT NULL DEFAULT "",
POST_BIN	MEDIUMBLOB NOT NULL DEFAULT ""
);
INSERT INTO JOBTYPE VALUES ("stdjob","","Default standard job","","","");
CREATE TABLE IF NOT EXISTS JOB (
ID          INT AUTO_INCREMENT NOT NULL PRIMARY KEY,
TYPE        VARCHAR(30) BINARY NOT NULL DEFAULT "",
SCH         VARCHAR(30) BINARY NOT NULL DEFAULT "",
SID         VARCHAR(100) BINARY NOT NULL DEFAULT "",
S_HOST      VARCHAR(30) BINARY NOT NULL DEFAULT "",
S_PATH      VARCHAR(255) BINARY NOT NULL DEFAULT "",
S_USR       VARCHAR(30) BINARY NOT NULL DEFAULT "",
EXEC        VARCHAR(255) BINARY NOT NULL DEFAULT "",
ARGS        VARCHAR(255) BINARY NOT NULL DEFAULT "",
STDIN       VARCHAR(255) BINARY NOT NULL DEFAULT "",
STDOUT      VARCHAR(255) BINARY NOT NULL DEFAULT "",
STDERR      VARCHAR(255) BINARY NOT NULL DEFAULT "",
E_HOST      VARCHAR(30) BINARY NOT NULL DEFAULT "",
E_PATH      VARCHAR(255) BINARY NOT NULL DEFAULT "",
E_USR       VARCHAR(30) BINARY NOT NULL DEFAULT "",
LOG         VARCHAR(255) BINARY NOT NULL DEFAULT "",
T_SUB       INT NOT NULL DEFAULT 0,
T_START     INT NOT NULL DEFAULT 0,
T_STOP      INT NOT NULL DEFAULT 0,
T_STAT      VARCHAR(50) BINARY NOT NULL DEFAULT "",
RET_CODE    VARCHAR(11) BINARY NOT NULL DEFAULT ""
);
FLUSH PRIVILEGES;

CREATE INDEX E_USR ON JOB (E_USR);
CREATE INDEX S_USR ON JOB (S_USR);
CREATE INDEX T_SUB ON JOB (T_SUB);
CREATE INDEX T_STAT ON JOB (T_STAT);
CREATE INDEX T_STAT_USR ON JOB (S_USR, T_STAT);