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