New file |
0,0 → 1,61 |
-- ----------------------------------------------------- |
-- 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; |