[Gforge-commits] gforge/db 20040914.sql,1.1,1.2

[tperdue]

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

Modified Files:
        20040914.sql 
Log Message:
initial commit of stored procs to add counters to taskman

Index: 20040914.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20040914.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 20040914.sql        15 Sep 2004 04:49:53 -0000      1.1
+++ 20040914.sql        15 Sep 2004 04:54:52 -0000      1.2
@@ -4,6 +4,8 @@
         open_count integer DEFAULT 0
 );
 
+CREATE VIEW project_group_list_vw AS SELECT * FROM project_group_list NATURAL 
JOIN project_counts_agg;
+
 INSERT INTO project_counts_agg 
        SELECT group_project_id, 
        (SELECT count(*) FROM project_task WHERE status_id != 3 AND