FaTCi8ez

1-- phpMyAdmin SQL Dump
2-- version 4.4.12
3-- http://www.phpmyadmin.net
4--
5-- Хост: localhost
6-- Время создания: Ноя 06 2016 г., 23:42
7-- Версия сервера: 5.6.25-log
8-- Версия PHP: 5.6.11
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- База данных: `ex`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Структура таблицы `phpbb_acl_groups`
21--
22
23CREATE TABLE IF NOT EXISTS `phpbb_acl_groups` (
24  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
25  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
26  `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
27  `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
28  `auth_setting` tinyint(2) NOT NULL DEFAULT '0'
29) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
30
31-- --------------------------------------------------------
32
33--
34-- Структура таблицы `phpbb_acl_options`
35--
36
37CREATE TABLE IF NOT EXISTS `phpbb_acl_options` (
38  `auth_option_id` mediumint(8) unsigned NOT NULL,
39  `auth_option` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
40  `is_global` tinyint(1) unsigned NOT NULL DEFAULT '0',
41  `is_local` tinyint(1) unsigned NOT NULL DEFAULT '0',
42  `founder_only` tinyint(1) unsigned NOT NULL DEFAULT '0'
43) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
44
45-- --------------------------------------------------------
46
47--
48-- Структура таблицы `phpbb_acl_roles`
49--
50
51CREATE TABLE IF NOT EXISTS `phpbb_acl_roles` (
52  `role_id` mediumint(8) unsigned NOT NULL,
53  `role_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
54  `role_description` text COLLATE utf8_bin NOT NULL,
55  `role_type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
56  `role_order` smallint(4) unsigned NOT NULL DEFAULT '0'
57) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
58
59-- --------------------------------------------------------
60
61--
62-- Структура таблицы `phpbb_acl_roles_data`
63--
64
65CREATE TABLE IF NOT EXISTS `phpbb_acl_roles_data` (
66  `role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
67  `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
68  `auth_setting` tinyint(2) NOT NULL DEFAULT '0'
69) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
70
71-- --------------------------------------------------------
72
73--
74-- Структура таблицы `phpbb_acl_users`
75--
76
77CREATE TABLE IF NOT EXISTS `phpbb_acl_users` (
78  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
79  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
80  `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
81  `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
82  `auth_setting` tinyint(2) NOT NULL DEFAULT '0'
83) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
84
85-- --------------------------------------------------------
86
87--
88-- Структура таблицы `phpbb_attachments`
89--
90
91CREATE TABLE IF NOT EXISTS `phpbb_attachments` (
92  `attach_id` mediumint(8) unsigned NOT NULL,
93  `post_msg_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
94  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
95  `in_message` tinyint(1) unsigned NOT NULL DEFAULT '0',
96  `poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
97  `is_orphan` tinyint(1) unsigned NOT NULL DEFAULT '1',
98  `physical_filename` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
99  `real_filename` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
100  `download_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
101  `attach_comment` text COLLATE utf8_bin NOT NULL,
102  `extension` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
103  `mimetype` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
104  `filesize` int(20) unsigned NOT NULL DEFAULT '0',
105  `filetime` int(11) unsigned NOT NULL DEFAULT '0',
106  `thumbnail` tinyint(1) unsigned NOT NULL DEFAULT '0'
107) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
108
109-- --------------------------------------------------------
110
111--
112-- Структура таблицы `phpbb_banlist`
113--
114
115CREATE TABLE IF NOT EXISTS `phpbb_banlist` (
116  `ban_id` mediumint(8) unsigned NOT NULL,
117  `ban_userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
118  `ban_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
119  `ban_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
120  `ban_start` int(11) unsigned NOT NULL DEFAULT '0',
121  `ban_end` int(11) unsigned NOT NULL DEFAULT '0',
122  `ban_exclude` tinyint(1) unsigned NOT NULL DEFAULT '0',
123  `ban_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
124  `ban_give_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
125) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
126
127-- --------------------------------------------------------
128
129--
130-- Структура таблицы `phpbb_bbcodes`
131--
132
133CREATE TABLE IF NOT EXISTS `phpbb_bbcodes` (
134  `bbcode_id` smallint(4) unsigned NOT NULL DEFAULT '0',
135  `bbcode_tag` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
136  `bbcode_helpline` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
137  `display_on_posting` tinyint(1) unsigned NOT NULL DEFAULT '0',
138  `bbcode_match` text COLLATE utf8_bin NOT NULL,
139  `bbcode_tpl` mediumtext COLLATE utf8_bin NOT NULL,
140  `first_pass_match` mediumtext COLLATE utf8_bin NOT NULL,
141  `first_pass_replace` mediumtext COLLATE utf8_bin NOT NULL,
142  `second_pass_match` mediumtext COLLATE utf8_bin NOT NULL,
143  `second_pass_replace` mediumtext COLLATE utf8_bin NOT NULL
144) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
145
146-- --------------------------------------------------------
147
148--
149-- Структура таблицы `phpbb_bookmarks`
150--
151
152CREATE TABLE IF NOT EXISTS `phpbb_bookmarks` (
153  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
154  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0'
155) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
156
157-- --------------------------------------------------------
158
159--
160-- Структура таблицы `phpbb_bots`
161--
162
163CREATE TABLE IF NOT EXISTS `phpbb_bots` (
164  `bot_id` mediumint(8) unsigned NOT NULL,
165  `bot_active` tinyint(1) unsigned NOT NULL DEFAULT '1',
166  `bot_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
167  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
168  `bot_agent` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
169  `bot_ip` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
170) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
171
172-- --------------------------------------------------------
173
174--
175-- Структура таблицы `phpbb_config`
176--
177
178CREATE TABLE IF NOT EXISTS `phpbb_config` (
179  `config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
180  `config_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
181  `is_dynamic` tinyint(1) unsigned NOT NULL DEFAULT '0'
182) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
183
184-- --------------------------------------------------------
185
186--
187-- Структура таблицы `phpbb_config_text`
188--
189
190CREATE TABLE IF NOT EXISTS `phpbb_config_text` (
191  `config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
192  `config_value` mediumtext COLLATE utf8_bin NOT NULL
193) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
194
195-- --------------------------------------------------------
196
197--
198-- Структура таблицы `phpbb_confirm`
199--
200
201CREATE TABLE IF NOT EXISTS `phpbb_confirm` (
202  `confirm_id` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
203  `session_id` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
204  `confirm_type` tinyint(3) NOT NULL DEFAULT '0',
205  `code` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
206  `seed` int(10) unsigned NOT NULL DEFAULT '0',
207  `attempts` mediumint(8) unsigned NOT NULL DEFAULT '0'
208) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
209
210-- --------------------------------------------------------
211
212--
213-- Структура таблицы `phpbb_disallow`
214--
215
216CREATE TABLE IF NOT EXISTS `phpbb_disallow` (
217  `disallow_id` mediumint(8) unsigned NOT NULL,
218  `disallow_username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
219) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
220
221-- --------------------------------------------------------
222
223--
224-- Структура таблицы `phpbb_drafts`
225--
226
227CREATE TABLE IF NOT EXISTS `phpbb_drafts` (
228  `draft_id` mediumint(8) unsigned NOT NULL,
229  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
230  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
231  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
232  `save_time` int(11) unsigned NOT NULL DEFAULT '0',
233  `draft_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
234  `draft_message` mediumtext COLLATE utf8_bin NOT NULL
235) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
236
237-- --------------------------------------------------------
238
239--
240-- Структура таблицы `phpbb_ext`
241--
242
243CREATE TABLE IF NOT EXISTS `phpbb_ext` (
244  `ext_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
245  `ext_active` tinyint(1) unsigned NOT NULL DEFAULT '0',
246  `ext_state` text COLLATE utf8_bin NOT NULL
247) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
248
249-- --------------------------------------------------------
250
251--
252-- Структура таблицы `phpbb_extensions`
253--
254
255CREATE TABLE IF NOT EXISTS `phpbb_extensions` (
256  `extension_id` mediumint(8) unsigned NOT NULL,
257  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
258  `extension` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT ''
259) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
260
261-- --------------------------------------------------------
262
263--
264-- Структура таблицы `phpbb_extension_groups`
265--
266
267CREATE TABLE IF NOT EXISTS `phpbb_extension_groups` (
268  `group_id` mediumint(8) unsigned NOT NULL,
269  `group_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
270  `cat_id` tinyint(2) NOT NULL DEFAULT '0',
271  `allow_group` tinyint(1) unsigned NOT NULL DEFAULT '0',
272  `download_mode` tinyint(1) unsigned NOT NULL DEFAULT '1',
273  `upload_icon` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
274  `max_filesize` int(20) unsigned NOT NULL DEFAULT '0',
275  `allowed_forums` text COLLATE utf8_bin NOT NULL,
276  `allow_in_pm` tinyint(1) unsigned NOT NULL DEFAULT '0'
277) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
278
279-- --------------------------------------------------------
280
281--
282-- Структура таблицы `phpbb_forums`
283--
284
285CREATE TABLE IF NOT EXISTS `phpbb_forums` (
286  `forum_id` mediumint(8) unsigned NOT NULL,
287  `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
288  `left_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
289  `right_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
290  `forum_parents` mediumtext COLLATE utf8_bin NOT NULL,
291  `forum_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
292  `forum_desc` text COLLATE utf8_bin NOT NULL,
293  `forum_desc_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
294  `forum_desc_options` int(11) unsigned NOT NULL DEFAULT '7',
295  `forum_desc_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
296  `forum_link` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
297  `forum_password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
298  `forum_style` mediumint(8) unsigned NOT NULL DEFAULT '0',
299  `forum_image` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
300  `forum_rules` text COLLATE utf8_bin NOT NULL,
301  `forum_rules_link` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
302  `forum_rules_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
303  `forum_rules_options` int(11) unsigned NOT NULL DEFAULT '7',
304  `forum_rules_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
305  `forum_topics_per_page` tinyint(4) NOT NULL DEFAULT '0',
306  `forum_type` tinyint(4) NOT NULL DEFAULT '0',
307  `forum_status` tinyint(4) NOT NULL DEFAULT '0',
308  `forum_last_post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
309  `forum_last_poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
310  `forum_last_post_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
311  `forum_last_post_time` int(11) unsigned NOT NULL DEFAULT '0',
312  `forum_last_poster_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
313  `forum_last_poster_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
314  `forum_flags` tinyint(4) NOT NULL DEFAULT '32',
315  `display_on_index` tinyint(1) unsigned NOT NULL DEFAULT '1',
316  `enable_indexing` tinyint(1) unsigned NOT NULL DEFAULT '1',
317  `enable_icons` tinyint(1) unsigned NOT NULL DEFAULT '1',
318  `enable_prune` tinyint(1) unsigned NOT NULL DEFAULT '0',
319  `prune_next` int(11) unsigned NOT NULL DEFAULT '0',
320  `prune_days` mediumint(8) unsigned NOT NULL DEFAULT '0',
321  `prune_viewed` mediumint(8) unsigned NOT NULL DEFAULT '0',
322  `prune_freq` mediumint(8) unsigned NOT NULL DEFAULT '0',
323  `display_subforum_list` tinyint(1) unsigned NOT NULL DEFAULT '1',
324  `forum_options` int(20) unsigned NOT NULL DEFAULT '0',
325  `enable_shadow_prune` tinyint(1) unsigned NOT NULL DEFAULT '0',
326  `prune_shadow_days` mediumint(8) unsigned NOT NULL DEFAULT '7',
327  `prune_shadow_freq` mediumint(8) unsigned NOT NULL DEFAULT '1',
328  `prune_shadow_next` int(11) NOT NULL DEFAULT '0',
329  `forum_posts_approved` mediumint(8) unsigned NOT NULL DEFAULT '0',
330  `forum_posts_unapproved` mediumint(8) unsigned NOT NULL DEFAULT '0',
331  `forum_posts_softdeleted` mediumint(8) unsigned NOT NULL DEFAULT '0',
332  `forum_topics_approved` mediumint(8) unsigned NOT NULL DEFAULT '0',
333  `forum_topics_unapproved` mediumint(8) unsigned NOT NULL DEFAULT '0',
334  `forum_topics_softdeleted` mediumint(8) unsigned NOT NULL DEFAULT '0'
335) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
336
337-- --------------------------------------------------------
338
339--
340-- Структура таблицы `phpbb_forums_access`
341--
342
343CREATE TABLE IF NOT EXISTS `phpbb_forums_access` (
344  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
345  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
346  `session_id` char(32) COLLATE utf8_bin NOT NULL DEFAULT ''
347) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
348
349-- --------------------------------------------------------
350
351--
352-- Структура таблицы `phpbb_forums_track`
353--
354
355CREATE TABLE IF NOT EXISTS `phpbb_forums_track` (
356  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
357  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
358  `mark_time` int(11) unsigned NOT NULL DEFAULT '0'
359) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
360
361-- --------------------------------------------------------
362
363--
364-- Структура таблицы `phpbb_forums_watch`
365--
366
367CREATE TABLE IF NOT EXISTS `phpbb_forums_watch` (
368  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
369  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
370  `notify_status` tinyint(1) unsigned NOT NULL DEFAULT '0'
371) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
372
373-- --------------------------------------------------------
374
375--
376-- Структура таблицы `phpbb_groups`
377--
378
379CREATE TABLE IF NOT EXISTS `phpbb_groups` (
380  `group_id` mediumint(8) unsigned NOT NULL,
381  `group_type` tinyint(4) NOT NULL DEFAULT '1',
382  `group_founder_manage` tinyint(1) unsigned NOT NULL DEFAULT '0',
383  `group_skip_auth` tinyint(1) unsigned NOT NULL DEFAULT '0',
384  `group_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
385  `group_desc` text COLLATE utf8_bin NOT NULL,
386  `group_desc_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
387  `group_desc_options` int(11) unsigned NOT NULL DEFAULT '7',
388  `group_desc_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
389  `group_display` tinyint(1) unsigned NOT NULL DEFAULT '0',
390  `group_avatar` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
391  `group_avatar_type` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
392  `group_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
393  `group_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
394  `group_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
395  `group_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
396  `group_sig_chars` mediumint(8) unsigned NOT NULL DEFAULT '0',
397  `group_receive_pm` tinyint(1) unsigned NOT NULL DEFAULT '0',
398  `group_message_limit` mediumint(8) unsigned NOT NULL DEFAULT '0',
399  `group_legend` mediumint(8) unsigned NOT NULL DEFAULT '0',
400  `group_max_recipients` mediumint(8) unsigned NOT NULL DEFAULT '0'
401) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
402
403-- --------------------------------------------------------
404
405--
406-- Структура таблицы `phpbb_icons`
407--
408
409CREATE TABLE IF NOT EXISTS `phpbb_icons` (
410  `icons_id` mediumint(8) unsigned NOT NULL,
411  `icons_url` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
412  `icons_width` tinyint(4) NOT NULL DEFAULT '0',
413  `icons_height` tinyint(4) NOT NULL DEFAULT '0',
414  `icons_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
415  `display_on_posting` tinyint(1) unsigned NOT NULL DEFAULT '1'
416) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
417
418-- --------------------------------------------------------
419
420--
421-- Структура таблицы `phpbb_lang`
422--
423
424CREATE TABLE IF NOT EXISTS `phpbb_lang` (
425  `lang_id` tinyint(4) NOT NULL,
426  `lang_iso` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
427  `lang_dir` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
428  `lang_english_name` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
429  `lang_local_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
430  `lang_author` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
431) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
432
433-- --------------------------------------------------------
434
435--
436-- Структура таблицы `phpbb_log`
437--
438
439CREATE TABLE IF NOT EXISTS `phpbb_log` (
440  `log_id` mediumint(8) unsigned NOT NULL,
441  `log_type` tinyint(4) NOT NULL DEFAULT '0',
442  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
443  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
444  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
445  `reportee_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
446  `log_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
447  `log_time` int(11) unsigned NOT NULL DEFAULT '0',
448  `log_operation` text COLLATE utf8_bin NOT NULL,
449  `log_data` mediumtext COLLATE utf8_bin NOT NULL
450) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
451
452-- --------------------------------------------------------
453
454--
455-- Структура таблицы `phpbb_login_attempts`
456--
457
458CREATE TABLE IF NOT EXISTS `phpbb_login_attempts` (
459  `attempt_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
460  `attempt_browser` varchar(150) COLLATE utf8_bin NOT NULL DEFAULT '',
461  `attempt_forwarded_for` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
462  `attempt_time` int(11) unsigned NOT NULL DEFAULT '0',
463  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
464  `username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
465  `username_clean` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0'
466) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
467
468-- --------------------------------------------------------
469
470--
471-- Структура таблицы `phpbb_migrations`
472--
473
474CREATE TABLE IF NOT EXISTS `phpbb_migrations` (
475  `migration_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
476  `migration_depends_on` text COLLATE utf8_bin NOT NULL,
477  `migration_schema_done` tinyint(1) unsigned NOT NULL DEFAULT '0',
478  `migration_data_done` tinyint(1) unsigned NOT NULL DEFAULT '0',
479  `migration_data_state` text COLLATE utf8_bin NOT NULL,
480  `migration_start_time` int(11) unsigned NOT NULL DEFAULT '0',
481  `migration_end_time` int(11) unsigned NOT NULL DEFAULT '0'
482) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
483
484-- --------------------------------------------------------
485
486--
487-- Структура таблицы `phpbb_moderator_cache`
488--
489
490CREATE TABLE IF NOT EXISTS `phpbb_moderator_cache` (
491  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
492  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
493  `username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
494  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
495  `group_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
496  `display_on_index` tinyint(1) unsigned NOT NULL DEFAULT '1'
497) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
498
499-- --------------------------------------------------------
500
501--
502-- Структура таблицы `phpbb_modules`
503--
504
505CREATE TABLE IF NOT EXISTS `phpbb_modules` (
506  `module_id` mediumint(8) unsigned NOT NULL,
507  `module_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
508  `module_display` tinyint(1) unsigned NOT NULL DEFAULT '1',
509  `module_basename` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
510  `module_class` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
511  `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
512  `left_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
513  `right_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
514  `module_langname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
515  `module_mode` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
516  `module_auth` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
517) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
518
519-- --------------------------------------------------------
520
521--
522-- Структура таблицы `phpbb_notifications`
523--
524
525CREATE TABLE IF NOT EXISTS `phpbb_notifications` (
526  `notification_id` int(10) unsigned NOT NULL,
527  `notification_type_id` smallint(4) unsigned NOT NULL DEFAULT '0',
528  `item_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
529  `item_parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
530  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
531  `notification_read` tinyint(1) unsigned NOT NULL DEFAULT '0',
532  `notification_time` int(11) unsigned NOT NULL DEFAULT '1',
533  `notification_data` text COLLATE utf8_bin NOT NULL
534) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
535
536-- --------------------------------------------------------
537
538--
539-- Структура таблицы `phpbb_notification_types`
540--
541
542CREATE TABLE IF NOT EXISTS `phpbb_notification_types` (
543  `notification_type_id` smallint(4) unsigned NOT NULL,
544  `notification_type_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
545  `notification_type_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1'
546) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
547
548-- --------------------------------------------------------
549
550--
551-- Структура таблицы `phpbb_oauth_accounts`
552--
553
554CREATE TABLE IF NOT EXISTS `phpbb_oauth_accounts` (
555  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
556  `provider` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
557  `oauth_provider_id` text COLLATE utf8_bin NOT NULL
558) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
559
560-- --------------------------------------------------------
561
562--
563-- Структура таблицы `phpbb_oauth_tokens`
564--
565
566CREATE TABLE IF NOT EXISTS `phpbb_oauth_tokens` (
567  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
568  `session_id` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
569  `provider` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
570  `oauth_token` mediumtext COLLATE utf8_bin NOT NULL
571) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
572
573-- --------------------------------------------------------
574
575--
576-- Структура таблицы `phpbb_poll_options`
577--
578
579CREATE TABLE IF NOT EXISTS `phpbb_poll_options` (
580  `poll_option_id` tinyint(4) NOT NULL DEFAULT '0',
581  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
582  `poll_option_text` text COLLATE utf8_bin NOT NULL,
583  `poll_option_total` mediumint(8) unsigned NOT NULL DEFAULT '0'
584) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
585
586-- --------------------------------------------------------
587
588--
589-- Структура таблицы `phpbb_poll_votes`
590--
591
592CREATE TABLE IF NOT EXISTS `phpbb_poll_votes` (
593  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
594  `poll_option_id` tinyint(4) NOT NULL DEFAULT '0',
595  `vote_user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
596  `vote_user_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT ''
597) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
598
599-- --------------------------------------------------------
600
601--
602-- Структура таблицы `phpbb_posts`
603--
604
605CREATE TABLE IF NOT EXISTS `phpbb_posts` (
606  `post_id` mediumint(8) unsigned NOT NULL,
607  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
608  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
609  `poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
610  `icon_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
611  `poster_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
612  `post_time` int(11) unsigned NOT NULL DEFAULT '0',
613  `post_reported` tinyint(1) unsigned NOT NULL DEFAULT '0',
614  `enable_bbcode` tinyint(1) unsigned NOT NULL DEFAULT '1',
615  `enable_smilies` tinyint(1) unsigned NOT NULL DEFAULT '1',
616  `enable_magic_url` tinyint(1) unsigned NOT NULL DEFAULT '1',
617  `enable_sig` tinyint(1) unsigned NOT NULL DEFAULT '1',
618  `post_username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
619  `post_subject` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
620  `post_text` mediumtext COLLATE utf8_bin NOT NULL,
621  `post_checksum` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
622  `post_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
623  `bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
624  `bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
625  `post_postcount` tinyint(1) unsigned NOT NULL DEFAULT '1',
626  `post_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
627  `post_edit_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
628  `post_edit_user` mediumint(8) unsigned NOT NULL DEFAULT '0',
629  `post_edit_count` smallint(4) unsigned NOT NULL DEFAULT '0',
630  `post_edit_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
631  `post_visibility` tinyint(3) NOT NULL DEFAULT '0',
632  `post_delete_time` int(11) unsigned NOT NULL DEFAULT '0',
633  `post_delete_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
634  `post_delete_user` mediumint(8) unsigned NOT NULL DEFAULT '0'
635) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
636
637-- --------------------------------------------------------
638
639--
640-- Структура таблицы `phpbb_privmsgs`
641--
642
643CREATE TABLE IF NOT EXISTS `phpbb_privmsgs` (
644  `msg_id` mediumint(8) unsigned NOT NULL,
645  `root_level` mediumint(8) unsigned NOT NULL DEFAULT '0',
646  `author_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
647  `icon_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
648  `author_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
649  `message_time` int(11) unsigned NOT NULL DEFAULT '0',
650  `enable_bbcode` tinyint(1) unsigned NOT NULL DEFAULT '1',
651  `enable_smilies` tinyint(1) unsigned NOT NULL DEFAULT '1',
652  `enable_magic_url` tinyint(1) unsigned NOT NULL DEFAULT '1',
653  `enable_sig` tinyint(1) unsigned NOT NULL DEFAULT '1',
654  `message_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
655  `message_text` mediumtext COLLATE utf8_bin NOT NULL,
656  `message_edit_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
657  `message_edit_user` mediumint(8) unsigned NOT NULL DEFAULT '0',
658  `message_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
659  `bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
660  `bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
661  `message_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
662  `message_edit_count` smallint(4) unsigned NOT NULL DEFAULT '0',
663  `to_address` text COLLATE utf8_bin NOT NULL,
664  `bcc_address` text COLLATE utf8_bin NOT NULL,
665  `message_reported` tinyint(1) unsigned NOT NULL DEFAULT '0'
666) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
667
668-- --------------------------------------------------------
669
670--
671-- Структура таблицы `phpbb_privmsgs_folder`
672--
673
674CREATE TABLE IF NOT EXISTS `phpbb_privmsgs_folder` (
675  `folder_id` mediumint(8) unsigned NOT NULL,
676  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
677  `folder_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
678  `pm_count` mediumint(8) unsigned NOT NULL DEFAULT '0'
679) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
680
681-- --------------------------------------------------------
682
683--
684-- Структура таблицы `phpbb_privmsgs_rules`
685--
686
687CREATE TABLE IF NOT EXISTS `phpbb_privmsgs_rules` (
688  `rule_id` mediumint(8) unsigned NOT NULL,
689  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
690  `rule_check` mediumint(8) unsigned NOT NULL DEFAULT '0',
691  `rule_connection` mediumint(8) unsigned NOT NULL DEFAULT '0',
692  `rule_string` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
693  `rule_user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
694  `rule_group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
695  `rule_action` mediumint(8) unsigned NOT NULL DEFAULT '0',
696  `rule_folder_id` int(11) NOT NULL DEFAULT '0'
697) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
698
699-- --------------------------------------------------------
700
701--
702-- Структура таблицы `phpbb_privmsgs_to`
703--
704
705CREATE TABLE IF NOT EXISTS `phpbb_privmsgs_to` (
706  `msg_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
707  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
708  `author_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
709  `pm_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
710  `pm_new` tinyint(1) unsigned NOT NULL DEFAULT '1',
711  `pm_unread` tinyint(1) unsigned NOT NULL DEFAULT '1',
712  `pm_replied` tinyint(1) unsigned NOT NULL DEFAULT '0',
713  `pm_marked` tinyint(1) unsigned NOT NULL DEFAULT '0',
714  `pm_forwarded` tinyint(1) unsigned NOT NULL DEFAULT '0',
715  `folder_id` int(11) NOT NULL DEFAULT '0'
716) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
717
718-- --------------------------------------------------------
719
720--
721-- Структура таблицы `phpbb_profile_fields`
722--
723
724CREATE TABLE IF NOT EXISTS `phpbb_profile_fields` (
725  `field_id` mediumint(8) unsigned NOT NULL,
726  `field_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
727  `field_type` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
728  `field_ident` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
729  `field_length` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
730  `field_minlen` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
731  `field_maxlen` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
732  `field_novalue` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
733  `field_default_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
734  `field_validation` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
735  `field_required` tinyint(1) unsigned NOT NULL DEFAULT '0',
736  `field_show_on_reg` tinyint(1) unsigned NOT NULL DEFAULT '0',
737  `field_hide` tinyint(1) unsigned NOT NULL DEFAULT '0',
738  `field_no_view` tinyint(1) unsigned NOT NULL DEFAULT '0',
739  `field_active` tinyint(1) unsigned NOT NULL DEFAULT '0',
740  `field_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
741  `field_show_profile` tinyint(1) unsigned NOT NULL DEFAULT '0',
742  `field_show_on_vt` tinyint(1) unsigned NOT NULL DEFAULT '0',
743  `field_show_novalue` tinyint(1) unsigned NOT NULL DEFAULT '0',
744  `field_show_on_pm` tinyint(1) unsigned NOT NULL DEFAULT '0',
745  `field_show_on_ml` tinyint(1) unsigned NOT NULL DEFAULT '0',
746  `field_is_contact` tinyint(1) unsigned NOT NULL DEFAULT '0',
747  `field_contact_desc` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
748  `field_contact_url` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
749) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
750
751-- --------------------------------------------------------
752
753--
754-- Структура таблицы `phpbb_profile_fields_data`
755--
756
757CREATE TABLE IF NOT EXISTS `phpbb_profile_fields_data` (
758  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
759  `pf_phpbb_interests` mediumtext COLLATE utf8_bin NOT NULL,
760  `pf_phpbb_occupation` mediumtext COLLATE utf8_bin NOT NULL,
761  `pf_phpbb_facebook` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
762  `pf_phpbb_googleplus` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
763  `pf_phpbb_icq` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
764  `pf_phpbb_location` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
765  `pf_phpbb_skype` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
766  `pf_phpbb_twitter` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
767  `pf_phpbb_website` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
768  `pf_phpbb_wlm` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
769  `pf_phpbb_yahoo` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
770  `pf_phpbb_youtube` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
771  `pf_phpbb_aol` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
772) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
773
774-- --------------------------------------------------------
775
776--
777-- Структура таблицы `phpbb_profile_fields_lang`
778--
779
780CREATE TABLE IF NOT EXISTS `phpbb_profile_fields_lang` (
781  `field_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
782  `lang_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
783  `option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
784  `field_type` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
785  `lang_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
786) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
787
788-- --------------------------------------------------------
789
790--
791-- Структура таблицы `phpbb_profile_lang`
792--
793
794CREATE TABLE IF NOT EXISTS `phpbb_profile_lang` (
795  `field_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
796  `lang_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
797  `lang_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
798  `lang_explain` text COLLATE utf8_bin NOT NULL,
799  `lang_default_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
800) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
801
802-- --------------------------------------------------------
803
804--
805-- Структура таблицы `phpbb_ranks`
806--
807
808CREATE TABLE IF NOT EXISTS `phpbb_ranks` (
809  `rank_id` mediumint(8) unsigned NOT NULL,
810  `rank_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
811  `rank_min` mediumint(8) unsigned NOT NULL DEFAULT '0',
812  `rank_special` tinyint(1) unsigned NOT NULL DEFAULT '0',
813  `rank_image` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
814) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
815
816-- --------------------------------------------------------
817
818--
819-- Структура таблицы `phpbb_reports`
820--
821
822CREATE TABLE IF NOT EXISTS `phpbb_reports` (
823  `report_id` mediumint(8) unsigned NOT NULL,
824  `reason_id` smallint(4) unsigned NOT NULL DEFAULT '0',
825  `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
826  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
827  `user_notify` tinyint(1) unsigned NOT NULL DEFAULT '0',
828  `report_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
829  `report_time` int(11) unsigned NOT NULL DEFAULT '0',
830  `report_text` mediumtext COLLATE utf8_bin NOT NULL,
831  `pm_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
832  `reported_post_enable_bbcode` tinyint(1) unsigned NOT NULL DEFAULT '1',
833  `reported_post_enable_smilies` tinyint(1) unsigned NOT NULL DEFAULT '1',
834  `reported_post_enable_magic_url` tinyint(1) unsigned NOT NULL DEFAULT '1',
835  `reported_post_text` mediumtext COLLATE utf8_bin NOT NULL,
836  `reported_post_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
837  `reported_post_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
838) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
839
840-- --------------------------------------------------------
841
842--
843-- Структура таблицы `phpbb_reports_reasons`
844--
845
846CREATE TABLE IF NOT EXISTS `phpbb_reports_reasons` (
847  `reason_id` smallint(4) unsigned NOT NULL,
848  `reason_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
849  `reason_description` mediumtext COLLATE utf8_bin NOT NULL,
850  `reason_order` smallint(4) unsigned NOT NULL DEFAULT '0'
851) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
852
853-- --------------------------------------------------------
854
855--
856-- Структура таблицы `phpbb_search_results`
857--
858
859CREATE TABLE IF NOT EXISTS `phpbb_search_results` (
860  `search_key` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
861  `search_time` int(11) unsigned NOT NULL DEFAULT '0',
862  `search_keywords` mediumtext COLLATE utf8_bin NOT NULL,
863  `search_authors` mediumtext COLLATE utf8_bin NOT NULL
864) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
865
866-- --------------------------------------------------------
867
868--
869-- Структура таблицы `phpbb_search_wordlist`
870--
871
872CREATE TABLE IF NOT EXISTS `phpbb_search_wordlist` (
873  `word_id` mediumint(8) unsigned NOT NULL,
874  `word_text` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
875  `word_common` tinyint(1) unsigned NOT NULL DEFAULT '0',
876  `word_count` mediumint(8) unsigned NOT NULL DEFAULT '0'
877) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
878
879-- --------------------------------------------------------
880
881--
882-- Структура таблицы `phpbb_search_wordmatch`
883--
884
885CREATE TABLE IF NOT EXISTS `phpbb_search_wordmatch` (
886  `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
887  `word_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
888  `title_match` tinyint(1) unsigned NOT NULL DEFAULT '0'
889) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
890
891-- --------------------------------------------------------
892
893--
894-- Структура таблицы `phpbb_sessions`
895--
896
897CREATE TABLE IF NOT EXISTS `phpbb_sessions` (
898  `session_id` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
899  `session_user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
900  `session_last_visit` int(11) unsigned NOT NULL DEFAULT '0',
901  `session_start` int(11) unsigned NOT NULL DEFAULT '0',
902  `session_time` int(11) unsigned NOT NULL DEFAULT '0',
903  `session_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
904  `session_browser` varchar(150) COLLATE utf8_bin NOT NULL DEFAULT '',
905  `session_forwarded_for` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
906  `session_page` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
907  `session_viewonline` tinyint(1) unsigned NOT NULL DEFAULT '1',
908  `session_autologin` tinyint(1) unsigned NOT NULL DEFAULT '0',
909  `session_admin` tinyint(1) unsigned NOT NULL DEFAULT '0',
910  `session_forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0'
911) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
912
913-- --------------------------------------------------------
914
915--
916-- Структура таблицы `phpbb_sessions_keys`
917--
918
919CREATE TABLE IF NOT EXISTS `phpbb_sessions_keys` (
920  `key_id` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
921  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
922  `last_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
923  `last_login` int(11) unsigned NOT NULL DEFAULT '0'
924) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
925
926-- --------------------------------------------------------
927
928--
929-- Структура таблицы `phpbb_sitelist`
930--
931
932CREATE TABLE IF NOT EXISTS `phpbb_sitelist` (
933  `site_id` mediumint(8) unsigned NOT NULL,
934  `site_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
935  `site_hostname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
936  `ip_exclude` tinyint(1) unsigned NOT NULL DEFAULT '0'
937) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
938
939-- --------------------------------------------------------
940
941--
942-- Структура таблицы `phpbb_smilies`
943--
944
945CREATE TABLE IF NOT EXISTS `phpbb_smilies` (
946  `smiley_id` mediumint(8) unsigned NOT NULL,
947  `code` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
948  `emotion` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
949  `smiley_url` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
950  `smiley_width` smallint(4) unsigned NOT NULL DEFAULT '0',
951  `smiley_height` smallint(4) unsigned NOT NULL DEFAULT '0',
952  `smiley_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
953  `display_on_posting` tinyint(1) unsigned NOT NULL DEFAULT '1'
954) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
955
956-- --------------------------------------------------------
957
958--
959-- Структура таблицы `phpbb_styles`
960--
961
962CREATE TABLE IF NOT EXISTS `phpbb_styles` (
963  `style_id` mediumint(8) unsigned NOT NULL,
964  `style_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
965  `style_copyright` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
966  `style_active` tinyint(1) unsigned NOT NULL DEFAULT '1',
967  `style_path` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
968  `bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'kNg=',
969  `style_parent_id` int(4) unsigned NOT NULL DEFAULT '0',
970  `style_parent_tree` text COLLATE utf8_bin NOT NULL
971) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
972
973-- --------------------------------------------------------
974
975--
976-- Структура таблицы `phpbb_teampage`
977--
978
979CREATE TABLE IF NOT EXISTS `phpbb_teampage` (
980  `teampage_id` mediumint(8) unsigned NOT NULL,
981  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
982  `teampage_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
983  `teampage_position` mediumint(8) unsigned NOT NULL DEFAULT '0',
984  `teampage_parent` mediumint(8) unsigned NOT NULL DEFAULT '0'
985) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
986
987-- --------------------------------------------------------
988
989--
990-- Структура таблицы `phpbb_topics`
991--
992
993CREATE TABLE IF NOT EXISTS `phpbb_topics` (
994  `topic_id` mediumint(8) unsigned NOT NULL,
995  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
996  `icon_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
997  `topic_attachment` tinyint(1) unsigned NOT NULL DEFAULT '0',
998  `topic_reported` tinyint(1) unsigned NOT NULL DEFAULT '0',
999  `topic_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1000  `topic_poster` mediumint(8) unsigned NOT NULL DEFAULT '0',
1001  `topic_time` int(11) unsigned NOT NULL DEFAULT '0',
1002  `topic_time_limit` int(11) unsigned NOT NULL DEFAULT '0',
1003  `topic_views` mediumint(8) unsigned NOT NULL DEFAULT '0',
1004  `topic_status` tinyint(3) NOT NULL DEFAULT '0',
1005  `topic_type` tinyint(3) NOT NULL DEFAULT '0',
1006  `topic_first_post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1007  `topic_first_poster_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
1008  `topic_first_poster_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
1009  `topic_last_post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1010  `topic_last_poster_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1011  `topic_last_poster_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1012  `topic_last_poster_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
1013  `topic_last_post_subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1014  `topic_last_post_time` int(11) unsigned NOT NULL DEFAULT '0',
1015  `topic_last_view_time` int(11) unsigned NOT NULL DEFAULT '0',
1016  `topic_moved_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1017  `topic_bumped` tinyint(1) unsigned NOT NULL DEFAULT '0',
1018  `topic_bumper` mediumint(8) unsigned NOT NULL DEFAULT '0',
1019  `poll_title` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1020  `poll_start` int(11) unsigned NOT NULL DEFAULT '0',
1021  `poll_length` int(11) unsigned NOT NULL DEFAULT '0',
1022  `poll_max_options` tinyint(4) NOT NULL DEFAULT '1',
1023  `poll_last_vote` int(11) unsigned NOT NULL DEFAULT '0',
1024  `poll_vote_change` tinyint(1) unsigned NOT NULL DEFAULT '0',
1025  `topic_visibility` tinyint(3) NOT NULL DEFAULT '0',
1026  `topic_delete_time` int(11) unsigned NOT NULL DEFAULT '0',
1027  `topic_delete_reason` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1028  `topic_delete_user` mediumint(8) unsigned NOT NULL DEFAULT '0',
1029  `topic_posts_approved` mediumint(8) unsigned NOT NULL DEFAULT '0',
1030  `topic_posts_unapproved` mediumint(8) unsigned NOT NULL DEFAULT '0',
1031  `topic_posts_softdeleted` mediumint(8) unsigned NOT NULL DEFAULT '0'
1032) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1033
1034-- --------------------------------------------------------
1035
1036--
1037-- Структура таблицы `phpbb_topics_posted`
1038--
1039
1040CREATE TABLE IF NOT EXISTS `phpbb_topics_posted` (
1041  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1042  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1043  `topic_posted` tinyint(1) unsigned NOT NULL DEFAULT '0'
1044) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1045
1046-- --------------------------------------------------------
1047
1048--
1049-- Структура таблицы `phpbb_topics_track`
1050--
1051
1052CREATE TABLE IF NOT EXISTS `phpbb_topics_track` (
1053  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1054  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1055  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1056  `mark_time` int(11) unsigned NOT NULL DEFAULT '0'
1057) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1058
1059-- --------------------------------------------------------
1060
1061--
1062-- Структура таблицы `phpbb_topics_watch`
1063--
1064
1065CREATE TABLE IF NOT EXISTS `phpbb_topics_watch` (
1066  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1067  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1068  `notify_status` tinyint(1) unsigned NOT NULL DEFAULT '0'
1069) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1070
1071-- --------------------------------------------------------
1072
1073--
1074-- Структура таблицы `phpbb_users`
1075--
1076
1077CREATE TABLE IF NOT EXISTS `phpbb_users` (
1078  `user_id` mediumint(8) unsigned NOT NULL,
1079  `user_type` tinyint(2) NOT NULL DEFAULT '0',
1080  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '3',
1081  `user_permissions` mediumtext COLLATE utf8_bin NOT NULL,
1082  `user_perm_from` mediumint(8) unsigned NOT NULL DEFAULT '0',
1083  `user_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
1084  `user_regdate` int(11) unsigned NOT NULL DEFAULT '0',
1085  `username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1086  `username_clean` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1087  `user_password` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1088  `user_passchg` int(11) unsigned NOT NULL DEFAULT '0',
1089  `user_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
1090  `user_email_hash` bigint(20) NOT NULL DEFAULT '0',
1091  `user_birthday` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
1092  `user_lastvisit` int(11) unsigned NOT NULL DEFAULT '0',
1093  `user_lastmark` int(11) unsigned NOT NULL DEFAULT '0',
1094  `user_lastpost_time` int(11) unsigned NOT NULL DEFAULT '0',
1095  `user_lastpage` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
1096  `user_last_confirm_key` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
1097  `user_last_search` int(11) unsigned NOT NULL DEFAULT '0',
1098  `user_warnings` tinyint(4) NOT NULL DEFAULT '0',
1099  `user_last_warning` int(11) unsigned NOT NULL DEFAULT '0',
1100  `user_login_attempts` tinyint(4) NOT NULL DEFAULT '0',
1101  `user_inactive_reason` tinyint(2) NOT NULL DEFAULT '0',
1102  `user_inactive_time` int(11) unsigned NOT NULL DEFAULT '0',
1103  `user_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
1104  `user_lang` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
1105  `user_timezone` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
1106  `user_dateformat` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
1107  `user_style` mediumint(8) unsigned NOT NULL DEFAULT '0',
1108  `user_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
1109  `user_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
1110  `user_new_privmsg` int(4) NOT NULL DEFAULT '0',
1111  `user_unread_privmsg` int(4) NOT NULL DEFAULT '0',
1112  `user_last_privmsg` int(11) unsigned NOT NULL DEFAULT '0',
1113  `user_message_rules` tinyint(1) unsigned NOT NULL DEFAULT '0',
1114  `user_full_folder` int(11) NOT NULL DEFAULT '-3',
1115  `user_emailtime` int(11) unsigned NOT NULL DEFAULT '0',
1116  `user_topic_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
1117  `user_topic_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
1118  `user_topic_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'd',
1119  `user_post_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
1120  `user_post_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
1121  `user_post_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'a',
1122  `user_notify` tinyint(1) unsigned NOT NULL DEFAULT '0',
1123  `user_notify_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
1124  `user_notify_type` tinyint(4) NOT NULL DEFAULT '0',
1125  `user_allow_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
1126  `user_allow_viewonline` tinyint(1) unsigned NOT NULL DEFAULT '1',
1127  `user_allow_viewemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
1128  `user_allow_massemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
1129  `user_options` int(11) unsigned NOT NULL DEFAULT '230271',
1130  `user_avatar` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1131  `user_avatar_type` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1132  `user_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
1133  `user_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
1134  `user_sig` mediumtext COLLATE utf8_bin NOT NULL,
1135  `user_sig_bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
1136  `user_sig_bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1137  `user_jabber` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1138  `user_actkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
1139  `user_newpasswd` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1140  `user_form_salt` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
1141  `user_new` tinyint(1) unsigned NOT NULL DEFAULT '1',
1142  `user_reminded` tinyint(4) NOT NULL DEFAULT '0',
1143  `user_reminded_time` int(11) unsigned NOT NULL DEFAULT '0'
1144) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1145
1146-- --------------------------------------------------------
1147
1148--
1149-- Структура таблицы `phpbb_user_group`
1150--
1151
1152CREATE TABLE IF NOT EXISTS `phpbb_user_group` (
1153  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1154  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1155  `group_leader` tinyint(1) unsigned NOT NULL DEFAULT '0',
1156  `user_pending` tinyint(1) unsigned NOT NULL DEFAULT '1'
1157) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1158
1159-- --------------------------------------------------------
1160
1161--
1162-- Структура таблицы `phpbb_user_notifications`
1163--
1164
1165CREATE TABLE IF NOT EXISTS `phpbb_user_notifications` (
1166  `item_type` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1167  `item_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1168  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1169  `method` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1170  `notify` tinyint(1) unsigned NOT NULL DEFAULT '1'
1171) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1172
1173-- --------------------------------------------------------
1174
1175--
1176-- Структура таблицы `phpbb_warnings`
1177--
1178
1179CREATE TABLE IF NOT EXISTS `phpbb_warnings` (
1180  `warning_id` mediumint(8) unsigned NOT NULL,
1181  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1182  `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1183  `log_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1184  `warning_time` int(11) unsigned NOT NULL DEFAULT '0'
1185) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1186
1187-- --------------------------------------------------------
1188
1189--
1190-- Структура таблицы `phpbb_words`
1191--
1192
1193CREATE TABLE IF NOT EXISTS `phpbb_words` (
1194  `word_id` mediumint(8) unsigned NOT NULL,
1195  `word` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
1196  `replacement` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''
1197) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1198
1199-- --------------------------------------------------------
1200
1201--
1202-- Структура таблицы `phpbb_zebra`
1203--
1204
1205CREATE TABLE IF NOT EXISTS `phpbb_zebra` (
1206  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1207  `zebra_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
1208  `friend` tinyint(1) unsigned NOT NULL DEFAULT '0',
1209  `foe` tinyint(1) unsigned NOT NULL DEFAULT '0'
1210) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1211
1212--
1213-- Индексы сохранённых таблиц
1214--
1215
1216--
1217-- Индексы таблицы `phpbb_acl_groups`
1218--
1219ALTER TABLE `phpbb_acl_groups`
1220  ADD KEY `group_id` (`group_id`),
1221  ADD KEY `auth_opt_id` (`auth_option_id`),
1222  ADD KEY `auth_role_id` (`auth_role_id`);
1223
1224--
1225-- Индексы таблицы `phpbb_acl_options`
1226--
1227ALTER TABLE `phpbb_acl_options`
1228  ADD PRIMARY KEY (`auth_option_id`),
1229  ADD UNIQUE KEY `auth_option` (`auth_option`);
1230
1231--
1232-- Индексы таблицы `phpbb_acl_roles`
1233--
1234ALTER TABLE `phpbb_acl_roles`
1235  ADD PRIMARY KEY (`role_id`),
1236  ADD KEY `role_type` (`role_type`),
1237  ADD KEY `role_order` (`role_order`);
1238
1239--
1240-- Индексы таблицы `phpbb_acl_roles_data`
1241--
1242ALTER TABLE `phpbb_acl_roles_data`
1243  ADD PRIMARY KEY (`role_id`,`auth_option_id`),
1244  ADD KEY `ath_op_id` (`auth_option_id`);
1245
1246--
1247-- Индексы таблицы `phpbb_acl_users`
1248--
1249ALTER TABLE `phpbb_acl_users`
1250  ADD KEY `user_id` (`user_id`),
1251  ADD KEY `auth_option_id` (`auth_option_id`),
1252  ADD KEY `auth_role_id` (`auth_role_id`);
1253
1254--
1255-- Индексы таблицы `phpbb_attachments`
1256--
1257ALTER TABLE `phpbb_attachments`
1258  ADD PRIMARY KEY (`attach_id`),
1259  ADD KEY `filetime` (`filetime`),
1260  ADD KEY `post_msg_id` (`post_msg_id`),
1261  ADD KEY `topic_id` (`topic_id`),
1262  ADD KEY `poster_id` (`poster_id`),
1263  ADD KEY `is_orphan` (`is_orphan`);
1264
1265--
1266-- Индексы таблицы `phpbb_banlist`
1267--
1268ALTER TABLE `phpbb_banlist`
1269  ADD PRIMARY KEY (`ban_id`),
1270  ADD KEY `ban_end` (`ban_end`),
1271  ADD KEY `ban_user` (`ban_userid`,`ban_exclude`),
1272  ADD KEY `ban_email` (`ban_email`,`ban_exclude`),
1273  ADD KEY `ban_ip` (`ban_ip`,`ban_exclude`);
1274
1275--
1276-- Индексы таблицы `phpbb_bbcodes`
1277--
1278ALTER TABLE `phpbb_bbcodes`
1279  ADD PRIMARY KEY (`bbcode_id`),
1280  ADD KEY `display_on_post` (`display_on_posting`);
1281
1282--
1283-- Индексы таблицы `phpbb_bookmarks`
1284--
1285ALTER TABLE `phpbb_bookmarks`
1286  ADD PRIMARY KEY (`topic_id`,`user_id`);
1287
1288--
1289-- Индексы таблицы `phpbb_bots`
1290--
1291ALTER TABLE `phpbb_bots`
1292  ADD PRIMARY KEY (`bot_id`),
1293  ADD KEY `bot_active` (`bot_active`);
1294
1295--
1296-- Индексы таблицы `phpbb_config`
1297--
1298ALTER TABLE `phpbb_config`
1299  ADD PRIMARY KEY (`config_name`),
1300  ADD KEY `is_dynamic` (`is_dynamic`);
1301
1302--
1303-- Индексы таблицы `phpbb_config_text`
1304--
1305ALTER TABLE `phpbb_config_text`
1306  ADD PRIMARY KEY (`config_name`);
1307
1308--
1309-- Индексы таблицы `phpbb_confirm`
1310--
1311ALTER TABLE `phpbb_confirm`
1312  ADD PRIMARY KEY (`session_id`,`confirm_id`),
1313  ADD KEY `confirm_type` (`confirm_type`);
1314
1315--
1316-- Индексы таблицы `phpbb_disallow`
1317--
1318ALTER TABLE `phpbb_disallow`
1319  ADD PRIMARY KEY (`disallow_id`);
1320
1321--
1322-- Индексы таблицы `phpbb_drafts`
1323--
1324ALTER TABLE `phpbb_drafts`
1325  ADD PRIMARY KEY (`draft_id`),
1326  ADD KEY `save_time` (`save_time`);
1327
1328--
1329-- Индексы таблицы `phpbb_ext`
1330--
1331ALTER TABLE `phpbb_ext`
1332  ADD UNIQUE KEY `ext_name` (`ext_name`);
1333
1334--
1335-- Индексы таблицы `phpbb_extensions`
1336--
1337ALTER TABLE `phpbb_extensions`
1338  ADD PRIMARY KEY (`extension_id`);
1339
1340--
1341-- Индексы таблицы `phpbb_extension_groups`
1342--
1343ALTER TABLE `phpbb_extension_groups`
1344  ADD PRIMARY KEY (`group_id`);
1345
1346--
1347-- Индексы таблицы `phpbb_forums`
1348--
1349ALTER TABLE `phpbb_forums`
1350  ADD PRIMARY KEY (`forum_id`),
1351  ADD KEY `left_right_id` (`left_id`,`right_id`),
1352  ADD KEY `forum_lastpost_id` (`forum_last_post_id`);
1353
1354--
1355-- Индексы таблицы `phpbb_forums_access`
1356--
1357ALTER TABLE `phpbb_forums_access`
1358  ADD PRIMARY KEY (`forum_id`,`user_id`,`session_id`);
1359
1360--
1361-- Индексы таблицы `phpbb_forums_track`
1362--
1363ALTER TABLE `phpbb_forums_track`
1364  ADD PRIMARY KEY (`user_id`,`forum_id`);
1365
1366--
1367-- Индексы таблицы `phpbb_forums_watch`
1368--
1369ALTER TABLE `phpbb_forums_watch`
1370  ADD KEY `forum_id` (`forum_id`),
1371  ADD KEY `user_id` (`user_id`),
1372  ADD KEY `notify_stat` (`notify_status`);
1373
1374--
1375-- Индексы таблицы `phpbb_groups`
1376--
1377ALTER TABLE `phpbb_groups`
1378  ADD PRIMARY KEY (`group_id`),
1379  ADD KEY `group_legend_name` (`group_legend`,`group_name`);
1380
1381--
1382-- Индексы таблицы `phpbb_icons`
1383--
1384ALTER TABLE `phpbb_icons`
1385  ADD PRIMARY KEY (`icons_id`),
1386  ADD KEY `display_on_posting` (`display_on_posting`);
1387
1388--
1389-- Индексы таблицы `phpbb_lang`
1390--
1391ALTER TABLE `phpbb_lang`
1392  ADD PRIMARY KEY (`lang_id`),
1393  ADD KEY `lang_iso` (`lang_iso`);
1394
1395--
1396-- Индексы таблицы `phpbb_log`
1397--
1398ALTER TABLE `phpbb_log`
1399  ADD PRIMARY KEY (`log_id`),
1400  ADD KEY `log_type` (`log_type`),
1401  ADD KEY `forum_id` (`forum_id`),
1402  ADD KEY `topic_id` (`topic_id`),
1403  ADD KEY `reportee_id` (`reportee_id`),
1404  ADD KEY `user_id` (`user_id`),
1405  ADD KEY `log_time` (`log_time`);
1406
1407--
1408-- Индексы таблицы `phpbb_login_attempts`
1409--
1410ALTER TABLE `phpbb_login_attempts`
1411  ADD KEY `att_ip` (`attempt_ip`,`attempt_time`),
1412  ADD KEY `att_for` (`attempt_forwarded_for`,`attempt_time`),
1413  ADD KEY `att_time` (`attempt_time`),
1414  ADD KEY `user_id` (`user_id`);
1415
1416--
1417-- Индексы таблицы `phpbb_migrations`
1418--
1419ALTER TABLE `phpbb_migrations`
1420  ADD PRIMARY KEY (`migration_name`);
1421
1422--
1423-- Индексы таблицы `phpbb_moderator_cache`
1424--
1425ALTER TABLE `phpbb_moderator_cache`
1426  ADD KEY `disp_idx` (`display_on_index`),
1427  ADD KEY `forum_id` (`forum_id`);
1428
1429--
1430-- Индексы таблицы `phpbb_modules`
1431--
1432ALTER TABLE `phpbb_modules`
1433  ADD PRIMARY KEY (`module_id`),
1434  ADD KEY `left_right_id` (`left_id`,`right_id`),
1435  ADD KEY `module_enabled` (`module_enabled`),
1436  ADD KEY `class_left_id` (`module_class`,`left_id`);
1437
1438--
1439-- Индексы таблицы `phpbb_notifications`
1440--
1441ALTER TABLE `phpbb_notifications`
1442  ADD PRIMARY KEY (`notification_id`),
1443  ADD KEY `item_ident` (`notification_type_id`,`item_id`),
1444  ADD KEY `user` (`user_id`,`notification_read`);
1445
1446--
1447-- Индексы таблицы `phpbb_notification_types`
1448--
1449ALTER TABLE `phpbb_notification_types`
1450  ADD PRIMARY KEY (`notification_type_id`),
1451  ADD UNIQUE KEY `type` (`notification_type_name`);
1452
1453--
1454-- Индексы таблицы `phpbb_oauth_accounts`
1455--
1456ALTER TABLE `phpbb_oauth_accounts`
1457  ADD PRIMARY KEY (`user_id`,`provider`);
1458
1459--
1460-- Индексы таблицы `phpbb_oauth_tokens`
1461--
1462ALTER TABLE `phpbb_oauth_tokens`
1463  ADD KEY `user_id` (`user_id`),
1464  ADD KEY `provider` (`provider`);
1465
1466--
1467-- Индексы таблицы `phpbb_poll_options`
1468--
1469ALTER TABLE `phpbb_poll_options`
1470  ADD KEY `poll_opt_id` (`poll_option_id`),
1471  ADD KEY `topic_id` (`topic_id`);
1472
1473--
1474-- Индексы таблицы `phpbb_poll_votes`
1475--
1476ALTER TABLE `phpbb_poll_votes`
1477  ADD KEY `topic_id` (`topic_id`),
1478  ADD KEY `vote_user_id` (`vote_user_id`),
1479  ADD KEY `vote_user_ip` (`vote_user_ip`);
1480
1481--
1482-- Индексы таблицы `phpbb_posts`
1483--
1484ALTER TABLE `phpbb_posts`
1485  ADD PRIMARY KEY (`post_id`),
1486  ADD KEY `forum_id` (`forum_id`),
1487  ADD KEY `topic_id` (`topic_id`),
1488  ADD KEY `poster_ip` (`poster_ip`),
1489  ADD KEY `poster_id` (`poster_id`),
1490  ADD KEY `tid_post_time` (`topic_id`,`post_time`),
1491  ADD KEY `post_username` (`post_username`),
1492  ADD KEY `post_visibility` (`post_visibility`);
1493
1494--
1495-- Индексы таблицы `phpbb_privmsgs`
1496--
1497ALTER TABLE `phpbb_privmsgs`
1498  ADD PRIMARY KEY (`msg_id`),
1499  ADD KEY `author_ip` (`author_ip`),
1500  ADD KEY `message_time` (`message_time`),
1501  ADD KEY `author_id` (`author_id`),
1502  ADD KEY `root_level` (`root_level`);
1503
1504--
1505-- Индексы таблицы `phpbb_privmsgs_folder`
1506--
1507ALTER TABLE `phpbb_privmsgs_folder`
1508  ADD PRIMARY KEY (`folder_id`),
1509  ADD KEY `user_id` (`user_id`);
1510
1511--
1512-- Индексы таблицы `phpbb_privmsgs_rules`
1513--
1514ALTER TABLE `phpbb_privmsgs_rules`
1515  ADD PRIMARY KEY (`rule_id`),
1516  ADD KEY `user_id` (`user_id`);
1517
1518--
1519-- Индексы таблицы `phpbb_privmsgs_to`
1520--
1521ALTER TABLE `phpbb_privmsgs_to`
1522  ADD KEY `msg_id` (`msg_id`),
1523  ADD KEY `author_id` (`author_id`),
1524  ADD KEY `usr_flder_id` (`user_id`,`folder_id`);
1525
1526--
1527-- Индексы таблицы `phpbb_profile_fields`
1528--
1529ALTER TABLE `phpbb_profile_fields`
1530  ADD PRIMARY KEY (`field_id`),
1531  ADD KEY `fld_type` (`field_type`),
1532  ADD KEY `fld_ordr` (`field_order`);
1533
1534--
1535-- Индексы таблицы `phpbb_profile_fields_data`
1536--
1537ALTER TABLE `phpbb_profile_fields_data`
1538  ADD PRIMARY KEY (`user_id`);
1539
1540--
1541-- Индексы таблицы `phpbb_profile_fields_lang`
1542--
1543ALTER TABLE `phpbb_profile_fields_lang`
1544  ADD PRIMARY KEY (`field_id`,`lang_id`,`option_id`);
1545
1546--
1547-- Индексы таблицы `phpbb_profile_lang`
1548--
1549ALTER TABLE `phpbb_profile_lang`
1550  ADD PRIMARY KEY (`field_id`,`lang_id`);
1551
1552--
1553-- Индексы таблицы `phpbb_ranks`
1554--
1555ALTER TABLE `phpbb_ranks`
1556  ADD PRIMARY KEY (`rank_id`);
1557
1558--
1559-- Индексы таблицы `phpbb_reports`
1560--
1561ALTER TABLE `phpbb_reports`
1562  ADD PRIMARY KEY (`report_id`),
1563  ADD KEY `post_id` (`post_id`),
1564  ADD KEY `pm_id` (`pm_id`);
1565
1566--
1567-- Индексы таблицы `phpbb_reports_reasons`
1568--
1569ALTER TABLE `phpbb_reports_reasons`
1570  ADD PRIMARY KEY (`reason_id`);
1571
1572--
1573-- Индексы таблицы `phpbb_search_results`
1574--
1575ALTER TABLE `phpbb_search_results`
1576  ADD PRIMARY KEY (`search_key`);
1577
1578--
1579-- Индексы таблицы `phpbb_search_wordlist`
1580--
1581ALTER TABLE `phpbb_search_wordlist`
1582  ADD PRIMARY KEY (`word_id`),
1583  ADD UNIQUE KEY `wrd_txt` (`word_text`),
1584  ADD KEY `wrd_cnt` (`word_count`);
1585
1586--
1587-- Индексы таблицы `phpbb_search_wordmatch`
1588--
1589ALTER TABLE `phpbb_search_wordmatch`
1590  ADD UNIQUE KEY `un_mtch` (`word_id`,`post_id`,`title_match`),
1591  ADD KEY `word_id` (`word_id`),
1592  ADD KEY `post_id` (`post_id`);
1593
1594--
1595-- Индексы таблицы `phpbb_sessions`
1596--
1597ALTER TABLE `phpbb_sessions`
1598  ADD PRIMARY KEY (`session_id`),
1599  ADD KEY `session_time` (`session_time`),
1600  ADD KEY `session_user_id` (`session_user_id`),
1601  ADD KEY `session_fid` (`session_forum_id`);
1602
1603--
1604-- Индексы таблицы `phpbb_sessions_keys`
1605--
1606ALTER TABLE `phpbb_sessions_keys`
1607  ADD PRIMARY KEY (`key_id`,`user_id`),
1608  ADD KEY `last_login` (`last_login`);
1609
1610--
1611-- Индексы таблицы `phpbb_sitelist`
1612--
1613ALTER TABLE `phpbb_sitelist`
1614  ADD PRIMARY KEY (`site_id`);
1615
1616--
1617-- Индексы таблицы `phpbb_smilies`
1618--
1619ALTER TABLE `phpbb_smilies`
1620  ADD PRIMARY KEY (`smiley_id`),
1621  ADD KEY `display_on_post` (`display_on_posting`);
1622
1623--
1624-- Индексы таблицы `phpbb_styles`
1625--
1626ALTER TABLE `phpbb_styles`
1627  ADD PRIMARY KEY (`style_id`),
1628  ADD UNIQUE KEY `style_name` (`style_name`);
1629
1630--
1631-- Индексы таблицы `phpbb_teampage`
1632--
1633ALTER TABLE `phpbb_teampage`
1634  ADD PRIMARY KEY (`teampage_id`);
1635
1636--
1637-- Индексы таблицы `phpbb_topics`
1638--
1639ALTER TABLE `phpbb_topics`
1640  ADD PRIMARY KEY (`topic_id`),
1641  ADD KEY `forum_id` (`forum_id`),
1642  ADD KEY `forum_id_type` (`forum_id`,`topic_type`),
1643  ADD KEY `last_post_time` (`topic_last_post_time`),
1644  ADD KEY `fid_time_moved` (`forum_id`,`topic_last_post_time`,`topic_moved_id`),
1645  ADD KEY `topic_visibility` (`topic_visibility`),
1646  ADD KEY `forum_vis_last` (`forum_id`,`topic_visibility`,`topic_last_post_id`);
1647
1648--
1649-- Индексы таблицы `phpbb_topics_posted`
1650--
1651ALTER TABLE `phpbb_topics_posted`
1652  ADD PRIMARY KEY (`user_id`,`topic_id`);
1653
1654--
1655-- Индексы таблицы `phpbb_topics_track`
1656--
1657ALTER TABLE `phpbb_topics_track`
1658  ADD PRIMARY KEY (`user_id`,`topic_id`),
1659  ADD KEY `forum_id` (`forum_id`),
1660  ADD KEY `topic_id` (`topic_id`);
1661
1662--
1663-- Индексы таблицы `phpbb_topics_watch`
1664--
1665ALTER TABLE `phpbb_topics_watch`
1666  ADD KEY `topic_id` (`topic_id`),
1667  ADD KEY `user_id` (`user_id`),
1668  ADD KEY `notify_stat` (`notify_status`);
1669
1670--
1671-- Индексы таблицы `phpbb_users`
1672--
1673ALTER TABLE `phpbb_users`
1674  ADD PRIMARY KEY (`user_id`),
1675  ADD UNIQUE KEY `username_clean` (`username_clean`),
1676  ADD KEY `user_birthday` (`user_birthday`),
1677  ADD KEY `user_email_hash` (`user_email_hash`),
1678  ADD KEY `user_type` (`user_type`);
1679
1680--
1681-- Индексы таблицы `phpbb_user_group`
1682--
1683ALTER TABLE `phpbb_user_group`
1684  ADD KEY `group_id` (`group_id`),
1685  ADD KEY `user_id` (`user_id`),
1686  ADD KEY `group_leader` (`group_leader`);
1687
1688--
1689-- Индексы таблицы `phpbb_warnings`
1690--
1691ALTER TABLE `phpbb_warnings`
1692  ADD PRIMARY KEY (`warning_id`);
1693
1694--
1695-- Индексы таблицы `phpbb_words`
1696--
1697ALTER TABLE `phpbb_words`
1698  ADD PRIMARY KEY (`word_id`);
1699
1700--
1701-- Индексы таблицы `phpbb_zebra`
1702--
1703ALTER TABLE `phpbb_zebra`
1704  ADD PRIMARY KEY (`user_id`,`zebra_id`);
1705
1706--
1707-- AUTO_INCREMENT для сохранённых таблиц
1708--
1709
1710--
1711-- AUTO_INCREMENT для таблицы `phpbb_acl_options`
1712--
1713ALTER TABLE `phpbb_acl_options`
1714  MODIFY `auth_option_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1715--
1716-- AUTO_INCREMENT для таблицы `phpbb_acl_roles`
1717--
1718ALTER TABLE `phpbb_acl_roles`
1719  MODIFY `role_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1720--
1721-- AUTO_INCREMENT для таблицы `phpbb_attachments`
1722--
1723ALTER TABLE `phpbb_attachments`
1724  MODIFY `attach_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1725--
1726-- AUTO_INCREMENT для таблицы `phpbb_banlist`
1727--
1728ALTER TABLE `phpbb_banlist`
1729  MODIFY `ban_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1730--
1731-- AUTO_INCREMENT для таблицы `phpbb_bots`
1732--
1733ALTER TABLE `phpbb_bots`
1734  MODIFY `bot_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1735--
1736-- AUTO_INCREMENT для таблицы `phpbb_disallow`
1737--
1738ALTER TABLE `phpbb_disallow`
1739  MODIFY `disallow_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1740--
1741-- AUTO_INCREMENT для таблицы `phpbb_drafts`
1742--
1743ALTER TABLE `phpbb_drafts`
1744  MODIFY `draft_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1745--
1746-- AUTO_INCREMENT для таблицы `phpbb_extensions`
1747--
1748ALTER TABLE `phpbb_extensions`
1749  MODIFY `extension_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1750--
1751-- AUTO_INCREMENT для таблицы `phpbb_extension_groups`
1752--
1753ALTER TABLE `phpbb_extension_groups`
1754  MODIFY `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1755--
1756-- AUTO_INCREMENT для таблицы `phpbb_forums`
1757--
1758ALTER TABLE `phpbb_forums`
1759  MODIFY `forum_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1760--
1761-- AUTO_INCREMENT для таблицы `phpbb_groups`
1762--
1763ALTER TABLE `phpbb_groups`
1764  MODIFY `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1765--
1766-- AUTO_INCREMENT для таблицы `phpbb_icons`
1767--
1768ALTER TABLE `phpbb_icons`
1769  MODIFY `icons_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1770--
1771-- AUTO_INCREMENT для таблицы `phpbb_lang`
1772--
1773ALTER TABLE `phpbb_lang`
1774  MODIFY `lang_id` tinyint(4) NOT NULL AUTO_INCREMENT;
1775--
1776-- AUTO_INCREMENT для таблицы `phpbb_log`
1777--
1778ALTER TABLE `phpbb_log`
1779  MODIFY `log_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1780--
1781-- AUTO_INCREMENT для таблицы `phpbb_modules`
1782--
1783ALTER TABLE `phpbb_modules`
1784  MODIFY `module_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1785--
1786-- AUTO_INCREMENT для таблицы `phpbb_notifications`
1787--
1788ALTER TABLE `phpbb_notifications`
1789  MODIFY `notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT;
1790--
1791-- AUTO_INCREMENT для таблицы `phpbb_notification_types`
1792--
1793ALTER TABLE `phpbb_notification_types`
1794  MODIFY `notification_type_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT;
1795--
1796-- AUTO_INCREMENT для таблицы `phpbb_posts`
1797--
1798ALTER TABLE `phpbb_posts`
1799  MODIFY `post_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1800--
1801-- AUTO_INCREMENT для таблицы `phpbb_privmsgs`
1802--
1803ALTER TABLE `phpbb_privmsgs`
1804  MODIFY `msg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1805--
1806-- AUTO_INCREMENT для таблицы `phpbb_privmsgs_folder`
1807--
1808ALTER TABLE `phpbb_privmsgs_folder`
1809  MODIFY `folder_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1810--
1811-- AUTO_INCREMENT для таблицы `phpbb_privmsgs_rules`
1812--
1813ALTER TABLE `phpbb_privmsgs_rules`
1814  MODIFY `rule_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1815--
1816-- AUTO_INCREMENT для таблицы `phpbb_profile_fields`
1817--
1818ALTER TABLE `phpbb_profile_fields`
1819  MODIFY `field_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1820--
1821-- AUTO_INCREMENT для таблицы `phpbb_ranks`
1822--
1823ALTER TABLE `phpbb_ranks`
1824  MODIFY `rank_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1825--
1826-- AUTO_INCREMENT для таблицы `phpbb_reports`
1827--
1828ALTER TABLE `phpbb_reports`
1829  MODIFY `report_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1830--
1831-- AUTO_INCREMENT для таблицы `phpbb_reports_reasons`
1832--
1833ALTER TABLE `phpbb_reports_reasons`
1834  MODIFY `reason_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT;
1835--
1836-- AUTO_INCREMENT для таблицы `phpbb_search_wordlist`
1837--
1838ALTER TABLE `phpbb_search_wordlist`
1839  MODIFY `word_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1840--
1841-- AUTO_INCREMENT для таблицы `phpbb_sitelist`
1842--
1843ALTER TABLE `phpbb_sitelist`
1844  MODIFY `site_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1845--
1846-- AUTO_INCREMENT для таблицы `phpbb_smilies`
1847--
1848ALTER TABLE `phpbb_smilies`
1849  MODIFY `smiley_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1850--
1851-- AUTO_INCREMENT для таблицы `phpbb_styles`
1852--
1853ALTER TABLE `phpbb_styles`
1854  MODIFY `style_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1855--
1856-- AUTO_INCREMENT для таблицы `phpbb_teampage`
1857--
1858ALTER TABLE `phpbb_teampage`
1859  MODIFY `teampage_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1860--
1861-- AUTO_INCREMENT для таблицы `phpbb_topics`
1862--
1863ALTER TABLE `phpbb_topics`
1864  MODIFY `topic_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1865--
1866-- AUTO_INCREMENT для таблицы `phpbb_users`
1867--
1868ALTER TABLE `phpbb_users`
1869  MODIFY `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1870--
1871-- AUTO_INCREMENT для таблицы `phpbb_warnings`
1872--
1873ALTER TABLE `phpbb_warnings`
1874  MODIFY `warning_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;
1875--
1876-- AUTO_INCREMENT для таблицы `phpbb_words`
1877--
1878ALTER TABLE `phpbb_words`
1879  MODIFY `word_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT;