Menu
▾
▴
[mxbb-commits] core/install/schemas mysql_schema_install_2.9.2.sql, NONE, 1.1 mysql_schema_install.sql, 1.52, 1.53
|
From: Jon O. <jon...@us...> - 2008-02-11 22:47:18
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv6223 Modified Files: mysql_schema_install.sql Added Files: mysql_schema_install_2.9.2.sql Log Message: New install schema for 2.9.x. Removed phpBB2 stuff, and simplified welcome page. --- NEW FILE: mysql_schema_install_2.9.2.sql --- # MySQL-Front Dump 2.4 # # Host: localhost Database: MX-Publisher #-------------------------------------------------------- # Server version 3.23.51-nt # # Table structure for table 'mx_table_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) NOT NULL default '0', `auth_delete` tinyint(2) NOT NULL default '0', `auth_view_group` varchar(255) NOT NULL default '0', `auth_edit_group` varchar(255) NOT NULL default '0', `auth_delete_group` varchar(255) NOT NULL default '0', `auth_moderator_group` varchar(255) NOT NULL default '0', `show_title` tinyint(2) unsigned NOT NULL default '1', `show_block` tinyint(2) unsigned NOT NULL default '1', `show_stats` tinyint(2) unsigned NOT NULL default '0', `block_time` varchar(255) binary NOT NULL default '', `block_editor_id` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`block_id`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_block' # INSERT INTO mx_table_block VALUES("1", "phpBB TextBlock", "This is a Demo Block", "24", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1125865999", "2"); INSERT INTO mx_table_block VALUES("2", "Split Block", "This is a Demo Block", "11", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1144407740", "2"); INSERT INTO mx_table_block VALUES("3", "Site Log", "This is a Demo Block", "10", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841954", "2"); INSERT INTO mx_table_block VALUES("4", "Dynamic Block", "This is a Demo Block", "3", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841802", "2"); INSERT INTO mx_table_block VALUES("6", "Poll", "This is a Demo Block", "14", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841942", "2"); INSERT INTO mx_table_block VALUES("7", "Language Select", "This is a Demo Block", "6", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841887", "2"); INSERT INTO mx_table_block VALUES("8", "Navigation Menu", "This is a vertical Navigation Menu Demo Block", "51", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1126034018", "2"); INSERT INTO mx_table_block VALUES("9", "mxBB TextBlock", "This is a Demo Block", "22", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1144408393", "2"); INSERT INTO mx_table_block VALUES("10", "WYSIWYG TextBlock", "This is a Demo Block", "23", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1144408349", "2"); INSERT INTO mx_table_block VALUES("13", "Login", "This is a Demo Block", "7", "9", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125867452", "2"); INSERT INTO mx_table_block VALUES("14", "Theme Select", "This is a Demo Block", "12", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841964", "2"); INSERT INTO mx_table_block VALUES("15", "Site Search", "Site Search", "15", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841954", "2"); INSERT INTO mx_table_block VALUES("16", "Last Message Post", "This is a Demo Block", "31", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125842159", "2"); INSERT INTO mx_table_block VALUES("18", "Announcements", "This is a Demo Block", "2", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125868467", "2"); INSERT INTO mx_table_block VALUES("19", "Who is Online?", "This is a Demo Block", "13", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841983", "2"); INSERT INTO mx_table_block VALUES("21", "Google", "This is a Demo Block", "4", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1126033253", "2"); INSERT INTO mx_table_block VALUES("24", "Forum", "This is a Demo Block", "8", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841817", "2"); INSERT INTO mx_table_block VALUES("25", "Navigation Menu", "This is a horizontal Navigation Menu Demo Block", "51", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1144406422", "2"); INSERT INTO mx_table_block VALUES("26", "Statistics", "This is a Demo Block", "41", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125842177", "2"); INSERT INTO mx_table_block VALUES("27", "IncludeX", "This is a Demo Block", "5", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1125841878", "2"); INSERT INTO mx_table_block VALUES("28", "Welcome", "This is the firstpage welcome block", "24", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1144408417", "2"); INSERT INTO mx_table_block VALUES("29", "Demo Pages", "Introduction", "24", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1144407996", "2"); INSERT INTO mx_table_block VALUES("30", "Modules Info", "Introduction", "24", "0", "5", "0", "0", "0", "0", "0", "1", "1", "1", "1144407795", "2"); INSERT INTO mx_table_block VALUES("31", "Page Navigation", "This is a page navigation menu", "52", "0", "5", "0", "0", "0", "0", "0", "1", "1", "0", "1144406422", "2"); # # Table structure for table 'mx_table_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, `parameter_opt` text, `sub_id` int(255) unsigned NOT NULL default '0', PRIMARY KEY (`block_id`,`parameter_id`,`sub_id`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_block_system_parameter' # INSERT INTO mx_table_block_system_parameter VALUES("1", "15", "This is a [i:d4ee1ca70a]standard [/i:d4ee1ca70a]TextBlock, featuring BBCode, HTML, and smilies, as defined by the phpBB config settings.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)", "d4ee1ca70a", "0"); INSERT INTO mx_table_block_system_parameter VALUES("2", "60", "16,13,9", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("2", "61", "33%, 33%,*", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("2", "62", "4", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("3", "91", "3 months", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("3", "92", "5", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("4", "80", "29", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("6", "36", "", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("6", "13", "0", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("8", "66", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("8", "93", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("8", "63", "Vertical", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("25", "66", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("25", "93", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("25", "63", "Horizontal", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("31", "100", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("31", "101", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("31", "102", "Overall_navigation", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "50", "This is basically a [i:021a122fa6]standard[/i:021a122fa6] TextBlock, but you may configure settings for bbcodes, html and smilies for [i:021a122fa6]this[/i:021a122fa6] block.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)", "021a122fa6", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "51", "none", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "52", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "53", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "56", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "54", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "57", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("9", "55", "b,i,u,img", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("10", "16", "<table width=\"100%\" cellpadding=\"2\" border=\"0\"><tbody><tr><td valign=\"top\" align=\"left\" class=\"row2\"><span class=\"genmed\"><strong>Mon</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- MÅNDAG -->Busy with <em>this and that</em></span></td></tr><tr><td valign=\"top\" align=\"left\" class=\"row1\"><span class=\"genmed\"><strong>Tue</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TISDAG-->Not so busy</span></td></tr><tr><td valign=\"top\" align=\"left\" class=\"row2\"><span class=\"genmed\"><strong>Wen</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- ONSDAG-->Very busy</span></td></tr><tr><td valign=\"top\" align=\"left\" class=\"row1\"><span class=\"genmed\"><strong>Thu</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TORSDAG-->Lazy</span></td></tr><tr><td valign=\"top\" align=\"left\" class=\"row2\"><span class=\"genmed\"><strong>Fri</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- FREDAG-->Resting...</span></td></tr></tbody></table><p>This basic table structure is a nice demonstration in which the wysiwyg editor comes in handy!</p><p>Try it out! <br />(to edit use the top right edit button)</p><p>Note: The wysiwyg editor is a 3rd party product (tinyMCE), and must be installed separately. Visit <a target=\"_blank\" href=\"http://www.moxiecode.com\">Moxiecode Systems AB</a> to get the software and place the \'tinymce\' folder in the root/modules/mx_shared directory. </p>", "0", "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "17", "5", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "18", "TRUE", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "19", "30", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "20", "_self", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "21", "left", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "22", "TRUE", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "37", "", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "38", "FALSE", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "39", "FALSE", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "40", "TRUE", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "95", "5", NULL, "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "1", "3", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "2", "10", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "3", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "4", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "5", "FALSE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "7", "thumb_news.gif", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "8", "thumb_globe.gif", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "9", "thumb_globe.gif", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "6", "TRUE", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "10", "thumb_globe.gif", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("18", "11", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("27", "70", "x_iframe", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("27", "71", "/docs", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("27", "72", "325", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("27", "73", "", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("28", "15", "[b:31f05e4fa3]MX-Publisher[/b:31f05e4fa3] is a fully modular portal and CMS for phpBB, featuring dynamic pages, blocks, themes, and more by means of a powerful yet flexible AdminCP. It works without touching phpBB by using integrated features and functions. MX-Publisher requires phpBB to run, and currently supports the mySQL and postgreSQL databases, with planned support for MS-SQL and other DBMSs. MX-Publisher is the classical phpBB portal add-on, improved and enhanced for every phpBB version released since 2001.\r\n\r\n[i:31f05e4fa3]Welcome, and thanks for using MX-Publisher![/i:31f05e4fa3] \r\n\r\n :lol:", "31f05e4fa3", "0"); INSERT INTO mx_table_block_system_parameter VALUES("29", "15", "On this page we [i:621ded23c6]demonstrate [/i:621ded23c6]a few basic portal blocks (not already present on this or other pages) - to get you started. Please, try out the top links.", "621ded23c6", "0"); INSERT INTO mx_table_block_system_parameter VALUES("30", "15", "You may enrich your portal with addon modules - for specific functionality:\r\n\r\n- Download manager\r\n- Picture Album\r\n- Calendar Tools\r\n- Knowledge Base\r\n- Links Gallery\r\n- Games\r\n\r\nand many more. Be sure to visit www.mx-publisher.com for latest available modules!", "eacbc1f61a", "0"); # # Table structure for table 'mx_table_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`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_column' # INSERT INTO mx_table_column VALUES("8", "Main", "50", NULL, "100%", "4"); INSERT INTO mx_table_column VALUES("2", "Main", "35", NULL, "100%", "1"); INSERT INTO mx_table_column VALUES("7", "Left", "40", NULL, "200", "4"); INSERT INTO mx_table_column VALUES("6", "Main", "50", NULL, "100%", "3"); INSERT INTO mx_table_column VALUES("5", "Left", "40", NULL, "200", "3"); INSERT INTO mx_table_column VALUES("4", "Main", "50", NULL, "100%", "2"); INSERT INTO mx_table_column VALUES("1", "Left", "25", NULL, "200", "1"); INSERT INTO mx_table_column VALUES("3", "Left", "40", NULL, "200", "2"); INSERT INTO mx_table_column VALUES("10", "Main", "50", NULL, "100%", "5"); INSERT INTO mx_table_column VALUES("9", "Left", "40", NULL, "200", "5"); # # Table structure for table 'mx_table_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', PRIMARY KEY (`column_id`, `block_id`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_column_block' # INSERT INTO mx_table_column_block VALUES("5", "14", "40"); INSERT INTO mx_table_column_block VALUES("4", "19", "20"); INSERT INTO mx_table_column_block VALUES("8", "19", "20"); INSERT INTO mx_table_column_block VALUES("4", "24", "10"); INSERT INTO mx_table_column_block VALUES("1", "13", "20"); INSERT INTO mx_table_column_block VALUES("3", "16", "20"); INSERT INTO mx_table_column_block VALUES("5", "3", "30"); INSERT INTO mx_table_column_block VALUES("2", "19", "20"); INSERT INTO mx_table_column_block VALUES("2", "28", "10"); INSERT INTO mx_table_column_block VALUES("1", "8", "10"); INSERT INTO mx_table_column_block VALUES("6", "25", "10"); INSERT INTO mx_table_column_block VALUES("8", "26", "10"); INSERT INTO mx_table_column_block VALUES("7", "8", "10"); INSERT INTO mx_table_column_block VALUES("6", "4", "20"); INSERT INTO mx_table_column_block VALUES("5", "8", "10"); INSERT INTO mx_table_column_block VALUES("6", "19", "30"); INSERT INTO mx_table_column_block VALUES("5", "7", "20"); INSERT INTO mx_table_column_block VALUES("3", "13", "30"); INSERT INTO mx_table_column_block VALUES("3", "8", "10"); INSERT INTO mx_table_column_block VALUES("10", "15", "10"); INSERT INTO mx_table_column_block VALUES("9", "8", "10"); # # Table structure for table 'mx_table_column_templates' # DROP TABLE IF EXISTS mx_table_column_templates; 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`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_column_templates' # INSERT INTO mx_table_column_templates VALUES("1", "Left", "40", "200", "2"); INSERT INTO mx_table_column_templates VALUES("2", "Main", "50", "100%", "2"); INSERT INTO mx_table_column_templates VALUES("3", "Main", "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", "180", "4"); INSERT INTO mx_table_column_templates VALUES("6", "Middle", "20", "100%", "4"); INSERT INTO mx_table_column_templates VALUES("7", "Right", "30", "180", "4"); # # Table structure for table 'mx_table_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`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_function' # INSERT INTO mx_table_function VALUES("8", "30", "phpBB Index", "phpBB Index Block", "mx_forum.php", ""); INSERT INTO mx_table_function VALUES("51", "50", "User Navigation Menu", "Site Navigation", "mx_menu_nav.php", ""); INSERT INTO mx_table_function VALUES("52", "50", "Page Navigation Menu", "Site Navigation", "mx_site_nav.php", ""); INSERT INTO mx_table_function VALUES("14", "30", "mxBB Polls", "mxBB Polls", "mx_poll.php", ""); INSERT INTO mx_table_function VALUES("6", "10", "Language Select", "Language Select Block", "mx_language.php", ""); INSERT INTO mx_table_function VALUES("7", "10", "Login", "Login Block", "mx_login.php", ""); INSERT INTO mx_table_function VALUES("12", "10", "Theme Select", "Theme Select Block", "mx_theme.php", ""); INSERT INTO mx_table_function VALUES("4", "10", "Google Search", "Google Search Block", "mx_google.php", ""); INSERT INTO mx_table_function VALUES("2", "30", "phpBB Announcements", "phpBB Announcements Block", "mx_announce.php", ""); INSERT INTO mx_table_function VALUES("13", "10", "Who is Online", "Who is Online Block", "mx_online.php", ""); INSERT INTO mx_table_function VALUES("11", "10", "Split Block", "Split Block Function - a block that puts subblocks side by side", "mx_multiple_blocks.php", ""); INSERT INTO mx_table_function VALUES("24", "20", "TextBlock (phpBB)", "BBcodes, html and smilies - defined by phpBB config", "mx_textblock_bbcode.php", ""); INSERT INTO mx_table_function VALUES("23", "20", "TextBlock (Html/wysiwyg)", "Plain html textblock, or featuring a wysiwyg editor", "mx_textblock_html.php", ""); INSERT INTO mx_table_function VALUES("22", "20", "TextBlock (Customized)", "Textblock, featuring block defined settings", "mx_textblock_multi.php", ""); INSERT INTO mx_table_function VALUES("31", "30", "Last Posts", "phpBB Last Posts Function", "mx_last_msg.php", ""); INSERT INTO mx_table_function VALUES("41", "30", "Statistics", "Site Statistics Function", "mx_statistics.php", ""); INSERT INTO mx_table_function VALUES("5", "10", "IncludeX", "Include a iframe, site, multimedia or file", "mx_includex.php", ""); INSERT INTO mx_table_function VALUES("3", "10", "DynamicBlock", "Dynamic block, defined by its block_id", "mx_dynamic.php", ""); INSERT INTO mx_table_function VALUES("10", "10", "Site Log", "Site Log monitor", "mx_site_log.php", ""); INSERT INTO mx_table_function VALUES("15", "10", "Site Search", "Site Search Block", "mx_search.php", ""); # # Table structure for table 'mx_table_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', `cat_url` smallint(5) unsigned default '0', `cat_target` tinyint(2) unsigned NOT NULL default '0', PRIMARY KEY (`cat_id`), KEY `cat_order` (`cat_order`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_menu_categories' # INSERT INTO mx_table_menu_categories VALUES("8", "1", "Resources", "20", "c1affc0aaa", "", "0", "0", "0"); INSERT INTO mx_table_menu_categories VALUES("8", "3", "Home", "10", "eab7a16ce5", "", "1", "1", "0"); INSERT INTO mx_table_menu_categories VALUES("25", "4", "Core Blocks", "40", "a5abf5b8c4", "Demo Core blocks", "1", "0", "0"); INSERT INTO mx_table_menu_categories VALUES("25", "5", "TextBlocks", "50", "fa33545edc", "Demo TextBlocks", "0", "0", "0"); INSERT INTO mx_table_menu_categories VALUES("25", "6", "Modules", "60", "7dafcede48", "Modules Info", "0", "0", "0"); # # Table structure for table 'mx_table_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, `menu_alt_icon` varchar(255) default NULL, `menu_alt_icon_hot` 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`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_menu_nav' # INSERT INTO mx_table_menu_nav VALUES("7", "4", "Split Block", "Split block Demo", "", "0", "10", "043673560e", "icon_dot.gif", "", "", "0", "2", "0", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("8", "4", "Google Block", "Google Block Demo", "", "0", "20", "795e2489d7", "icon_dot.gif", "", "", "0", "21", "0", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("9", "4", "phpBB Announcements (if any)", "phpBB Announcements Demo", "", "0", "30", "29add66982", "icon_dot.gif", "", "", "0", "18", "0", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("10", "4", "IncludeX", "IncludeX Demo", "", "0", "40", "f7adaf1201", "icon_dot.gif", "", "", "0", "27", "0", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("11", "4", "phpBB Polls (if any)", "phpBB Polls Demo", "", "0", "50", "a80fe73aee", "icon_dot.gif", "", "", "0", "6", "0", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("12", "5", "phpBB TextBlock", "phpBB TextBlock Demo", "", "0", "10", "85d178caa8", "icon_dot.gif", "", "", "0", "1", "3", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("13", "5", "WYSIWYG TextBlock", "WYSIWYG TextBlock Demo", "", "0", "20", "51e2ddb3a7", "icon_dot.gif", "", "", "0", "10", "3", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("14", "5", "Custom TextBlock", "Custom TextBlock Demo", "", "0", "30", "22cb7a4f9f", "icon_dot.gif", "", "", "0", "9", "3", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("15", "6", "Modules Info", "Information", "", "0", "10", "630ce0e7f0", "icon_dot.gif", "", "", "0", "30", "3", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("5", "1", "phpBB Home", "", "http://www.phpbb.com", "0", "20", "a9ff189bf5", "icon_info.gif", "", "", "0", "0", "0", "0", "1"); INSERT INTO mx_table_menu_nav VALUES("3", "3", "Statistics", "Site Statistics", "", "0", "30", "98b16ec029", "icon_stats.gif", "", "", "0", "0", "4", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("4", "1", "MX-Publisher Home", "", "http://www.mx-publisher.com", "0", "10", "1f171544ea", "icon_info.gif", "", "", "0", "0", "0", "0", "1"); INSERT INTO mx_table_menu_nav VALUES("6", "1", "Demo Pages", "On this page are several demo blocks located", "", "0", "30", "fb028ba583", "icon_dot.gif", "", "", "0", "0", "3", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("1", "3", "Home", "Back to home", "", "0", "10", "bb51181967", "icon_home.gif", "", "", "0", "0", "1", "0", "0"); INSERT INTO mx_table_menu_nav VALUES("2", "3", "Forum", "phpBB Forum Index", "", "0", "20", "a33e401abc", "icon_forum.gif", "", "", "0", "0", "2", "0", "0"); # # Table structure for table 'mx_table_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', `module_version` varchar(255) default NULL, `module_copy` text, PRIMARY KEY (`module_id`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_module' # #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (10, 'Core Blocks', 'modules/mx_coreblocks/', 'MX-Publisher Core Blocks', '', 'mxBB Core Module', 'Original mxBB <i>Core Blocks</i> module by <a href="http://www.mx-publisher.com" target="_blank">The mxBB Development Team</a>'); #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (20, 'Textblocks', 'modules/mx_textblocks/', 'MX-Publisher Textblocks', '', 'mxBB Core Module', 'Original mxBB <i>Textblocks</i> module by <a href="http://www.mx-publisher.com" target="_blank">Jon</a>'); #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (30, 'phpBB2 Blocks', 'modules/mx_phpbb2blocks/', 'MX-Publisher phpBB2 blocks', '', 'mxBB Core Module', 'Original mxBB <i>phpBB2 Blocks</i> module by <a href="http://www.mx-publisher.com" target="_blank"> The mxBB Development Team</a>'); #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (40, 'Users and Groups', 'modules/mx_users/', 'Users and Group adminCP', '1', 'mxBB Core Module', 'Based on original phpBB <i>Admin Tool MODs</i> by Adam Alkins, Omar Ramadan & wGEric :: Adapted for mxBB by <a href="http://www.mx-publisher.com" target="_blank">Jon</a>'); #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (50, 'Navigation Menu', 'modules/mx_navmenu/', 'MX-Publisher Site Navigation', '', 'mxBB Core Module', 'Original mxBB <i>Navigation Menu</i> module by <a href="http://www.mx-publisher.com" target="_blank">Jon</a>'); INSERT INTO mx_table_module VALUES("10", "Core Blocks", "modules/mx_coreblocks/", "MX-Publisher Core Blocks", "", "mxBB Core Module", "Original mxBB <i>Core Blocks</i> module by <a href=\"http://www.mx-publisher.com\" target=\"_blank\">The MX-Publisher Development Team</a>"); INSERT INTO mx_table_module VALUES("20", "Textblocks", "modules/mx_textblocks/", "MX-Publisher Textblocks", "", "mxBB Core Module", "Original mxBB <i>Textblocks</i> module by <a href=\"http://www.mx-publisher.com\" target=\"_blank\">Jon</a>"); INSERT INTO mx_table_module VALUES("30", "phpBB2 Blocks", "modules/mx_phpbb2blocks/", "MX-Publisher phpBB2 blocks", "", "mxBB Core Module", "Original mxBB <i>phpBB2 Blocks</i> module by <a href=\"http://www.mx-publisher.com\" target=\"_blank\"> The MX-Publisher Development Team</a>"); INSERT INTO mx_table_module VALUES("40", "Users and Groups", "modules/mx_users/", "Users and Group adminCP", "1", "mxBB Core Module", "Based on original phpBB <i>Admin Tool MODs</i> by Adam Alkins, Omar Ramadan & wGEric :: Adapted for MX-Publisher by <a href=\"http://www.mx-publisher.com\" target=\"_blank\">Jon</a>"); INSERT INTO mx_table_module VALUES("50", "Navigation Menu", "modules/mx_navmenu/", "MX-Publisher Site Navigation", "", "mxBB Core Module", "Original mxBB <i>Navigation Menu</i> module by <a href=\"http://www.mx-publisher.com\" target=\"_blank\">Jon</a>"); # # Table structure for table 'mx_table_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_desc` varchar(255) default NULL, `page_parent` int(50) default '0', `parents_data` text NOT NULL, `page_order` smallint(5) default '0', `page_icon` varchar(255) default NULL, `page_alt_icon` varchar(255) default NULL, `menu_icon` varchar(255) default NULL, `menu_alt_icon` varchar(255) default NULL, `menu_alt_icon_hot` varchar(255) default NULL, `menu_active` tinyint(2) default '1', `auth_view` tinyint(2) NOT NULL default '0', `auth_view_group` varchar(255) NOT NULL default '0', `auth_moderator_group` varchar(255) NOT NULL default '0', `default_style` smallint(5) NOT NULL default '-1', `override_user_style` smallint(2) NOT NULL default '-1', `page_header` varchar(255) default '', `page_footer` varchar(255) default '', `page_main_layout` varchar(255) default '', `navigation_block` smallint(5) unsigned NOT NULL default '0', `ip_filter` varchar(255) NOT NULL default '', `phpbb_stats` tinyint(2) NOT NULL default '-1', PRIMARY KEY (`page_id`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_page' # INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "0", "", "10","icon_home.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "0", "", "20","icon_forum.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "overall_header_navigation_phpbb.tpl", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1"); INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "0", "", "30","icon_docs.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "0", "", "40","icon_stats.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); INSERT INTO mx_table_page VALUES("5", "Site Search", "Site Search page", "0", "", "50","icon_search.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1"); # # Table structure for table 'mx_table_page_templates' # DROP TABLE IF EXISTS mx_table_page_templates; 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`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_page_templates' # 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"); # # Table structure for table 'mx_table_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, `parameter_auth` tinyint(2) NOT NULL default '0', `parameter_order` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`parameter_id`) ) TYPE=MyISAM; # # Dumping data for table 'mx_table_parameter' # INSERT INTO mx_table_parameter VALUES("1", "2", "announce_nbr_display", "Number", "1", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("2", "2", "announce_nbr_days", "Number", "14", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("3", "2", "announce_display", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("4", "2", "announce_display_sticky", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("5", "2", "announce_display_normal", "Boolean", "FALSE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("7", "2", "announce_img", "Text", "thumb_globe.gif", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("8", "2", "announce_img_sticky", "Text", "thumb_globe.gif", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("9", "2", "announce_img_normal", "Text", "thumb_globe.gif", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("6", "2", "announce_display_global", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("10", "2", "announce_img_global", "Text", "thumb_globe.gif", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("11", "2", "announce_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0", "0"); INSERT INTO mx_table_parameter VALUES("13", "14", "Poll_Display", "Function", "0", "poll_select( {parameter_value}, \"{parameter_id}\" )", "0", "0"); INSERT INTO mx_table_parameter VALUES("36", "14", "poll_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0", "0"); INSERT INTO mx_table_parameter VALUES("15", "24", "Text", "phpBBTextBlock", "Insert your text here", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("16", "23", "Html", "WysiwygTextBlock", "Entre your Html code here", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("17", "31", "Last_Msg_Number_Title", "Number", "15", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("18", "31", "Last_Msg_Display_Date", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("19", "31", "Last_Msg_Title_Length", "Number", "30", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("20", "31", "Last_Msg_Target", "Values", "_blank", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("21", "31", "Last_Msg_Align", "Values", "left", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("22", "31", "Last_Msg_Display_Forum", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("37", "31", "Last_Msg_forum", "Function", "", "get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)", "0", "0"); INSERT INTO mx_table_parameter VALUES("38", "31", "Last_Msg_Display_Last_Author", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("39", "31", "Last_Msg_Display_Author", "Boolean", "FALSE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("40", "31", "Last_Msg_Display_Icon_View", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("50", "22", "Text", "CustomizedTextBlock", "Enter your block text here", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("51", "22", "text_style", "Text", "none", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("52", "22", "block_style", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("53", "22", "title_style", "Boolean", "TRUE", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("91", "10", "log_filter_date", "Menu_single_select", "1 month", "a:12:{i:0;s:8:\"no limit\";i:1;s:5:\"1 day\";i:2;s:6:\"2 days\";i:3;s:6:\"3 days\";i:4;s:6:\"1 week\";i:5;s:7:\"2 weeks\";i:6;s:7:\"3 weeks\";i:7;s:7:\"1 month\";i:8;s:8:\"2 months\";i:9;s:8:\"3 months\";i:10;s:8:\"6 months\";i:11;s:6:\"1 year\";}", "0", "0"); INSERT INTO mx_table_parameter VALUES("60", "11", "block_ids", "Function", "1,2,3", "get_list_multiple( \"{parameter_id}[]\", BLOCK_TABLE, \'block_id\', \'block_title\', \"{parameter_value}\", TRUE, \'block_desc\')", "0", "0"); INSERT INTO mx_table_parameter VALUES("61", "11", "block_sizes", "Text", "20%,30%,*", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("62", "11", "space_between", "Number", "4", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("80", "3", "default_block_id", "Function", "0", "get_list_formatted(\"block_list\",\"{parameter_value}\",\"{parameter_id}[]\")", "0", "0"); INSERT INTO mx_table_parameter VALUES("70", "5", "x_mode", "Menu_single_select", "x_iframe", "a:6:{i:0;s:8:\"x_listen\";i:1;s:8:\"x_iframe\";i:2;s:10:\"x_textfile\";i:3;s:12:\"x_multimedia\";i:4;s:5:\"x_pic\";i:5;s:8:\"x_format\";}", "0", "0"); INSERT INTO mx_table_parameter VALUES("71", "5", "x_1", "Text", "/docs", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("72", "5", "x_2", "Text", "325", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("73", "5", "x_3", "Text", "", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("66", "51", "Nav menu", "nav_menu", "", "", "0", "10"); INSERT INTO mx_table_parameter VALUES("93", "51", "menu_custom_tpl", "Text", "", "", "0", "20"); INSERT INTO mx_table_parameter VALUES("63", "51", "menu_display_mode", "Radio_single_select", "Vertical", "a:3:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";i:2;s:18:\"Overall_navigation\";}", "0", "30"); INSERT INTO mx_table_parameter VALUES("100", "52", "Site menu", "site_menu", "", "", "0", "10"); INSERT INTO mx_table_parameter VALUES("101", "52", "menu_custom_tpl", "Text", "", "", "0", "20"); INSERT INTO mx_table_parameter VALUES("102", "52", "menu_display_mode", "Radio_single_select", "Overall_navigation", "a:3:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";i:2;s:18:\"Overall_navigation\";}", "0", "30"); INSERT INTO mx_table_parameter VALUES("92", "10", "numOfEvents", "Number", "5", "", "0", "0"); INSERT INTO mx_table_parameter VALUES("57", "22", "allow_smilies", "Boolean", "TRUE", "", "1", "0"); INSERT INTO mx_table_parameter VALUES("54", "22", "allow_html", "Boolean", "TRUE", "", "1", "0"); INSERT INTO mx_table_parameter VALUES("56", "22", "allow_bbcode", "Boolean", "TRUE", "", "1", "0"); INSERT INTO mx_table_parameter VALUES("55", "22", "html_tags", "Text", "b,i,u", "", "1", "0"); INSERT INTO mx_table_parameter VALUES("95", "31", "msg_filter_date", "Function", "5", "get_list_static(\"{parameter_id}[]\",array(\"no limit\", \"1 day\", \"2 days\", \"3 days\", \"1 week\", \"2 weeks\", \"3 weeks\", \"1 month\", \"2 months\", \"3 months\", \"6 months\", \"1 year\"),\"{parameter_value}\")", "0", "0"); # # Table structure for table 'mx_table_portal' # DROP TABLE IF EXISTS mx_table_portal; CREATE TABLE `mx_table_portal` ( `portal_id` smallint(2) unsigned NOT NULL auto_increment, `portal_name` varchar(255) NOT NULL default 'yourdomain.com', `portal_desc` varchar(255) NOT NULL default 'A _little_ text to describe your site', `portal_status` smallint(2) unsigned NOT NULL default '1', `disabled_message` varchar(255) NOT NULL default 'We are currently upgrading this site with latest MX-Publisher software.', `server_name` varchar(255) NOT NULL default 'www.myserver.tld', `script_path` varchar(255) NOT NULL default '/', `script_protocol` varchar(255) NOT NULL default 'http://', `server_port` varchar(255) NOT NULL default '80', `default_dateformat` varchar(255) NOT NULL default 'D M d, Y g:i a', `board_timezone` smallint(2) NOT NULL default '0', `gzip_compress` smallint(2) unsigned NOT NULL default '0', `mx_use_cache` smallint(2) unsigned NOT NULL default '1', `mod_rewrite` smallint(2) unsigned NOT NULL default '0', `cookie_domain` varchar(255) NOT NULL default '', `cookie_name` varchar(255) NOT NULL default 'mxbb29x', `cookie_path` varchar(255) NOT NULL default '/', `cookie_secure` smallint(2) unsigned NOT NULL default '0', `session_length` varchar(255) NOT NULL default '3600', `allow_autologin` smallint(2) unsigned NOT NULL default '1', `max_autologin_time` smallint(2) NOT NULL default '0', `max_login_attempts` smallint(2) NOT NULL default '5', `login_reset_time` varchar(255) NOT NULL default '30', `default_lang` varchar(255) NOT NULL default 'english', `default_style` smallint(5) NOT NULL default '-1', `override_user_style` smallint(2) unsigned NOT NULL default '1', `default_admin_style` smallint(5) NOT NULL default '-1', `overall_header` varchar(255) NOT NULL default 'overall_header_navigation.tpl', `overall_footer` varchar(255) NOT NULL default 'overall_footer.tpl', `main_layout` varchar(255) NOT NULL default 'mx_main_layout.tpl', `navigation_block` smallint(5) unsigned NOT NULL default '31', `top_phpbb_links` smallint(2) unsigned NOT NULL default '0', `allow_html` smallint(2) unsigned NOT NULL default '1', `allow_html_tags` varchar(255) NOT NULL default 'b,i,u,pre', `allow_bbcode` smallint(2) unsigned NOT NULL default '1', `allow_smilies` smallint(2) unsigned NOT NULL default '1', `smilies_path` varchar(255) NOT NULL default 'images/smiles', `board_email` varchar(255) NOT NULL default 'you...@yo...', `board_email_sig` varchar(255) NOT NULL default 'Thanks, the MX-Publisher Team', `smtp_delivery` smallint(2) unsigned NOT NULL default '0', `smtp_host` varchar(255) NOT NULL default '', `smtp_username` varchar(255) NOT NULL default '', `smtp_password` varchar(255) NOT NULL default '', `smtp_auth_method` varchar(255) NOT NULL default '', `portal_version` varchar(255) NOT NULL default '', `portal_recached` varchar(255) NOT NULL default '', `portal_backend` varchar(255) NOT NULL default 'internal', `portal_backend_path` varchar(255) NOT NULL default '', `portal_startdate` varchar(255) NOT NULL default '0', `rand_seed` varchar(255) NOT NULL default '0', `record_online_users` varchar(255) NOT NULL default '0', `record_online_date` varchar(255) NOT NULL default '0', PRIMARY KEY (`portal_id`) ) TYPE=MyISAM; # # Table structure for table 'mx_table_search_results' # DROP TABLE IF EXISTS mx_table_search_results; CREATE TABLE `mx_table_search_results` ( `search_id` int(11) unsigned NOT NULL default '0', `session_id` varchar(32) NOT NULL default '', `search_array` text NOT NULL, PRIMARY KEY (`search_id`), KEY `session_id` (`session_id`) ) TYPE=MyISAM; # # Table structure for table 'mx_table_wordlist' # DROP TABLE IF EXISTS mx_table_wordlist; CREATE TABLE `mx_table_wordlist` ( `word_text` varchar(50) binary NOT NULL default '', `word_id` mediumint(8) unsigned NOT NULL auto_increment, `word_common` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`word_text`), KEY `word_id` (`word_id`) ) TYPE=MyISAM; # # Table structure for table 'mx_table_wordmatch' # DROP TABLE IF EXISTS mx_table_wordmatch; CREATE TABLE `mx_table_wordmatch` ( `block_id` mediumint(8) unsigned NOT NULL default '0', `word_id` mediumint(8) unsigned NOT NULL default '0', `title_match` tinyint(1) NOT NULL default '0', KEY `block_id` (`block_id`), KEY `word_id` (`word_id`) ) TYPE=MyISAM; # # Table structure for table 'mx_table_user_group' # DROP TABLE IF EXISTS mx_table_user_group; CREATE TABLE mx_table_user_group ( group_id mediumint(8) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, user_pending tinyint(1), KEY group_id (group_id), KEY user_id (user_id) ); # # Table structure for table 'mx_table_groups' # DROP TABLE IF EXISTS mx_table_groups; CREATE TABLE mx_table_groups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) NOT NULL, group_description varchar(255) NOT NULL, group_moderator mediumint(8) DEFAULT '0' NOT NULL, group_single_user tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (group_id), KEY group_single_user (group_single_user) ); # -------------------------------------------------------- # # Table structure for table 'mx_table_sessions' # # Note that if you\'re running 3.23.x you may want to make # this table a type HEAP. This type of table is stored # within system memory and therefore for big busy boards # is likely to be noticeably faster than continually # writing to disk ... # DROP TABLE IF EXISTS mx_table_sessions; CREATE TABLE mx_table_sessions ( session_id char(32) DEFAULT '' NOT NULL, session_user_id mediumint(8) DEFAULT '0' NOT NULL, session_start int(11) DEFAULT '0' NOT NULL, session_time int(11) DEFAULT '0' NOT NULL, session_ip char(8) DEFAULT '0' NOT NULL, session_page int(11) DEFAULT '0' NOT NULL, session_logged_in tinyint(1) DEFAULT '0' NOT NULL, session_admin tinyint(2) DEFAULT '0' NOT NULL, PRIMARY KEY (session_id), KEY session_user_id (session_user_id), KEY session_id_ip_user_id (session_id, session_ip, session_user_id) ); # -------------------------------------------------------- # # Table structure for table `mx_table_sessions_keys` # DROP TABLE IF EXISTS mx_table_sessions_keys; CREATE TABLE mx_table_sessions_keys ( key_id varchar(32) DEFAULT '0' NOT NULL, user_id mediumint(8) DEFAULT '0' NOT NULL, last_ip varchar(8) DEFAULT '0' NOT NULL, last_login int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (key_id, user_id), KEY last_login (last_login) ); # -------------------------------------------------------- # # Table structure for table 'mx_table_users' # DROP TABLE IF EXISTS mx_table_users; CREATE TABLE mx_table_users ( user_id mediumint(8) NOT NULL, user_active tinyint(1) DEFAULT '1', username varchar(25) NOT NULL, user_password varchar(32) NOT NULL, user_session_time int(11) DEFAULT '0' NOT NULL, user_session_page smallint(5) DEFAULT '0' NOT NULL, user_lastvisit int(11) DEFAULT '0' NOT NULL, user_regdate int(11) DEFAULT '0' NOT NULL, user_level tinyint(4) DEFAULT '0', user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL, user_last_login_try int(11) DEFAULT '0' NOT NULL, user_email varchar(255), PRIMARY KEY (user_id), KEY user_session_time (user_session_time) ); # -- Users INSERT INTO mx_table_users (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', 0); # -- username: admin password: admin (change this or remove it once everything is working!) INSERT INTO mx_table_users (user_id, username, user_level, user_regdate, user_password, user_email, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'ad...@yo...', 1); # -- Groups INSERT INTO mx_table_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1); INSERT INTO mx_table_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1); # -- User -> Group INSERT INTO mx_table_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0); INSERT INTO mx_table_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0); # -------------------------------------------------------- # # Table structure for table 'mx_table_themes' # DROP TABLE IF EXISTS mx_table_themes; CREATE TABLE mx_table_themes ( themes_id mediumint(8) UNSIGNED NOT NULL auto_increment, template_name varchar(30) NOT NULL default '', style_name varchar(30) NOT NULL default '', head_stylesheet varchar(100) default NULL, portal_backend varchar(30) NOT NULL default '', PRIMARY KEY (themes_id) ); # -- Themes INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (1, 'mxBase1', 'mxBase1', 'mxBase1.css', 'internal'); INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (2, 'mxBase2', 'mxBase2', 'mxBase2.css', 'internal'); INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (3, 'mxSilver', 'mxSilver', 'mxSilver.css', 'internal'); INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (4, 'subSilver', 'subSilver', 'subSilver.css', 'phpbb2'); INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (5, 'subsilver2', 'subsilver2', 'subsilver2.css', 'phpbb3'); INSERT INTO mx_table_themes (themes_id, template_name, style_name, head_stylesheet, portal_backend) VALUES (6, 'prosilver', 'prosilver', 'prosilver.css', 'phpbb3'); # -------------------------------------------------------- # # Table structure for table 'mx_table_smilies' # DROP TABLE IF EXISTS mx_table_smilies; CREATE TABLE mx_table_smilies ( smilies_id smallint(5) UNSIGNED NOT NULL auto_increment, code varchar(50), smile_url varchar(100), emoticon varchar(75), PRIMARY KEY (smilies_id) ); # -- Smilies INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, ':shock:', 'icon_eek.gif', 'Shocked'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, ':?', 'icon_confused.gif', 'Confused'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':-?', 'icon_confused.gif', 'Confused'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':???:', 'icon_confused.gif', 'Confused'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, '8)', 'icon_cool.gif', 'Cool'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, '8-)', 'icon_cool.gif', 'Cool'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, ':cool:', 'icon_cool.gif', 'Cool'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, ':lol:', 'icon_lol.gif', 'Laughing'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':x', 'icon_mad.gif', 'Mad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':-x', 'icon_mad.gif', 'Mad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':mad:', 'icon_mad.gif', 'Mad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':P', 'icon_razz.gif', 'Razz'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':-P', 'icon_razz.gif', 'Razz'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':razz:', 'icon_razz.gif', 'Razz'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':oops:', 'icon_redface.gif', 'Embarassed'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':cry:', 'icon_cry.gif', 'Crying or Very sad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':wink:', 'icon_wink.gif', 'Wink'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ';)', 'icon_wink.gif', 'Wink'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ';-)', 'icon_wink.gif', 'Wink'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ':!:', 'icon_exclaim.gif', 'Exclamation'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ':?:', 'icon_question.gif', 'Question'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':idea:', 'icon_idea.gif', 'Idea'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':arrow:', 'icon_arrow.gif', 'Arrow'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':|', 'icon_neutral.gif', 'Neutral'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':-|', 'icon_neutral.gif', 'Neutral'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':neutral:', 'icon_neutral.gif', 'Neutral'); INSERT INTO mx_table_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green'); # -------------------------------------------------------- # # Table structure for table 'mx_table_words' # DROP TABLE IF EXISTS mx_table_words; CREATE TABLE mx_table_words ( word_id mediumint(8) UNSIGNED NOT NULL auto_increment, word char(100) NOT NULL, replacement char(100) NOT NULL, PRIMARY KEY (word_id) ); Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.52 retrieving revision 1.53 diff -C2 -d -r1.52 -r1.53 *** mysql_schema_install.sql 10 Feb 2008 20:58:47 -0000 1.52 --- mysql_schema_install.sql 11 Feb 2008 22:47:12 -0000 1.53 *************** *** 3,7 **** # Host: localhost Database: MX-Publisher #-------------------------------------------------------- - # Server version 3.23.51-nt --- 3,6 ---- *************** *** 9,32 **** # Table structure for table 'mx_table_block' # [...1446 lines suppressed...] ! ! DROP TABLE IF EXISTS mx_table_words; ! CREATE TABLE mx_table_words ( word_id mediumint(8) UNSIGNED NOT NULL auto_increment, word char(100) NOT NULL, replacement char(100) NOT NULL, PRIMARY KEY (word_id) ! ); ! --- 752,760 ---- # Table structure for table 'mx_table_words' # ! DROP TABLE IF EXISTS `mx_table_words`; ! CREATE TABLE `mx_table_words` ( word_id mediumint(8) UNSIGNED NOT NULL auto_increment, word char(100) NOT NULL, replacement char(100) NOT NULL, PRIMARY KEY (word_id) ! ); \ No newline at end of file |
