[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8.0.sql, NONE, 1.1 mysql_schema_inst

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-cvs16:/tmp/cvs-serv316

Modified Files:
	mysql_schema_install.sql upgrade_schemas_map.php 
Added Files:
	mysql_schema_upgrade_to_2.8.0.sql 
Log Message:
Page ordering bug
Updated schemas, for new "page_footer" db entry

Index: upgrade_schemas_map.php
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/upgrade_schemas_map.php,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** upgrade_schemas_map.php	5 May 2007 20:40:27 -0000	1.15
--- upgrade_schemas_map.php	16 May 2007 19:18:38 -0000	1.16
***************
*** 17,21 ****
  	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")
  );
  
--- 17,22 ----
  	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"),
! 	array('schema' => 'upgrade_to_2.8.0'	, 'sql' => "SELECT overall_footer FROM mx_table_portal")
  );
  

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.34
retrieving revision 1.35
diff -C2 -d -r1.34 -r1.35
*** mysql_schema_install.sql	11 May 2007 20:13:45 -0000	1.34
--- mysql_schema_install.sql	16 May 2007 19:18:38 -0000	1.35
***************
*** 96,105 ****
  INSERT INTO mx_table_block_system_parameter VALUES("8", "66", "", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("8", "93", "Classic", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("8", "63", "vertical", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("8", "64", "TRUE", "", "0");
  
  INSERT INTO mx_table_block_system_parameter VALUES("25", "66", "", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("25", "93", "Classic", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("25", "63", "horizontal", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("25", "64", "TRUE", "", "0");
  
--- 96,105 ----
  INSERT INTO mx_table_block_system_parameter VALUES("8", "66", "", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("8", "93", "Classic", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("8", "63", "Vertical", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("8", "64", "TRUE", "", "0");
  
  INSERT INTO mx_table_block_system_parameter VALUES("25", "66", "", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("25", "93", "Classic", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("25", "63", "Horizontal", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("25", "64", "TRUE", "", "0");
  
***************
*** 412,415 ****
--- 412,416 ----
    `auth_moderator_group` varchar(255) NOT NULL default '0',
    `page_header` varchar(255) default '',
+   `page_footer` varchar(255) default '',
    `page_main_layout` varchar(255) default '',
    `navigation_block` smallint(5) unsigned NOT NULL default '0',
***************
*** 424,432 ****
  # Dumping data for table 'mx_table_page'
  #
! INSERT INTO mx_table_page VALUES("5", "Site Search", "Site Search page", "icon_search.gif", "0", "0", "0", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "icon_stats.gif", "0", "0", "0", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "icon_home.gif", "0", "0", "0", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "icon_forum.gif", "0", "0", "0", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1");
! INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "icon_scate.gif", "0", "0", "0", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  
  
--- 425,433 ----
  # Dumping data for table 'mx_table_page'
  #
! INSERT INTO mx_table_page VALUES("5", "Site Search", "Site Search page", "icon_search.gif", "0", "0", "0", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "icon_stats.gif", "0", "0", "0", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "icon_home.gif", "0", "0", "0", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "icon_forum.gif", "0", "0", "0", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1");
! INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "icon_scate.gif", "0", "0", "0", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  
  
***************
*** 525,529 ****
  INSERT INTO mx_table_parameter VALUES("66", "51", "Nav menu", "nav_menu", "", "", "0", "10");
  INSERT INTO mx_table_parameter VALUES("93", "51", "menu_display_style", "Radio_single_select", "Classic", "a:5:{i:0;s:7:\"Classic\";i:1;s:8:\"Advanced\";i:2;s:15:\"Simple_CSS_menu\";i:3;s:17:\"Advanced_CSS_menu\";i:4;s:18:\"Overall_navigation\";}", "0", "20");
! INSERT INTO mx_table_parameter VALUES("63", "51", "menu_display_mode", "Radio_single_select", "vertical", "a:2:{i:0;s:8:\"vertical\";i:1;s:10:\"horizontal\";}", "0", "30");
  INSERT INTO mx_table_parameter VALUES("64", "51", "menu_page_sync", "Boolean", "0", "", "0", "40");
  
--- 526,530 ----
  INSERT INTO mx_table_parameter VALUES("66", "51", "Nav menu", "nav_menu", "", "", "0", "10");
  INSERT INTO mx_table_parameter VALUES("93", "51", "menu_display_style", "Radio_single_select", "Classic", "a:5:{i:0;s:7:\"Classic\";i:1;s:8:\"Advanced\";i:2;s:15:\"Simple_CSS_menu\";i:3;s:17:\"Advanced_CSS_menu\";i:4;s:18:\"Overall_navigation\";}", "0", "20");
! INSERT INTO mx_table_parameter VALUES("63", "51", "menu_display_mode", "Radio_single_select", "Vertical", "a:2:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";}", "0", "30");
  INSERT INTO mx_table_parameter VALUES("64", "51", "menu_page_sync", "Boolean", "0", "", "0", "40");
  
***************
*** 551,554 ****
--- 552,556 ----
    `portal_version` varchar(255) default NULL,
    `overall_header` varchar(255) default 'overall_header.tpl',
+   `overall_footer` varchar(255) default 'overall_footer.tpl',
    `main_layout` varchar(255) default 'mx_main_layout.tpl',
    `navigation_block` smallint(5) unsigned NOT NULL default '0',

--- NEW FILE: mysql_schema_upgrade_to_2.8.0.sql ---
#
# mxBB-Portal - MySQL Schema - Upgrade "2.8.0"
#
# $Id: mysql_schema_upgrade_to_2.8.0.sql,v 1.1 2007/05/16 19:18:38 jonohlsson Exp $
#

# ------------------------------------------------------------
#
# New Fields in Table `mx_page`
ALTER TABLE mx_table_page ADD page_footer varchar(255) default '' AFTER page_header;

# ------------------------------------------------------------
#
# New Fields in Table `mx_portal`
#
ALTER TABLE mx_table_portal ADD overall_footer varchar(255) default 'overall_footer.tpl' AFTER overall_header;

[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8.0.sql, NONE, 1.1 mysql_schema_inst

[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8.0.sql, NONE, 1.1 mysql_schema_install.sql, 1.34, 1.35 upgrade_schemas_map.php, 1.15, 1.16