| New file |
|---|
| 0,0 → 1,33 |
|---|
| 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 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; |