| New file |
|---|
| 0,0 → 1,47 |
|---|
| -- ----------------------------------------------------- |
| -- Table `cel_arbre_mots_cles_images` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `cel_arbre_mots_cles_images` ; |
| |
| CREATE TABLE IF NOT EXISTS `cel_arbre_mots_cles_images` ( |
| `id_mot_cle` INT NOT NULL AUTO_INCREMENT , |
| `chemin` VARCHAR(2048) NULL , |
| `mot_cle` VARCHAR(255) NULL , |
| `id_utilisateur` VARCHAR(255) NULL , |
| PRIMARY KEY (`id_mot_cle`) ) |
| ENGINE = MyISAM; |
| |
| -- ----------------------------------------------------- |
| -- Table `cel_mots_cles_images_liaison` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `cel_mots_cles_images_liaison` ; |
| |
| CREATE TABLE IF NOT EXISTS `cel_mots_cles_images_liaison` ( |
| `id_element_lie` INT NOT NULL , |
| `id_mot_cle` INT NOT NULL , |
| PRIMARY KEY (`id_element_lie`, `id_mot_cle`) ) |
| ENGINE = MyISAM; |
| |
| -- ----------------------------------------------------- |
| -- Table `cel_arbre_mots_cles_obs` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `cel_arbre_mots_cles_obs` ; |
| |
| CREATE TABLE IF NOT EXISTS `cel_arbre_mots_cles_obs` ( |
| `id_mot_cle` INT NOT NULL AUTO_INCREMENT , |
| `chemin` VARCHAR(2048) NULL , |
| `mot_cle` VARCHAR(255) NULL , |
| `id_utilisateur` VARCHAR(255) NULL , |
| PRIMARY KEY (`id_mot_cle`) ) |
| ENGINE = MyISAM; |
| |
| -- ----------------------------------------------------- |
| -- Table `cel_mots_cles_obs_liaison` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `cel_mots_cles_obs_liaison` ; |
| |
| CREATE TABLE IF NOT EXISTS `cel_mots_cles_obs_liaison` ( |
| `id_element_lie` INT NOT NULL , |
| `id_mot_cle` INT NOT NULL , |
| PRIMARY KEY (`id_element_lie`, `id_mot_cle`) ) |
| ENGINE = MyISAM; |