Line 200... |
Line 200... |
200 |
CREATE TABLE IF NOT EXISTS `del_utilisateur_infos` (
|
200 |
CREATE TABLE IF NOT EXISTS `del_utilisateur_infos` (
|
201 |
`id_utilisateur` int(11) NOT NULL,
|
201 |
`id_utilisateur` int(11) NOT NULL,
|
202 |
`admin` tinyint(1) NOT NULL,
|
202 |
`admin` tinyint(1) NOT NULL,
|
203 |
`preferences` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
|
203 |
`preferences` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
|
204 |
`date_premiere_utilisation` datetime DEFAULT NULL,
|
204 |
`date_premiere_utilisation` datetime DEFAULT NULL,
|
205 |
PRIMARY KEY (`id_utilisateur`)
|
205 |
PRIMARY KEY (`id_utilisateur`)
|
206 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
206 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
Line -... |
Line 207... |
- |
|
207 |
|
- |
|
208 |
-- --------------------------------------------------------
|
- |
|
209 |
|
- |
|
210 |
--
|
- |
|
211 |
-- Structure de la vue `del_image`
|
- |
|
212 |
--
|
- |
|
213 |
DROP TABLE IF EXISTS `del_image`;
|
- |
|
214 |
|
- |
|
215 |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `del_image` AS select `i`.`id_image` AS `id_image`,`i`.`ce_utilisateur` AS `ce_utilisateur`,`i`.`hauteur` AS `hauteur`,`i`.`largeur` AS `largeur`,`i`.`date_prise_de_vue` AS `date_prise_de_vue`,`i`.`mots_cles_texte` AS `mots_cles_texte`,`i`.`commentaire` AS `commentaire`,`i`.`nom_original` AS `nom_original`,`i`.`date_modification` AS `date_modification`,`i`.`date_creation` AS `date_creation`,`i`.`publiable_eflore` AS `publiable_eflore` from (((`tb_cel`.`cel_images` `i` join `tb_cel`.`cel_obs_images` `oi` on((`i`.`id_image` = `oi`.`id_image`))) join `tb_cel`.`cel_obs` `o` on((`oi`.`id_observation` = `o`.`id_observation`))) join `tb_cel`.`cel_utilisateurs_infos` `u` on((`i`.`ce_utilisateur` = `u`.`id_utilisateur`))) where (`o`.`transmission` = '1');
|
- |
|
216 |
|
- |
|
217 |
-- --------------------------------------------------------
|
- |
|
218 |
|
- |
|
219 |
--
|
- |
|
220 |
-- Structure de la vue `del_observation`
|
- |
|
221 |
--
|
- |
|
222 |
DROP TABLE IF EXISTS `del_observation`;
|
- |
|
223 |
|
- |
|
224 |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `del_observation` AS select `o`.`id_observation` AS `id_observation`,`o`.`ce_utilisateur` AS `ce_utilisateur`,`o`.`nom_sel` AS `nom_sel`,`o`.`nom_sel_nn` AS `nom_sel_nn`,`o`.`nom_ret` AS `nom_ret`,`o`.`nom_ret_nn` AS `nom_ret_nn`,`o`.`nt` AS `nt`,`o`.`famille` AS `famille`,`o`.`ce_zone_geo` AS `ce_zone_geo`,`o`.`zone_geo` AS `zone_geo`,`o`.`lieudit` AS `lieudit`,`o`.`station` AS `station`,`o`.`milieu` AS `milieu`,`o`.`date_observation` AS `date_observation`,`o`.`mots_cles_texte` AS `mots_cles_texte`,`o`.`commentaire` AS `commentaire`,`o`.`date_creation` AS `date_creation`,`o`.`date_modification` AS `date_modification`,`o`.`date_transmission` AS `date_transmission` from ((`tb_cel`.`cel_obs` `o` join `tb_cel`.`cel_utilisateurs_infos` `u` on((`o`.`ce_utilisateur` = `u`.`id_utilisateur`))) join `tb_cel`.`cel_obs_images` `coi` on((`o`.`id_observation` = `coi`.`id_observation`))) where (`o`.`transmission` = '1');
|
- |
|
225 |
|
- |
|
226 |
-- --------------------------------------------------------
|
- |
|
227 |
|
- |
|
228 |
--
|
- |
|
229 |
-- Structure de la vue `del_obs_image`
|
- |
|
230 |
--
|
- |
|
231 |
DROP TABLE IF EXISTS `del_obs_image`;
|
- |
|
232 |
|
- |
|
233 |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `del_obs_image` AS select `oi`.`id_image` AS `id_image`,`oi`.`id_observation` AS `id_observation`,`oi`.`date_liaison` AS `date_liaison` from ((`tb_cel`.`cel_obs_images` `oi` join `tb_cel`.`cel_obs` `o` on((`oi`.`id_observation` = `o`.`id_observation`))) join `tb_cel`.`cel_utilisateurs_infos` `u` on((`o`.`ce_utilisateur` = `u`.`id_utilisateur`))) where (`o`.`transmission` = '1');
|
- |
|
234 |
|
- |
|
235 |
-- --------------------------------------------------------
|
- |
|
236 |
|
- |
|
237 |
--
|
- |
|
238 |
-- Structure de la vue `del_utilisateur`
|
- |
|
239 |
--
|
- |
|
240 |
DROP TABLE IF EXISTS `del_utilisateur`;
|
- |
|
241 |
|
Line 207... |
Line -... |
207 |
|
- |
|
208 |
|
- |
|
209 |
SET SQL_MODE=@OLD_SQL_MODE;
|
- |
|
210 |
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
|
242 |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `del_utilisateur` AS select `at`.`U_ID` AS `id_utilisateur`,`at`.`U_SURNAME` AS `prenom`,`at`.`U_NAME` AS `nom`,`at`.`U_MAIL` AS `courriel`,`at`.`U_PASSWD` AS `mot_de_passe` from (`tb_cel`.`cel_utilisateurs_infos` `ui` left join `tela_prod`.`annuaire_tela` `at` on((`ui`.`id_utilisateur` = `at`.`U_ID`)));
|
- |
|
243 |
|
- |
|
244 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
- |
|
245 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|