Subversion Repositories eFlore/Applications.del

Compare Revisions

No changes between revisions

Ignore whitespace Rev 1267 → Rev 1268

/trunk/doc/bdd/sql/del.sql
23,7 → 23,7
DROP TABLE IF EXISTS `del_utilisateur` ;
 
CREATE TABLE IF NOT EXISTS `del_utilisateur` (
`id_utilisateur` BIGINT NOT NULL AUTO_INCREMENT COMMENT ' ' ,
`id_utilisateur` VARCHAR(20) NOT NULL COMMENT 'Type varchar pour éviter problème de jointure.' ,
`prenom` VARCHAR(255) NOT NULL ,
`nom` VARCHAR(255) NOT NULL ,
`courriel` VARCHAR(255) NOT NULL ,
237,7 → 237,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 ;
/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 ;
/trunk/doc/bdd/schema_bdd_del.mwb
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/doc/bdd/schema_bdd_del.pdf
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream