Verzeichnisstruktur phpBB-3.1.0
- Veröffentlicht
- 27.10.2014
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 |
schema.json
0001 {
0002 "phpbb_acl_groups": {
0003 "COLUMNS": {
0004 "group_id": [
0005 "UINT",
0006 0
0007 ],
0008 "forum_id": [
0009 "UINT",
0010 0
0011 ],
0012 "auth_option_id": [
0013 "UINT",
0014 0
0015 ],
0016 "auth_role_id": [
0017 "UINT",
0018 0
0019 ],
0020 "auth_setting": [
0021 "TINT:2",
0022 0
0023 ]
0024 },
0025 "KEYS": {
0026 "group_id": [
0027 "INDEX",
0028 "group_id"
0029 ],
0030 "auth_opt_id": [
0031 "INDEX",
0032 "auth_option_id"
0033 ],
0034 "auth_role_id": [
0035 "INDEX",
0036 "auth_role_id"
0037 ]
0038 }
0039 },
0040 "phpbb_acl_options": {
0041 "COLUMNS": {
0042 "auth_option_id": [
0043 "UINT",
0044 null,
0045 "auto_increment"
0046 ],
0047 "auth_option": [
0048 "VCHAR:50",
0049 ""
0050 ],
0051 "is_global": [
0052 "BOOL",
0053 0
0054 ],
0055 "is_local": [
0056 "BOOL",
0057 0
0058 ],
0059 "founder_only": [
0060 "BOOL",
0061 0
0062 ]
0063 },
0064 "PRIMARY_KEY": "auth_option_id",
0065 "KEYS": {
0066 "auth_option": [
0067 "UNIQUE",
0068 [
0069 "auth_option"
0070 ]
0071 ]
0072 }
0073 },
0074 "phpbb_acl_roles": {
0075 "COLUMNS": {
0076 "role_id": [
0077 "UINT",
0078 null,
0079 "auto_increment"
0080 ],
0081 "role_name": [
0082 "VCHAR_UNI",
0083 ""
0084 ],
0085 "role_description": [
0086 "TEXT_UNI",
0087 ""
0088 ],
0089 "role_type": [
0090 "VCHAR:10",
0091 ""
0092 ],
0093 "role_order": [
0094 "USINT",
0095 0
0096 ]
0097 },
0098 "PRIMARY_KEY": "role_id",
0099 "KEYS": {
0100 "role_type": [
0101 "INDEX",
0102 "role_type"
0103 ],
0104 "role_order": [
0105 "INDEX",
0106 "role_order"
0107 ]
0108 }
0109 },
0110 "phpbb_acl_roles_data": {
0111 "COLUMNS": {
0112 "role_id": [
0113 "UINT",
0114 0
0115 ],
0116 "auth_option_id": [
0117 "UINT",
0118 0
0119 ],
0120 "auth_setting": [
0121 "TINT:2",
0122 0
0123 ]
0124 },
0125 "PRIMARY_KEY": [
0126 "role_id",
0127 "auth_option_id"
0128 ],
0129 "KEYS": {
0130 "ath_op_id": [
0131 "INDEX",
0132 "auth_option_id"
0133 ]
0134 }
0135 },
0136 "phpbb_acl_users": {
0137 "COLUMNS": {
0138 "user_id": [
0139 "UINT",
0140 0
0141 ],
0142 "forum_id": [
0143 "UINT",
0144 0
0145 ],
0146 "auth_option_id": [
0147 "UINT",
0148 0
0149 ],
0150 "auth_role_id": [
0151 "UINT",
0152 0
0153 ],
0154 "auth_setting": [
0155 "TINT:2",
0156 0
0157 ]
0158 },
0159 "KEYS": {
0160 "user_id": [
0161 "INDEX",
0162 "user_id"
0163 ],
0164 "auth_option_id": [
0165 "INDEX",
0166 "auth_option_id"
0167 ],
0168 "auth_role_id": [
0169 "INDEX",
0170 "auth_role_id"
0171 ]
0172 }
0173 },
0174 "phpbb_attachments": {
0175 "COLUMNS": {
0176 "attach_id": [
0177 "UINT",
0178 null,
0179 "auto_increment"
0180 ],
0181 "post_msg_id": [
0182 "UINT",
0183 0
0184 ],
0185 "topic_id": [
0186 "UINT",
0187 0
0188 ],
0189 "in_message": [
0190 "BOOL",
0191 0
0192 ],
0193 "poster_id": [
0194 "UINT",
0195 0
0196 ],
0197 "is_orphan": [
0198 "BOOL",
0199 1
0200 ],
0201 "physical_filename": [
0202 "VCHAR",
0203 ""
0204 ],
0205 "real_filename": [
0206 "VCHAR",
0207 ""
0208 ],
0209 "download_count": [
0210 "UINT",
0211 0
0212 ],
0213 "attach_comment": [
0214 "TEXT_UNI",
0215 ""
0216 ],
0217 "extension": [
0218 "VCHAR:100",
0219 ""
0220 ],
0221 "mimetype": [
0222 "VCHAR:100",
0223 ""
0224 ],
0225 "filesize": [
0226 "UINT:20",
0227 0
0228 ],
0229 "filetime": [
0230 "TIMESTAMP",
0231 0
0232 ],
0233 "thumbnail": [
0234 "BOOL",
0235 0
0236 ]
0237 },
0238 "PRIMARY_KEY": "attach_id",
0239 "KEYS": {
0240 "filetime": [
0241 "INDEX",
0242 "filetime"
0243 ],
0244 "post_msg_id": [
0245 "INDEX",
0246 "post_msg_id"
0247 ],
0248 "topic_id": [
0249 "INDEX",
0250 "topic_id"
0251 ],
0252 "poster_id": [
0253 "INDEX",
0254 "poster_id"
0255 ],
0256 "is_orphan": [
0257 "INDEX",
0258 "is_orphan"
0259 ]
0260 }
0261 },
0262 "phpbb_banlist": {
0263 "COLUMNS": {
0264 "ban_id": [
0265 "UINT",
0266 null,
0267 "auto_increment"
0268 ],
0269 "ban_userid": [
0270 "UINT",
0271 0
0272 ],
0273 "ban_ip": [
0274 "VCHAR:40",
0275 ""
0276 ],
0277 "ban_email": [
0278 "VCHAR_UNI:100",
0279 ""
0280 ],
0281 "ban_start": [
0282 "TIMESTAMP",
0283 0
0284 ],
0285 "ban_end": [
0286 "TIMESTAMP",
0287 0
0288 ],
0289 "ban_exclude": [
0290 "BOOL",
0291 0
0292 ],
0293 "ban_reason": [
0294 "VCHAR_UNI",
0295 ""
0296 ],
0297 "ban_give_reason": [
0298 "VCHAR_UNI",
0299 ""
0300 ]
0301 },
0302 "PRIMARY_KEY": "ban_id",
0303 "KEYS": {
0304 "ban_end": [
0305 "INDEX",
0306 "ban_end"
0307 ],
0308 "ban_user": [
0309 "INDEX",
0310 [
0311 "ban_userid",
0312 "ban_exclude"
0313 ]
0314 ],
0315 "ban_email": [
0316 "INDEX",
0317 [
0318 "ban_email",
0319 "ban_exclude"
0320 ]
0321 ],
0322 "ban_ip": [
0323 "INDEX",
0324 [
0325 "ban_ip",
0326 "ban_exclude"
0327 ]
0328 ]
0329 }
0330 },
0331 "phpbb_bbcodes": {
0332 "COLUMNS": {
0333 "bbcode_id": [
0334 "USINT",
0335 0
0336 ],
0337 "bbcode_tag": [
0338 "VCHAR:16",
0339 ""
0340 ],
0341 "bbcode_helpline": [
0342 "VCHAR_UNI",
0343 ""
0344 ],
0345 "display_on_posting": [
0346 "BOOL",
0347 0
0348 ],
0349 "bbcode_match": [
0350 "TEXT_UNI",
0351 ""
0352 ],
0353 "bbcode_tpl": [
0354 "MTEXT_UNI",
0355 ""
0356 ],
0357 "first_pass_match": [
0358 "MTEXT_UNI",
0359 ""
0360 ],
0361 "first_pass_replace": [
0362 "MTEXT_UNI",
0363 ""
0364 ],
0365 "second_pass_match": [
0366 "MTEXT_UNI",
0367 ""
0368 ],
0369 "second_pass_replace": [
0370 "MTEXT_UNI",
0371 ""
0372 ]
0373 },
0374 "PRIMARY_KEY": "bbcode_id",
0375 "KEYS": {
0376 "display_on_post": [
0377 "INDEX",
0378 "display_on_posting"
0379 ]
0380 }
0381 },
0382 "phpbb_bookmarks": {
0383 "COLUMNS": {
0384 "topic_id": [
0385 "UINT",
0386 0
0387 ],
0388 "user_id": [
0389 "UINT",
0390 0
0391 ]
0392 },
0393 "PRIMARY_KEY": [
0394 "topic_id",
0395 "user_id"
0396 ]
0397 },
0398 "phpbb_bots": {
0399 "COLUMNS": {
0400 "bot_id": [
0401 "UINT",
0402 null,
0403 "auto_increment"
0404 ],
0405 "bot_active": [
0406 "BOOL",
0407 1
0408 ],
0409 "bot_name": [
0410 "STEXT_UNI",
0411 ""
0412 ],
0413 "user_id": [
0414 "UINT",
0415 0
0416 ],
0417 "bot_agent": [
0418 "VCHAR",
0419 ""
0420 ],
0421 "bot_ip": [
0422 "VCHAR",
0423 ""
0424 ]
0425 },
0426 "PRIMARY_KEY": "bot_id",
0427 "KEYS": {
0428 "bot_active": [
0429 "INDEX",
0430 "bot_active"
0431 ]
0432 }
0433 },
0434 "phpbb_config": {
0435 "COLUMNS": {
0436 "config_name": [
0437 "VCHAR",
0438 ""
0439 ],
0440 "config_value": [
0441 "VCHAR_UNI",
0442 ""
0443 ],
0444 "is_dynamic": [
0445 "BOOL",
0446 0
0447 ]
0448 },
0449 "PRIMARY_KEY": "config_name",
0450 "KEYS": {
0451 "is_dynamic": [
0452 "INDEX",
0453 "is_dynamic"
0454 ]
0455 }
0456 },
0457 "phpbb_config_text": {
0458 "COLUMNS": {
0459 "config_name": [
0460 "VCHAR",
0461 ""
0462 ],
0463 "config_value": [
0464 "MTEXT",
0465 ""
0466 ]
0467 },
0468 "PRIMARY_KEY": "config_name"
0469 },
0470 "phpbb_confirm": {
0471 "COLUMNS": {
0472 "confirm_id": [
0473 "CHAR:32",
0474 ""
0475 ],
0476 "session_id": [
0477 "CHAR:32",
0478 ""
0479 ],
0480 "confirm_type": [
0481 "TINT:3",
0482 0
0483 ],
0484 "code": [
0485 "VCHAR:8",
0486 ""
0487 ],
0488 "seed": [
0489 "UINT:10",
0490 0
0491 ],
0492 "attempts": [
0493 "UINT",
0494 0
0495 ]
0496 },
0497 "PRIMARY_KEY": [
0498 "session_id",
0499 "confirm_id"
0500 ],
0501 "KEYS": {
0502 "confirm_type": [
0503 "INDEX",
0504 "confirm_type"
0505 ]
0506 }
0507 },
0508 "phpbb_disallow": {
0509 "COLUMNS": {
0510 "disallow_id": [
0511 "UINT",
0512 null,
0513 "auto_increment"
0514 ],
0515 "disallow_username": [
0516 "VCHAR_UNI:255",
0517 ""
0518 ]
0519 },
0520 "PRIMARY_KEY": "disallow_id"
0521 },
0522 "phpbb_drafts": {
0523 "COLUMNS": {
0524 "draft_id": [
0525 "UINT",
0526 null,
0527 "auto_increment"
0528 ],
0529 "user_id": [
0530 "UINT",
0531 0
0532 ],
0533 "topic_id": [
0534 "UINT",
0535 0
0536 ],
0537 "forum_id": [
0538 "UINT",
0539 0
0540 ],
0541 "save_time": [
0542 "TIMESTAMP",
0543 0
0544 ],
0545 "draft_subject": [
0546 "STEXT_UNI",
0547 ""
0548 ],
0549 "draft_message": [
0550 "MTEXT_UNI",
0551 ""
0552 ]
0553 },
0554 "PRIMARY_KEY": "draft_id",
0555 "KEYS": {
0556 "save_time": [
0557 "INDEX",
0558 "save_time"
0559 ]
0560 }
0561 },
0562 "phpbb_ext": {
0563 "COLUMNS": {
0564 "ext_name": [
0565 "VCHAR",
0566 ""
0567 ],
0568 "ext_active": [
0569 "BOOL",
0570 0
0571 ],
0572 "ext_state": [
0573 "TEXT",
0574 ""
0575 ]
0576 },
0577 "KEYS": {
0578 "ext_name": [
0579 "UNIQUE",
0580 "ext_name"
0581 ]
0582 }
0583 },
0584 "phpbb_extension_groups": {
0585 "COLUMNS": {
0586 "group_id": [
0587 "UINT",
0588 null,
0589 "auto_increment"
0590 ],
0591 "group_name": [
0592 "VCHAR_UNI",
0593 ""
0594 ],
0595 "cat_id": [
0596 "TINT:2",
0597 0
0598 ],
0599 "allow_group": [
0600 "BOOL",
0601 0
0602 ],
0603 "download_mode": [
0604 "BOOL",
0605 1
0606 ],
0607 "upload_icon": [
0608 "VCHAR",
0609 ""
0610 ],
0611 "max_filesize": [
0612 "UINT:20",
0613 0
0614 ],
0615 "allowed_forums": [
0616 "TEXT",
0617 ""
0618 ],
0619 "allow_in_pm": [
0620 "BOOL",
0621 0
0622 ]
0623 },
0624 "PRIMARY_KEY": "group_id"
0625 },
0626 "phpbb_extensions": {
0627 "COLUMNS": {
0628 "extension_id": [
0629 "UINT",
0630 null,
0631 "auto_increment"
0632 ],
0633 "group_id": [
0634 "UINT",
0635 0
0636 ],
0637 "extension": [
0638 "VCHAR:100",
0639 ""
0640 ]
0641 },
0642 "PRIMARY_KEY": "extension_id"
0643 },
0644 "phpbb_forums": {
0645 "COLUMNS": {
0646 "forum_id": [
0647 "UINT",
0648 null,
0649 "auto_increment"
0650 ],
0651 "parent_id": [
0652 "UINT",
0653 0
0654 ],
0655 "left_id": [
0656 "UINT",
0657 0
0658 ],
0659 "right_id": [
0660 "UINT",
0661 0
0662 ],
0663 "forum_parents": [
0664 "MTEXT",
0665 ""
0666 ],
0667 "forum_name": [
0668 "STEXT_UNI",
0669 ""
0670 ],
0671 "forum_desc": [
0672 "TEXT_UNI",
0673 ""
0674 ],
0675 "forum_desc_bitfield": [
0676 "VCHAR:255",
0677 ""
0678 ],
0679 "forum_desc_options": [
0680 "UINT:11",
0681 7
0682 ],
0683 "forum_desc_uid": [
0684 "VCHAR:8",
0685 ""
0686 ],
0687 "forum_link": [
0688 "VCHAR_UNI",
0689 ""
0690 ],
0691 "forum_password": [
0692 "VCHAR:255",
0693 ""
0694 ],
0695 "forum_style": [
0696 "UINT",
0697 0
0698 ],
0699 "forum_image": [
0700 "VCHAR",
0701 ""
0702 ],
0703 "forum_rules": [
0704 "TEXT_UNI",
0705 ""
0706 ],
0707 "forum_rules_link": [
0708 "VCHAR_UNI",
0709 ""
0710 ],
0711 "forum_rules_bitfield": [
0712 "VCHAR:255",
0713 ""
0714 ],
0715 "forum_rules_options": [
0716 "UINT:11",
0717 7
0718 ],
0719 "forum_rules_uid": [
0720 "VCHAR:8",
0721 ""
0722 ],
0723 "forum_topics_per_page": [
0724 "TINT:4",
0725 0
0726 ],
0727 "forum_type": [
0728 "TINT:4",
0729 0
0730 ],
0731 "forum_status": [
0732 "TINT:4",
0733 0
0734 ],
0735 "forum_last_post_id": [
0736 "UINT",
0737 0
0738 ],
0739 "forum_last_poster_id": [
0740 "UINT",
0741 0
0742 ],
0743 "forum_last_post_subject": [
0744 "STEXT_UNI",
0745 ""
0746 ],
0747 "forum_last_post_time": [
0748 "TIMESTAMP",
0749 0
0750 ],
0751 "forum_last_poster_name": [
0752 "VCHAR_UNI",
0753 ""
0754 ],
0755 "forum_last_poster_colour": [
0756 "VCHAR:6",
0757 ""
0758 ],
0759 "forum_flags": [
0760 "TINT:4",
0761 32
0762 ],
0763 "display_on_index": [
0764 "BOOL",
0765 1
0766 ],
0767 "enable_indexing": [
0768 "BOOL",
0769 1
0770 ],
0771 "enable_icons": [
0772 "BOOL",
0773 1
0774 ],
0775 "enable_prune": [
0776 "BOOL",
0777 0
0778 ],
0779 "prune_next": [
0780 "TIMESTAMP",
0781 0
0782 ],
0783 "prune_days": [
0784 "UINT",
0785 0
0786 ],
0787 "prune_viewed": [
0788 "UINT",
0789 0
0790 ],
0791 "prune_freq": [
0792 "UINT",
0793 0
0794 ],
0795 "display_subforum_list": [
0796 "BOOL",
0797 1
0798 ],
0799 "forum_options": [
0800 "UINT:20",
0801 0
0802 ],
0803 "forum_posts_approved": [
0804 "UINT",
0805 0
0806 ],
0807 "forum_posts_unapproved": [
0808 "UINT",
0809 0
0810 ],
0811 "forum_posts_softdeleted": [
0812 "UINT",
0813 0
0814 ],
0815 "forum_topics_approved": [
0816 "UINT",
0817 0
0818 ],
0819 "forum_topics_unapproved": [
0820 "UINT",
0821 0
0822 ],
0823 "forum_topics_softdeleted": [
0824 "UINT",
0825 0
0826 ],
0827 "enable_shadow_prune": [
0828 "BOOL",
0829 0
0830 ],
0831 "prune_shadow_days": [
0832 "UINT",
0833 7
0834 ],
0835 "prune_shadow_freq": [
0836 "UINT",
0837 1
0838 ],
0839 "prune_shadow_next": [
0840 "INT:11",
0841 0
0842 ]
0843 },
0844 "PRIMARY_KEY": "forum_id",
0845 "KEYS": {
0846 "left_right_id": [
0847 "INDEX",
0848 [
0849 "left_id",
0850 "right_id"
0851 ]
0852 ],
0853 "forum_lastpost_id": [
0854 "INDEX",
0855 "forum_last_post_id"
0856 ]
0857 }
0858 },
0859 "phpbb_forums_access": {
0860 "COLUMNS": {
0861 "forum_id": [
0862 "UINT",
0863 0
0864 ],
0865 "user_id": [
0866 "UINT",
0867 0
0868 ],
0869 "session_id": [
0870 "CHAR:32",
0871 ""
0872 ]
0873 },
0874 "PRIMARY_KEY": [
0875 "forum_id",
0876 "user_id",
0877 "session_id"
0878 ]
0879 },
0880 "phpbb_forums_track": {
0881 "COLUMNS": {
0882 "user_id": [
0883 "UINT",
0884 0
0885 ],
0886 "forum_id": [
0887 "UINT",
0888 0
0889 ],
0890 "mark_time": [
0891 "TIMESTAMP",
0892 0
0893 ]
0894 },
0895 "PRIMARY_KEY": [
0896 "user_id",
0897 "forum_id"
0898 ]
0899 },
0900 "phpbb_forums_watch": {
0901 "COLUMNS": {
0902 "forum_id": [
0903 "UINT",
0904 0
0905 ],
0906 "user_id": [
0907 "UINT",
0908 0
0909 ],
0910 "notify_status": [
0911 "BOOL",
0912 0
0913 ]
0914 },
0915 "KEYS": {
0916 "forum_id": [
0917 "INDEX",
0918 "forum_id"
0919 ],
0920 "user_id": [
0921 "INDEX",
0922 "user_id"
0923 ],
0924 "notify_stat": [
0925 "INDEX",
0926 "notify_status"
0927 ]
0928 }
0929 },
0930 "phpbb_groups": {
0931 "COLUMNS": {
0932 "group_id": [
0933 "UINT",
0934 null,
0935 "auto_increment"
0936 ],
0937 "group_type": [
0938 "TINT:4",
0939 1
0940 ],
0941 "group_founder_manage": [
0942 "BOOL",
0943 0
0944 ],
0945 "group_skip_auth": [
0946 "BOOL",
0947 0
0948 ],
0949 "group_name": [
0950 "VCHAR_CI",
0951 ""
0952 ],
0953 "group_desc": [
0954 "TEXT_UNI",
0955 ""
0956 ],
0957 "group_desc_bitfield": [
0958 "VCHAR:255",
0959 ""
0960 ],
0961 "group_desc_options": [
0962 "UINT:11",
0963 7
0964 ],
0965 "group_desc_uid": [
0966 "VCHAR:8",
0967 ""
0968 ],
0969 "group_display": [
0970 "BOOL",
0971 0
0972 ],
0973 "group_avatar": [
0974 "VCHAR",
0975 ""
0976 ],
0977 "group_avatar_type": [
0978 "VCHAR:255",
0979 ""
0980 ],
0981 "group_avatar_width": [
0982 "USINT",
0983 0
0984 ],
0985 "group_avatar_height": [
0986 "USINT",
0987 0
0988 ],
0989 "group_rank": [
0990 "UINT",
0991 0
0992 ],
0993 "group_colour": [
0994 "VCHAR:6",
0995 ""
0996 ],
0997 "group_sig_chars": [
0998 "UINT",
0999 0
1000 ],
1001 "group_receive_pm": [
1002 "BOOL",
1003 0
1004 ],
1005 "group_message_limit": [
1006 "UINT",
1007 0
1008 ],
1009 "group_legend": [
1010 "UINT",
1011 0
1012 ],
1013 "group_max_recipients": [
1014 "UINT",
1015 0
1016 ]
1017 },
1018 "PRIMARY_KEY": "group_id",
1019 "KEYS": {
1020 "group_legend_name": [
1021 "INDEX",
1022 [
1023 "group_legend",
1024 "group_name"
1025 ]
1026 ]
1027 }
1028 },
1029 "phpbb_icons": {
1030 "COLUMNS": {
1031 "icons_id": [
1032 "UINT",
1033 null,
1034 "auto_increment"
1035 ],
1036 "icons_url": [
1037 "VCHAR",
1038 ""
1039 ],
1040 "icons_width": [
1041 "TINT:4",
1042 0
1043 ],
1044 "icons_height": [
1045 "TINT:4",
1046 0
1047 ],
1048 "icons_order": [
1049 "UINT",
1050 0
1051 ],
1052 "display_on_posting": [
1053 "BOOL",
1054 1
1055 ]
1056 },
1057 "PRIMARY_KEY": "icons_id",
1058 "KEYS": {
1059 "display_on_posting": [
1060 "INDEX",
1061 "display_on_posting"
1062 ]
1063 }
1064 },
1065 "phpbb_lang": {
1066 "COLUMNS": {
1067 "lang_id": [
1068 "TINT:4",
1069 null,
1070 "auto_increment"
1071 ],
1072 "lang_iso": [
1073 "VCHAR:30",
1074 ""
1075 ],
1076 "lang_dir": [
1077 "VCHAR:30",
1078 ""
1079 ],
1080 "lang_english_name": [
1081 "VCHAR_UNI:100",
1082 ""
1083 ],
1084 "lang_local_name": [
1085 "VCHAR_UNI:255",
1086 ""
1087 ],
1088 "lang_author": [
1089 "VCHAR_UNI:255",
1090 ""
1091 ]
1092 },
1093 "PRIMARY_KEY": "lang_id",
1094 "KEYS": {
1095 "lang_iso": [
1096 "INDEX",
1097 "lang_iso"
1098 ]
1099 }
1100 },
1101 "phpbb_log": {
1102 "COLUMNS": {
1103 "log_id": [
1104 "UINT",
1105 null,
1106 "auto_increment"
1107 ],
1108 "log_type": [
1109 "TINT:4",
1110 0
1111 ],
1112 "user_id": [
1113 "UINT",
1114 0
1115 ],
1116 "forum_id": [
1117 "UINT",
1118 0
1119 ],
1120 "topic_id": [
1121 "UINT",
1122 0
1123 ],
1124 "reportee_id": [
1125 "UINT",
1126 0
1127 ],
1128 "log_ip": [
1129 "VCHAR:40",
1130 ""
1131 ],
1132 "log_time": [
1133 "TIMESTAMP",
1134 0
1135 ],
1136 "log_operation": [
1137 "TEXT_UNI",
1138 ""
1139 ],
1140 "log_data": [
1141 "MTEXT_UNI",
1142 ""
1143 ]
1144 },
1145 "PRIMARY_KEY": "log_id",
1146 "KEYS": {
1147 "log_type": [
1148 "INDEX",
1149 "log_type"
1150 ],
1151 "forum_id": [
1152 "INDEX",
1153 "forum_id"
1154 ],
1155 "topic_id": [
1156 "INDEX",
1157 "topic_id"
1158 ],
1159 "reportee_id": [
1160 "INDEX",
1161 "reportee_id"
1162 ],
1163 "user_id": [
1164 "INDEX",
1165 "user_id"
1166 ]
1167 }
1168 },
1169 "phpbb_login_attempts": {
1170 "COLUMNS": {
1171 "attempt_ip": [
1172 "VCHAR:40",
1173 ""
1174 ],
1175 "attempt_browser": [
1176 "VCHAR:150",
1177 ""
1178 ],
1179 "attempt_forwarded_for": [
1180 "VCHAR:255",
1181 ""
1182 ],
1183 "attempt_time": [
1184 "TIMESTAMP",
1185 0
1186 ],
1187 "user_id": [
1188 "UINT",
1189 0
1190 ],
1191 "username": [
1192 "VCHAR_UNI:255",
1193 0
1194 ],
1195 "username_clean": [
1196 "VCHAR_CI",
1197 0
1198 ]
1199 },
1200 "KEYS": {
1201 "att_ip": [
1202 "INDEX",
1203 [
1204 "attempt_ip",
1205 "attempt_time"
1206 ]
1207 ],
1208 "att_for": [
1209 "INDEX",
1210 [
1211 "attempt_forwarded_for",
1212 "attempt_time"
1213 ]
1214 ],
1215 "att_time": [
1216 "INDEX",
1217 [
1218 "attempt_time"
1219 ]
1220 ],
1221 "user_id": [
1222 "INDEX",
1223 "user_id"
1224 ]
1225 }
1226 },
1227 "phpbb_migrations": {
1228 "COLUMNS": {
1229 "migration_name": [
1230 "VCHAR",
1231 ""
1232 ],
1233 "migration_depends_on": [
1234 "TEXT",
1235 ""
1236 ],
1237 "migration_schema_done": [
1238 "BOOL",
1239 0
1240 ],
1241 "migration_data_done": [
1242 "BOOL",
1243 0
1244 ],
1245 "migration_data_state": [
1246 "TEXT",
1247 ""
1248 ],
1249 "migration_start_time": [
1250 "TIMESTAMP",
1251 0
1252 ],
1253 "migration_end_time": [
1254 "TIMESTAMP",
1255 0
1256 ]
1257 },
1258 "PRIMARY_KEY": "migration_name"
1259 },
1260 "phpbb_moderator_cache": {
1261 "COLUMNS": {
1262 "forum_id": [
1263 "UINT",
1264 0
1265 ],
1266 "user_id": [
1267 "UINT",
1268 0
1269 ],
1270 "username": [
1271 "VCHAR_UNI:255",
1272 ""
1273 ],
1274 "group_id": [
1275 "UINT",
1276 0
1277 ],
1278 "group_name": [
1279 "VCHAR_UNI",
1280 ""
1281 ],
1282 "display_on_index": [
1283 "BOOL",
1284 1
1285 ]
1286 },
1287 "KEYS": {
1288 "disp_idx": [
1289 "INDEX",
1290 "display_on_index"
1291 ],
1292 "forum_id": [
1293 "INDEX",
1294 "forum_id"
1295 ]
1296 }
1297 },
1298 "phpbb_modules": {
1299 "COLUMNS": {
1300 "module_id": [
1301 "UINT",
1302 null,
1303 "auto_increment"
1304 ],
1305 "module_enabled": [
1306 "BOOL",
1307 1
1308 ],
1309 "module_display": [
1310 "BOOL",
1311 1
1312 ],
1313 "module_basename": [
1314 "VCHAR",
1315 ""
1316 ],
1317 "module_class": [
1318 "VCHAR:10",
1319 ""
1320 ],
1321 "parent_id": [
1322 "UINT",
1323 0
1324 ],
1325 "left_id": [
1326 "UINT",
1327 0
1328 ],
1329 "right_id": [
1330 "UINT",
1331 0
1332 ],
1333 "module_langname": [
1334 "VCHAR",
1335 ""
1336 ],
1337 "module_mode": [
1338 "VCHAR",
1339 ""
1340 ],
1341 "module_auth": [
1342 "VCHAR",
1343 ""
1344 ]
1345 },
1346 "PRIMARY_KEY": "module_id",
1347 "KEYS": {
1348 "left_right_id": [
1349 "INDEX",
1350 [
1351 "left_id",
1352 "right_id"
1353 ]
1354 ],
1355 "module_enabled": [
1356 "INDEX",
1357 "module_enabled"
1358 ],
1359 "class_left_id": [
1360 "INDEX",
1361 [
1362 "module_class",
1363 "left_id"
1364 ]
1365 ]
1366 }
1367 },
1368 "phpbb_notification_types": {
1369 "COLUMNS": {
1370 "notification_type_id": [
1371 "USINT",
1372 null,
1373 "auto_increment"
1374 ],
1375 "notification_type_name": [
1376 "VCHAR:255",
1377 ""
1378 ],
1379 "notification_type_enabled": [
1380 "BOOL",
1381 1
1382 ]
1383 },
1384 "PRIMARY_KEY": [
1385 "notification_type_id"
1386 ],
1387 "KEYS": {
1388 "type": [
1389 "UNIQUE",
1390 [
1391 "notification_type_name"
1392 ]
1393 ]
1394 }
1395 },
1396 "phpbb_notifications": {
1397 "COLUMNS": {
1398 "notification_id": [
1399 "UINT:10",
1400 null,
1401 "auto_increment"
1402 ],
1403 "notification_type_id": [
1404 "USINT",
1405 0
1406 ],
1407 "item_id": [
1408 "UINT",
1409 0
1410 ],
1411 "item_parent_id": [
1412 "UINT",
1413 0
1414 ],
1415 "user_id": [
1416 "UINT",
1417 0
1418 ],
1419 "notification_read": [
1420 "BOOL",
1421 0
1422 ],
1423 "notification_time": [
1424 "TIMESTAMP",
1425 1
1426 ],
1427 "notification_data": [
1428 "TEXT_UNI",
1429 ""
1430 ]
1431 },
1432 "PRIMARY_KEY": "notification_id",
1433 "KEYS": {
1434 "item_ident": [
1435 "INDEX",
1436 [
1437 "notification_type_id",
1438 "item_id"
1439 ]
1440 ],
1441 "user": [
1442 "INDEX",
1443 [
1444 "user_id",
1445 "notification_read"
1446 ]
1447 ]
1448 }
1449 },
1450 "phpbb_oauth_accounts": {
1451 "COLUMNS": {
1452 "user_id": [
1453 "UINT",
1454 0
1455 ],
1456 "provider": [
1457 "VCHAR",
1458 ""
1459 ],
1460 "oauth_provider_id": [
1461 "TEXT_UNI",
1462 ""
1463 ]
1464 },
1465 "PRIMARY_KEY": [
1466 "user_id",
1467 "provider"
1468 ]
1469 },
1470 "phpbb_oauth_tokens": {
1471 "COLUMNS": {
1472 "user_id": [
1473 "UINT",
1474 0
1475 ],
1476 "session_id": [
1477 "CHAR:32",
1478 ""
1479 ],
1480 "provider": [
1481 "VCHAR",
1482 ""
1483 ],
1484 "oauth_token": [
1485 "MTEXT",
1486 ""
1487 ]
1488 },
1489 "KEYS": {
1490 "user_id": [
1491 "INDEX",
1492 "user_id"
1493 ],
1494 "provider": [
1495 "INDEX",
1496 "provider"
1497 ]
1498 }
1499 },
1500 "phpbb_poll_options": {
1501 "COLUMNS": {
1502 "poll_option_id": [
1503 "TINT:4",
1504 0
1505 ],
1506 "topic_id": [
1507 "UINT",
1508 0
1509 ],
1510 "poll_option_text": [
1511 "TEXT_UNI",
1512 ""
1513 ],
1514 "poll_option_total": [
1515 "UINT",
1516 0
1517 ]
1518 },
1519 "KEYS": {
1520 "poll_opt_id": [
1521 "INDEX",
1522 "poll_option_id"
1523 ],
1524 "topic_id": [
1525 "INDEX",
1526 "topic_id"
1527 ]
1528 }
1529 },
1530 "phpbb_poll_votes": {
1531 "COLUMNS": {
1532 "topic_id": [
1533 "UINT",
1534 0
1535 ],
1536 "poll_option_id": [
1537 "TINT:4",
1538 0
1539 ],
1540 "vote_user_id": [
1541 "UINT",
1542 0
1543 ],
1544 "vote_user_ip": [
1545 "VCHAR:40",
1546 ""
1547 ]
1548 },
1549 "KEYS": {
1550 "topic_id": [
1551 "INDEX",
1552 "topic_id"
1553 ],
1554 "vote_user_id": [
1555 "INDEX",
1556 "vote_user_id"
1557 ],
1558 "vote_user_ip": [
1559 "INDEX",
1560 "vote_user_ip"
1561 ]
1562 }
1563 },
1564 "phpbb_posts": {
1565 "COLUMNS": {
1566 "post_id": [
1567 "UINT",
1568 null,
1569 "auto_increment"
1570 ],
1571 "topic_id": [
1572 "UINT",
1573 0
1574 ],
1575 "forum_id": [
1576 "UINT",
1577 0
1578 ],
1579 "poster_id": [
1580 "UINT",
1581 0
1582 ],
1583 "icon_id": [
1584 "UINT",
1585 0
1586 ],
1587 "poster_ip": [
1588 "VCHAR:40",
1589 ""
1590 ],
1591 "post_time": [
1592 "TIMESTAMP",
1593 0
1594 ],
1595 "post_reported": [
1596 "BOOL",
1597 0
1598 ],
1599 "enable_bbcode": [
1600 "BOOL",
1601 1
1602 ],
1603 "enable_smilies": [
1604 "BOOL",
1605 1
1606 ],
1607 "enable_magic_url": [
1608 "BOOL",
1609 1
1610 ],
1611 "enable_sig": [
1612 "BOOL",
1613 1
1614 ],
1615 "post_username": [
1616 "VCHAR_UNI:255",
1617 ""
1618 ],
1619 "post_subject": [
1620 "STEXT_UNI",
1621 "",
1622 "true_sort"
1623 ],
1624 "post_text": [
1625 "MTEXT_UNI",
1626 ""
1627 ],
1628 "post_checksum": [
1629 "VCHAR:32",
1630 ""
1631 ],
1632 "post_attachment": [
1633 "BOOL",
1634 0
1635 ],
1636 "bbcode_bitfield": [
1637 "VCHAR:255",
1638 ""
1639 ],
1640 "bbcode_uid": [
1641 "VCHAR:8",
1642 ""
1643 ],
1644 "post_postcount": [
1645 "BOOL",
1646 1
1647 ],
1648 "post_edit_time": [
1649 "TIMESTAMP",
1650 0
1651 ],
1652 "post_edit_reason": [
1653 "STEXT_UNI",
1654 ""
1655 ],
1656 "post_edit_user": [
1657 "UINT",
1658 0
1659 ],
1660 "post_edit_count": [
1661 "USINT",
1662 0
1663 ],
1664 "post_edit_locked": [
1665 "BOOL",
1666 0
1667 ],
1668 "post_visibility": [
1669 "TINT:3",
1670 0
1671 ],
1672 "post_delete_time": [
1673 "TIMESTAMP",
1674 0
1675 ],
1676 "post_delete_reason": [
1677 "STEXT_UNI",
1678 ""
1679 ],
1680 "post_delete_user": [
1681 "UINT",
1682 0
1683 ]
1684 },
1685 "PRIMARY_KEY": "post_id",
1686 "KEYS": {
1687 "forum_id": [
1688 "INDEX",
1689 "forum_id"
1690 ],
1691 "topic_id": [
1692 "INDEX",
1693 "topic_id"
1694 ],
1695 "poster_ip": [
1696 "INDEX",
1697 "poster_ip"
1698 ],
1699 "poster_id": [
1700 "INDEX",
1701 "poster_id"
1702 ],
1703 "tid_post_time": [
1704 "INDEX",
1705 [
1706 "topic_id",
1707 "post_time"
1708 ]
1709 ],
1710 "post_username": [
1711 "INDEX",
1712 [
1713 "post_username:255"
1714 ]
1715 ],
1716 "post_visibility": [
1717 "INDEX",
1718 [
1719 "post_visibility"
1720 ]
1721 ]
1722 }
1723 },
1724 "phpbb_privmsgs": {
1725 "COLUMNS": {
1726 "msg_id": [
1727 "UINT",
1728 null,
1729 "auto_increment"
1730 ],
1731 "root_level": [
1732 "UINT",
1733 0
1734 ],
1735 "author_id": [
1736 "UINT",
1737 0
1738 ],
1739 "icon_id": [
1740 "UINT",
1741 0
1742 ],
1743 "author_ip": [
1744 "VCHAR:40",
1745 ""
1746 ],
1747 "message_time": [
1748 "TIMESTAMP",
1749 0
1750 ],
1751 "enable_bbcode": [
1752 "BOOL",
1753 1
1754 ],
1755 "enable_smilies": [
1756 "BOOL",
1757 1
1758 ],
1759 "enable_magic_url": [
1760 "BOOL",
1761 1
1762 ],
1763 "enable_sig": [
1764 "BOOL",
1765 1
1766 ],
1767 "message_subject": [
1768 "STEXT_UNI",
1769 ""
1770 ],
1771 "message_text": [
1772 "MTEXT_UNI",
1773 ""
1774 ],
1775 "message_edit_reason": [
1776 "STEXT_UNI",
1777 ""
1778 ],
1779 "message_edit_user": [
1780 "UINT",
1781 0
1782 ],
1783 "message_attachment": [
1784 "BOOL",
1785 0
1786 ],
1787 "bbcode_bitfield": [
1788 "VCHAR:255",
1789 ""
1790 ],
1791 "bbcode_uid": [
1792 "VCHAR:8",
1793 ""
1794 ],
1795 "message_edit_time": [
1796 "TIMESTAMP",
1797 0
1798 ],
1799 "message_edit_count": [
1800 "USINT",
1801 0
1802 ],
1803 "to_address": [
1804 "TEXT_UNI",
1805 ""
1806 ],
1807 "bcc_address": [
1808 "TEXT_UNI",
1809 ""
1810 ],
1811 "message_reported": [
1812 "BOOL",
1813 0
1814 ]
1815 },
1816 "PRIMARY_KEY": "msg_id",
1817 "KEYS": {
1818 "author_ip": [
1819 "INDEX",
1820 "author_ip"
1821 ],
1822 "message_time": [
1823 "INDEX",
1824 "message_time"
1825 ],
1826 "author_id": [
1827 "INDEX",
1828 "author_id"
1829 ],
1830 "root_level": [
1831 "INDEX",
1832 "root_level"
1833 ]
1834 }
1835 },
1836 "phpbb_privmsgs_folder": {
1837 "COLUMNS": {
1838 "folder_id": [
1839 "UINT",
1840 null,
1841 "auto_increment"
1842 ],
1843 "user_id": [
1844 "UINT",
1845 0
1846 ],
1847 "folder_name": [
1848 "VCHAR_UNI",
1849 ""
1850 ],
1851 "pm_count": [
1852 "UINT",
1853 0
1854 ]
1855 },
1856 "PRIMARY_KEY": "folder_id",
1857 "KEYS": {
1858 "user_id": [
1859 "INDEX",
1860 "user_id"
1861 ]
1862 }
1863 },
1864 "phpbb_privmsgs_rules": {
1865 "COLUMNS": {
1866 "rule_id": [
1867 "UINT",
1868 null,
1869 "auto_increment"
1870 ],
1871 "user_id": [
1872 "UINT",
1873 0
1874 ],
1875 "rule_check": [
1876 "UINT",
1877 0
1878 ],
1879 "rule_connection": [
1880 "UINT",
1881 0
1882 ],
1883 "rule_string": [
1884 "VCHAR_UNI",
1885 ""
1886 ],
1887 "rule_user_id": [
1888 "UINT",
1889 0
1890 ],
1891 "rule_group_id": [
1892 "UINT",
1893 0
1894 ],
1895 "rule_action": [
1896 "UINT",
1897 0
1898 ],
1899 "rule_folder_id": [
1900 "INT:11",
1901 0
1902 ]
1903 },
1904 "PRIMARY_KEY": "rule_id",
1905 "KEYS": {
1906 "user_id": [
1907 "INDEX",
1908 "user_id"
1909 ]
1910 }
1911 },
1912 "phpbb_privmsgs_to": {
1913 "COLUMNS": {
1914 "msg_id": [
1915 "UINT",
1916 0
1917 ],
1918 "user_id": [
1919 "UINT",
1920 0
1921 ],
1922 "author_id": [
1923 "UINT",
1924 0
1925 ],
1926 "pm_deleted": [
1927 "BOOL",
1928 0
1929 ],
1930 "pm_new": [
1931 "BOOL",
1932 1
1933 ],
1934 "pm_unread": [
1935 "BOOL",
1936 1
1937 ],
1938 "pm_replied": [
1939 "BOOL",
1940 0
1941 ],
1942 "pm_marked": [
1943 "BOOL",
1944 0
1945 ],
1946 "pm_forwarded": [
1947 "BOOL",
1948 0
1949 ],
1950 "folder_id": [
1951 "INT:11",
1952 0
1953 ]
1954 },
1955 "KEYS": {
1956 "msg_id": [
1957 "INDEX",
1958 "msg_id"
1959 ],
1960 "author_id": [
1961 "INDEX",
1962 "author_id"
1963 ],
1964 "usr_flder_id": [
1965 "INDEX",
1966 [
1967 "user_id",
1968 "folder_id"
1969 ]
1970 ]
1971 }
1972 },
1973 "phpbb_profile_fields": {
1974 "COLUMNS": {
1975 "field_id": [
1976 "UINT",
1977 null,
1978 "auto_increment"
1979 ],
1980 "field_name": [
1981 "VCHAR_UNI",
1982 ""
1983 ],
1984 "field_type": [
1985 "VCHAR:100",
1986 ""
1987 ],
1988 "field_ident": [
1989 "VCHAR:20",
1990 ""
1991 ],
1992 "field_length": [
1993 "VCHAR:20",
1994 ""
1995 ],
1996 "field_minlen": [
1997 "VCHAR",
1998 ""
1999 ],
2000 "field_maxlen": [
2001 "VCHAR",
2002 ""
2003 ],
2004 "field_novalue": [
2005 "VCHAR_UNI",
2006 ""
2007 ],
2008 "field_default_value": [
2009 "VCHAR_UNI",
2010 ""
2011 ],
2012 "field_validation": [
2013 "VCHAR_UNI:64",
2014 ""
2015 ],
2016 "field_required": [
2017 "BOOL",
2018 0
2019 ],
2020 "field_show_on_reg": [
2021 "BOOL",
2022 0
2023 ],
2024 "field_hide": [
2025 "BOOL",
2026 0
2027 ],
2028 "field_no_view": [
2029 "BOOL",
2030 0
2031 ],
2032 "field_active": [
2033 "BOOL",
2034 0
2035 ],
2036 "field_order": [
2037 "UINT",
2038 0
2039 ],
2040 "field_show_profile": [
2041 "BOOL",
2042 0
2043 ],
2044 "field_show_on_vt": [
2045 "BOOL",
2046 0
2047 ],
2048 "field_show_novalue": [
2049 "BOOL",
2050 0
2051 ],
2052 "field_show_on_pm": [
2053 "BOOL",
2054 0
2055 ],
2056 "field_show_on_ml": [
2057 "BOOL",
2058 0
2059 ],
2060 "field_is_contact": [
2061 "BOOL",
2062 0
2063 ],
2064 "field_contact_desc": [
2065 "VCHAR",
2066 ""
2067 ],
2068 "field_contact_url": [
2069 "VCHAR",
2070 ""
2071 ]
2072 },
2073 "PRIMARY_KEY": "field_id",
2074 "KEYS": {
2075 "fld_type": [
2076 "INDEX",
2077 "field_type"
2078 ],
2079 "fld_ordr": [
2080 "INDEX",
2081 "field_order"
2082 ]
2083 }
2084 },
2085 "phpbb_profile_fields_data": {
2086 "COLUMNS": {
2087 "user_id": [
2088 "UINT",
2089 0
2090 ],
2091 "pf_phpbb_interests": [
2092 "MTEXT",
2093 ""
2094 ],
2095 "pf_phpbb_occupation": [
2096 "MTEXT",
2097 ""
2098 ],
2099 "pf_phpbb_location": [
2100 "VCHAR",
2101 ""
2102 ],
2103 "pf_phpbb_icq": [
2104 "VCHAR",
2105 ""
2106 ],
2107 "pf_phpbb_googleplus": [
2108 "VCHAR",
2109 ""
2110 ],
2111 "pf_phpbb_youtube": [
2112 "VCHAR",
2113 ""
2114 ],
2115 "pf_phpbb_twitter": [
2116 "VCHAR",
2117 ""
2118 ],
2119 "pf_phpbb_facebook": [
2120 "VCHAR",
2121 ""
2122 ],
2123 "pf_phpbb_skype": [
2124 "VCHAR",
2125 ""
2126 ],
2127 "pf_phpbb_website": [
2128 "VCHAR",
2129 ""
2130 ],
2131 "pf_phpbb_wlm": [
2132 "VCHAR",
2133 ""
2134 ],
2135 "pf_phpbb_yahoo": [
2136 "VCHAR",
2137 ""
2138 ],
2139 "pf_phpbb_aol": [
2140 "VCHAR",
2141 ""
2142 ]
2143 },
2144 "PRIMARY_KEY": "user_id"
2145 },
2146 "phpbb_profile_fields_lang": {
2147 "COLUMNS": {
2148 "field_id": [
2149 "UINT",
2150 0
2151 ],
2152 "lang_id": [
2153 "UINT",
2154 0
2155 ],
2156 "option_id": [
2157 "UINT",
2158 0
2159 ],
2160 "field_type": [
2161 "VCHAR:100",
2162 ""
2163 ],
2164 "lang_value": [
2165 "VCHAR_UNI",
2166 ""
2167 ]
2168 },
2169 "PRIMARY_KEY": [
2170 "field_id",
2171 "lang_id",
2172 "option_id"
2173 ]
2174 },
2175 "phpbb_profile_lang": {
2176 "COLUMNS": {
2177 "field_id": [
2178 "UINT",
2179 0
2180 ],
2181 "lang_id": [
2182 "UINT",
2183 0
2184 ],
2185 "lang_name": [
2186 "VCHAR_UNI",
2187 ""
2188 ],
2189 "lang_explain": [
2190 "TEXT_UNI",
2191 ""
2192 ],
2193 "lang_default_value": [
2194 "VCHAR_UNI",
2195 ""
2196 ]
2197 },
2198 "PRIMARY_KEY": [
2199 "field_id",
2200 "lang_id"
2201 ]
2202 },
2203 "phpbb_ranks": {
2204 "COLUMNS": {
2205 "rank_id": [
2206 "UINT",
2207 null,
2208 "auto_increment"
2209 ],
2210 "rank_title": [
2211 "VCHAR_UNI",
2212 ""
2213 ],
2214 "rank_min": [
2215 "UINT",
2216 0
2217 ],
2218 "rank_special": [
2219 "BOOL",
2220 0
2221 ],
2222 "rank_image": [
2223 "VCHAR",
2224 ""
2225 ]
2226 },
2227 "PRIMARY_KEY": "rank_id"
2228 },
2229 "phpbb_reports": {
2230 "COLUMNS": {
2231 "report_id": [
2232 "UINT",
2233 null,
2234 "auto_increment"
2235 ],
2236 "reason_id": [
2237 "USINT",
2238 0
2239 ],
2240 "post_id": [
2241 "UINT",
2242 0
2243 ],
2244 "user_id": [
2245 "UINT",
2246 0
2247 ],
2248 "user_notify": [
2249 "BOOL",
2250 0
2251 ],
2252 "report_closed": [
2253 "BOOL",
2254 0
2255 ],
2256 "report_time": [
2257 "TIMESTAMP",
2258 0
2259 ],
2260 "report_text": [
2261 "MTEXT_UNI",
2262 ""
2263 ],
2264 "pm_id": [
2265 "UINT",
2266 0
2267 ],
2268 "reported_post_enable_bbcode": [
2269 "BOOL",
2270 1
2271 ],
2272 "reported_post_enable_smilies": [
2273 "BOOL",
2274 1
2275 ],
2276 "reported_post_enable_magic_url": [
2277 "BOOL",
2278 1
2279 ],
2280 "reported_post_text": [
2281 "MTEXT_UNI",
2282 ""
2283 ],
2284 "reported_post_uid": [
2285 "VCHAR:8",
2286 ""
2287 ],
2288 "reported_post_bitfield": [
2289 "VCHAR:255",
2290 ""
2291 ]
2292 },
2293 "PRIMARY_KEY": "report_id",
2294 "KEYS": {
2295 "post_id": [
2296 "INDEX",
2297 [
2298 "post_id"
2299 ]
2300 ],
2301 "pm_id": [
2302 "INDEX",
2303 [
2304 "pm_id"
2305 ]
2306 ]
2307 }
2308 },
2309 "phpbb_reports_reasons": {
2310 "COLUMNS": {
2311 "reason_id": [
2312 "USINT",
2313 null,
2314 "auto_increment"
2315 ],
2316 "reason_title": [
2317 "VCHAR_UNI",
2318 ""
2319 ],
2320 "reason_description": [
2321 "MTEXT_UNI",
2322 ""
2323 ],
2324 "reason_order": [
2325 "USINT",
2326 0
2327 ]
2328 },
2329 "PRIMARY_KEY": "reason_id"
2330 },
2331 "phpbb_search_results": {
2332 "COLUMNS": {
2333 "search_key": [
2334 "VCHAR:32",
2335 ""
2336 ],
2337 "search_time": [
2338 "TIMESTAMP",
2339 0
2340 ],
2341 "search_keywords": [
2342 "MTEXT_UNI",
2343 ""
2344 ],
2345 "search_authors": [
2346 "MTEXT",
2347 ""
2348 ]
2349 },
2350 "PRIMARY_KEY": "search_key"
2351 },
2352 "phpbb_search_wordlist": {
2353 "COLUMNS": {
2354 "word_id": [
2355 "UINT",
2356 null,
2357 "auto_increment"
2358 ],
2359 "word_text": [
2360 "VCHAR_UNI",
2361 ""
2362 ],
2363 "word_common": [
2364 "BOOL",
2365 0
2366 ],
2367 "word_count": [
2368 "UINT",
2369 0
2370 ]
2371 },
2372 "PRIMARY_KEY": "word_id",
2373 "KEYS": {
2374 "wrd_txt": [
2375 "UNIQUE",
2376 "word_text"
2377 ],
2378 "wrd_cnt": [
2379 "INDEX",
2380 "word_count"
2381 ]
2382 }
2383 },
2384 "phpbb_search_wordmatch": {
2385 "COLUMNS": {
2386 "post_id": [
2387 "UINT",
2388 0
2389 ],
2390 "word_id": [
2391 "UINT",
2392 0
2393 ],
2394 "title_match": [
2395 "BOOL",
2396 0
2397 ]
2398 },
2399 "KEYS": {
2400 "word_id": [
2401 "INDEX",
2402 "word_id"
2403 ],
2404 "post_id": [
2405 "INDEX",
2406 "post_id"
2407 ],
2408 "un_mtch": [
2409 "UNIQUE",
2410 [
2411 "word_id",
2412 "post_id",
2413 "title_match"
2414 ]
2415 ]
2416 }
2417 },
2418 "phpbb_sessions": {
2419 "COLUMNS": {
2420 "session_id": [
2421 "CHAR:32",
2422 ""
2423 ],
2424 "session_user_id": [
2425 "UINT",
2426 0
2427 ],
2428 "session_last_visit": [
2429 "TIMESTAMP",
2430 0
2431 ],
2432 "session_start": [
2433 "TIMESTAMP",
2434 0
2435 ],
2436 "session_time": [
2437 "TIMESTAMP",
2438 0
2439 ],
2440 "session_ip": [
2441 "VCHAR:40",
2442 ""
2443 ],
2444 "session_browser": [
2445 "VCHAR:150",
2446 ""
2447 ],
2448 "session_forwarded_for": [
2449 "VCHAR:255",
2450 ""
2451 ],
2452 "session_page": [
2453 "VCHAR_UNI",
2454 ""
2455 ],
2456 "session_viewonline": [
2457 "BOOL",
2458 1
2459 ],
2460 "session_autologin": [
2461 "BOOL",
2462 0
2463 ],
2464 "session_admin": [
2465 "BOOL",
2466 0
2467 ],
2468 "session_forum_id": [
2469 "UINT",
2470 0
2471 ]
2472 },
2473 "PRIMARY_KEY": "session_id",
2474 "KEYS": {
2475 "session_time": [
2476 "INDEX",
2477 "session_time"
2478 ],
2479 "session_user_id": [
2480 "INDEX",
2481 "session_user_id"
2482 ],
2483 "session_fid": [
2484 "INDEX",
2485 [
2486 "session_forum_id"
2487 ]
2488 ]
2489 }
2490 },
2491 "phpbb_sessions_keys": {
2492 "COLUMNS": {
2493 "key_id": [
2494 "CHAR:32",
2495 ""
2496 ],
2497 "user_id": [
2498 "UINT",
2499 0
2500 ],
2501 "last_ip": [
2502 "VCHAR:40",
2503 ""
2504 ],
2505 "last_login": [
2506 "TIMESTAMP",
2507 0
2508 ]
2509 },
2510 "PRIMARY_KEY": [
2511 "key_id",
2512 "user_id"
2513 ],
2514 "KEYS": {
2515 "last_login": [
2516 "INDEX",
2517 "last_login"
2518 ]
2519 }
2520 },
2521 "phpbb_sitelist": {
2522 "COLUMNS": {
2523 "site_id": [
2524 "UINT",
2525 null,
2526 "auto_increment"
2527 ],
2528 "site_ip": [
2529 "VCHAR:40",
2530 ""
2531 ],
2532 "site_hostname": [
2533 "VCHAR",
2534 ""
2535 ],
2536 "ip_exclude": [
2537 "BOOL",
2538 0
2539 ]
2540 },
2541 "PRIMARY_KEY": "site_id"
2542 },
2543 "phpbb_smilies": {
2544 "COLUMNS": {
2545 "smiley_id": [
2546 "UINT",
2547 null,
2548 "auto_increment"
2549 ],
2550 "code": [
2551 "VCHAR_UNI:50",
2552 ""
2553 ],
2554 "emotion": [
2555 "VCHAR_UNI:50",
2556 ""
2557 ],
2558 "smiley_url": [
2559 "VCHAR:50",
2560 ""
2561 ],
2562 "smiley_width": [
2563 "USINT",
2564 0
2565 ],
2566 "smiley_height": [
2567 "USINT",
2568 0
2569 ],
2570 "smiley_order": [
2571 "UINT",
2572 0
2573 ],
2574 "display_on_posting": [
2575 "BOOL",
2576 1
2577 ]
2578 },
2579 "PRIMARY_KEY": "smiley_id",
2580 "KEYS": {
2581 "display_on_post": [
2582 "INDEX",
2583 "display_on_posting"
2584 ]
2585 }
2586 },
2587 "phpbb_styles": {
2588 "COLUMNS": {
2589 "style_id": [
2590 "UINT",
2591 null,
2592 "auto_increment"
2593 ],
2594 "style_name": [
2595 "VCHAR_UNI:255",
2596 ""
2597 ],
2598 "style_copyright": [
2599 "VCHAR_UNI",
2600 ""
2601 ],
2602 "style_active": [
2603 "BOOL",
2604 1
2605 ],
2606 "style_path": [
2607 "VCHAR:100",
2608 ""
2609 ],
2610 "bbcode_bitfield": [
2611 "VCHAR:255",
2612 "kNg="
2613 ],
2614 "style_parent_id": [
2615 "UINT:4",
2616 0
2617 ],
2618 "style_parent_tree": [
2619 "TEXT",
2620 ""
2621 ]
2622 },
2623 "PRIMARY_KEY": "style_id",
2624 "KEYS": {
2625 "style_name": [
2626 "UNIQUE",
2627 "style_name"
2628 ]
2629 }
2630 },
2631 "phpbb_teampage": {
2632 "COLUMNS": {
2633 "teampage_id": [
2634 "UINT",
2635 null,
2636 "auto_increment"
2637 ],
2638 "group_id": [
2639 "UINT",
2640 0
2641 ],
2642 "teampage_name": [
2643 "VCHAR_UNI:255",
2644 ""
2645 ],
2646 "teampage_position": [
2647 "UINT",
2648 0
2649 ],
2650 "teampage_parent": [
2651 "UINT",
2652 0
2653 ]
2654 },
2655 "PRIMARY_KEY": "teampage_id"
2656 },
2657 "phpbb_topics": {
2658 "COLUMNS": {
2659 "topic_id": [
2660 "UINT",
2661 null,
2662 "auto_increment"
2663 ],
2664 "forum_id": [
2665 "UINT",
2666 0
2667 ],
2668 "icon_id": [
2669 "UINT",
2670 0
2671 ],
2672 "topic_attachment": [
2673 "BOOL",
2674 0
2675 ],
2676 "topic_reported": [
2677 "BOOL",
2678 0
2679 ],
2680 "topic_title": [
2681 "STEXT_UNI",
2682 "",
2683 "true_sort"
2684 ],
2685 "topic_poster": [
2686 "UINT",
2687 0
2688 ],
2689 "topic_time": [
2690 "TIMESTAMP",
2691 0
2692 ],
2693 "topic_time_limit": [
2694 "TIMESTAMP",
2695 0
2696 ],
2697 "topic_views": [
2698 "UINT",
2699 0
2700 ],
2701 "topic_status": [
2702 "TINT:3",
2703 0
2704 ],
2705 "topic_type": [
2706 "TINT:3",
2707 0
2708 ],
2709 "topic_first_post_id": [
2710 "UINT",
2711 0
2712 ],
2713 "topic_first_poster_name": [
2714 "VCHAR_UNI:255",
2715 "",
2716 "true_sort"
2717 ],
2718 "topic_first_poster_colour": [
2719 "VCHAR:6",
2720 ""
2721 ],
2722 "topic_last_post_id": [
2723 "UINT",
2724 0
2725 ],
2726 "topic_last_poster_id": [
2727 "UINT",
2728 0
2729 ],
2730 "topic_last_poster_name": [
2731 "VCHAR_UNI",
2732 ""
2733 ],
2734 "topic_last_poster_colour": [
2735 "VCHAR:6",
2736 ""
2737 ],
2738 "topic_last_post_subject": [
2739 "STEXT_UNI",
2740 ""
2741 ],
2742 "topic_last_post_time": [
2743 "TIMESTAMP",
2744 0
2745 ],
2746 "topic_last_view_time": [
2747 "TIMESTAMP",
2748 0
2749 ],
2750 "topic_moved_id": [
2751 "UINT",
2752 0
2753 ],
2754 "topic_bumped": [
2755 "BOOL",
2756 0
2757 ],
2758 "topic_bumper": [
2759 "UINT",
2760 0
2761 ],
2762 "poll_title": [
2763 "STEXT_UNI",
2764 ""
2765 ],
2766 "poll_start": [
2767 "TIMESTAMP",
2768 0
2769 ],
2770 "poll_length": [
2771 "TIMESTAMP",
2772 0
2773 ],
2774 "poll_max_options": [
2775 "TINT:4",
2776 1
2777 ],
2778 "poll_last_vote": [
2779 "TIMESTAMP",
2780 0
2781 ],
2782 "poll_vote_change": [
2783 "BOOL",
2784 0
2785 ],
2786 "topic_visibility": [
2787 "TINT:3",
2788 0
2789 ],
2790 "topic_delete_time": [
2791 "TIMESTAMP",
2792 0
2793 ],
2794 "topic_delete_reason": [
2795 "STEXT_UNI",
2796 ""
2797 ],
2798 "topic_delete_user": [
2799 "UINT",
2800 0
2801 ],
2802 "topic_posts_approved": [
2803 "UINT",
2804 0
2805 ],
2806 "topic_posts_unapproved": [
2807 "UINT",
2808 0
2809 ],
2810 "topic_posts_softdeleted": [
2811 "UINT",
2812 0
2813 ]
2814 },
2815 "PRIMARY_KEY": "topic_id",
2816 "KEYS": {
2817 "forum_id": [
2818 "INDEX",
2819 "forum_id"
2820 ],
2821 "forum_id_type": [
2822 "INDEX",
2823 [
2824 "forum_id",
2825 "topic_type"
2826 ]
2827 ],
2828 "last_post_time": [
2829 "INDEX",
2830 "topic_last_post_time"
2831 ],
2832 "fid_time_moved": [
2833 "INDEX",
2834 [
2835 "forum_id",
2836 "topic_last_post_time",
2837 "topic_moved_id"
2838 ]
2839 ],
2840 "topic_visibility": [
2841 "INDEX",
2842 [
2843 "topic_visibility"
2844 ]
2845 ],
2846 "forum_vis_last": [
2847 "INDEX",
2848 [
2849 "forum_id",
2850 "topic_visibility",
2851 "topic_last_post_id"
2852 ]
2853 ]
2854 }
2855 },
2856 "phpbb_topics_posted": {
2857 "COLUMNS": {
2858 "user_id": [
2859 "UINT",
2860 0
2861 ],
2862 "topic_id": [
2863 "UINT",
2864 0
2865 ],
2866 "topic_posted": [
2867 "BOOL",
2868 0
2869 ]
2870 },
2871 "PRIMARY_KEY": [
2872 "user_id",
2873 "topic_id"
2874 ]
2875 },
2876 "phpbb_topics_track": {
2877 "COLUMNS": {
2878 "user_id": [
2879 "UINT",
2880 0
2881 ],
2882 "topic_id": [
2883 "UINT",
2884 0
2885 ],
2886 "forum_id": [
2887 "UINT",
2888 0
2889 ],
2890 "mark_time": [
2891 "TIMESTAMP",
2892 0
2893 ]
2894 },
2895 "PRIMARY_KEY": [
2896 "user_id",
2897 "topic_id"
2898 ],
2899 "KEYS": {
2900 "forum_id": [
2901 "INDEX",
2902 "forum_id"
2903 ],
2904 "topic_id": [
2905 "INDEX",
2906 [
2907 "topic_id"
2908 ]
2909 ]
2910 }
2911 },
2912 "phpbb_topics_watch": {
2913 "COLUMNS": {
2914 "topic_id": [
2915 "UINT",
2916 0
2917 ],
2918 "user_id": [
2919 "UINT",
2920 0
2921 ],
2922 "notify_status": [
2923 "BOOL",
2924 0
2925 ]
2926 },
2927 "KEYS": {
2928 "topic_id": [
2929 "INDEX",
2930 "topic_id"
2931 ],
2932 "user_id": [
2933 "INDEX",
2934 "user_id"
2935 ],
2936 "notify_stat": [
2937 "INDEX",
2938 "notify_status"
2939 ]
2940 }
2941 },
2942 "phpbb_user_group": {
2943 "COLUMNS": {
2944 "group_id": [
2945 "UINT",
2946 0
2947 ],
2948 "user_id": [
2949 "UINT",
2950 0
2951 ],
2952 "group_leader": [
2953 "BOOL",
2954 0
2955 ],
2956 "user_pending": [
2957 "BOOL",
2958 1
2959 ]
2960 },
2961 "KEYS": {
2962 "group_id": [
2963 "INDEX",
2964 "group_id"
2965 ],
2966 "user_id": [
2967 "INDEX",
2968 "user_id"
2969 ],
2970 "group_leader": [
2971 "INDEX",
2972 "group_leader"
2973 ]
2974 }
2975 },
2976 "phpbb_user_notifications": {
2977 "COLUMNS": {
2978 "item_type": [
2979 "VCHAR:255",
2980 ""
2981 ],
2982 "item_id": [
2983 "UINT",
2984 0
2985 ],
2986 "user_id": [
2987 "UINT",
2988 0
2989 ],
2990 "method": [
2991 "VCHAR:255",
2992 ""
2993 ],
2994 "notify": [
2995 "BOOL",
2996 1
2997 ]
2998 }
2999 },
3000 "phpbb_users": {
3001 "COLUMNS": {
3002 "user_id": [
3003 "UINT",
3004 null,
3005 "auto_increment"
3006 ],
3007 "user_type": [
3008 "TINT:2",
3009 0
3010 ],
3011 "group_id": [
3012 "UINT",
3013 3
3014 ],
3015 "user_permissions": [
3016 "MTEXT",
3017 ""
3018 ],
3019 "user_perm_from": [
3020 "UINT",
3021 0
3022 ],
3023 "user_ip": [
3024 "VCHAR:40",
3025 ""
3026 ],
3027 "user_regdate": [
3028 "TIMESTAMP",
3029 0
3030 ],
3031 "username": [
3032 "VCHAR_CI",
3033 ""
3034 ],
3035 "username_clean": [
3036 "VCHAR_CI",
3037 ""
3038 ],
3039 "user_password": [
3040 "VCHAR:255",
3041 ""
3042 ],
3043 "user_passchg": [
3044 "TIMESTAMP",
3045 0
3046 ],
3047 "user_email": [
3048 "VCHAR_UNI:100",
3049 ""
3050 ],
3051 "user_email_hash": [
3052 "BINT",
3053 0
3054 ],
3055 "user_birthday": [
3056 "VCHAR:10",
3057 ""
3058 ],
3059 "user_lastvisit": [
3060 "TIMESTAMP",
3061 0
3062 ],
3063 "user_lastmark": [
3064 "TIMESTAMP",
3065 0
3066 ],
3067 "user_lastpost_time": [
3068 "TIMESTAMP",
3069 0
3070 ],
3071 "user_lastpage": [
3072 "VCHAR_UNI:200",
3073 ""
3074 ],
3075 "user_last_confirm_key": [
3076 "VCHAR:10",
3077 ""
3078 ],
3079 "user_last_search": [
3080 "TIMESTAMP",
3081 0
3082 ],
3083 "user_warnings": [
3084 "TINT:4",
3085 0
3086 ],
3087 "user_last_warning": [
3088 "TIMESTAMP",
3089 0
3090 ],
3091 "user_login_attempts": [
3092 "TINT:4",
3093 0
3094 ],
3095 "user_inactive_reason": [
3096 "TINT:2",
3097 0
3098 ],
3099 "user_inactive_time": [
3100 "TIMESTAMP",
3101 0
3102 ],
3103 "user_posts": [
3104 "UINT",
3105 0
3106 ],
3107 "user_lang": [
3108 "VCHAR:30",
3109 ""
3110 ],
3111 "user_timezone": [
3112 "VCHAR:100",
3113 ""
3114 ],
3115 "user_dateformat": [
3116 "VCHAR_UNI:30",
3117 "d M Y H:i"
3118 ],
3119 "user_style": [
3120 "UINT",
3121 0
3122 ],
3123 "user_rank": [
3124 "UINT",
3125 0
3126 ],
3127 "user_colour": [
3128 "VCHAR:6",
3129 ""
3130 ],
3131 "user_new_privmsg": [
3132 "INT:4",
3133 0
3134 ],
3135 "user_unread_privmsg": [
3136 "INT:4",
3137 0
3138 ],
3139 "user_last_privmsg": [
3140 "TIMESTAMP",
3141 0
3142 ],
3143 "user_message_rules": [
3144 "BOOL",
3145 0
3146 ],
3147 "user_full_folder": [
3148 "INT:11",
3149 -3
3150 ],
3151 "user_emailtime": [
3152 "TIMESTAMP",
3153 0
3154 ],
3155 "user_topic_show_days": [
3156 "USINT",
3157 0
3158 ],
3159 "user_topic_sortby_type": [
3160 "VCHAR:1",
3161 "t"
3162 ],
3163 "user_topic_sortby_dir": [
3164 "VCHAR:1",
3165 "d"
3166 ],
3167 "user_post_show_days": [
3168 "USINT",
3169 0
3170 ],
3171 "user_post_sortby_type": [
3172 "VCHAR:1",
3173 "t"
3174 ],
3175 "user_post_sortby_dir": [
3176 "VCHAR:1",
3177 "a"
3178 ],
3179 "user_notify": [
3180 "BOOL",
3181 0
3182 ],
3183 "user_notify_pm": [
3184 "BOOL",
3185 1
3186 ],
3187 "user_notify_type": [
3188 "TINT:4",
3189 0
3190 ],
3191 "user_allow_pm": [
3192 "BOOL",
3193 1
3194 ],
3195 "user_allow_viewonline": [
3196 "BOOL",
3197 1
3198 ],
3199 "user_allow_viewemail": [
3200 "BOOL",
3201 1
3202 ],
3203 "user_allow_massemail": [
3204 "BOOL",
3205 1
3206 ],
3207 "user_options": [
3208 "UINT:11",
3209 230271
3210 ],
3211 "user_avatar": [
3212 "VCHAR",
3213 ""
3214 ],
3215 "user_avatar_type": [
3216 "VCHAR:255",
3217 ""
3218 ],
3219 "user_avatar_width": [
3220 "USINT",
3221 0
3222 ],
3223 "user_avatar_height": [
3224 "USINT",
3225 0
3226 ],
3227 "user_sig": [
3228 "MTEXT_UNI",
3229 ""
3230 ],
3231 "user_sig_bbcode_uid": [
3232 "VCHAR:8",
3233 ""
3234 ],
3235 "user_sig_bbcode_bitfield": [
3236 "VCHAR:255",
3237 ""
3238 ],
3239 "user_jabber": [
3240 "VCHAR_UNI",
3241 ""
3242 ],
3243 "user_actkey": [
3244 "VCHAR:32",
3245 ""
3246 ],
3247 "user_newpasswd": [
3248 "VCHAR:255",
3249 ""
3250 ],
3251 "user_form_salt": [
3252 "VCHAR_UNI:32",
3253 ""
3254 ],
3255 "user_new": [
3256 "BOOL",
3257 1
3258 ],
3259 "user_reminded": [
3260 "TINT:4",
3261 0
3262 ],
3263 "user_reminded_time": [
3264 "TIMESTAMP",
3265 0
3266 ]
3267 },
3268 "PRIMARY_KEY": "user_id",
3269 "KEYS": {
3270 "user_birthday": [
3271 "INDEX",
3272 "user_birthday"
3273 ],
3274 "user_email_hash": [
3275 "INDEX",
3276 "user_email_hash"
3277 ],
3278 "user_type": [
3279 "INDEX",
3280 "user_type"
3281 ],
3282 "username_clean": [
3283 "UNIQUE",
3284 "username_clean"
3285 ]
3286 }
3287 },
3288 "phpbb_warnings": {
3289 "COLUMNS": {
3290 "warning_id": [
3291 "UINT",
3292 null,
3293 "auto_increment"
3294 ],
3295 "user_id": [
3296 "UINT",
3297 0
3298 ],
3299 "post_id": [
3300 "UINT",
3301 0
3302 ],
3303 "log_id": [
3304 "UINT",
3305 0
3306 ],
3307 "warning_time": [
3308 "TIMESTAMP",
3309 0
3310 ]
3311 },
3312 "PRIMARY_KEY": "warning_id"
3313 },
3314 "phpbb_words": {
3315 "COLUMNS": {
3316 "word_id": [
3317 "UINT",
3318 null,
3319 "auto_increment"
3320 ],
3321 "word": [
3322 "VCHAR_UNI",
3323 ""
3324 ],
3325 "replacement": [
3326 "VCHAR_UNI",
3327 ""
3328 ]
3329 },
3330 "PRIMARY_KEY": "word_id"
3331 },
3332 "phpbb_zebra": {
3333 "COLUMNS": {
3334 "user_id": [
3335 "UINT",
3336 0
3337 ],
3338 "zebra_id": [
3339 "UINT",
3340 0
3341 ],
3342 "friend": [
3343 "BOOL",
3344 0
3345 ],
3346 "foe": [
3347 "BOOL",
3348 0
3349 ]
3350 },
3351 "PRIMARY_KEY": [
3352 "user_id",
3353 "zebra_id"
3354 ]
3355 }
3356 }