New file |
0,0 → 1,207 |
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; |
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` ; |
|
-- ----------------------------------------------------- |
-- Table `del`.`Utilisateurs` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Utilisateurs` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Utilisateurs` ( |
`id_utilisateur` INT NOT NULL COMMENT ' ' , |
`prenom` VARCHAR(45) NULL , |
`nom` VARCHAR(45) NULL , |
`courriel` VARCHAR(45) NULL , |
`mot_de_passe` VARCHAR(45) NULL , |
`licence_acceptee` VARCHAR(45) NULL , |
PRIMARY KEY (`id_utilisateur`) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Images` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Images` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Images` ( |
`id_image` BIGINT NOT NULL , |
`ce_utilisateur` VARCHAR(32) NOT NULL , |
`hauteur` INT NULL , |
`largeur` INT NULL , |
`date_prise_de_vue` DATETIME NULL , |
`mots_cles_texte` LONGTEXT NULL , |
`commentaire` LONGTEXT NULL , |
`nom_original` VARCHAR(255) NULL , |
`date_modification` DATETIME NULL , |
`date_creation` DATETIME NULL , |
`publiable_eflore` TINYINT(1) NULL , |
PRIMARY KEY (`id_image`) , |
UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Observations` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Observations` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Observations` ( |
`id_observation` INT NOT NULL , |
`ce_utilisateur` INT NULL , |
`nom_sel` VARCHAR(255) NULL , |
`nom_sel_nn` INT(11) NULL , |
`nom_ret` VARCHAR(255) NULL , |
`nom_ret_nn` INT(11) NULL , |
`nt` INT(11) NULL , |
`famille` VARCHAR(255) NULL , |
`ce_zone_geo` VARCHAR(50) NULL , |
`zone_geo` VARCHAR(255) NULL , |
`lieudit` VARCHAR(255) NULL , |
`station` VARCHAR(255) NULL , |
`milieu` VARCHAR(255) NULL , |
`date_observation` DATETIME NULL , |
`mots_cles_texte` LONGTEXT NULL , |
`commentaire` TEXT NULL , |
`transmission` TINYINT(1) NULL , |
`date_creation` DATETIME NULL , |
`date_modification` DATETIME NULL , |
`date_transmission` DATETIME NULL , |
PRIMARY KEY (`id_observation`) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Protocoles` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Protocoles` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Protocoles` ( |
`id_protocole` INT NOT NULL , |
`intitule` VARCHAR(255) NULL , |
`descriptif` VARCHAR(255) NULL , |
PRIMARY KEY (`id_protocole`) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Vote_images` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Vote_images` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Vote_images` ( |
`id_vote_image` INT NOT NULL , |
`ce_image` INT NOT NULL , |
`ce_utilisateur` INT NOT NULL , |
`ce_protocole` INT NOT NULL , |
`valeur_vote` TINYINT(1) NULL , |
PRIMARY KEY (`id_vote_image`) , |
UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Tags` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Tags` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Tags` ( |
`id_tag` INT NOT NULL , |
`tag` VARCHAR(45) NULL , |
`ce_image` INT NULL , |
`ce_utilisateur` INT NULL , |
`md5` VARCHAR(32) NULL , |
PRIMARY KEY (`id_tag`) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Propositions` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Propositions` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Propositions` ( |
`id_proposition` INT NOT NULL , |
`nom_sci` VARCHAR(45) NULL , |
`ce_utilisateur` VARCHAR(45) NULL , |
`ce_observation` INT NOT NULL , |
`nt` VARCHAR(45) NULL , |
PRIMARY KEY (`id_proposition`) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Commentaires` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Commentaires` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Commentaires` ( |
`id_commentaire` INT NOT NULL , |
`texte` VARCHAR(45) NULL , |
`ce_utilisateur` INT NULL , |
`ce_proposition` INT NOT NULL , |
`ce_commentaire` INT NULL , |
`utilisateur_nom` VARCHAR(45) NULL , |
`utilisateur_prenom` VARCHAR(45) NULL , |
`utilisateur_mail` VARCHAR(45) NULL , |
`ce_observation` INT NULL , |
PRIMARY KEY (`id_commentaire`, `ce_proposition`) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Vote_observations` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Vote_observations` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Vote_observations` ( |
`id_vote_observations` INT NOT NULL , |
`ce_proposition` INT NOT NULL , |
`ce_utilisateur` INT NOT NULL , |
`valeur_vote` TINYINT(1) NULL , |
PRIMARY KEY (`id_vote_observations`) , |
UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
-- ----------------------------------------------------- |
-- Table `del`.`Obs_images` |
-- ----------------------------------------------------- |
DROP TABLE IF EXISTS `del`.`Obs_images` ; |
|
CREATE TABLE IF NOT EXISTS `del`.`Obs_images` ( |
`ce_image` INT NOT NULL , |
`ce_utilisateur` INT NOT NULL , |
`ce_observation` INT NOT NULL , |
`date_liaison` DATETIME NULL , |
PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) ) |
ENGINE = MyISAM |
DEFAULT CHARACTER SET = utf8 |
COLLATE = utf8_general_ci; |
|
|
|
SET SQL_MODE=@OLD_SQL_MODE; |
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |