From 1d4cd49856ed0b498661b2e6c85381e5aa2d7741 Mon Sep 17 00:00:00 2001 From: Pascal Corpet Date: Thu, 10 Jun 2010 00:46:54 +0200 Subject: [PATCH] Create acocunts for ext in groups --- upgrade/account/30_xnet_groups.sql | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 upgrade/account/30_xnet_groups.sql diff --git a/upgrade/account/30_xnet_groups.sql b/upgrade/account/30_xnet_groups.sql new file mode 100644 index 0000000..8caaaf0 --- /dev/null +++ b/upgrade/account/30_xnet_groups.sql @@ -0,0 +1,35 @@ +# Create one account by email +INSERT INTO accounts ( + SELECT NULL AS uid, + CONCAT(LOWER(REPLACE(email,'@','.')),'.ext') AS hruid, + 'xnet' AS type, + 0 as is_admin, + 'disabled' AS state, + NULL as password, + NULL as token, + NULL as weak_password, + NULL as registration_date, + '' AS flags, + comm AS comment, + email, + CONCAT(prenom,' ',nom) AS full_name, + prenom AS display_name, + IF(sexe,'female','male') AS sex, + 'html' AS email_format, + 1 AS skin, + NULL as last_version + FROM group_members WHERE origine = 'ext' GROUP BY hruid); + +# Delete person that are several time in same asso +DELETE g2 + FROM group_members AS g1 + INNER JOIN group_members AS g2 ON (g1.asso_id = g2.asso_id AND g1.email = g2.email AND g1.uid < g2.uid) + WHERE g1.origine = 'ext' AND g2.origine = 'ext'; + +# Update uids +UPDATE group_members AS g, accounts AS a + SET g.uid = a.uid + WHERE g.origine = 'ext' AND + a.hruid = CONCAT(LOWER(REPLACE(g.email,'@','.')),'.ext'); + +# vim:set syntax=mysql: -- 2.1.4