Subversion Repositories Applications.referentiel

CREATE TABLE ref_triple (

CREATE TABLE IF NOT EXISTS `ref_triple` (

  id_triple INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,

  `id_triple` int(10) unsigned NOT NULL auto_increment,

  ressource VARCHAR(255)  NULL  ,

  `ressource` varchar(255) default NULL,

  propriete VARCHAR(255)  NULL  ,

  `propriete` varchar(255) default NULL,

  valeur TEXT  NULL    ,

  `valeur` text,

PRIMARY KEY(id_triple)  ,

  PRIMARY KEY  (`id_triple`),

INDEX ressource(ressource)  ,

  KEY `ressource` (`ressource`),

INDEX propriete(propriete));

  KEY `propriete` (`propriete`)

CREATE TABLE ref_traitement (

CREATE TABLE IF NOT EXISTS `ref_traitement` (

  id_traitement INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,

  `id_traitement` int(10) unsigned NOT NULL auto_increment,

  referentiel_code VARCHAR(50)  NULL  ,

  `referentiel_code` varchar(50) default NULL,

  nom VARCHAR(100)  NULL  ,

  `nom` varchar(100) default NULL,

  date_debut DATETIME  NULL  ,

  `date_debut` datetime default NULL,

  date_fin DATETIME  NULL  ,

  `date_fin` datetime default NULL,

  meta_date_creation DATETIME  NULL    ,

  `meta_date_creation` datetime default NULL,

PRIMARY KEY(id_traitement));

  PRIMARY KEY  (`id_traitement`)

CREATE TABLE ref_resultat (

CREATE TABLE IF NOT EXISTS `ref_resultat` (

  id_resultat INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,

  `id_resultat` int(10) unsigned NOT NULL auto_increment,

  ce_traitement INTEGER UNSIGNED  NULL  ,

  `ce_traitement` int(10) unsigned default NULL,

  nom VARCHAR(100)  NULL  ,

  `nom` varchar(100) default NULL,

  description TEXT  NULL  ,

  `description` text,

  resultat BOOL  NULL  ,

  `resultat` tinyint(1) default NULL,

  message MEDIUMTEXT  NULL  ,

  `message` mediumtext,

  meta_date_creation DATETIME  NULL    ,

  `meta_date_creation` datetime default NULL,

PRIMARY KEY(id_resultat)  ,

  PRIMARY KEY  (`id_resultat`),

INDEX ce_traitement(ce_traitement));

  KEY `ce_traitement` (`ce_traitement`)