Subversion Repositories eFlore/Applications.cel

Rev

Rev 2063 | Go to most recent revision | 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`) )