From ae01664e014897d9d1691a2121748f4dac675414 Mon Sep 17 00:00:00 2001 From: Ingo Schwarze Date: Fri, 27 Dec 2013 01:16:54 +0000 Subject: 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. --- mansearch.c | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'mansearch.c') diff --git a/mansearch.c b/mansearch.c index e054e4dd..05d11293 100644 --- a/mansearch.c +++ b/mansearch.c @@ -1,4 +1,4 @@ -/* $Id: mansearch.c,v 1.8 2013/10/20 00:03:05 schwarze Exp $ */ +/* $Id: mansearch.c,v 1.9 2013/12/27 01:16:54 schwarze Exp $ */ /* * Copyright (c) 2012 Kristaps Dzonsons * Copyright (c) 2013 Ingo Schwarze @@ -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); -- cgit v1.2.3-56-ge451