[src/trunk]: src/usr.sbin/makemandb Mark the section and md5_hash columns as ...

[abhinav <abhinav%NetBSD.org@localhost>]

details:   https://anonhg.NetBSD.org/src/rev/199770993a5c
branches:  trunk
changeset: 348067:199770993a5c
user:      abhinav <abhinav%NetBSD.org@localhost>
date:      Mon Oct 03 13:36:35 2016 +0000

description:
Mark the section and md5_hash columns as unindexed in the FTS table, as they are not used for search

diffstat:

 usr.sbin/makemandb/apropos-utils.c |  7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diffs (28 lines):

diff -r 6ca96a3035ad -r 199770993a5c usr.sbin/makemandb/apropos-utils.c
--- a/usr.sbin/makemandb/apropos-utils.c        Mon Oct 03 13:36:33 2016 +0000
+++ b/usr.sbin/makemandb/apropos-utils.c        Mon Oct 03 13:36:35 2016 +0000
@@ -1,4 +1,4 @@
-/*     $NetBSD: apropos-utils.c,v 1.28 2016/07/06 18:03:27 abhinav Exp $       */
+/*     $NetBSD: apropos-utils.c,v 1.29 2016/10/03 13:36:35 abhinav Exp $       */
 /*-
  * Copyright (c) 2011 Abhinav Upadhyay <er.abhinav.upadhyay%gmail.com@localhost>
  * All rights reserved.
@@ -31,7 +31,7 @@
  */
 
 #include <sys/cdefs.h>
-__RCSID("$NetBSD: apropos-utils.c,v 1.28 2016/07/06 18:03:27 abhinav Exp $");
+__RCSID("$NetBSD: apropos-utils.c,v 1.29 2016/10/03 13:36:35 abhinav Exp $");
 
 #include <sys/queue.h>
 #include <sys/stat.h>
@@ -175,7 +175,8 @@
            "CREATE VIRTUAL TABLE mandb USING fts4(section, name, "
                "name_desc, desc, lib, return_vals, env, files, "
                "exit_status, diagnostics, errors, md5_hash UNIQUE, machine, "
-               "compress=zip, uncompress=unzip, tokenize=porter); "
+               "compress=zip, uncompress=unzip, tokenize=porter, "
+               "notindexed=section, notindexed=md5_hash); "
            //mandb_meta
            "CREATE TABLE IF NOT EXISTS mandb_meta(device, inode, mtime, "
                "file UNIQUE, md5_hash UNIQUE, id  INTEGER PRIMARY KEY); "