[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8_a2.sql, 1.1, 1.2 mysql_schema_upgrade_to_2.8_b2.sql, 1.2, 1.3 mysql_schema_upgrade_to_2.8_b3.sql, 1.2, 1.3

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv28692/install/schemas

Modified Files:
	mysql_schema_upgrade_to_2.8_a2.sql 
	mysql_schema_upgrade_to_2.8_b2.sql 
	mysql_schema_upgrade_to_2.8_b3.sql 
Log Message:
Fixes

Index: mysql_schema_upgrade_to_2.8_a2.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_a2.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_schema_upgrade_to_2.8_a2.sql	4 Sep 2006 16:48:43 -0000	1.1
--- mysql_schema_upgrade_to_2.8_a2.sql	16 Sep 2006 17:59:59 -0000	1.2
***************
*** 50,52 ****
  # New Fields in Table `mx_table_parameter`
  #
! ALTER TABLE mx_table_parameter ADD parameter_auth tinyint(2) NOT NULL default '0';
--- 50,52 ----
  # New Fields in Table `mx_table_parameter`
  #
! ALTER TABLE mx_table_parameter ADD parameter_auth tinyint(2) NOT NULL default '0' AFTER parameter_function;

Index: mysql_schema_upgrade_to_2.8_b3.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_b3.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_schema_upgrade_to_2.8_b3.sql	3 May 2006 09:17:29 -0000	1.2
--- mysql_schema_upgrade_to_2.8_b3.sql	16 Sep 2006 17:59:59 -0000	1.3
***************
*** 81,84 ****
--- 81,88 ----
  # New Fields in Table `mx_page`
  ALTER TABLE mx_table_page ADD page_main_layout varchar(255) default '' AFTER page_header;
+ ALTER TABLE mx_table_page MODIFY page_header varchar(255) default '';
+ ALTER TABLE mx_table_page MODIFY phpbb_stats tinyint(2) NOT NULL default '-1';
+ # Whats the Field Drop syntax?????????????????????????????
+ #ALTER TABLE mx_table_page DELETE page_graph_border;
  
  # ------------------------------------------------------------

Index: mysql_schema_upgrade_to_2.8_b2.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_b2.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_schema_upgrade_to_2.8_b2.sql	5 Apr 2006 21:58:37 -0000	1.2
--- mysql_schema_upgrade_to_2.8_b2.sql	16 Sep 2006 17:59:59 -0000	1.3
***************
*** 7,14 ****
  # ------------------------------------------------------------
  #
! # Removed Fields from Table `mx_page`
! # Whats the Field Drop syntax?????????????????????????????
! #ALTER TABLE mx_table_page ADD ip_filter VARCHAR(255) NOT NULL DEFAULT '';
! ALTER TABLE mx_table_page ADD navigation_block smallint(5) unsigned NOT NULL default '0';
  
  # ------------------------------------------------------------
--- 7,12 ----
  # ------------------------------------------------------------
  #
! # Updated Fields from Table `mx_page`
! ALTER TABLE mx_table_page ADD navigation_block smallint(5) unsigned NOT NULL default '0' AFTER page_main_layout;
  
  # ------------------------------------------------------------