diff options
| author |   Ingo Schwarze <schwarze@openbsd.org> | 2014-01-06 03:52:13 +0000 |
|---|---|---|
| committer | Ingo Schwarze <schwarze@openbsd.org> | 2014-01-06 03:52:13 +0000 |
| commit | 9a93632ffc644aba021ef8f0e26de6b6ebbe0e1e (patch) | |
| tree | 2b1abceb07a0613a5169e266f5cd08ee6180abf7 /mandocdb.c | |
| parent | c2dd68816c9e05ae3f31a96307caa577ff4db3dd (diff) | |
| download | mandoc-9a93632ffc644aba021ef8f0e26de6b6ebbe0e1e.tar.gz mandoc-9a93632ffc644aba021ef8f0e26de6b6ebbe0e1e.tar.zst mandoc-9a93632ffc644aba021ef8f0e26de6b6ebbe0e1e.zip | |
Remove the redundant "file" column from the "mlinks" table.
The contents can easily be reconstructed from sec, arch, name, form.
Shrinks the database by another 3% in standard mode and 9% in -Q mode.
Diffstat (limited to 'mandocdb.c')
| -rw-r--r-- | mandocdb.c | 6 |
1 files changed, 2 insertions, 4 deletions
@@ -1,4 +1,4 @@ -/* $Id: mandocdb.c,v 1.103 2014/01/06 03:02:46 schwarze Exp $ */ +/* $Id: mandocdb.c,v 1.104 2014/01/06 03:52:13 schwarze Exp $ */ /* * Copyright (c) 2011, 2012 Kristaps Dzonsons <kristaps@bsd.lv> * Copyright (c) 2011, 2012, 2013, 2014 Ingo Schwarze <schwarze@openbsd.org> @@ -1756,7 +1756,6 @@ dbindex(const struct mpage *mpage, struct mchars *mc) 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); @@ -1890,7 +1889,6 @@ dbopen(int real) ");\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" @@ -1923,7 +1921,7 @@ prepare_statements: "(form) VALUES (?)"; 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 (?,?,?)"; |