[Gforge-commits] gforge/db 20040804.sql,1.2,1.3

[tperdue]

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

Modified Files:
        20040804.sql 
Log Message:
fixing potential bug in upgrade SQL

Index: 20040804.sql
===================================================================
RCS file: /cvsroot/gforge/gforge/db/20040804.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- 20040804.sql        12 Sep 2004 23:00:57 -0000      1.2
+++ 20040804.sql        9 Dec 2004 19:06:36 -0000       1.3
@@ -78,6 +78,7 @@
 --
 --     Add to all trackers
 --
+update user_group set artifact_flags=0 where artifact_flags is null;
 INSERT INTO artifact_perm (group_artifact_id,user_id,perm_level) 
        SELECT 
artifact_group_list.group_artifact_id,user_group.user_id,user_group.artifact_flags
        FROM user_group,artifact_group_list