1 -- $Id: schema.psql,v 1.2 2000-06-12 04:19:17 wainstead Exp $
10 pagename VARCHAR(100) NOT NULL,
11 version INT NOT NULL DEFAULT 1,
12 flags INT NOT NULL DEFAULT 0,
14 lastmodified INT NOT NULL,
16 content TEXT NOT NULL,
18 PRIMARY KEY (pagename)
21 CREATE TABLE archive (
22 pagename VARCHAR(100) NOT NULL,
23 content TEXT NOT NULL,
26 lastmodified INT NOT NULL,
27 PRIMARY KEY (pagename)
30 CREATE TABLE wikilinks (
31 frompage VARCHAR(100) NOT NULL,
32 topage VARCHAR(100) NOT NULL,
33 PRIMARY KEY (frompage, topage)
36 CREATE TABLE hottopics (
37 pagename VARCHAR(100) NOT NULL,
38 lastmodified INT NOT NULL,
39 PRIMARY KEY (pagename, lastmodified)
42 CREATE TABLE hitcount (
43 pagename VARCHAR(100) NOT NULL,
44 hits INT NOT NULL DEFAULT 0,
45 PRIMARY KEY (pagename)