Subversion Repositories eFlore/Applications.del

Rev

Rev 808 | Rev 1155 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 808 Rev 1141
Line 115... Line 115...
115 
DROP TABLE IF EXISTS `del_image_tag` ;
 115 
DROP TABLE IF EXISTS `del_image_tag` ;
Line 116... Line 116...
116 
 
 116 
 
117 
CREATE  TABLE IF NOT EXISTS `del_image_tag` (
 117 
CREATE  TABLE IF NOT EXISTS `del_image_tag` (
118 
  `id_tag` BIGINT NOT NULL AUTO_INCREMENT ,
 118 
  `id_tag` BIGINT NOT NULL AUTO_INCREMENT ,
119 
  `ce_image` BIGINT NOT NULL ,
 119 
  `ce_image` BIGINT NOT NULL ,
120 
  `ce_utilisateur` INT NOT NULL ,
 120 
  `ce_utilisateur` VARCHAR(32) NOT NULL ,
121 
  `tag` VARCHAR(45) NOT NULL ,
 121 
  `tag` VARCHAR(125) NOT NULL ,
122 
  `md5` VARCHAR(32) NOT NULL ,
 122 
  `tag_normalise` VARCHAR(32) NOT NULL ,
123 
  `date` DATETIME NOT NULL COMMENT 'Date de création du tag.' ,
 123 
  `date` DATETIME NOT NULL COMMENT 'Date de création du tag.' ,
- 
 
 124 
  PRIMARY KEY (`id_tag`) ,
- 
 
 125 
  INDEX `tag` (`tag` ASC) ,
124 
  PRIMARY KEY (`id_tag`) )
 126 
  INDEX `tag_normalise` (`tag_normalise` ASC) )
125 
ENGINE = MyISAM
 127 
ENGINE = MyISAM
126 
DEFAULT CHARACTER SET = utf8
 128 
DEFAULT CHARACTER SET = utf8