-- $Id: schema.psql,v 1.7 2001-07-12 03:25:11 wainstead Exp $

drop table phpwiki_pages;
drop table phpwiki_archive;
drop table phpwiki_links;
drop table phpwiki_hottopics;
drop table phpwiki_hitcount;
drop table phpwiki_score;

CREATE TABLE phpwiki_pages (
        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 phpwiki_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 phpwiki_links (
        frompage VARCHAR(100) NOT NULL,
        topage VARCHAR(100) NOT NULL,
        PRIMARY KEY (frompage, topage)
        );

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

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

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


GRANT ALL ON phpwiki_pages TO nobody;
GRANT ALL ON phpwiki_archive TO nobody;
GRANT ALL ON phpwiki_links TO nobody;
GRANT ALL ON phpwiki_hottopics TO nobody;
GRANT ALL ON phpwiki_hitcount TO nobody;
GRANT ALL ON phpwiki_score TO nobody;