Subversion Repositories eFlore/Projets.eflore-projets

-- -----------------------------------------------------
-- Table `tl2_auteurs`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `tl2_auteurs` (
  `id_auteur` INT NOT NULL AUTO_INCREMENT ,
  `tl2_volume` INT NOT NULL ,
  `tl2_page` INT NOT NULL ,
  `tl2_nom` TEXT NOT NULL ,
  `nom` VARCHAR(45) NULL ,
  `prenom` VARCHAR(45) NULL ,
  `naissance_date` VARCHAR(45) NULL ,
  `deces_date` VARCHAR(45) NULL ,
  `abreviation` VARCHAR(45) NULL ,
  `intitule_complet_originel` VARCHAR(255) NULL ,
  `occupation` VARCHAR(255) NULL ,
  `tl2_herbier` TEXT NULL ,
  `tl2_bibliographie_biographie` TEXT NULL ,
  `tl2_biofile` TEXT NULL ,
  `tl2_correspondance` TEXT NULL ,
  PRIMARY KEY (`id_auteur`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `tl2_publications`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `tl2_publications` (
  `id_publication` INT NOT NULL AUTO_INCREMENT ,
  `tl2_num` VARCHAR(20) NOT NULL ,
  `tl2_titre_complet` VARCHAR(500) NOT NULL ,
  `tl2_titre_court` VARCHAR(255) NULL ,
  `tl2_notes` TEXT NULL ,
  PRIMARY KEY (`id_publication`) )
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;


-- -----------------------------------------------------
-- Table `tl2_auteur_a_publication`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `tl2_auteur_a_publication` (
  `id_auteur` INT NOT NULL ,
  `id_publication` INT NOT NULL ,
  PRIMARY KEY (`id_auteur`, `id_publication`) ,
  INDEX `fk_tl2_auteur_a_publication_tl2_publications1` (`id_publication` ASC) ,
  CONSTRAINT `fk_tl2_auteur_a_publication_tl2_auteurs`
    FOREIGN KEY (`id_auteur` )
    REFERENCES `tl2_auteurs` (`id_auteur` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_tl2_auteur_a_publication_tl2_publications1`
    FOREIGN KEY (`id_publication` )
    REFERENCES `tl2_publications` (`id_publication` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci;