Verzeichnisstruktur phpBB-3.0.0
- Veröffentlicht
- 12.12.2007
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 |
firebird_schema.sql
0001 #
0002 # $Id$
0003 #
0004
0005
0006 # Table: 'phpbb_attachments'
0007 CREATE TABLE phpbb_attachments (
0008 attach_id INTEGER NOT NULL,
0009 post_msg_id INTEGER DEFAULT 0 NOT NULL,
0010 topic_id INTEGER DEFAULT 0 NOT NULL,
0011 in_message INTEGER DEFAULT 0 NOT NULL,
0012 poster_id INTEGER DEFAULT 0 NOT NULL,
0013 is_orphan INTEGER DEFAULT 1 NOT NULL,
0014 physical_filename VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0015 real_filename VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0016 download_count INTEGER DEFAULT 0 NOT NULL,
0017 attach_comment BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0018 extension VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
0019 mimetype VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
0020 filesize INTEGER DEFAULT 0 NOT NULL,
0021 filetime INTEGER DEFAULT 0 NOT NULL,
0022 thumbnail INTEGER DEFAULT 0 NOT NULL
0023 );;
0024
0025 ALTER TABLE phpbb_attachments ADD PRIMARY KEY (attach_id);;
0026
0027 CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments(filetime);;
0028 CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments(post_msg_id);;
0029 CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments(topic_id);;
0030 CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments(poster_id);;
0031 CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments(is_orphan);;
0032
0033 CREATE GENERATOR phpbb_attachments_gen;;
0034 SET GENERATOR phpbb_attachments_gen TO 0;;
0035
0036 CREATE TRIGGER t_phpbb_attachments FOR phpbb_attachments
0037 BEFORE INSERT
0038 AS
0039 BEGIN
0040 NEW.attach_id = GEN_ID(phpbb_attachments_gen, 1);
0041 END;;
0042
0043
0044 # Table: 'phpbb_acl_groups'
0045 CREATE TABLE phpbb_acl_groups (
0046 group_id INTEGER DEFAULT 0 NOT NULL,
0047 forum_id INTEGER DEFAULT 0 NOT NULL,
0048 auth_option_id INTEGER DEFAULT 0 NOT NULL,
0049 auth_role_id INTEGER DEFAULT 0 NOT NULL,
0050 auth_setting INTEGER DEFAULT 0 NOT NULL
0051 );;
0052
0053 CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups(group_id);;
0054 CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups(auth_option_id);;
0055 CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups(auth_role_id);;
0056
0057 # Table: 'phpbb_acl_options'
0058 CREATE TABLE phpbb_acl_options (
0059 auth_option_id INTEGER NOT NULL,
0060 auth_option VARCHAR(50) CHARACTER SET NONE DEFAULT '' NOT NULL,
0061 is_global INTEGER DEFAULT 0 NOT NULL,
0062 is_local INTEGER DEFAULT 0 NOT NULL,
0063 founder_only INTEGER DEFAULT 0 NOT NULL
0064 );;
0065
0066 ALTER TABLE phpbb_acl_options ADD PRIMARY KEY (auth_option_id);;
0067
0068 CREATE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options(auth_option);;
0069
0070 CREATE GENERATOR phpbb_acl_options_gen;;
0071 SET GENERATOR phpbb_acl_options_gen TO 0;;
0072
0073 CREATE TRIGGER t_phpbb_acl_options FOR phpbb_acl_options
0074 BEFORE INSERT
0075 AS
0076 BEGIN
0077 NEW.auth_option_id = GEN_ID(phpbb_acl_options_gen, 1);
0078 END;;
0079
0080
0081 # Table: 'phpbb_acl_roles'
0082 CREATE TABLE phpbb_acl_roles (
0083 role_id INTEGER NOT NULL,
0084 role_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0085 role_description BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0086 role_type VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
0087 role_order INTEGER DEFAULT 0 NOT NULL
0088 );;
0089
0090 ALTER TABLE phpbb_acl_roles ADD PRIMARY KEY (role_id);;
0091
0092 CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles(role_type);;
0093 CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles(role_order);;
0094
0095 CREATE GENERATOR phpbb_acl_roles_gen;;
0096 SET GENERATOR phpbb_acl_roles_gen TO 0;;
0097
0098 CREATE TRIGGER t_phpbb_acl_roles FOR phpbb_acl_roles
0099 BEFORE INSERT
0100 AS
0101 BEGIN
0102 NEW.role_id = GEN_ID(phpbb_acl_roles_gen, 1);
0103 END;;
0104
0105
0106 # Table: 'phpbb_acl_roles_data'
0107 CREATE TABLE phpbb_acl_roles_data (
0108 role_id INTEGER DEFAULT 0 NOT NULL,
0109 auth_option_id INTEGER DEFAULT 0 NOT NULL,
0110 auth_setting INTEGER DEFAULT 0 NOT NULL
0111 );;
0112
0113 ALTER TABLE phpbb_acl_roles_data ADD PRIMARY KEY (role_id, auth_option_id);;
0114
0115 CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data(auth_option_id);;
0116
0117 # Table: 'phpbb_acl_users'
0118 CREATE TABLE phpbb_acl_users (
0119 user_id INTEGER DEFAULT 0 NOT NULL,
0120 forum_id INTEGER DEFAULT 0 NOT NULL,
0121 auth_option_id INTEGER DEFAULT 0 NOT NULL,
0122 auth_role_id INTEGER DEFAULT 0 NOT NULL,
0123 auth_setting INTEGER DEFAULT 0 NOT NULL
0124 );;
0125
0126 CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users(user_id);;
0127 CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users(auth_option_id);;
0128 CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users(auth_role_id);;
0129
0130 # Table: 'phpbb_banlist'
0131 CREATE TABLE phpbb_banlist (
0132 ban_id INTEGER NOT NULL,
0133 ban_userid INTEGER DEFAULT 0 NOT NULL,
0134 ban_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
0135 ban_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0136 ban_start INTEGER DEFAULT 0 NOT NULL,
0137 ban_end INTEGER DEFAULT 0 NOT NULL,
0138 ban_exclude INTEGER DEFAULT 0 NOT NULL,
0139 ban_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0140 ban_give_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
0141 );;
0142
0143 ALTER TABLE phpbb_banlist ADD PRIMARY KEY (ban_id);;
0144
0145 CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist(ban_end);;
0146 CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist(ban_userid, ban_exclude);;
0147 CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist(ban_email, ban_exclude);;
0148 CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist(ban_ip, ban_exclude);;
0149
0150 CREATE GENERATOR phpbb_banlist_gen;;
0151 SET GENERATOR phpbb_banlist_gen TO 0;;
0152
0153 CREATE TRIGGER t_phpbb_banlist FOR phpbb_banlist
0154 BEFORE INSERT
0155 AS
0156 BEGIN
0157 NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1);
0158 END;;
0159
0160
0161 # Table: 'phpbb_bbcodes'
0162 CREATE TABLE phpbb_bbcodes (
0163 bbcode_id INTEGER DEFAULT 0 NOT NULL,
0164 bbcode_tag VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,
0165 bbcode_helpline VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0166 display_on_posting INTEGER DEFAULT 0 NOT NULL,
0167 bbcode_match BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0168 bbcode_tpl BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0169 first_pass_match BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0170 first_pass_replace BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0171 second_pass_match BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0172 second_pass_replace BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
0173 );;
0174
0175 ALTER TABLE phpbb_bbcodes ADD PRIMARY KEY (bbcode_id);;
0176
0177 CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes(display_on_posting);;
0178
0179 # Table: 'phpbb_bookmarks'
0180 CREATE TABLE phpbb_bookmarks (
0181 topic_id INTEGER DEFAULT 0 NOT NULL,
0182 user_id INTEGER DEFAULT 0 NOT NULL
0183 );;
0184
0185 ALTER TABLE phpbb_bookmarks ADD PRIMARY KEY (topic_id, user_id);;
0186
0187
0188 # Table: 'phpbb_bots'
0189 CREATE TABLE phpbb_bots (
0190 bot_id INTEGER NOT NULL,
0191 bot_active INTEGER DEFAULT 1 NOT NULL,
0192 bot_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0193 user_id INTEGER DEFAULT 0 NOT NULL,
0194 bot_agent VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0195 bot_ip VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
0196 );;
0197
0198 ALTER TABLE phpbb_bots ADD PRIMARY KEY (bot_id);;
0199
0200 CREATE INDEX phpbb_bots_bot_active ON phpbb_bots(bot_active);;
0201
0202 CREATE GENERATOR phpbb_bots_gen;;
0203 SET GENERATOR phpbb_bots_gen TO 0;;
0204
0205 CREATE TRIGGER t_phpbb_bots FOR phpbb_bots
0206 BEFORE INSERT
0207 AS
0208 BEGIN
0209 NEW.bot_id = GEN_ID(phpbb_bots_gen, 1);
0210 END;;
0211
0212
0213 # Table: 'phpbb_config'
0214 CREATE TABLE phpbb_config (
0215 config_name VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0216 config_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0217 is_dynamic INTEGER DEFAULT 0 NOT NULL
0218 );;
0219
0220 ALTER TABLE phpbb_config ADD PRIMARY KEY (config_name);;
0221
0222 CREATE INDEX phpbb_config_is_dynamic ON phpbb_config(is_dynamic);;
0223
0224 # Table: 'phpbb_confirm'
0225 CREATE TABLE phpbb_confirm (
0226 confirm_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
0227 session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
0228 confirm_type INTEGER DEFAULT 0 NOT NULL,
0229 code VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
0230 seed INTEGER DEFAULT 0 NOT NULL
0231 );;
0232
0233 ALTER TABLE phpbb_confirm ADD PRIMARY KEY (session_id, confirm_id);;
0234
0235 CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm(confirm_type);;
0236
0237 # Table: 'phpbb_disallow'
0238 CREATE TABLE phpbb_disallow (
0239 disallow_id INTEGER NOT NULL,
0240 disallow_username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
0241 );;
0242
0243 ALTER TABLE phpbb_disallow ADD PRIMARY KEY (disallow_id);;
0244
0245
0246 CREATE GENERATOR phpbb_disallow_gen;;
0247 SET GENERATOR phpbb_disallow_gen TO 0;;
0248
0249 CREATE TRIGGER t_phpbb_disallow FOR phpbb_disallow
0250 BEFORE INSERT
0251 AS
0252 BEGIN
0253 NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1);
0254 END;;
0255
0256
0257 # Table: 'phpbb_drafts'
0258 CREATE TABLE phpbb_drafts (
0259 draft_id INTEGER NOT NULL,
0260 user_id INTEGER DEFAULT 0 NOT NULL,
0261 topic_id INTEGER DEFAULT 0 NOT NULL,
0262 forum_id INTEGER DEFAULT 0 NOT NULL,
0263 save_time INTEGER DEFAULT 0 NOT NULL,
0264 draft_subject VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0265 draft_message BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
0266 );;
0267
0268 ALTER TABLE phpbb_drafts ADD PRIMARY KEY (draft_id);;
0269
0270 CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts(save_time);;
0271
0272 CREATE GENERATOR phpbb_drafts_gen;;
0273 SET GENERATOR phpbb_drafts_gen TO 0;;
0274
0275 CREATE TRIGGER t_phpbb_drafts FOR phpbb_drafts
0276 BEFORE INSERT
0277 AS
0278 BEGIN
0279 NEW.draft_id = GEN_ID(phpbb_drafts_gen, 1);
0280 END;;
0281
0282
0283 # Table: 'phpbb_extensions'
0284 CREATE TABLE phpbb_extensions (
0285 extension_id INTEGER NOT NULL,
0286 group_id INTEGER DEFAULT 0 NOT NULL,
0287 extension VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL
0288 );;
0289
0290 ALTER TABLE phpbb_extensions ADD PRIMARY KEY (extension_id);;
0291
0292
0293 CREATE GENERATOR phpbb_extensions_gen;;
0294 SET GENERATOR phpbb_extensions_gen TO 0;;
0295
0296 CREATE TRIGGER t_phpbb_extensions FOR phpbb_extensions
0297 BEFORE INSERT
0298 AS
0299 BEGIN
0300 NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1);
0301 END;;
0302
0303
0304 # Table: 'phpbb_extension_groups'
0305 CREATE TABLE phpbb_extension_groups (
0306 group_id INTEGER NOT NULL,
0307 group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0308 cat_id INTEGER DEFAULT 0 NOT NULL,
0309 allow_group INTEGER DEFAULT 0 NOT NULL,
0310 download_mode INTEGER DEFAULT 1 NOT NULL,
0311 upload_icon VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0312 max_filesize INTEGER DEFAULT 0 NOT NULL,
0313 allowed_forums BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
0314 allow_in_pm INTEGER DEFAULT 0 NOT NULL
0315 );;
0316
0317 ALTER TABLE phpbb_extension_groups ADD PRIMARY KEY (group_id);;
0318
0319
0320 CREATE GENERATOR phpbb_extension_groups_gen;;
0321 SET GENERATOR phpbb_extension_groups_gen TO 0;;
0322
0323 CREATE TRIGGER t_phpbb_extension_groups FOR phpbb_extension_groups
0324 BEFORE INSERT
0325 AS
0326 BEGIN
0327 NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1);
0328 END;;
0329
0330
0331 # Table: 'phpbb_forums'
0332 CREATE TABLE phpbb_forums (
0333 forum_id INTEGER NOT NULL,
0334 parent_id INTEGER DEFAULT 0 NOT NULL,
0335 left_id INTEGER DEFAULT 0 NOT NULL,
0336 right_id INTEGER DEFAULT 0 NOT NULL,
0337 forum_parents BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
0338 forum_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0339 forum_desc BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0340 forum_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0341 forum_desc_options INTEGER DEFAULT 7 NOT NULL,
0342 forum_desc_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
0343 forum_link VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0344 forum_password VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0345 forum_style INTEGER DEFAULT 0 NOT NULL,
0346 forum_image VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0347 forum_rules BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0348 forum_rules_link VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0349 forum_rules_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0350 forum_rules_options INTEGER DEFAULT 7 NOT NULL,
0351 forum_rules_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
0352 forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,
0353 forum_type INTEGER DEFAULT 0 NOT NULL,
0354 forum_status INTEGER DEFAULT 0 NOT NULL,
0355 forum_posts INTEGER DEFAULT 0 NOT NULL,
0356 forum_topics INTEGER DEFAULT 0 NOT NULL,
0357 forum_topics_real INTEGER DEFAULT 0 NOT NULL,
0358 forum_last_post_id INTEGER DEFAULT 0 NOT NULL,
0359 forum_last_poster_id INTEGER DEFAULT 0 NOT NULL,
0360 forum_last_post_subject VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0361 forum_last_post_time INTEGER DEFAULT 0 NOT NULL,
0362 forum_last_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0363 forum_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
0364 forum_flags INTEGER DEFAULT 32 NOT NULL,
0365 display_on_index INTEGER DEFAULT 1 NOT NULL,
0366 enable_indexing INTEGER DEFAULT 1 NOT NULL,
0367 enable_icons INTEGER DEFAULT 1 NOT NULL,
0368 enable_prune INTEGER DEFAULT 0 NOT NULL,
0369 prune_next INTEGER DEFAULT 0 NOT NULL,
0370 prune_days INTEGER DEFAULT 0 NOT NULL,
0371 prune_viewed INTEGER DEFAULT 0 NOT NULL,
0372 prune_freq INTEGER DEFAULT 0 NOT NULL
0373 );;
0374
0375 ALTER TABLE phpbb_forums ADD PRIMARY KEY (forum_id);;
0376
0377 CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums(left_id, right_id);;
0378 CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums(forum_last_post_id);;
0379
0380 CREATE GENERATOR phpbb_forums_gen;;
0381 SET GENERATOR phpbb_forums_gen TO 0;;
0382
0383 CREATE TRIGGER t_phpbb_forums FOR phpbb_forums
0384 BEFORE INSERT
0385 AS
0386 BEGIN
0387 NEW.forum_id = GEN_ID(phpbb_forums_gen, 1);
0388 END;;
0389
0390
0391 # Table: 'phpbb_forums_access'
0392 CREATE TABLE phpbb_forums_access (
0393 forum_id INTEGER DEFAULT 0 NOT NULL,
0394 user_id INTEGER DEFAULT 0 NOT NULL,
0395 session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL
0396 );;
0397
0398 ALTER TABLE phpbb_forums_access ADD PRIMARY KEY (forum_id, user_id, session_id);;
0399
0400
0401 # Table: 'phpbb_forums_track'
0402 CREATE TABLE phpbb_forums_track (
0403 user_id INTEGER DEFAULT 0 NOT NULL,
0404 forum_id INTEGER DEFAULT 0 NOT NULL,
0405 mark_time INTEGER DEFAULT 0 NOT NULL
0406 );;
0407
0408 ALTER TABLE phpbb_forums_track ADD PRIMARY KEY (user_id, forum_id);;
0409
0410
0411 # Table: 'phpbb_forums_watch'
0412 CREATE TABLE phpbb_forums_watch (
0413 forum_id INTEGER DEFAULT 0 NOT NULL,
0414 user_id INTEGER DEFAULT 0 NOT NULL,
0415 notify_status INTEGER DEFAULT 0 NOT NULL
0416 );;
0417
0418 CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch(forum_id);;
0419 CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch(user_id);;
0420 CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch(notify_status);;
0421
0422 # Table: 'phpbb_groups'
0423 CREATE TABLE phpbb_groups (
0424 group_id INTEGER NOT NULL,
0425 group_type INTEGER DEFAULT 1 NOT NULL,
0426 group_founder_manage INTEGER DEFAULT 0 NOT NULL,
0427 group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0428 group_desc BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0429 group_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0430 group_desc_options INTEGER DEFAULT 7 NOT NULL,
0431 group_desc_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
0432 group_display INTEGER DEFAULT 0 NOT NULL,
0433 group_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0434 group_avatar_type INTEGER DEFAULT 0 NOT NULL,
0435 group_avatar_width INTEGER DEFAULT 0 NOT NULL,
0436 group_avatar_height INTEGER DEFAULT 0 NOT NULL,
0437 group_rank INTEGER DEFAULT 0 NOT NULL,
0438 group_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
0439 group_sig_chars INTEGER DEFAULT 0 NOT NULL,
0440 group_receive_pm INTEGER DEFAULT 0 NOT NULL,
0441 group_message_limit INTEGER DEFAULT 0 NOT NULL,
0442 group_legend INTEGER DEFAULT 1 NOT NULL
0443 );;
0444
0445 ALTER TABLE phpbb_groups ADD PRIMARY KEY (group_id);;
0446
0447 CREATE INDEX phpbb_groups_group_legend ON phpbb_groups(group_legend);;
0448
0449 CREATE GENERATOR phpbb_groups_gen;;
0450 SET GENERATOR phpbb_groups_gen TO 0;;
0451
0452 CREATE TRIGGER t_phpbb_groups FOR phpbb_groups
0453 BEFORE INSERT
0454 AS
0455 BEGIN
0456 NEW.group_id = GEN_ID(phpbb_groups_gen, 1);
0457 END;;
0458
0459
0460 # Table: 'phpbb_icons'
0461 CREATE TABLE phpbb_icons (
0462 icons_id INTEGER NOT NULL,
0463 icons_url VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0464 icons_width INTEGER DEFAULT 0 NOT NULL,
0465 icons_height INTEGER DEFAULT 0 NOT NULL,
0466 icons_order INTEGER DEFAULT 0 NOT NULL,
0467 display_on_posting INTEGER DEFAULT 1 NOT NULL
0468 );;
0469
0470 ALTER TABLE phpbb_icons ADD PRIMARY KEY (icons_id);;
0471
0472 CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons(display_on_posting);;
0473
0474 CREATE GENERATOR phpbb_icons_gen;;
0475 SET GENERATOR phpbb_icons_gen TO 0;;
0476
0477 CREATE TRIGGER t_phpbb_icons FOR phpbb_icons
0478 BEFORE INSERT
0479 AS
0480 BEGIN
0481 NEW.icons_id = GEN_ID(phpbb_icons_gen, 1);
0482 END;;
0483
0484
0485 # Table: 'phpbb_lang'
0486 CREATE TABLE phpbb_lang (
0487 lang_id INTEGER NOT NULL,
0488 lang_iso VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
0489 lang_dir VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
0490 lang_english_name VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0491 lang_local_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0492 lang_author VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
0493 );;
0494
0495 ALTER TABLE phpbb_lang ADD PRIMARY KEY (lang_id);;
0496
0497 CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang(lang_iso);;
0498
0499 CREATE GENERATOR phpbb_lang_gen;;
0500 SET GENERATOR phpbb_lang_gen TO 0;;
0501
0502 CREATE TRIGGER t_phpbb_lang FOR phpbb_lang
0503 BEFORE INSERT
0504 AS
0505 BEGIN
0506 NEW.lang_id = GEN_ID(phpbb_lang_gen, 1);
0507 END;;
0508
0509
0510 # Table: 'phpbb_log'
0511 CREATE TABLE phpbb_log (
0512 log_id INTEGER NOT NULL,
0513 log_type INTEGER DEFAULT 0 NOT NULL,
0514 user_id INTEGER DEFAULT 0 NOT NULL,
0515 forum_id INTEGER DEFAULT 0 NOT NULL,
0516 topic_id INTEGER DEFAULT 0 NOT NULL,
0517 reportee_id INTEGER DEFAULT 0 NOT NULL,
0518 log_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
0519 log_time INTEGER DEFAULT 0 NOT NULL,
0520 log_operation BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0521 log_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
0522 );;
0523
0524 ALTER TABLE phpbb_log ADD PRIMARY KEY (log_id);;
0525
0526 CREATE INDEX phpbb_log_log_type ON phpbb_log(log_type);;
0527 CREATE INDEX phpbb_log_forum_id ON phpbb_log(forum_id);;
0528 CREATE INDEX phpbb_log_topic_id ON phpbb_log(topic_id);;
0529 CREATE INDEX phpbb_log_reportee_id ON phpbb_log(reportee_id);;
0530 CREATE INDEX phpbb_log_user_id ON phpbb_log(user_id);;
0531
0532 CREATE GENERATOR phpbb_log_gen;;
0533 SET GENERATOR phpbb_log_gen TO 0;;
0534
0535 CREATE TRIGGER t_phpbb_log FOR phpbb_log
0536 BEFORE INSERT
0537 AS
0538 BEGIN
0539 NEW.log_id = GEN_ID(phpbb_log_gen, 1);
0540 END;;
0541
0542
0543 # Table: 'phpbb_moderator_cache'
0544 CREATE TABLE phpbb_moderator_cache (
0545 forum_id INTEGER DEFAULT 0 NOT NULL,
0546 user_id INTEGER DEFAULT 0 NOT NULL,
0547 username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0548 group_id INTEGER DEFAULT 0 NOT NULL,
0549 group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0550 display_on_index INTEGER DEFAULT 1 NOT NULL
0551 );;
0552
0553 CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache(display_on_index);;
0554 CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache(forum_id);;
0555
0556 # Table: 'phpbb_modules'
0557 CREATE TABLE phpbb_modules (
0558 module_id INTEGER NOT NULL,
0559 module_enabled INTEGER DEFAULT 1 NOT NULL,
0560 module_display INTEGER DEFAULT 1 NOT NULL,
0561 module_basename VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0562 module_class VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
0563 parent_id INTEGER DEFAULT 0 NOT NULL,
0564 left_id INTEGER DEFAULT 0 NOT NULL,
0565 right_id INTEGER DEFAULT 0 NOT NULL,
0566 module_langname VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0567 module_mode VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0568 module_auth VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
0569 );;
0570
0571 ALTER TABLE phpbb_modules ADD PRIMARY KEY (module_id);;
0572
0573 CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules(left_id, right_id);;
0574 CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules(module_enabled);;
0575 CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules(module_class, left_id);;
0576
0577 CREATE GENERATOR phpbb_modules_gen;;
0578 SET GENERATOR phpbb_modules_gen TO 0;;
0579
0580 CREATE TRIGGER t_phpbb_modules FOR phpbb_modules
0581 BEFORE INSERT
0582 AS
0583 BEGIN
0584 NEW.module_id = GEN_ID(phpbb_modules_gen, 1);
0585 END;;
0586
0587
0588 # Table: 'phpbb_poll_options'
0589 CREATE TABLE phpbb_poll_options (
0590 poll_option_id INTEGER DEFAULT 0 NOT NULL,
0591 topic_id INTEGER DEFAULT 0 NOT NULL,
0592 poll_option_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0593 poll_option_total INTEGER DEFAULT 0 NOT NULL
0594 );;
0595
0596 CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options(poll_option_id);;
0597 CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options(topic_id);;
0598
0599 # Table: 'phpbb_poll_votes'
0600 CREATE TABLE phpbb_poll_votes (
0601 topic_id INTEGER DEFAULT 0 NOT NULL,
0602 poll_option_id INTEGER DEFAULT 0 NOT NULL,
0603 vote_user_id INTEGER DEFAULT 0 NOT NULL,
0604 vote_user_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL
0605 );;
0606
0607 CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes(topic_id);;
0608 CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes(vote_user_id);;
0609 CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes(vote_user_ip);;
0610
0611 # Table: 'phpbb_posts'
0612 CREATE TABLE phpbb_posts (
0613 post_id INTEGER NOT NULL,
0614 topic_id INTEGER DEFAULT 0 NOT NULL,
0615 forum_id INTEGER DEFAULT 0 NOT NULL,
0616 poster_id INTEGER DEFAULT 0 NOT NULL,
0617 icon_id INTEGER DEFAULT 0 NOT NULL,
0618 poster_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
0619 post_time INTEGER DEFAULT 0 NOT NULL,
0620 post_approved INTEGER DEFAULT 1 NOT NULL,
0621 post_reported INTEGER DEFAULT 0 NOT NULL,
0622 enable_bbcode INTEGER DEFAULT 1 NOT NULL,
0623 enable_smilies INTEGER DEFAULT 1 NOT NULL,
0624 enable_magic_url INTEGER DEFAULT 1 NOT NULL,
0625 enable_sig INTEGER DEFAULT 1 NOT NULL,
0626 post_username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0627 post_subject VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0628 post_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0629 post_checksum VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
0630 post_attachment INTEGER DEFAULT 0 NOT NULL,
0631 bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0632 bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
0633 post_postcount INTEGER DEFAULT 1 NOT NULL,
0634 post_edit_time INTEGER DEFAULT 0 NOT NULL,
0635 post_edit_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0636 post_edit_user INTEGER DEFAULT 0 NOT NULL,
0637 post_edit_count INTEGER DEFAULT 0 NOT NULL,
0638 post_edit_locked INTEGER DEFAULT 0 NOT NULL
0639 );;
0640
0641 ALTER TABLE phpbb_posts ADD PRIMARY KEY (post_id);;
0642
0643 CREATE INDEX phpbb_posts_forum_id ON phpbb_posts(forum_id);;
0644 CREATE INDEX phpbb_posts_topic_id ON phpbb_posts(topic_id);;
0645 CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts(poster_ip);;
0646 CREATE INDEX phpbb_posts_poster_id ON phpbb_posts(poster_id);;
0647 CREATE INDEX phpbb_posts_post_approved ON phpbb_posts(post_approved);;
0648 CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts(topic_id, post_time);;
0649
0650 CREATE GENERATOR phpbb_posts_gen;;
0651 SET GENERATOR phpbb_posts_gen TO 0;;
0652
0653 CREATE TRIGGER t_phpbb_posts FOR phpbb_posts
0654 BEFORE INSERT
0655 AS
0656 BEGIN
0657 NEW.post_id = GEN_ID(phpbb_posts_gen, 1);
0658 END;;
0659
0660
0661 # Table: 'phpbb_privmsgs'
0662 CREATE TABLE phpbb_privmsgs (
0663 msg_id INTEGER NOT NULL,
0664 root_level INTEGER DEFAULT 0 NOT NULL,
0665 author_id INTEGER DEFAULT 0 NOT NULL,
0666 icon_id INTEGER DEFAULT 0 NOT NULL,
0667 author_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
0668 message_time INTEGER DEFAULT 0 NOT NULL,
0669 enable_bbcode INTEGER DEFAULT 1 NOT NULL,
0670 enable_smilies INTEGER DEFAULT 1 NOT NULL,
0671 enable_magic_url INTEGER DEFAULT 1 NOT NULL,
0672 enable_sig INTEGER DEFAULT 1 NOT NULL,
0673 message_subject VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0674 message_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0675 message_edit_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0676 message_edit_user INTEGER DEFAULT 0 NOT NULL,
0677 message_attachment INTEGER DEFAULT 0 NOT NULL,
0678 bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0679 bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
0680 message_edit_time INTEGER DEFAULT 0 NOT NULL,
0681 message_edit_count INTEGER DEFAULT 0 NOT NULL,
0682 to_address BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0683 bcc_address BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
0684 );;
0685
0686 ALTER TABLE phpbb_privmsgs ADD PRIMARY KEY (msg_id);;
0687
0688 CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs(author_ip);;
0689 CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs(message_time);;
0690 CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs(author_id);;
0691 CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs(root_level);;
0692
0693 CREATE GENERATOR phpbb_privmsgs_gen;;
0694 SET GENERATOR phpbb_privmsgs_gen TO 0;;
0695
0696 CREATE TRIGGER t_phpbb_privmsgs FOR phpbb_privmsgs
0697 BEFORE INSERT
0698 AS
0699 BEGIN
0700 NEW.msg_id = GEN_ID(phpbb_privmsgs_gen, 1);
0701 END;;
0702
0703
0704 # Table: 'phpbb_privmsgs_folder'
0705 CREATE TABLE phpbb_privmsgs_folder (
0706 folder_id INTEGER NOT NULL,
0707 user_id INTEGER DEFAULT 0 NOT NULL,
0708 folder_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0709 pm_count INTEGER DEFAULT 0 NOT NULL
0710 );;
0711
0712 ALTER TABLE phpbb_privmsgs_folder ADD PRIMARY KEY (folder_id);;
0713
0714 CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder(user_id);;
0715
0716 CREATE GENERATOR phpbb_privmsgs_folder_gen;;
0717 SET GENERATOR phpbb_privmsgs_folder_gen TO 0;;
0718
0719 CREATE TRIGGER t_phpbb_privmsgs_folder FOR phpbb_privmsgs_folder
0720 BEFORE INSERT
0721 AS
0722 BEGIN
0723 NEW.folder_id = GEN_ID(phpbb_privmsgs_folder_gen, 1);
0724 END;;
0725
0726
0727 # Table: 'phpbb_privmsgs_rules'
0728 CREATE TABLE phpbb_privmsgs_rules (
0729 rule_id INTEGER NOT NULL,
0730 user_id INTEGER DEFAULT 0 NOT NULL,
0731 rule_check INTEGER DEFAULT 0 NOT NULL,
0732 rule_connection INTEGER DEFAULT 0 NOT NULL,
0733 rule_string VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0734 rule_user_id INTEGER DEFAULT 0 NOT NULL,
0735 rule_group_id INTEGER DEFAULT 0 NOT NULL,
0736 rule_action INTEGER DEFAULT 0 NOT NULL,
0737 rule_folder_id INTEGER DEFAULT 0 NOT NULL
0738 );;
0739
0740 ALTER TABLE phpbb_privmsgs_rules ADD PRIMARY KEY (rule_id);;
0741
0742 CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules(user_id);;
0743
0744 CREATE GENERATOR phpbb_privmsgs_rules_gen;;
0745 SET GENERATOR phpbb_privmsgs_rules_gen TO 0;;
0746
0747 CREATE TRIGGER t_phpbb_privmsgs_rules FOR phpbb_privmsgs_rules
0748 BEFORE INSERT
0749 AS
0750 BEGIN
0751 NEW.rule_id = GEN_ID(phpbb_privmsgs_rules_gen, 1);
0752 END;;
0753
0754
0755 # Table: 'phpbb_privmsgs_to'
0756 CREATE TABLE phpbb_privmsgs_to (
0757 msg_id INTEGER DEFAULT 0 NOT NULL,
0758 user_id INTEGER DEFAULT 0 NOT NULL,
0759 author_id INTEGER DEFAULT 0 NOT NULL,
0760 pm_deleted INTEGER DEFAULT 0 NOT NULL,
0761 pm_new INTEGER DEFAULT 1 NOT NULL,
0762 pm_unread INTEGER DEFAULT 1 NOT NULL,
0763 pm_replied INTEGER DEFAULT 0 NOT NULL,
0764 pm_marked INTEGER DEFAULT 0 NOT NULL,
0765 pm_forwarded INTEGER DEFAULT 0 NOT NULL,
0766 folder_id INTEGER DEFAULT 0 NOT NULL
0767 );;
0768
0769 CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to(msg_id);;
0770 CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to(author_id);;
0771 CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to(user_id, folder_id);;
0772
0773 # Table: 'phpbb_profile_fields'
0774 CREATE TABLE phpbb_profile_fields (
0775 field_id INTEGER NOT NULL,
0776 field_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0777 field_type INTEGER DEFAULT 0 NOT NULL,
0778 field_ident VARCHAR(20) CHARACTER SET NONE DEFAULT '' NOT NULL,
0779 field_length VARCHAR(20) CHARACTER SET NONE DEFAULT '' NOT NULL,
0780 field_minlen VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0781 field_maxlen VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0782 field_novalue VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0783 field_default_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0784 field_validation VARCHAR(20) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0785 field_required INTEGER DEFAULT 0 NOT NULL,
0786 field_show_on_reg INTEGER DEFAULT 0 NOT NULL,
0787 field_hide INTEGER DEFAULT 0 NOT NULL,
0788 field_no_view INTEGER DEFAULT 0 NOT NULL,
0789 field_active INTEGER DEFAULT 0 NOT NULL,
0790 field_order INTEGER DEFAULT 0 NOT NULL
0791 );;
0792
0793 ALTER TABLE phpbb_profile_fields ADD PRIMARY KEY (field_id);;
0794
0795 CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields(field_type);;
0796 CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields(field_order);;
0797
0798 CREATE GENERATOR phpbb_profile_fields_gen;;
0799 SET GENERATOR phpbb_profile_fields_gen TO 0;;
0800
0801 CREATE TRIGGER t_phpbb_profile_fields FOR phpbb_profile_fields
0802 BEFORE INSERT
0803 AS
0804 BEGIN
0805 NEW.field_id = GEN_ID(phpbb_profile_fields_gen, 1);
0806 END;;
0807
0808
0809 # Table: 'phpbb_profile_fields_data'
0810 CREATE TABLE phpbb_profile_fields_data (
0811 user_id INTEGER DEFAULT 0 NOT NULL
0812 );;
0813
0814 ALTER TABLE phpbb_profile_fields_data ADD PRIMARY KEY (user_id);;
0815
0816
0817 # Table: 'phpbb_profile_fields_lang'
0818 CREATE TABLE phpbb_profile_fields_lang (
0819 field_id INTEGER DEFAULT 0 NOT NULL,
0820 lang_id INTEGER DEFAULT 0 NOT NULL,
0821 option_id INTEGER DEFAULT 0 NOT NULL,
0822 field_type INTEGER DEFAULT 0 NOT NULL,
0823 lang_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
0824 );;
0825
0826 ALTER TABLE phpbb_profile_fields_lang ADD PRIMARY KEY (field_id, lang_id, option_id);;
0827
0828
0829 # Table: 'phpbb_profile_lang'
0830 CREATE TABLE phpbb_profile_lang (
0831 field_id INTEGER DEFAULT 0 NOT NULL,
0832 lang_id INTEGER DEFAULT 0 NOT NULL,
0833 lang_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0834 lang_explain BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0835 lang_default_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
0836 );;
0837
0838 ALTER TABLE phpbb_profile_lang ADD PRIMARY KEY (field_id, lang_id);;
0839
0840
0841 # Table: 'phpbb_ranks'
0842 CREATE TABLE phpbb_ranks (
0843 rank_id INTEGER NOT NULL,
0844 rank_title VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0845 rank_min INTEGER DEFAULT 0 NOT NULL,
0846 rank_special INTEGER DEFAULT 0 NOT NULL,
0847 rank_image VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
0848 );;
0849
0850 ALTER TABLE phpbb_ranks ADD PRIMARY KEY (rank_id);;
0851
0852
0853 CREATE GENERATOR phpbb_ranks_gen;;
0854 SET GENERATOR phpbb_ranks_gen TO 0;;
0855
0856 CREATE TRIGGER t_phpbb_ranks FOR phpbb_ranks
0857 BEFORE INSERT
0858 AS
0859 BEGIN
0860 NEW.rank_id = GEN_ID(phpbb_ranks_gen, 1);
0861 END;;
0862
0863
0864 # Table: 'phpbb_reports'
0865 CREATE TABLE phpbb_reports (
0866 report_id INTEGER NOT NULL,
0867 reason_id INTEGER DEFAULT 0 NOT NULL,
0868 post_id INTEGER DEFAULT 0 NOT NULL,
0869 user_id INTEGER DEFAULT 0 NOT NULL,
0870 user_notify INTEGER DEFAULT 0 NOT NULL,
0871 report_closed INTEGER DEFAULT 0 NOT NULL,
0872 report_time INTEGER DEFAULT 0 NOT NULL,
0873 report_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
0874 );;
0875
0876 ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;
0877
0878
0879 CREATE GENERATOR phpbb_reports_gen;;
0880 SET GENERATOR phpbb_reports_gen TO 0;;
0881
0882 CREATE TRIGGER t_phpbb_reports FOR phpbb_reports
0883 BEFORE INSERT
0884 AS
0885 BEGIN
0886 NEW.report_id = GEN_ID(phpbb_reports_gen, 1);
0887 END;;
0888
0889
0890 # Table: 'phpbb_reports_reasons'
0891 CREATE TABLE phpbb_reports_reasons (
0892 reason_id INTEGER NOT NULL,
0893 reason_title VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0894 reason_description BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0895 reason_order INTEGER DEFAULT 0 NOT NULL
0896 );;
0897
0898 ALTER TABLE phpbb_reports_reasons ADD PRIMARY KEY (reason_id);;
0899
0900
0901 CREATE GENERATOR phpbb_reports_reasons_gen;;
0902 SET GENERATOR phpbb_reports_reasons_gen TO 0;;
0903
0904 CREATE TRIGGER t_phpbb_reports_reasons FOR phpbb_reports_reasons
0905 BEFORE INSERT
0906 AS
0907 BEGIN
0908 NEW.reason_id = GEN_ID(phpbb_reports_reasons_gen, 1);
0909 END;;
0910
0911
0912 # Table: 'phpbb_search_results'
0913 CREATE TABLE phpbb_search_results (
0914 search_key VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
0915 search_time INTEGER DEFAULT 0 NOT NULL,
0916 search_keywords BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
0917 search_authors BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL
0918 );;
0919
0920 ALTER TABLE phpbb_search_results ADD PRIMARY KEY (search_key);;
0921
0922
0923 # Table: 'phpbb_search_wordlist'
0924 CREATE TABLE phpbb_search_wordlist (
0925 word_id INTEGER NOT NULL,
0926 word_text VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0927 word_common INTEGER DEFAULT 0 NOT NULL,
0928 word_count INTEGER DEFAULT 0 NOT NULL
0929 );;
0930
0931 ALTER TABLE phpbb_search_wordlist ADD PRIMARY KEY (word_id);;
0932
0933 CREATE UNIQUE INDEX phpbb_search_wordlist_wrd_txt ON phpbb_search_wordlist(word_text);;
0934 CREATE INDEX phpbb_search_wordlist_wrd_cnt ON phpbb_search_wordlist(word_count);;
0935
0936 CREATE GENERATOR phpbb_search_wordlist_gen;;
0937 SET GENERATOR phpbb_search_wordlist_gen TO 0;;
0938
0939 CREATE TRIGGER t_phpbb_search_wordlist FOR phpbb_search_wordlist
0940 BEFORE INSERT
0941 AS
0942 BEGIN
0943 NEW.word_id = GEN_ID(phpbb_search_wordlist_gen, 1);
0944 END;;
0945
0946
0947 # Table: 'phpbb_search_wordmatch'
0948 CREATE TABLE phpbb_search_wordmatch (
0949 post_id INTEGER DEFAULT 0 NOT NULL,
0950 word_id INTEGER DEFAULT 0 NOT NULL,
0951 title_match INTEGER DEFAULT 0 NOT NULL
0952 );;
0953
0954 CREATE UNIQUE INDEX phpbb_search_wordmatch_unq_mtch ON phpbb_search_wordmatch(word_id, post_id, title_match);;
0955 CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch(word_id);;
0956 CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch(post_id);;
0957
0958 # Table: 'phpbb_sessions'
0959 CREATE TABLE phpbb_sessions (
0960 session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
0961 session_user_id INTEGER DEFAULT 0 NOT NULL,
0962 session_last_visit INTEGER DEFAULT 0 NOT NULL,
0963 session_start INTEGER DEFAULT 0 NOT NULL,
0964 session_time INTEGER DEFAULT 0 NOT NULL,
0965 session_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
0966 session_browser VARCHAR(150) CHARACTER SET NONE DEFAULT '' NOT NULL,
0967 session_forwarded_for VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0968 session_page VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
0969 session_viewonline INTEGER DEFAULT 1 NOT NULL,
0970 session_autologin INTEGER DEFAULT 0 NOT NULL,
0971 session_admin INTEGER DEFAULT 0 NOT NULL
0972 );;
0973
0974 ALTER TABLE phpbb_sessions ADD PRIMARY KEY (session_id);;
0975
0976 CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions(session_time);;
0977 CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions(session_user_id);;
0978
0979 # Table: 'phpbb_sessions_keys'
0980 CREATE TABLE phpbb_sessions_keys (
0981 key_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
0982 user_id INTEGER DEFAULT 0 NOT NULL,
0983 last_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
0984 last_login INTEGER DEFAULT 0 NOT NULL
0985 );;
0986
0987 ALTER TABLE phpbb_sessions_keys ADD PRIMARY KEY (key_id, user_id);;
0988
0989 CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys(last_login);;
0990
0991 # Table: 'phpbb_sitelist'
0992 CREATE TABLE phpbb_sitelist (
0993 site_id INTEGER NOT NULL,
0994 site_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
0995 site_hostname VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
0996 ip_exclude INTEGER DEFAULT 0 NOT NULL
0997 );;
0998
0999 ALTER TABLE phpbb_sitelist ADD PRIMARY KEY (site_id);;
1000
1001
1002 CREATE GENERATOR phpbb_sitelist_gen;;
1003 SET GENERATOR phpbb_sitelist_gen TO 0;;
1004
1005 CREATE TRIGGER t_phpbb_sitelist FOR phpbb_sitelist
1006 BEFORE INSERT
1007 AS
1008 BEGIN
1009 NEW.site_id = GEN_ID(phpbb_sitelist_gen, 1);
1010 END;;
1011
1012
1013 # Table: 'phpbb_smilies'
1014 CREATE TABLE phpbb_smilies (
1015 smiley_id INTEGER NOT NULL,
1016 code VARCHAR(50) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1017 emotion VARCHAR(50) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1018 smiley_url VARCHAR(50) CHARACTER SET NONE DEFAULT '' NOT NULL,
1019 smiley_width INTEGER DEFAULT 0 NOT NULL,
1020 smiley_height INTEGER DEFAULT 0 NOT NULL,
1021 smiley_order INTEGER DEFAULT 0 NOT NULL,
1022 display_on_posting INTEGER DEFAULT 1 NOT NULL
1023 );;
1024
1025 ALTER TABLE phpbb_smilies ADD PRIMARY KEY (smiley_id);;
1026
1027 CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies(display_on_posting);;
1028
1029 CREATE GENERATOR phpbb_smilies_gen;;
1030 SET GENERATOR phpbb_smilies_gen TO 0;;
1031
1032 CREATE TRIGGER t_phpbb_smilies FOR phpbb_smilies
1033 BEFORE INSERT
1034 AS
1035 BEGIN
1036 NEW.smiley_id = GEN_ID(phpbb_smilies_gen, 1);
1037 END;;
1038
1039
1040 # Table: 'phpbb_styles'
1041 CREATE TABLE phpbb_styles (
1042 style_id INTEGER NOT NULL,
1043 style_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1044 style_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1045 style_active INTEGER DEFAULT 1 NOT NULL,
1046 template_id INTEGER DEFAULT 0 NOT NULL,
1047 theme_id INTEGER DEFAULT 0 NOT NULL,
1048 imageset_id INTEGER DEFAULT 0 NOT NULL
1049 );;
1050
1051 ALTER TABLE phpbb_styles ADD PRIMARY KEY (style_id);;
1052
1053 CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles(style_name);;
1054 CREATE INDEX phpbb_styles_template_id ON phpbb_styles(template_id);;
1055 CREATE INDEX phpbb_styles_theme_id ON phpbb_styles(theme_id);;
1056 CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles(imageset_id);;
1057
1058 CREATE GENERATOR phpbb_styles_gen;;
1059 SET GENERATOR phpbb_styles_gen TO 0;;
1060
1061 CREATE TRIGGER t_phpbb_styles FOR phpbb_styles
1062 BEFORE INSERT
1063 AS
1064 BEGIN
1065 NEW.style_id = GEN_ID(phpbb_styles_gen, 1);
1066 END;;
1067
1068
1069 # Table: 'phpbb_styles_template'
1070 CREATE TABLE phpbb_styles_template (
1071 template_id INTEGER NOT NULL,
1072 template_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1073 template_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1074 template_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
1075 bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT 'kNg=' NOT NULL,
1076 template_storedb INTEGER DEFAULT 0 NOT NULL
1077 );;
1078
1079 ALTER TABLE phpbb_styles_template ADD PRIMARY KEY (template_id);;
1080
1081 CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template(template_name);;
1082
1083 CREATE GENERATOR phpbb_styles_template_gen;;
1084 SET GENERATOR phpbb_styles_template_gen TO 0;;
1085
1086 CREATE TRIGGER t_phpbb_styles_template FOR phpbb_styles_template
1087 BEFORE INSERT
1088 AS
1089 BEGIN
1090 NEW.template_id = GEN_ID(phpbb_styles_template_gen, 1);
1091 END;;
1092
1093
1094 # Table: 'phpbb_styles_template_data'
1095 CREATE TABLE phpbb_styles_template_data (
1096 template_id INTEGER DEFAULT 0 NOT NULL,
1097 template_filename VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
1098 template_included BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
1099 template_mtime INTEGER DEFAULT 0 NOT NULL,
1100 template_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
1101 );;
1102
1103 CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data(template_id);;
1104 CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data(template_filename);;
1105
1106 # Table: 'phpbb_styles_theme'
1107 CREATE TABLE phpbb_styles_theme (
1108 theme_id INTEGER NOT NULL,
1109 theme_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1110 theme_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1111 theme_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
1112 theme_storedb INTEGER DEFAULT 0 NOT NULL,
1113 theme_mtime INTEGER DEFAULT 0 NOT NULL,
1114 theme_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
1115 );;
1116
1117 ALTER TABLE phpbb_styles_theme ADD PRIMARY KEY (theme_id);;
1118
1119 CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme(theme_name);;
1120
1121 CREATE GENERATOR phpbb_styles_theme_gen;;
1122 SET GENERATOR phpbb_styles_theme_gen TO 0;;
1123
1124 CREATE TRIGGER t_phpbb_styles_theme FOR phpbb_styles_theme
1125 BEFORE INSERT
1126 AS
1127 BEGIN
1128 NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1);
1129 END;;
1130
1131
1132 # Table: 'phpbb_styles_imageset'
1133 CREATE TABLE phpbb_styles_imageset (
1134 imageset_id INTEGER NOT NULL,
1135 imageset_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1136 imageset_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1137 imageset_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL
1138 );;
1139
1140 ALTER TABLE phpbb_styles_imageset ADD PRIMARY KEY (imageset_id);;
1141
1142 CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset(imageset_name);;
1143
1144 CREATE GENERATOR phpbb_styles_imageset_gen;;
1145 SET GENERATOR phpbb_styles_imageset_gen TO 0;;
1146
1147 CREATE TRIGGER t_phpbb_styles_imageset FOR phpbb_styles_imageset
1148 BEFORE INSERT
1149 AS
1150 BEGIN
1151 NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);
1152 END;;
1153
1154
1155 # Table: 'phpbb_styles_imageset_data'
1156 CREATE TABLE phpbb_styles_imageset_data (
1157 image_id INTEGER NOT NULL,
1158 image_name VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,
1159 image_filename VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,
1160 image_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
1161 image_height INTEGER DEFAULT 0 NOT NULL,
1162 image_width INTEGER DEFAULT 0 NOT NULL,
1163 imageset_id INTEGER DEFAULT 0 NOT NULL
1164 );;
1165
1166 ALTER TABLE phpbb_styles_imageset_data ADD PRIMARY KEY (image_id);;
1167
1168 CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data(imageset_id);;
1169
1170 CREATE GENERATOR phpbb_styles_imageset_data_gen;;
1171 SET GENERATOR phpbb_styles_imageset_data_gen TO 0;;
1172
1173 CREATE TRIGGER t_phpbb_styles_imageset_data FOR phpbb_styles_imageset_data
1174 BEFORE INSERT
1175 AS
1176 BEGIN
1177 NEW.image_id = GEN_ID(phpbb_styles_imageset_data_gen, 1);
1178 END;;
1179
1180
1181 # Table: 'phpbb_topics'
1182 CREATE TABLE phpbb_topics (
1183 topic_id INTEGER NOT NULL,
1184 forum_id INTEGER DEFAULT 0 NOT NULL,
1185 icon_id INTEGER DEFAULT 0 NOT NULL,
1186 topic_attachment INTEGER DEFAULT 0 NOT NULL,
1187 topic_approved INTEGER DEFAULT 1 NOT NULL,
1188 topic_reported INTEGER DEFAULT 0 NOT NULL,
1189 topic_title VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1190 topic_poster INTEGER DEFAULT 0 NOT NULL,
1191 topic_time INTEGER DEFAULT 0 NOT NULL,
1192 topic_time_limit INTEGER DEFAULT 0 NOT NULL,
1193 topic_views INTEGER DEFAULT 0 NOT NULL,
1194 topic_replies INTEGER DEFAULT 0 NOT NULL,
1195 topic_replies_real INTEGER DEFAULT 0 NOT NULL,
1196 topic_status INTEGER DEFAULT 0 NOT NULL,
1197 topic_type INTEGER DEFAULT 0 NOT NULL,
1198 topic_first_post_id INTEGER DEFAULT 0 NOT NULL,
1199 topic_first_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1200 topic_first_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
1201 topic_last_post_id INTEGER DEFAULT 0 NOT NULL,
1202 topic_last_poster_id INTEGER DEFAULT 0 NOT NULL,
1203 topic_last_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1204 topic_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
1205 topic_last_post_subject VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1206 topic_last_post_time INTEGER DEFAULT 0 NOT NULL,
1207 topic_last_view_time INTEGER DEFAULT 0 NOT NULL,
1208 topic_moved_id INTEGER DEFAULT 0 NOT NULL,
1209 topic_bumped INTEGER DEFAULT 0 NOT NULL,
1210 topic_bumper INTEGER DEFAULT 0 NOT NULL,
1211 poll_title VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1212 poll_start INTEGER DEFAULT 0 NOT NULL,
1213 poll_length INTEGER DEFAULT 0 NOT NULL,
1214 poll_max_options INTEGER DEFAULT 1 NOT NULL,
1215 poll_last_vote INTEGER DEFAULT 0 NOT NULL,
1216 poll_vote_change INTEGER DEFAULT 0 NOT NULL
1217 );;
1218
1219 ALTER TABLE phpbb_topics ADD PRIMARY KEY (topic_id);;
1220
1221 CREATE INDEX phpbb_topics_forum_id ON phpbb_topics(forum_id);;
1222 CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics(forum_id, topic_type);;
1223 CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics(topic_last_post_time);;
1224 CREATE INDEX phpbb_topics_topic_approved ON phpbb_topics(topic_approved);;
1225 CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics(forum_id, topic_approved, topic_last_post_id);;
1226 CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics(forum_id, topic_last_post_time, topic_moved_id);;
1227
1228 CREATE GENERATOR phpbb_topics_gen;;
1229 SET GENERATOR phpbb_topics_gen TO 0;;
1230
1231 CREATE TRIGGER t_phpbb_topics FOR phpbb_topics
1232 BEFORE INSERT
1233 AS
1234 BEGIN
1235 NEW.topic_id = GEN_ID(phpbb_topics_gen, 1);
1236 END;;
1237
1238
1239 # Table: 'phpbb_topics_track'
1240 CREATE TABLE phpbb_topics_track (
1241 user_id INTEGER DEFAULT 0 NOT NULL,
1242 topic_id INTEGER DEFAULT 0 NOT NULL,
1243 forum_id INTEGER DEFAULT 0 NOT NULL,
1244 mark_time INTEGER DEFAULT 0 NOT NULL
1245 );;
1246
1247 ALTER TABLE phpbb_topics_track ADD PRIMARY KEY (user_id, topic_id);;
1248
1249 CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track(forum_id);;
1250
1251 # Table: 'phpbb_topics_posted'
1252 CREATE TABLE phpbb_topics_posted (
1253 user_id INTEGER DEFAULT 0 NOT NULL,
1254 topic_id INTEGER DEFAULT 0 NOT NULL,
1255 topic_posted INTEGER DEFAULT 0 NOT NULL
1256 );;
1257
1258 ALTER TABLE phpbb_topics_posted ADD PRIMARY KEY (user_id, topic_id);;
1259
1260
1261 # Table: 'phpbb_topics_watch'
1262 CREATE TABLE phpbb_topics_watch (
1263 topic_id INTEGER DEFAULT 0 NOT NULL,
1264 user_id INTEGER DEFAULT 0 NOT NULL,
1265 notify_status INTEGER DEFAULT 0 NOT NULL
1266 );;
1267
1268 CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch(topic_id);;
1269 CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch(user_id);;
1270 CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch(notify_status);;
1271
1272 # Table: 'phpbb_user_group'
1273 CREATE TABLE phpbb_user_group (
1274 group_id INTEGER DEFAULT 0 NOT NULL,
1275 user_id INTEGER DEFAULT 0 NOT NULL,
1276 group_leader INTEGER DEFAULT 0 NOT NULL,
1277 user_pending INTEGER DEFAULT 1 NOT NULL
1278 );;
1279
1280 CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group(group_id);;
1281 CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group(user_id);;
1282 CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group(group_leader);;
1283
1284 # Table: 'phpbb_users'
1285 CREATE TABLE phpbb_users (
1286 user_id INTEGER NOT NULL,
1287 user_type INTEGER DEFAULT 0 NOT NULL,
1288 group_id INTEGER DEFAULT 3 NOT NULL,
1289 user_permissions BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
1290 user_perm_from INTEGER DEFAULT 0 NOT NULL,
1291 user_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
1292 user_regdate INTEGER DEFAULT 0 NOT NULL,
1293 username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1294 username_clean VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1295 user_password VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1296 user_passchg INTEGER DEFAULT 0 NOT NULL,
1297 user_pass_convert INTEGER DEFAULT 0 NOT NULL,
1298 user_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1299 user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,
1300 user_birthday VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
1301 user_lastvisit INTEGER DEFAULT 0 NOT NULL,
1302 user_lastmark INTEGER DEFAULT 0 NOT NULL,
1303 user_lastpost_time INTEGER DEFAULT 0 NOT NULL,
1304 user_lastpage VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1305 user_last_confirm_key VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
1306 user_last_search INTEGER DEFAULT 0 NOT NULL,
1307 user_warnings INTEGER DEFAULT 0 NOT NULL,
1308 user_last_warning INTEGER DEFAULT 0 NOT NULL,
1309 user_login_attempts INTEGER DEFAULT 0 NOT NULL,
1310 user_inactive_reason INTEGER DEFAULT 0 NOT NULL,
1311 user_inactive_time INTEGER DEFAULT 0 NOT NULL,
1312 user_posts INTEGER DEFAULT 0 NOT NULL,
1313 user_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
1314 user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,
1315 user_dst INTEGER DEFAULT 0 NOT NULL,
1316 user_dateformat VARCHAR(30) CHARACTER SET UTF8 DEFAULT 'd M Y H:i' NOT NULL COLLATE UNICODE,
1317 user_style INTEGER DEFAULT 0 NOT NULL,
1318 user_rank INTEGER DEFAULT 0 NOT NULL,
1319 user_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
1320 user_new_privmsg INTEGER DEFAULT 0 NOT NULL,
1321 user_unread_privmsg INTEGER DEFAULT 0 NOT NULL,
1322 user_last_privmsg INTEGER DEFAULT 0 NOT NULL,
1323 user_message_rules INTEGER DEFAULT 0 NOT NULL,
1324 user_full_folder INTEGER DEFAULT -3 NOT NULL,
1325 user_emailtime INTEGER DEFAULT 0 NOT NULL,
1326 user_topic_show_days INTEGER DEFAULT 0 NOT NULL,
1327 user_topic_sortby_type VARCHAR(1) CHARACTER SET NONE DEFAULT 't' NOT NULL,
1328 user_topic_sortby_dir VARCHAR(1) CHARACTER SET NONE DEFAULT 'd' NOT NULL,
1329 user_post_show_days INTEGER DEFAULT 0 NOT NULL,
1330 user_post_sortby_type VARCHAR(1) CHARACTER SET NONE DEFAULT 't' NOT NULL,
1331 user_post_sortby_dir VARCHAR(1) CHARACTER SET NONE DEFAULT 'a' NOT NULL,
1332 user_notify INTEGER DEFAULT 0 NOT NULL,
1333 user_notify_pm INTEGER DEFAULT 1 NOT NULL,
1334 user_notify_type INTEGER DEFAULT 0 NOT NULL,
1335 user_allow_pm INTEGER DEFAULT 1 NOT NULL,
1336 user_allow_viewonline INTEGER DEFAULT 1 NOT NULL,
1337 user_allow_viewemail INTEGER DEFAULT 1 NOT NULL,
1338 user_allow_massemail INTEGER DEFAULT 1 NOT NULL,
1339 user_options INTEGER DEFAULT 895 NOT NULL,
1340 user_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
1341 user_avatar_type INTEGER DEFAULT 0 NOT NULL,
1342 user_avatar_width INTEGER DEFAULT 0 NOT NULL,
1343 user_avatar_height INTEGER DEFAULT 0 NOT NULL,
1344 user_sig BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
1345 user_sig_bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
1346 user_sig_bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
1347 user_from VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1348 user_icq VARCHAR(15) CHARACTER SET NONE DEFAULT '' NOT NULL,
1349 user_aim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1350 user_yim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1351 user_msnm VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1352 user_jabber VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1353 user_website VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1354 user_occ BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
1355 user_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
1356 user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
1357 user_newpasswd VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1358 user_form_salt VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
1359 );;
1360
1361 ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);;
1362
1363 CREATE INDEX phpbb_users_user_birthday ON phpbb_users(user_birthday);;
1364 CREATE INDEX phpbb_users_user_email_hash ON phpbb_users(user_email_hash);;
1365 CREATE INDEX phpbb_users_user_type ON phpbb_users(user_type);;
1366 CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users(username_clean);;
1367
1368 CREATE GENERATOR phpbb_users_gen;;
1369 SET GENERATOR phpbb_users_gen TO 0;;
1370
1371 CREATE TRIGGER t_phpbb_users FOR phpbb_users
1372 BEFORE INSERT
1373 AS
1374 BEGIN
1375 NEW.user_id = GEN_ID(phpbb_users_gen, 1);
1376 END;;
1377
1378
1379 # Table: 'phpbb_warnings'
1380 CREATE TABLE phpbb_warnings (
1381 warning_id INTEGER NOT NULL,
1382 user_id INTEGER DEFAULT 0 NOT NULL,
1383 post_id INTEGER DEFAULT 0 NOT NULL,
1384 log_id INTEGER DEFAULT 0 NOT NULL,
1385 warning_time INTEGER DEFAULT 0 NOT NULL
1386 );;
1387
1388 ALTER TABLE phpbb_warnings ADD PRIMARY KEY (warning_id);;
1389
1390
1391 CREATE GENERATOR phpbb_warnings_gen;;
1392 SET GENERATOR phpbb_warnings_gen TO 0;;
1393
1394 CREATE TRIGGER t_phpbb_warnings FOR phpbb_warnings
1395 BEFORE INSERT
1396 AS
1397 BEGIN
1398 NEW.warning_id = GEN_ID(phpbb_warnings_gen, 1);
1399 END;;
1400
1401
1402 # Table: 'phpbb_words'
1403 CREATE TABLE phpbb_words (
1404 word_id INTEGER NOT NULL,
1405 word VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1406 replacement VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
1407 );;
1408
1409 ALTER TABLE phpbb_words ADD PRIMARY KEY (word_id);;
1410
1411
1412 CREATE GENERATOR phpbb_words_gen;;
1413 SET GENERATOR phpbb_words_gen TO 0;;
1414
1415 CREATE TRIGGER t_phpbb_words FOR phpbb_words
1416 BEFORE INSERT
1417 AS
1418 BEGIN
1419 NEW.word_id = GEN_ID(phpbb_words_gen, 1);
1420 END;;
1421
1422
1423 # Table: 'phpbb_zebra'
1424 CREATE TABLE phpbb_zebra (
1425 user_id INTEGER DEFAULT 0 NOT NULL,
1426 zebra_id INTEGER DEFAULT 0 NOT NULL,
1427 friend INTEGER DEFAULT 0 NOT NULL,
1428 foe INTEGER DEFAULT 0 NOT NULL
1429 );;
1430
1431 ALTER TABLE phpbb_zebra ADD PRIMARY KEY (user_id, zebra_id);;
1432
1433
1434