Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 1185 Rev 1191
Line 20... Line 20...
20 
  PRIMARY KEY (`id_utilisateur`) )
 20 
  PRIMARY KEY (`id_utilisateur`) )
21 
ENGINE = MyISAM
 21 
ENGINE = MyISAM
22 
DEFAULT CHARACTER SET = utf8
 22 
DEFAULT CHARACTER SET = utf8
23 
COLLATE = utf8_general_ci;
 23 
COLLATE = utf8_general_ci;
Line -... Line 24...
- 
 
 24 
 
- 
 
 25 
-- -----------------------------------------------------
- 
 
 26 
-- Table `cel_utilisateurs_infos`
- 
 
 27 
-- -----------------------------------------------------
- 
 
 28 
DROP TABLE IF EXISTS `cel_utilisateurs_infos` ;
- 
 
 29 
 
- 
 
 30 
CREATE  TABLE IF NOT EXISTS `cel_utilisateurs_infos` (
- 
 
 31 
  `id_utilisateur` INT NOT NULL ,
- 
 
 32 
  `admin` TINYINT(1) NOT NULL DEFAULT 0 ,
- 
 
 33 
  `licence_acceptee` TINYINT(1) NOT NULL DEFAULT 0 ,
- 
 
 34 
  `preferences` LONGTEXT NULL ,
- 
 
 35 
  PRIMARY KEY (`id_utilisateur`) )
- 
 
 36 
ENGINE = MyISAM
- 
 
 37 
DEFAULT CHARACTER SET = utf8
- 
 
 38 
COLLATE = utf8_general_ci
- 
 
 39 
COMMENT = 'Contient les infos utilisateurs spécifiques au CEL.\nA utilis' /* comment truncated */;
- 
 
 40 
 
- 
 
 41 
 
- 
 
 42 
-- -----------------------------------------------------
- 
 
 43 
-- View `cel_utilisateurs`
- 
 
 44 
-- -----------------------------------------------------
- 
 
 45 
DROP VIEW IF EXISTS `cel_utilisateurs` ;
- 
 
 46 
DROP TABLE IF EXISTS `cel_utilisateurs`;
- 
 
 47 
CREATE  OR REPLACE VIEW `cel_utilisateurs` AS
- 
 
 48 
	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,
- 
 
 49 
		ui.licence_acceptee, ui.admin, ui.preferences
- 
 
 50 
	FROM cel_utilisateurs_infos AS ui
Line 24... Line 51...
24 
 
 51 
		LEFT JOIN tela_prod_v4.annuaire_tela AS at ON (ui.id_utilisateur = at.U_ID);
25 
 
 52 
 
26 
-- -----------------------------------------------------
 53 
-- -----------------------------------------------------
27 
-- Table `cel_obs_images`
 54 
-- Table `cel_obs_images`
Line 220... Line 247...
220 
  INDEX `date_observation` (`date_observation` ASC) )
 247 
  INDEX `date_observation` (`date_observation` ASC) )
221 
ENGINE = MyISAM
 248 
ENGINE = MyISAM
222 
DEFAULT CHARACTER SET = utf8
 249 
DEFAULT CHARACTER SET = utf8
223 
COLLATE = utf8_general_ci;
 250 
COLLATE = utf8_general_ci;
Line 224... Line -...
224 
 
 - 
 
225 
 
 - 
 
226 
 
 251 
 
227 
SET SQL_MODE=@OLD_SQL_MODE;
 252 
SET SQL_MODE=@OLD_SQL_MODE;
228 
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
 253 
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;