projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge remote branch 'origin/xorg/f/geocoding' into xorg/master
[platal.git]
/
upgrade
/
newdirectory-0.0.1
/
10_promotion.sql
diff --git
a/upgrade/newdirectory-0.0.1/10_promotion.sql
b/upgrade/newdirectory-0.0.1/10_promotion.sql
index
de629b4
..
7dec54d
100644
(file)
--- a/
upgrade/newdirectory-0.0.1/10_promotion.sql
+++ b/
upgrade/newdirectory-0.0.1/10_promotion.sql
@@
-1,11
+1,11
@@
-INSERT INTO profile_education (id,
u
id, grad_year, entry_year, eduid, degreeid, flags)
+INSERT INTO profile_education (id,
p
id, grad_year, entry_year, eduid, degreeid, flags)
SELECT 100, u.user_id, u.promo_sortie, u.promo, e.id, d.id, 'primary'
SELECT 100, u.user_id, u.promo_sortie, u.promo, e.id, d.id, 'primary'
- FROM auth_user_md5 AS u
+ FROM
#x4dat#.
auth_user_md5 AS u
LEFT JOIN profile_education_enum AS e ON (e.abbreviation = "X")
LEFT JOIN profile_education_degree_enum AS d ON (d.degree = "Ingénieur");
UPDATE profile_display AS d
LEFT JOIN profile_education_enum AS e ON (e.abbreviation = "X")
LEFT JOIN profile_education_degree_enum AS d ON (d.degree = "Ingénieur");
UPDATE profile_display AS d
-INNER JOIN profile_education AS e ON (d.pid = e.
u
id)
+INNER JOIN profile_education AS e ON (d.pid = e.
p
id)
SET d.promo = CONCAT("X", entry_year)
WHERE FIND_IN_SET('primary', e.flags);
SET d.promo = CONCAT("X", entry_year)
WHERE FIND_IN_SET('primary', e.flags);