[Phpbb-php5mod-cvs-checkins] phpbb-php5/install/schemas mssql_basic.sql,1.5,1.6 mssql_schema.sql,1.1,1.2 mysql_basic.sql,1.5,1.6 mysql_schema.sql,1.1,1.2 postgres_basic.sql,1.5,1.6 postgres_schema.sql,1.1,1.2

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

Update of /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32438/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 changes for 2.0.15

Index: postgres_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_basic.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** postgres_basic.sql	16 Apr 2005 21:09:05 -0000	1.5
--- postgres_basic.sql	9 May 2005 00:33:17 -0000	1.6
***************
*** 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.14');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.14.3');
  
  -- Categories
--- 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.15');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.15.3');
  
  -- Categories

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_schema.sql	29 Jul 2004 22:36:20 -0000	1.1
--- mysql_schema.sql	9 May 2005 00:33:17 -0000	1.2
***************
*** 306,309 ****
--- 306,310 ----
     session_page int(11) DEFAULT '0' NOT NULL,
     session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
+    session_admin tinyint(1) DEFAULT '0' NOT NULL,
     PRIMARY KEY (session_id),
     KEY session_user_id (session_user_id),

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** postgres_schema.sql	29 Jul 2004 22:36:20 -0000	1.1
--- postgres_schema.sql	9 May 2005 00:33:17 -0000	1.2
***************
*** 290,293 ****
--- 290,294 ----
     session_page int4 DEFAULT '0' NOT NULL,
     session_logged_in int2 DEFAULT '0' NOT NULL,
+    session_admin int2 DEFAULT '0' NOT NULL,
     CONSTRAINT phpbb_session_pkey PRIMARY KEY (session_id)
  );

Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_basic.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** mysql_basic.sql	16 Apr 2005 21:09:05 -0000	1.5
--- mysql_basic.sql	9 May 2005 00:33:17 -0000	1.6
***************
*** 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.14');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.14.3');
  
  
--- 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.15');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.15.4');
  
  

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mssql_schema.sql	29 Jul 2004 22:36:20 -0000	1.1
--- mssql_schema.sql	9 May 2005 00:33:17 -0000	1.2
***************
*** 191,195 ****
  	[session_ip] [char] (8) NOT NULL ,
  	[session_page] [int] NULL ,
! 	[session_logged_in] [smallint] NULL
  ) ON [PRIMARY]
  GO
--- 191,196 ----
  	[session_ip] [char] (8) NOT NULL ,
  	[session_page] [int] NULL ,
! 	[session_logged_in] [smallint] NULL,
! 	[session_admin] [int] NOT NULL,
  ) ON [PRIMARY]
  GO

Index: mssql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_basic.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** mssql_basic.sql	16 Apr 2005 21:09:05 -0000	1.5
--- mssql_basic.sql	9 May 2005 00:33:17 -0000	1.6
***************
*** 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.14');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.14.3');
  
  /*
--- 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.15');
! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.15.4');
  
  /*