Revision 669

Date:
2017/11/28 14:14:54
Author:
ahitrov
Revision Log:
index on object id and class must be unique

Files:

Legend:

 
Added
 
Removed
 
Modified

  • utf8/plugins/sphinx/sql/TOAST/search.sql

     
    13 13 object_class text not null,
    14 14 name text,
    15 15 search text,
    16 data text
    16 data text,
    17 UNIQUE(object_id, object_class)
    17 18 );
    18 create index search_object on search (object_class, object_id);
    19 create UNIQUE index search_object on search (object_class, object_id);
    19 20 create index search_mtime on search (mtime);