Line 320... |
Line 320... |
320 |
DROP VIEW IF EXISTS `cel_utilisateurs` ;
|
320 |
DROP VIEW IF EXISTS `cel_utilisateurs` ;
|
321 |
DROP TABLE IF EXISTS `cel_utilisateurs`;
|
321 |
DROP TABLE IF EXISTS `cel_utilisateurs`;
|
322 |
CREATE OR REPLACE VIEW `cel_utilisateurs` AS
|
322 |
CREATE OR REPLACE VIEW `cel_utilisateurs` AS
|
323 |
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,
|
323 |
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,
|
324 |
ui.licence_acceptee, ui.admin, ui.preferences, ui.date_premiere_utilisation
|
324 |
ui.licence_acceptee, ui.admin, ui.preferences, ui.date_premiere_utilisation
|
325 |
FROM cel_utilisateurs_infos AS ui
|
325 |
FROM tela_prod_v4.annuaire_tela AS at
|
326 |
LEFT JOIN tela_prod_v4.annuaire_tela AS at ON (ui.id_utilisateur = at.U_ID);
|
326 |
LEFT JOIN cel_utilisateurs_infos AS ui ON (ui.id_utilisateur = at.U_ID);
|
Line 327... |
Line 327... |
327 |
|
327 |
|
328 |
-- -----------------------------------------------------
|
328 |
-- -----------------------------------------------------
|
329 |
-- View `cel_tapir`
|
329 |
-- View `cel_tapir`
|
330 |
-- -----------------------------------------------------
|
330 |
-- -----------------------------------------------------
|