USE boss_v3_3;

# Table: 'DAGARC'
# 
CREATE TABLE IF NOT EXISTS DAGARC (
  `cid` int(11) NOT NULL default '0',
  `pid` int(11) NOT NULL default '0'
) TYPE=MyISAM; 

# Table: 'DAGNODE'
# 
CREATE TABLE IF NOT EXISTS DAGNODE (
  `id` int(11) NOT NULL auto_increment,
  `t_stat` varchar(100) default NULL,
  `name` varchar(100) NOT NULL,
  `jobid` varchar(100) NOT NULL,
  `t_sub` datetime default NULL,
  `t_stop` datetime default NULL,
  `t_start` datetime default NULL,
  `subfile` varchar(100) NOT NULL,
  `ret_code` varchar(11) default '',
  `stderr` varchar(100) default '',
  `stdout` varchar(100) default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM; 

CREATE INDEX name ON DAGNODE (name);
CREATE INDEX jobid ON DAGNODE (jobid);

CREATE INDEX cid ON DAGARC (cid);
CREATE INDEX pid ON DAGARC (pid);