[Gforge-commits] gforge/db 20040729.sql, 1.3, NONE 20041022.sql, NONE, 1.1

[cbayle]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/tmp/cvs-serv12422

Added Files:
        20041022.sql 
Removed Files:
        20040729.sql 
Log Message:
don't take care of this bad commit


--- 20040729.sql DELETED ---

--- NEW FILE: 20041022.sql ---
--
--
--      WARNING - modifying on 10-22-2004 since the 0729 version was incomplete
--
--
-- Christian Bayle, finally renaming 0729 in 1022
-- Insert record in plugins table only if it doesn't already exists


INSERT INTO plugins (plugin_name,plugin_desc) (SELECT 'scmcvs','CVS Plugin' 
WHERE (SELECT count(*) FROM plugins WHERE plugin_name ='scmcvs')=0) ;

-- Subscribe groups that use SCM to scmcvs plugin
DELETE FROM group_plugin 
        WHERE plugin_id=(SELECT plugin_id FROM plugins WHERE 
plugin_name='scmcvs');

INSERT INTO group_plugin (group_id,plugin_id) 
        (SELECT group_id,(SELECT plugin_id FROM plugins WHERE 
plugin_name='scmcvs') 
        FROM groups
        WHERE status != 'P');