-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
--
http://www.phpmyadmin.net
--
-- 主机: bws0272.ihep.ac.cn
-- 生成日期: 2011 年 03 月 30 日 11:07
-- 服务器版本: 4.1.22
-- PHP 版本: 4.4.9
--
-- 数据库: `Dayabay`
--
-- --------------------------------------------------------
--
-- 表的结构 `2011_HistoryJob`
--
CREATE TABLE `2011_HistoryJob` (
`jobId` varchar(250) NOT NULL default '',
`jobComm` text NOT NULL,
`jobScript` varchar(250) NOT NULL default '',
`jobStatus` tinyint(2) NOT NULL default '0',
`submitDate` date NOT NULL default '0000-00-00',
`submitTime` time NOT NULL default '00:00:00',
`jobQueue` varchar(50) default NULL,
`jobType` tinyint(2) NOT NULL default '0',
`logFile` varchar(250) default NULL,
`siteName` varchar(20) NOT NULL default '',
`userName` varchar(15) NOT NULL default '',
`finish_flag` tinyint(1) default NULL,
`wallTime` varchar(15) default NULL,
`cpuTime` varchar(15) default NULL,
`backend` tinyint(2) NOT NULL default '0',
`taskId` int(11) NOT NULL default '0',
`fileName` varchar(250) NOT NULL default '',
`fileSeq` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `2011_Task`
--
CREATE TABLE `2011_Task` (
`taskId` int(10) NOT NULL auto_increment,
`command` text NOT NULL,
`taskScript` varchar(250) NOT NULL default '',
`submitDate` date NOT NULL default '0000-00-00',
`submitTime` time NOT NULL default '00:00:00',
`userName` varchar(15) NOT NULL default '',
`version` varchar(32) NOT NULL default '',
`jobType` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`taskId`)
) ENGINE=MyISAM AUTO_INCREMENT=294 DEFAULT CHARSET=latin1 AUTO_INCREMENT=294 ;
-- --------------------------------------------------------
--
-- 表的结构 `CurrentJob`
--
CREATE TABLE `CurrentJob` (
`jobId` varchar(250) NOT NULL default '',
`jobComm` text NOT NULL,
`jobScript` varchar(250) NOT NULL default '',
`jobStatus` tinyint(2) NOT NULL default '0',
`submitDate` date NOT NULL default '0000-00-00',
`submitTime` time NOT NULL default '00:00:00',
`jobQueue` varchar(50) default NULL,
`jobType` tinyint(2) NOT NULL default '0',
`logFile` varchar(250) default NULL,
`siteName` varchar(20) NOT NULL default '',
`userName` varchar(15) NOT NULL default '',
`finish_flag` tinyint(1) default '-1',
`wallTime` varchar(15) default NULL,
`cpuTime` varchar(15) default NULL,
`backend` tinyint(2) NOT NULL default '0',
`taskId` int(11) NOT NULL default '0',
`fileName` varchar(250) NOT NULL default '',
`fileSeq` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `CurrentMCFile`
--
CREATE TABLE `CurrentMCFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `CurrentMixFile`
--
CREATE TABLE `CurrentMixFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `CurrentRecMcFile`
--
CREATE TABLE `CurrentRecMcFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `CurrentRecRawFile`
--
CREATE TABLE `CurrentRecRawFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `FinishFlag`
--
CREATE TABLE `FinishFlag` (
`flagId` tinyint(2) NOT NULL default '0',
`flag` varchar(20) NOT NULL default '',
`flagDes` text NOT NULL,
PRIMARY KEY (`flagId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `JobStatus`
--
CREATE TABLE `JobStatus` (
`statusId` tinyint(2) NOT NULL default '0',
`jobStatus` varchar(20) NOT NULL default '',
`statusDes` text NOT NULL,
PRIMARY KEY (`statusId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `JobType`
--
CREATE TABLE `JobType` (
`jobType` tinyint(2) NOT NULL default '0',
`jobTypeName` varchar(20) NOT NULL default '',
`typeDes` text,
PRIMARY KEY (`jobType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `UnSubmitJob`
--
CREATE TABLE `UnSubmitJob` (
`jobId` varchar(250) NOT NULL default '',
`jobComm` text NOT NULL,
`jobScript` varchar(250) NOT NULL default '',
`jobStatus` tinyint(2) NOT NULL default '0',
`submitDate` date NOT NULL default '0000-00-00',
`submitTime` time NOT NULL default '00:00:00',
`jobQueue` varchar(50) default NULL,
`jobType` tinyint(2) NOT NULL default '0',
`logFile` varchar(250) default NULL,
`siteName` varchar(20) NOT NULL default '',
`userName` varchar(15) NOT NULL default '',
`finish_flag` tinyint(1) default '-1',
`wallTime` varchar(15) default NULL,
`cpuTime` varchar(15) default NULL,
`backend` tinyint(2) NOT NULL default '0',
`taskId` int(11) NOT NULL default '0',
`fileName` varchar(250) NOT NULL default '',
`fileSeq` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `UnSubmitMCFile`
--
CREATE TABLE `UnSubmitMCFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `UnSubmitMixFile`
--
CREATE TABLE `UnSubmitMixFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `UnSubmitRecMcFile`
--
CREATE TABLE `UnSubmitRecMcFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `UnSubmitRecRawFile`
--
CREATE TABLE `UnSubmitRecRawFile` (
`fileName` varchar(250) NOT NULL default '',
`inout_flag` char(1) NOT NULL default '0',
`jobId` varchar(250) NOT NULL default '',
`taskId` int(10) NOT NULL default '0',
PRIMARY KEY (`jobId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `errorInfo`
--
CREATE TABLE `errorInfo` (
`errorNo` tinyint(4) NOT NULL default '0',
`error` varchar(250) NOT NULL default '',
`errorDes` text NOT NULL,
PRIMARY KEY (`errorNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- 表的结构 `version`
--
CREATE TABLE `version` (
`version` char(32) NOT NULL default '',
`location` char(250) NOT NULL default '',
PRIMARY KEY (`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;