From 0431f0700f204ab9941a4791c887024aa4f83ceb Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Wed, 20 Aug 2003 19:19:13 +0000
Subject: - Committed Jeremy's session patch: this brings us one step closer to
 having   session for anonymous users.

---
 database/database.pgsql | 16 +++++++++++++---
 1 file changed, 13 insertions(+), 3 deletions(-)

(limited to 'database/database.pgsql')

diff --git a/database/database.pgsql b/database/database.pgsql
index 63ec8f7d4..dc08bfc86 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -360,6 +360,19 @@ CREATE TABLE search_index (
 CREATE INDEX search_index_lno_idx ON search_index(lno);
 CREATE INDEX search_index_word_idx ON search_index(word);
 
+--
+-- Table structure for sessions
+--
+
+CREATE TABLE sessions (
+  uid integer NOT NULL,
+  sid varchar(32) NOT NULL default '',
+  hostname varchar(128) NOT NULL default '',
+  timestamp integer NOT NULL default '0',
+  session text,
+  PRIMARY KEY (sid)
+);
+
 --
 -- Table structure for sequences
 -- This is only used under MySQL, co commented out
@@ -494,14 +507,11 @@ CREATE TABLE users (
   theme varchar(255) NOT NULL default '',
   signature varchar(255) NOT NULL default '',
   timestamp integer NOT NULL default '0',
-  hostname varchar(128) NOT NULL default '',
   status smallint NOT NULL default '0',
   timezone varchar(8) default NULL,
   rating decimal(8,2) default NULL,
   language char(2) NOT NULL default '',
-  sid varchar(32) NOT NULL default '',
   init varchar(64) default '',
-  session text default '',
   data text default '',
   rid integer NOT NULL default '0',
   PRIMARY KEY  (uid),
-- 
cgit v1.2.3