Subversion Repositories eFlore/Applications.del

Rev

Rev 694 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 694 Rev 695
Line 1... Line 1...
1 
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
 1 
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2 
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
 2 
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3 
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
 3 
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
Line 4... Line -...
4 
 
 - 
 
5 
DROP SCHEMA IF EXISTS `del` ;
 4 
 
6 
CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
 5 
CREATE SCHEMA IF NOT EXISTS `del` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
Line 7... Line 6...
7 
USE `del` ;
 6 
USE `del` ;
8 
 
 7 
 
Line 40... Line 39...
40 
  `nom_original` VARCHAR(255) NULL ,
 39 
  `nom_original` VARCHAR(255) NULL ,
41 
  `date_modification` DATETIME NULL ,
 40 
  `date_modification` DATETIME NULL ,
42 
  `date_creation` DATETIME NULL ,
 41 
  `date_creation` DATETIME NULL ,
43 
  `publiable_eflore` TINYINT(1) NULL ,
 42 
  `publiable_eflore` TINYINT(1) NULL ,
44 
  PRIMARY KEY (`id_image`) ,
 43 
  PRIMARY KEY (`id_image`) ,
45 
  UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) )
 44 
  UNIQUE INDEX `id_image_UNIQUE` (`id_image` ASC) ,
- 
 
 45 
  INDEX `fk_Images_Utilisateurs1` (`ce_utilisateur` ASC) )
46 
ENGINE = MyISAM
 46 
ENGINE = MyISAM
47 
DEFAULT CHARACTER SET = utf8
 47 
DEFAULT CHARACTER SET = utf8
48 
COLLATE = utf8_general_ci;
 48 
COLLATE = utf8_general_ci;
Line 72... Line 72...
72 
  `commentaire` TEXT NULL ,
 72 
  `commentaire` TEXT NULL ,
73 
  `transmission` TINYINT(1) NULL ,
 73 
  `transmission` TINYINT(1) NULL ,
74 
  `date_creation` DATETIME NULL ,
 74 
  `date_creation` DATETIME NULL ,
75 
  `date_modification` DATETIME NULL ,
 75 
  `date_modification` DATETIME NULL ,
76 
  `date_transmission` DATETIME NULL ,
 76 
  `date_transmission` DATETIME NULL ,
77 
  PRIMARY KEY (`id_observation`) )
 77 
  PRIMARY KEY (`id_observation`) ,
- 
 
 78 
  INDEX `fk_Observations_Utilisateurs1` (`ce_utilisateur` ASC) )
78 
ENGINE = MyISAM
 79 
ENGINE = MyISAM
79 
DEFAULT CHARACTER SET = utf8
 80 
DEFAULT CHARACTER SET = utf8
80 
COLLATE = utf8_general_ci;
 81 
COLLATE = utf8_general_ci;
Line 105... Line 106...
105 
  `ce_image` INT NOT NULL ,
 106 
  `ce_image` INT NOT NULL ,
106 
  `ce_utilisateur` INT NOT NULL ,
 107 
  `ce_utilisateur` INT NOT NULL ,
107 
  `ce_protocole` INT NOT NULL ,
 108 
  `ce_protocole` INT NOT NULL ,
108 
  `valeur_vote` TINYINT(1) NULL ,
 109 
  `valeur_vote` TINYINT(1) NULL ,
109 
  PRIMARY KEY (`id_vote_image`) ,
 110 
  PRIMARY KEY (`id_vote_image`) ,
110 
  UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) )
 111 
  UNIQUE INDEX `ID_UNIQUE` (`id_vote_image` ASC) ,
- 
 
 112 
  INDEX `fk_Vote_images_Protocoles` (`ce_protocole` ASC) ,
- 
 
 113 
  INDEX `fk_Vote_images_Images1` (`ce_image` ASC) ,
- 
 
 114 
  INDEX `fk_Vote_images_Utilisateurs1` (`ce_utilisateur` ASC) )
111 
ENGINE = MyISAM
 115 
ENGINE = MyISAM
112 
DEFAULT CHARACTER SET = utf8
 116 
DEFAULT CHARACTER SET = utf8
113 
COLLATE = utf8_general_ci;
 117 
COLLATE = utf8_general_ci;
Line 122... Line 126...
122 
  `id_tag` INT NOT NULL ,
 126 
  `id_tag` INT NOT NULL ,
123 
  `tag` VARCHAR(45) NULL ,
 127 
  `tag` VARCHAR(45) NULL ,
124 
  `ce_image` INT NULL ,
 128 
  `ce_image` INT NULL ,
125 
  `ce_utilisateur` INT NULL ,
 129 
  `ce_utilisateur` INT NULL ,
126 
  `md5` VARCHAR(32) NULL ,
 130 
  `md5` VARCHAR(32) NULL ,
127 
  PRIMARY KEY (`id_tag`) )
 131 
  PRIMARY KEY (`id_tag`) ,
- 
 
 132 
  INDEX `fk_Tags_Vote_images1` (`ce_image` ASC) ,
- 
 
 133 
  INDEX `fk_Tags_Utilisateurs1` (`ce_utilisateur` ASC) )
128 
ENGINE = MyISAM
 134 
ENGINE = MyISAM
129 
DEFAULT CHARACTER SET = utf8
 135 
DEFAULT CHARACTER SET = utf8
130 
COLLATE = utf8_general_ci;
 136 
COLLATE = utf8_general_ci;
Line 135... Line 141...
135 
-- -----------------------------------------------------
 141 
-- -----------------------------------------------------
136 
DROP TABLE IF EXISTS `del`.`del_proposition` ;
 142 
DROP TABLE IF EXISTS `del`.`del_proposition` ;
Line 137... Line 143...
137 
 
 143 
 
138 
CREATE  TABLE IF NOT EXISTS `del`.`del_proposition` (
 144 
CREATE  TABLE IF NOT EXISTS `del`.`del_proposition` (
- 
 
 145 
  `id_proposition` INT NOT NULL ,
- 
 
 146 
  `nom_sel` VARCHAR(255) NULL COMMENT 'Nom scientifique sélectionné\n' ,
139 
  `id_proposition` INT NOT NULL ,
 147 
  `nom_sel_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique selectionné\n' ,
- 
 
 148 
  `nom_ret` VARCHAR(255) NULL COMMENT 'Nom scientifique retenu\n' ,
- 
 
 149 
  `nom_ret_nn` INT NULL COMMENT 'Numéro nomenclatural du nom scientifique retenu\n' ,
- 
 
 150 
  `nt` INT NULL COMMENT 'Numéro taxonomique\n' ,
140 
  `nom_sci` VARCHAR(45) NULL ,
 151 
  `nom_referentiel` VARCHAR(45) NULL COMMENT 'Nom du référentiel utilisé (ex bdtfx_v1)\n' ,
141 
  `ce_utilisateur` VARCHAR(45) NULL ,
 152 
  `ce_utilisateur` VARCHAR(45) NULL COMMENT 'identifiant numérique de l\'utilisateur\n' ,
142 
  `ce_observation` INT NOT NULL ,
 - 
 
143 
  `nt` VARCHAR(45) NULL ,
 153 
  `ce_observation` INT NOT NULL ,
- 
 
 154 
  PRIMARY KEY (`id_proposition`) ,
144 
  PRIMARY KEY (`id_proposition`) )
 155 
  INDEX `fk_Propositions_Observations1` (`ce_observation` ASC) )
145 
ENGINE = MyISAM
 156 
ENGINE = MyISAM
146 
DEFAULT CHARACTER SET = utf8
 157 
DEFAULT CHARACTER SET = utf8
Line 160... Line 171...
160 
  `ce_commentaire` INT NULL ,
 171 
  `ce_commentaire` INT NULL ,
161 
  `utilisateur_nom` VARCHAR(45) NULL ,
 172 
  `utilisateur_nom` VARCHAR(45) NULL ,
162 
  `utilisateur_prenom` VARCHAR(45) NULL ,
 173 
  `utilisateur_prenom` VARCHAR(45) NULL ,
163 
  `utilisateur_mail` VARCHAR(45) NULL ,
 174 
  `utilisateur_mail` VARCHAR(45) NULL ,
164 
  `ce_observation` INT NULL ,
 175 
  `ce_observation` INT NULL ,
165 
  PRIMARY KEY (`id_commentaire`, `ce_proposition`) )
 176 
  PRIMARY KEY (`id_commentaire`, `ce_proposition`) ,
- 
 
 177 
  INDEX `fk_Commentaires_Propositions1` (`ce_proposition` ASC) ,
- 
 
 178 
  INDEX `fk_Commentaires_Commentaires1` (`ce_commentaire` ASC) ,
- 
 
 179 
  INDEX `fk_Commentaires_Utilisateurs1` (`ce_utilisateur` ASC) ,
- 
 
 180 
  INDEX `fk_Commentaires_Observations1` (`ce_observation` ASC) )
166 
ENGINE = MyISAM
 181 
ENGINE = MyISAM
167 
DEFAULT CHARACTER SET = utf8
 182 
DEFAULT CHARACTER SET = utf8
168 
COLLATE = utf8_general_ci;
 183 
COLLATE = utf8_general_ci;
Line 177... Line 192...
177 
  `id_vote_observations` INT NOT NULL ,
 192 
  `id_vote_observations` INT NOT NULL ,
178 
  `ce_proposition` INT NOT NULL ,
 193 
  `ce_proposition` INT NOT NULL ,
179 
  `ce_utilisateur` INT NOT NULL ,
 194 
  `ce_utilisateur` INT NOT NULL ,
180 
  `valeur_vote` TINYINT(1) NULL ,
 195 
  `valeur_vote` TINYINT(1) NULL ,
181 
  PRIMARY KEY (`id_vote_observations`) ,
 196 
  PRIMARY KEY (`id_vote_observations`) ,
182 
  UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) )
 197 
  UNIQUE INDEX `ID_UNIQUE` (`id_vote_observations` ASC) ,
- 
 
 198 
  INDEX `fk_Vote_observations_Utilisateurs1` (`ce_utilisateur` ASC) ,
- 
 
 199 
  INDEX `fk_Vote_observations_Propositions1` (`ce_proposition` ASC) )
183 
ENGINE = MyISAM
 200 
ENGINE = MyISAM
184 
DEFAULT CHARACTER SET = utf8
 201 
DEFAULT CHARACTER SET = utf8
185 
COLLATE = utf8_general_ci;
 202 
COLLATE = utf8_general_ci;
Line 193... Line 210...
193 
CREATE  TABLE IF NOT EXISTS `del`.`del_obs_image` (
 210 
CREATE  TABLE IF NOT EXISTS `del`.`del_obs_image` (
194 
  `ce_image` INT NOT NULL ,
 211 
  `ce_image` INT NOT NULL ,
195 
  `ce_utilisateur` INT NOT NULL ,
 212 
  `ce_utilisateur` INT NOT NULL ,
196 
  `ce_observation` INT NOT NULL ,
 213 
  `ce_observation` INT NOT NULL ,
197 
  `date_liaison` DATETIME NULL ,
 214 
  `date_liaison` DATETIME NULL ,
198 
  PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) )
 215 
  PRIMARY KEY (`ce_image`, `ce_observation`, `ce_utilisateur`) ,
- 
 
 216 
  INDEX `fk_Obs_images_Images1` (`ce_image` ASC) ,
- 
 
 217 
  INDEX `fk_Obs_images_Utilisateurs1` (`ce_utilisateur` ASC) ,
- 
 
 218 
  INDEX `fk_Obs_images_Observations1` (`ce_observation` ASC) )
199 
ENGINE = MyISAM
 219 
ENGINE = MyISAM
200 
DEFAULT CHARACTER SET = utf8
 220 
DEFAULT CHARACTER SET = utf8
201 
COLLATE = utf8_general_ci;
 221 
COLLATE = utf8_general_ci;