diff options
| author | Dries Buytaert <dries@buytaert.net> | 2003-08-20 19:19:13 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2003-08-20 19:19:13 +0000 |
| commit | 0431f0700f204ab9941a4791c887024aa4f83ceb (patch) | |
| tree | 9d2f013bdc3a619164820adcd398b0f344d3df18 /database/database.pgsql | |
| parent | b79b831152f79b412ce35c91193332c66ba94580 (diff) | |
| download | brdo-0431f0700f204ab9941a4791c887024aa4f83ceb.tar.gz brdo-0431f0700f204ab9941a4791c887024aa4f83ceb.tar.bz2 | |
- Committed Jeremy's session patch: this brings us one step closer to having
session for anonymous users.
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 63ec8f7d4..dc08bfc86 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -361,6 +361,19 @@ 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), |