[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_schema.sql,1.9,1.10 mysql_schema.sql,1.7,1.8 postgres_schema.sql,1.6,1.7

[Paul S. O. <ps...@us...>]

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);
  
  /* --------------------------------------------------------