Verzeichnisstruktur phpBB-2.0.0
- Veröffentlicht
- 03.04.2002
So funktioniert es
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
mysql_schema.sql
001 #
002 # phpBB2 - MySQL schema
003 #
004 # $Id$
005 #
006
007 #
008 # Table structure for table 'phpbb_auth_access'
009 #
010 CREATE TABLE phpbb_auth_access (
011 group_id mediumint(8) DEFAULT '0' NOT NULL,
012 forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
013 auth_view tinyint(1) DEFAULT '0' NOT NULL,
014 auth_read tinyint(1) DEFAULT '0' NOT NULL,
015 auth_post tinyint(1) DEFAULT '0' NOT NULL,
016 auth_reply tinyint(1) DEFAULT '0' NOT NULL,
017 auth_edit tinyint(1) DEFAULT '0' NOT NULL,
018 auth_delete tinyint(1) DEFAULT '0' NOT NULL,
019 auth_sticky tinyint(1) DEFAULT '0' NOT NULL,
020 auth_announce tinyint(1) DEFAULT '0' NOT NULL,
021 auth_vote tinyint(1) DEFAULT '0' NOT NULL,
022 auth_pollcreate tinyint(1) DEFAULT '0' NOT NULL,
023 auth_attachments tinyint(1) DEFAULT '0' NOT NULL,
024 auth_mod tinyint(1) DEFAULT '0' NOT NULL,
025 KEY group_id (group_id),
026 KEY forum_id (forum_id)
027 );
028
029
030 #
031 # Table structure for table 'phpbb_user_group'
032 #
033 CREATE TABLE phpbb_user_group (
034 group_id mediumint(8) DEFAULT '0' NOT NULL,
035 user_id mediumint(8) DEFAULT '0' NOT NULL,
036 user_pending tinyint(1),
037 KEY group_id (group_id),
038 KEY user_id (user_id)
039 );
040
041 #
042 # Table structure for table 'phpbb_groups'
043 #
044 CREATE TABLE phpbb_groups (
045 group_id mediumint(8) NOT NULL auto_increment,
046 group_type tinyint(4) DEFAULT '1' NOT NULL,
047 group_name varchar(40) NOT NULL,
048 group_description varchar(255) NOT NULL,
049 group_moderator mediumint(8) DEFAULT '0' NOT NULL,
050 group_single_user tinyint(1) DEFAULT '1' NOT NULL,
051 PRIMARY KEY (group_id),
052 KEY group_single_user (group_single_user)
053 );
054
055
056 # --------------------------------------------------------
057 #
058 # Table structure for table 'phpbb_banlist'
059 #
060 CREATE TABLE phpbb_banlist (
061 ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
062 ban_userid mediumint(8) NOT NULL,
063 ban_ip char(8) NOT NULL,
064 ban_email varchar(255),
065 PRIMARY KEY (ban_id),
066 KEY ban_ip_user_id (ban_ip, ban_userid)
067 );
068
069
070 # --------------------------------------------------------
071 #
072 # Table structure for table 'phpbb_categories'
073 #
074 CREATE TABLE phpbb_categories (
075 cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
076 cat_title varchar(100),
077 cat_order mediumint(8) UNSIGNED NOT NULL,
078 PRIMARY KEY (cat_id),
079 KEY cat_order (cat_order)
080 );
081
082
083 # --------------------------------------------------------
084 #
085 # Table structure for table 'phpbb_config'
086 #
087 CREATE TABLE phpbb_config (
088 config_name varchar(255) NOT NULL,
089 config_value varchar(255) NOT NULL,
090 PRIMARY KEY (config_name)
091 );
092
093
094 # --------------------------------------------------------
095 #
096 # Table structure for table 'phpbb_confirm'
097 #
098 CREATE TABLE phpbb_confirm (
099 confirm_id char(32) DEFAULT '' NOT NULL,
100 session_id char(32) DEFAULT '' NOT NULL,
101 code char(6) DEFAULT '' NOT NULL,
102 PRIMARY KEY (session_id,confirm_id)
103 );
104
105
106 # --------------------------------------------------------
107 #
108 # Table structure for table 'phpbb_disallow'
109 #
110 CREATE TABLE phpbb_disallow (
111 disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
112 disallow_username varchar(25) DEFAULT '' NOT NULL,
113 PRIMARY KEY (disallow_id)
114 );
115
116
117 # --------------------------------------------------------
118 #
119 # Table structure for table 'phpbb_forum_prune'
120 #
121 CREATE TABLE phpbb_forum_prune (
122 prune_id mediumint(8) UNSIGNED NOT NULL auto_increment,
123 forum_id smallint(5) UNSIGNED NOT NULL,
124 prune_days smallint(5) UNSIGNED NOT NULL,
125 prune_freq smallint(5) UNSIGNED NOT NULL,
126 PRIMARY KEY(prune_id),
127 KEY forum_id (forum_id)
128 );
129
130
131 # --------------------------------------------------------
132 #
133 # Table structure for table 'phpbb_forums'
134 #
135 CREATE TABLE phpbb_forums (
136 forum_id smallint(5) UNSIGNED NOT NULL,
137 cat_id mediumint(8) UNSIGNED NOT NULL,
138 forum_name varchar(150),
139 forum_desc text,
140 forum_status tinyint(4) DEFAULT '0' NOT NULL,
141 forum_order mediumint(8) UNSIGNED DEFAULT '1' NOT NULL,
142 forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
143 forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
144 forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
145 prune_next int(11),
146 prune_enable tinyint(1) DEFAULT '0' NOT NULL,
147 auth_view tinyint(2) DEFAULT '0' NOT NULL,
148 auth_read tinyint(2) DEFAULT '0' NOT NULL,
149 auth_post tinyint(2) DEFAULT '0' NOT NULL,
150 auth_reply tinyint(2) DEFAULT '0' NOT NULL,
151 auth_edit tinyint(2) DEFAULT '0' NOT NULL,
152 auth_delete tinyint(2) DEFAULT '0' NOT NULL,
153 auth_sticky tinyint(2) DEFAULT '0' NOT NULL,
154 auth_announce tinyint(2) DEFAULT '0' NOT NULL,
155 auth_vote tinyint(2) DEFAULT '0' NOT NULL,
156 auth_pollcreate tinyint(2) DEFAULT '0' NOT NULL,
157 auth_attachments tinyint(2) DEFAULT '0' NOT NULL,
158 PRIMARY KEY (forum_id),
159 KEY forums_order (forum_order),
160 KEY cat_id (cat_id),
161 KEY forum_last_post_id (forum_last_post_id)
162 );
163
164
165 # --------------------------------------------------------
166 #
167 # Table structure for table 'phpbb_posts'
168 #
169 CREATE TABLE phpbb_posts (
170 post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
171 topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
172 forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
173 poster_id mediumint(8) DEFAULT '0' NOT NULL,
174 post_time int(11) DEFAULT '0' NOT NULL,
175 poster_ip char(8) NOT NULL,
176 post_username varchar(25),
177 enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
178 enable_html tinyint(1) DEFAULT '0' NOT NULL,
179 enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
180 enable_sig tinyint(1) DEFAULT '1' NOT NULL,
181 post_edit_time int(11),
182 post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
183 PRIMARY KEY (post_id),
184 KEY forum_id (forum_id),
185 KEY topic_id (topic_id),
186 KEY poster_id (poster_id),
187 KEY post_time (post_time)
188 );
189
190
191 # --------------------------------------------------------
192 #
193 # Table structure for table 'phpbb_posts_text'
194 #
195 CREATE TABLE phpbb_posts_text (
196 post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
197 bbcode_uid char(10) DEFAULT '' NOT NULL,
198 post_subject char(60),
199 post_text text,
200 PRIMARY KEY (post_id)
201 );
202
203
204 # --------------------------------------------------------
205 #
206 # Table structure for table 'phpbb_privmsgs'
207 #
208 CREATE TABLE phpbb_privmsgs (
209 privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment,
210 privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
211 privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
212 privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
213 privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
214 privmsgs_date int(11) DEFAULT '0' NOT NULL,
215 privmsgs_ip char(8) NOT NULL,
216 privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
217 privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
218 privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
219 privmsgs_attach_sig tinyint(1) DEFAULT '1' NOT NULL,
220 PRIMARY KEY (privmsgs_id),
221 KEY privmsgs_from_userid (privmsgs_from_userid),
222 KEY privmsgs_to_userid (privmsgs_to_userid)
223 );
224
225
226 # --------------------------------------------------------
227 #
228 # Table structure for table 'phpbb_privmsgs_text'
229 #
230 CREATE TABLE phpbb_privmsgs_text (
231 privmsgs_text_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
232 privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL,
233 privmsgs_text text,
234 PRIMARY KEY (privmsgs_text_id)
235 );
236
237
238 # --------------------------------------------------------
239 #
240 # Table structure for table 'phpbb_ranks'
241 #
242 CREATE TABLE phpbb_ranks (
243 rank_id smallint(5) UNSIGNED NOT NULL auto_increment,
244 rank_title varchar(50) NOT NULL,
245 rank_min mediumint(8) DEFAULT '0' NOT NULL,
246 rank_special tinyint(1) DEFAULT '0',
247 rank_image varchar(255),
248 PRIMARY KEY (rank_id)
249 );
250
251
252 # --------------------------------------------------------
253 #
254 # Table structure for table `phpbb_search_results`
255 #
256 CREATE TABLE phpbb_search_results (
257 search_id int(11) UNSIGNED NOT NULL default '0',
258 session_id char(32) NOT NULL default '',
259 search_time int(11) DEFAULT '0' NOT NULL,
260 search_array mediumtext NOT NULL,
261 PRIMARY KEY (search_id),
262 KEY session_id (session_id)
263 );
264
265
266 # --------------------------------------------------------
267 #
268 # Table structure for table `phpbb_search_wordlist`
269 #
270 CREATE TABLE phpbb_search_wordlist (
271 word_text varchar(50) binary NOT NULL default '',
272 word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
273 word_common tinyint(1) unsigned NOT NULL default '0',
274 PRIMARY KEY (word_text),
275 KEY word_id (word_id)
276 );
277
278 # --------------------------------------------------------
279 #
280 # Table structure for table `phpbb_search_wordmatch`
281 #
282 CREATE TABLE phpbb_search_wordmatch (
283 post_id mediumint(8) UNSIGNED NOT NULL default '0',
284 word_id mediumint(8) UNSIGNED NOT NULL default '0',
285 title_match tinyint(1) NOT NULL default '0',
286 KEY post_id (post_id),
287 KEY word_id (word_id)
288 );
289
290
291 # --------------------------------------------------------
292 #
293 # Table structure for table 'phpbb_sessions'
294 #
295 # Note that if you're running 3.23.x you may want to make
296 # this table a type HEAP. This type of table is stored
297 # within system memory and therefore for big busy boards
298 # is likely to be noticeably faster than continually
299 # writing to disk ...
300 #
301 CREATE TABLE phpbb_sessions (
302 session_id char(32) DEFAULT '' NOT NULL,
303 session_user_id mediumint(8) DEFAULT '0' NOT NULL,
304 session_start int(11) DEFAULT '0' NOT NULL,
305 session_time int(11) DEFAULT '0' NOT NULL,
306 session_ip char(8) DEFAULT '0' NOT NULL,
307 session_page int(11) DEFAULT '0' NOT NULL,
308 session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
309 session_admin tinyint(2) DEFAULT '0' NOT NULL,
310 priv_session_id char(32) DEFAULT '' NOT NULL,
311 PRIMARY KEY (session_id),
312 KEY session_user_id (session_user_id),
313 KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
314 );
315
316 # --------------------------------------------------------
317 #
318 # Table structure for table `phpbb_sessions_keys`
319 #
320 CREATE TABLE phpbb_sessions_keys (
321 key_id varchar(32) DEFAULT '0' NOT NULL,
322 user_id mediumint(8) DEFAULT '0' NOT NULL,
323 last_ip varchar(8) DEFAULT '0' NOT NULL,
324 last_login int(11) DEFAULT '0' NOT NULL,
325 PRIMARY KEY (key_id, user_id),
326 KEY last_login (last_login)
327 );
328
329
330 # --------------------------------------------------------
331 #
332 # Table structure for table 'phpbb_smilies'
333 #
334 CREATE TABLE phpbb_smilies (
335 smilies_id smallint(5) UNSIGNED NOT NULL auto_increment,
336 code varchar(50),
337 smile_url varchar(100),
338 emoticon varchar(75),
339 PRIMARY KEY (smilies_id)
340 );
341
342
343 # --------------------------------------------------------
344 #
345 # Table structure for table 'phpbb_themes'
346 #
347 CREATE TABLE phpbb_themes (
348 themes_id mediumint(8) UNSIGNED NOT NULL auto_increment,
349 template_name varchar(30) NOT NULL default '',
350 style_name varchar(30) NOT NULL default '',
351 head_stylesheet varchar(100) default NULL,
352 body_background varchar(100) default NULL,
353 body_bgcolor varchar(6) default NULL,
354 body_text varchar(6) default NULL,
355 body_link varchar(6) default NULL,
356 body_vlink varchar(6) default NULL,
357 body_alink varchar(6) default NULL,
358 body_hlink varchar(6) default NULL,
359 tr_color1 varchar(6) default NULL,
360 tr_color2 varchar(6) default NULL,
361 tr_color3 varchar(6) default NULL,
362 tr_class1 varchar(25) default NULL,
363 tr_class2 varchar(25) default NULL,
364 tr_class3 varchar(25) default NULL,
365 th_color1 varchar(6) default NULL,
366 th_color2 varchar(6) default NULL,
367 th_color3 varchar(6) default NULL,
368 th_class1 varchar(25) default NULL,
369 th_class2 varchar(25) default NULL,
370 th_class3 varchar(25) default NULL,
371 td_color1 varchar(6) default NULL,
372 td_color2 varchar(6) default NULL,
373 td_color3 varchar(6) default NULL,
374 td_class1 varchar(25) default NULL,
375 td_class2 varchar(25) default NULL,
376 td_class3 varchar(25) default NULL,
377 fontface1 varchar(50) default NULL,
378 fontface2 varchar(50) default NULL,
379 fontface3 varchar(50) default NULL,
380 fontsize1 tinyint(4) default NULL,
381 fontsize2 tinyint(4) default NULL,
382 fontsize3 tinyint(4) default NULL,
383 fontcolor1 varchar(6) default NULL,
384 fontcolor2 varchar(6) default NULL,
385 fontcolor3 varchar(6) default NULL,
386 span_class1 varchar(25) default NULL,
387 span_class2 varchar(25) default NULL,
388 span_class3 varchar(25) default NULL,
389 img_size_poll smallint(5) UNSIGNED,
390 img_size_privmsg smallint(5) UNSIGNED,
391 PRIMARY KEY (themes_id)
392 );
393
394
395 # --------------------------------------------------------
396 #
397 # Table structure for table 'phpbb_themes_name'
398 #
399 CREATE TABLE phpbb_themes_name (
400 themes_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
401 tr_color1_name char(50),
402 tr_color2_name char(50),
403 tr_color3_name char(50),
404 tr_class1_name char(50),
405 tr_class2_name char(50),
406 tr_class3_name char(50),
407 th_color1_name char(50),
408 th_color2_name char(50),
409 th_color3_name char(50),
410 th_class1_name char(50),
411 th_class2_name char(50),
412 th_class3_name char(50),
413 td_color1_name char(50),
414 td_color2_name char(50),
415 td_color3_name char(50),
416 td_class1_name char(50),
417 td_class2_name char(50),
418 td_class3_name char(50),
419 fontface1_name char(50),
420 fontface2_name char(50),
421 fontface3_name char(50),
422 fontsize1_name char(50),
423 fontsize2_name char(50),
424 fontsize3_name char(50),
425 fontcolor1_name char(50),
426 fontcolor2_name char(50),
427 fontcolor3_name char(50),
428 span_class1_name char(50),
429 span_class2_name char(50),
430 span_class3_name char(50),
431 PRIMARY KEY (themes_id)
432 );
433
434
435 # --------------------------------------------------------
436 #
437 # Table structure for table 'phpbb_topics'
438 #
439 CREATE TABLE phpbb_topics (
440 topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
441 forum_id smallint(8) UNSIGNED DEFAULT '0' NOT NULL,
442 topic_title char(60) NOT NULL,
443 topic_poster mediumint(8) DEFAULT '0' NOT NULL,
444 topic_time int(11) DEFAULT '0' NOT NULL,
445 topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
446 topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
447 topic_status tinyint(3) DEFAULT '0' NOT NULL,
448 topic_vote tinyint(1) DEFAULT '0' NOT NULL,
449 topic_type tinyint(3) DEFAULT '0' NOT NULL,
450 topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
451 topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
452 topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
453 PRIMARY KEY (topic_id),
454 KEY forum_id (forum_id),
455 KEY topic_moved_id (topic_moved_id),
456 KEY topic_status (topic_status),
457 KEY topic_type (topic_type)
458 );
459
460
461 # --------------------------------------------------------
462 #
463 # Table structure for table 'phpbb_topics_watch'
464 #
465 CREATE TABLE phpbb_topics_watch (
466 topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
467 user_id mediumint(8) NOT NULL DEFAULT '0',
468 notify_status tinyint(1) NOT NULL default '0',
469 KEY topic_id (topic_id),
470 KEY user_id (user_id),
471 KEY notify_status (notify_status)
472 );
473
474
475 # --------------------------------------------------------
476 #
477 # Table structure for table 'phpbb_users'
478 #
479 CREATE TABLE phpbb_users (
480 user_id mediumint(8) NOT NULL,
481 user_active tinyint(1) DEFAULT '1',
482 username varchar(25) NOT NULL,
483 user_password varchar(32) NOT NULL,
484 user_session_time int(11) DEFAULT '0' NOT NULL,
485 user_session_page smallint(5) DEFAULT '0' NOT NULL,
486 user_lastvisit int(11) DEFAULT '0' NOT NULL,
487 user_regdate int(11) DEFAULT '0' NOT NULL,
488 user_level tinyint(4) DEFAULT '0',
489 user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
490 user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
491 user_style tinyint(4),
492 user_lang varchar(255),
493 user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
494 user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
495 user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
496 user_last_privmsg int(11) DEFAULT '0' NOT NULL,
497 user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
498 user_last_login_try int(11) DEFAULT '0' NOT NULL,
499 user_emailtime int(11),
500 user_viewemail tinyint(1),
501 user_attachsig tinyint(1),
502 user_allowhtml tinyint(1) DEFAULT '1',
503 user_allowbbcode tinyint(1) DEFAULT '1',
504 user_allowsmile tinyint(1) DEFAULT '1',
505 user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
506 user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
507 user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
508 user_notify tinyint(1) DEFAULT '1' NOT NULL,
509 user_notify_pm tinyint(1) DEFAULT '0' NOT NULL,
510 user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
511 user_rank int(11) DEFAULT '0',
512 user_avatar varchar(100),
513 user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
514 user_email varchar(255),
515 user_icq varchar(15),
516 user_website varchar(100),
517 user_from varchar(100),
518 user_sig text,
519 user_sig_bbcode_uid char(10),
520 user_aim varchar(255),
521 user_yim varchar(255),
522 user_msnm varchar(255),
523 user_occ varchar(100),
524 user_interests varchar(255),
525 user_actkey varchar(32),
526 user_newpasswd varchar(32),
527 PRIMARY KEY (user_id),
528 KEY user_session_time (user_session_time)
529 );
530
531
532 # --------------------------------------------------------
533 #
534 # Table structure for table 'phpbb_vote_desc'
535 #
536 CREATE TABLE phpbb_vote_desc (
537 vote_id mediumint(8) UNSIGNED NOT NULL auto_increment,
538 topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
539 vote_text text NOT NULL,
540 vote_start int(11) NOT NULL DEFAULT '0',
541 vote_length int(11) NOT NULL DEFAULT '0',
542 PRIMARY KEY (vote_id),
543 KEY topic_id (topic_id)
544 );
545
546
547 # --------------------------------------------------------
548 #
549 # Table structure for table 'phpbb_vote_results'
550 #
551 CREATE TABLE phpbb_vote_results (
552 vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
553 vote_option_id tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
554 vote_option_text varchar(255) NOT NULL,
555 vote_result int(11) NOT NULL DEFAULT '0',
556 KEY vote_option_id (vote_option_id),
557 KEY vote_id (vote_id)
558 );
559
560
561 # --------------------------------------------------------
562 #
563 # Table structure for table 'phpbb_vote_voters'
564 #
565 CREATE TABLE phpbb_vote_voters (
566 vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
567 vote_user_id mediumint(8) NOT NULL DEFAULT '0',
568 vote_user_ip char(8) NOT NULL,
569 KEY vote_id (vote_id),
570 KEY vote_user_id (vote_user_id),
571 KEY vote_user_ip (vote_user_ip)
572 );
573
574
575 # --------------------------------------------------------
576 #
577 # Table structure for table 'phpbb_words'
578 #
579 CREATE TABLE phpbb_words (
580 word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
581 word char(100) NOT NULL,
582 replacement char(100) NOT NULL,
583 PRIMARY KEY (word_id)
584 );
585