1 # $Id: schema.minisql,v 1.5 2000-06-29 04:30:31 wainstead Exp $
6 drop table archivepages\g
12 # metadata about the page
15 pagename CHAR(100) NOT NULL,
19 lastmodified INT NOT NULL,
25 CREATE UNIQUE INDEX wiki_index ON wiki (pagename)
28 # archive for page metadata
30 CREATE TABLE archive (
31 pagename CHAR(100) NOT NULL,
35 lastmodified INT NOT NULL,
41 CREATE UNIQUE INDEX archive_index ON archive (pagename, version)
45 # table for the pages themselves... stored in lines
47 CREATE TABLE wikipages (
48 pagename CHAR(100) NOT NULL,
54 CREATE UNIQUE INDEX wp_idx ON wikipages (pagename, lineno)
58 # archive of page lines
60 CREATE TABLE archivepages (
61 pagename CHAR(100) NOT NULL,
67 CREATE UNIQUE INDEX ap_idx ON archivepages (pagename, lineno)
72 # tables below are not yet used
74 CREATE TABLE wikilinks (
75 frompage CHAR(100) NOT NULL,
76 topage CHAR(100) NOT NULL
80 CREATE UNIQUE INDEX wikilinks_index ON wikilinks (frompage, topage)
83 CREATE TABLE hottopics (
84 pagename CHAR(100) NOT NULL,
85 lastmodified INT NOT NULL
89 CREATE UNIQUE INDEX hottopics_index ON hottopics (pagename, lastmodified)
92 CREATE TABLE hitcount (
93 pagename CHAR(100) NOT NULL,
98 CREATE UNIQUE INDEX hitcount_index ON hitcount (pagename)