| 224 |
jpm |
1 |
-- -----------------------------------------------------
|
|
|
2 |
-- Table `tl2_auteurs`
|
|
|
3 |
-- -----------------------------------------------------
|
|
|
4 |
CREATE TABLE IF NOT EXISTS `tl2_auteurs` (
|
|
|
5 |
`id_auteur` INT NOT NULL AUTO_INCREMENT ,
|
|
|
6 |
`tl2_volume` INT NOT NULL ,
|
|
|
7 |
`tl2_page` INT NOT NULL ,
|
|
|
8 |
`tl2_nom` TEXT NOT NULL ,
|
|
|
9 |
`nom` VARCHAR(45) NULL ,
|
|
|
10 |
`prenom` VARCHAR(45) NULL ,
|
|
|
11 |
`naissance_date` VARCHAR(45) NULL ,
|
|
|
12 |
`deces_date` VARCHAR(45) NULL ,
|
|
|
13 |
`abreviation` VARCHAR(45) NULL ,
|
|
|
14 |
`intitule_complet_originel` VARCHAR(255) NULL ,
|
|
|
15 |
`occupation` VARCHAR(255) NULL ,
|
|
|
16 |
`tl2_herbier` TEXT NULL ,
|
|
|
17 |
`tl2_bibliographie_biographie` TEXT NULL ,
|
|
|
18 |
`tl2_biofile` TEXT NULL ,
|
|
|
19 |
`tl2_correspondance` TEXT NULL ,
|
|
|
20 |
PRIMARY KEY (`id_auteur`) )
|
|
|
21 |
ENGINE = MyISAM
|
|
|
22 |
DEFAULT CHARACTER SET = utf8
|
|
|
23 |
COLLATE = utf8_general_ci;
|
|
|
24 |
|
|
|
25 |
|
|
|
26 |
-- -----------------------------------------------------
|
|
|
27 |
-- Table `tl2_publications`
|
|
|
28 |
-- -----------------------------------------------------
|
|
|
29 |
CREATE TABLE IF NOT EXISTS `tl2_publications` (
|
|
|
30 |
`id_publication` INT NOT NULL AUTO_INCREMENT ,
|
|
|
31 |
`tl2_num` VARCHAR(20) NOT NULL ,
|
|
|
32 |
`tl2_titre_complet` VARCHAR(500) NOT NULL ,
|
|
|
33 |
`tl2_titre_court` VARCHAR(255) NULL ,
|
|
|
34 |
`tl2_notes` TEXT NULL ,
|
|
|
35 |
PRIMARY KEY (`id_publication`) )
|
|
|
36 |
ENGINE = MyISAM
|
|
|
37 |
DEFAULT CHARACTER SET = utf8
|
|
|
38 |
COLLATE = utf8_general_ci;
|
|
|
39 |
|
|
|
40 |
|
|
|
41 |
-- -----------------------------------------------------
|
|
|
42 |
-- Table `tl2_auteur_a_publication`
|
|
|
43 |
-- -----------------------------------------------------
|
|
|
44 |
CREATE TABLE IF NOT EXISTS `tl2_auteur_a_publication` (
|
|
|
45 |
`id_auteur` INT NOT NULL ,
|
|
|
46 |
`id_publication` INT NOT NULL ,
|
|
|
47 |
PRIMARY KEY (`id_auteur`, `id_publication`) ,
|
|
|
48 |
INDEX `fk_tl2_auteur_a_publication_tl2_publications1` (`id_publication` ASC) ,
|
|
|
49 |
CONSTRAINT `fk_tl2_auteur_a_publication_tl2_auteurs`
|
|
|
50 |
FOREIGN KEY (`id_auteur` )
|
|
|
51 |
REFERENCES `tl2_auteurs` (`id_auteur` )
|
|
|
52 |
ON DELETE NO ACTION
|
|
|
53 |
ON UPDATE NO ACTION,
|
|
|
54 |
CONSTRAINT `fk_tl2_auteur_a_publication_tl2_publications1`
|
|
|
55 |
FOREIGN KEY (`id_publication` )
|
|
|
56 |
REFERENCES `tl2_publications` (`id_publication` )
|
|
|
57 |
ON DELETE NO ACTION
|
|
|
58 |
ON UPDATE NO ACTION)
|
|
|
59 |
ENGINE = MyISAM
|
|
|
60 |
DEFAULT CHARACTER SET = utf8
|
|
|
61 |
COLLATE = utf8_general_ci;
|