[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] gforge/db 20040914.sql,1.1,1.2
From: |
tperdue |
Subject: |
[Gforge-commits] gforge/db 20040914.sql,1.1,1.2 |
Date: |
Tue, 14 Sep 2004 23:54:55 -0500 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] gforge/db 20040914.sql,1.1,1.2,
tperdue <=