1 # $Id: minisql-initialize.sql,v 1.1 2004-07-22 16:49:19 dfrankow Exp $
3 # metadata about the page
6 pagename CHAR(100) NOT NULL,
10 lastmodified INT NOT NULL,
16 CREATE UNIQUE INDEX wiki_index ON wiki (pagename)
19 # archive for page metadata
21 CREATE TABLE archive (
22 pagename CHAR(100) NOT NULL,
26 lastmodified INT NOT NULL,
32 CREATE UNIQUE INDEX archive_index ON archive (pagename, version)
36 # table for the pages themselves... stored in lines
38 CREATE TABLE wikipages (
39 pagename CHAR(100) NOT NULL,
45 CREATE UNIQUE INDEX wp_idx ON wikipages (pagename, lineno)
49 # archive of page lines
51 CREATE TABLE archivepages (
52 pagename CHAR(100) NOT NULL,
58 CREATE UNIQUE INDEX ap_idx ON archivepages (pagename, lineno)
63 # tables below are not yet used
65 CREATE TABLE wikilinks (
66 frompage CHAR(100) NOT NULL,
67 topage CHAR(100) NOT NULL
71 CREATE UNIQUE INDEX wikilinks_index ON wikilinks (frompage, topage)
74 CREATE TABLE hottopics (
75 pagename CHAR(100) NOT NULL,
76 lastmodified INT NOT NULL
80 CREATE UNIQUE INDEX hottopics_index ON hottopics (pagename, lastmodified)
83 CREATE TABLE hitcount (
84 pagename CHAR(100) NOT NULL,
89 CREATE UNIQUE INDEX hitcount_index ON hitcount (pagename)
92 CREATE TABLE wikiscore (
93 pagename CHAR(100) NOT NULL,
98 CREATE UNIQUE INDEX hitcount_index ON wikiscore (pagename)