Menu
▾
▴
[mxbb-commits] core27x/install/schemas mysql_schema_install.sql,NONE,1.1 mysql_schema_upgrade_to_2.7.0.sql,NONE,1.1 mysql_schema_upgrade_to_2.7.1.sql,NONE,1.1 mysql_schema_upgrade_to_2.705.sql,NONE,1.1 mysql_schema_upgrade_to_2.706.sql,NONE,1.1 postgres_schema_install.sql,NONE,1.1 postgres_schema_upgrade_to_2.7.0.sql,NONE,1.1 postgres_schema_upgrade_to_2.7.1.sql,NONE,1.1 postgres_schema_upgrade_to_2.705.sql,NONE,1.1 postgres_schema_upgrade_to_2.706.sql,NONE,1.1 upgrade_schemas_map.php,NONE,1.1
Update of /cvsroot/mxbb/core27x/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13016/install/schemas Added Files: mysql_schema_install.sql mysql_schema_upgrade_to_2.7.0.sql mysql_schema_upgrade_to_2.7.1.sql mysql_schema_upgrade_to_2.705.sql mysql_schema_upgrade_to_2.706.sql postgres_schema_install.sql postgres_schema_upgrade_to_2.7.0.sql postgres_schema_upgrade_to_2.7.1.sql postgres_schema_upgrade_to_2.705.sql postgres_schema_upgrade_to_2.706.sql upgrade_schemas_map.php Log Message: Initital core 2.7.x commit :-) --- NEW FILE: mysql_schema_upgrade_to_2.706.sql --- # # mxBB-Portal - MySQL Schema - Upgrade "2.706" # # $Id: mysql_schema_upgrade_to_2.706.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ # # ------------------------------------------------------------ # # New Fields in Table `mx_portal` # ALTER TABLE mx_table_portal ADD portal_version VARCHAR(255) DEFAULT NULL; ALTER TABLE mx_table_portal ADD top_phpbb_links SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL; # ------------------------------------------------------------ # # New Fields in Table `mx_block` # ALTER TABLE mx_table_block ADD auth_view_group SMALLINT(5) NOT NULL DEFAULT '0'; ALTER TABLE mx_table_block ADD auth_edit_group SMALLINT(5) NOT NULL DEFAULT '0'; ALTER TABLE mx_table_block ADD auth_delete_group SMALLINT(5) NOT NULL DEFAULT '0'; # ------------------------------------------------------------ # # New Fields in Table `mx_page` # ALTER TABLE mx_table_page ADD auth_view_group SMALLINT(5) NOT NULL DEFAULT '0'; # ------------------------------------------------------------ # # New Fields in Table `mx_menu_nav` # ALTER TABLE mx_table_menu_nav ADD page_id SMALLINT(5) UNSIGNED DEFAULT '0'; ALTER TABLE mx_table_menu_nav ADD auth_view_group SMALLINT(5) NOT NULL DEFAULT '0'; # ------------------------------------------------------------ # # New Fields in Table `mx_menu_categories` # ALTER TABLE mx_table_menu_categories ADD cat_show TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL; # ------------------------------------------------------------ --- NEW FILE: mysql_schema_upgrade_to_2.7.1.sql --- # # mxBB-Portal - MySQL Schema - Upgrade "2.7.1" # # $Id: mysql_schema_upgrade_to_2.7.1.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ # # ------------------------------------------------------------ # # Drop unused Table `mx_block_user_parameter` (finally official) # DROP TABLE IF EXISTS mx_table_block_user_parameter; # ------------------------------------------------------------ # # New Fields in Table `mx_page` # ALTER TABLE mx_table_page ADD page_header VARCHAR(255) DEFAULT 'overall_header.tpl'; # ------------------------------------------------------------ # # New Fields in Table `mx_menu_nav` # ALTER TABLE mx_table_menu_nav ADD link_target TINYINT(2) UNSIGNED NOT NULL DEFAULT '0'; # ------------------------------------------------------------ # # Updating Core Blocks Module # UPDATE mx_table_module SET module_name = 'Core Blocks', module_desc = 'Core blocks' WHERE module_id = '10'; # ------------------------------------------------------------ # # Updating TextBlocks Module # UPDATE mx_table_function SET module_id = '20', function_name = 'TextBlock_BBcode', function_desc = 'TextBlock (BBcode) Block', function_file = 'mx_textblock_bbcode.php', function_admin = 'modules/mx_textblocks/admin/admin_edit.php' WHERE function_id = '10' OR function_file = 'mx_block.php'; UPDATE mx_table_function SET module_id = '20', function_name = 'TextBlock_Html', function_desc = 'TextBlock (Html) Block', function_file = 'mx_textblock_html.php', function_admin = 'modules/mx_textblocks/admin/admin_edit.php' WHERE function_id = '70' OR function_file = 'mx_block_html.php'; INSERT INTO mx_table_module VALUES ('20', 'Text Blocks', 'modules/mx_textblocks/', 'Textblocks module', ''); INSERT INTO mx_table_function VALUES('22', '20', 'TextBlock_Multi', 'Textblock (BBcode and Html) with parameters', 'mx_textblock_multi.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'Text', 'BBText', 'Enter your block text here', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'text_style', 'Values', 'none', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'block_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'title_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'show_title', 'Boolean', 'TRUE', ''); # ------------------------------------------------------------ # # Adding Multiple Horizontal Blocks from Flexible Blocks # INSERT INTO mx_table_function VALUES('19', '10', 'Split Blocks', 'Place blocks side by side in one column.', 'mx_multiple_blocks.php', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('19', 'block_ids', 'Function', '1,2,3', 'get_list_multiple( \"{parameter_id}[]\", BLOCK_TABLE, \'block_id\', \'block_title\', \"{parameter_value}\", TRUE)'); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('19', 'block_sizes', 'Text', '20%,30%,*', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('19', 'space_between', 'Number', '4', ''); # ------------------------------------------------------------ --- NEW FILE: postgres_schema_upgrade_to_2.706.sql --- -- -- mxBB-Portal - PostgreSQL Schema - Upgrade "2.706" -- -- $Id: postgres_schema_upgrade_to_2.706.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ -- -- ------------------------------------------------------------ -- -- New Fields in Table `mx_portal` -- ALTER TABLE mx_table_portal ADD portal_version VARCHAR(255) DEFAULT NULL; ALTER TABLE mx_table_portal ADD top_phpbb_links smallint UNSIGNED DEFAULT '1' NOT NULL; -- ------------------------------------------------------------ -- -- New Fields in Table `mx_block` -- ALTER TABLE mx_table_block ADD auth_view_group smallint NOT NULL DEFAULT '0'; ALTER TABLE mx_table_block ADD auth_edit_group smallint NOT NULL DEFAULT '0'; ALTER TABLE mx_table_block ADD auth_delete_group smallint NOT NULL DEFAULT '0'; -- ------------------------------------------------------------ -- -- New Fields in Table `mx_page` -- ALTER TABLE mx_table_page ADD auth_view_group smallint NOT NULL DEFAULT '0'; -- ------------------------------------------------------------ -- -- New Fields in Table `mx_menu_nav` -- ALTER TABLE mx_table_menu_nav ADD page_id smallint UNSIGNED DEFAULT '0'; ALTER TABLE mx_table_menu_nav ADD auth_view_group smallint NOT NULL DEFAULT '0'; -- ------------------------------------------------------------ -- -- New Fields in Table `mx_menu_categories` -- ALTER TABLE mx_table_menu_categories ADD cat_show smallint UNSIGNED DEFAULT '1' NOT NULL; -- ------------------------------------------------------------ --- NEW FILE: postgres_schema_upgrade_to_2.7.1.sql --- -- -- mxBB-Portal - PostgreSQL Schema - Upgrade "2.7.1" -- -- $Id: postgres_schema_upgrade_to_2.7.1.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ -- -- ------------------------------------------------------------ -- -- Drop unused Table `mx_block_user_parameter` (finally official) -- -- ------------------------------------------------------------ -- -- New Fields in Table `mx_page` -- ALTER TABLE mx_table_page ADD page_header VARCHAR(255) DEFAULT 'overall_header.tpl'; -- ------------------------------------------------------------ -- -- New Fields in Table `mx_menu_nav` -- ALTER TABLE mx_table_menu_nav ADD link_target smallint UNSIGNED NOT NULL DEFAULT '0'; -- ------------------------------------------------------------ -- -- Updating Core Blocks Module -- UPDATE mx_table_module SET module_name = 'Core Blocks', module_desc = 'Core blocks' WHERE module_id = '10'; -- ------------------------------------------------------------ -- -- Updating TextBlocks Module -- UPDATE mx_table_function SET module_id = '20', function_name = 'TextBlock_BBcode', function_desc = 'TextBlock (BBcode) Block', function_file = 'mx_textblock_bbcode.php', function_admin = 'modules/mx_textblocks/admin/admin_edit.php' WHERE function_id = '10' OR function_file = 'mx_block.php'; UPDATE mx_table_function SET module_id = '20', function_name = 'TextBlock_Html', function_desc = 'TextBlock (Html) Block', function_file = 'mx_textblock_html.php', function_admin = 'modules/mx_textblocks/admin/admin_edit.php' WHERE function_id = '70' OR function_file = 'mx_block_html.php'; INSERT INTO mx_table_module VALUES ('20', 'Text Blocks', 'modules/mx_textblocks/', 'Textblocks module', ''); INSERT INTO mx_table_function VALUES('22', '20', 'TextBlock_Multi', 'Textblock (BBcode and Html) with parameters', 'mx_textblock_multi.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'Text', 'BBText', 'Enter your block text here', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'text_style', 'Values', 'none', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'block_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'title_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('22', 'show_title', 'Boolean', 'TRUE', ''); -- ------------------------------------------------------------ -- -- Adding Multiple Horizontal Blocks from Flexible Blocks -- INSERT INTO mx_table_function VALUES('19', '10', 'Split Blocks', 'Place blocks side by side in one column.', 'mx_multiple_blocks.php', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('19', 'block_ids', 'Function', '1,2,3', 'get_list_multiple( \"{parameter_id}[]\", BLOCK_TABLE, \'block_id\', \'block_title\', \"{parameter_value}\", TRUE)'); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('19', 'block_sizes', 'Text', '20%,30%,*', ''); INSERT INTO mx_table_parameter (function_id, parameter_name, parameter_type, parameter_default, parameter_function) VALUES('19', 'space_between', 'Number', '4', ''); -- ------------------------------------------------------------ --- NEW FILE: mysql_schema_upgrade_to_2.7.0.sql --- # # mxBB-Portal - MySQL Schema - Upgrade "2.7.0" # # $Id: mysql_schema_upgrade_to_2.7.0.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ # # ------------------------------------------------------------ # # Convert old Modules to Blocks # INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 1, 15, welcome_text from mx_table_welcome_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 5, 13, poll_topic_id FROM mx_table_config_poll; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 17, last_msg_number FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 18, last_msg_display_date FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 19, last_msg_length FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 20, last_msg_target FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 21, last_msg_align FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 22, last_msg_display_forum FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 10, 23, news_xml_file FROM mx_table_config_news; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 10, 24, news_folder FROM mx_table_config_news; DROP TABLE IF EXISTS mx_table_config_ads; DROP TABLE IF EXISTS mx_table_config_announcement; DROP TABLE IF EXISTS mx_table_config_last_msg; DROP TABLE IF EXISTS mx_table_config_news; DROP TABLE IF EXISTS mx_table_config_poll; DROP TABLE IF EXISTS mx_table_welcome_msg; # ------------------------------------------------------------ --- NEW FILE: upgrade_schemas_map.php --- <?php /** ------------------------------------------------------------------------ * subject : mxBB-Portal Upgrade Schemas Map * begin : june, 2002 * copyright : (C) 2002-2005 mxBB-Portal * email : jon...@ho... * project site : www.mx-system.com * * description : * ------------------------------------------------------------------------- * * $Id: upgrade_schemas_map.php,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ */ /** * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. */ // // The following array is processed by mx_install.php script to guess the SQL schemas // that should be applied when upgrading a target system. // // Please, note we use here 'mx_table_' as table prefix, as we also do in schema files. // This will be replaced by mx_install.php with the real table prefix selected by the // user in the installation panels. // // The map is read as follows: // // If the SQL statement fails, mx_install.php will process upgrades schemas from that // point till the end of the table. So, the order of elements IS very important. ;-) // // When adding more elements to the map, please do so at the end. // $upgrade_schemas_map = array( array('schema' => 'upgrade_to_2.705' , 'sql' => "SELECT auth_view FROM mx_table_page"), 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"), ); // -------------------- // DEBUG ONLY ;-) // //echo('upgrade_schemas_map: '.var_export($upgrade_schemas_map, true)."<br />\n"); // -------------------- ?> --- NEW FILE: postgres_schema_upgrade_to_2.705.sql --- -- -- mxBB-Portal - PostgreSQL Schema - Upgrade "2.705" -- -- $Id: postgres_schema_upgrade_to_2.705.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ -- -- ------------------------------------------------------------ -- -- Remove SERIAL attribute from field parameter_id -- in Tables `mx_block_system_parameter` and `mx_block_user_parameter` -- -- NOTE 1: This change was really implemented in 2.704 -- NOTE 2: Not all DB managers support changing column attributes. -- CREATE TABLE mx_table_block_system_parameter_tmp ( block_id smallint unsigned NOT NULL default '0', parameter_id smallint unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); INSERT INTO mx_table_block_system_parameter_tmp SELECT * FROM mx_table_block_system_parameter; DROP TABLE mx_table_block_system_parameter; CREATE TABLE mx_table_block_system_parameter ( block_id smallint unsigned NOT NULL default '0', parameter_id smallint unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); INSERT INTO mx_table_block_system_parameter SELECT * FROM mx_table_block_system_parameter_tmp; DROP TABLE mx_table_block_system_parameter_tmp; CREATE TABLE mx_table_block_user_parameter_tmp ( block_id smallint unsigned NOT NULL default '0', parameter_id smallint unsigned NOT NULL default '0', parameter_value text, PRIMARY KEY (block_id, parameter_id) ); INSERT INTO mx_table_block_user_parameter_tmp SELECT * FROM mx_table_block_user_parameter; DROP TABLE mx_table_block_user_parameter; CREATE TABLE mx_table_block_user_parameter ( block_id smallint unsigned NOT NULL default '0', parameter_id smallint unsigned NOT NULL default '0', parameter_value text, PRIMARY KEY (block_id, parameter_id) ); INSERT INTO mx_table_block_user_parameter SELECT * FROM mx_table_block_user_parameter_tmp; DROP TABLE mx_table_block_user_parameter_tmp; -- ------------------------------------------------------------ -- -- New Fields in Table `mx_page` -- ALTER TABLE mx_table_page ADD auth_view smallint NOT NULL DEFAULT '0'; -- ------------------------------------------------------------ -- -- Changed images affecting default page icons -- UPDATE mx_table_page SET page_icon = 'icon_home.gif' WHERE page_icon = 'home.jpg'; UPDATE mx_table_page SET page_icon = 'icon_forum.gif' WHERE page_icon = 'forum.jpg'; -- ------------------------------------------------------------ -- -- Changed images affecting default menu entries -- UPDATE mx_table_menu_nav SET menu_icon = 'icon_forum.gif' WHERE menu_icon = 'icon_help.gif'; UPDATE mx_table_menu_nav SET menu_icon = 'icon_stat.gif' WHERE menu_icon = 'icon_poll.gif'; -- ------------------------------------------------------------ -- -- Changed images affecting some block parameters -- UPDATE mx_table_block_system_parameter SET parameter_value = 'thumb_news.gif' WHERE block_id = 18 AND parameter_value = './images/news_02.gif'; UPDATE mx_table_block_system_parameter SET parameter_value = 'thumb_globe.gif' WHERE block_id = 18 AND parameter_value = './images/globe7.gif'; UPDATE mx_table_parameter SET parameter_default = 'thumb_globe.gif' WHERE function_id = 110 AND parameter_default = './images/globe7.gif'; -- ------------------------------------------------------------ -- -- Changed default values on some parameters of the LastMsgPost block -- UPDATE mx_table_parameter SET parameter_default = 'TRUE' WHERE parameter_name = 'Last_Msg_Display_Last_Author'; UPDATE mx_table_parameter SET parameter_default = 'TRUE' WHERE parameter_name = 'Last_Msg_Display_Icon_View'; -- ------------------------------------------------------------ --- NEW FILE: postgres_schema_install.sql --- -- -- mxBB-Portal - PostgreSQL Schema - version 2.7.5 -- -- $Id: postgres_schema_install.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ -- -- -------------------------------------------------------- -- -- Table structure for table `mx_block` -- DROP TABLE mx_table_block; CREATE TABLE mx_table_block ( block_id SERIAL, block_title varchar(150) default NULL, block_desc text, function_id int default NULL, auth_view smallint NOT NULL default '0', auth_edit smallint default '0', auth_delete smallint default '0', auth_view_group smallint NOT NULL default '0', auth_edit_group smallint NOT NULL default '0', auth_delete_group smallint NOT NULL default '0', CONSTRAINT mx_table_block_pkey PRIMARY KEY (block_id) ); -- -- Dumping data for table `mx_block` -- INSERT INTO mx_table_block VALUES (1, 'Welcome', '', 20, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (2, 'Multiple Horizontal Blocks', '', 19, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (3, 'Demo Textblock Multi', '', 22, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (4, 'Demo Textblock BBcode', '', 20, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (5, 'Demo Textblock Html', '', 21, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (6, 'Poll', '', 12, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (7, 'Language Select', '', 13, 99, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (8, 'Navigation Menu', '', 11, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (24, 'Forum', '', 10, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (13, 'Login', NULL, 14, 99, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (14, 'Theme Select', '', 15, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (21, 'Google', '', 16, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (18, 'Announcements', NULL, 17, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (19, 'Online', '', 18, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (16, 'Last Message Post', NULL, 30, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (32, 'Statistics', '', 40, 0, 0, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `mx_block_system_parameter` -- DROP TABLE mx_table_block_system_parameter; CREATE TABLE mx_table_block_system_parameter ( block_id int NOT NULL default '0', parameter_id int NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, CONSTRAINT mx_table_block_system_parameter_pkey PRIMARY KEY (block_id, parameter_id) ); CREATE INDEX mx_table_block_system_parameter_parameter_id ON mx_table_block_system_parameter (parameter_id); CREATE INDEX mx_table_block_system_parameter_block_id ON mx_table_block_system_parameter (block_id); -- -- Dumping data for table `mx_block_system_parameter` -- INSERT INTO mx_table_block_system_parameter VALUES (1, 15, 'Welcome to the Mx-system Portal!\r\n\r\nPlease visit www.mx-system.com for further information.\r\n\r\nThe Mx-Portal version is announced and documented [url=http://www.mx-system.com/forum/viewforum.php?f=11] here[/url].', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (2, 60, '3,4,5', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 61, '33%,*,33%', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 62, '4', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 50, 'This is a demo multi textblock!\r\n\r\n - featuring bbcode, html, style parameters (click the EDIT button and try them out) and permissions (view and edit permissions for users and PRIVATE groups).', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (3, 51, 'none', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 52, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 53, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 54, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (4, 15, 'This is a demo bbcode textblock!\r\n\r\n- featuring bbcode, html and permissions (view and edit permissions for users and PRIVATE groups).', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (5, 16, 'This is a demo html textblock!\r\n\r\n- featuring html and permissions (view and edit permissions for users and PRIVATE groups).', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (6, 36, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (6, 13, '0', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 17, '5', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 18, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 19, '30', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 20, '_self', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 21, 'left', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 22, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 37, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 38, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 39, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 40, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 1, '1', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 2, '999', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 3, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 4, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 5, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 7, 'thumb_news.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 8, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 9, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 6, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 10, 'thumb_globe.gif ', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 11, '', NULL); -- -------------------------------------------------------- -- -- Table structure for table `mx_column` -- DROP TABLE mx_table_column; CREATE TABLE mx_table_column ( column_id SERIAL, column_title varchar(100) default NULL, column_order int NOT NULL default '0', bbcode_uid varchar(10) default NULL, column_size varchar(5) default '100%', page_id smallint NOT NULL default '0', CONSTRAINT mx_table_column_pkey PRIMARY KEY (column_id) ); CREATE INDEX mx_table_column_cat_order ON mx_table_column (column_order); -- -- Dumping data for table `mx_column` -- INSERT INTO mx_table_column VALUES (1, 'Column 1', 10, NULL, '220', 1); INSERT INTO mx_table_column VALUES (2, 'Column 2', 20, NULL, '100%', 1); INSERT INTO mx_table_column VALUES (20, 'Menu', 10, NULL, '200', 2); INSERT INTO mx_table_column VALUES (21, 'Forum', 20, NULL, '100%', 2); -- -------------------------------------------------------- -- -- Table structure for table `mx_column_block` -- DROP TABLE mx_table_column_block; CREATE TABLE mx_table_column_block ( column_id smallint NOT NULL default '0', block_id smallint NOT NULL default '0', block_order smallint NOT NULL default '0' ); -- -- Dumping data for table `mx_column_block` -- INSERT INTO mx_table_column_block VALUES (1, 8, 10); INSERT INTO mx_table_column_block VALUES (1, 16, 20); INSERT INTO mx_table_column_block VALUES (1, 6, 30); INSERT INTO mx_table_column_block VALUES (1, 13, 40); INSERT INTO mx_table_column_block VALUES (1, 7, 50); INSERT INTO mx_table_column_block VALUES (1, 14, 60); INSERT INTO mx_table_column_block VALUES (2, 1, 10); INSERT INTO mx_table_column_block VALUES (2, 2, 10); INSERT INTO mx_table_column_block VALUES (2, 18, 20); INSERT INTO mx_table_column_block VALUES (2, 19, 30); INSERT INTO mx_table_column_block VALUES (20, 8, 10); INSERT INTO mx_table_column_block VALUES (20, 16, 20); INSERT INTO mx_table_column_block VALUES (21, 24, 30); INSERT INTO mx_table_column_block VALUES (21, 19, 40); -- -------------------------------------------------------- -- -- Table structure for table `mx_function` -- DROP TABLE mx_table_function; CREATE TABLE mx_table_function ( function_id SERIAL, module_id int NOT NULL default '0', function_name varchar(150) default NULL, function_desc text, function_file varchar(255) default NULL, function_admin varchar(255) default NULL, CONSTRAINT mx_table_function_pkey PRIMARY KEY (function_id) ); CREATE INDEX mx_table_function_module_id ON mx_table_function (module_id); -- -- Dumping data for table `mx_function` -- INSERT INTO mx_table_function VALUES (10, 10, 'Forum phpBB', 'Forum phpBB', 'mx_forum.php', NULL); INSERT INTO mx_table_function VALUES (11, 10, 'Navigation Menu', 'Menu Navigation', 'mx_menu_nav.php', 'admin/admin_mx_menu.php'); INSERT INTO mx_table_function VALUES (12, 10, 'Polls', 'Polls', 'mx_poll.php', NULL); INSERT INTO mx_table_function VALUES (13, 10, 'Language Select', 'Language Select', 'mx_language.php', NULL); INSERT INTO mx_table_function VALUES (14, 10, 'Login', 'Login', 'mx_login.php', NULL); INSERT INTO mx_table_function VALUES (15, 10, 'Theme Select', 'Theme Select', 'mx_theme.php', NULL); INSERT INTO mx_table_function VALUES (16, 10, 'Google', 'Google', 'mx_google.php', NULL); INSERT INTO mx_table_function VALUES (17, 10, 'Announcements', 'Announcements', 'mx_announce.php', NULL); INSERT INTO mx_table_function VALUES (18, 10, 'Who is Online', 'Who is Online', 'mx_online.php', NULL); INSERT INTO mx_table_function VALUES (19, 10, 'Multiple Horizontal Blocks', 'Block that can arrange other blocks in a horizontal line.', 'mx_multiple_blocks.php', ''); INSERT INTO mx_table_function VALUES (20, 20, 'TextBlock_BBcode', 'TextBlock_BBcode', 'mx_textblock_bbcode.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES (21, 20, 'TextBlock_Html', 'TextBlock_Html', 'mx_textblock_html.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES (22, 20, 'TextBlock_Multi', 'Textblock for bbcode and html with parameters', 'mx_textblock_multi.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES (30, 30, 'Post Last Message', 'Post Last Message', 'mx_last_msg.php', NULL); INSERT INTO mx_table_function VALUES (40, 40, 'Statistics MX', 'Statistics MX', 'mx_statistics.php', NULL); -- -------------------------------------------------------- -- -- Table structure for table `mx_menu_categories` -- DROP TABLE mx_table_menu_categories; CREATE TABLE mx_table_menu_categories ( block_id int NOT NULL default '1', cat_id SERIAL, cat_title varchar(100) default NULL, cat_order int NOT NULL default '0', bbcode_uid varchar(10) default NULL, cat_desc text, cat_show int NOT NULL default '0', CONSTRAINT mx_table_menu_categories_pkey PRIMARY KEY (cat_id) ); CREATE INDEX mx_table_menu_categories_cat_order ON mx_table_menu_categories (cat_order); -- -- Dumping data for table `mx_menu_categories` -- INSERT INTO mx_table_menu_categories VALUES (8, 1, 'Main Menu', 20, NULL, NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `mx_menu_nav` -- DROP TABLE mx_table_menu_nav; CREATE TABLE mx_table_menu_nav ( menu_id SERIAL, cat_id int NOT NULL default '0', menu_name varchar(150) default NULL, menu_desc text, menu_links varchar(255) default NULL, auth_view smallint NOT NULL default '0', menu_order int default '0', bbcode_uid varchar(10) default NULL, menu_icon varchar(255) default NULL, function_id int default '0', block_id smallint NOT NULL default '0', page_id int default '0', auth_view_group smallint NOT NULL default '0', link_target int NOT NULL default '0', CONSTRAINT mx_table_menu_nav_pkey PRIMARY KEY (menu_id) ); CREATE INDEX mx_table_menu_nav_cat_id ON mx_table_menu_nav (cat_id); -- -- Dumping data for table `mx_menu_nav` -- INSERT INTO mx_table_menu_nav VALUES (1, 1, 'Home', 'Home Page', 'index.php', 0, 10, 'bc5d5e65eb', 'icon_home.gif', 0, 0, 0, 0, 0); INSERT INTO mx_table_menu_nav VALUES (2, 1, 'Forum', 'phpBB Forum', 'index.php', 0, 20, '1a7e19f246', 'icon_forum.gif', 0, 0, 2, 0, 0); INSERT INTO mx_table_menu_nav VALUES (3, 1, 'Statistics', 'Statistics Module', '', 0, 30, 'e16b0fbb51', 'icon_stat.gif', 40, 0, 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `mx_module` -- DROP TABLE mx_table_module; CREATE TABLE mx_table_module ( module_id SERIAL, module_name varchar(150) default NULL, module_path varchar(255) default NULL, module_desc text, module_include_admin char(1) default '0', CONSTRAINT mx_table_module_pkey PRIMARY KEY (module_id) ); -- -- Dumping data for table `mx_module` -- INSERT INTO mx_table_module VALUES (10, 'Core Blocks', './', 'Core blocks', ''); INSERT INTO mx_table_module VALUES (20, 'Text Blocks', 'modules/mx_textblocks/', 'Textblocks module', ''); INSERT INTO mx_table_module VALUES (30, 'Post Last Message', 'modules/mx_last_msg/', 'Last Message Module', '0'); INSERT INTO mx_table_module VALUES (40, 'Statistics MX', 'modules/mx_statistics/', 'Statistics Modules', '0'); -- -------------------------------------------------------- -- -- Table structure for table `mx_page` -- DROP TABLE mx_table_page; CREATE TABLE mx_table_page ( page_id SERIAL, page_name varchar(255) default NULL, page_icon varchar(255) default NULL, auth_view smallint NOT NULL default '0', auth_view_group smallint NOT NULL default '0', page_header varchar(255) default 'overall_header.tpl', CONSTRAINT mx_table_page_pkey PRIMARY KEY (page_id) ); -- -- Dumping data for table `mx_page` -- INSERT INTO mx_table_page VALUES (1, 'Home', 'icon_home.gif', 0, 0, 'overall_header.tpl'); INSERT INTO mx_table_page VALUES (2, 'Forum', 'icon_forum.gif', 0, 0, 'overall_header.tpl'); -- -------------------------------------------------------- -- -- Table structure for table `mx_parameter` -- DROP TABLE mx_table_parameter; CREATE TABLE mx_table_parameter ( parameter_id SERIAL, function_id int NOT NULL default '0', parameter_name varchar(150) default NULL, parameter_type varchar(30) default NULL, parameter_default varchar(150) default NULL, parameter_function varchar(255) default NULL, CONSTRAINT mx_table_parameter_pkey PRIMARY KEY (parameter_id) ); -- -- Dumping data for table `mx_parameter` -- INSERT INTO mx_table_parameter VALUES (1, 17, 'announce_nbr_display', 'Number', '1', NULL); INSERT INTO mx_table_parameter VALUES (2, 17, 'announce_nbr_days', 'Number', '14', NULL); INSERT INTO mx_table_parameter VALUES (3, 17, 'announce_display', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (4, 17, 'announce_display_sticky', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (5, 17, 'announce_display_normal', 'Boolean', 'FALSE', NULL); INSERT INTO mx_table_parameter VALUES (7, 17, 'announce_img', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (8, 17, 'announce_img_sticky', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (9, 17, 'announce_img_normal', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (6, 17, 'announce_display_global', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (10, 17, 'announce_img_global', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (11, 17, 'announce_forum', 'Function', NULL, 'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (13, 12, 'Poll_Display', 'Function', '0', 'poll_select( {parameter_value}, "{parameter_id}" )'); INSERT INTO mx_table_parameter VALUES (36, 12, 'poll_forum', 'Function', '', 'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (15, 20, 'Text', 'BBText', 'Insert your text here', NULL); INSERT INTO mx_table_parameter VALUES (16, 21, 'Html', 'Html', 'Entre your Html code here', NULL); INSERT INTO mx_table_parameter VALUES (17, 30, 'Last_Msg_Number_Title', 'Number', '15', NULL); INSERT INTO mx_table_parameter VALUES (18, 30, 'Last_Msg_Display_Date', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (19, 30, 'Last_Msg_Title_Length', 'Number', '30', NULL); INSERT INTO mx_table_parameter VALUES (20, 30, 'Last_Msg_Target', 'Values', '_blank', NULL); INSERT INTO mx_table_parameter VALUES (21, 30, 'Last_Msg_Align', 'Values', 'left', NULL); INSERT INTO mx_table_parameter VALUES (22, 30, 'Last_Msg_Display_Forum', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (37, 30, 'Last_Msg_forum', 'Function', '', 'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (38, 30, 'Last_Msg_Display_Last_Author', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (39, 30, 'Last_Msg_Display_Author', 'Boolean', 'FALSE', ''); INSERT INTO mx_table_parameter VALUES (40, 30, 'Last_Msg_Display_Icon_View', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (50, 22, 'Text', 'BBText', 'Enter your block text here', ''); INSERT INTO mx_table_parameter VALUES (51, 22, 'text_style', 'Values', 'none', ''); INSERT INTO mx_table_parameter VALUES (52, 22, 'block_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (53, 22, 'title_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (54, 22, 'show_title', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (60, 19, 'block_ids', 'Function', '1,2,3', 'get_list_multiple( "{parameter_id}[]", BLOCK_TABLE, \'block_id\', \'block_title\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (61, 19, 'block_sizes', 'Text', '20%,30%,*', ''); INSERT INTO mx_table_parameter VALUES (62, 19, 'space_between', 'Number', '4', ''); -- -------------------------------------------------------- -- -- Table structure for table `mx_parameter_option` -- DROP TABLE mx_table_parameter_option; CREATE TABLE mx_table_parameter_option ( option_id SERIAL, parameter_id int NOT NULL default '0', option_code varchar(150) default NULL, option_desc text, CONSTRAINT mx_table_parameter_option_pkey PRIMARY KEY (option_id) ); -- -- Dumping data for table `mx_parameter_option` -- INSERT INTO mx_table_parameter_option VALUES (3, 21, 'left', 'left '); INSERT INTO mx_table_parameter_option VALUES (4, 21, 'right', 'right'); INSERT INTO mx_table_parameter_option VALUES (5, 21, 'center', 'center'); INSERT INTO mx_table_parameter_option VALUES (6, 20, '_blank', 'New Window'); INSERT INTO mx_table_parameter_option VALUES (7, 20, '_self', 'Current Window'); -- -------------------------------------------------------- -- -- Table structure for table `mx_portal` -- DROP TABLE mx_table_portal; CREATE TABLE mx_table_portal ( portal_id SERIAL, portal_name varchar(150) default NULL, portal_phpbb_url varchar(255) default 'http://www.phpbb.com/phpBB/', portal_url varchar(255) default NULL, portal_version varchar(255) default NULL, top_phpbb_links int NOT NULL default '1', CONSTRAINT mx_table_portal_pkey PRIMARY KEY (portal_id) ); --- NEW FILE: postgres_schema_upgrade_to_2.7.0.sql --- -- -- mxBB-Portal - PostgreSQL Schema - Upgrade "2.7.0" -- -- $Id: postgres_schema_upgrade_to_2.7.0.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ -- -- ------------------------------------------------------------ -- -- Convert old Modules to Blocks -- INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 1, 15, welcome_text from mx_table_welcome_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 5, 13, poll_topic_id FROM mx_table_config_poll; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 17, last_msg_number FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 18, last_msg_display_date FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 19, last_msg_length FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 20, last_msg_target FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 21, last_msg_align FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 16, 22, last_msg_display_forum FROM mx_table_config_last_msg; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 10, 23, news_xml_file FROM mx_table_config_news; INSERT INTO mx_table_block_system_parameter (block_id, parameter_id, parameter_value) SELECT 10, 24, news_folder FROM mx_table_config_news; -- ------------------------------------------------------------ --- NEW FILE: mysql_schema_install.sql --- # # mxBB-Portal - MySQL Schema - version 2.7.5 # # $Id: mysql_schema_install.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ # # -------------------------------------------------------- # # Table structure for table `mx_block` # DROP TABLE IF EXISTS mx_table_block; CREATE TABLE mx_table_block ( block_id smallint(5) unsigned NOT NULL auto_increment, block_title varchar(150) default NULL, block_desc text, function_id smallint(5) unsigned default NULL, auth_view tinyint(2) NOT NULL default '0', auth_edit tinyint(2) default '0', auth_delete tinyint(2) default '0', auth_view_group smallint(5) NOT NULL default '0', auth_edit_group smallint(5) NOT NULL default '0', auth_delete_group smallint(5) NOT NULL default '0', PRIMARY KEY (block_id) ); # # Dumping data for table `mx_block` # INSERT INTO mx_table_block VALUES (1, 'Welcome', '', 20, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (2, 'Multiple Horizontal Blocks', '', 19, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (3, 'Demo Textblock Multi', '', 22, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (4, 'Demo Textblock BBcode', '', 20, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (5, 'Demo Textblock Html', '', 21, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (6, 'Poll', '', 12, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (7, 'Language Select', '', 13, 99, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (8, 'Navigation Menu', '', 11, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (24, 'Forum', '', 10, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (13, 'Login', NULL, 14, 99, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (14, 'Theme Select', '', 15, 0, 5, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (21, 'Google', '', 16, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (18, 'Announcements', NULL, 17, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (19, 'Online', '', 18, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (16, 'Last Message Post', NULL, 30, 0, 0, 0, 0, 0, 0); INSERT INTO mx_table_block VALUES (32, 'Statistics', '', 40, 0, 0, 0, 0, 0, 0); # -------------------------------------------------------- # # Table structure for table `mx_block_system_parameter` # DROP TABLE IF EXISTS mx_table_block_system_parameter; CREATE TABLE mx_table_block_system_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id), KEY block_id (block_id), KEY parameter_id (parameter_id) ); # # Dumping data for table `mx_block_system_parameter` # INSERT INTO mx_table_block_system_parameter VALUES (1, 15, 'Welcome to the Mx-system Portal!\r\n\r\nPlease visit www.mx-system.com for further information.\r\n\r\nThe Mx-Portal version is announced and documented [url=http://www.mx-system.com/forum/viewforum.php?f=11] here[/url].', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (2, 60, '3,4,5', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 61, '33%,*,33%', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 62, '4', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 50, 'This is a demo multi textblock!\r\n\r\n - featuring bbcode, html, style parameters (click the EDIT button and try them out) and permissions (view and edit permissions for users and PRIVATE groups).', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (3, 51, 'none', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 52, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 53, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 54, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (4, 15, 'This is a demo bbcode textblock!\r\n\r\n- featuring bbcode, html and permissions (view and edit permissions for users and PRIVATE groups).', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (5, 16, 'This is a demo html textblock!\r\n\r\n- featuring html and permissions (view and edit permissions for users and PRIVATE groups).', '10bec5b560'); INSERT INTO mx_table_block_system_parameter VALUES (6, 36, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (6, 13, '0', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 17, '5', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 18, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 19, '30', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 20, '_self', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 21, 'left', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 22, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 37, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 38, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 39, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 40, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 1, '1', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 2, '999', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 3, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 4, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 5, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 7, 'thumb_news.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 8, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 9, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 6, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 10, 'thumb_globe.gif ', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 11, '', NULL); # -------------------------------------------------------- # # Table structure for table `mx_column` # DROP TABLE IF EXISTS mx_table_column; CREATE TABLE mx_table_column ( column_id smallint(5) unsigned NOT NULL auto_increment, column_title varchar(100) default NULL, column_order smallint(5) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, column_size varchar(5) default '100%', page_id smallint(5) NOT NULL default '0', PRIMARY KEY (column_id), KEY cat_order (column_order) ); # # Dumping data for table `mx_column` # INSERT INTO mx_table_column VALUES (1, 'Column 1', 10, NULL, '220', 1); INSERT INTO mx_table_column VALUES (2, 'Column 2', 20, NULL, '100%', 1); INSERT INTO mx_table_column VALUES (20, 'Menu', 10, NULL, '200', 2); INSERT INTO mx_table_column VALUES (21, 'Forum', 20, NULL, '100%', 2); # -------------------------------------------------------- # # Table structure for table `mx_column_block` # DROP TABLE IF EXISTS mx_table_column_block; CREATE TABLE mx_table_column_block ( column_id smallint(5) NOT NULL default '0', block_id smallint(5) NOT NULL default '0', block_order smallint(5) NOT NULL default '0' ); # # Dumping data for table `mx_column_block` # INSERT INTO mx_table_column_block VALUES (1, 8, 10); INSERT INTO mx_table_column_block VALUES (1, 16, 20); INSERT INTO mx_table_column_block VALUES (1, 6, 30); INSERT INTO mx_table_column_block VALUES (1, 13, 40); INSERT INTO mx_table_column_block VALUES (1, 7, 50); INSERT INTO mx_table_column_block VALUES (1, 14, 60); INSERT INTO mx_table_column_block VALUES (2, 1, 10); INSERT INTO mx_table_column_block VALUES (2, 2, 10); INSERT INTO mx_table_column_block VALUES (2, 18, 20); INSERT INTO mx_table_column_block VALUES (2, 19, 30); INSERT INTO mx_table_column_block VALUES (20, 8, 10); INSERT INTO mx_table_column_block VALUES (20, 16, 20); INSERT INTO mx_table_column_block VALUES (21, 24, 30); INSERT INTO mx_table_column_block VALUES (21, 19, 40); # -------------------------------------------------------- # # Table structure for table `mx_function` # DROP TABLE IF EXISTS mx_table_function; CREATE TABLE mx_table_function ( function_id smallint(5) unsigned NOT NULL auto_increment, module_id smallint(5) unsigned NOT NULL default '0', function_name varchar(150) default NULL, function_desc text, function_file varchar(255) default NULL, function_admin varchar(255) default NULL, PRIMARY KEY (function_id), KEY module_id (module_id) ); # # Dumping data for table `mx_function` # INSERT INTO mx_table_function VALUES (10, 10, 'Forum phpBB', 'Forum phpBB', 'mx_forum.php', NULL); INSERT INTO mx_table_function VALUES (11, 10, 'Navigation Menu', 'Menu Navigation', 'mx_menu_nav.php', 'admin/admin_mx_menu.php'); INSERT INTO mx_table_function VALUES (12, 10, 'Polls', 'Polls', 'mx_poll.php', NULL); INSERT INTO mx_table_function VALUES (13, 10, 'Language Select', 'Language Select', 'mx_language.php', NULL); INSERT INTO mx_table_function VALUES (14, 10, 'Login', 'Login', 'mx_login.php', NULL); INSERT INTO mx_table_function VALUES (15, 10, 'Theme Select', 'Theme Select', 'mx_theme.php', NULL); INSERT INTO mx_table_function VALUES (16, 10, 'Google', 'Google', 'mx_google.php', NULL); INSERT INTO mx_table_function VALUES (17, 10, 'Announcements', 'Announcements', 'mx_announce.php', NULL); INSERT INTO mx_table_function VALUES (18, 10, 'Who is Online', 'Who is Online', 'mx_online.php', NULL); INSERT INTO mx_table_function VALUES (19, 10, 'Multiple Horizontal Blocks', 'Block that can arrange other blocks in a horizontal line.', 'mx_multiple_blocks.php', ''); INSERT INTO mx_table_function VALUES (20, 20, 'TextBlock_BBcode', 'TextBlock_BBcode', 'mx_textblock_bbcode.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES (21, 20, 'TextBlock_Html', 'TextBlock_Html', 'mx_textblock_html.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES (22, 20, 'TextBlock_Multi', 'Textblock for bbcode and html with parameters', 'mx_textblock_multi.php', 'modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES (30, 30, 'Post Last Message', 'Post Last Message', 'mx_last_msg.php', NULL); INSERT INTO mx_table_function VALUES (40, 40, 'Statistics MX', 'Statistics MX', 'mx_statistics.php', NULL); # -------------------------------------------------------- # # Table structure for table `mx_menu_categories` # DROP TABLE IF EXISTS mx_table_menu_categories; CREATE TABLE mx_table_menu_categories ( block_id smallint(5) unsigned NOT NULL default '1', cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) default NULL, cat_order mediumint(8) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, cat_desc text, cat_show tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order) ); # # Dumping data for table `mx_menu_categories` # INSERT INTO mx_table_menu_categories VALUES (8, 1, 'Main Menu', 20, NULL, NULL, 1); # -------------------------------------------------------- # # Table structure for table `mx_menu_nav` # DROP TABLE IF EXISTS mx_table_menu_nav; CREATE TABLE mx_table_menu_nav ( menu_id smallint(5) unsigned NOT NULL auto_increment, cat_id mediumint(8) unsigned NOT NULL default '0', menu_name varchar(150) default NULL, menu_desc text, menu_links varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', menu_order smallint(5) unsigned default '0', bbcode_uid varchar(10) default NULL, menu_icon varchar(255) default NULL, function_id smallint(5) unsigned default '0', block_id smallint(8) NOT NULL default '0', page_id smallint(5) unsigned default '0', auth_view_group smallint(5) NOT NULL default '0', link_target tinyint(2) unsigned NOT NULL default '0', PRIMARY KEY (menu_id), KEY cat_id (cat_id) ); # # Dumping data for table `mx_menu_nav` # INSERT INTO mx_table_menu_nav VALUES (1, 1, 'Home', 'Home Page', 'index.php', 0, 10, 'bc5d5e65eb', 'icon_home.gif', 0, 0, 0, 0, 0); INSERT INTO mx_table_menu_nav VALUES (2, 1, 'Forum', 'phpBB Forum', 'index.php', 0, 20, '1a7e19f246', 'icon_forum.gif', 0, 0, 2, 0, 0); INSERT INTO mx_table_menu_nav VALUES (3, 1, 'Statistics', 'Statistics Module', '', 0, 30, 'e16b0fbb51', 'icon_stat.gif', 40, 0, 0, 0, 0); # -------------------------------------------------------- # # Table structure for table `mx_module` # DROP TABLE IF EXISTS mx_table_module; CREATE TABLE mx_table_module ( module_id smallint(5) unsigned NOT NULL auto_increment, module_name varchar(150) default NULL, module_path varchar(255) default NULL, module_desc text, module_include_admin char(1) default '0', PRIMARY KEY (module_id) ); # # Dumping data for table `mx_module` # INSERT INTO mx_table_module VALUES (10, 'Core Blocks', './', 'Core blocks', ''); INSERT INTO mx_table_module VALUES (20, 'Text Blocks', 'modules/mx_textblocks/', 'Textblocks module', ''); INSERT INTO mx_table_module VALUES (30, 'Post Last Message', 'modules/mx_last_msg/', 'Last Message Module', '0'); INSERT INTO mx_table_module VALUES (40, 'Statistics MX', 'modules/mx_statistics/', 'Statistics Modules', '0'); # -------------------------------------------------------- # # Table structure for table `mx_page` # DROP TABLE IF EXISTS mx_table_page; CREATE TABLE mx_table_page ( page_id smallint(5) NOT NULL auto_increment, page_name varchar(255) default NULL, page_icon varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', auth_view_group smallint(5) NOT NULL default '0', page_header varchar(255) default 'overall_header.tpl', PRIMARY KEY (page_id) ); # # Dumping data for table `mx_page` # INSERT INTO mx_table_page VALUES (1, 'Home', 'icon_home.gif', 0, 0, 'overall_header.tpl'); INSERT INTO mx_table_page VALUES (2, 'Forum', 'icon_forum.gif', 0, 0, 'overall_header.tpl'); # -------------------------------------------------------- # # Table structure for table `mx_parameter` # DROP TABLE IF EXISTS mx_table_parameter; CREATE TABLE mx_table_parameter ( parameter_id smallint(5) unsigned NOT NULL auto_increment, function_id smallint(5) unsigned NOT NULL default '0', parameter_name varchar(150) default NULL, parameter_type varchar(30) default NULL, parameter_default varchar(150) default NULL, parameter_function varchar(255) default NULL, PRIMARY KEY (parameter_id) ); # # Dumping data for table `mx_parameter` # INSERT INTO mx_table_parameter VALUES (1, 17, 'announce_nbr_display', 'Number', '1', NULL); INSERT INTO mx_table_parameter VALUES (2, 17, 'announce_nbr_days', 'Number', '14', NULL); INSERT INTO mx_table_parameter VALUES (3, 17, 'announce_display', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (4, 17, 'announce_display_sticky', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (5, 17, 'announce_display_normal', 'Boolean', 'FALSE', NULL); INSERT INTO mx_table_parameter VALUES (7, 17, 'announce_img', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (8, 17, 'announce_img_sticky', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (9, 17, 'announce_img_normal', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (6, 17, 'announce_display_global', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (10, 17, 'announce_img_global', 'Text', 'thumb_globe.gif', NULL); INSERT INTO mx_table_parameter VALUES (11, 17, 'announce_forum', 'Function', NULL, 'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (13, 12, 'Poll_Display', 'Function', '0', 'poll_select( {parameter_value}, "{parameter_id}" )'); INSERT INTO mx_table_parameter VALUES (36, 12, 'poll_forum', 'Function', '', 'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (15, 20, 'Text', 'BBText', 'Insert your text here', NULL); INSERT INTO mx_table_parameter VALUES (16, 21, 'Html', 'Html', 'Entre your Html code here', NULL); INSERT INTO mx_table_parameter VALUES (17, 30, 'Last_Msg_Number_Title', 'Number', '15', NULL); INSERT INTO mx_table_parameter VALUES (18, 30, 'Last_Msg_Display_Date', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (19, 30, 'Last_Msg_Title_Length', 'Number', '30', NULL); INSERT INTO mx_table_parameter VALUES (20, 30, 'Last_Msg_Target', 'Values', '_blank', NULL); INSERT INTO mx_table_parameter VALUES (21, 30, 'Last_Msg_Align', 'Values', 'left', NULL); INSERT INTO mx_table_parameter VALUES (22, 30, 'Last_Msg_Display_Forum', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (37, 30, 'Last_Msg_forum', 'Function', '', 'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (38, 30, 'Last_Msg_Display_Last_Author', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (39, 30, 'Last_Msg_Display_Author', 'Boolean', 'FALSE', ''); INSERT INTO mx_table_parameter VALUES (40, 30, 'Last_Msg_Display_Icon_View', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (50, 22, 'Text', 'BBText', 'Enter your block text here', ''); INSERT INTO mx_table_parameter VALUES (51, 22, 'text_style', 'Values', 'none', ''); INSERT INTO mx_table_parameter VALUES (52, 22, 'block_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (53, 22, 'title_style', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (54, 22, 'show_title', 'Boolean', 'TRUE', ''); INSERT INTO mx_table_parameter VALUES (60, 19, 'block_ids', 'Function', '1,2,3', 'get_list_multiple( "{parameter_id}[]", BLOCK_TABLE, \'block_id\', \'block_title\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES (61, 19, 'block_sizes', 'Text', '20%,30%,*', ''); INSERT INTO mx_table_parameter VALUES (62, 19, 'space_between', 'Number', '4', ''); # -------------------------------------------------------- # # Table structure for table `mx_parameter_option` # DROP TABLE IF EXISTS mx_table_parameter_option; CREATE TABLE mx_table_parameter_option ( option_id smallint(5) unsigned NOT NULL auto_increment, parameter_id smallint(5) unsigned NOT NULL default '0', option_code varchar(150) default NULL, option_desc text, PRIMARY KEY (option_id) ); # # Dumping data for table `mx_parameter_option` # INSERT INTO mx_table_parameter_option VALUES (3, 21, 'left', 'left '); INSERT INTO mx_table_parameter_option VALUES (4, 21, 'right', 'right'); INSERT INTO mx_table_parameter_option VALUES (5, 21, 'center', 'center'); INSERT INTO mx_table_parameter_option VALUES (6, 20, '_blank', 'New Window'); INSERT INTO mx_table_parameter_option VALUES (7, 20, '_self', 'Current Window'); # -------------------------------------------------------- # # Table structure for table `mx_portal` # DROP TABLE IF EXISTS mx_table_portal; CREATE TABLE mx_table_portal ( portal_id smallint(5) unsigned NOT NULL auto_increment, portal_name varchar(150) default NULL, portal_phpbb_url varchar(255) default 'http://www.phpbb.com/phpBB/', portal_url varchar(255) default NULL, portal_version varchar(255) default NULL, top_phpbb_links smallint(5) unsigned NOT NULL default '1', PRIMARY KEY (portal_id) ); --- NEW FILE: mysql_schema_upgrade_to_2.705.sql --- # # mxBB-Portal - MySQL Schema - Upgrade "2.705" # # $Id: mysql_schema_upgrade_to_2.705.sql,v 1.1 2005/05/06 06:47:59 jonohlsson Exp $ # # ------------------------------------------------------------ # # Remove auto_increment attribute from field parameter_id # in Tables `mx_block_system_parameter` and `mx_block_user_parameter` # # NOTE 1: This change was really implemented in 2.704 # NOTE 2: Not all DB managers support changing column attributes. # CREATE TABLE mx_table_block_system_parameter_tmp ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); INSERT INTO mx_table_block_system_parameter_tmp SELECT * FROM mx_table_block_system_parameter; DROP TABLE mx_table_block_system_parameter; CREATE TABLE mx_table_block_system_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, paramete... [truncated message content] |
