Difference: Database ( vs. 1)

Revision 12011-03-30 - WangXinhua

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="WebHome"
-- 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;

 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback