/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 ; |