1,42 → 1,33 |
CREATE TABLE ref_triple ( |
id_triple INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
ressource VARCHAR(255) NULL , |
propriete VARCHAR(255) NULL , |
valeur TEXT NULL , |
PRIMARY KEY(id_triple) , |
INDEX ressource(ressource) , |
INDEX propriete(propriete)); |
CREATE TABLE IF NOT EXISTS `ref_triple` ( |
`id_triple` int(10) unsigned NOT NULL auto_increment, |
`ressource` varchar(255) default NULL, |
`propriete` varchar(255) default NULL, |
`valeur` text, |
PRIMARY KEY (`id_triple`), |
KEY `ressource` (`ressource`), |
KEY `propriete` (`propriete`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|
CREATE TABLE IF NOT EXISTS `ref_traitement` ( |
`id_traitement` int(10) unsigned NOT NULL auto_increment, |
`referentiel_code` varchar(50) default NULL, |
`script` varchar(50) default NULL COMMENT 'Nom du script à lancer.', |
`nom` varchar(100) default NULL, |
`date_debut` datetime default NULL, |
`date_fin` datetime default NULL, |
`duree` time default NULL, |
`meta_date_creation` datetime default NULL, |
PRIMARY KEY (`id_traitement`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|
|
CREATE TABLE ref_traitement ( |
id_traitement INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
referentiel_code VARCHAR(50) NULL , |
nom VARCHAR(100) NULL , |
date_debut DATETIME NULL , |
date_fin DATETIME NULL , |
meta_date_creation DATETIME NULL , |
PRIMARY KEY(id_traitement)); |
|
|
|
|
|
|
|
|
|
CREATE TABLE ref_resultat ( |
id_resultat INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
ce_traitement INTEGER UNSIGNED NULL , |
nom VARCHAR(100) NULL , |
description TEXT NULL , |
resultat BOOL NULL , |
message MEDIUMTEXT NULL , |
meta_date_creation DATETIME NULL , |
PRIMARY KEY(id_resultat) , |
INDEX ce_traitement(ce_traitement)); |
|
|
|
|
CREATE TABLE IF NOT EXISTS `ref_resultat` ( |
`id_resultat` int(10) unsigned NOT NULL auto_increment, |
`ce_traitement` int(10) unsigned default NULL, |
`nom` varchar(100) default NULL, |
`description` text, |
`resultat` tinyint(1) default NULL, |
`message` mediumtext, |
`meta_date_creation` datetime default NULL, |
PRIMARY KEY (`id_resultat`), |
KEY `ce_traitement` (`ce_traitement`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |