phpbb-php5mod-cvs-checkins

[Josh <jel...@us...>]

Update of /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1999/install_/schemas

Modified Files:
	mssql_basic.sql mssql_schema.sql mysql_basic.sql 
	mysql_schema.sql postgres_basic.sql postgres_schema.sql 
Log Message:
Schema updates

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_schema.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_schema.sql	9 May 2005 00:33:17 -0000	1.2
--- mysql_schema.sql	31 Oct 2005 21:35:11 -0000	1.3
***************
*** 312,315 ****
--- 312,328 ----
  );
  
+ # --------------------------------------------------------
+ #
+ # Table structure for table `phpbb_sessions_keys`
+ #
+ CREATE TABLE phpbb_sessions_keys (
+   key_id varchar(32) DEFAULT '0' NOT NULL,
+   user_id mediumint(8) DEFAULT '0' NOT NULL,
+   last_ip varchar(8) DEFAULT '0' NOT NULL,
+   last_login int(11) DEFAULT '0' NOT NULL,
+   PRIMARY KEY (key_id, user_id),
+   KEY last_login (last_login)
+ );
+ 
  
  # --------------------------------------------------------

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_schema.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** postgres_schema.sql	9 May 2005 00:33:17 -0000	1.2
--- postgres_schema.sql	31 Oct 2005 21:35:11 -0000	1.3
***************
*** 296,299 ****
--- 296,311 ----
  CREATE INDEX session_id_ip_user_id_phpbb_sessions_index ON phpbb_sessions (session_id, session_ip, session_user_id);
  
+ /* --------------------------------------------------------
+   Table structure for table phpbb_sessions_keys
+ -------------------------------------------------------- */
+ CREATE TABLE phpbb_sessions_keys (
+   key_id char(32) DEFAULT '0' NOT NULL,
+   user_id int4 DEFAULT '0' NOT NULL,
+   last_ip char(8) DEFAULT '0' NOT NULL,
+   last_login int4 DEFAULT '0' NOT NULL,
+   CONSTRAINT phpbb_sessions_keys_pkey PRIMARY KEY (key_id, user_id)
+ );
+ CREATE INDEX last_login_phpbb_sessions_keys_index ON phpbb_sessions_keys (last_login);
+ 
  
  /* --------------------------------------------------------
***************
*** 490,497 ****
     user_avatar varchar(100),
     user_avatar_type int2 DEFAULT '0' NOT NULL,
!    user_level int4 DEFAULT '1',
     user_lang varchar(255),
     user_timezone decimal(5) DEFAULT '0' NOT NULL,
!    user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL,
     user_notify_pm int2 DEFAULT '0' NOT NULL,
     user_popup_pm int2 DEFAULT '0' NOT NULL,
--- 502,509 ----
     user_avatar varchar(100),
     user_avatar_type int2 DEFAULT '0' NOT NULL,
!    user_level int4 DEFAULT '0',
     user_lang varchar(255),
     user_timezone decimal(5) DEFAULT '0' NOT NULL,
!    user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
     user_notify_pm int2 DEFAULT '0' NOT NULL,
     user_popup_pm int2 DEFAULT '0' NOT NULL,

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_schema.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mssql_schema.sql	9 May 2005 00:33:17 -0000	1.2
--- mssql_schema.sql	31 Oct 2005 21:35:11 -0000	1.3
***************
*** 196,199 ****
--- 196,207 ----
  GO
  
+ CREATE TABLE [phpbb_sessions_keys] (
+   [key_id] [char] (32) NOT NULL ,
+   [user_id] [int] NOT NULL ,
+   [last_ip] [char] (8) NOT NULL ,
+   [last_login] [int] NOT NULL
+ ) ON [PRIMARY]
+ GO
+ 
  CREATE TABLE [phpbb_smilies] (
  	[smilies_id] [int] IDENTITY (1, 1) NOT NULL ,
***************
*** 617,620 ****
--- 625,629 ----
  	CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (0) FOR [user_notify_pm],
  	CONSTRAINT [DF_phpbb_users_user_popup_pm] DEFAULT (1) FOR [user_popup_pm],
+ 	CONSTRAINT [DF_phpbb_users_user_dateformat] DEFAULT('d M Y H:i') FOR [user_dateformat],
  	CONSTRAINT [DF_phpbb_users_user_avatar_type] DEFAULT (0) FOR [user_avatar_type]
  GO
***************
*** 677,680 ****
--- 686,696 ----
  GO
  
+  CREATE  INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([key_id], [user_id]) ON [PRIMARY]
+ GO
+ 
+  CREATE  INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
+ GO
+ 
+ 
   CREATE  INDEX [IX_phpbb_user_group] ON [phpbb_user_group]([group_id], [user_id]) ON [PRIMARY]
  GO

Index: postgres_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_basic.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** postgres_basic.sql	19 Jul 2005 23:14:52 -0000	1.8
--- postgres_basic.sql	31 Oct 2005 21:35:11 -0000	1.9
***************
*** 26,29 ****
--- 26,31 ----
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
***************
*** 64,69 ****
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.17');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5');
  
  -- Categories
--- 66,71 ----
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.18');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.18.5');
  
  -- Categories

Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_basic.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** mysql_basic.sql	19 Jul 2005 23:14:52 -0000	1.8
--- mysql_basic.sql	31 Oct 2005 21:35:11 -0000	1.9
***************
*** 25,28 ****
--- 25,30 ----
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
***************
*** 63,68 ****
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.17');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5');
  
  
--- 65,70 ----
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.18');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.18.5');
  
  

Index: mssql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_basic.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** mssql_basic.sql	19 Jul 2005 23:14:52 -0000	1.8
--- mssql_basic.sql	31 Oct 2005 21:35:11 -0000	1.9
***************
*** 43,46 ****
--- 43,48 ----
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','you...@yo...');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1');
+ INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
***************
*** 70,75 ****
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.17');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5');
  
  /*
--- 72,77 ----
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
  INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.18');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.18.5');
  
  /*