Page History

 CREATE TABLE IF NOT EXISTS SCHEDULER_JOBS (
   "SPOOLER_ID"             varchar(100) CHARACTER SET latin1 NOT NULL,         
   "CLUSTER_MEMBER_ID"      varchar(100) CHARACTER SET latin1 NOT NULL,                            
   "PATH"                   varchar(255) CHARACTER SET latin1 NOT NULL,                                                                
   "STOPPED"                int(1)       NOT NULL DEFAULT 0,                                                                      
   "NEXT_START_TIME"        varchar(24)  ,                                                                         
   PRIMARY KEY  ("SPOOLER_ID","CLUSTER_MEMBER_ID","PATH")
 ) ENGINE=InnoDB; 

 
 
 CREATE TABLE IF NOT EXISTS SCHEDULER_JOB_CHAINS (
   "SPOOLER_ID"             varchar(100) CHARACTER SET latin1  NOT NULL,   
   "CLUSTER_MEMBER_ID"      varchar(100) CHARACTER SET latin1  NOT NULL,                     
   "PATH"                   varchar(255) CHARACTER SET latin1  NOT NULL,                                                      
   "STOPPED"                int(1)       NOT NULL DEFAULT 0,                                                                
   PRIMARY KEY  ("SPOOLER_ID","CLUSTER_MEMBER_ID","PATH")
 ) ENGINE=InnoDB; 
 

 
 CREATE TABLE IF NOT EXISTS SCHEDULER_JOB_CHAIN_NODES (
   "SPOOLER_ID"             varchar(100) CHARACTER SET latin1 NOT NULL, 
   "CLUSTER_MEMBER_ID"      varchar(100) CHARACTER SET latin1 NOT NULL,                     
   "JOB_CHAIN"              varchar(255) CHARACTER SET latin1 NOT NULL,                                                    
   "ORDER_STATE"            varchar(100) CHARACTER SET latin1 NOT NULL,                                                
   "ACTION"                 varchar(100) ,                                                    
   PRIMARY KEY  ("SPOOLER_ID","CLUSTER_MEMBER_ID","JOB_CHAIN","ORDER_STATE")
 ) ENGINE=InnoDB;