Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1267 Rev 1268
Line 23... Line 23...
23 
-- -----------------------------------------------------
 23 
-- -----------------------------------------------------
24 
DROP VIEW IF EXISTS `del_utilisateur` ;
 24 
DROP VIEW IF EXISTS `del_utilisateur` ;
25 
DROP TABLE IF EXISTS `del_utilisateur`;
 25 
DROP TABLE IF EXISTS `del_utilisateur`;
26 
DELIMITER $$
 26 
DELIMITER $$
27 
CREATE  OR REPLACE VIEW del_utilisateur AS
27 
CREATE  OR REPLACE VIEW del_utilisateur AS
28 
	SELECT U_ID AS id_utilisateur, U_SURNAME AS prenom, U_NAME AS nom, U_MAIL AS courriel, U_PASSWD AS mot_de_passe
28 
	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
29 
	FROM tela_prod_v4.annuaire_tela;
 29 
	FROM tela_prod_v4.annuaire_tela;
30 
$$
 30 
$$
31 
DELIMITER ;
 31 
DELIMITER ;
Line 32... Line 32...
32 
 
 32