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.mysql | |
| 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.mysql')
| -rw-r--r-- | database/database.mysql | 19 |
1 files changed, 16 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql index 523aa6181..00d6ca884 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -361,6 +361,22 @@ CREATE TABLE search_index ( ) 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), |