Rev 224 | Blame | Compare with Previous | Last modification | View Log | RSS feed
-- -----------------------------------------------------
-- 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;