Subversion Repositories eFlore/Applications.del

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';


-- -----------------------------------------------------
-- Table `del_image_protocole`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del_image_protocole` ;

CREATE  TABLE IF NOT EXISTS `del_image_protocole` (
  `id_protocole` INT(11) NOT NULL AUTO_INCREMENT ,
  `intitule` VARCHAR(255) NOT NULL ,
  `descriptif` TEXT NULL ,
  PRIMARY KEY (`id_protocole`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `del_image_vote`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del_image_vote` ;

CREATE  TABLE IF NOT EXISTS `del_image_vote` (
  `id_vote` BIGINT NOT NULL AUTO_INCREMENT ,
  `ce_image` BIGINT NOT NULL ,
  `ce_protocole` INT(11) NOT NULL ,
  `ce_utilisateur` INT NULL ,
  `valeur` TINYINT(1) NOT NULL ,
  `date` DATETIME NOT NULL ,
  PRIMARY KEY (`id_vote`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `del_image_tag`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del_image_tag` ;

CREATE  TABLE IF NOT EXISTS `del_image_tag` (
  `id_tag` BIGINT NOT NULL AUTO_INCREMENT ,
  `ce_image` BIGINT NOT NULL ,
  `ce_utilisateur` INT NOT NULL ,
  `tag` VARCHAR(45) NOT NULL ,
  `md5` VARCHAR(32) NOT NULL ,
  PRIMARY KEY (`id_tag`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `del_commentaire`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del_commentaire` ;

CREATE  TABLE IF NOT EXISTS `del_commentaire` (
  `id_commentaire` BIGINT NOT NULL AUTO_INCREMENT ,
  `ce_observation` BIGINT NOT NULL ,
  `ce_commentaire_parent` BIGINT NULL ,
  `ce_proposition` BIGINT NULL ,
  `texte` TEXT NOT NULL ,
  `ce_utilisateur` INT NULL ,
  `utilisateur_prenom` VARCHAR(255) NOT NULL ,
  `utilisateur_nom` VARCHAR(255) NOT NULL ,
  `utilisateur_courriel` VARCHAR(255) NOT NULL ,
  PRIMARY KEY (`id_commentaire`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `del_proposition`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del_proposition` ;

CREATE  TABLE IF NOT EXISTS `del_proposition` (
  `id_proposition` BIGINT NOT NULL ,
  `nom_sel` VARCHAR(255) NOT NULL COMMENT 'Nom scientifique sélectionné\n' ,
  `nom_sel_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique selectionné\n' ,
  `nom_ret` VARCHAR(255) NULL COMMENT 'Nom scientifique retenu\n' ,
  `nom_ret_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique retenu\n' ,
  `nt` INT NULL COMMENT 'Numéro taxonomique\n' ,
  `famille` VARCHAR(255) NULL ,
  `nom_referentiel` VARCHAR(45) NULL COMMENT 'Nom du référentiel utilisé (ex bdtfx_v1)\n' ,
  PRIMARY KEY (`id_proposition`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `del_proposition_vote`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `del_proposition_vote` ;

CREATE  TABLE IF NOT EXISTS `del_proposition_vote` (
  `id_vote` BIGINT NOT NULL AUTO_INCREMENT ,
  `ce_proposition` BIGINT NOT NULL ,
  `ce_utilisateur` INT NULL ,
  `valeur` TINYINT(1) NOT NULL ,
  `date` DATETIME NOT NULL ,
  PRIMARY KEY (`id_vote`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;