Add an additional mlinks table to the database, redundant for now,

both because it contains nothing but a subset of the data of the
existing mpages table and because the relationship of mpage and mlink
entries is still 1:1.  But all that will eventually change.

1 files changed, 2 insertions, 2 deletions

diff --git a/mansearch.c b/mansearch.c
index 42905954..ff864c7d 100644
--- a/mansearch.c
+++ b/mansearch.c
@@ -363,9 +363,9 @@ sql_statement(const struct expr *e, const char *arch, const char *sec)
 	size_t		 sz;
 
 	sql = mandoc_strdup
-		("SELECT docid,bits,key,file,desc,form,sec,arch "
+		("SELECT pageid,bits,key,file,desc,form,sec,arch "
 		 "FROM keys "
-		 "INNER JOIN docs ON docs.id=keys.docid "
+		 "INNER JOIN mpages ON mpages.id=keys.pageid "
 		 "WHERE ");
 	sz = strlen(sql);
 	substrsz = strlen(substr);