Index: search.sql =================================================================== --- search.sql (revision 668) +++ search.sql (revision 669) @@ -13,7 +13,8 @@ object_class text not null, name text, search text, - data text + data text, + UNIQUE(object_id, object_class) ); -create index search_object on search (object_class, object_id); +create UNIQUE index search_object on search (object_class, object_id); create index search_mtime on search (mtime);