Subversion Repositories eFlore/Projets.eflore-projets

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
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;