Verzeichnisstruktur phpBB-3.3.15
- Veröffentlicht
- 28.08.2024
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 "ULINT",
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 "ULINT",
0178 null,
0179 "auto_increment"
0180 ],
0181 "post_msg_id": [
0182 "ULINT",
0183 0
0184 ],
0185 "topic_id": [
0186 "ULINT",
0187 0
0188 ],
0189 "in_message": [
0190 "BOOL",
0191 0
0192 ],
0193 "poster_id": [
0194 "ULINT",
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 "ULINT",
0266 null,
0267 "auto_increment"
0268 ],
0269 "ban_userid": [
0270 "ULINT",
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 "TEXT_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 "ULINT",
0386 0
0387 ],
0388 "user_id": [
0389 "ULINT",
0390 0
0391 ]
0392 },
0393 "PRIMARY_KEY": [
0394 "topic_id",
0395 "user_id"
0396 ]
0397 },
0398 "phpbb_bots": {
0399 "COLUMNS": {
0400 "bot_id": [
0401 "ULINT",
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 "ULINT",
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 "ULINT",
0526 null,
0527 "auto_increment"
0528 ],
0529 "user_id": [
0530 "ULINT",
0531 0
0532 ],
0533 "topic_id": [
0534 "ULINT",
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 "USINT",
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 "ULINT",
0737 0
0738 ],
0739 "forum_last_poster_id": [
0740 "ULINT",
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 "display_subforum_limit": [
0800 "BOOL",
0801 0
0802 ],
0803 "forum_options": [
0804 "UINT:20",
0805 0
0806 ],
0807 "enable_shadow_prune": [
0808 "BOOL",
0809 0
0810 ],
0811 "prune_shadow_days": [
0812 "UINT",
0813 7
0814 ],
0815 "prune_shadow_freq": [
0816 "UINT",
0817 1
0818 ],
0819 "prune_shadow_next": [
0820 "INT:11",
0821 0
0822 ],
0823 "forum_posts_approved": [
0824 "UINT",
0825 0
0826 ],
0827 "forum_posts_unapproved": [
0828 "UINT",
0829 0
0830 ],
0831 "forum_posts_softdeleted": [
0832 "UINT",
0833 0
0834 ],
0835 "forum_topics_approved": [
0836 "UINT",
0837 0
0838 ],
0839 "forum_topics_unapproved": [
0840 "UINT",
0841 0
0842 ],
0843 "forum_topics_softdeleted": [
0844 "UINT",
0845 0
0846 ]
0847 },
0848 "PRIMARY_KEY": "forum_id",
0849 "KEYS": {
0850 "left_right_id": [
0851 "INDEX",
0852 [
0853 "left_id",
0854 "right_id"
0855 ]
0856 ],
0857 "forum_lastpost_id": [
0858 "INDEX",
0859 "forum_last_post_id"
0860 ]
0861 }
0862 },
0863 "phpbb_forums_access": {
0864 "COLUMNS": {
0865 "forum_id": [
0866 "UINT",
0867 0
0868 ],
0869 "user_id": [
0870 "ULINT",
0871 0
0872 ],
0873 "session_id": [
0874 "CHAR:32",
0875 ""
0876 ]
0877 },
0878 "PRIMARY_KEY": [
0879 "forum_id",
0880 "user_id",
0881 "session_id"
0882 ]
0883 },
0884 "phpbb_forums_track": {
0885 "COLUMNS": {
0886 "user_id": [
0887 "ULINT",
0888 0
0889 ],
0890 "forum_id": [
0891 "UINT",
0892 0
0893 ],
0894 "mark_time": [
0895 "TIMESTAMP",
0896 0
0897 ]
0898 },
0899 "PRIMARY_KEY": [
0900 "user_id",
0901 "forum_id"
0902 ]
0903 },
0904 "phpbb_forums_watch": {
0905 "COLUMNS": {
0906 "forum_id": [
0907 "UINT",
0908 0
0909 ],
0910 "user_id": [
0911 "ULINT",
0912 0
0913 ],
0914 "notify_status": [
0915 "BOOL",
0916 0
0917 ]
0918 },
0919 "KEYS": {
0920 "forum_id": [
0921 "INDEX",
0922 "forum_id"
0923 ],
0924 "user_id": [
0925 "INDEX",
0926 "user_id"
0927 ],
0928 "notify_stat": [
0929 "INDEX",
0930 "notify_status"
0931 ]
0932 }
0933 },
0934 "phpbb_groups": {
0935 "COLUMNS": {
0936 "group_id": [
0937 "UINT",
0938 null,
0939 "auto_increment"
0940 ],
0941 "group_type": [
0942 "TINT:4",
0943 1
0944 ],
0945 "group_founder_manage": [
0946 "BOOL",
0947 0
0948 ],
0949 "group_skip_auth": [
0950 "BOOL",
0951 0
0952 ],
0953 "group_name": [
0954 "VCHAR_CI",
0955 ""
0956 ],
0957 "group_desc": [
0958 "TEXT_UNI",
0959 ""
0960 ],
0961 "group_desc_bitfield": [
0962 "VCHAR:255",
0963 ""
0964 ],
0965 "group_desc_options": [
0966 "UINT:11",
0967 7
0968 ],
0969 "group_desc_uid": [
0970 "VCHAR:8",
0971 ""
0972 ],
0973 "group_display": [
0974 "BOOL",
0975 0
0976 ],
0977 "group_avatar": [
0978 "VCHAR",
0979 ""
0980 ],
0981 "group_avatar_type": [
0982 "VCHAR:255",
0983 ""
0984 ],
0985 "group_avatar_width": [
0986 "USINT",
0987 0
0988 ],
0989 "group_avatar_height": [
0990 "USINT",
0991 0
0992 ],
0993 "group_rank": [
0994 "UINT",
0995 0
0996 ],
0997 "group_colour": [
0998 "VCHAR:6",
0999 ""
1000 ],
1001 "group_sig_chars": [
1002 "UINT",
1003 0
1004 ],
1005 "group_receive_pm": [
1006 "BOOL",
1007 0
1008 ],
1009 "group_message_limit": [
1010 "UINT",
1011 0
1012 ],
1013 "group_legend": [
1014 "UINT",
1015 0
1016 ],
1017 "group_max_recipients": [
1018 "UINT",
1019 0
1020 ]
1021 },
1022 "PRIMARY_KEY": "group_id",
1023 "KEYS": {
1024 "group_legend_name": [
1025 "INDEX",
1026 [
1027 "group_legend",
1028 "group_name"
1029 ]
1030 ]
1031 }
1032 },
1033 "phpbb_icons": {
1034 "COLUMNS": {
1035 "icons_id": [
1036 "UINT",
1037 null,
1038 "auto_increment"
1039 ],
1040 "icons_url": [
1041 "VCHAR",
1042 ""
1043 ],
1044 "icons_width": [
1045 "TINT:4",
1046 0
1047 ],
1048 "icons_height": [
1049 "TINT:4",
1050 0
1051 ],
1052 "icons_alt": [
1053 "VCHAR",
1054 ""
1055 ],
1056 "icons_order": [
1057 "UINT",
1058 0
1059 ],
1060 "display_on_posting": [
1061 "BOOL",
1062 1
1063 ]
1064 },
1065 "PRIMARY_KEY": "icons_id",
1066 "KEYS": {
1067 "display_on_posting": [
1068 "INDEX",
1069 "display_on_posting"
1070 ]
1071 }
1072 },
1073 "phpbb_lang": {
1074 "COLUMNS": {
1075 "lang_id": [
1076 "TINT:4",
1077 null,
1078 "auto_increment"
1079 ],
1080 "lang_iso": [
1081 "VCHAR:30",
1082 ""
1083 ],
1084 "lang_dir": [
1085 "VCHAR:30",
1086 ""
1087 ],
1088 "lang_english_name": [
1089 "VCHAR_UNI:100",
1090 ""
1091 ],
1092 "lang_local_name": [
1093 "VCHAR_UNI:255",
1094 ""
1095 ],
1096 "lang_author": [
1097 "VCHAR_UNI:255",
1098 ""
1099 ]
1100 },
1101 "PRIMARY_KEY": "lang_id",
1102 "KEYS": {
1103 "lang_iso": [
1104 "INDEX",
1105 "lang_iso"
1106 ]
1107 }
1108 },
1109 "phpbb_log": {
1110 "COLUMNS": {
1111 "log_id": [
1112 "ULINT",
1113 null,
1114 "auto_increment"
1115 ],
1116 "log_type": [
1117 "TINT:4",
1118 0
1119 ],
1120 "user_id": [
1121 "ULINT",
1122 0
1123 ],
1124 "forum_id": [
1125 "UINT",
1126 0
1127 ],
1128 "topic_id": [
1129 "ULINT",
1130 0
1131 ],
1132 "post_id": [
1133 "ULINT",
1134 0
1135 ],
1136 "reportee_id": [
1137 "ULINT",
1138 0
1139 ],
1140 "log_ip": [
1141 "VCHAR:40",
1142 ""
1143 ],
1144 "log_time": [
1145 "TIMESTAMP",
1146 0
1147 ],
1148 "log_operation": [
1149 "TEXT_UNI",
1150 ""
1151 ],
1152 "log_data": [
1153 "MTEXT_UNI",
1154 ""
1155 ]
1156 },
1157 "PRIMARY_KEY": "log_id",
1158 "KEYS": {
1159 "log_type": [
1160 "INDEX",
1161 "log_type"
1162 ],
1163 "forum_id": [
1164 "INDEX",
1165 "forum_id"
1166 ],
1167 "topic_id": [
1168 "INDEX",
1169 "topic_id"
1170 ],
1171 "reportee_id": [
1172 "INDEX",
1173 "reportee_id"
1174 ],
1175 "user_id": [
1176 "INDEX",
1177 "user_id"
1178 ],
1179 "log_time": [
1180 "INDEX",
1181 [
1182 "log_time"
1183 ]
1184 ]
1185 }
1186 },
1187 "phpbb_login_attempts": {
1188 "COLUMNS": {
1189 "attempt_ip": [
1190 "VCHAR:40",
1191 ""
1192 ],
1193 "attempt_browser": [
1194 "VCHAR:150",
1195 ""
1196 ],
1197 "attempt_forwarded_for": [
1198 "VCHAR:255",
1199 ""
1200 ],
1201 "attempt_time": [
1202 "TIMESTAMP",
1203 0
1204 ],
1205 "user_id": [
1206 "ULINT",
1207 0
1208 ],
1209 "username": [
1210 "VCHAR_UNI:255",
1211 0
1212 ],
1213 "username_clean": [
1214 "VCHAR_CI",
1215 0
1216 ]
1217 },
1218 "KEYS": {
1219 "att_ip": [
1220 "INDEX",
1221 [
1222 "attempt_ip",
1223 "attempt_time"
1224 ]
1225 ],
1226 "att_for": [
1227 "INDEX",
1228 [
1229 "attempt_forwarded_for",
1230 "attempt_time"
1231 ]
1232 ],
1233 "att_time": [
1234 "INDEX",
1235 [
1236 "attempt_time"
1237 ]
1238 ],
1239 "user_id": [
1240 "INDEX",
1241 "user_id"
1242 ]
1243 }
1244 },
1245 "phpbb_migrations": {
1246 "COLUMNS": {
1247 "migration_name": [
1248 "VCHAR",
1249 ""
1250 ],
1251 "migration_depends_on": [
1252 "TEXT",
1253 ""
1254 ],
1255 "migration_schema_done": [
1256 "BOOL",
1257 0
1258 ],
1259 "migration_data_done": [
1260 "BOOL",
1261 0
1262 ],
1263 "migration_data_state": [
1264 "TEXT",
1265 ""
1266 ],
1267 "migration_start_time": [
1268 "TIMESTAMP",
1269 0
1270 ],
1271 "migration_end_time": [
1272 "TIMESTAMP",
1273 0
1274 ]
1275 },
1276 "PRIMARY_KEY": "migration_name"
1277 },
1278 "phpbb_moderator_cache": {
1279 "COLUMNS": {
1280 "forum_id": [
1281 "UINT",
1282 0
1283 ],
1284 "user_id": [
1285 "ULINT",
1286 0
1287 ],
1288 "username": [
1289 "VCHAR_UNI:255",
1290 ""
1291 ],
1292 "group_id": [
1293 "UINT",
1294 0
1295 ],
1296 "group_name": [
1297 "VCHAR_UNI",
1298 ""
1299 ],
1300 "display_on_index": [
1301 "BOOL",
1302 1
1303 ]
1304 },
1305 "KEYS": {
1306 "disp_idx": [
1307 "INDEX",
1308 "display_on_index"
1309 ],
1310 "forum_id": [
1311 "INDEX",
1312 "forum_id"
1313 ]
1314 }
1315 },
1316 "phpbb_modules": {
1317 "COLUMNS": {
1318 "module_id": [
1319 "UINT",
1320 null,
1321 "auto_increment"
1322 ],
1323 "module_enabled": [
1324 "BOOL",
1325 1
1326 ],
1327 "module_display": [
1328 "BOOL",
1329 1
1330 ],
1331 "module_basename": [
1332 "VCHAR",
1333 ""
1334 ],
1335 "module_class": [
1336 "VCHAR:10",
1337 ""
1338 ],
1339 "parent_id": [
1340 "UINT",
1341 0
1342 ],
1343 "left_id": [
1344 "UINT",
1345 0
1346 ],
1347 "right_id": [
1348 "UINT",
1349 0
1350 ],
1351 "module_langname": [
1352 "VCHAR",
1353 ""
1354 ],
1355 "module_mode": [
1356 "VCHAR",
1357 ""
1358 ],
1359 "module_auth": [
1360 "VCHAR",
1361 ""
1362 ]
1363 },
1364 "PRIMARY_KEY": "module_id",
1365 "KEYS": {
1366 "left_right_id": [
1367 "INDEX",
1368 [
1369 "left_id",
1370 "right_id"
1371 ]
1372 ],
1373 "module_enabled": [
1374 "INDEX",
1375 "module_enabled"
1376 ],
1377 "class_left_id": [
1378 "INDEX",
1379 [
1380 "module_class",
1381 "left_id"
1382 ]
1383 ]
1384 }
1385 },
1386 "phpbb_notification_emails": {
1387 "COLUMNS": {
1388 "notification_type_id": [
1389 "USINT",
1390 0
1391 ],
1392 "item_id": [
1393 "ULINT",
1394 0
1395 ],
1396 "item_parent_id": [
1397 "ULINT",
1398 0
1399 ],
1400 "user_id": [
1401 "ULINT",
1402 0
1403 ]
1404 },
1405 "PRIMARY_KEY": [
1406 "notification_type_id",
1407 "item_id",
1408 "item_parent_id",
1409 "user_id"
1410 ]
1411 },
1412 "phpbb_notification_types": {
1413 "COLUMNS": {
1414 "notification_type_id": [
1415 "USINT",
1416 null,
1417 "auto_increment"
1418 ],
1419 "notification_type_name": [
1420 "VCHAR:255",
1421 ""
1422 ],
1423 "notification_type_enabled": [
1424 "BOOL",
1425 1
1426 ]
1427 },
1428 "PRIMARY_KEY": [
1429 "notification_type_id"
1430 ],
1431 "KEYS": {
1432 "type": [
1433 "UNIQUE",
1434 [
1435 "notification_type_name"
1436 ]
1437 ]
1438 }
1439 },
1440 "phpbb_notifications": {
1441 "COLUMNS": {
1442 "notification_id": [
1443 "UINT:10",
1444 null,
1445 "auto_increment"
1446 ],
1447 "notification_type_id": [
1448 "USINT",
1449 0
1450 ],
1451 "item_id": [
1452 "UINT",
1453 0
1454 ],
1455 "item_parent_id": [
1456 "UINT",
1457 0
1458 ],
1459 "user_id": [
1460 "ULINT",
1461 0
1462 ],
1463 "notification_read": [
1464 "BOOL",
1465 0
1466 ],
1467 "notification_time": [
1468 "TIMESTAMP",
1469 1
1470 ],
1471 "notification_data": [
1472 "TEXT_UNI",
1473 ""
1474 ]
1475 },
1476 "PRIMARY_KEY": "notification_id",
1477 "KEYS": {
1478 "item_ident": [
1479 "INDEX",
1480 [
1481 "notification_type_id",
1482 "item_id"
1483 ]
1484 ],
1485 "user": [
1486 "INDEX",
1487 [
1488 "user_id",
1489 "notification_read"
1490 ]
1491 ]
1492 }
1493 },
1494 "phpbb_oauth_accounts": {
1495 "COLUMNS": {
1496 "user_id": [
1497 "ULINT",
1498 0
1499 ],
1500 "provider": [
1501 "VCHAR",
1502 ""
1503 ],
1504 "oauth_provider_id": [
1505 "TEXT_UNI",
1506 ""
1507 ]
1508 },
1509 "PRIMARY_KEY": [
1510 "user_id",
1511 "provider"
1512 ]
1513 },
1514 "phpbb_oauth_states": {
1515 "COLUMNS": {
1516 "user_id": [
1517 "ULINT",
1518 0
1519 ],
1520 "session_id": [
1521 "CHAR:32",
1522 ""
1523 ],
1524 "provider": [
1525 "VCHAR",
1526 ""
1527 ],
1528 "oauth_state": [
1529 "VCHAR",
1530 ""
1531 ]
1532 },
1533 "KEYS": {
1534 "user_id": [
1535 "INDEX",
1536 "user_id"
1537 ],
1538 "provider": [
1539 "INDEX",
1540 "provider"
1541 ]
1542 }
1543 },
1544 "phpbb_oauth_tokens": {
1545 "COLUMNS": {
1546 "user_id": [
1547 "ULINT",
1548 0
1549 ],
1550 "session_id": [
1551 "CHAR:32",
1552 ""
1553 ],
1554 "provider": [
1555 "VCHAR",
1556 ""
1557 ],
1558 "oauth_token": [
1559 "MTEXT",
1560 ""
1561 ]
1562 },
1563 "KEYS": {
1564 "user_id": [
1565 "INDEX",
1566 "user_id"
1567 ],
1568 "provider": [
1569 "INDEX",
1570 "provider"
1571 ]
1572 }
1573 },
1574 "phpbb_poll_options": {
1575 "COLUMNS": {
1576 "poll_option_id": [
1577 "TINT:4",
1578 0
1579 ],
1580 "topic_id": [
1581 "ULINT",
1582 0
1583 ],
1584 "poll_option_text": [
1585 "TEXT_UNI",
1586 ""
1587 ],
1588 "poll_option_total": [
1589 "UINT",
1590 0
1591 ]
1592 },
1593 "KEYS": {
1594 "poll_opt_id": [
1595 "INDEX",
1596 "poll_option_id"
1597 ],
1598 "topic_id": [
1599 "INDEX",
1600 "topic_id"
1601 ]
1602 }
1603 },
1604 "phpbb_poll_votes": {
1605 "COLUMNS": {
1606 "topic_id": [
1607 "ULINT",
1608 0
1609 ],
1610 "poll_option_id": [
1611 "TINT:4",
1612 0
1613 ],
1614 "vote_user_id": [
1615 "ULINT",
1616 0
1617 ],
1618 "vote_user_ip": [
1619 "VCHAR:40",
1620 ""
1621 ]
1622 },
1623 "KEYS": {
1624 "topic_id": [
1625 "INDEX",
1626 "topic_id"
1627 ],
1628 "vote_user_id": [
1629 "INDEX",
1630 "vote_user_id"
1631 ],
1632 "vote_user_ip": [
1633 "INDEX",
1634 "vote_user_ip"
1635 ]
1636 }
1637 },
1638 "phpbb_posts": {
1639 "COLUMNS": {
1640 "post_id": [
1641 "ULINT",
1642 null,
1643 "auto_increment"
1644 ],
1645 "topic_id": [
1646 "ULINT",
1647 0
1648 ],
1649 "forum_id": [
1650 "UINT",
1651 0
1652 ],
1653 "poster_id": [
1654 "ULINT",
1655 0
1656 ],
1657 "icon_id": [
1658 "UINT",
1659 0
1660 ],
1661 "poster_ip": [
1662 "VCHAR:40",
1663 ""
1664 ],
1665 "post_time": [
1666 "TIMESTAMP",
1667 0
1668 ],
1669 "post_reported": [
1670 "BOOL",
1671 0
1672 ],
1673 "enable_bbcode": [
1674 "BOOL",
1675 1
1676 ],
1677 "enable_smilies": [
1678 "BOOL",
1679 1
1680 ],
1681 "enable_magic_url": [
1682 "BOOL",
1683 1
1684 ],
1685 "enable_sig": [
1686 "BOOL",
1687 1
1688 ],
1689 "post_username": [
1690 "VCHAR_UNI:255",
1691 ""
1692 ],
1693 "post_subject": [
1694 "STEXT_UNI",
1695 "",
1696 "true_sort"
1697 ],
1698 "post_text": [
1699 "MTEXT_UNI",
1700 ""
1701 ],
1702 "post_checksum": [
1703 "VCHAR:32",
1704 ""
1705 ],
1706 "post_attachment": [
1707 "BOOL",
1708 0
1709 ],
1710 "bbcode_bitfield": [
1711 "VCHAR:255",
1712 ""
1713 ],
1714 "bbcode_uid": [
1715 "VCHAR:8",
1716 ""
1717 ],
1718 "post_postcount": [
1719 "BOOL",
1720 1
1721 ],
1722 "post_edit_time": [
1723 "TIMESTAMP",
1724 0
1725 ],
1726 "post_edit_reason": [
1727 "STEXT_UNI",
1728 ""
1729 ],
1730 "post_edit_user": [
1731 "ULINT",
1732 0
1733 ],
1734 "post_edit_count": [
1735 "USINT",
1736 0
1737 ],
1738 "post_edit_locked": [
1739 "BOOL",
1740 0
1741 ],
1742 "post_visibility": [
1743 "TINT:3",
1744 0
1745 ],
1746 "post_delete_time": [
1747 "TIMESTAMP",
1748 0
1749 ],
1750 "post_delete_reason": [
1751 "STEXT_UNI",
1752 ""
1753 ],
1754 "post_delete_user": [
1755 "ULINT",
1756 0
1757 ]
1758 },
1759 "PRIMARY_KEY": "post_id",
1760 "KEYS": {
1761 "forum_id": [
1762 "INDEX",
1763 "forum_id"
1764 ],
1765 "topic_id": [
1766 "INDEX",
1767 "topic_id"
1768 ],
1769 "poster_ip": [
1770 "INDEX",
1771 "poster_ip"
1772 ],
1773 "poster_id": [
1774 "INDEX",
1775 "poster_id"
1776 ],
1777 "tid_post_time": [
1778 "INDEX",
1779 [
1780 "topic_id",
1781 "post_time"
1782 ]
1783 ],
1784 "post_username": [
1785 "INDEX",
1786 [
1787 "post_username:255"
1788 ]
1789 ],
1790 "post_visibility": [
1791 "INDEX",
1792 [
1793 "post_visibility"
1794 ]
1795 ]
1796 }
1797 },
1798 "phpbb_privmsgs": {
1799 "COLUMNS": {
1800 "msg_id": [
1801 "ULINT",
1802 null,
1803 "auto_increment"
1804 ],
1805 "root_level": [
1806 "UINT",
1807 0
1808 ],
1809 "author_id": [
1810 "ULINT",
1811 0
1812 ],
1813 "icon_id": [
1814 "UINT",
1815 0
1816 ],
1817 "author_ip": [
1818 "VCHAR:40",
1819 ""
1820 ],
1821 "message_time": [
1822 "TIMESTAMP",
1823 0
1824 ],
1825 "enable_bbcode": [
1826 "BOOL",
1827 1
1828 ],
1829 "enable_smilies": [
1830 "BOOL",
1831 1
1832 ],
1833 "enable_magic_url": [
1834 "BOOL",
1835 1
1836 ],
1837 "enable_sig": [
1838 "BOOL",
1839 1
1840 ],
1841 "message_subject": [
1842 "STEXT_UNI",
1843 ""
1844 ],
1845 "message_text": [
1846 "MTEXT_UNI",
1847 ""
1848 ],
1849 "message_edit_reason": [
1850 "STEXT_UNI",
1851 ""
1852 ],
1853 "message_edit_user": [
1854 "ULINT",
1855 0
1856 ],
1857 "message_attachment": [
1858 "BOOL",
1859 0
1860 ],
1861 "bbcode_bitfield": [
1862 "VCHAR:255",
1863 ""
1864 ],
1865 "bbcode_uid": [
1866 "VCHAR:8",
1867 ""
1868 ],
1869 "message_edit_time": [
1870 "TIMESTAMP",
1871 0
1872 ],
1873 "message_edit_count": [
1874 "USINT",
1875 0
1876 ],
1877 "to_address": [
1878 "TEXT_UNI",
1879 ""
1880 ],
1881 "bcc_address": [
1882 "TEXT_UNI",
1883 ""
1884 ],
1885 "message_reported": [
1886 "BOOL",
1887 0
1888 ]
1889 },
1890 "PRIMARY_KEY": "msg_id",
1891 "KEYS": {
1892 "author_ip": [
1893 "INDEX",
1894 "author_ip"
1895 ],
1896 "message_time": [
1897 "INDEX",
1898 "message_time"
1899 ],
1900 "author_id": [
1901 "INDEX",
1902 "author_id"
1903 ],
1904 "root_level": [
1905 "INDEX",
1906 "root_level"
1907 ]
1908 }
1909 },
1910 "phpbb_privmsgs_folder": {
1911 "COLUMNS": {
1912 "folder_id": [
1913 "UINT",
1914 null,
1915 "auto_increment"
1916 ],
1917 "user_id": [
1918 "ULINT",
1919 0
1920 ],
1921 "folder_name": [
1922 "VCHAR_UNI",
1923 ""
1924 ],
1925 "pm_count": [
1926 "UINT",
1927 0
1928 ]
1929 },
1930 "PRIMARY_KEY": "folder_id",
1931 "KEYS": {
1932 "user_id": [
1933 "INDEX",
1934 "user_id"
1935 ]
1936 }
1937 },
1938 "phpbb_privmsgs_rules": {
1939 "COLUMNS": {
1940 "rule_id": [
1941 "UINT",
1942 null,
1943 "auto_increment"
1944 ],
1945 "user_id": [
1946 "ULINT",
1947 0
1948 ],
1949 "rule_check": [
1950 "UINT",
1951 0
1952 ],
1953 "rule_connection": [
1954 "UINT",
1955 0
1956 ],
1957 "rule_string": [
1958 "VCHAR_UNI",
1959 ""
1960 ],
1961 "rule_user_id": [
1962 "ULINT",
1963 0
1964 ],
1965 "rule_group_id": [
1966 "UINT",
1967 0
1968 ],
1969 "rule_action": [
1970 "UINT",
1971 0
1972 ],
1973 "rule_folder_id": [
1974 "INT:11",
1975 0
1976 ]
1977 },
1978 "PRIMARY_KEY": "rule_id",
1979 "KEYS": {
1980 "user_id": [
1981 "INDEX",
1982 "user_id"
1983 ]
1984 }
1985 },
1986 "phpbb_privmsgs_to": {
1987 "COLUMNS": {
1988 "msg_id": [
1989 "ULINT",
1990 0
1991 ],
1992 "user_id": [
1993 "ULINT",
1994 0
1995 ],
1996 "author_id": [
1997 "ULINT",
1998 0
1999 ],
2000 "pm_deleted": [
2001 "BOOL",
2002 0
2003 ],
2004 "pm_new": [
2005 "BOOL",
2006 1
2007 ],
2008 "pm_unread": [
2009 "BOOL",
2010 1
2011 ],
2012 "pm_replied": [
2013 "BOOL",
2014 0
2015 ],
2016 "pm_marked": [
2017 "BOOL",
2018 0
2019 ],
2020 "pm_forwarded": [
2021 "BOOL",
2022 0
2023 ],
2024 "folder_id": [
2025 "INT:11",
2026 0
2027 ]
2028 },
2029 "KEYS": {
2030 "msg_id": [
2031 "INDEX",
2032 "msg_id"
2033 ],
2034 "author_id": [
2035 "INDEX",
2036 "author_id"
2037 ],
2038 "usr_flder_id": [
2039 "INDEX",
2040 [
2041 "user_id",
2042 "folder_id"
2043 ]
2044 ]
2045 }
2046 },
2047 "phpbb_profile_fields": {
2048 "COLUMNS": {
2049 "field_id": [
2050 "UINT",
2051 null,
2052 "auto_increment"
2053 ],
2054 "field_name": [
2055 "VCHAR_UNI",
2056 ""
2057 ],
2058 "field_type": [
2059 "VCHAR:100",
2060 ""
2061 ],
2062 "field_ident": [
2063 "VCHAR:20",
2064 ""
2065 ],
2066 "field_length": [
2067 "VCHAR:20",
2068 ""
2069 ],
2070 "field_minlen": [
2071 "VCHAR",
2072 ""
2073 ],
2074 "field_maxlen": [
2075 "VCHAR",
2076 ""
2077 ],
2078 "field_novalue": [
2079 "VCHAR_UNI",
2080 ""
2081 ],
2082 "field_default_value": [
2083 "VCHAR_UNI",
2084 ""
2085 ],
2086 "field_validation": [
2087 "VCHAR_UNI:128",
2088 ""
2089 ],
2090 "field_required": [
2091 "BOOL",
2092 0
2093 ],
2094 "field_show_on_reg": [
2095 "BOOL",
2096 0
2097 ],
2098 "field_hide": [
2099 "BOOL",
2100 0
2101 ],
2102 "field_no_view": [
2103 "BOOL",
2104 0
2105 ],
2106 "field_active": [
2107 "BOOL",
2108 0
2109 ],
2110 "field_order": [
2111 "UINT",
2112 0
2113 ],
2114 "field_show_profile": [
2115 "BOOL",
2116 0
2117 ],
2118 "field_show_on_vt": [
2119 "BOOL",
2120 0
2121 ],
2122 "field_show_novalue": [
2123 "BOOL",
2124 0
2125 ],
2126 "field_show_on_pm": [
2127 "BOOL",
2128 0
2129 ],
2130 "field_show_on_ml": [
2131 "BOOL",
2132 0
2133 ],
2134 "field_is_contact": [
2135 "BOOL",
2136 0
2137 ],
2138 "field_contact_desc": [
2139 "VCHAR",
2140 ""
2141 ],
2142 "field_contact_url": [
2143 "VCHAR",
2144 ""
2145 ]
2146 },
2147 "PRIMARY_KEY": "field_id",
2148 "KEYS": {
2149 "fld_type": [
2150 "INDEX",
2151 "field_type"
2152 ],
2153 "fld_ordr": [
2154 "INDEX",
2155 "field_order"
2156 ]
2157 }
2158 },
2159 "phpbb_profile_fields_data": {
2160 "COLUMNS": {
2161 "user_id": [
2162 "ULINT",
2163 0
2164 ],
2165 "pf_phpbb_interests": [
2166 "MTEXT",
2167 ""
2168 ],
2169 "pf_phpbb_occupation": [
2170 "MTEXT",
2171 ""
2172 ],
2173 "pf_phpbb_location": [
2174 "VCHAR",
2175 ""
2176 ],
2177 "pf_phpbb_facebook": [
2178 "VCHAR",
2179 ""
2180 ],
2181 "pf_phpbb_icq": [
2182 "VCHAR",
2183 ""
2184 ],
2185 "pf_phpbb_skype": [
2186 "VCHAR",
2187 ""
2188 ],
2189 "pf_phpbb_twitter": [
2190 "VCHAR",
2191 ""
2192 ],
2193 "pf_phpbb_youtube": [
2194 "VCHAR",
2195 ""
2196 ],
2197 "pf_phpbb_website": [
2198 "VCHAR",
2199 ""
2200 ],
2201 "pf_phpbb_yahoo": [
2202 "VCHAR",
2203 ""
2204 ]
2205 },
2206 "PRIMARY_KEY": "user_id"
2207 },
2208 "phpbb_profile_fields_lang": {
2209 "COLUMNS": {
2210 "field_id": [
2211 "UINT",
2212 0
2213 ],
2214 "lang_id": [
2215 "UINT",
2216 0
2217 ],
2218 "option_id": [
2219 "UINT",
2220 0
2221 ],
2222 "field_type": [
2223 "VCHAR:100",
2224 ""
2225 ],
2226 "lang_value": [
2227 "VCHAR_UNI",
2228 ""
2229 ]
2230 },
2231 "PRIMARY_KEY": [
2232 "field_id",
2233 "lang_id",
2234 "option_id"
2235 ]
2236 },
2237 "phpbb_profile_lang": {
2238 "COLUMNS": {
2239 "field_id": [
2240 "UINT",
2241 0
2242 ],
2243 "lang_id": [
2244 "UINT",
2245 0
2246 ],
2247 "lang_name": [
2248 "VCHAR_UNI",
2249 ""
2250 ],
2251 "lang_explain": [
2252 "TEXT_UNI",
2253 ""
2254 ],
2255 "lang_default_value": [
2256 "VCHAR_UNI",
2257 ""
2258 ]
2259 },
2260 "PRIMARY_KEY": [
2261 "field_id",
2262 "lang_id"
2263 ]
2264 },
2265 "phpbb_ranks": {
2266 "COLUMNS": {
2267 "rank_id": [
2268 "UINT",
2269 null,
2270 "auto_increment"
2271 ],
2272 "rank_title": [
2273 "VCHAR_UNI",
2274 ""
2275 ],
2276 "rank_min": [
2277 "UINT",
2278 0
2279 ],
2280 "rank_special": [
2281 "BOOL",
2282 0
2283 ],
2284 "rank_image": [
2285 "VCHAR",
2286 ""
2287 ]
2288 },
2289 "PRIMARY_KEY": "rank_id"
2290 },
2291 "phpbb_reports": {
2292 "COLUMNS": {
2293 "report_id": [
2294 "ULINT",
2295 null,
2296 "auto_increment"
2297 ],
2298 "reason_id": [
2299 "USINT",
2300 0
2301 ],
2302 "post_id": [
2303 "ULINT",
2304 0
2305 ],
2306 "user_id": [
2307 "ULINT",
2308 0
2309 ],
2310 "user_notify": [
2311 "BOOL",
2312 0
2313 ],
2314 "report_closed": [
2315 "BOOL",
2316 0
2317 ],
2318 "report_time": [
2319 "TIMESTAMP",
2320 0
2321 ],
2322 "report_text": [
2323 "MTEXT_UNI",
2324 ""
2325 ],
2326 "pm_id": [
2327 "ULINT",
2328 0
2329 ],
2330 "reported_post_enable_bbcode": [
2331 "BOOL",
2332 1
2333 ],
2334 "reported_post_enable_smilies": [
2335 "BOOL",
2336 1
2337 ],
2338 "reported_post_enable_magic_url": [
2339 "BOOL",
2340 1
2341 ],
2342 "reported_post_text": [
2343 "MTEXT_UNI",
2344 ""
2345 ],
2346 "reported_post_uid": [
2347 "VCHAR:8",
2348 ""
2349 ],
2350 "reported_post_bitfield": [
2351 "VCHAR:255",
2352 ""
2353 ]
2354 },
2355 "PRIMARY_KEY": "report_id",
2356 "KEYS": {
2357 "post_id": [
2358 "INDEX",
2359 [
2360 "post_id"
2361 ]
2362 ],
2363 "pm_id": [
2364 "INDEX",
2365 [
2366 "pm_id"
2367 ]
2368 ]
2369 }
2370 },
2371 "phpbb_reports_reasons": {
2372 "COLUMNS": {
2373 "reason_id": [
2374 "USINT",
2375 null,
2376 "auto_increment"
2377 ],
2378 "reason_title": [
2379 "VCHAR_UNI",
2380 ""
2381 ],
2382 "reason_description": [
2383 "MTEXT_UNI",
2384 ""
2385 ],
2386 "reason_order": [
2387 "USINT",
2388 0
2389 ]
2390 },
2391 "PRIMARY_KEY": "reason_id"
2392 },
2393 "phpbb_search_results": {
2394 "COLUMNS": {
2395 "search_key": [
2396 "VCHAR:32",
2397 ""
2398 ],
2399 "search_time": [
2400 "TIMESTAMP",
2401 0
2402 ],
2403 "search_keywords": [
2404 "MTEXT_UNI",
2405 ""
2406 ],
2407 "search_authors": [
2408 "MTEXT",
2409 ""
2410 ]
2411 },
2412 "PRIMARY_KEY": "search_key"
2413 },
2414 "phpbb_search_wordlist": {
2415 "COLUMNS": {
2416 "word_id": [
2417 "ULINT",
2418 null,
2419 "auto_increment"
2420 ],
2421 "word_text": [
2422 "VCHAR_UNI",
2423 ""
2424 ],
2425 "word_common": [
2426 "BOOL",
2427 0
2428 ],
2429 "word_count": [
2430 "UINT",
2431 0
2432 ]
2433 },
2434 "PRIMARY_KEY": "word_id",
2435 "KEYS": {
2436 "wrd_txt": [
2437 "UNIQUE",
2438 "word_text"
2439 ],
2440 "wrd_cnt": [
2441 "INDEX",
2442 "word_count"
2443 ]
2444 }
2445 },
2446 "phpbb_search_wordmatch": {
2447 "COLUMNS": {
2448 "post_id": [
2449 "ULINT",
2450 0
2451 ],
2452 "word_id": [
2453 "ULINT",
2454 0
2455 ],
2456 "title_match": [
2457 "BOOL",
2458 0
2459 ]
2460 },
2461 "KEYS": {
2462 "word_id": [
2463 "INDEX",
2464 "word_id"
2465 ],
2466 "post_id": [
2467 "INDEX",
2468 "post_id"
2469 ],
2470 "un_mtch": [
2471 "UNIQUE",
2472 [
2473 "word_id",
2474 "post_id",
2475 "title_match"
2476 ]
2477 ]
2478 }
2479 },
2480 "phpbb_sessions": {
2481 "COLUMNS": {
2482 "session_id": [
2483 "CHAR:32",
2484 ""
2485 ],
2486 "session_user_id": [
2487 "ULINT",
2488 0
2489 ],
2490 "session_last_visit": [
2491 "TIMESTAMP",
2492 0
2493 ],
2494 "session_start": [
2495 "TIMESTAMP",
2496 0
2497 ],
2498 "session_time": [
2499 "TIMESTAMP",
2500 0
2501 ],
2502 "session_ip": [
2503 "VCHAR:40",
2504 ""
2505 ],
2506 "session_browser": [
2507 "VCHAR:150",
2508 ""
2509 ],
2510 "session_forwarded_for": [
2511 "VCHAR:255",
2512 ""
2513 ],
2514 "session_page": [
2515 "VCHAR_UNI",
2516 ""
2517 ],
2518 "session_viewonline": [
2519 "BOOL",
2520 1
2521 ],
2522 "session_autologin": [
2523 "BOOL",
2524 0
2525 ],
2526 "session_admin": [
2527 "BOOL",
2528 0
2529 ],
2530 "session_forum_id": [
2531 "UINT",
2532 0
2533 ]
2534 },
2535 "PRIMARY_KEY": "session_id",
2536 "KEYS": {
2537 "session_time": [
2538 "INDEX",
2539 "session_time"
2540 ],
2541 "session_user_id": [
2542 "INDEX",
2543 "session_user_id"
2544 ],
2545 "session_fid": [
2546 "INDEX",
2547 [
2548 "session_forum_id"
2549 ]
2550 ]
2551 }
2552 },
2553 "phpbb_sessions_keys": {
2554 "COLUMNS": {
2555 "key_id": [
2556 "CHAR:32",
2557 ""
2558 ],
2559 "user_id": [
2560 "ULINT",
2561 0
2562 ],
2563 "last_ip": [
2564 "VCHAR:40",
2565 ""
2566 ],
2567 "last_login": [
2568 "TIMESTAMP",
2569 0
2570 ]
2571 },
2572 "PRIMARY_KEY": [
2573 "key_id",
2574 "user_id"
2575 ],
2576 "KEYS": {
2577 "last_login": [
2578 "INDEX",
2579 "last_login"
2580 ]
2581 }
2582 },
2583 "phpbb_sitelist": {
2584 "COLUMNS": {
2585 "site_id": [
2586 "UINT",
2587 null,
2588 "auto_increment"
2589 ],
2590 "site_ip": [
2591 "VCHAR:40",
2592 ""
2593 ],
2594 "site_hostname": [
2595 "VCHAR",
2596 ""
2597 ],
2598 "ip_exclude": [
2599 "BOOL",
2600 0
2601 ]
2602 },
2603 "PRIMARY_KEY": "site_id"
2604 },
2605 "phpbb_smilies": {
2606 "COLUMNS": {
2607 "smiley_id": [
2608 "UINT",
2609 null,
2610 "auto_increment"
2611 ],
2612 "code": [
2613 "VCHAR_UNI:50",
2614 ""
2615 ],
2616 "emotion": [
2617 "VCHAR_UNI",
2618 ""
2619 ],
2620 "smiley_url": [
2621 "VCHAR:50",
2622 ""
2623 ],
2624 "smiley_width": [
2625 "USINT",
2626 0
2627 ],
2628 "smiley_height": [
2629 "USINT",
2630 0
2631 ],
2632 "smiley_order": [
2633 "UINT",
2634 0
2635 ],
2636 "display_on_posting": [
2637 "BOOL",
2638 1
2639 ]
2640 },
2641 "PRIMARY_KEY": "smiley_id",
2642 "KEYS": {
2643 "display_on_post": [
2644 "INDEX",
2645 "display_on_posting"
2646 ]
2647 }
2648 },
2649 "phpbb_styles": {
2650 "COLUMNS": {
2651 "style_id": [
2652 "UINT",
2653 null,
2654 "auto_increment"
2655 ],
2656 "style_name": [
2657 "VCHAR_UNI:255",
2658 ""
2659 ],
2660 "style_copyright": [
2661 "VCHAR_UNI",
2662 ""
2663 ],
2664 "style_active": [
2665 "BOOL",
2666 1
2667 ],
2668 "style_path": [
2669 "VCHAR:100",
2670 ""
2671 ],
2672 "bbcode_bitfield": [
2673 "VCHAR:255",
2674 "kNg="
2675 ],
2676 "style_parent_id": [
2677 "UINT:4",
2678 0
2679 ],
2680 "style_parent_tree": [
2681 "TEXT",
2682 ""
2683 ]
2684 },
2685 "PRIMARY_KEY": "style_id",
2686 "KEYS": {
2687 "style_name": [
2688 "UNIQUE",
2689 "style_name"
2690 ]
2691 }
2692 },
2693 "phpbb_teampage": {
2694 "COLUMNS": {
2695 "teampage_id": [
2696 "UINT",
2697 null,
2698 "auto_increment"
2699 ],
2700 "group_id": [
2701 "UINT",
2702 0
2703 ],
2704 "teampage_name": [
2705 "VCHAR_UNI:255",
2706 ""
2707 ],
2708 "teampage_position": [
2709 "UINT",
2710 0
2711 ],
2712 "teampage_parent": [
2713 "UINT",
2714 0
2715 ]
2716 },
2717 "PRIMARY_KEY": "teampage_id"
2718 },
2719 "phpbb_topics": {
2720 "COLUMNS": {
2721 "topic_id": [
2722 "ULINT",
2723 null,
2724 "auto_increment"
2725 ],
2726 "forum_id": [
2727 "UINT",
2728 0
2729 ],
2730 "icon_id": [
2731 "UINT",
2732 0
2733 ],
2734 "topic_attachment": [
2735 "BOOL",
2736 0
2737 ],
2738 "topic_reported": [
2739 "BOOL",
2740 0
2741 ],
2742 "topic_title": [
2743 "STEXT_UNI",
2744 "",
2745 "true_sort"
2746 ],
2747 "topic_poster": [
2748 "ULINT",
2749 0
2750 ],
2751 "topic_time": [
2752 "TIMESTAMP",
2753 0
2754 ],
2755 "topic_time_limit": [
2756 "TIMESTAMP",
2757 0
2758 ],
2759 "topic_views": [
2760 "ULINT",
2761 0
2762 ],
2763 "topic_status": [
2764 "TINT:3",
2765 0
2766 ],
2767 "topic_type": [
2768 "TINT:3",
2769 0
2770 ],
2771 "topic_first_post_id": [
2772 "ULINT",
2773 0
2774 ],
2775 "topic_first_poster_name": [
2776 "VCHAR_UNI:255",
2777 "",
2778 "true_sort"
2779 ],
2780 "topic_first_poster_colour": [
2781 "VCHAR:6",
2782 ""
2783 ],
2784 "topic_last_post_id": [
2785 "ULINT",
2786 0
2787 ],
2788 "topic_last_poster_id": [
2789 "ULINT",
2790 0
2791 ],
2792 "topic_last_poster_name": [
2793 "VCHAR_UNI",
2794 ""
2795 ],
2796 "topic_last_poster_colour": [
2797 "VCHAR:6",
2798 ""
2799 ],
2800 "topic_last_post_subject": [
2801 "STEXT_UNI",
2802 ""
2803 ],
2804 "topic_last_post_time": [
2805 "TIMESTAMP",
2806 0
2807 ],
2808 "topic_last_view_time": [
2809 "TIMESTAMP",
2810 0
2811 ],
2812 "topic_moved_id": [
2813 "ULINT",
2814 0
2815 ],
2816 "topic_bumped": [
2817 "BOOL",
2818 0
2819 ],
2820 "topic_bumper": [
2821 "UINT",
2822 0
2823 ],
2824 "poll_title": [
2825 "STEXT_UNI",
2826 ""
2827 ],
2828 "poll_start": [
2829 "TIMESTAMP",
2830 0
2831 ],
2832 "poll_length": [
2833 "TIMESTAMP",
2834 0
2835 ],
2836 "poll_max_options": [
2837 "TINT:4",
2838 1
2839 ],
2840 "poll_last_vote": [
2841 "TIMESTAMP",
2842 0
2843 ],
2844 "poll_vote_change": [
2845 "BOOL",
2846 0
2847 ],
2848 "topic_visibility": [
2849 "TINT:3",
2850 0
2851 ],
2852 "topic_delete_time": [
2853 "TIMESTAMP",
2854 0
2855 ],
2856 "topic_delete_reason": [
2857 "STEXT_UNI",
2858 ""
2859 ],
2860 "topic_delete_user": [
2861 "ULINT",
2862 0
2863 ],
2864 "topic_posts_approved": [
2865 "UINT",
2866 0
2867 ],
2868 "topic_posts_unapproved": [
2869 "UINT",
2870 0
2871 ],
2872 "topic_posts_softdeleted": [
2873 "UINT",
2874 0
2875 ]
2876 },
2877 "PRIMARY_KEY": "topic_id",
2878 "KEYS": {
2879 "forum_id": [
2880 "INDEX",
2881 "forum_id"
2882 ],
2883 "forum_id_type": [
2884 "INDEX",
2885 [
2886 "forum_id",
2887 "topic_type"
2888 ]
2889 ],
2890 "last_post_time": [
2891 "INDEX",
2892 "topic_last_post_time"
2893 ],
2894 "fid_time_moved": [
2895 "INDEX",
2896 [
2897 "forum_id",
2898 "topic_last_post_time",
2899 "topic_moved_id"
2900 ]
2901 ],
2902 "topic_visibility": [
2903 "INDEX",
2904 [
2905 "topic_visibility"
2906 ]
2907 ],
2908 "forum_vis_last": [
2909 "INDEX",
2910 [
2911 "forum_id",
2912 "topic_visibility",
2913 "topic_last_post_id"
2914 ]
2915 ],
2916 "latest_topics": [
2917 "INDEX",
2918 [
2919 "forum_id",
2920 "topic_last_post_time",
2921 "topic_last_post_id",
2922 "topic_moved_id"
2923 ]
2924 ]
2925 }
2926 },
2927 "phpbb_topics_posted": {
2928 "COLUMNS": {
2929 "user_id": [
2930 "ULINT",
2931 0
2932 ],
2933 "topic_id": [
2934 "ULINT",
2935 0
2936 ],
2937 "topic_posted": [
2938 "BOOL",
2939 0
2940 ]
2941 },
2942 "PRIMARY_KEY": [
2943 "user_id",
2944 "topic_id"
2945 ]
2946 },
2947 "phpbb_topics_track": {
2948 "COLUMNS": {
2949 "user_id": [
2950 "ULINT",
2951 0
2952 ],
2953 "topic_id": [
2954 "ULINT",
2955 0
2956 ],
2957 "forum_id": [
2958 "UINT",
2959 0
2960 ],
2961 "mark_time": [
2962 "TIMESTAMP",
2963 0
2964 ]
2965 },
2966 "PRIMARY_KEY": [
2967 "user_id",
2968 "topic_id"
2969 ],
2970 "KEYS": {
2971 "forum_id": [
2972 "INDEX",
2973 "forum_id"
2974 ],
2975 "topic_id": [
2976 "INDEX",
2977 [
2978 "topic_id"
2979 ]
2980 ]
2981 }
2982 },
2983 "phpbb_topics_watch": {
2984 "COLUMNS": {
2985 "topic_id": [
2986 "ULINT",
2987 0
2988 ],
2989 "user_id": [
2990 "ULINT",
2991 0
2992 ],
2993 "notify_status": [
2994 "BOOL",
2995 0
2996 ]
2997 },
2998 "KEYS": {
2999 "topic_id": [
3000 "INDEX",
3001 "topic_id"
3002 ],
3003 "user_id": [
3004 "INDEX",
3005 "user_id"
3006 ],
3007 "notify_stat": [
3008 "INDEX",
3009 "notify_status"
3010 ]
3011 }
3012 },
3013 "phpbb_user_group": {
3014 "COLUMNS": {
3015 "group_id": [
3016 "UINT",
3017 0
3018 ],
3019 "user_id": [
3020 "ULINT",
3021 0
3022 ],
3023 "group_leader": [
3024 "BOOL",
3025 0
3026 ],
3027 "user_pending": [
3028 "BOOL",
3029 1
3030 ]
3031 },
3032 "KEYS": {
3033 "group_id": [
3034 "INDEX",
3035 "group_id"
3036 ],
3037 "user_id": [
3038 "INDEX",
3039 "user_id"
3040 ],
3041 "group_leader": [
3042 "INDEX",
3043 "group_leader"
3044 ]
3045 }
3046 },
3047 "phpbb_user_notifications": {
3048 "COLUMNS": {
3049 "item_type": [
3050 "VCHAR:165",
3051 ""
3052 ],
3053 "item_id": [
3054 "ULINT",
3055 0
3056 ],
3057 "user_id": [
3058 "ULINT",
3059 0
3060 ],
3061 "method": [
3062 "VCHAR:165",
3063 ""
3064 ],
3065 "notify": [
3066 "BOOL",
3067 1
3068 ]
3069 },
3070 "KEYS": {
3071 "user_id": [
3072 "INDEX",
3073 [
3074 "user_id"
3075 ]
3076 ],
3077 "uid_itm_id": [
3078 "INDEX",
3079 [
3080 "user_id",
3081 "item_id"
3082 ]
3083 ],
3084 "usr_itm_tpe": [
3085 "INDEX",
3086 [
3087 "user_id",
3088 "item_type",
3089 "item_id"
3090 ]
3091 ],
3092 "itm_usr_mthd": [
3093 "UNIQUE",
3094 [
3095 "item_type",
3096 "item_id",
3097 "user_id",
3098 "method"
3099 ]
3100 ]
3101 }
3102 },
3103 "phpbb_users": {
3104 "COLUMNS": {
3105 "user_id": [
3106 "ULINT",
3107 null,
3108 "auto_increment"
3109 ],
3110 "user_type": [
3111 "TINT:2",
3112 0
3113 ],
3114 "group_id": [
3115 "UINT",
3116 3
3117 ],
3118 "user_permissions": [
3119 "MTEXT",
3120 ""
3121 ],
3122 "user_perm_from": [
3123 "UINT",
3124 0
3125 ],
3126 "user_ip": [
3127 "VCHAR:40",
3128 ""
3129 ],
3130 "user_regdate": [
3131 "TIMESTAMP",
3132 0
3133 ],
3134 "username": [
3135 "VCHAR_CI",
3136 ""
3137 ],
3138 "username_clean": [
3139 "VCHAR_CI",
3140 ""
3141 ],
3142 "user_password": [
3143 "VCHAR:255",
3144 ""
3145 ],
3146 "user_passchg": [
3147 "TIMESTAMP",
3148 0
3149 ],
3150 "user_email": [
3151 "VCHAR_UNI:100",
3152 ""
3153 ],
3154 "user_birthday": [
3155 "VCHAR:10",
3156 ""
3157 ],
3158 "user_lastvisit": [
3159 "TIMESTAMP",
3160 0
3161 ],
3162 "user_last_active": [
3163 "TIMESTAMP",
3164 0
3165 ],
3166 "user_lastmark": [
3167 "TIMESTAMP",
3168 0
3169 ],
3170 "user_lastpost_time": [
3171 "TIMESTAMP",
3172 0
3173 ],
3174 "user_lastpage": [
3175 "VCHAR_UNI:200",
3176 ""
3177 ],
3178 "user_last_confirm_key": [
3179 "VCHAR:10",
3180 ""
3181 ],
3182 "user_last_search": [
3183 "TIMESTAMP",
3184 0
3185 ],
3186 "user_warnings": [
3187 "TINT:4",
3188 0
3189 ],
3190 "user_last_warning": [
3191 "TIMESTAMP",
3192 0
3193 ],
3194 "user_login_attempts": [
3195 "TINT:4",
3196 0
3197 ],
3198 "user_inactive_reason": [
3199 "TINT:2",
3200 0
3201 ],
3202 "user_inactive_time": [
3203 "TIMESTAMP",
3204 0
3205 ],
3206 "user_posts": [
3207 "UINT",
3208 0
3209 ],
3210 "user_lang": [
3211 "VCHAR:30",
3212 ""
3213 ],
3214 "user_timezone": [
3215 "VCHAR:100",
3216 ""
3217 ],
3218 "user_dateformat": [
3219 "VCHAR_UNI:64",
3220 "d M Y H:i"
3221 ],
3222 "user_style": [
3223 "UINT",
3224 0
3225 ],
3226 "user_rank": [
3227 "UINT",
3228 0
3229 ],
3230 "user_colour": [
3231 "VCHAR:6",
3232 ""
3233 ],
3234 "user_new_privmsg": [
3235 "INT:4",
3236 0
3237 ],
3238 "user_unread_privmsg": [
3239 "INT:4",
3240 0
3241 ],
3242 "user_last_privmsg": [
3243 "TIMESTAMP",
3244 0
3245 ],
3246 "user_message_rules": [
3247 "BOOL",
3248 0
3249 ],
3250 "user_full_folder": [
3251 "INT:11",
3252 -3
3253 ],
3254 "user_emailtime": [
3255 "TIMESTAMP",
3256 0
3257 ],
3258 "user_topic_show_days": [
3259 "USINT",
3260 0
3261 ],
3262 "user_topic_sortby_type": [
3263 "VCHAR:1",
3264 "t"
3265 ],
3266 "user_topic_sortby_dir": [
3267 "VCHAR:1",
3268 "d"
3269 ],
3270 "user_post_show_days": [
3271 "USINT",
3272 0
3273 ],
3274 "user_post_sortby_type": [
3275 "VCHAR:1",
3276 "t"
3277 ],
3278 "user_post_sortby_dir": [
3279 "VCHAR:1",
3280 "a"
3281 ],
3282 "user_notify": [
3283 "BOOL",
3284 0
3285 ],
3286 "user_notify_pm": [
3287 "BOOL",
3288 1
3289 ],
3290 "user_notify_type": [
3291 "TINT:4",
3292 0
3293 ],
3294 "user_allow_pm": [
3295 "BOOL",
3296 1
3297 ],
3298 "user_allow_viewonline": [
3299 "BOOL",
3300 1
3301 ],
3302 "user_allow_viewemail": [
3303 "BOOL",
3304 1
3305 ],
3306 "user_allow_massemail": [
3307 "BOOL",
3308 1
3309 ],
3310 "user_options": [
3311 "UINT:11",
3312 230271
3313 ],
3314 "user_avatar": [
3315 "VCHAR",
3316 ""
3317 ],
3318 "user_avatar_type": [
3319 "VCHAR:255",
3320 ""
3321 ],
3322 "user_avatar_width": [
3323 "USINT",
3324 0
3325 ],
3326 "user_avatar_height": [
3327 "USINT",
3328 0
3329 ],
3330 "user_sig": [
3331 "MTEXT_UNI",
3332 ""
3333 ],
3334 "user_sig_bbcode_uid": [
3335 "VCHAR:8",
3336 ""
3337 ],
3338 "user_sig_bbcode_bitfield": [
3339 "VCHAR:255",
3340 ""
3341 ],
3342 "user_jabber": [
3343 "VCHAR_UNI",
3344 ""
3345 ],
3346 "user_actkey": [
3347 "VCHAR:32",
3348 ""
3349 ],
3350 "user_actkey_expiration": [
3351 "TIMESTAMP",
3352 0
3353 ],
3354 "reset_token": [
3355 "VCHAR:64",
3356 ""
3357 ],
3358 "reset_token_expiration": [
3359 "TIMESTAMP",
3360 0
3361 ],
3362 "user_newpasswd": [
3363 "VCHAR:255",
3364 ""
3365 ],
3366 "user_form_salt": [
3367 "VCHAR_UNI:32",
3368 ""
3369 ],
3370 "user_new": [
3371 "BOOL",
3372 1
3373 ],
3374 "user_reminded": [
3375 "TINT:4",
3376 0
3377 ],
3378 "user_reminded_time": [
3379 "TIMESTAMP",
3380 0
3381 ]
3382 },
3383 "PRIMARY_KEY": "user_id",
3384 "KEYS": {
3385 "user_birthday": [
3386 "INDEX",
3387 "user_birthday"
3388 ],
3389 "user_type": [
3390 "INDEX",
3391 "user_type"
3392 ],
3393 "username_clean": [
3394 "UNIQUE",
3395 "username_clean"
3396 ],
3397 "user_email": [
3398 "INDEX",
3399 [
3400 "user_email"
3401 ]
3402 ]
3403 }
3404 },
3405 "phpbb_warnings": {
3406 "COLUMNS": {
3407 "warning_id": [
3408 "UINT",
3409 null,
3410 "auto_increment"
3411 ],
3412 "user_id": [
3413 "ULINT",
3414 0
3415 ],
3416 "post_id": [
3417 "ULINT",
3418 0
3419 ],
3420 "log_id": [
3421 "ULINT",
3422 0
3423 ],
3424 "warning_time": [
3425 "TIMESTAMP",
3426 0
3427 ]
3428 },
3429 "PRIMARY_KEY": "warning_id"
3430 },
3431 "phpbb_words": {
3432 "COLUMNS": {
3433 "word_id": [
3434 "ULINT",
3435 null,
3436 "auto_increment"
3437 ],
3438 "word": [
3439 "VCHAR_UNI",
3440 ""
3441 ],
3442 "replacement": [
3443 "VCHAR_UNI",
3444 ""
3445 ]
3446 },
3447 "PRIMARY_KEY": "word_id"
3448 },
3449 "phpbb_zebra": {
3450 "COLUMNS": {
3451 "user_id": [
3452 "ULINT",
3453 0
3454 ],
3455 "zebra_id": [
3456 "ULINT",
3457 0
3458 ],
3459 "friend": [
3460 "BOOL",
3461 0
3462 ],
3463 "foe": [
3464 "BOOL",
3465 0
3466 ]
3467 },
3468 "PRIMARY_KEY": [
3469 "user_id",
3470 "zebra_id"
3471 ]
3472 }
3473 }