[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8_rc5.sql,1.2,1.3 mysql_schema_upgrade_to_2.8_rc7.sql,1.4,1.5

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

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

Modified Files:
	mysql_schema_upgrade_to_2.8_rc5.sql 
	mysql_schema_upgrade_to_2.8_rc7.sql 
Log Message:
schemas and upgrade data are validated

Index: mysql_schema_upgrade_to_2.8_rc5.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_rc5.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_schema_upgrade_to_2.8_rc5.sql	20 Sep 2005 15:36:47 -0000	1.2
--- mysql_schema_upgrade_to_2.8_rc5.sql	9 Dec 2005 00:22:23 -0000	1.3
***************
*** 30,33 ****
--- 30,35 ----
  ALTER TABLE mx_table_block_system_parameter CHANGE bbcode_uid parameter_opt TEXT;
  ALTER TABLE mx_table_block_system_parameter ADD sub_id INT(255) UNSIGNED NOT NULL DEFAULT '0';
+ ALTER TABLE mx_table_block_system_parameter DROP INDEX block_id;
+ ALTER TABLE mx_table_block_system_parameter DROP INDEX parameter_id;
  ALTER TABLE mx_table_block_system_parameter DROP PRIMARY KEY, ADD PRIMARY KEY (block_id, parameter_id, sub_id);
  
***************
*** 36,41 ****
  # New Fields in Table `mx_page` (update for new permissions)
  #
! ALTER TABLE mx_table_page ADD page_desc varchar(255) default NULL;
! ALTER TABLE mx_table_page ADD auth_moderator_group varchar(255) NOT NULL default '0';
  ALTER TABLE mx_table_page ADD page_graph_border varchar(255) NOT NULL default '';
  
--- 38,43 ----
  # New Fields in Table `mx_page` (update for new permissions)
  #
! ALTER TABLE mx_table_page ADD page_desc varchar(255) default NULL AFTER page_name;
! ALTER TABLE mx_table_page ADD auth_moderator_group varchar(255) NOT NULL default '0' AFTER auth_view_group;
  ALTER TABLE mx_table_page ADD page_graph_border varchar(255) NOT NULL default '';
  
***************
*** 113,117 ****
  #
  ALTER TABLE mx_table_portal ADD portal_recached VARCHAR(255) BINARY NOT NULL DEFAULT '';
! ALTER TABLE mx_table_portal ADD mx_use_cache smallint(5) unsigned NOT NULL default '1';
  
  #
--- 115,119 ----
  #
  ALTER TABLE mx_table_portal ADD portal_recached VARCHAR(255) BINARY NOT NULL DEFAULT '';
! ALTER TABLE mx_table_portal ADD mx_use_cache smallint(5) unsigned NOT NULL default '1' AFTER top_phpbb_links;
  
  #
***************
*** 213,217 ****
  UPDATE mx_table_module
  	SET module_name = 'Core Blocks',
! 	SET module_desc = 'mxBB Core (standard) Module',
! 	SET module_path = 'modules/mx_coreblocks/',
! 	WHERE module_id = '{module.module_id}';	
\ No newline at end of file
--- 215,230 ----
  UPDATE mx_table_module
  	SET module_name = 'Core Blocks',
! 	 	module_desc = 'mxBB Core (standard) Module',
! 	 	module_path = 'modules/mx_coreblocks/',
! 	 	module_include_admin = '0'
! 	WHERE module_id = '{module.module_id}';	
! 	
! #
! # Minor mistake for the textblocks
! #
! SET module = SELECT * FROM mx_table_module WHERE module_path = 'modules/mx_textblocks/';	
! 
! UPDATE mx_table_module
! 	SET	module_include_admin = '0'
! 	WHERE module_id = '{module.module_id}';		
! 	
\ No newline at end of file

Index: mysql_schema_upgrade_to_2.8_rc7.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_rc7.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** mysql_schema_upgrade_to_2.8_rc7.sql	8 Dec 2005 21:41:28 -0000	1.4
--- mysql_schema_upgrade_to_2.8_rc7.sql	9 Dec 2005 00:22:23 -0000	1.5
***************
*** 22,27 ****
  #
  ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0';
  
  ALTER TABLE mx_table_block MODIFY auth_view_group smallint(5) NOT NULL default '0';
--- 22,27 ----
  #
  ALTER TABLE mx_table_block MODIFY auth_view tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_edit tinyint(2) NOT NULL default '0';
! ALTER TABLE mx_table_block MODIFY auth_delete tinyint(2) NOT NULL default '0';
  
  ALTER TABLE mx_table_block MODIFY auth_view_group smallint(5) NOT NULL default '0';
***************
*** 36,39 ****
--- 36,40 ----
  ALTER TABLE mx_table_page MODIFY auth_view tinyint(2) NOT NULL default '0';
  ALTER TABLE mx_table_page MODIFY auth_view_group smallint(5) NOT NULL default '0';
+ ALTER TABLE mx_table_page MODIFY auth_moderator_group smallint(5) NOT NULL default '0';
  
  # ------------------------------------------------------------