[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8_rc5.sql,NONE,1.1 upgrade_schemas_map

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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

Modified Files:
	upgrade_schemas_map.php 
Added Files:
	mysql_schema_upgrade_to_2.8_rc5.sql 
Removed Files:
	mysql_schema_upgrade_to_2.801.sql 
Log Message:
updated install schemes

--- mysql_schema_upgrade_to_2.801.sql DELETED ---

--- NEW FILE: mysql_schema_upgrade_to_2.8_rc5.sql ---
#
# mxBB-Portal - MySQL Schema - Upgrade "2.8 - RC4"
#
# $Id: mysql_schema_upgrade_to_2.8_rc5.sql,v 1.1 2005/09/09 16:49:57 jonohlsson Exp $
#

# ------------------------------------------------------------
#
# Changed Fields in Table `mx_block` (update for new permissions)
#
ALTER TABLE mx_table_block MODIFY auth_view_group VARCHAR(255) NOT NULL DEFAULT '0';
ALTER TABLE mx_table_block MODIFY auth_edit_group VARCHAR(255) NOT NULL DEFAULT '0';
ALTER TABLE mx_table_block MODIFY auth_delete_group VARCHAR(255) NOT NULL DEFAULT '0';

# ------------------------------------------------------------
#
# New Fields in Table `mx_block`
#
ALTER TABLE mx_table_block ADD auth_moderator_group VARCHAR(255) NOT NULL DEFAULT '0';
ALTER TABLE mx_table_block ADD show_title TINYINT(2) UNSIGNED NOT NULL DEFAULT '1';
ALTER TABLE mx_table_block ADD show_block TINYINT(2) UNSIGNED NOT NULL DEFAULT '1';
ALTER TABLE mx_table_block ADD show_stats TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE mx_table_block ADD block_time VARCHAR(255) BINARY NOT NULL DEFAULT '';
ALTER TABLE mx_table_block ADD block_editor_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';

# ------------------------------------------------------------
#
# New/Changed Fields in Table `mx_block_system_parameter` // Maybe this only works for mySQL
#
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 PRIMARY KEY, ADD PRIMARY KEY (block_id, parameter_id, sub_id);

# ------------------------------------------------------------
#
# 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 '';

# ------------------------------------------------------------
#
# Changed Fields in Table `mx_page` (update for new permissions)
#
ALTER TABLE mx_table_page MODIFY auth_view_group VARCHAR(255) NOT NULL DEFAULT '0';

# ------------------------------------------------------------
#
# New Fields in Table `mx_table_menu_categories`
#
ALTER TABLE mx_table_menu_categories ADD cat_url smallint(5) unsigned default '0';
ALTER TABLE mx_table_menu_categories ADD cat_target tinyint(2) unsigned NOT NULL default '0';

# ------------------------------------------------------------
#
# New Fields in Table `mx_module`
#
ALTER TABLE mx_table_module ADD module_version varchar(255) default NULL;
ALTER TABLE mx_table_module ADD module_copy text default NULL;

# ------------------------------------------------------------
#
# Table structure for table `mx_wordlist`
#
CREATE TABLE mx_table_wordlist (
	word_text VARCHAR(50) BINARY NOT NULL DEFAULT '',
	word_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
	word_common TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (word_text),
	KEY word_id (word_id)
);

# ------------------------------------------------------------
#
# Table structure for table `mx_search_results`
#
CREATE TABLE mx_table_search_results (
	search_id INT(11) UNSIGNED NOT NULL DEFAULT '0',
	session_id VARCHAR(32) NOT NULL DEFAULT '',
	search_array TEXT NOT NULL,
	PRIMARY KEY (search_id),
	KEY session_id (session_id)
);

# ------------------------------------------------------------
#
# Table structure for table `mx_wordmatch`
#
CREATE TABLE mx_table_wordmatch (
	block_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	word_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
	title_match TINYINT(1) NOT NULL DEFAULT '0',
	KEY block_id (block_id),
	KEY word_id (word_id)
);

# ------------------------------------------------------------
#
# New Fields in Table `mx_parameter`
#
ALTER TABLE mx_table_parameter ADD parameter_order smallint(5) unsigned NOT NULL default '0';

#
# Delete Table `mx_parameter_option`
#

DROP TABLE IF EXISTS mx_table_parameter_option;
  
# ------------------------------------------------------------
#
# New Fields in Table `mx_portal`
#
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';

#
# Table structure for table 'mx_table_page_templates'
#

DROP TABLE IF EXISTS mx_table_page_templates;
CREATE TABLE `mx_table_page_templates` (
  `page_template_id` smallint(3) unsigned NOT NULL auto_increment,
  `template_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`page_template_id`)
) TYPE=MyISAM;

#
# Dumping data for table 'mx_table_page_templates'
#
INSERT INTO mx_table_page_templates VALUES("1", "NONE");
INSERT INTO mx_table_page_templates VALUES("2", "Two-Columns left1");
INSERT INTO mx_table_page_templates VALUES("3", "Two-Columns right");
INSERT INTO mx_table_page_templates VALUES("4", "Three-Columns");

#
# Table structure for table 'mx_table_column_templates'
#

DROP TABLE IF EXISTS mx_table_column_templates;
CREATE TABLE `mx_table_column_templates` (
  `column_template_id` smallint(5) unsigned NOT NULL auto_increment,
  `column_title` varchar(100) default '0',
  `column_order` smallint(5) unsigned NOT NULL default '0',
  `column_size` varchar(5) default '0',
  `page_template_id` smallint(5) NOT NULL default '0',
  PRIMARY KEY  (`column_template_id`),
  KEY `cat_order` (`column_order`)
) TYPE=MyISAM;


#
# Dumping data for table 'mx_table_column_templates'
#
INSERT INTO mx_table_column_templates VALUES("1", "Left", "40", "200", "2");
INSERT INTO mx_table_column_templates VALUES("2", "Main", "50", "100%", "2");
INSERT INTO mx_table_column_templates VALUES("3", "Main", "10", "100%", "3");
INSERT INTO mx_table_column_templates VALUES("4", "Right", "20", "200", "3");
INSERT INTO mx_table_column_templates VALUES("5", "Left", "10", "180", "4");
INSERT INTO mx_table_column_templates VALUES("6", "Middle", "20", "100%", "4");
INSERT INTO mx_table_column_templates VALUES("7", "Right", "30", "180", "4");

#
# Some fixes related to the navigation menu block being modulized
#
SET module 		= SELECT MAX(module_id)	AS next_id FROM mx_table_module;

SET module.next_id = module.next_id + 1;
INSERT INTO mx_table_module VALUES('{module.next_id}', "Navigation Menu", "modules/mx_navmenu/", "mxBB Navigation Module", "0", NULL, "mzBB Core Module");

SET function = SELECT * FROM mx_table_function WHERE function_file = 'mx_menu_nav.php';

UPDATE mx_table_function
	SET module_id  = '{module.next_id}',
		function_name = 'Navigation Menu',
		function_desc = 'This is the function for Navigation Menu Blocks',
		function_admin = ''
	WHERE function_id = '{function.function_id}';
	
#
# Updating the TextBlocks
#
SET function = SELECT * FROM mx_table_function WHERE function_file = 'mx_textblock_bbcode.php';

UPDATE mx_table_function
	SET function_name = 'TextBlock (phpBB)',
		function_desc = 'BBcodes, html and smilies - defined by phpBB config',
		function_admin = ''
	WHERE function_id = '{function.function_id}';
	
SET function = SELECT * FROM mx_table_function WHERE function_file = 'mx_textblock_html.php';

UPDATE mx_table_function
	SET function_name = 'TextBlock (Html/wysiwyg)',
		function_desc = 'Plain html textblock, or featuring a wysiwyg editor',
		function_admin = ''
	WHERE function_id = '{function.function_id}';

SET function = SELECT * FROM mx_table_function WHERE function_file = 'mx_textblock_multi.php';

UPDATE mx_table_function
	SET function_name = 'TextBlock (Customized)',
		function_desc = 'Textblock, featuring block defined settings',
		function_admin = ''
	WHERE function_id = '{function.function_id}';	
	
#
# Finally, all core blocks have been moved to the modules/mx_coreblocks folder
#
SET function = SELECT * FROM mx_table_module WHERE module_path = './';

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}';	
Index: upgrade_schemas_map.php
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/upgrade_schemas_map.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** upgrade_schemas_map.php	9 Sep 2005 08:57:17 -0000	1.6
--- upgrade_schemas_map.php	9 Sep 2005 16:49:57 -0000	1.7
***************
*** 40,45 ****
  	array('schema' => 'upgrade_to_2.706'	, 'sql' => "SELECT portal_version FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.7.1'	, 'sql' => "SELECT link_target FROM mx_table_menu_nav"),
! 	array('schema' => 'upgrade_to_2.7.4'	, 'sql' => "SELECT page_template_id FROM mx_table_page_templates"),
! 	array('schema' => 'upgrade_to_2.8.RC5'	, 'sql' => "SELECT parameter_order FROM mx_table_parameter")
  );
  
--- 40,44 ----
  	array('schema' => 'upgrade_to_2.706'	, 'sql' => "SELECT portal_version FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.7.1'	, 'sql' => "SELECT link_target FROM mx_table_menu_nav"),
! 	array('schema' => 'upgrade_to_2.8_rc5'	, 'sql' => "SELECT parameter_order FROM mx_table_parameter")
  );

[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8_rc5.sql,NONE,1.1 upgrade_schemas_map

[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8_rc5.sql,NONE,1.1 upgrade_schemas_map.php,1.6,1.7 mysql_schema_upgrade_to_2.801.sql,1.1,NONE