Subversion Repositories eFlore/Applications.cel

Rev

Rev 2069 | Rev 2299 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2069 Rev 2240
Line 61... Line 61...
61 
DROP TABLE IF EXISTS `cel_mots_cles_images_liaison` ;
 61 
DROP TABLE IF EXISTS `cel_mots_cles_images_liaison` ;
Line 62... Line 62...
62 
 
 62 
 
63 
CREATE  TABLE IF NOT EXISTS `cel_mots_cles_images_liaison` (
 63 
CREATE  TABLE IF NOT EXISTS `cel_mots_cles_images_liaison` (
64 
  `id_element_lie` INT NOT NULL ,
 64 
  `id_element_lie` INT NOT NULL ,
- 
 
 65 
  `id_mot_cle` INT NOT NULL ,
65 
  `id_mot_cle` INT NOT NULL ,
 66 
  `date_liaison` DATETIME DEFAULT NOW(),
66 
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
 67 
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
Line 67... Line 68...
67 
ENGINE = MyISAM;
 68 
ENGINE = MyISAM;
Line 168... Line 169...
168 
DROP TABLE IF EXISTS `cel_mots_cles_obs_liaison` ;
 169 
DROP TABLE IF EXISTS `cel_mots_cles_obs_liaison` ;
Line 169... Line 170...
169 
 
 170 
 
170 
CREATE  TABLE IF NOT EXISTS `cel_mots_cles_obs_liaison` (
 171 
CREATE  TABLE IF NOT EXISTS `cel_mots_cles_obs_liaison` (
171 
  `id_element_lie` INT NOT NULL ,
 172 
  `id_element_lie` INT NOT NULL ,
- 
 
 173 
  `id_mot_cle` INT NOT NULL ,
172 
  `id_mot_cle` INT NOT NULL ,
 174 
  `date_liaison` DATETIME DEFAULT NOW(),
173 
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
 175 
  PRIMARY KEY (`id_element_lie`, `id_mot_cle`) )
Line 174... Line 176...
174 
ENGINE = MyISAM;
 176 
ENGINE = MyISAM;