Menu
▾
▴
[mxbb-commits] core/install/schemas mysql_schema_install_2.7.1.sql,1.1,1.2 mysql_schema_install_2.7.2.sql,1.1,1.2 mysql_schema_install_2.7.3.sql,1.2,1.3 mysql_schema_install_2.7.5.sql,1.1,1.2 mysql_schema_install_2.701.sql,1.1,1.2 mysql_schema_install_2.702.sql,1.1,1.2 mysql_schema_install_2.703.sql,1.1,1.2 mysql_schema_install_2.704.sql,1.1,1.2 mysql_schema_install_2.705.sql,1.1,1.2 mysql_schema_install_2.706.sql,1.1,1.2 mysql_schema_upgrade_to_2.7.4.sql,1.3,1.4
|
From: Markus P. <mar...@us...> - 2005-04-13 21:23:46
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3079/install/schemas Modified Files: mysql_schema_install_2.7.1.sql mysql_schema_install_2.7.2.sql mysql_schema_install_2.7.3.sql mysql_schema_install_2.7.5.sql mysql_schema_install_2.701.sql mysql_schema_install_2.702.sql mysql_schema_install_2.703.sql mysql_schema_install_2.704.sql mysql_schema_install_2.705.sql mysql_schema_install_2.706.sql mysql_schema_upgrade_to_2.7.4.sql Log Message: ok, second step on fixing double line breaks. I think this is all. Index: mysql_schema_install_2.7.5.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install_2.7.5.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** mysql_schema_install_2.7.5.sql 20 Mar 2005 04:20:17 -0000 1.1 --- mysql_schema_install_2.7.5.sql 13 Apr 2005 21:23:27 -0000 1.2 *************** *** 1,391 **** ! # ! # mxBB-Portal - MySQL Schema - version 2.7.5 ! # ! # $Id$ ! # ! ! # -------------------------------------------------------- ! ! # ! # Table structure for table `mx_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` ! # ! ! 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) ! ); ! ! # ! # 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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) ! ); --- 1,391 ---- ! # ! # mxBB-Portal - MySQL Schema - version 2.7.5 ! # ! # $Id$ ! # ! ! # -------------------------------------------------------- ! ! # ! # Table structure for table `mx_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` ! # ! ! 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) ! ); ! ! # ! # 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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) ! ); Index: mysql_schema_upgrade_to_2.7.4.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.7.4.sql,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** mysql_schema_upgrade_to_2.7.4.sql 9 Mar 2005 19:25:18 -0000 1.3 --- mysql_schema_upgrade_to_2.7.4.sql 13 Apr 2005 21:23:28 -0000 1.4 *************** *** 1,99 **** ! # ! # mxBB-Portal - MySQL Schema - Upgrade "2.7.4" ! # ! # $Id$ ! # ! ! # ------------------------------------------------------------ ! # ! # New Function, Block and Parameters 'IncludeX' ! # ! SET module = SELECT * FROM mx_table_module WHERE module_name = 'Core Blocks'; ! SET function = SELECT MAX(function_id) AS next_id FROM mx_table_function; ! SET block = SELECT MAX(block_id) AS next_id FROM mx_table_block; ! SET parameter = SELECT MAX(parameter_id) AS next_id FROM mx_table_parameter; ! ! SET function.next_id = function.next_id + 1; ! INSERT INTO mx_table_function VALUES('{function.next_id}', '{module.module_id}', 'IncludeX', 'IncludeX Block, include file or url', 'mx_include_file.php', NULL); ! ! SET block.next_id = block.next_id + 1; ! INSERT INTO mx_table_block VALUES('{block.next_id}', 'IncludeX', 'IncludeX Block, include file or url', '{function.next_id}', '0', '0', '0', '', '', '', '', '1', '1', '0', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'include_file', 'Text', '0', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', '0', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'show_title', 'Boolean', 'TRUE', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', 'TRUE', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'iframe_mode', 'Boolean', 'FALSE', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', 'FALSE', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'include_url', 'Text', 'http://www.mx-system.com', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', 'http://www.mx-system.com', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'iframe_height', '300', '0', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', '0', '', '0'); ! ! # ------------------------------------------------------------ ! # ! # New Parameters for Function 'Navigation Menu' (added by Jaime) ! # ! SET function = SELECT * FROM mx_table_function WHERE function_name = 'Navigation Menu'; ! SET block = SELECT * FROM mx_table_block WHERE block_title = 'Navigation Menu'; ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.function_id}', 'menu_display_mode', 'Text', 'Vertical', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.block_id}', '{parameter.next_id}', 'Vertical', NULL); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.function_id}', 'menu_page_sync', 'Text', '0', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.block_id}', '{parameter.next_id}', '0', NULL); ! ! # ------------------------------------------------------------ ! # ! # New Fields in Table `mx_menu_categories` (added by Jaime) ! # ! ALTER TABLE mx_table_menu_categories ADD cat_url SMALLINT(5) UNSIGNED DEFAULT '0'; ! ALTER TABLE mx_table_menu_categories ADD cat_target TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL; ! ! # ------------------------------------------------------------ ! # ! # New Table `mx_page_templates` (added by Jaime) ! # ! CREATE TABLE mx_table_page_templates ( ! page_template_id SMALLINT(3) UNSIGNED NOT NULL auto_increment, ! template_name VARCHAR(255) NOT NULL DEFAULT '', ! PRIMARY KEY (page_template_id) ! ); ! 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'); ! ! # ------------------------------------------------------------ ! # ! # New Table `mx_column_templates` (added by Jaime) ! # ! CREATE TABLE mx_table_column_templates ( ! column_template_id SMALLINT(5) UNSIGNED NOT NULL auto_increment, ! column_title VARCHAR(100) DEFAULT '0', ! column_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', ! column_size VARCHAR(5) DEFAULT '0', ! page_template_id SMALLINT(5) NOT NULL DEFAULT '0', ! PRIMARY KEY (column_template_id), ! KEY cat_order (column_order) ! ); ! INSERT INTO mx_table_column_templates VALUES('1', 'Left', '10', '200', '2'); ! INSERT INTO mx_table_column_templates VALUES('2', 'Right', '20', '100%', '2'); ! INSERT INTO mx_table_column_templates VALUES('3', 'Left', '10', '100%', '3'); ! INSERT INTO mx_table_column_templates VALUES('4', 'Right', '20', '200', '3'); ! INSERT INTO mx_table_column_templates VALUES('5', 'Left', '10', '150', '4'); ! INSERT INTO mx_table_column_templates VALUES('6', 'Middle', '20', '100%', '4'); ! INSERT INTO mx_table_column_templates VALUES('7', 'Right', '30', '150', '4'); ! ! # ------------------------------------------------------------ --- 1,99 ---- ! # ! # mxBB-Portal - MySQL Schema - Upgrade "2.7.4" ! # ! # $Id$ ! # ! ! # ------------------------------------------------------------ ! # ! # New Function, Block and Parameters 'IncludeX' ! # ! SET module = SELECT * FROM mx_table_module WHERE module_name = 'Core Blocks'; ! SET function = SELECT MAX(function_id) AS next_id FROM mx_table_function; ! SET block = SELECT MAX(block_id) AS next_id FROM mx_table_block; ! SET parameter = SELECT MAX(parameter_id) AS next_id FROM mx_table_parameter; ! ! SET function.next_id = function.next_id + 1; ! INSERT INTO mx_table_function VALUES('{function.next_id}', '{module.module_id}', 'IncludeX', 'IncludeX Block, include file or url', 'mx_include_file.php', NULL); ! ! SET block.next_id = block.next_id + 1; ! INSERT INTO mx_table_block VALUES('{block.next_id}', 'IncludeX', 'IncludeX Block, include file or url', '{function.next_id}', '0', '0', '0', '', '', '', '', '1', '1', '0', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'include_file', 'Text', '0', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', '0', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'show_title', 'Boolean', 'TRUE', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', 'TRUE', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'iframe_mode', 'Boolean', 'FALSE', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', 'FALSE', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'include_url', 'Text', 'http://www.mx-system.com', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', 'http://www.mx-system.com', '', '0'); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.next_id}', 'iframe_height', '300', '0', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.next_id}', '{parameter.next_id}', '0', '', '0'); ! ! # ------------------------------------------------------------ ! # ! # New Parameters for Function 'Navigation Menu' (added by Jaime) ! # ! SET function = SELECT * FROM mx_table_function WHERE function_name = 'Navigation Menu'; ! SET block = SELECT * FROM mx_table_block WHERE block_title = 'Navigation Menu'; ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.function_id}', 'menu_display_mode', 'Text', 'Vertical', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.block_id}', '{parameter.next_id}', 'Vertical', NULL); ! ! SET parameter.next_id = parameter.next_id + 1; ! INSERT INTO mx_table_parameter VALUES('{parameter.next_id}', '{function.function_id}', 'menu_page_sync', 'Text', '0', ''); ! INSERT INTO mx_table_block_system_parameter VALUES('{block.block_id}', '{parameter.next_id}', '0', NULL); ! ! # ------------------------------------------------------------ ! # ! # New Fields in Table `mx_menu_categories` (added by Jaime) ! # ! ALTER TABLE mx_table_menu_categories ADD cat_url SMALLINT(5) UNSIGNED DEFAULT '0'; ! ALTER TABLE mx_table_menu_categories ADD cat_target TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL; ! ! # ------------------------------------------------------------ ! # ! # New Table `mx_page_templates` (added by Jaime) ! # ! CREATE TABLE mx_table_page_templates ( ! page_template_id SMALLINT(3) UNSIGNED NOT NULL auto_increment, ! template_name VARCHAR(255) NOT NULL DEFAULT '', ! PRIMARY KEY (page_template_id) ! ); ! 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'); ! ! # ------------------------------------------------------------ ! # ! # New Table `mx_column_templates` (added by Jaime) ! # ! CREATE TABLE mx_table_column_templates ( ! column_template_id SMALLINT(5) UNSIGNED NOT NULL auto_increment, ! column_title VARCHAR(100) DEFAULT '0', ! column_order SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', ! column_size VARCHAR(5) DEFAULT '0', ! page_template_id SMALLINT(5) NOT NULL DEFAULT '0', ! PRIMARY KEY (column_template_id), ! KEY cat_order (column_order) ! ); ! INSERT INTO mx_table_column_templates VALUES('1', 'Left', '10', '200', '2'); ! INSERT INTO mx_table_column_templates VALUES('2', 'Right', '20', '100%', '2'); ! INSERT INTO mx_table_column_templates VALUES('3', 'Left', '10', '100%', '3'); ! INSERT INTO mx_table_column_templates VALUES('4', 'Right', '20', '200', '3'); ! INSERT INTO mx_table_column_templates VALUES('5', 'Left', '10', '150', '4'); ! INSERT INTO mx_table_column_templates VALUES('6', 'Middle', '20', '100%', '4'); ! INSERT INTO mx_table_column_templates VALUES('7', 'Right', '30', '150', '4'); ! ! # ------------------------------------------------------------ Index: mysql_schema_install_2.7.1.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install_2.7.1.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** mysql_schema_install_2.7.1.sql 20 Mar 2005 03:37:05 -0000 1.1 --- mysql_schema_install_2.7.1.sql 13 Apr 2005 21:23:27 -0000 1.2 *************** *** 1,393 **** ! # ! # mxBB-Portal - MySQL Schema - version 2.7.1 ! # ! # $Id$ ! # ! ! # -------------------------------------------------------- ! ! # ! # Table structure for table `mx_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` ! # ! ! 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) ! ); ! ! # ! # 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 (if allowed by phpbb config), 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 (if allowed by phpbb config) 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 (if allowed by phpbb config) 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` ! # ! ! 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` ! # ! ! 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` ! # ! ! 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... [truncated message content] |
