Keep words after .Ic together in a single argument.

[mandoc.git] / mandocdb.c

diff --git a/mandocdb.c b/mandocdb.c
index 514ce7aa04fe74dfb2ad92e37bf37955b7fd0533..e796385948ed1dbea8558290f6aa7c900c3135b8 100644 (file)
--- a/mandocdb.c
+++ b/mandocdb.c
@@ -1,7 +1,7 @@
-/*     $Id: mandocdb.c,v 1.91 2013/12/31 18:07:42 schwarze Exp $ */
+/*     $Id: mandocdb.c,v 1.113 2014/01/19 22:48:16 schwarze Exp $ */

 /*
  * Copyright (c) 2011, 2012 Kristaps Dzonsons <kristaps@bsd.lv>
 /*
  * Copyright (c) 2011, 2012 Kristaps Dzonsons <kristaps@bsd.lv>

- * Copyright (c) 2011, 2012, 2013 Ingo Schwarze <schwarze@openbsd.org>
+ * Copyright (c) 2011, 2012, 2013, 2014 Ingo Schwarze <schwarze@openbsd.org>

  *
  * Permission to use, copy, modify, and distribute this software for any
  * purpose with or without fee is hereby granted, provided that the above
  *
  * Permission to use, copy, modify, and distribute this software for any
  * purpose with or without fee is hereby granted, provided that the above


@@ -48,6 +48,9 @@
 #include "manpath.h"
 #include "mansearch.h"
 
 #include "manpath.h"
 #include "mansearch.h"
 

+extern int mansearch_keymax;
+extern const char *const mansearch_keynames[];
+

 #define        SQL_EXEC(_v) \
        if (SQLITE_OK != sqlite3_exec(db, (_v), NULL, NULL, NULL)) \
                fprintf(stderr, "%s\n", sqlite3_errmsg(db))
 #define        SQL_EXEC(_v) \
        if (SQLITE_OK != sqlite3_exec(db, (_v), NULL, NULL, NULL)) \
                fprintf(stderr, "%s\n", sqlite3_errmsg(db))


@@ -82,10 +85,10 @@ enum        form {
 };
 
 struct str {
 };
 
 struct str {

-       char            *utf8; /* key in UTF-8 form */
+       char            *rendered; /* key in UTF-8 or ASCII form */

        const struct mpage *mpage; /* if set, the owning parse */
        uint64_t         mask; /* bitmask in sequence */
        const struct mpage *mpage; /* if set, the owning parse */
        uint64_t         mask; /* bitmask in sequence */

-       char             key[]; /* the string itself */
+       char             key[]; /* may contain escape sequences */

 };
 
 struct inodev {
 };
 
 struct inodev {


@@ -114,11 +117,6 @@ struct     mlink {
        struct mlink    *next;    /* singly linked list */
 };
 
        struct mlink    *next;    /* singly linked list */
 };
 

-struct title {
-       char            *title; /* name(sec/arch) given inside the file */
-       char            *file; /* file name in case of mismatch */
-};
-

 enum   stmt {
        STMT_DELETE_PAGE = 0,   /* delete mpage */
        STMT_INSERT_PAGE,       /* insert mpage */
 enum   stmt {
        STMT_DELETE_PAGE = 0,   /* delete mpage */
        STMT_INSERT_PAGE,       /* insert mpage */


@@ -135,7 +133,7 @@ struct      mdoc_handler {
 };
 
 static void     dbclose(int);
 };
 
 static void     dbclose(int);

-static void     dbindex(const struct mpage *, struct mchars *);
+static void     dbadd(const struct mpage *, struct mchars *);

 static int      dbopen(int);
 static void     dbprune(void);
 static void     filescan(const char *);
 static int      dbopen(int);
 static void     dbprune(void);
 static void     filescan(const char *);


@@ -143,10 +141,11 @@ static    void    *hash_alloc(size_t, void *);
 static void     hash_free(void *, size_t, void *);
 static void    *hash_halloc(size_t, void *);
 static void     mlink_add(struct mlink *, const struct stat *);
 static void     hash_free(void *, size_t, void *);
 static void    *hash_halloc(size_t, void *);
 static void     mlink_add(struct mlink *, const struct stat *);

+static int      mlink_check(struct mpage *, struct mlink *);

 static void     mlink_free(struct mlink *);
 static void     mlinks_undupe(struct mpage *);
 static void     mpages_free(void);
 static void     mlink_free(struct mlink *);
 static void     mlinks_undupe(struct mpage *);
 static void     mpages_free(void);

-static void     mpages_merge(struct mchars *, struct mparse *, int);
+static void     mpages_merge(struct mchars *, struct mparse *);

 static void     parse_cat(struct mpage *);
 static void     parse_man(struct mpage *, const struct man_node *);
 static void     parse_mdoc(struct mpage *, const struct mdoc_node *);
 static void     parse_cat(struct mpage *);
 static void     parse_man(struct mpage *, const struct man_node *);
 static void     parse_mdoc(struct mpage *, const struct mdoc_node *);


@@ -154,29 +153,28 @@ static    int      parse_mdoc_body(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_head(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Fd(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Fn(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_head(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Fd(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Fn(struct mpage *, const struct mdoc_node *);

-static int      parse_mdoc_In(struct mpage *, const struct mdoc_node *);

 static int      parse_mdoc_Nd(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Nm(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Sh(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Nd(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Nm(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Sh(struct mpage *, const struct mdoc_node *);

-static int      parse_mdoc_St(struct mpage *, const struct mdoc_node *);

 static int      parse_mdoc_Xr(struct mpage *, const struct mdoc_node *);
 static int      parse_mdoc_Xr(struct mpage *, const struct mdoc_node *);

-static void     putkey(const struct mpage *,
-                       const char *, uint64_t);
+static void     putkey(const struct mpage *, char *, uint64_t);

 static void     putkeys(const struct mpage *,
                        const char *, size_t, uint64_t);
 static void     putmdockey(const struct mpage *,
                        const struct mdoc_node *, uint64_t);
 static void     putkeys(const struct mpage *,
                        const char *, size_t, uint64_t);
 static void     putmdockey(const struct mpage *,
                        const struct mdoc_node *, uint64_t);

+static void     render_key(struct mchars *, struct str *);

 static void     say(const char *, const char *, ...);
 static int      set_basedir(const char *);
 static int      treescan(void);
 static size_t   utf8(unsigned int, char [7]);
 static void     say(const char *, const char *, ...);
 static int      set_basedir(const char *);
 static int      treescan(void);
 static size_t   utf8(unsigned int, char [7]);

-static void     utf8key(struct mchars *, struct str *);

 
 static char            *progname;
 
 static char            *progname;

-static int              use_all; /* use all found files */

 static int              nodb; /* no database changes */
 static int              nodb; /* no database changes */

+static int              quick; /* abort the parse early */
+static int              use_all; /* use all found files */

 static int              verb; /* print what we're doing */
 static int              warnings; /* warn about crap */
 static int              verb; /* print what we're doing */
 static int              warnings; /* warn about crap */

+static int              write_utf8; /* write UTF-8 output; else ASCII */

 static int              exitcode; /* to be returned by main */
 static enum op          op; /* operational mode */
 static char             basedir[PATH_MAX]; /* current base directory */
 static int              exitcode; /* to be returned by main */
 static enum op          op; /* operational mode */
 static char             basedir[PATH_MAX]; /* current base directory */


@@ -216,7 +214,7 @@ static      const struct mdoc_handler mdocs[MDOC_MAX] = {
        { parse_mdoc_Fn, 0 },  /* Fn */
        { NULL, TYPE_Ft },  /* Ft */
        { NULL, TYPE_Ic },  /* Ic */
        { parse_mdoc_Fn, 0 },  /* Fn */
        { NULL, TYPE_Ft },  /* Ft */
        { NULL, TYPE_Ic },  /* Ic */

-       { parse_mdoc_In, TYPE_In },  /* In */
+       { NULL, TYPE_In },  /* In */

        { NULL, TYPE_Li },  /* Li */
        { parse_mdoc_Nd, TYPE_Nd },  /* Nd */
        { parse_mdoc_Nm, TYPE_Nm },  /* Nm */
        { NULL, TYPE_Li },  /* Li */
        { parse_mdoc_Nd, TYPE_Nd },  /* Nd */
        { parse_mdoc_Nm, TYPE_Nm },  /* Nm */


@@ -224,7 +222,7 @@ static      const struct mdoc_handler mdocs[MDOC_MAX] = {
        { NULL, 0 },  /* Ot */
        { NULL, TYPE_Pa },  /* Pa */
        { NULL, 0 },  /* Rv */
        { NULL, 0 },  /* Ot */
        { NULL, TYPE_Pa },  /* Pa */
        { NULL, 0 },  /* Rv */

-       { parse_mdoc_St, 0 },  /* St */
+       { NULL, TYPE_St },  /* St */

        { NULL, TYPE_Va },  /* Va */
        { parse_mdoc_body, TYPE_Va },  /* Vt */
        { parse_mdoc_Xr, 0 },  /* Xr */
        { NULL, TYPE_Va },  /* Va */
        { parse_mdoc_body, TYPE_Va },  /* Vt */
        { parse_mdoc_Xr, 0 },  /* Xr */


@@ -352,7 +350,7 @@ main(int argc, char *argv[])
        path_arg = NULL;
        op = OP_DEFAULT;
 
        path_arg = NULL;
        op = OP_DEFAULT;
 

-       while (-1 != (ch = getopt(argc, argv, "aC:d:ntu:vW")))
+       while (-1 != (ch = getopt(argc, argv, "aC:d:nQT:tu:vW")))

                switch (ch) {
                case ('a'):
                        use_all = 1;
                switch (ch) {
                case ('a'):
                        use_all = 1;


@@ -370,6 +368,17 @@ main(int argc, char *argv[])
                case ('n'):
                        nodb = 1;
                        break;
                case ('n'):
                        nodb = 1;
                        break;

+               case ('Q'):
+                       quick = 1;
+                       break;
+               case ('T'):
+                       if (strcmp(optarg, "utf8")) {
+                               fprintf(stderr, "-T%s: Unsupported "
+                                   "output format\n", optarg);
+                               goto usage;
+                       }
+                       write_utf8 = 1;
+                       break;

                case ('t'):
                        CHECKOP(op, ch);
                        dup2(STDOUT_FILENO, STDERR_FILENO);
                case ('t'):
                        CHECKOP(op, ch);
                        dup2(STDOUT_FILENO, STDERR_FILENO);


@@ -401,7 +410,7 @@ main(int argc, char *argv[])
 
        exitcode = (int)MANDOCLEVEL_OK;
        mp = mparse_alloc(MPARSE_AUTO, 
 
        exitcode = (int)MANDOCLEVEL_OK;
        mp = mparse_alloc(MPARSE_AUTO, 

-               MANDOCLEVEL_FATAL, NULL, NULL, NULL);
+               MANDOCLEVEL_FATAL, NULL, NULL, quick);

        mc = mchars_alloc();
 
        ohash_init(&mpages, 6, &mpages_info);
        mc = mchars_alloc();
 
        ohash_init(&mpages, 6, &mpages_info);


@@ -427,7 +436,7 @@ main(int argc, char *argv[])
                if (OP_TEST != op)
                        dbprune();
                if (OP_DELETE != op)
                if (OP_TEST != op)
                        dbprune();
                if (OP_DELETE != op)

-                       mpages_merge(mc, mp, 0);
+                       mpages_merge(mc, mp);

                dbclose(1);
        } else {
                /*
                dbclose(1);
        } else {
                /*


@@ -471,7 +480,7 @@ main(int argc, char *argv[])
                        if (0 == dbopen(0))
                                goto out;
 
                        if (0 == dbopen(0))
                                goto out;
 

-                       mpages_merge(mc, mp, warnings && !use_all);
+                       mpages_merge(mc, mp);

                        dbclose(0);
 
                        if (j + 1 < dirs.sz) {
                        dbclose(0);
 
                        if (j + 1 < dirs.sz) {


@@ -491,11 +500,11 @@ out:
        ohash_delete(&mlinks);
        return(exitcode);
 usage:
        ohash_delete(&mlinks);
        return(exitcode);
 usage:

-       fprintf(stderr, "usage: %s [-anvW] [-C file]\n"
-                       "       %s [-anvW] dir ...\n"
-                       "       %s [-nvW] -d dir [file ...]\n"
+       fprintf(stderr, "usage: %s [-anQvW] [-C file] [-Tutf8]\n"
+                       "       %s [-anQvW] [-Tutf8] dir ...\n"
+                       "       %s [-nQvW] [-Tutf8] -d dir [file ...]\n"

                        "       %s [-nvW] -u dir [file ...]\n"
                        "       %s [-nvW] -u dir [file ...]\n"

-                       "       %s -t file ...\n",
+                       "       %s [-Q] -t file ...\n",

                       progname, progname, progname, 
                       progname, progname);
 
                       progname, progname, progname, 
                       progname, progname);
 


@@ -523,8 +532,8 @@ treescan(void)
        FTSENT          *ff;
        struct mlink    *mlink;
        int              dform;
        FTSENT          *ff;
        struct mlink    *mlink;
        int              dform;

-       char            *fsec;
-       const char      *dsec, *arch, *cp, *path;
+       char            *dsec, *arch, *fsec, *cp;
+       const char      *path;

        const char      *argv[2];
 
        argv[0] = ".";
        const char      *argv[2];
 
        argv[0] = ".";


@@ -589,16 +598,14 @@ treescan(void)
                                continue;
                        } else
                                fsec[-1] = '\0';
                                continue;
                        } else
                                fsec[-1] = '\0';

+

                        mlink = mandoc_calloc(1, sizeof(struct mlink));
                        strlcpy(mlink->file, path, sizeof(mlink->file));
                        mlink->dform = dform;
                        mlink = mandoc_calloc(1, sizeof(struct mlink));
                        strlcpy(mlink->file, path, sizeof(mlink->file));
                        mlink->dform = dform;

-                       if (NULL != dsec)
-                               mlink->dsec = mandoc_strdup(dsec);
-                       if (NULL != arch)
-                               mlink->arch = mandoc_strdup(arch);
-                       mlink->name = mandoc_strdup(ff->fts_name);
-                       if (NULL != fsec)
-                               mlink->fsec = mandoc_strdup(fsec);
+                       mlink->dsec = dsec;
+                       mlink->arch = arch;
+                       mlink->name = ff->fts_name;
+                       mlink->fsec = fsec;

                        mlink_add(mlink, ff->fts_statp);
                        continue;
                } else if (FTS_D != ff->fts_info &&
                        mlink_add(mlink, ff->fts_statp);
                        continue;
                } else if (FTS_D != ff->fts_info &&


@@ -618,8 +625,6 @@ treescan(void)
                         * Try to infer this from the name.
                         * If we're not in use_all, enforce it.
                         */
                         * Try to infer this from the name.
                         * If we're not in use_all, enforce it.
                         */

-                       dsec = NULL;
-                       dform = FORM_NONE;

                        cp = ff->fts_name;
                        if (FTS_DP == ff->fts_info)
                                break;
                        cp = ff->fts_name;
                        if (FTS_DP == ff->fts_info)
                                break;


@@ -630,6 +635,9 @@ treescan(void)
                        } else if (0 == strncmp(cp, "cat", 3)) {
                                dform = FORM_CAT;
                                dsec = cp + 3;
                        } else if (0 == strncmp(cp, "cat", 3)) {
                                dform = FORM_CAT;
                                dsec = cp + 3;

+                       } else {
+                               dform = FORM_NONE;
+                               dsec = NULL;

                        }
 
                        if (NULL != dsec || use_all) 
                        }
 
                        if (NULL != dsec || use_all) 


@@ -644,9 +652,10 @@ treescan(void)
                         * Possibly our architecture.
                         * If we're descending, keep tabs on it.
                         */
                         * Possibly our architecture.
                         * If we're descending, keep tabs on it.
                         */

-                       arch = NULL;

                        if (FTS_DP != ff->fts_info && NULL != dsec)
                                arch = ff->fts_name;
                        if (FTS_DP != ff->fts_info && NULL != dsec)
                                arch = ff->fts_name;

+                       else
+                               arch = NULL;

                        break;
                default:
                        if (FTS_DP == ff->fts_info || use_all)
                        break;
                default:
                        if (FTS_DP == ff->fts_info || use_all)


@@ -693,11 +702,19 @@ filescan(const char *file)
                exitcode = (int)MANDOCLEVEL_BADARG;
                say(file, NULL);
                return;
                exitcode = (int)MANDOCLEVEL_BADARG;
                say(file, NULL);
                return;

-       } else if (OP_TEST != op && strstr(buf, basedir) != buf) {
+       }
+
+       if (strstr(buf, basedir) == buf)
+               start = buf + strlen(basedir) + 1;
+       else if (OP_TEST == op)
+               start = buf;
+       else {

                exitcode = (int)MANDOCLEVEL_BADARG;
                say("", "%s: outside base directory", buf);
                return;
                exitcode = (int)MANDOCLEVEL_BADARG;
                say("", "%s: outside base directory", buf);
                return;

-       } else if (-1 == stat(buf, &st)) {
+       }
+
+       if (-1 == stat(buf, &st)) {

                exitcode = (int)MANDOCLEVEL_BADARG;
                say(file, NULL);
                return;
                exitcode = (int)MANDOCLEVEL_BADARG;
                say(file, NULL);
                return;


@@ -706,7 +723,7 @@ filescan(const char *file)
                say(file, "Not a regular file");
                return;
        }
                say(file, "Not a regular file");
                return;
        }

-       start = buf + strlen(basedir);
+

        mlink = mandoc_calloc(1, sizeof(struct mlink));
        strlcpy(mlink->file, start, sizeof(mlink->file));
 
        mlink = mandoc_calloc(1, sizeof(struct mlink));
        strlcpy(mlink->file, start, sizeof(mlink->file));
 


@@ -720,16 +737,16 @@ filescan(const char *file)
                *p++ = '\0';
                if (0 == strncmp(start, "man", 3)) {
                        mlink->dform = FORM_SRC;
                *p++ = '\0';
                if (0 == strncmp(start, "man", 3)) {
                        mlink->dform = FORM_SRC;

-                       mlink->dsec = mandoc_strdup(start + 3);
+                       mlink->dsec = start + 3;

                } else if (0 == strncmp(start, "cat", 3)) {
                        mlink->dform = FORM_CAT;
                } else if (0 == strncmp(start, "cat", 3)) {
                        mlink->dform = FORM_CAT;

-                       mlink->dsec = mandoc_strdup(start + 3);
+                       mlink->dsec = start + 3;

                }
 
                start = p;
                if (NULL != mlink->dsec && NULL != (p = strchr(start, '/'))) {
                        *p++ = '\0';
                }
 
                start = p;
                if (NULL != mlink->dsec && NULL != (p = strchr(start, '/'))) {
                        *p++ = '\0';

-                       mlink->arch = mandoc_strdup(start);
+                       mlink->arch = start;

                        start = p;
                }
        }
                        start = p;
                }
        }


@@ -744,7 +761,7 @@ filescan(const char *file)
 
        if ('.' == *p) {
                *p++ = '\0';
 
        if ('.' == *p) {
                *p++ = '\0';

-               mlink->fsec = mandoc_strdup(p);
+               mlink->fsec = p;

        }
 
        /*
        }
 
        /*


@@ -756,8 +773,6 @@ filescan(const char *file)
                mlink->name = p + 1;
                *p = '\0';
        }
                mlink->name = p + 1;
                *p = '\0';
        }

-       mlink->name = mandoc_strdup(mlink->name);
-

        mlink_add(mlink, &st);
 }
 
        mlink_add(mlink, &st);
 }
 


@@ -770,14 +785,10 @@ mlink_add(struct mlink *mlink, const struct stat *st)
 
        assert(NULL != mlink->file);
 
 
        assert(NULL != mlink->file);
 

-       if (NULL == mlink->dsec)
-               mlink->dsec = mandoc_strdup("");
-       if (NULL == mlink->arch)
-               mlink->arch = mandoc_strdup("");
-       if (NULL == mlink->name)
-               mlink->name = mandoc_strdup("");
-       if (NULL == mlink->fsec)
-               mlink->fsec = mandoc_strdup("");
+       mlink->dsec = mandoc_strdup(mlink->dsec ? mlink->dsec : "");
+       mlink->arch = mandoc_strdup(mlink->arch ? mlink->arch : "");
+       mlink->name = mandoc_strdup(mlink->name ? mlink->name : "");
+       mlink->fsec = mandoc_strdup(mlink->fsec ? mlink->fsec : "");

 
        if ('0' == *mlink->fsec) {
                free(mlink->fsec);
 
        if ('0' == *mlink->fsec) {
                free(mlink->fsec);


@@ -887,6 +898,54 @@ nextlink:
        }
 }
 
        }
 }
 

+static int
+mlink_check(struct mpage *mpage, struct mlink *mlink)
+{
+       int      match;
+
+       match = 1;
+
+       /*
+        * Check whether the manual section given in a file
+        * agrees with the directory where the file is located.
+        * Some manuals have suffixes like (3p) on their
+        * section number either inside the file or in the
+        * directory name, some are linked into more than one
+        * section, like encrypt(1) = makekey(8).
+        */
+
+       if (FORM_SRC == mpage->form &&
+           strcasecmp(mpage->sec, mlink->dsec)) {
+               match = 0;
+               say(mlink->file, "Section \"%s\" manual in %s directory",
+                   mpage->sec, mlink->dsec);
+       }
+
+       /*
+        * Manual page directories exist for each kernel
+        * architecture as returned by machine(1).
+        * However, many manuals only depend on the
+        * application architecture as returned by arch(1).
+        * For example, some (2/ARM) manuals are shared
+        * across the "armish" and "zaurus" kernel
+        * architectures.
+        * A few manuals are even shared across completely
+        * different architectures, for example fdformat(1)
+        * on amd64, i386, sparc, and sparc64.
+        */
+
+       if (strcasecmp(mpage->arch, mlink->arch)) {
+               match = 0;
+               say(mlink->file, "Architecture \"%s\" manual in "
+                   "\"%s\" directory", mpage->arch, mlink->arch);
+       }
+
+       if (strcasecmp(mpage->title, mlink->name))
+               match = 0;
+
+       return(match);
+}
+

 /*
  * Run through the files in the global vector "mpages"
  * and add them to the database specified in "basedir".
 /*
  * Run through the files in the global vector "mpages"
  * and add them to the database specified in "basedir".


@@ -895,18 +954,17 @@ nextlink:
  * and filename to determine whether the file is parsable or not.
  */
 static void
  * and filename to determine whether the file is parsable or not.
  */
 static void

-mpages_merge(struct mchars *mc, struct mparse *mp, int check_reachable)
+mpages_merge(struct mchars *mc, struct mparse *mp)

 {
 {

-       struct ohash             title_table;
-       struct ohash_info        title_info, str_info;
+       char                     any[] = "any";
+       struct ohash_info        str_info;

        struct mpage            *mpage;
        struct mpage            *mpage;

+       struct mlink            *mlink;

        struct mdoc             *mdoc;
        struct man              *man;
        struct mdoc             *mdoc;
        struct man              *man;

-       struct title            *title_entry;
-       char                    *title_str;
-       const char              *cp;
+       char                    *cp;

        int                      match;
        int                      match;

-       unsigned int             pslot, tslot;
+       unsigned int             pslot;

        enum mandoclevel         lvl;
 
        str_info.alloc = hash_alloc;
        enum mandoclevel         lvl;
 
        str_info.alloc = hash_alloc;


@@ -914,13 +972,8 @@ mpages_merge(struct mchars *mc, struct mparse *mp, int check_reachable)
        str_info.hfree = hash_free;
        str_info.key_offset = offsetof(struct str, key);
 
        str_info.hfree = hash_free;
        str_info.key_offset = offsetof(struct str, key);
 

-       if (check_reachable) {
-               title_info.alloc = hash_alloc;
-               title_info.halloc = hash_halloc;
-               title_info.hfree = hash_free;
-               title_info.key_offset = offsetof(struct title, title);
-               ohash_init(&title_table, 6, &title_info);
-       }
+       if (0 == nodb)
+               SQL_EXEC("BEGIN TRANSACTION");

 
        mpage = ohash_first(&mpages, &pslot);
        while (NULL != mpage) {
 
        mpage = ohash_first(&mpages, &pslot);
        while (NULL != mpage) {


@@ -934,7 +987,6 @@ mpages_merge(struct mchars *mc, struct mparse *mp, int check_reachable)
                mparse_reset(mp);
                mdoc = NULL;
                man = NULL;
                mparse_reset(mp);
                mdoc = NULL;
                man = NULL;

-               match = 1;

 
                /*
                 * Try interpreting the file as mdoc(7) or man(7)
 
                /*
                 * Try interpreting the file as mdoc(7) or man(7)


@@ -974,50 +1026,28 @@ mpages_merge(struct mchars *mc, struct mparse *mp, int check_reachable)
                        mpage->title =
                            mandoc_strdup(mpage->mlinks->name);
                }
                        mpage->title =
                            mandoc_strdup(mpage->mlinks->name);
                }

-
-               /*
-                * Check whether the manual section given in a file
-                * agrees with the directory where the file is located.
-                * Some manuals have suffixes like (3p) on their
-                * section number either inside the file or in the
-                * directory name, some are linked into more than one
-                * section, like encrypt(1) = makekey(8).  Do not skip
-                * manuals for such reasons.
-                */
-               if (warnings && !use_all && FORM_SRC == mpage->form &&
-                   strcasecmp(mpage->sec, mpage->mlinks->dsec)) {
-                       match = 0;
-                       say(mpage->mlinks->file, "Section \"%s\" "
-                               "manual in %s directory",
-                               mpage->sec, mpage->mlinks->dsec);
+               putkey(mpage, mpage->sec, TYPE_sec);
+               putkey(mpage, '\0' == *mpage->arch ?
+                   any : mpage->arch, TYPE_arch);
+
+               for (mlink = mpage->mlinks; mlink; mlink = mlink->next) {
+                       if ('\0' != *mlink->dsec)
+                               putkey(mpage, mlink->dsec, TYPE_sec);
+                       if ('\0' != *mlink->fsec)
+                               putkey(mpage, mlink->fsec, TYPE_sec);
+                       putkey(mpage, '\0' == *mlink->arch ?
+                           any : mlink->arch, TYPE_arch);
+                       putkey(mpage, mlink->name, TYPE_Nm);

                }
 
                }
 

-               /*
-                * Manual page directories exist for each kernel
-                * architecture as returned by machine(1).
-                * However, many manuals only depend on the
-                * application architecture as returned by arch(1).
-                * For example, some (2/ARM) manuals are shared
-                * across the "armish" and "zaurus" kernel
-                * architectures.
-                * A few manuals are even shared across completely
-                * different architectures, for example fdformat(1)
-                * on amd64, i386, sparc, and sparc64.
-                * Thus, warn about architecture mismatches,
-                * but don't skip manuals for this reason.
-                */
-               if (warnings && !use_all &&
-                   strcasecmp(mpage->arch, mpage->mlinks->arch)) {
-                       match = 0;
-                       say(mpage->mlinks->file, "Architecture \"%s\" "
-                               "manual in \"%s\" directory",
-                               mpage->arch, mpage->mlinks->arch);
-               }
-               if (warnings && !use_all &&
-                   strcasecmp(mpage->title, mpage->mlinks->name))
+               if (warnings && !use_all) {

                        match = 0;
                        match = 0;

-
-               putkey(mpage, mpage->mlinks->name, TYPE_Nm);
+                       for (mlink = mpage->mlinks; mlink;
+                            mlink = mlink->next)
+                               if (mlink_check(mpage, mlink))
+                                       match = 1;
+               } else
+                       match = 1;

 
                if (NULL != mdoc) {
                        if (NULL != (cp = mdoc_meta(mdoc)->name))
 
                if (NULL != mdoc) {
                        if (NULL != (cp = mdoc_meta(mdoc)->name))


@@ -1031,56 +1061,13 @@ mpages_merge(struct mchars *mc, struct mparse *mp, int check_reachable)
                else
                        parse_cat(mpage);
 
                else
                        parse_cat(mpage);
 

-               /*
-                * Build a title string for the file.  If it matches
-                * the location of the file, remember the title as
-                * found; else, remember it as missing.
-                */
-
-               if (check_reachable) {
-                       if (-1 == asprintf(&title_str, "%s(%s%s%s)",
-                           mpage->title, mpage->sec,
-                           '\0' == *mpage->arch ? "" : "/",
-                           mpage->arch)) {
-                               perror(NULL);
-                               exit((int)MANDOCLEVEL_SYSERR);
-                       }
-                       tslot = ohash_qlookup(&title_table, title_str);
-                       title_entry = ohash_find(&title_table, tslot);
-                       if (NULL == title_entry) {
-                               title_entry = mandoc_malloc(
-                                               sizeof(struct title));
-                               title_entry->title = title_str;
-                               title_entry->file = mandoc_strdup(
-                                   match ? "" : mpage->mlinks->file);
-                               ohash_insert(&title_table, tslot,
-                                               title_entry);
-                       } else {
-                               if (match)
-                                       *title_entry->file = '\0';
-                               free(title_str);
-                       }
-               }
-
-               dbindex(mpage, mc);
+               dbadd(mpage, mc);

                ohash_delete(&strings);
                mpage = ohash_next(&mpages, &pslot);
        }
 
                ohash_delete(&strings);
                mpage = ohash_next(&mpages, &pslot);
        }
 

-       if (check_reachable) {
-               title_entry = ohash_first(&title_table, &tslot);
-               while (NULL != title_entry) {
-                       if ('\0' != *title_entry->file)
-                               say(title_entry->file,
-                                   "Probably unreachable, title is %s",
-                                   title_entry->title);
-                       free(title_entry->title);
-                       free(title_entry->file);
-                       free(title_entry);
-                       title_entry = ohash_next(&title_table, &tslot);
-               }
-               ohash_delete(&title_table);
-       }
+       if (0 == nodb)
+               SQL_EXEC("END TRANSACTION");

 }
 
 static void
 }
 
 static void


@@ -1199,10 +1186,15 @@ parse_cat(struct mpage *mpage)
  * Put a type/word pair into the word database for this particular file.
  */
 static void
  * Put a type/word pair into the word database for this particular file.
  */
 static void

-putkey(const struct mpage *mpage, const char *value, uint64_t type)
+putkey(const struct mpage *mpage, char *value, uint64_t type)

 {
 {

+       char     *cp;

 
        assert(NULL != value);
 
        assert(NULL != value);

+       if (TYPE_arch == type)
+               for (cp = value; *cp; cp++)
+                       if (isupper((unsigned char)*cp))
+                               *cp = _tolower((unsigned char)*cp);

        putkeys(mpage, value, strlen(value), type);
 }
 
        putkeys(mpage, value, strlen(value), type);
 }
 


@@ -1318,6 +1310,15 @@ parse_man(struct mpage *mpage, const struct man_node *n)
                                byte = start[sz];
                                start[sz] = '\0';
 
                                byte = start[sz];
                                start[sz] = '\0';
 

+                               /*
+                                * Assume a stray trailing comma in the
+                                * name list if a name begins with a dash.
+                                */
+
+                               if ('-' == start[0] ||
+                                   ('\\' == start[0] && '-' == start[1]))
+                                       break;
+

                                putkey(mpage, start, TYPE_Nm);
 
                                if (' ' == byte) {
                                putkey(mpage, start, TYPE_Nm);
 
                                if (' ' == byte) {


@@ -1441,24 +1442,13 @@ parse_mdoc_Fd(struct mpage *mpage, const struct mdoc_node *n)
 
        if (end > start)
                putkeys(mpage, start, end - start + 1, TYPE_In);
 
        if (end > start)
                putkeys(mpage, start, end - start + 1, TYPE_In);

-       return(1);
-}
-
-static int
-parse_mdoc_In(struct mpage *mpage, const struct mdoc_node *n)
-{
-
-       if (NULL != n->child && MDOC_TEXT == n->child->type)
-               return(0);
-
-       putkey(mpage, n->child->string, TYPE_In);
-       return(1);
+       return(0);

 }
 
 static int
 parse_mdoc_Fn(struct mpage *mpage, const struct mdoc_node *n)
 {
 }
 
 static int
 parse_mdoc_Fn(struct mpage *mpage, const struct mdoc_node *n)
 {

-       const char      *cp;
+       char    *cp;

 
        if (NULL == (n = n->child) || MDOC_TEXT != n->type)
                return(0);
 
        if (NULL == (n = n->child) || MDOC_TEXT != n->type)
                return(0);


@@ -1488,17 +1478,6 @@ parse_mdoc_Fn(struct mpage *mpage, const struct mdoc_node *n)
        return(0);
 }
 
        return(0);
 }
 

-static int
-parse_mdoc_St(struct mpage *mpage, const struct mdoc_node *n)
-{
-
-       if (NULL == n->child || MDOC_TEXT != n->child->type)
-               return(0);
-
-       putkey(mpage, n->child->string, TYPE_St);
-       return(1);
-}
-

 static int
 parse_mdoc_Xr(struct mpage *mpage, const struct mdoc_node *n)
 {
 static int
 parse_mdoc_Xr(struct mpage *mpage, const struct mdoc_node *n)
 {


@@ -1556,12 +1535,8 @@ static int
 parse_mdoc_Nm(struct mpage *mpage, const struct mdoc_node *n)
 {
 
 parse_mdoc_Nm(struct mpage *mpage, const struct mdoc_node *n)
 {
 

-       if (SEC_NAME == n->sec)
-               return(1);
-       else if (SEC_SYNOPSIS != n->sec || MDOC_HEAD != n->type)
-               return(0);
-
-       return(1);
+       return(SEC_NAME == n->sec ||
+           (SEC_SYNOPSIS == n->sec && MDOC_HEAD == n->type));

 }
 
 static int
 }
 
 static int


@@ -1595,12 +1570,24 @@ putkeys(const struct mpage *mpage,
        const char *cp, size_t sz, uint64_t v)
 {
        struct str      *s;
        const char *cp, size_t sz, uint64_t v)
 {
        struct str      *s;

-       unsigned int     slot;

        const char      *end;
        const char      *end;

+       uint64_t         mask;
+       unsigned int     slot;
+       int              i;

 
        if (0 == sz)
                return;
 
 
        if (0 == sz)
                return;
 

+       if (verb > 1) {
+               for (i = 0, mask = 1;
+                    i < mansearch_keymax;
+                    i++, mask <<= 1)
+                       if (mask & v)
+                               break;
+               say(mpage->mlinks->file, "Adding key %s=%*s",
+                   mansearch_keynames[i], sz, cp);
+       }
+

        end = cp + sz;
        slot = ohash_qlookupi(&strings, cp, &end);
        s = ohash_find(&strings, slot);
        end = cp + sz;
        slot = ohash_qlookupi(&strings, cp, &end);
        s = ohash_find(&strings, slot);


@@ -1670,11 +1657,11 @@ utf8(unsigned int cp, char out[7])
 }
 
 /*
 }
 
 /*

- * Store the UTF-8 version of a key, or alias the pointer if the key has
- * no UTF-8 transcription marks in it.
+ * Store the rendered version of a key, or alias the pointer
+ * if the key contains no escape sequences.

  */
 static void
  */
 static void

-utf8key(struct mchars *mc, struct str *key)
+render_key(struct mchars *mc, struct str *key)

 {
        size_t           sz, bsz, pos;
        char             utfbuf[7], res[5];
 {
        size_t           sz, bsz, pos;
        char             utfbuf[7], res[5];


@@ -1683,7 +1670,7 @@ utf8key(struct mchars *mc, struct str *key)
        int              len, u;
        enum mandoc_esc  esc;
 
        int              len, u;
        enum mandoc_esc  esc;
 

-       assert(NULL == key->utf8);
+       assert(NULL == key->rendered);

 
        res[0] = '\\';
        res[1] = '\t';
 
        res[0] = '\\';
        res[1] = '\t';


@@ -1699,7 +1686,7 @@ utf8key(struct mchars *mc, struct str *key)
         * pointer as ourselvse and get out of here.
         */
        if (strcspn(val, res) == bsz) {
         * pointer as ourselvse and get out of here.
         */
        if (strcspn(val, res) == bsz) {

-               key->utf8 = key->key;
+               key->rendered = key->key;

                return;
        } 
 
                return;
        } 
 


@@ -1739,83 +1726,70 @@ utf8key(struct mchars *mc, struct str *key)
                 * Parse the escape sequence and see if it's a
                 * predefined character or special character.
                 */
                 * Parse the escape sequence and see if it's a
                 * predefined character or special character.
                 */

+

                esc = mandoc_escape
                        ((const char **)&val, &seq, &len);
                if (ESCAPE_ERROR == esc)
                        break;
                esc = mandoc_escape
                        ((const char **)&val, &seq, &len);
                if (ESCAPE_ERROR == esc)
                        break;

-

                if (ESCAPE_SPECIAL != esc)
                        continue;
                if (ESCAPE_SPECIAL != esc)
                        continue;

-               if (0 == (u = mchars_spec2cp(mc, seq, len)))
-                       continue;

 
                /*
 
                /*

-                * If we have a Unicode codepoint, try to convert that
-                * to a UTF-8 byte string.
+                * Render the special character
+                * as either UTF-8 or ASCII.

                 */
                 */

-               cpp = utfbuf;
-               if (0 == (sz = utf8(u, utfbuf)))
-                       continue;
+
+               if (write_utf8) {
+                       if (0 == (u = mchars_spec2cp(mc, seq, len)))
+                               continue;
+                       cpp = utfbuf;
+                       if (0 == (sz = utf8(u, utfbuf)))
+                               continue;
+                       sz = strlen(cpp);
+               } else {
+                       cpp = mchars_spec2str(mc, seq, len, &sz);
+                       if (NULL == cpp)
+                               continue;
+                       if (ASCII_NBRSP == *cpp) {
+                               cpp = " ";
+                               sz = 1;
+                       }
+               }

 
                /* Copy the rendered glyph into the stream. */
 
 
                /* Copy the rendered glyph into the stream. */
 

-               sz = strlen(cpp);

                bsz += sz;
                bsz += sz;

-

                buf = mandoc_realloc(buf, bsz);
                buf = mandoc_realloc(buf, bsz);

-

                memcpy(&buf[pos], cpp, sz);
                pos += sz;
        }
 
        buf[pos] = '\0';
                memcpy(&buf[pos], cpp, sz);
                pos += sz;
        }
 
        buf[pos] = '\0';

-       key->utf8 = buf;
+       key->rendered = buf;

 }
 
 /*
  * Flush the current page's terms (and their bits) into the database.
  * Wrap the entire set of additions in a transaction to make sqlite be a
  * little faster.
 }
 
 /*
  * Flush the current page's terms (and their bits) into the database.
  * Wrap the entire set of additions in a transaction to make sqlite be a
  * little faster.

- * Also, UTF-8-encode the description at the last possible moment.
+ * Also, handle escape sequences at the last possible moment.

  */
 static void
  */
 static void

-dbindex(const struct mpage *mpage, struct mchars *mc)
+dbadd(const struct mpage *mpage, struct mchars *mc)

 {
        struct mlink    *mlink;
        struct str      *key;
 {
        struct mlink    *mlink;
        struct str      *key;

-       const char      *desc;

        int64_t          recno;
        size_t           i;
        unsigned int     slot;
 
        if (verb)
        int64_t          recno;
        size_t           i;
        unsigned int     slot;
 
        if (verb)

-               say(mpage->mlinks->file, "Adding to index");
+               say(mpage->mlinks->file, "Adding to database");

 
        if (nodb)
                return;
 
 
        if (nodb)
                return;
 

-       desc = "";
-       if (NULL != mpage->desc && '\0' != *mpage->desc) {
-               key = ohash_find(&strings,
-                       ohash_qlookup(&strings, mpage->desc));
-               assert(NULL != key);
-               if (NULL == key->utf8)
-                       utf8key(mc, key);
-               desc = key->utf8;
-       }
-
-       SQL_EXEC("BEGIN TRANSACTION");
-

        i = 1;
        i = 1;

-       /*
-        * XXX The following three lines are obsolete
-        * and only kept for backward compatibility
-        * until apropos(1) and friends have caught up.
-        */
-       SQL_BIND_TEXT(stmts[STMT_INSERT_PAGE], i, mpage->mlinks->file);
-       SQL_BIND_TEXT(stmts[STMT_INSERT_PAGE], i, mpage->mlinks->dsec);
-       SQL_BIND_TEXT(stmts[STMT_INSERT_PAGE], i, mpage->mlinks->arch);
-       SQL_BIND_TEXT(stmts[STMT_INSERT_PAGE], i, desc);

        SQL_BIND_INT(stmts[STMT_INSERT_PAGE], i, FORM_SRC == mpage->form);
        SQL_STEP(stmts[STMT_INSERT_PAGE]);
        recno = sqlite3_last_insert_rowid(db);
        SQL_BIND_INT(stmts[STMT_INSERT_PAGE], i, FORM_SRC == mpage->form);
        SQL_STEP(stmts[STMT_INSERT_PAGE]);
        recno = sqlite3_last_insert_rowid(db);


@@ -1823,7 +1797,6 @@ dbindex(const struct mpage *mpage, struct mchars *mc)
 
        for (mlink = mpage->mlinks; mlink; mlink = mlink->next) {
                i = 1;
 
        for (mlink = mpage->mlinks; mlink; mlink = mlink->next) {
                i = 1;

-               SQL_BIND_TEXT(stmts[STMT_INSERT_LINK], i, mlink->file);

                SQL_BIND_TEXT(stmts[STMT_INSERT_LINK], i, mlink->dsec);
                SQL_BIND_TEXT(stmts[STMT_INSERT_LINK], i, mlink->arch);
                SQL_BIND_TEXT(stmts[STMT_INSERT_LINK], i, mlink->name);
                SQL_BIND_TEXT(stmts[STMT_INSERT_LINK], i, mlink->dsec);
                SQL_BIND_TEXT(stmts[STMT_INSERT_LINK], i, mlink->arch);
                SQL_BIND_TEXT(stmts[STMT_INSERT_LINK], i, mlink->name);


@@ -1835,20 +1808,18 @@ dbindex(const struct mpage *mpage, struct mchars *mc)
        for (key = ohash_first(&strings, &slot); NULL != key;
             key = ohash_next(&strings, &slot)) {
                assert(key->mpage == mpage);
        for (key = ohash_first(&strings, &slot); NULL != key;
             key = ohash_next(&strings, &slot)) {
                assert(key->mpage == mpage);

-               if (NULL == key->utf8)
-                       utf8key(mc, key);
+               if (NULL == key->rendered)
+                       render_key(mc, key);

                i = 1;
                SQL_BIND_INT64(stmts[STMT_INSERT_KEY], i, key->mask);
                i = 1;
                SQL_BIND_INT64(stmts[STMT_INSERT_KEY], i, key->mask);

-               SQL_BIND_TEXT(stmts[STMT_INSERT_KEY], i, key->utf8);
+               SQL_BIND_TEXT(stmts[STMT_INSERT_KEY], i, key->rendered);

                SQL_BIND_INT64(stmts[STMT_INSERT_KEY], i, recno);
                SQL_STEP(stmts[STMT_INSERT_KEY]);
                sqlite3_reset(stmts[STMT_INSERT_KEY]);
                SQL_BIND_INT64(stmts[STMT_INSERT_KEY], i, recno);
                SQL_STEP(stmts[STMT_INSERT_KEY]);
                sqlite3_reset(stmts[STMT_INSERT_KEY]);

-               if (key->utf8 != key->key)
-                       free(key->utf8);
+               if (key->rendered != key->key)
+                       free(key->rendered);

                free(key);
        }
                free(key);
        }

-
-       SQL_EXEC("END TRANSACTION");

 }
 
 static void
 }
 
 static void


@@ -1859,20 +1830,31 @@ dbprune(void)
        size_t           i;
        unsigned int     slot;
 
        size_t           i;
        unsigned int     slot;
 

-       if (nodb)
-               return;
+       if (0 == nodb)
+               SQL_EXEC("BEGIN TRANSACTION");

 
 

-       mpage = ohash_first(&mpages, &slot);
-       while (NULL != mpage) {
+       for (mpage = ohash_first(&mpages, &slot); NULL != mpage;
+            mpage = ohash_next(&mpages, &slot)) {

                mlink = mpage->mlinks;
                mlink = mpage->mlinks;

-               i = 1;
-               SQL_BIND_TEXT(stmts[STMT_DELETE_PAGE], i, mlink->file);
-               SQL_STEP(stmts[STMT_DELETE_PAGE]);
-               sqlite3_reset(stmts[STMT_DELETE_PAGE]);

                if (verb)
                if (verb)

-                       say(mlink->file, "Deleted from index");
-               mpage = ohash_next(&mpages, &slot);
+                       say(mlink->file, "Deleting from database");
+               if (nodb)
+                       continue;
+               for ( ; NULL != mlink; mlink = mlink->next) {
+                       i = 1;
+                       SQL_BIND_TEXT(stmts[STMT_DELETE_PAGE],
+                           i, mlink->dsec);
+                       SQL_BIND_TEXT(stmts[STMT_DELETE_PAGE],
+                           i, mlink->arch);
+                       SQL_BIND_TEXT(stmts[STMT_DELETE_PAGE],
+                           i, mlink->name);
+                       SQL_STEP(stmts[STMT_DELETE_PAGE]);
+                       sqlite3_reset(stmts[STMT_DELETE_PAGE]);
+               }

        }
        }

+
+       if (0 == nodb)
+               SQL_EXEC("END TRANSACTION");

 }
 
 /*
 }
 
 /*


@@ -1951,39 +1933,25 @@ dbopen(int real)
                return(0);
        }
 
                return(0);
        }
 

-       /*
-        * XXX The first three columns in table mpages are obsolete
-        * and only kept for backward compatibility
-        * until apropos(1) and friends have caught up.
-        */

        sql = "CREATE TABLE \"mpages\" (\n"
        sql = "CREATE TABLE \"mpages\" (\n"

-             " \"file\" TEXT NOT NULL,\n"
-             " \"sec\" TEXT NOT NULL,\n"
-             " \"arch\" TEXT NOT NULL,\n"
-             " \"desc\" TEXT NOT NULL,\n"

              " \"form\" INTEGER NOT NULL,\n"
              " \"id\" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL\n"
              ");\n"
              "\n"
              "CREATE TABLE \"mlinks\" (\n"
              " \"form\" INTEGER NOT NULL,\n"
              " \"id\" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL\n"
              ");\n"
              "\n"
              "CREATE TABLE \"mlinks\" (\n"

-             " \"file\" TEXT NOT NULL,\n"

              " \"sec\" TEXT NOT NULL,\n"
              " \"arch\" TEXT NOT NULL,\n"
              " \"name\" TEXT NOT NULL,\n"
              " \"pageid\" INTEGER NOT NULL REFERENCES mpages(id) "
              " \"sec\" TEXT NOT NULL,\n"
              " \"arch\" TEXT NOT NULL,\n"
              " \"name\" TEXT NOT NULL,\n"
              " \"pageid\" INTEGER NOT NULL REFERENCES mpages(id) "

-               "ON DELETE CASCADE,\n"
-             " \"id\" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL\n"
+               "ON DELETE CASCADE\n"

              ");\n"
              "\n"
              "CREATE TABLE \"keys\" (\n"
              " \"bits\" INTEGER NOT NULL,\n"
              " \"key\" TEXT NOT NULL,\n"
              " \"pageid\" INTEGER NOT NULL REFERENCES mpages(id) "
              ");\n"
              "\n"
              "CREATE TABLE \"keys\" (\n"
              " \"bits\" INTEGER NOT NULL,\n"
              " \"key\" TEXT NOT NULL,\n"
              " \"pageid\" INTEGER NOT NULL REFERENCES mpages(id) "

-               "ON DELETE CASCADE,\n"
-             " \"id\" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL\n"
-             ");\n"
-             "\n"
-             "CREATE INDEX \"key_index\" ON keys (key);\n";
+               "ON DELETE CASCADE\n"
+             ");\n";

 
        if (SQLITE_OK != sqlite3_exec(db, sql, NULL, NULL, NULL)) {
                exitcode = (int)MANDOCLEVEL_SYSERR;
 
        if (SQLITE_OK != sqlite3_exec(db, sql, NULL, NULL, NULL)) {
                exitcode = (int)MANDOCLEVEL_SYSERR;


@@ -1993,13 +1961,15 @@ dbopen(int real)
 
 prepare_statements:
        SQL_EXEC("PRAGMA foreign_keys = ON");
 
 prepare_statements:
        SQL_EXEC("PRAGMA foreign_keys = ON");

-       sql = "DELETE FROM mpages where file=?";
+       sql = "DELETE FROM mpages WHERE id IN "
+               "(SELECT pageid FROM mlinks WHERE "
+               "sec=? AND arch=? AND name=?)";

        sqlite3_prepare_v2(db, sql, -1, &stmts[STMT_DELETE_PAGE], NULL);
        sql = "INSERT INTO mpages "
        sqlite3_prepare_v2(db, sql, -1, &stmts[STMT_DELETE_PAGE], NULL);
        sql = "INSERT INTO mpages "

-               "(file,sec,arch,desc,form) VALUES (?,?,?,?,?)";
+               "(form) VALUES (?)";

        sqlite3_prepare_v2(db, sql, -1, &stmts[STMT_INSERT_PAGE], NULL);
        sql = "INSERT INTO mlinks "
        sqlite3_prepare_v2(db, sql, -1, &stmts[STMT_INSERT_PAGE], NULL);
        sql = "INSERT INTO mlinks "

-               "(file,sec,arch,name,pageid) VALUES (?,?,?,?,?)";
+               "(sec,arch,name,pageid) VALUES (?,?,?,?)";

        sqlite3_prepare_v2(db, sql, -1, &stmts[STMT_INSERT_LINK], NULL);
        sql = "INSERT INTO keys "
                "(bits,key,pageid) VALUES (?,?,?)";
        sqlite3_prepare_v2(db, sql, -1, &stmts[STMT_INSERT_LINK], NULL);
        sql = "INSERT INTO keys "
                "(bits,key,pageid) VALUES (?,?,?)";