New file |
0,0 → 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 ref_traitement ( |
id_traitement INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, |
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 , |
message MEDIUMTEXT NULL , |
meta_date_creation DATETIME NULL , |
PRIMARY KEY(id_resultat) , |
INDEX ce_traitement(ce_traitement)); |
|
|
|
|