Subversion Repositories Applications.referentiel

Compare Revisions

Ignore whitespace Rev 43 → Rev 44

/trunk/doc/bdd/referentiel.sql
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;