[Gforge-commits] gforge/db 20040729.sql, 1.2, 1.3 gforge.sql, NONE, 1.1 gforge3.sql, 1.14, NONE

[tperdue]

Update of /cvsroot/gforge/gforge/db
In directory db.perdue.net:/home/tperdue/share/release.gforge.org/db

Modified Files:
        20040729.sql 
Added Files:
        gforge.sql 
Removed Files:
        gforge3.sql 
Log Message:


Index: 20040729.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20040729.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- 20040729.sql        29 Sep 2004 17:36:46 -0000      1.2
+++ 20040729.sql        23 Oct 2004 02:01:29 -0000      1.3
@@ -1,5 +1,18 @@
+--
+--
+--     WARNING - modifying on 10-22-2004 since the 0729 version was incomplete
+--
+--
+
+
+INSERT INTO plugins (plugin_name,plugin_desc) values 
+       ('scmcvs','CVS Plugin');
+
 -- 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,plugin_id FROM groups,plugins 
-       WHERE use_scm=1 AND group_id NOT IN (SELECT group_id 
-       FROM group_plugin) AND plugin_name='scmcvs');
+       (SELECT group_id,(SELECT plugin_id FROM plugins WHERE 
plugin_name='scmcvs') 
+       FROM groups
+       WHERE status != 'P');

--- NEW FILE: gforge.sql ---

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

SET search_path = public, pg_catalog;


CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;



CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;



REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;
[...7677 lines suppressed...]

SELECT pg_catalog.setval('forum_perm_id_seq', 1, false);



SELECT pg_catalog.setval('artifact_group_selection_box_list_id_seq', 100, true);



SELECT pg_catalog.setval('artifact_group_selection_box_options_id_seq', 100, 
true);



SELECT pg_catalog.setval('artifact_extra_field_data_id_seq', 100, true);



COMMENT ON SCHEMA public IS 'Standard public schema';



--- gforge3.sql DELETED ---