diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-14 02:11:57 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-14 02:11:57 +0000 |
| commit | f6cea9c614a5a86bc74940e1a7ade8f09481110e (patch) | |
| tree | a228285d215ddeecc2f07fe2d9e83ef25843a972 | |
| parent | 16df4a91ee3d316058a4fd2d420594f98ba82987 (diff) | |
| download | forums-f6cea9c614a5a86bc74940e1a7ade8f09481110e.tar forums-f6cea9c614a5a86bc74940e1a7ade8f09481110e.tar.gz forums-f6cea9c614a5a86bc74940e1a7ade8f09481110e.tar.bz2 forums-f6cea9c614a5a86bc74940e1a7ade8f09481110e.tar.xz forums-f6cea9c614a5a86bc74940e1a7ade8f09481110e.zip | |
Updated schema for session stuff + fix for mysql search result id
git-svn-id: file:///svn/phpbb/trunk@1563 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/db/schemas/ms_access_primer.zip | bin | 92144 -> 93467 bytes | |||
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 9 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 9 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 6 |
4 files changed, 19 insertions, 5 deletions
diff --git a/phpBB/db/schemas/ms_access_primer.zip b/phpBB/db/schemas/ms_access_primer.zip Binary files differindex b9effb0147..2bdccec855 100644 --- a/phpBB/db/schemas/ms_access_primer.zip +++ b/phpBB/db/schemas/ms_access_primer.zip diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index 26c1f870e9..d314d94311 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -312,6 +312,9 @@ CREATE TABLE [phpbb_users] ( [username] [varchar] (25) NOT NULL , [user_password] [varchar] (32) NOT NULL , [user_autologin_key] [varchar] (32) NULL , + [user_session_time] [int] NOT NULL , + [user_session_page] [smallint] NOT NULL , + [user_lastvisit] [int] NOT NULL , [user_regdate] [int] NOT NULL , [user_level] [smallint] NOT NULL , [user_posts] [int] NOT NULL , @@ -319,7 +322,6 @@ CREATE TABLE [phpbb_users] ( [user_style] [int] NULL , [user_lang] [varchar] (255) NULL , [user_dateformat] [varchar] (14) NOT NULL , - [user_lastvisit] [int] NOT NULL , [user_new_privmsg] [smallint] NOT NULL , [user_unread_privmsg] [smallint] NOT NULL , [user_last_privmsg] [int] NOT NULL , @@ -567,6 +569,8 @@ GO ALTER TABLE [phpbb_users] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_users_user_level] DEFAULT (0) FOR [user_level], CONSTRAINT [DF_phpbb_users_user_posts] DEFAULT (0) FOR [user_posts], + CONSTRAINT [DF_phpbb_users_user_session_time] DEFAULT (0) FOR [user_session_time], + CONSTRAINT [DF_phpbb_users_user_session_page] DEFAULT (0) FOR [user_session_page], CONSTRAINT [DF_phpbb_users_user_lastvisit] DEFAULT (0) FOR [user_lastvisit], CONSTRAINT [DF_phpbb_users_user_new_privmsg] DEFAULT (0) FOR [user_new_privmsg], CONSTRAINT [DF_phpbb_users_user_unread_privmsg] DEFAULT (0) FOR [user_unread_privmsg], @@ -636,6 +640,9 @@ GO CREATE INDEX [IX_phpbb_topics_watch] ON [phpbb_topics_watch]([topic_id], [user_id]) ON [PRIMARY] GO + CREATE INDEX [IX_phpbb_users] ON [phpbb_users]([user_session_time]) ON [PRIMARY] +GO + CREATE INDEX [IX_phpbb_user_group] ON [phpbb_user_group]([group_id], [user_id]) ON [PRIMARY] GO diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 65c9fe95e0..6c8848a504 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -243,7 +243,7 @@ CREATE TABLE phpbb_ranks ( # Table structure for table `phpbb_search_results` # CREATE TABLE phpbb_search_results ( - search_id mediumint(8) UNSIGNED NOT NULL default '0', + search_id int(11) UNSIGNED NOT NULL default '0', session_id char(32) NOT NULL default '', search_array text NOT NULL, PRIMARY KEY (search_id), @@ -458,6 +458,9 @@ CREATE TABLE phpbb_users ( username varchar(25) NOT NULL, user_password varchar(32) NOT NULL, user_autologin_key varchar(32), + user_session_time int(11) DEFAULT '0' NOT NULL, + user_session_page smallint(5) DEFAULT '0' NOT NULL, + user_lastvisit int(11) DEFAULT '0' NOT NULL, user_regdate int(11) DEFAULT '0' NOT NULL, user_level tinyint(4) DEFAULT '0', user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, @@ -465,7 +468,6 @@ CREATE TABLE phpbb_users ( user_style tinyint(4), user_lang varchar(255), user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, - user_lastvisit int(11) DEFAULT '0' NOT NULL, user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL, user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL, user_last_privmsg int(11) DEFAULT '0' NOT NULL, @@ -497,7 +499,8 @@ CREATE TABLE phpbb_users ( user_interests varchar(255), user_actkey varchar(32), user_newpasswd varchar(32), - PRIMARY KEY (user_id) + PRIMARY KEY (user_id), + KEY user_session_time (user_session_time) ); diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 952767a3a2..536bb07011 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -447,6 +447,9 @@ CREATE TABLE phpbb_users ( user_regdate int4 DEFAULT '0' NOT NULL, user_password varchar(32) DEFAULT '' NOT NULL, user_autologin_key varchar(32), + user_session_time int4 DEFAULT '0' NOT NULL, + user_session_page int2 DEFAULT '0' NOT NULL, + user_lastvisit int4 DEFAULT '0' NOT NULL, user_email varchar(255), user_icq varchar(15), user_website varchar(100), @@ -460,7 +463,6 @@ CREATE TABLE phpbb_users ( user_yim varchar(255), user_msnm varchar(255), user_posts int4 DEFAULT '0' NOT NULL, - user_lastvisit int4 DEFAULT '0' NOT NULL, user_new_privmsg int2 DEFAULT '0' NOT NULL, user_unread_privmsg int2 DEFAULT '0' NOT NULL, user_last_privmsg int4 DEFAULT '0' NOT NULL, @@ -488,6 +490,8 @@ CREATE TABLE phpbb_users ( CONSTRAINT phpbb_users_pkey PRIMARY KEY (user_id) ); +CREATE INDEX user_session_time_phpbb_users_index ON phpbb_users (user_session_time); + /* -------------------------------------------------------- Table structure for table phpbb_vote_desc -------------------------------------------------------- */ |