diff options
author | Jamie McCracken <jamiemcc@src.gnome.org> | 2006-07-30 07:31:08 +0000 |
---|---|---|
committer | Jamie McCracken <jamiemcc@src.gnome.org> | 2006-07-30 07:31:08 +0000 |
commit | 99e7a2a30236c58599772e9ae2f3d5c6256b4a95 (patch) | |
tree | 73b0434862514f80f887c341cd7b701a1cdc88b4 /data | |
parent | 1ac51943ae6b30b4154faafa951ca4ab95a61719 (diff) | |
download | tracker-99e7a2a30236c58599772e9ae2f3d5c6256b4a95.tar.gz |
bug fixes
Diffstat (limited to 'data')
-rw-r--r-- | data/mysql-stored-procs.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/data/mysql-stored-procs.sql b/data/mysql-stored-procs.sql index 0767ff5d3..60c753ddb 100644 --- a/data/mysql-stored-procs.sql +++ b/data/mysql-stored-procs.sql @@ -129,7 +129,7 @@ BEGIN PREPARE GET_FILE_MTIME FROM 'SELECT M.MetaDataNumericValue FROM Services F inner join ServiceMetaData M on F.ID = M.ServiceID WHERE F.Path = ? and F.Name = ? and M.MetaDataID = GetMetaDataTypeID(''File.Modified'') '; - PREPARE SEARCH_KEYWORDS FROM 'Select Concat(S.Path, \'/\', S.Name) as uri from Services S INNER JOIN ServiceKeywords K ON K.ServiceID = S.ID WHERE (S.ServiceTypeID between ? and ?) and K.Keyword = ? limit ?'; + PREPARE SEARCH_KEYWORDS FROM 'Select Concat(S.Path, ''/'', S.Name) as uri from Services S INNER JOIN ServiceKeywords K ON K.ServiceID = S.ID WHERE (S.ServiceTypeID between ? and ?) and K.Keyword = ? limit ?'; END| @@ -715,7 +715,7 @@ BEGIN SELECT CONCAT(pLocation, '/%') into pLocationLike; - SELECT DISTINCT F.Path, F.Name FROM Services F, ServiceMetaData M WHERE F.ID = M.ServiceID AND (F.Path like pLocationLike OR F.Path = pLocation) AND MATCH (M.MetaDataIndexValue) AGAINST (pText IN BOOLEAN MODE) AND (F.ServiceTypeID between 0 and 4) LIMIT 512; + SELECT DISTINCT F.Path, F.Name FROM Services F, ServiceMetaData M WHERE F.ID = M.ServiceID AND (F.Path like pLocationLike OR F.Path = pLocation) AND MATCH (M.MetaDataIndexValue) AGAINST (pText IN BOOLEAN MODE) AND (F.ServiceTypeID between 0 and 8) LIMIT 512; END| @@ -728,7 +728,7 @@ BEGIN SELECT CONCAT(pLocation, '/%') into pLocationLike; - SELECT DISTINCT F.Path, F.Name FROM Services F, ServiceMetaData M, ServiceMetaData M2 WHERE F.ID = M.ServiceID AND F.ID = M2.ServiceID AND (F.Path like pLocationLike OR F.Path = pLocation) AND MATCH (M.MetaDataIndexValue) AGAINST (pText IN BOOLEAN MODE) AND (F.ServiceTypeID between 0 and 4) AND M2.MetaDataID = (SELECT ID FROM MetaDataTypes WHERE MetaName = 'File.Format') AND FIND_IN_SET(M2.MetaDataIndexValue, pMimes) LIMIT 512; + SELECT DISTINCT F.Path, F.Name FROM Services F, ServiceMetaData M, ServiceMetaData M2 WHERE F.ID = M.ServiceID AND F.ID = M2.ServiceID AND (F.Path like pLocationLike OR F.Path = pLocation) AND MATCH (M.MetaDataIndexValue) AGAINST (pText IN BOOLEAN MODE) AND (F.ServiceTypeID between 0 and 8) AND M2.MetaDataID = (SELECT ID FROM MetaDataTypes WHERE MetaName = 'File.Format') AND FIND_IN_SET(M2.MetaDataIndexValue, pMimes) LIMIT 512; END| |