4 * Copyright 2011 Roland Mas
6 * This file is part of FusionForge. FusionForge is free software;
7 * you can redistribute it and/or modify it under the terms of the
8 * GNU General Public License as published by the Free Software
9 * Foundation; either version 2 of the Licence, or (at your option)
12 * FusionForge is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
17 * You should have received a copy of the GNU General Public License along
18 * with FusionForge; if not, write to the Free Software Foundation, Inc.,
19 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
22 require (dirname(__FILE__).'/../www/env.inc.php');
23 require_once $gfcommon.'include/pre.php';
25 $res=db_query_params('CREATE FUNCTION upgrade_default_role_to_admin () RETURNS void AS $$
29 FOR g IN SELECT * FROM groups
31 UPDATE user_group SET role_id=(
33 FROM role r JOIN role_setting rs USING (role_id)
34 WHERE r.group_id=g.group_id
35 AND rs.section_name=\'projectadmin\'
39 AND group_id=g.group_id;
43 $$ LANGUAGE plpgsql', array());
45 $res=db_query_params('SELECT upgrade_default_role_to_admin()', array());
47 $res=db_query_params('DROP FUNCTION upgrade_default_role_to_admin()', array());