Subversion Repositories Applications.referentiel

Rev

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

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;