| 44 |
jpm |
1 |
CREATE TABLE IF NOT EXISTS `ref_triple` (
|
|
|
2 |
`id_triple` int(10) unsigned NOT NULL auto_increment,
|
|
|
3 |
`ressource` varchar(255) default NULL,
|
|
|
4 |
`propriete` varchar(255) default NULL,
|
|
|
5 |
`valeur` text,
|
|
|
6 |
PRIMARY KEY (`id_triple`),
|
|
|
7 |
KEY `ressource` (`ressource`),
|
|
|
8 |
KEY `propriete` (`propriete`)
|
|
|
9 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
| 18 |
jpm |
10 |
|
| 44 |
jpm |
11 |
CREATE TABLE IF NOT EXISTS `ref_traitement` (
|
|
|
12 |
`id_traitement` int(10) unsigned NOT NULL auto_increment,
|
|
|
13 |
`referentiel_code` varchar(50) default NULL,
|
|
|
14 |
`script` varchar(50) default NULL COMMENT 'Nom du script à lancer.',
|
|
|
15 |
`nom` varchar(100) default NULL,
|
|
|
16 |
`date_debut` datetime default NULL,
|
|
|
17 |
`date_fin` datetime default NULL,
|
|
|
18 |
`duree` time default NULL,
|
|
|
19 |
`meta_date_creation` datetime default NULL,
|
|
|
20 |
PRIMARY KEY (`id_traitement`)
|
|
|
21 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
| 18 |
jpm |
22 |
|
| 44 |
jpm |
23 |
CREATE TABLE IF NOT EXISTS `ref_resultat` (
|
|
|
24 |
`id_resultat` int(10) unsigned NOT NULL auto_increment,
|
|
|
25 |
`ce_traitement` int(10) unsigned default NULL,
|
|
|
26 |
`nom` varchar(100) default NULL,
|
|
|
27 |
`description` text,
|
|
|
28 |
`resultat` tinyint(1) default NULL,
|
|
|
29 |
`message` mediumtext,
|
|
|
30 |
`meta_date_creation` datetime default NULL,
|
|
|
31 |
PRIMARY KEY (`id_resultat`),
|
|
|
32 |
KEY `ce_traitement` (`ce_traitement`)
|
|
|
33 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|