-- $Id: schema.psql,v 1.3 2000-06-20 04:39:16 wainstead Exp $

drop table wiki;
drop table archive;
drop table wikilinks;
drop table hottopics;
drop table hitcount;

CREATE TABLE wiki (
        pagename VARCHAR(100) NOT NULL,
        version INT NOT NULL DEFAULT 1,
        flags INT NOT NULL DEFAULT 0,
        author VARCHAR(100),
        lastmodified INT NOT NULL,
        created INT NOT NULL,           
        content TEXT NOT NULL,
        refs TEXT,                      
        PRIMARY KEY (pagename)
        );

CREATE TABLE archive (
        pagename VARCHAR(100) NOT NULL,
        version INT NOT NULL DEFAULT 1,
        flags INT NOT NULL DEFAULT 0,
        author VARCHAR(100),
        lastmodified INT NOT NULL,
        created INT NOT NULL,           
        content TEXT NOT NULL,
        refs TEXT,                      
        PRIMARY KEY (pagename)
        );

CREATE TABLE wikilinks (
        frompage VARCHAR(100) NOT NULL,
        topage VARCHAR(100) NOT NULL,
        PRIMARY KEY (frompage, topage)
        );

CREATE TABLE hottopics (                
        pagename VARCHAR(100) NOT NULL,
        lastmodified INT NOT NULL,
        PRIMARY KEY (pagename, lastmodified)
        );

CREATE TABLE hitcount (                 
        pagename VARCHAR(100) NOT NULL, 
        hits INT NOT NULL DEFAULT 0,    
        PRIMARY KEY (pagename)          
        );

GRANT ALL ON wiki TO nobody;
GRANT ALL ON archive TO nobody;
GRANT ALL ON wikilinks TO nobody;
GRANT ALL ON hottopics TO nobody;
GRANT ALL ON hitcount TO nobody;

GRANT ALL ON wiki TO swain;
GRANT ALL ON archive TO swain;
GRANT ALL ON wikilinks TO swain;
GRANT ALL ON hottopics TO swain;
GRANT ALL ON hitcount TO swain;