From b474c1219262a87fbb181bb18ea5ec54f336521a Mon Sep 17 00:00:00 2001
From: wainstead <wainstead@96ab9672-09ca-45d6-a79d-3d69d39ca109>
Date: Sat, 10 Jun 2000 03:49:29 +0000
Subject: [PATCH] Initial version of the schema for Postgresql.

git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@39 96ab9672-09ca-45d6-a79d-3d69d39ca109
---
 schemas/schema.psql | 45 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 schemas/schema.psql

diff --git a/schemas/schema.psql b/schemas/schema.psql
new file mode 100644
index 000000000..e75290467
--- /dev/null
+++ b/schemas/schema.psql
@@ -0,0 +1,45 @@
+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,
+        content TEXT NOT NULL,
+        refs TEXT,
+        author VARCHAR(100),            
+        lastmodified INT NOT NULL,
+        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)          
+        );
+
-- 
2.45.0