projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge commit 'origin/master' into fusionax
[platal.git]
/
upgrade
/
0.9.11
/
03_xnet.sql
diff --git
a/upgrade/0.9.11/03_xnet.sql
b/upgrade/0.9.11/03_xnet.sql
index
fad1950
..
6d269c5
100644
(file)
--- a/
upgrade/0.9.11/03_xnet.sql
+++ b/
upgrade/0.9.11/03_xnet.sql
@@
-1,5
+1,11
@@
use groupex
alter table evenements drop column advertise;
alter table evenements drop column membres_only;
use groupex
alter table evenements drop column advertise;
alter table evenements drop column membres_only;
+alter table membres add column sexe bool default null;
+
+INSERT IGNORE INTO membres (uid, asso_id)
+ SELECT u.user_id AS uid, g.id AS asso_id
+ FROM x4dat.auth_user_md5 AS u
+ INNER JOIN asso AS g ON (g.diminutif LIKE u.promo);
use x4dat
use x4dat