2,7 → 2,6 |
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; |
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL'; |
|
DROP SCHEMA IF EXISTS `del` ; |
CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ; |
USE `del` ; |
|
42,7 → 41,8 |
`date_creation` DATETIME NULL , |
`publiable_eflore` TINYINT(1) NULL , |
PRIMARY KEY (`id_image`) , |
UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) ) |
UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) , |
INDEX `fk_Images_Utilisateurs1` (`ce_utilisateur` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
74,7 → 74,8 |
`date_creation` DATETIME NULL , |
`date_modification` DATETIME NULL , |
`date_transmission` DATETIME NULL , |
PRIMARY KEY (`id_observation`) ) |
PRIMARY KEY (`id_observation`) , |
INDEX `fk_Observations_Utilisateurs1` (`ce_utilisateur` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
107,7 → 108,10 |
`ce_protocole` INT NOT NULL , |
`valeur_vote` TINYINT(1) NULL , |
PRIMARY KEY (`id_vote_image`) , |
UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) ) |
UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) , |
INDEX `fk_Vote_images_Protocoles` (`ce_protocole` ASC) , |
INDEX `fk_Vote_images_Images1` (`ce_image` ASC) , |
INDEX `fk_Vote_images_Utilisateurs1` (`ce_utilisateur` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
124,7 → 128,9 |
`ce_image` INT NULL , |
`ce_utilisateur` INT NULL , |
`md5` VARCHAR(32) NULL , |
PRIMARY KEY (`id_tag`) ) |
PRIMARY KEY (`id_tag`) , |
INDEX `fk_Tags_Vote_images1` (`ce_image` ASC) , |
INDEX `fk_Tags_Utilisateurs1` (`ce_utilisateur` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
137,11 → 143,16 |
|
CREATE TABLE IF NOT EXISTS `del`.`del_proposition` ( |
`id_proposition` INT NOT NULL , |
`nom_sci` VARCHAR(45) NULL , |
`ce_utilisateur` VARCHAR(45) NULL , |
`nom_sel` VARCHAR(255) NULL COMMENT 'Nom scientifique sélectionné\n' , |
`nom_sel_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique selectionné\n' , |
`nom_ret` VARCHAR(255) NULL COMMENT 'Nom scientifique retenu\n' , |
`nom_ret_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique retenu\n' , |
`nt` INT NULL COMMENT 'Numéro taxonomique\n' , |
`nom_referentiel` VARCHAR(45) NULL COMMENT 'Nom du référentiel utilisé (ex bdtfx_v1)\n' , |
`ce_utilisateur` VARCHAR(45) NULL COMMENT 'identifiant numérique de l\'utilisateur\n' , |
`ce_observation` INT NOT NULL , |
`nt` VARCHAR(45) NULL , |
PRIMARY KEY (`id_proposition`) ) |
PRIMARY KEY (`id_proposition`) , |
INDEX `fk_Propositions_Observations1` (`ce_observation` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
162,7 → 173,11 |
`utilisateur_prenom` VARCHAR(45) NULL , |
`utilisateur_mail` VARCHAR(45) NULL , |
`ce_observation` INT NULL , |
PRIMARY KEY (`id_commentaire`, `ce_proposition`) ) |
PRIMARY KEY (`id_commentaire`, `ce_proposition`) , |
INDEX `fk_Commentaires_Propositions1` (`ce_proposition` ASC) , |
INDEX `fk_Commentaires_Commentaires1` (`ce_commentaire` ASC) , |
INDEX `fk_Commentaires_Utilisateurs1` (`ce_utilisateur` ASC) , |
INDEX `fk_Commentaires_Observations1` (`ce_observation` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
179,7 → 194,9 |
`ce_utilisateur` INT NOT NULL , |
`valeur_vote` TINYINT(1) NULL , |
PRIMARY KEY (`id_vote_observations`) , |
UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) ) |
UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) , |
INDEX `fk_Vote_observations_Utilisateurs1` (`ce_utilisateur` ASC) , |
INDEX `fk_Vote_observations_Propositions1` (`ce_proposition` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
195,7 → 212,10 |
`ce_utilisateur` INT NOT NULL , |
`ce_observation` INT NOT NULL , |
`date_liaison` DATETIME NULL , |
PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) ) |
PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) , |
INDEX `fk_Obs_images_Images1` (`ce_image` ASC) , |
INDEX `fk_Obs_images_Utilisateurs1` (`ce_utilisateur` ASC) , |
INDEX `fk_Obs_images_Observations1` (`ce_observation` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |