|
From: Jon O. <jon...@us...> - 2005-12-17 00:33:18
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14518/install/schemas Modified Files: mysql_schema_install.sql mysql_schema_upgrade_to_2.8_rc5.sql mysql_schema_upgrade_to_2.8_rc7.sql Log Message: - updated schemas, adding new parameter_auth field - fix for regenerating cache during install/upgrade Index: mysql_schema_upgrade_to_2.8_rc5.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_rc5.sql,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** mysql_schema_upgrade_to_2.8_rc5.sql 9 Dec 2005 00:22:23 -0000 1.3 --- mysql_schema_upgrade_to_2.8_rc5.sql 17 Dec 2005 00:33:10 -0000 1.4 *************** *** 132,136 **** # 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"); --- 132,136 ---- # 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"); Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** mysql_schema_install.sql 16 Dec 2005 18:58:45 -0000 1.13 --- mysql_schema_install.sql 17 Dec 2005 00:33:10 -0000 1.14 *************** *** 430,434 **** # 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"); --- 430,434 ---- # 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"); *************** *** 447,450 **** --- 447,451 ---- `parameter_default` varchar(150) default NULL, `parameter_function` varchar(255) default NULL, + `parameter_auth` tinyint(2) NOT NULL default '0', `parameter_order` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`parameter_id`) *************** *** 456,507 **** # Dumping data for table 'mx_table_parameter' # ! INSERT INTO mx_table_parameter VALUES("1", "2", "announce_nbr_display", "Number", "1", "", "0"); ! INSERT INTO mx_table_parameter VALUES("2", "2", "announce_nbr_days", "Number", "14", "", "0"); ! INSERT INTO mx_table_parameter VALUES("3", "2", "announce_display", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("4", "2", "announce_display_sticky", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("5", "2", "announce_display_normal", "Boolean", "FALSE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("7", "2", "announce_img", "Text", "thumb_globe.gif", "", "0"); ! INSERT INTO mx_table_parameter VALUES("8", "2", "announce_img_sticky", "Text", "thumb_globe.gif", "", "0"); ! INSERT INTO mx_table_parameter VALUES("9", "2", "announce_img_normal", "Text", "thumb_globe.gif", "", "0"); ! INSERT INTO mx_table_parameter VALUES("6", "2", "announce_display_global", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("10", "2", "announce_img_global", "Text", "thumb_globe.gif", "", "0"); ! INSERT INTO mx_table_parameter VALUES("11", "2", "announce_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0"); ! INSERT INTO mx_table_parameter VALUES("13", "14", "Poll_Display", "Function", "0", "poll_select( {parameter_value}, \"{parameter_id}\" )", "0"); ! INSERT INTO mx_table_parameter VALUES("36", "14", "poll_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0"); ! INSERT INTO mx_table_parameter VALUES("15", "24", "Text", "phpBBTextBlock", "Insert your text here", "", "0"); ! INSERT INTO mx_table_parameter VALUES("16", "23", "Html", "WysiwygTextBlock", "Entre your Html code here", "", "0"); ! INSERT INTO mx_table_parameter VALUES("17", "31", "Last_Msg_Number_Title", "Number", "15", "", "0"); ! INSERT INTO mx_table_parameter VALUES("18", "31", "Last_Msg_Display_Date", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("19", "31", "Last_Msg_Title_Length", "Number", "30", "", "0"); ! INSERT INTO mx_table_parameter VALUES("20", "31", "Last_Msg_Target", "Values", "_blank", "", "0"); ! INSERT INTO mx_table_parameter VALUES("21", "31", "Last_Msg_Align", "Values", "left", "", "0"); ! INSERT INTO mx_table_parameter VALUES("22", "31", "Last_Msg_Display_Forum", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("37", "31", "Last_Msg_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0"); ! INSERT INTO mx_table_parameter VALUES("38", "31", "Last_Msg_Display_Last_Author", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("39", "31", "Last_Msg_Display_Author", "Boolean", "FALSE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("40", "31", "Last_Msg_Display_Icon_View", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("50", "22", "Text", "CustomizedTextBlock", "Enter your block text here", "", "0"); ! INSERT INTO mx_table_parameter VALUES("51", "22", "text_style", "Text", "none", "", "0"); ! INSERT INTO mx_table_parameter VALUES("52", "22", "block_style", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("53", "22", "title_style", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("91", "10", "log_filter_date", "Menu_single_select", "1 month", "a:12:{i:0;s:8:\"no limit\";i:1;s:5:\"1 day\";i:2;s:6:\"2 days\";i:3;s:6:\"3 days\";i:4;s:6:\"1 week\";i:5;s:7:\"2 weeks\";i:6;s:7:\"3 weeks\";i:7;s:7:\"1 month\";i:8;s:8:\"2 months\";i:9;s:8:\"3 months\";i:10;s:8:\"6 months\";i:11;s:6:\"1 year\";}", "0"); ! INSERT INTO mx_table_parameter VALUES("60", "11", "block_ids", "Function", "1,2,3", "get_list_multiple( \"{parameter_id}[]\", BLOCK_TABLE, \'block_id\', \'block_title\', \"{parameter_value}\", TRUE)", "0"); ! INSERT INTO mx_table_parameter VALUES("61", "11", "block_sizes", "Text", "20%,30%,*", "", "0"); ! INSERT INTO mx_table_parameter VALUES("62", "11", "space_between", "Number", "4", "", "0"); ! INSERT INTO mx_table_parameter VALUES("70", "5", "x_mode", "Menu_single_select", "x_iframe", "a:6:{i:0;s:8:\"x_listen\";i:1;s:8:\"x_iframe\";i:2;s:10:\"x_textfile\";i:3;s:12:\"x_multimedia\";i:4;s:5:\"x_pic\";i:5;s:8:\"x_format\";}", "0"); ! INSERT INTO mx_table_parameter VALUES("80", "3", "default_block_id", "Function", "0", "get_list_formatted(\"block_list\",\"{parameter_value}\",\"{parameter_id}[]\")", "0"); ! INSERT INTO mx_table_parameter VALUES("72", "5", "x_1", "Text", "", "", "0"); ! INSERT INTO mx_table_parameter VALUES("73", "5", "x_2", "Text", "", "", "0"); ! 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\";}", "20"); ! INSERT INTO mx_table_parameter VALUES("64", "51", "menu_page_sync", "Boolean", "0", "", "30"); ! INSERT INTO mx_table_parameter VALUES("71", "5", "x_3", "Text", "http://www.mx-system.com", "", "0"); ! INSERT INTO mx_table_parameter VALUES("81", "21", "Blog", "BBText", "Add your text here...", "", "0"); ! INSERT INTO mx_table_parameter VALUES("92", "10", "numOfEvents", "Number", "5", "", "0"); ! INSERT INTO mx_table_parameter VALUES("65", "51", "msg_filter_date", "Function", "5", "get_list_static(\"{parameter_id}[]\",array(\"no limit\", \"1 day\", \"2 days\", \"3 days\", \"1 week\", \"2 weeks\", \"3 weeks\", \"1 month\", \"2 months\", \"3 months\", \"6 months\", \"1 year\"),\"{parameter_value}\")", "0"); ! INSERT INTO mx_table_parameter VALUES("57", "22", "allow_smilies", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("54", "22", "allow_html", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("56", "22", "allow_bbcode", "Boolean", "TRUE", "", "0"); ! INSERT INTO mx_table_parameter VALUES("55", "22", "html_tags", "Text", "b,i,u,img", "", "0"); ! INSERT INTO mx_table_parameter VALUES("66", "51", "Nav menu", "nav_menu", "", "", "10"); --- 457,508 ---- # Dumping data for table 'mx_table_parameter' # ! INSERT INTO mx_table_parameter VALUES("1", "2", "announce_nbr_display", "Number", "1", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("2", "2", "announce_nbr_days", "Number", "14", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("3", "2", "announce_display", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("4", "2", "announce_display_sticky", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("5", "2", "announce_display_normal", "Boolean", "FALSE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("7", "2", "announce_img", "Text", "thumb_globe.gif", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("8", "2", "announce_img_sticky", "Text", "thumb_globe.gif", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("9", "2", "announce_img_normal", "Text", "thumb_globe.gif", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("6", "2", "announce_display_global", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("10", "2", "announce_img_global", "Text", "thumb_globe.gif", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("11", "2", "announce_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("13", "14", "Poll_Display", "Function", "0", "poll_select( {parameter_value}, \"{parameter_id}\" )", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("36", "14", "poll_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("15", "24", "Text", "phpBBTextBlock", "Insert your text here", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("16", "23", "Html", "WysiwygTextBlock", "Entre your Html code here", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("17", "31", "Last_Msg_Number_Title", "Number", "15", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("18", "31", "Last_Msg_Display_Date", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("19", "31", "Last_Msg_Title_Length", "Number", "30", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("20", "31", "Last_Msg_Target", "Values", "_blank", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("21", "31", "Last_Msg_Align", "Values", "left", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("22", "31", "Last_Msg_Display_Forum", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("37", "31", "Last_Msg_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("38", "31", "Last_Msg_Display_Last_Author", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("39", "31", "Last_Msg_Display_Author", "Boolean", "FALSE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("40", "31", "Last_Msg_Display_Icon_View", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("50", "22", "Text", "CustomizedTextBlock", "Enter your block text here", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("51", "22", "text_style", "Text", "none", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("52", "22", "block_style", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("53", "22", "title_style", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("91", "10", "log_filter_date", "Menu_single_select", "1 month", "a:12:{i:0;s:8:\"no limit\";i:1;s:5:\"1 day\";i:2;s:6:\"2 days\";i:3;s:6:\"3 days\";i:4;s:6:\"1 week\";i:5;s:7:\"2 weeks\";i:6;s:7:\"3 weeks\";i:7;s:7:\"1 month\";i:8;s:8:\"2 months\";i:9;s:8:\"3 months\";i:10;s:8:\"6 months\";i:11;s:6:\"1 year\";}", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("60", "11", "block_ids", "Function", "1,2,3", "get_list_multiple( \"{parameter_id}[]\", BLOCK_TABLE, \'block_id\', \'block_title\', \"{parameter_value}\", TRUE)", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("61", "11", "block_sizes", "Text", "20%,30%,*", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("62", "11", "space_between", "Number", "4", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("70", "5", "x_mode", "Menu_single_select", "x_iframe", "a:6:{i:0;s:8:\"x_listen\";i:1;s:8:\"x_iframe\";i:2;s:10:\"x_textfile\";i:3;s:12:\"x_multimedia\";i:4;s:5:\"x_pic\";i:5;s:8:\"x_format\";}", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("80", "3", "default_block_id", "Function", "0", "get_list_formatted(\"block_list\",\"{parameter_value}\",\"{parameter_id}[]\")", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("72", "5", "x_1", "Text", "", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("73", "5", "x_2", "Text", "", "", "0", "0"); ! 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", "20"); ! INSERT INTO mx_table_parameter VALUES("64", "51", "menu_page_sync", "Boolean", "0", "", "0", "30"); ! INSERT INTO mx_table_parameter VALUES("71", "5", "x_3", "Text", "http://www.mx-system.com", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("81", "21", "Blog", "BBText", "Add your text here...", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("92", "10", "numOfEvents", "Number", "5", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("65", "51", "msg_filter_date", "Function", "5", "get_list_static(\"{parameter_id}[]\",array(\"no limit\", \"1 day\", \"2 days\", \"3 days\", \"1 week\", \"2 weeks\", \"3 weeks\", \"1 month\", \"2 months\", \"3 months\", \"6 months\", \"1 year\"),\"{parameter_value}\")", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("57", "22", "allow_smilies", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("54", "22", "allow_html", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("56", "22", "allow_bbcode", "Boolean", "TRUE", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("55", "22", "html_tags", "Text", "b,i,u,img", "", "0", "0"); ! INSERT INTO mx_table_parameter VALUES("66", "51", "Nav menu", "nav_menu", "", "", "0", "10"); Index: mysql_schema_upgrade_to_2.8_rc7.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8_rc7.sql,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** mysql_schema_upgrade_to_2.8_rc7.sql 9 Dec 2005 23:22:03 -0000 1.6 --- mysql_schema_upgrade_to_2.8_rc7.sql 17 Dec 2005 00:33:10 -0000 1.7 *************** *** 44,46 **** # 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'; \ No newline at end of file --- 44,52 ---- # 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'; |