Subversion Repositories eFlore/Applications.del

Rev

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

Rev 1032 Rev 1246
Line 1... Line 1...
1 
-- -----------------------------------------------------
 1 
-- -----------------------------------------------------
2 
-- Placeholder table for view `del_utilisateur`
 2 
-- Placeholder table for view `del_utilisateur`
3 
-- -----------------------------------------------------
 3 
-- -----------------------------------------------------
4 
CREATE TABLE IF NOT EXISTS `del_utilisateur` (`id_utilisateur` INT, `prenom` INT, `nom` INT, `courriel` INT, `mot_de_passe` INT);
 4 
CREATE TABLE IF NOT EXISTS `del_utilisateur` (`id_utilisateur` VARCHAR, `prenom` INT, `nom` INT, `courriel` INT, `mot_de_passe` INT);
Line 5... Line 5...
5 
 
 5 
 
6 
-- -----------------------------------------------------
 6 
-- -----------------------------------------------------
7 
-- Placeholder table for view `del_observation`
 7 
-- Placeholder table for view `del_observation`
8 
-- -----------------------------------------------------
 8 
-- -----------------------------------------------------
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 ALGORITHM=MERGE VIEW del_utilisateur AS
27 
CREATE  OR REPLACE ALGORITHM=MERGE VIEW del_utilisateur AS
28 
	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
28 
	SELECT CAST(at.U_ID AS CHAR) 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
29 
	FROM tb_cel.cel_utilisateurs_infos AS ui
29 
	FROM tb_cel.cel_utilisateurs_infos AS ui
30 
		LEFT JOIN tela_prod_v4.annuaire_tela AS at ON (ui.id_utilisateur = at.U_ID);
 30 
		LEFT JOIN tela_prod_v4.annuaire_tela AS at ON (ui.id_utilisateur = at.U_ID);
31 
$$
 31 
$$
32 
DELIMITER ;
 32 
DELIMITER ;