[Phpbb-php5mod-cvs-checkins] phpbb-php5/install/schemas mssql_basic.sql,1.9,1.10 mssql_schema.sql,1.3,1.4 mysql_basic.sql,1.9,1.10 mysql_schema.sql,1.3,1.4 postgres_basic.sql,1.9,1.10 postgres_schema.sql,1.3,1.4

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

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

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

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mysql_schema.sql	31 Oct 2005 21:35:11 -0000	1.3
--- mysql_schema.sql	31 Dec 2005 02:10:06 -0000	1.4
***************
*** 521,524 ****
--- 521,526 ----
     user_actkey varchar(32),
     user_newpasswd varchar(32),
+    user_last_login_try int(11) NOT NULL DEFAULT '0',
+    user_login_tries smallint(5) UNSIGNED NOT NULL DEFAULT '0'
     PRIMARY KEY (user_id),
     KEY user_session_time (user_session_time)

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** postgres_schema.sql	31 Oct 2005 21:35:11 -0000	1.3
--- postgres_schema.sql	31 Dec 2005 02:10:06 -0000	1.4
***************
*** 511,514 ****
--- 511,516 ----
     user_actkey varchar(32),
     user_newpasswd varchar(32),
+    user_login_tries int2,
+    user_last_login_try int4 DEFAULT '0',
     CONSTRAINT phpbb_users_pkey PRIMARY KEY (user_id)
  );

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mssql_schema.sql	31 Oct 2005 21:35:11 -0000	1.3
--- mssql_schema.sql	31 Dec 2005 02:10:06 -0000	1.4
***************
*** 370,374 ****
  	[user_actkey] [varchar] (32) NULL ,
  	[user_newpasswd] [varchar] (32) NULL ,
! 	[user_notify] [smallint] NOT NULL
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  GO
--- 370,376 ----
  	[user_actkey] [varchar] (32) NULL ,
  	[user_newpasswd] [varchar] (32) NULL ,
! 	[user_notify] [smallint] NOT NULL ,
! 	[user_last_login_try] [int] NOT NULL ,
! 	[user_login_tries] [smallint] NOT NULL
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  GO
***************
*** 689,693 ****
  GO
  
!  CREATE  INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
  GO
  
--- 691,695 ----
  GO
  
!  CREATE  INDEX [IX_phpbb_sessions_keys_1] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
  GO
  

Index: postgres_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_basic.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** postgres_basic.sql	31 Oct 2005 21:35:11 -0000	1.9
--- postgres_basic.sql	31 Dec 2005 02:10:06 -0000	1.10
***************
*** 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
--- 66,73 ----
  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.19');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.19.5');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
  
  -- Categories

Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_basic.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** mysql_basic.sql	31 Oct 2005 21:35:11 -0000	1.9
--- mysql_basic.sql	31 Dec 2005 02:10:06 -0000	1.10
***************
*** 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');
  
  
--- 65,72 ----
  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.19');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.19.5');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
  
  

Index: mssql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_basic.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** mssql_basic.sql	31 Oct 2005 21:35:11 -0000	1.9
--- mssql_basic.sql	31 Dec 2005 02:10:06 -0000	1.10
***************
*** 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');
  
  /*
--- 72,79 ----
  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.19');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.19.5');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
  
  /*