| 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)); |
| |
| |
| |
| |