[vhffs-dev] [740] Added single name -> complete path compat SQL for cvs and svn

[subversion@xxxxxxxxx]

Revision: 740
Author:   gradator
Date:     2007-07-31 23:21:38 +0000 (Tue, 31 Jul 2007)

Log Message:
-----------
Added single name -> complete path compat SQL for cvs and svn

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-07-31 00:00:31 UTC (rev 739)
+++ trunk/vhffs-compat/4.0.sql.in	2007-07-31 23:21:38 UTC (rev 740)
@@ -298,3 +298,9 @@
 ALTER TABLE vhffs_user_group ALTER uid SET NOT NULL;
 ALTER TABLE vhffs_user_group ALTER gid SET NOT NULL;
 ALTER TABLE vhffs_user_group ALTER state SET NOT NULL;
+
+-- change naming scheme of vhffs_svn (complete path instead single name)
+UPDATE vhffs_svn SET reponame=(SELECT (SELECT g.groupname FROM vhffs_groups g WHERE g.gid=(SELECT o.owner_gid FROM vhffs_object o WHERE o.object_id=s.object_id) )||'/'||s.reponame FROM vhffs_svn s WHERE s.svn_id=vhffs_svn.svn_id);
+
+-- change naming scheme of vhffs_cvs (complete path instead single name)
+UPDATE vhffs_cvs SET cvsroot=(SELECT (SELECT g.groupname FROM vhffs_groups g WHERE g.gid=(SELECT o.owner_gid FROM vhffs_object o WHERE o.object_id=c.object_id) )||'/'||c.cvsroot FROM vhffs_cvs c WHERE c.cvs_id=vhffs_cvs.cvs_id);