1 # $Id: schema.minisql,v 1.2 2000-06-25 07:34:36 wainstead Exp $
10 pagename CHAR(100) NOT NULL,
14 lastmodified INT NOT NULL,
18 searchterms char(2048)
22 CREATE UNIQUE INDEX wiki_index ON wiki (pagename)
25 CREATE TABLE archive (
26 pagename CHAR(100) NOT NULL,
30 lastmodified INT NOT NULL,
34 searchterms char(2048)
38 CREATE UNIQUE INDEX archive_index ON archive (pagename, version)
41 # tables below are not yet used
43 CREATE TABLE wikilinks (
44 frompage CHAR(100) NOT NULL,
45 topage CHAR(100) NOT NULL
49 CREATE UNIQUE INDEX wikilinks_index ON wikilinks (frompage, topage)
52 CREATE TABLE hottopics (
53 pagename CHAR(100) NOT NULL,
54 lastmodified INT NOT NULL
58 CREATE UNIQUE INDEX hottopics_index ON hottopics (pagename, lastmodified)
61 CREATE TABLE hitcount (
62 pagename CHAR(100) NOT NULL,
67 CREATE UNIQUE INDEX hitcount_index ON hitcount (pagename)