| /trunk/doc/bdd/sql/tela/tb_del_cel_vues.sql |
|---|
| 25,7 → 25,7 |
| DROP TABLE IF EXISTS `del_utilisateur`; |
| DELIMITER $$ |
| CREATE OR REPLACE VIEW del_utilisateur AS |
| SELECT U_ID AS id_utilisateur, U_SURNAME AS prenom, U_NAME AS nom, U_MAIL AS courriel, U_PASSWD AS mot_de_passe |
| SELECT CAST(U_ID AS CHAR) AS id_utilisateur, U_SURNAME AS prenom, U_NAME AS nom, U_MAIL AS courriel, U_PASSWD AS mot_de_passe |
| FROM tela_prod_v4.annuaire_tela; |
| $$ |
| DELIMITER ; |