Listing 2. SQL CREATE TABLE Script to Define the
Basic Job Control Table

CREATE TABLE `JobManagement` ( `task_id` int(11) NOT NULL, `entry_id` int(11) NOT NULL AUTO_INCREMENT, `node_id` int(11) DEFAULT NULL, `node_start` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `node_end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `datapath` varchar(256) DEFAULT NULL, `task_name` varchar(128) NOT NULL, PRIMARY KEY (`task_id`,`entry_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;