Subversion Repositories Applications.referentiel

Rev

Rev 23 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
18 jpm 1 
CREATE TABLE ref_triple (
2 
  id_triple INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
3 
  ressource VARCHAR(255)  NULL  ,
4 
  propriete VARCHAR(255)  NULL  ,
5 
  valeur TEXT  NULL    ,
6 
PRIMARY KEY(id_triple)  ,
7 
INDEX ressource(ressource)  ,
8 
INDEX propriete(propriete));
9 
 
10 
 
11 
 
12 
CREATE TABLE ref_traitement (
13 
  id_traitement INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
14 
  nom VARCHAR(100)  NULL  ,
15 
  date_debut DATETIME  NULL  ,
16 
  date_fin DATETIME  NULL  ,
17 
  meta_date_creation DATETIME  NULL    ,
18 
PRIMARY KEY(id_traitement));
19 
 
20 
 
21 
 
22 
CREATE TABLE ref_resultat (
23 
  id_resultat INTEGER UNSIGNED  NOT NULL   AUTO_INCREMENT,
24 
  ce_traitement INTEGER UNSIGNED  NULL  ,
25 
  nom VARCHAR(100)  NULL  ,
26 
  message MEDIUMTEXT  NULL  ,
27 
  meta_date_creation DATETIME  NULL    ,
28 
PRIMARY KEY(id_resultat)  ,
29 
INDEX ce_traitement(ce_traitement));
30 
 
31 
 
32 
 
33