1 # $Id: minisql.sql,v 1.1 2001-12-03 04:05:38 wainstead Exp $
6 drop table archivepages\g
11 drop table wikiscore\g
13 # metadata about the page
16 pagename CHAR(100) NOT NULL,
20 lastmodified INT NOT NULL,
26 CREATE UNIQUE INDEX wiki_index ON wiki (pagename)
29 # archive for page metadata
31 CREATE TABLE archive (
32 pagename CHAR(100) NOT NULL,
36 lastmodified INT NOT NULL,
42 CREATE UNIQUE INDEX archive_index ON archive (pagename, version)
46 # table for the pages themselves... stored in lines
48 CREATE TABLE wikipages (
49 pagename CHAR(100) NOT NULL,
55 CREATE UNIQUE INDEX wp_idx ON wikipages (pagename, lineno)
59 # archive of page lines
61 CREATE TABLE archivepages (
62 pagename CHAR(100) NOT NULL,
68 CREATE UNIQUE INDEX ap_idx ON archivepages (pagename, lineno)
73 # tables below are not yet used
75 CREATE TABLE wikilinks (
76 frompage CHAR(100) NOT NULL,
77 topage CHAR(100) NOT NULL
81 CREATE UNIQUE INDEX wikilinks_index ON wikilinks (frompage, topage)
84 CREATE TABLE hottopics (
85 pagename CHAR(100) NOT NULL,
86 lastmodified INT NOT NULL
90 CREATE UNIQUE INDEX hottopics_index ON hottopics (pagename, lastmodified)
93 CREATE TABLE hitcount (
94 pagename CHAR(100) NOT NULL,
99 CREATE UNIQUE INDEX hitcount_index ON hitcount (pagename)
102 CREATE TABLE wikiscore (
103 pagename CHAR(100) NOT NULL,
108 CREATE UNIQUE INDEX hitcount_index ON wikiscore (pagename)