Subversion Repositories Applications.referentiel

Rev

Rev 44 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
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;