projects
/
fusionforge
/
fusionforge.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
project home
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
461af68
)
Fixed migration logic for tracker submission rights
author
Roland Mas
<lolando@debian.org>
Sun, 10 Jun 2012 15:38:57 +0000
(15:38 +0000)
committer
Roland Mas
<lolando@debian.org>
Sun, 10 Jun 2012 15:38:57 +0000
(15:38 +0000)
src/db/20120605-drop-obsolete.sql
patch
|
blob
|
history
diff --git
a/src/db/20120605-drop-obsolete.sql
b/src/db/20120605-drop-obsolete.sql
index 8bd9fbf209ce43369f08c3f0190002a54dc5586f..8431a8ec4a0266a89a063b5f87d2b7b14db03651 100644
(file)
--- a/
src/db/20120605-drop-obsolete.sql
+++ b/
src/db/20120605-drop-obsolete.sql
@@
-21,7
+21,7
@@
BEGIN
FOR agl IN SELECT * FROM artifact_group_list WHERE allow_anon = 1
LOOP
tid = agl.group_artifact_id ;
- UPDATE pfo_role_setting SET perm_val = perm_val|8 WHERE perm_val > 0 AND role_id = 1 AND
(section_name = 'tracker' OR section_name = 'new_tracker')
;
+ UPDATE pfo_role_setting SET perm_val = perm_val|8 WHERE perm_val > 0 AND role_id = 1 AND
section_name = 'tracker' AND ref_id = tid
;
END LOOP ;
RETURN 0;
END ;