| [vhffs-dev] [744] Add something to fixes groups state |
[ Thread Index |
Date Index
| More vhffs.org/vhffs-dev Archives
]
Revision: 744
Author: gradator
Date: 2007-08-01 20:33:05 +0000 (Wed, 01 Aug 2007)
Log Message:
-----------
Add something to fixes groups state
Modified Paths:
--------------
trunk/vhffs-compat/4.0.sql.in
Modified: trunk/vhffs-compat/4.0.sql.in
===================================================================
--- trunk/vhffs-compat/4.0.sql.in 2007-08-01 19:29:17 UTC (rev 743)
+++ trunk/vhffs-compat/4.0.sql.in 2007-08-01 20:33:05 UTC (rev 744)
@@ -322,3 +322,7 @@
-- vhffs_ml
ALTER TABLE vhffs_ml ALTER admin SET NOT NULL;
+
+-- main groups of users don't use anymore a stupid state to be hidden from user groups
+UPDATE vhffs_object SET state=6 WHERE vhffs_object.state=1 AND vhffs_object.object_id IN (SELECT g.object_id FROM vhffs_groups g, vhffs_users u WHERE u.gid=g.gid);
+