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