| 22,8 → 22,35 |
|---|
| DEFAULT CHARACTER SET = utf8 |
| COLLATE = utf8_general_ci; |
| |
| -- ----------------------------------------------------- |
| -- Table `cel_utilisateurs_infos` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `cel_utilisateurs_infos` ; |
| |
| CREATE TABLE IF NOT EXISTS `cel_utilisateurs_infos` ( |
| `id_utilisateur` INT NOT NULL , |
| `admin` TINYINT(1) NOT NULL DEFAULT 0 , |
| `licence_acceptee` TINYINT(1) NOT NULL DEFAULT 0 , |
| `preferences` LONGTEXT NULL , |
| PRIMARY KEY (`id_utilisateur`) ) |
| ENGINE = MyISAM |
| DEFAULT CHARACTER SET = utf8 |
| COLLATE = utf8_general_ci |
| COMMENT = 'Contient les infos utilisateurs spécifiques au CEL.\nA utilis' /* comment truncated */; |
| |
| |
| -- ----------------------------------------------------- |
| -- View `cel_utilisateurs` |
| -- ----------------------------------------------------- |
| DROP VIEW IF EXISTS `cel_utilisateurs` ; |
| DROP TABLE IF EXISTS `cel_utilisateurs`; |
| CREATE OR REPLACE VIEW `cel_utilisateurs` AS |
| 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, |
| ui.licence_acceptee, ui.admin, ui.preferences |
| FROM cel_utilisateurs_infos AS ui |
| LEFT JOIN tela_prod_v4.annuaire_tela AS at ON (ui.id_utilisateur = at.U_ID); |
| |
| -- ----------------------------------------------------- |
| -- Table `cel_obs_images` |
| -- ----------------------------------------------------- |
| DROP TABLE IF EXISTS `cel_obs_images` ; |
| 222,8 → 249,6 |
|---|
| DEFAULT CHARACTER SET = utf8 |
| COLLATE = utf8_general_ci; |
| |
| |
| |
| SET SQL_MODE=@OLD_SQL_MODE; |
| SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
| SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |