tracker r2646 - in trunk: . data/db

[carlosg svn gnome org]

Author: carlosg
Date: Thu Dec  4 08:21:42 2008
New Revision: 2646
URL: http://svn.gnome.org/viewvc/tracker?rev=2646&view=rev

Log:
2008-12-04  Carlos Garnacho  <carlos imendio com>

        * data/db/sqlite-stored-procs.sql (DeleteServiceRecursively): Fix so
        it just deletes files contained in the directory.

Modified:
   trunk/ChangeLog
   trunk/data/db/sqlite-stored-procs.sql

Modified: trunk/data/db/sqlite-stored-procs.sql
==============================================================================
--- trunk/data/db/sqlite-stored-procs.sql	(original)
+++ trunk/data/db/sqlite-stored-procs.sql	Thu Dec  4 08:21:42 2008
@@ -46,7 +46,7 @@
 
 DeleteContent                  DELETE FROM ServiceContents WHERE ServiceID = ? AND MetadataId = ?;
 DeleteService1                 DELETE FROM Services WHERE ID = ?;
-DeleteServiceRecursively       DELETE FROM Services WHERE Path = ? OR Path LIKE ?;
+DeleteServiceRecursively       DELETE FROM Services WHERE Path = ? OR Path LIKE (? || '/%');
 DeleteServiceMetadata          DELETE FROM ServiceMetaData WHERE ServiceID = ?;
 DeleteServiceKeywordMetadata   DELETE FROM ServiceMetaData WHERE ServiceID = ?;
 DeleteServiceNumericMetadata   DELETE FROM ServiceMetaData WHERE ServiceID = ?;