|
From: Paul S. O. <ps...@us...> - 2001-12-14 02:10:33
|
Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv5455/db/schemas
Modified Files:
mssql_schema.sql mysql_schema.sql postgres_schema.sql
Log Message:
Updated schema for session stuff + fix for mysql search result id
Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** mssql_schema.sql 2001/12/11 02:41:47 1.9
--- mssql_schema.sql 2001/12/14 02:10:30 1.10
***************
*** 313,316 ****
--- 313,319 ----
[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 ,
***************
*** 320,324 ****
[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 ,
--- 323,326 ----
***************
*** 568,571 ****
--- 570,575 ----
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],
***************
*** 635,638 ****
--- 639,645 ----
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
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** mysql_schema.sql 2001/12/11 02:41:47 1.7
--- mysql_schema.sql 2001/12/14 02:10:30 1.8
***************
*** 244,248 ****
#
CREATE TABLE phpbb_search_results (
! search_id mediumint(8) UNSIGNED NOT NULL default '0',
session_id char(32) NOT NULL default '',
search_array text NOT NULL,
--- 244,248 ----
#
CREATE TABLE phpbb_search_results (
! search_id int(11) UNSIGNED NOT NULL default '0',
session_id char(32) NOT NULL default '',
search_array text NOT NULL,
***************
*** 459,462 ****
--- 459,465 ----
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',
***************
*** 466,470 ****
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,
--- 469,472 ----
***************
*** 498,502 ****
user_actkey varchar(32),
user_newpasswd varchar(32),
! PRIMARY KEY (user_id)
);
--- 500,505 ----
user_actkey varchar(32),
user_newpasswd varchar(32),
! PRIMARY KEY (user_id),
! KEY user_session_time (user_session_time)
);
Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** postgres_schema.sql 2001/12/10 21:53:27 1.6
--- postgres_schema.sql 2001/12/14 02:10:30 1.7
***************
*** 448,451 ****
--- 448,454 ----
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),
***************
*** 461,465 ****
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,
--- 464,467 ----
***************
*** 488,491 ****
--- 490,495 ----
CONSTRAINT phpbb_users_pkey PRIMARY KEY (user_id)
);
+
+ CREATE INDEX user_session_time_phpbb_users_index ON phpbb_users (user_session_time);
/* --------------------------------------------------------
|