Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv23964/install/schemas Modified Files: mysql_schema_upgrade_to_2.8_a1.sql 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: improved upgrade method, solving missing page.page_navigation column 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.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** mysql_schema_upgrade_to_2.8_a2.sql 3 Dec 2006 21:26:17 -0000 1.3 --- mysql_schema_upgrade_to_2.8_a2.sql 28 Jan 2007 19:53:33 -0000 1.4 *************** *** 1,4 **** # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8 - RC7" # # $Id$ --- 1,4 ---- # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8 - a2" # # $Id$ 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.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** mysql_schema_upgrade_to_2.8_b3.sql 16 Sep 2006 17:59:59 -0000 1.3 --- mysql_schema_upgrade_to_2.8_b3.sql 28 Jan 2007 19:53:33 -0000 1.4 *************** *** 1,4 **** # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8.0 - beta3" # # $Id$ --- 1,4 ---- # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8.0 - b3" # # $Id$ *************** *** 90,92 **** --- 90,98 ---- # New Fields in Table `mx_portal` # + ALTER TABLE mx_table_portal ADD navigation_block smallint(5) unsigned NOT NULL default '0'; ALTER TABLE mx_table_portal ADD main_layout varchar(255) default 'mx_main_layout.tpl' AFTER overall_header; + + # ------------------------------------------------------------ + # + # 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; 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.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** mysql_schema_upgrade_to_2.8_b2.sql 16 Sep 2006 17:59:59 -0000 1.3 --- mysql_schema_upgrade_to_2.8_b2.sql 28 Jan 2007 19:53:33 -0000 1.4 *************** *** 1,4 **** # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8 - RC7" # # $Id$ --- 1,4 ---- # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8 - b2" # # $Id$ *************** *** 7,17 **** # ------------------------------------------------------------ # - # 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; - - # ------------------------------------------------------------ - # # New Fields in Table `mx_portal` # ALTER TABLE mx_table_portal ADD overall_header varchar(255) default 'overall_header.tpl'; - ALTER TABLE mx_table_portal ADD navigation_block smallint(5) unsigned NOT NULL default '0'; --- 7,11 ---- Index: mysql_schema_upgrade_to_2.8_a1.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_a1.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** mysql_schema_upgrade_to_2.8_a1.sql 4 Sep 2006 16:48:43 -0000 1.1 --- mysql_schema_upgrade_to_2.8_a1.sql 28 Jan 2007 19:53:33 -0000 1.2 *************** *** 1,4 **** # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8 - RC4" # # $Id$ --- 1,4 ---- # ! # mxBB-Portal - MySQL Schema - Upgrade "2.8 - a1" # # $Id$ *************** *** 109,113 **** DROP TABLE IF EXISTS mx_table_parameter_option; ! # ------------------------------------------------------------ # --- 109,113 ---- DROP TABLE IF EXISTS mx_table_parameter_option; ! # ------------------------------------------------------------ # *************** *** 180,184 **** function_admin = '' WHERE function_id = '{function.function_id}'; ! # # Updating the TextBlocks --- 180,184 ---- function_admin = '' WHERE function_id = '{function.function_id}'; ! # # Updating the TextBlocks *************** *** 191,195 **** function_admin = '' WHERE function_id = '{function.function_id}'; ! SET function = SELECT * FROM mx_table_function WHERE function_file = 'mx_textblock_html.php'; --- 191,195 ---- function_admin = '' WHERE function_id = '{function.function_id}'; ! SET function = SELECT * FROM mx_table_function WHERE function_file = 'mx_textblock_html.php'; *************** *** 206,211 **** 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 --- 206,211 ---- 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 *************** *** 218,230 **** 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 --- 218,229 ---- 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}'; |