From 0431f0700f204ab9941a4791c887024aa4f83ceb Mon Sep 17 00:00:00 2001 From: Dries Buytaert 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.mysql | 19 ++++++++++++++++--- 1 file changed, 16 insertions(+), 3 deletions(-) (limited to 'database/database.mysql') diff --git a/database/database.mysql b/database/database.mysql index 523aa6181..00d6ca884 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -360,6 +360,22 @@ CREATE TABLE search_index ( KEY word (word) ) TYPE=MyISAM; +-- +-- Table structure for table 'sessesions' +-- + + +CREATE TABLE sessions ( + uid int(10) unsigned NOT NULL, + sid varchar(32) NOT NULL default '', + hostname varchar(128) NOT NULL default '', + timestamp int(11) NOT NULL default '0', + session text, + KEY uid (uid), + KEY sid (sid(4)), + KEY timestamp (timestamp) +) TYPE=MyISAM; + -- -- Table structure for table 'sequences' -- @@ -491,14 +507,11 @@ CREATE TABLE users ( theme varchar(255) NOT NULL default '', signature varchar(255) NOT NULL default '', timestamp int(11) NOT NULL default '0', - hostname varchar(128) NOT NULL default '', status tinyint(4) 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, data text, rid int(10) unsigned NOT NULL default '0', PRIMARY KEY (uid), -- cgit v1.2.3