|
From: Jon O. <jon...@us...> - 2006-09-04 16:48:52
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv21460/install/schemas Modified Files: upgrade_schemas_map.php Added Files: mysql_schema_upgrade_to_2.8_a1.sql mysql_schema_upgrade_to_2.8_a2.sql Removed Files: mssql_schema_install.sql mssql_schema_install_2.7.1.sql mssql_schema_install_2.7.2.sql mssql_schema_install_2.7.3.sql mysql_schema_upgrade_to_2.8_rc5.sql mysql_schema_upgrade_to_2.8_rc7.sql Log Message: Version RC1 --- mssql_schema_install_2.7.2.sql DELETED --- --- mssql_schema_install_2.7.3.sql DELETED --- Index: upgrade_schemas_map.php =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/upgrade_schemas_map.php,v retrieving revision 1.12 retrieving revision 1.13 diff -C2 -d -r1.12 -r1.13 *** upgrade_schemas_map.php 15 Aug 2006 09:11:34 -0000 1.12 --- upgrade_schemas_map.php 4 Sep 2006 16:48:43 -0000 1.13 *************** *** 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.8_rc5' , 'sql' => "SELECT parameter_order FROM mx_table_parameter"), ! array('schema' => 'upgrade_to_2.8_rc7' , 'sql' => "SELECT phpbb_stats FROM mx_table_page"), array('schema' => 'upgrade_to_2.8_b2' , 'sql' => "SELECT overall_header FROM mx_table_portal"), array('schema' => 'upgrade_to_2.8_b3' , 'sql' => "SELECT main_layout FROM mx_table_portal") --- 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.8_a1' , 'sql' => "SELECT parameter_order FROM mx_table_parameter"), ! array('schema' => 'upgrade_to_2.8_a2' , 'sql' => "SELECT phpbb_stats FROM mx_table_page"), array('schema' => 'upgrade_to_2.8_b2' , 'sql' => "SELECT overall_header FROM mx_table_portal"), array('schema' => 'upgrade_to_2.8_b3' , 'sql' => "SELECT main_layout FROM mx_table_portal") --- mssql_schema_install.sql DELETED --- --- mysql_schema_upgrade_to_2.8_rc7.sql DELETED --- --- mssql_schema_install_2.7.1.sql DELETED --- --- mysql_schema_upgrade_to_2.8_rc5.sql DELETED --- --- NEW FILE: mysql_schema_upgrade_to_2.8_a2.sql --- # # mxBB-Portal - MySQL Schema - Upgrade "2.8 - RC7" # # $Id: mysql_schema_upgrade_to_2.8_a2.sql,v 1.1 2006/09/04 16:48:43 jonohlsson Exp $ # # ------------------------------------------------------------ # # New Fields in Table `mx_page` # ALTER TABLE mx_table_page ADD ip_filter VARCHAR(255) NOT NULL DEFAULT ''; # ------------------------------------------------------------ # # New Fields in Table `mx_portal` # ALTER TABLE mx_table_portal ADD mod_rewrite smallint(2) NOT NULL DEFAULT '0'; # ------------------------------------------------------------ # # Changed Fields in Table `mx_block` (updated type) # 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'; ALTER TABLE mx_table_block MODIFY auth_edit_group smallint(5) NOT NULL default '0'; ALTER TABLE mx_table_block MODIFY auth_delete_group smallint(5) NOT NULL default '0'; ALTER TABLE mx_table_block MODIFY auth_moderator_group smallint(5) NOT NULL default '0'; # ------------------------------------------------------------ # # Changed Fields in Table `mx_page` (updated type) # 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'; ALTER TABLE mx_table_page ADD phpbb_stats smallint(2) NOT NULL DEFAULT '-1'; # ------------------------------------------------------------ # # Changed Fields in Table `mx_menu_nav` (updated type) # ALTER TABLE mx_table_menu_nav MODIFY auth_view tinyint(2) NOT NULL default '0'; ALTER TABLE mx_table_menu_nav MODIFY auth_view_group smallint(5) NOT NULL default '0'; # ------------------------------------------------------------ # # New Fields in Table `mx_table_parameter` # ALTER TABLE mx_table_parameter ADD parameter_auth tinyint(2) NOT NULL default '0'; --- NEW FILE: mysql_schema_upgrade_to_2.8_a1.sql --- # # mxBB-Portal - MySQL Schema - Upgrade "2.8 - RC4" # # $Id: mysql_schema_upgrade_to_2.8_a1.sql,v 1.1 2006/09/04 16:48:43 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 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); # ------------------------------------------------------------ # # 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 ''; # ------------------------------------------------------------ # # 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' AFTER top_phpbb_links; # # 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 left"); 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 module = SELECT * FROM mx_table_module WHERE module_path = './'; 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}'; |