[mxbb-commits] core/install/schemas mysql_schema_install.sql, 1.41, 1.41.2.1 postgres_schema_install.sql, 1.3, 1.3.2.1

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

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

Modified Files:
      Tag: core28x
	mysql_schema_install.sql postgres_schema_install.sql 
Log Message:
schema bugs

Index: postgres_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/postgres_schema_install.sql,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -C2 -d -r1.3 -r1.3.2.1
*** postgres_schema_install.sql	22 Jul 2007 21:00:21 -0000	1.3
--- postgres_schema_install.sql	12 Aug 2007 20:48:22 -0000	1.3.2.1
***************
*** 273,277 ****
  --
  INSERT INTO "mx_table_function" VALUES (8, 30,'phpBB Index','phpBB Index Block','mx_forum.php','');
! INSERT INTO "mx_table_function" VALUES (51, 50,'Navigation Menu','Site Navigation Menu Blocks','mx_menu_nav.php','');
  INSERT INTO "mx_table_function" VALUES (14, 30,'mxBB Polls','mxBB Polls','mx_poll.php','');
  INSERT INTO "mx_table_function" VALUES (6, 10,'Language Select','Language Select Block','mx_language.php','');
--- 273,278 ----
  --
  INSERT INTO "mx_table_function" VALUES (8, 30,'phpBB Index','phpBB Index Block','mx_forum.php','');
! INSERT INTO "mx_table_function" VALUES (51, 50,'User Navigation Menu','Site Navigation','mx_menu_nav.php','');
! INSERT INTO "mx_table_function" VALUES (52, 50,'Site Navigation Menu','Site Navigation','mx_site_nav.php','');
  INSERT INTO "mx_table_function" VALUES (14, 30,'mxBB Polls','mxBB Polls','mx_poll.php','');
  INSERT INTO "mx_table_function" VALUES (6, 10,'Language Select','Language Select Block','mx_language.php','');
***************
*** 432,440 ****
  -- Dumping data for table 'mx_table_page'
  --
! INSERT INTO "mx_table_page" VALUES (1,'Home','This is the startpage','0','','0','icon_home.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
! INSERT INTO "mx_table_page" VALUES (2,'Forum','This is the phpBB Forum startpage','0','','0','icon_forum.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',1);
! INSERT INTO "mx_table_page" VALUES (3,'Demo Page','Block Demos','0','','0','icon_settings.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
! INSERT INTO "mx_table_page" VALUES (4,'Sitestats','Sitestats page','0','','0','icon_statistics.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
! INSERT INTO "mx_table_page" VALUES (5,'Site Search','Site Search page','0','','0','icon_search.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
  
  
--- 433,441 ----
  -- Dumping data for table 'mx_table_page'
  --
! INSERT INTO "mx_table_page" VALUES (1,'Home','This is the startpage','0','','10','icon_home.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
! INSERT INTO "mx_table_page" VALUES (2,'Forum','This is the phpBB Forum startpage','0','','20','icon_forum.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',1);
! INSERT INTO "mx_table_page" VALUES (3,'Demo Page','Block Demos','0','','30','icon_settings.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
! INSERT INTO "mx_table_page" VALUES (4,'Sitestats','Sitestats page','0','','40','icon_statistics.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
! INSERT INTO "mx_table_page" VALUES (5,'Site Search','Site Search page','0','','50','icon_search.gif','','','','','1','0','0','0',-1,-1,'','','','0','a:1:{i:0;s:0:"";}',-1);
  
  
***************
*** 535,538 ****
--- 536,544 ----
  INSERT INTO "mx_table_parameter" VALUES (64,51,'menu_page_sync','Boolean','0','',0,40);
  
+ INSERT INTO "mx_table_parameter" VALUES (100,52,'Site menu','site_menu','','',0,10);
+ INSERT INTO "mx_table_parameter" VALUES (101,52,'menu_display_style','Radio_single_select','Overall_navigation','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 (102,52,'menu_display_mode','Radio_single_select','Horizontal','a:2:{i:0;s:8:"Vertical";i:1;s:10:"Horizontal";}',0,30);
+ INSERT INTO "mx_table_parameter" VALUES (103,52,'menu_page_sync','Boolean','1','',0,40);
+ 
  INSERT INTO "mx_table_parameter" VALUES (92,10,'numOfEvents','Number','5','',0,0);
  

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.41
retrieving revision 1.41.2.1
diff -C2 -d -r1.41 -r1.41.2.1
*** mysql_schema_install.sql	22 Jul 2007 22:29:01 -0000	1.41
--- mysql_schema_install.sql	12 Aug 2007 20:48:21 -0000	1.41.2.1
***************
*** 274,278 ****
  #
  INSERT INTO mx_table_function VALUES("8", "30", "phpBB Index", "phpBB Index Block", "mx_forum.php", "");
! INSERT INTO mx_table_function VALUES("51", "50", "Navigation Menu", "Site Navigation Menu Blocks", "mx_menu_nav.php", "");
  INSERT INTO mx_table_function VALUES("14", "30", "mxBB Polls", "mxBB Polls", "mx_poll.php", "");
  INSERT INTO mx_table_function VALUES("6", "10", "Language Select", "Language Select Block", "mx_language.php", "");
--- 274,279 ----
  #
  INSERT INTO mx_table_function VALUES("8", "30", "phpBB Index", "phpBB Index Block", "mx_forum.php", "");
! INSERT INTO mx_table_function VALUES("51", "50", "User Navigation Menu", "Site Navigation", "mx_menu_nav.php", "");
! INSERT INTO mx_table_function VALUES("52", "50", "Page Navigation Menu", "Site Navigation", "mx_site_nav.php", "");
  INSERT INTO mx_table_function VALUES("14", "30", "mxBB Polls", "mxBB Polls", "mx_poll.php", "");
  INSERT INTO mx_table_function VALUES("6", "10", "Language Select", "Language Select Block", "mx_language.php", "");
***************
*** 437,445 ****
  # Dumping data for table 'mx_table_page'
  #
! INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "10", "", "0","icon_home.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "20", "", "0","icon_forum.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1");
! INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "30", "", "0","icon_docs.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "40", "", "0","icon_stats.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("5", "Site Search", "Site Search page", "50", "", "0","icon_search.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  
  
--- 438,446 ----
  # Dumping data for table 'mx_table_page'
  #
! INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "0", "", "10","icon_home.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "0", "", "20","icon_forum.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1");
! INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "0", "", "30","icon_docs.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "0", "", "40","icon_stats.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
! INSERT INTO mx_table_page VALUES("5", "Site Search", "Site Search page", "0", "", "50","icon_search.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  
  
***************
*** 541,544 ****
--- 542,550 ----
  INSERT INTO mx_table_parameter VALUES("64", "51", "menu_page_sync", "Boolean", "0", "", "0", "40");
  
+ INSERT INTO mx_table_parameter VALUES("100", "52", "Site menu", "site_menu", "", "", "0", "10");
+ INSERT INTO mx_table_parameter VALUES("101", "52", "menu_display_style", "Radio_single_select", "Overall_navigation", "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("102", "52", "menu_display_mode", "Radio_single_select", "Horizontal", "a:2:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";}", "0", "30");
+ INSERT INTO mx_table_parameter VALUES("103", "52", "menu_page_sync", "Boolean", "1", "", "0", "40");
+ 
  INSERT INTO mx_table_parameter VALUES("92", "10", "numOfEvents", "Number", "5", "", "0", "0");