1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| CREATE TABLE `tb_job` (
`job_internal_id` int(11) unsigned NOT NULL auto_increment,
`job_id` int(11) unsigned NOT NULL,
`job_alarm` smallint(6) unsigned default NULL,
`job_state` smallint(6) unsigned NOT NULL default '0',
`job_product_status` smallint(6) unsigned default NULL,
`job_type_id` int(11) unsigned NOT NULL,
`data_type` varchar(128) NOT NULL default '0',
`inst_client_id` int(11) unsigned NOT NULL,
`inst_server_id` int(11) unsigned NOT NULL,
`client_name` varchar(128) default NULL,
`server_name` varchar(128) default NULL,
`start_time` int(11) NOT NULL,
`end_time` int(11) NOT NULL,
`data_volume_kb` int(11) unsigned NOT NULL default '0',
`job_percent` smallint(6) unsigned default NULL,
`number_files` int(11) unsigned NOT NULL default '0',
`job_desc` varchar(64) NOT NULL default '',
PRIMARY KEY (`job_internal_id`),
UNIQUE KEY `job_id` (`job_id`,`inst_server_id`),
KEY `idx_server_name` (`server_name`),
KEY `idx_job_id` (`job_id`),
KEY `idx_client_name` (`client_name`),
KEY `idx_data_type` (`data_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table des operations de sauvegarde/restaure' AUTO_INCREMENT=2549 ; |
Partager