Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `punbb146`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `[[dbprefix]]bans`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]bans` (

[20] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`username` varchar(200) DEFAULT NULL,

[22] Fix | Delete

`ip` varchar(255) DEFAULT NULL,

[23] Fix | Delete

`email` varchar(80) DEFAULT NULL,

[24] Fix | Delete

`message` varchar(255) DEFAULT NULL,

[25] Fix | Delete

`expire` int(10) unsigned DEFAULT NULL,

[26] Fix | Delete

`ban_creator` int(10) unsigned NOT NULL DEFAULT '0',

[27] Fix | Delete

PRIMARY KEY (`id`)

[28] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[29] Fix | Delete

[30] Fix | Delete

-- --------------------------------------------------------

[31] Fix | Delete

[32] Fix | Delete

[33] Fix | Delete

-- Table structure for table `[[dbprefix]]categories`

[34] Fix | Delete

[35] Fix | Delete

[36] Fix | Delete

CREATE TABLE `[[dbprefix]]categories` (

[37] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[38] Fix | Delete

`cat_name` varchar(80) NOT NULL DEFAULT 'New Category',

[39] Fix | Delete

`disp_position` int(10) NOT NULL DEFAULT '0',

[40] Fix | Delete

PRIMARY KEY (`id`)

[41] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[42] Fix | Delete

[43] Fix | Delete

[44] Fix | Delete

-- Dumping data for table `[[dbprefix]]categories`

[45] Fix | Delete

[46] Fix | Delete

[47] Fix | Delete

INSERT INTO `[[dbprefix]]categories` VALUES

[48] Fix | Delete

(1, 'Test category', 1);

[49] Fix | Delete

[50] Fix | Delete

-- --------------------------------------------------------

[51] Fix | Delete

[52] Fix | Delete

[53] Fix | Delete

-- Table structure for table `[[dbprefix]]censoring`

[54] Fix | Delete

[55] Fix | Delete

[56] Fix | Delete

CREATE TABLE `[[dbprefix]]censoring` (

[57] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[58] Fix | Delete

`search_for` varchar(60) NOT NULL DEFAULT '',

[59] Fix | Delete

`replace_with` varchar(60) NOT NULL DEFAULT '',

[60] Fix | Delete

PRIMARY KEY (`id`)

[61] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[62] Fix | Delete

[63] Fix | Delete

-- --------------------------------------------------------

[64] Fix | Delete

[65] Fix | Delete

[66] Fix | Delete

-- Table structure for table `[[dbprefix]]config`

[67] Fix | Delete

[68] Fix | Delete

[69] Fix | Delete

CREATE TABLE `[[dbprefix]]config` (

[70] Fix | Delete

`conf_name` varchar(255) NOT NULL DEFAULT '',

[71] Fix | Delete

`conf_value` text,

[72] Fix | Delete

PRIMARY KEY (`conf_name`)

[73] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[74] Fix | Delete

[75] Fix | Delete

[76] Fix | Delete

-- Dumping data for table `[[dbprefix]]config`

[77] Fix | Delete

[78] Fix | Delete

[79] Fix | Delete

INSERT INTO `[[dbprefix]]config` VALUES

[80] Fix | Delete

('o_cur_version', '1.4.6'),

[81] Fix | Delete

('o_database_revision', '5'),

[82] Fix | Delete

('o_board_title', '[[site_name]]'),

[83] Fix | Delete

('o_board_desc', '[[site_desc]]'),

[84] Fix | Delete

('o_default_timezone', '0'),

[85] Fix | Delete

('o_time_format', 'H:i:s'),

[86] Fix | Delete

('o_date_format', 'Y-m-d'),

[87] Fix | Delete

('o_check_for_updates', '1'),

[88] Fix | Delete

('o_check_for_versions', '1'),

[89] Fix | Delete

('o_timeout_visit', '5400'),

[90] Fix | Delete

('o_timeout_online', '300'),

[91] Fix | Delete

('o_redirect_delay', '0'),

[92] Fix | Delete

('o_show_version', '0'),

[93] Fix | Delete

('o_show_user_info', '1'),

[94] Fix | Delete

('o_show_post_count', '1'),

[95] Fix | Delete

('o_signatures', '1'),

[96] Fix | Delete

('o_smilies', '1'),

[97] Fix | Delete

('o_smilies_sig', '1'),

[98] Fix | Delete

('o_make_links', '1'),

[99] Fix | Delete

('o_default_lang', 'English'),

[100] Fix | Delete

('o_default_style', 'Oxygen'),

[101] Fix | Delete

('o_default_user_group', '3'),

[102] Fix | Delete

('o_topic_review', '15'),

[103] Fix | Delete

('o_disp_topics_default', '30'),

[104] Fix | Delete

('o_disp_posts_default', '25'),

[105] Fix | Delete

('o_indent_num_spaces', '4'),

[106] Fix | Delete

('o_quote_depth', '3'),

[107] Fix | Delete

('o_quickpost', '1'),

[108] Fix | Delete

('o_users_online', '1'),

[109] Fix | Delete

('o_censoring', '0'),

[110] Fix | Delete

('o_ranks', '1'),

[111] Fix | Delete

('o_show_dot', '0'),

[112] Fix | Delete

('o_topic_views', '1'),

[113] Fix | Delete

('o_quickjump', '1'),

[114] Fix | Delete

('o_gzip', '0'),

[115] Fix | Delete

('o_additional_navlinks', ''),

[116] Fix | Delete

('o_report_method', '0'),

[117] Fix | Delete

('o_regs_report', '0'),

[118] Fix | Delete

('o_default_email_setting', '1'),

[119] Fix | Delete

('o_mailing_list', '[[admin_email]]'),

[120] Fix | Delete

('o_avatars', '1'),

[121] Fix | Delete

('o_avatars_dir', 'img/avatars'),

[122] Fix | Delete

('o_avatars_width', '60'),

[123] Fix | Delete

('o_avatars_height', '60'),

[124] Fix | Delete

('o_avatars_size', '15360'),

[125] Fix | Delete

('o_search_all_forums', '1'),

[126] Fix | Delete

('o_sef', 'Default'),

[127] Fix | Delete

('o_admin_email', '[[admin_email]]'),

[128] Fix | Delete

('o_webmaster_email', '[[admin_email]]'),

[129] Fix | Delete

('o_subscriptions', '1'),

[130] Fix | Delete

('o_smtp_host', NULL),

[131] Fix | Delete

('o_smtp_user', NULL),

[132] Fix | Delete

('o_smtp_pass', NULL),

[133] Fix | Delete

('o_smtp_ssl', '0'),

[134] Fix | Delete

('o_regs_allow', '1'),

[135] Fix | Delete

('o_regs_verify', '0'),

[136] Fix | Delete

('o_announcement', '0'),

[137] Fix | Delete

('o_announcement_heading', 'Sample announcement'),

[138] Fix | Delete

('o_announcement_message', '<p>Enter your announcement here.</p>'),

[139] Fix | Delete

('o_rules', '0'),

[140] Fix | Delete

('o_rules_message', 'Enter your rules here.'),

[141] Fix | Delete

('o_maintenance', '0'),

[142] Fix | Delete

('o_maintenance_message', 'The forums are temporarily down for maintenance. Please try again in a few minutes.<br /><br />Administrator'),

[143] Fix | Delete

('o_default_dst', '0'),

[144] Fix | Delete

('p_message_bbcode', '1'),

[145] Fix | Delete

('p_message_img_tag', '1'),

[146] Fix | Delete

('p_message_all_caps', '1'),

[147] Fix | Delete

('p_subject_all_caps', '1'),

[148] Fix | Delete

('p_sig_all_caps', '1'),

[149] Fix | Delete

('p_sig_bbcode', '1'),

[150] Fix | Delete

('p_sig_img_tag', '0'),

[151] Fix | Delete

('p_sig_length', '400'),

[152] Fix | Delete

('p_sig_lines', '4'),

[153] Fix | Delete

('p_allow_banned_email', '1'),

[154] Fix | Delete

('p_allow_dupe_email', '0'),

[155] Fix | Delete

('p_force_guest_email', '1'),

[156] Fix | Delete

('o_show_moderators', '0'),

[157] Fix | Delete

('o_mask_passwords', '1');

[158] Fix | Delete

[159] Fix | Delete

-- --------------------------------------------------------

[160] Fix | Delete

[161] Fix | Delete

[162] Fix | Delete

-- Table structure for table `[[dbprefix]]extensions`

[163] Fix | Delete

[164] Fix | Delete

[165] Fix | Delete

CREATE TABLE `[[dbprefix]]extensions` (

[166] Fix | Delete

`id` varchar(150) NOT NULL DEFAULT '',

[167] Fix | Delete

`title` varchar(255) NOT NULL DEFAULT '',

[168] Fix | Delete

`version` varchar(25) NOT NULL DEFAULT '',

[169] Fix | Delete

`description` text,

[170] Fix | Delete

`author` varchar(50) NOT NULL DEFAULT '',

[171] Fix | Delete

`uninstall` text,

[172] Fix | Delete

`uninstall_note` text,

[173] Fix | Delete

`disabled` tinyint(1) NOT NULL DEFAULT '0',

[174] Fix | Delete

`dependencies` varchar(255) NOT NULL DEFAULT '',

[175] Fix | Delete

PRIMARY KEY (`id`)

[176] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[177] Fix | Delete

[178] Fix | Delete

-- --------------------------------------------------------

[179] Fix | Delete

[180] Fix | Delete

[181] Fix | Delete

-- Table structure for table `[[dbprefix]]extension_hooks`

[182] Fix | Delete

[183] Fix | Delete

[184] Fix | Delete

CREATE TABLE `[[dbprefix]]extension_hooks` (

[185] Fix | Delete

`id` varchar(150) NOT NULL DEFAULT '',

[186] Fix | Delete

`extension_id` varchar(50) NOT NULL DEFAULT '',

[187] Fix | Delete

`code` text,

[188] Fix | Delete

`installed` int(10) unsigned NOT NULL DEFAULT '0',

[189] Fix | Delete

`priority` tinyint(1) unsigned NOT NULL DEFAULT '5',

[190] Fix | Delete

PRIMARY KEY (`id`,`extension_id`)

[191] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[192] Fix | Delete

[193] Fix | Delete

-- --------------------------------------------------------

[194] Fix | Delete

[195] Fix | Delete

[196] Fix | Delete

-- Table structure for table `[[dbprefix]]forums`

[197] Fix | Delete

[198] Fix | Delete

[199] Fix | Delete

CREATE TABLE `[[dbprefix]]forums` (

[200] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[201] Fix | Delete

`forum_name` varchar(80) NOT NULL DEFAULT 'New forum',

[202] Fix | Delete

`forum_desc` text,

[203] Fix | Delete

`redirect_url` varchar(100) DEFAULT NULL,

[204] Fix | Delete

`moderators` text,

[205] Fix | Delete

`num_topics` mediumint(8) unsigned NOT NULL DEFAULT '0',

[206] Fix | Delete

`num_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',

[207] Fix | Delete

`last_post` int(10) unsigned DEFAULT NULL,

[208] Fix | Delete

`last_post_id` int(10) unsigned DEFAULT NULL,

[209] Fix | Delete

`last_poster` varchar(200) DEFAULT NULL,

[210] Fix | Delete

`sort_by` tinyint(1) NOT NULL DEFAULT '0',

[211] Fix | Delete

`disp_position` int(10) NOT NULL DEFAULT '0',

[212] Fix | Delete

`cat_id` int(10) unsigned NOT NULL DEFAULT '0',

[213] Fix | Delete

PRIMARY KEY (`id`)

[214] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[215] Fix | Delete

[216] Fix | Delete

[217] Fix | Delete

-- Dumping data for table `[[dbprefix]]forums`

[218] Fix | Delete

[219] Fix | Delete

[220] Fix | Delete

INSERT INTO `[[dbprefix]]forums` VALUES

[221] Fix | Delete

(1, 'Test forum', 'This is just a test forum', NULL, NULL, 1, 1, [[timestamp]], 1, '[[admin_username]]', 0, 1, 1);

[222] Fix | Delete

[223] Fix | Delete

-- --------------------------------------------------------

[224] Fix | Delete

[225] Fix | Delete

[226] Fix | Delete

-- Table structure for table `[[dbprefix]]forum_perms`

[227] Fix | Delete

[228] Fix | Delete

[229] Fix | Delete

CREATE TABLE `[[dbprefix]]forum_perms` (

[230] Fix | Delete

`group_id` int(10) NOT NULL DEFAULT '0',

[231] Fix | Delete

`forum_id` int(10) NOT NULL DEFAULT '0',

[232] Fix | Delete

`read_forum` tinyint(1) NOT NULL DEFAULT '1',

[233] Fix | Delete

`post_replies` tinyint(1) NOT NULL DEFAULT '1',

[234] Fix | Delete

`post_topics` tinyint(1) NOT NULL DEFAULT '1',

[235] Fix | Delete

PRIMARY KEY (`group_id`,`forum_id`)

[236] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[237] Fix | Delete

[238] Fix | Delete

-- --------------------------------------------------------

[239] Fix | Delete

[240] Fix | Delete

[241] Fix | Delete

-- Table structure for table `[[dbprefix]]forum_subscriptions`

[242] Fix | Delete

[243] Fix | Delete

[244] Fix | Delete

CREATE TABLE `[[dbprefix]]forum_subscriptions` (

[245] Fix | Delete

`user_id` int(10) unsigned NOT NULL DEFAULT '0',

[246] Fix | Delete

`forum_id` int(10) unsigned NOT NULL DEFAULT '0',

[247] Fix | Delete

PRIMARY KEY (`user_id`,`forum_id`)

[248] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[249] Fix | Delete

[250] Fix | Delete

-- --------------------------------------------------------

[251] Fix | Delete

[252] Fix | Delete

[253] Fix | Delete

-- Table structure for table `[[dbprefix]]groups`

[254] Fix | Delete

[255] Fix | Delete

[256] Fix | Delete

CREATE TABLE `[[dbprefix]]groups` (

[257] Fix | Delete

`g_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[258] Fix | Delete

`g_title` varchar(50) NOT NULL DEFAULT '',

[259] Fix | Delete

`g_user_title` varchar(50) DEFAULT NULL,

[260] Fix | Delete

`g_moderator` tinyint(1) NOT NULL DEFAULT '0',

[261] Fix | Delete

`g_mod_edit_users` tinyint(1) NOT NULL DEFAULT '0',

[262] Fix | Delete

`g_mod_rename_users` tinyint(1) NOT NULL DEFAULT '0',

[263] Fix | Delete

`g_mod_change_passwords` tinyint(1) NOT NULL DEFAULT '0',

[264] Fix | Delete

`g_mod_ban_users` tinyint(1) NOT NULL DEFAULT '0',

[265] Fix | Delete

`g_read_board` tinyint(1) NOT NULL DEFAULT '1',

[266] Fix | Delete

`g_view_users` tinyint(1) NOT NULL DEFAULT '1',

[267] Fix | Delete

`g_post_replies` tinyint(1) NOT NULL DEFAULT '1',

[268] Fix | Delete

`g_post_topics` tinyint(1) NOT NULL DEFAULT '1',

[269] Fix | Delete

`g_edit_posts` tinyint(1) NOT NULL DEFAULT '1',

[270] Fix | Delete

`g_delete_posts` tinyint(1) NOT NULL DEFAULT '1',

[271] Fix | Delete

`g_delete_topics` tinyint(1) NOT NULL DEFAULT '1',

[272] Fix | Delete

`g_set_title` tinyint(1) NOT NULL DEFAULT '1',

[273] Fix | Delete

`g_search` tinyint(1) NOT NULL DEFAULT '1',

[274] Fix | Delete

`g_search_users` tinyint(1) NOT NULL DEFAULT '1',

[275] Fix | Delete

`g_send_email` tinyint(1) NOT NULL DEFAULT '1',

[276] Fix | Delete

`g_post_flood` smallint(6) NOT NULL DEFAULT '30',

[277] Fix | Delete

`g_search_flood` smallint(6) NOT NULL DEFAULT '30',

[278] Fix | Delete

`g_email_flood` smallint(6) NOT NULL DEFAULT '60',

[279] Fix | Delete

PRIMARY KEY (`g_id`)

[280] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

[281] Fix | Delete

[282] Fix | Delete

[283] Fix | Delete

-- Dumping data for table `[[dbprefix]]groups`

[284] Fix | Delete

[285] Fix | Delete

[286] Fix | Delete

INSERT INTO `[[dbprefix]]groups` VALUES

[287] Fix | Delete

(1, 'Administrators', 'Administrator', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0),

[288] Fix | Delete

(2, 'Guest', NULL, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 60, 30, 0),

[289] Fix | Delete

(3, 'Members', NULL, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 60, 30, 60),

[290] Fix | Delete

(4, 'Moderators', 'Moderator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0);

[291] Fix | Delete

[292] Fix | Delete

-- --------------------------------------------------------

[293] Fix | Delete

[294] Fix | Delete

[295] Fix | Delete

-- Table structure for table `[[dbprefix]]online`

[296] Fix | Delete

[297] Fix | Delete

[298] Fix | Delete

CREATE TABLE `[[dbprefix]]online` (

[299] Fix | Delete

`user_id` int(10) unsigned NOT NULL DEFAULT '1',

[300] Fix | Delete

`ident` varchar(200) NOT NULL DEFAULT '',

[301] Fix | Delete

`logged` int(10) unsigned NOT NULL DEFAULT '0',

[302] Fix | Delete

`idle` tinyint(1) NOT NULL DEFAULT '0',

[303] Fix | Delete

`csrf_token` varchar(40) NOT NULL DEFAULT '',

[304] Fix | Delete

`prev_url` varchar(255) DEFAULT NULL,

[305] Fix | Delete

`last_post` int(10) unsigned DEFAULT NULL,

[306] Fix | Delete

`last_search` int(10) unsigned DEFAULT NULL,

[307] Fix | Delete

UNIQUE KEY `[[dbprefix]]online_user_id_ident_idx` (`user_id`,`ident`(25)),

[308] Fix | Delete

KEY `[[dbprefix]]online_ident_idx` (`ident`(25)),

[309] Fix | Delete

KEY `[[dbprefix]]online_logged_idx` (`logged`)

[310] Fix | Delete

) ENGINE=MEMORY DEFAULT CHARSET=utf8;

[311] Fix | Delete

[312] Fix | Delete

-- --------------------------------------------------------

[313] Fix | Delete

[314] Fix | Delete

[315] Fix | Delete

-- Table structure for table `[[dbprefix]]posts`

[316] Fix | Delete

[317] Fix | Delete

[318] Fix | Delete

CREATE TABLE `[[dbprefix]]posts` (

[319] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[320] Fix | Delete

`poster` varchar(200) NOT NULL DEFAULT '',

[321] Fix | Delete

`poster_id` int(10) unsigned NOT NULL DEFAULT '1',

[322] Fix | Delete

`poster_ip` varchar(39) DEFAULT NULL,

[323] Fix | Delete

`poster_email` varchar(80) DEFAULT NULL,

[324] Fix | Delete

`message` text,

[325] Fix | Delete

`hide_smilies` tinyint(1) NOT NULL DEFAULT '0',

[326] Fix | Delete

`posted` int(10) unsigned NOT NULL DEFAULT '0',

[327] Fix | Delete

`edited` int(10) unsigned DEFAULT NULL,

[328] Fix | Delete

`edited_by` varchar(200) DEFAULT NULL,

[329] Fix | Delete

`topic_id` int(10) unsigned NOT NULL DEFAULT '0',

[330] Fix | Delete

PRIMARY KEY (`id`),

[331] Fix | Delete

KEY `[[dbprefix]]posts_topic_id_idx` (`topic_id`),

[332] Fix | Delete

KEY `[[dbprefix]]posts_multi_idx` (`poster_id`,`topic_id`),

[333] Fix | Delete

KEY `[[dbprefix]]posts_posted_idx` (`posted`)

[334] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[335] Fix | Delete

[336] Fix | Delete

[337] Fix | Delete

-- Dumping data for table `[[dbprefix]]posts`

[338] Fix | Delete

[339] Fix | Delete

[340] Fix | Delete

INSERT INTO `[[dbprefix]]posts` VALUES

[341] Fix | Delete

(1, '[[admin_username]]', 2, '[[clientip]]', NULL, 'If you are looking at this (which I guess you are), the install of PunBB appears to have worked! Now log in and head over to the administration control panel to configure your forum.', 0, [[timestamp]], NULL, NULL, 1);

[342] Fix | Delete

[343] Fix | Delete

-- --------------------------------------------------------

[344] Fix | Delete

[345] Fix | Delete

[346] Fix | Delete

-- Table structure for table `[[dbprefix]]ranks`

[347] Fix | Delete

[348] Fix | Delete

[349] Fix | Delete

CREATE TABLE `[[dbprefix]]ranks` (

[350] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[351] Fix | Delete

`rank` varchar(50) NOT NULL DEFAULT '',

[352] Fix | Delete

`min_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',

[353] Fix | Delete

PRIMARY KEY (`id`)

[354] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[355] Fix | Delete

[356] Fix | Delete

[357] Fix | Delete

-- Dumping data for table `[[dbprefix]]ranks`

[358] Fix | Delete

[359] Fix | Delete

[360] Fix | Delete

INSERT INTO `[[dbprefix]]ranks` VALUES

[361] Fix | Delete

(1, 'New member', 0),

[362] Fix | Delete

(2, 'Member', 10);

[363] Fix | Delete

[364] Fix | Delete

-- --------------------------------------------------------

[365] Fix | Delete

[366] Fix | Delete

[367] Fix | Delete

-- Table structure for table `[[dbprefix]]reports`

[368] Fix | Delete

[369] Fix | Delete

[370] Fix | Delete

CREATE TABLE `[[dbprefix]]reports` (

[371] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[372] Fix | Delete

`post_id` int(10) unsigned NOT NULL DEFAULT '0',

[373] Fix | Delete

`topic_id` int(10) unsigned NOT NULL DEFAULT '0',

[374] Fix | Delete

`forum_id` int(10) unsigned NOT NULL DEFAULT '0',

[375] Fix | Delete

`reported_by` int(10) unsigned NOT NULL DEFAULT '0',

[376] Fix | Delete

`created` int(10) unsigned NOT NULL DEFAULT '0',

[377] Fix | Delete

`message` text,

[378] Fix | Delete

`zapped` int(10) unsigned DEFAULT NULL,

[379] Fix | Delete

`zapped_by` int(10) unsigned DEFAULT NULL,

[380] Fix | Delete

PRIMARY KEY (`id`),

[381] Fix | Delete

KEY `[[dbprefix]]reports_zapped_idx` (`zapped`)

[382] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[383] Fix | Delete

[384] Fix | Delete

-- --------------------------------------------------------

[385] Fix | Delete

[386] Fix | Delete

[387] Fix | Delete

-- Table structure for table `[[dbprefix]]search_cache`

[388] Fix | Delete

[389] Fix | Delete

[390] Fix | Delete

CREATE TABLE `[[dbprefix]]search_cache` (

[391] Fix | Delete

`id` int(10) unsigned NOT NULL DEFAULT '0',

[392] Fix | Delete

`ident` varchar(200) NOT NULL DEFAULT '',

[393] Fix | Delete

`search_data` text,

[394] Fix | Delete

PRIMARY KEY (`id`),

[395] Fix | Delete

KEY `[[dbprefix]]search_cache_ident_idx` (`ident`(8))

[396] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[397] Fix | Delete

[398] Fix | Delete

-- --------------------------------------------------------

[399] Fix | Delete

[400] Fix | Delete

[401] Fix | Delete

-- Table structure for table `[[dbprefix]]search_matches`

[402] Fix | Delete

[403] Fix | Delete

[404] Fix | Delete

CREATE TABLE `[[dbprefix]]search_matches` (

[405] Fix | Delete

`post_id` int(10) unsigned NOT NULL DEFAULT '0',

[406] Fix | Delete

`word_id` int(10) unsigned NOT NULL DEFAULT '0',

[407] Fix | Delete

`subject_match` tinyint(1) NOT NULL DEFAULT '0',

[408] Fix | Delete

KEY `[[dbprefix]]search_matches_word_id_idx` (`word_id`),

[409] Fix | Delete

KEY `[[dbprefix]]search_matches_post_id_idx` (`post_id`)

[410] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[411] Fix | Delete

[412] Fix | Delete

[413] Fix | Delete

-- Dumping data for table `[[dbprefix]]search_matches`

[414] Fix | Delete

[415] Fix | Delete

[416] Fix | Delete

INSERT INTO `[[dbprefix]]search_matches` VALUES

[417] Fix | Delete

(1, 1, 0),

[418] Fix | Delete

(1, 2, 0),

[419] Fix | Delete

(1, 3, 0),

[420] Fix | Delete

(1, 4, 0),

[421] Fix | Delete

(1, 5, 0),

[422] Fix | Delete

(1, 6, 0),

[423] Fix | Delete

(1, 7, 0),

[424] Fix | Delete

(1, 8, 0),

[425] Fix | Delete

(1, 9, 0),

[426] Fix | Delete

(1, 10, 0),

[427] Fix | Delete

(1, 11, 0),

[428] Fix | Delete

(1, 12, 0),

[429] Fix | Delete

(1, 13, 0),

[430] Fix | Delete

(1, 14, 0),

[431] Fix | Delete

(1, 15, 0),

[432] Fix | Delete

(1, 16, 0),

[433] Fix | Delete

(1, 17, 0),

[434] Fix | Delete

(1, 18, 0),

[435] Fix | Delete

(1, 19, 0),

[436] Fix | Delete

(1, 20, 0),

[437] Fix | Delete

(1, 21, 0),

[438] Fix | Delete

(1, 22, 0),

[439] Fix | Delete

(1, 23, 0),

[440] Fix | Delete

(1, 25, 1),

[441] Fix | Delete

(1, 24, 1);

[442] Fix | Delete

[443] Fix | Delete

-- --------------------------------------------------------

[444] Fix | Delete

[445] Fix | Delete

[446] Fix | Delete

-- Table structure for table `[[dbprefix]]search_words`

[447] Fix | Delete

[448] Fix | Delete

[449] Fix | Delete

CREATE TABLE `[[dbprefix]]search_words` (

[450] Fix | Delete

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

[451] Fix | Delete

`word` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',

[452] Fix | Delete

PRIMARY KEY (`word`),

[453] Fix | Delete

KEY `[[dbprefix]]search_words_id_idx` (`id`)

[454] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

[455] Fix | Delete

[456] Fix | Delete

[457] Fix | Delete

-- Dumping data for table `[[dbprefix]]search_words`

[458] Fix | Delete

[459] Fix | Delete

[460] Fix | Delete

INSERT INTO `[[dbprefix]]search_words` VALUES

[461] Fix | Delete

(1, 'you'),

[462] Fix | Delete

(2, 'are'),

[463] Fix | Delete

(3, 'looking'),

[464] Fix | Delete

(4, 'this'),

[465] Fix | Delete

(5, 'which'),

[466] Fix | Delete

(6, 'guess'),

[467] Fix | Delete

(7, 'the'),

[468] Fix | Delete

(8, 'install'),

[469] Fix | Delete

(9, 'punbb'),

[470] Fix | Delete

(10, 'appears'),

[471] Fix | Delete

(11, 'have'),

[472] Fix | Delete

(12, 'worked'),

[473] Fix | Delete

(13, 'now'),

[474] Fix | Delete

(14, 'log'),

[475] Fix | Delete

(15, 'and'),

[476] Fix | Delete

(16, 'head'),

[477] Fix | Delete

(17, 'over'),

[478] Fix | Delete

(18, 'administration'),

[479] Fix | Delete

(19, 'control'),

[480] Fix | Delete

(20, 'panel'),

[481] Fix | Delete

(21, 'configure'),

[482] Fix | Delete

(22, 'your'),

[483] Fix | Delete

(23, 'forum'),

[484] Fix | Delete

(24, 'test'),

[485] Fix | Delete

(25, 'post');

[486] Fix | Delete

[487] Fix | Delete

-- --------------------------------------------------------

[488] Fix | Delete

[489] Fix | Delete

[490] Fix | Delete

-- Table structure for table `[[dbprefix]]subscriptions`

[491] Fix | Delete

[492] Fix | Delete

[493] Fix | Delete

CREATE TABLE `[[dbprefix]]subscriptions` (

[494] Fix | Delete

`user_id` int(10) unsigned NOT NULL DEFAULT '0',

[495] Fix | Delete

`topic_id` int(10) unsigned NOT NULL DEFAULT '0',

[496] Fix | Delete

PRIMARY KEY (`user_id`,`topic_id`)

[497] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[498] Fix | Delete

[499] Fix | Delete