Subversion Repositories eFlore/Applications.cel

Rev

Rev 2063 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2063 Rev 2069
Line 2... Line 2...
2
-- Table `cel_arbre_mots_cles_images`
2
-- Table `cel_arbre_mots_cles_images`
3
-- -----------------------------------------------------
3
-- -----------------------------------------------------
4
DROP TABLE IF EXISTS `cel_arbre_mots_cles_images` ;
4
DROP TABLE IF EXISTS `cel_arbre_mots_cles_images` ;
Line 5... Line 5...
5
 
5
 
6
CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_images` (
6
CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_images` (
7
  `id_mot_cle` INT NOT NULL ,
7
  `id_mot_cle` INT NOT NULL AUTO_INCREMENT ,
8
  `chemin` VARCHAR(2048) NULL ,
8
  `chemin` VARCHAR(2048) NULL ,
9
  `mot_cle` VARCHAR(255) NULL ,
9
  `mot_cle` VARCHAR(255) NULL ,
10
  `id_utilisateur` VARCHAR(255) NULL ,
10
  `id_utilisateur` VARCHAR(255) NULL ,
11
  PRIMARY KEY (`id_mot_cle`) )
11
  PRIMARY KEY (`id_mot_cle`) )
Line 26... Line 26...
26
-- Table `cel_arbre_mots_cles_obs`
26
-- Table `cel_arbre_mots_cles_obs`
27
-- -----------------------------------------------------
27
-- -----------------------------------------------------
28
DROP TABLE IF EXISTS `cel_arbre_mots_cles_obs` ;
28
DROP TABLE IF EXISTS `cel_arbre_mots_cles_obs` ;
Line 29... Line 29...
29
 
29
 
30
CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_obs` (
30
CREATE  TABLE IF NOT EXISTS `cel_arbre_mots_cles_obs` (
31
  `id_mot_cle` INT NOT NULL ,
31
  `id_mot_cle` INT NOT NULL AUTO_INCREMENT ,
32
  `chemin` VARCHAR(2048) NULL ,
32
  `chemin` VARCHAR(2048) NULL ,
33
  `mot_cle` VARCHAR(255) NULL ,
33
  `mot_cle` VARCHAR(255) NULL ,
34
  `id_utilisateur` VARCHAR(255) NULL ,
34
  `id_utilisateur` VARCHAR(255) NULL ,
35
  PRIMARY KEY (`id_mot_cle`) )
35
  PRIMARY KEY (`id_mot_cle`) )