Subversion Repositories eFlore/Projets.eflore-projets

Compare Revisions

No changes between revisions

Ignore whitespace Rev 224 → Rev 996

/tags/v5.3-amandaie/docs/projets/tl2/bdd/tl2.mwb
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/tags/v5.3-amandaie/docs/projets/tl2/bdd/tl2.mwb
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/tags/v5.3-amandaie/docs/projets/tl2/bdd/tl2.sql
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;