OpenPNE のユーザーデータを使用して Digest認証

とりえあず View 定義の覚え書き。

groups

SELECT
  `c_commu`.`c_commu_id` + 200000 as `gid`,
  `c_commu`.`kuloak_gname` as `gname`,

  `c_member_secure`.`c_member_id` + 100000 as `uid`,
  `c_member_secure`.`pc_address` as `uname`

FROM `c_commu`
INNER JOIN `c_commu_member` ON `c_commu`.`c_commu_id` = `c_commu_member`.`c_commu_id`
INNER JOIN `c_member_secure` ON `c_commu_member`.`c_member_id` = `c_member_secure`.`c_member_id`;

users

SELECT
 `c_member_id` + 100000 as uid,
 `pc_address`  as uname
FROM `c_member_secure`;

うーん。