| [ Index ] |
PHP Cross Reference of phpBB-3.2.11-deutsch |
[Summary view] [Print] [Text view]
1 { 2 "phpbb_acl_groups": { 3 "COLUMNS": { 4 "group_id": [ 5 "UINT", 6 0 7 ], 8 "forum_id": [ 9 "UINT", 10 0 11 ], 12 "auth_option_id": [ 13 "UINT", 14 0 15 ], 16 "auth_role_id": [ 17 "UINT", 18 0 19 ], 20 "auth_setting": [ 21 "TINT:2", 22 0 23 ] 24 }, 25 "KEYS": { 26 "group_id": [ 27 "INDEX", 28 "group_id" 29 ], 30 "auth_opt_id": [ 31 "INDEX", 32 "auth_option_id" 33 ], 34 "auth_role_id": [ 35 "INDEX", 36 "auth_role_id" 37 ] 38 } 39 }, 40 "phpbb_acl_options": { 41 "COLUMNS": { 42 "auth_option_id": [ 43 "UINT", 44 null, 45 "auto_increment" 46 ], 47 "auth_option": [ 48 "VCHAR:50", 49 "" 50 ], 51 "is_global": [ 52 "BOOL", 53 0 54 ], 55 "is_local": [ 56 "BOOL", 57 0 58 ], 59 "founder_only": [ 60 "BOOL", 61 0 62 ] 63 }, 64 "PRIMARY_KEY": "auth_option_id", 65 "KEYS": { 66 "auth_option": [ 67 "UNIQUE", 68 [ 69 "auth_option" 70 ] 71 ] 72 } 73 }, 74 "phpbb_acl_roles": { 75 "COLUMNS": { 76 "role_id": [ 77 "UINT", 78 null, 79 "auto_increment" 80 ], 81 "role_name": [ 82 "VCHAR_UNI", 83 "" 84 ], 85 "role_description": [ 86 "TEXT_UNI", 87 "" 88 ], 89 "role_type": [ 90 "VCHAR:10", 91 "" 92 ], 93 "role_order": [ 94 "USINT", 95 0 96 ] 97 }, 98 "PRIMARY_KEY": "role_id", 99 "KEYS": { 100 "role_type": [ 101 "INDEX", 102 "role_type" 103 ], 104 "role_order": [ 105 "INDEX", 106 "role_order" 107 ] 108 } 109 }, 110 "phpbb_acl_roles_data": { 111 "COLUMNS": { 112 "role_id": [ 113 "UINT", 114 0 115 ], 116 "auth_option_id": [ 117 "UINT", 118 0 119 ], 120 "auth_setting": [ 121 "TINT:2", 122 0 123 ] 124 }, 125 "PRIMARY_KEY": [ 126 "role_id", 127 "auth_option_id" 128 ], 129 "KEYS": { 130 "ath_op_id": [ 131 "INDEX", 132 "auth_option_id" 133 ] 134 } 135 }, 136 "phpbb_acl_users": { 137 "COLUMNS": { 138 "user_id": [ 139 "ULINT", 140 0 141 ], 142 "forum_id": [ 143 "UINT", 144 0 145 ], 146 "auth_option_id": [ 147 "UINT", 148 0 149 ], 150 "auth_role_id": [ 151 "UINT", 152 0 153 ], 154 "auth_setting": [ 155 "TINT:2", 156 0 157 ] 158 }, 159 "KEYS": { 160 "user_id": [ 161 "INDEX", 162 "user_id" 163 ], 164 "auth_option_id": [ 165 "INDEX", 166 "auth_option_id" 167 ], 168 "auth_role_id": [ 169 "INDEX", 170 "auth_role_id" 171 ] 172 } 173 }, 174 "phpbb_attachments": { 175 "COLUMNS": { 176 "attach_id": [ 177 "ULINT", 178 null, 179 "auto_increment" 180 ], 181 "post_msg_id": [ 182 "ULINT", 183 0 184 ], 185 "topic_id": [ 186 "ULINT", 187 0 188 ], 189 "in_message": [ 190 "BOOL", 191 0 192 ], 193 "poster_id": [ 194 "ULINT", 195 0 196 ], 197 "is_orphan": [ 198 "BOOL", 199 1 200 ], 201 "physical_filename": [ 202 "VCHAR", 203 "" 204 ], 205 "real_filename": [ 206 "VCHAR", 207 "" 208 ], 209 "download_count": [ 210 "UINT", 211 0 212 ], 213 "attach_comment": [ 214 "TEXT_UNI", 215 "" 216 ], 217 "extension": [ 218 "VCHAR:100", 219 "" 220 ], 221 "mimetype": [ 222 "VCHAR:100", 223 "" 224 ], 225 "filesize": [ 226 "UINT:20", 227 0 228 ], 229 "filetime": [ 230 "TIMESTAMP", 231 0 232 ], 233 "thumbnail": [ 234 "BOOL", 235 0 236 ] 237 }, 238 "PRIMARY_KEY": "attach_id", 239 "KEYS": { 240 "filetime": [ 241 "INDEX", 242 "filetime" 243 ], 244 "post_msg_id": [ 245 "INDEX", 246 "post_msg_id" 247 ], 248 "topic_id": [ 249 "INDEX", 250 "topic_id" 251 ], 252 "poster_id": [ 253 "INDEX", 254 "poster_id" 255 ], 256 "is_orphan": [ 257 "INDEX", 258 "is_orphan" 259 ] 260 } 261 }, 262 "phpbb_banlist": { 263 "COLUMNS": { 264 "ban_id": [ 265 "ULINT", 266 null, 267 "auto_increment" 268 ], 269 "ban_userid": [ 270 "ULINT", 271 0 272 ], 273 "ban_ip": [ 274 "VCHAR:40", 275 "" 276 ], 277 "ban_email": [ 278 "VCHAR_UNI:100", 279 "" 280 ], 281 "ban_start": [ 282 "TIMESTAMP", 283 0 284 ], 285 "ban_end": [ 286 "TIMESTAMP", 287 0 288 ], 289 "ban_exclude": [ 290 "BOOL", 291 0 292 ], 293 "ban_reason": [ 294 "VCHAR_UNI", 295 "" 296 ], 297 "ban_give_reason": [ 298 "VCHAR_UNI", 299 "" 300 ] 301 }, 302 "PRIMARY_KEY": "ban_id", 303 "KEYS": { 304 "ban_end": [ 305 "INDEX", 306 "ban_end" 307 ], 308 "ban_user": [ 309 "INDEX", 310 [ 311 "ban_userid", 312 "ban_exclude" 313 ] 314 ], 315 "ban_email": [ 316 "INDEX", 317 [ 318 "ban_email", 319 "ban_exclude" 320 ] 321 ], 322 "ban_ip": [ 323 "INDEX", 324 [ 325 "ban_ip", 326 "ban_exclude" 327 ] 328 ] 329 } 330 }, 331 "phpbb_bbcodes": { 332 "COLUMNS": { 333 "bbcode_id": [ 334 "USINT", 335 0 336 ], 337 "bbcode_tag": [ 338 "VCHAR:16", 339 "" 340 ], 341 "bbcode_helpline": [ 342 "VCHAR_UNI", 343 "" 344 ], 345 "display_on_posting": [ 346 "BOOL", 347 0 348 ], 349 "bbcode_match": [ 350 "TEXT_UNI", 351 "" 352 ], 353 "bbcode_tpl": [ 354 "MTEXT_UNI", 355 "" 356 ], 357 "first_pass_match": [ 358 "MTEXT_UNI", 359 "" 360 ], 361 "first_pass_replace": [ 362 "MTEXT_UNI", 363 "" 364 ], 365 "second_pass_match": [ 366 "MTEXT_UNI", 367 "" 368 ], 369 "second_pass_replace": [ 370 "MTEXT_UNI", 371 "" 372 ] 373 }, 374 "PRIMARY_KEY": "bbcode_id", 375 "KEYS": { 376 "display_on_post": [ 377 "INDEX", 378 "display_on_posting" 379 ] 380 } 381 }, 382 "phpbb_bookmarks": { 383 "COLUMNS": { 384 "topic_id": [ 385 "ULINT", 386 0 387 ], 388 "user_id": [ 389 "ULINT", 390 0 391 ] 392 }, 393 "PRIMARY_KEY": [ 394 "topic_id", 395 "user_id" 396 ] 397 }, 398 "phpbb_bots": { 399 "COLUMNS": { 400 "bot_id": [ 401 "ULINT", 402 null, 403 "auto_increment" 404 ], 405 "bot_active": [ 406 "BOOL", 407 1 408 ], 409 "bot_name": [ 410 "STEXT_UNI", 411 "" 412 ], 413 "user_id": [ 414 "ULINT", 415 0 416 ], 417 "bot_agent": [ 418 "VCHAR", 419 "" 420 ], 421 "bot_ip": [ 422 "VCHAR", 423 "" 424 ] 425 }, 426 "PRIMARY_KEY": "bot_id", 427 "KEYS": { 428 "bot_active": [ 429 "INDEX", 430 "bot_active" 431 ] 432 } 433 }, 434 "phpbb_config": { 435 "COLUMNS": { 436 "config_name": [ 437 "VCHAR", 438 "" 439 ], 440 "config_value": [ 441 "VCHAR_UNI", 442 "" 443 ], 444 "is_dynamic": [ 445 "BOOL", 446 0 447 ] 448 }, 449 "PRIMARY_KEY": "config_name", 450 "KEYS": { 451 "is_dynamic": [ 452 "INDEX", 453 "is_dynamic" 454 ] 455 } 456 }, 457 "phpbb_config_text": { 458 "COLUMNS": { 459 "config_name": [ 460 "VCHAR", 461 "" 462 ], 463 "config_value": [ 464 "MTEXT", 465 "" 466 ] 467 }, 468 "PRIMARY_KEY": "config_name" 469 }, 470 "phpbb_confirm": { 471 "COLUMNS": { 472 "confirm_id": [ 473 "CHAR:32", 474 "" 475 ], 476 "session_id": [ 477 "CHAR:32", 478 "" 479 ], 480 "confirm_type": [ 481 "TINT:3", 482 0 483 ], 484 "code": [ 485 "VCHAR:8", 486 "" 487 ], 488 "seed": [ 489 "UINT:10", 490 0 491 ], 492 "attempts": [ 493 "UINT", 494 0 495 ] 496 }, 497 "PRIMARY_KEY": [ 498 "session_id", 499 "confirm_id" 500 ], 501 "KEYS": { 502 "confirm_type": [ 503 "INDEX", 504 "confirm_type" 505 ] 506 } 507 }, 508 "phpbb_disallow": { 509 "COLUMNS": { 510 "disallow_id": [ 511 "UINT", 512 null, 513 "auto_increment" 514 ], 515 "disallow_username": [ 516 "VCHAR_UNI:255", 517 "" 518 ] 519 }, 520 "PRIMARY_KEY": "disallow_id" 521 }, 522 "phpbb_drafts": { 523 "COLUMNS": { 524 "draft_id": [ 525 "ULINT", 526 null, 527 "auto_increment" 528 ], 529 "user_id": [ 530 "ULINT", 531 0 532 ], 533 "topic_id": [ 534 "ULINT", 535 0 536 ], 537 "forum_id": [ 538 "UINT", 539 0 540 ], 541 "save_time": [ 542 "TIMESTAMP", 543 0 544 ], 545 "draft_subject": [ 546 "STEXT_UNI", 547 "" 548 ], 549 "draft_message": [ 550 "MTEXT_UNI", 551 "" 552 ] 553 }, 554 "PRIMARY_KEY": "draft_id", 555 "KEYS": { 556 "save_time": [ 557 "INDEX", 558 "save_time" 559 ] 560 } 561 }, 562 "phpbb_ext": { 563 "COLUMNS": { 564 "ext_name": [ 565 "VCHAR", 566 "" 567 ], 568 "ext_active": [ 569 "BOOL", 570 0 571 ], 572 "ext_state": [ 573 "TEXT", 574 "" 575 ] 576 }, 577 "KEYS": { 578 "ext_name": [ 579 "UNIQUE", 580 "ext_name" 581 ] 582 } 583 }, 584 "phpbb_extension_groups": { 585 "COLUMNS": { 586 "group_id": [ 587 "UINT", 588 null, 589 "auto_increment" 590 ], 591 "group_name": [ 592 "VCHAR_UNI", 593 "" 594 ], 595 "cat_id": [ 596 "TINT:2", 597 0 598 ], 599 "allow_group": [ 600 "BOOL", 601 0 602 ], 603 "download_mode": [ 604 "BOOL", 605 1 606 ], 607 "upload_icon": [ 608 "VCHAR", 609 "" 610 ], 611 "max_filesize": [ 612 "UINT:20", 613 0 614 ], 615 "allowed_forums": [ 616 "TEXT", 617 "" 618 ], 619 "allow_in_pm": [ 620 "BOOL", 621 0 622 ] 623 }, 624 "PRIMARY_KEY": "group_id" 625 }, 626 "phpbb_extensions": { 627 "COLUMNS": { 628 "extension_id": [ 629 "UINT", 630 null, 631 "auto_increment" 632 ], 633 "group_id": [ 634 "UINT", 635 0 636 ], 637 "extension": [ 638 "VCHAR:100", 639 "" 640 ] 641 }, 642 "PRIMARY_KEY": "extension_id" 643 }, 644 "phpbb_forums": { 645 "COLUMNS": { 646 "forum_id": [ 647 "UINT", 648 null, 649 "auto_increment" 650 ], 651 "parent_id": [ 652 "UINT", 653 0 654 ], 655 "left_id": [ 656 "UINT", 657 0 658 ], 659 "right_id": [ 660 "UINT", 661 0 662 ], 663 "forum_parents": [ 664 "MTEXT", 665 "" 666 ], 667 "forum_name": [ 668 "STEXT_UNI", 669 "" 670 ], 671 "forum_desc": [ 672 "TEXT_UNI", 673 "" 674 ], 675 "forum_desc_bitfield": [ 676 "VCHAR:255", 677 "" 678 ], 679 "forum_desc_options": [ 680 "UINT:11", 681 7 682 ], 683 "forum_desc_uid": [ 684 "VCHAR:8", 685 "" 686 ], 687 "forum_link": [ 688 "VCHAR_UNI", 689 "" 690 ], 691 "forum_password": [ 692 "VCHAR:255", 693 "" 694 ], 695 "forum_style": [ 696 "UINT", 697 0 698 ], 699 "forum_image": [ 700 "VCHAR", 701 "" 702 ], 703 "forum_rules": [ 704 "TEXT_UNI", 705 "" 706 ], 707 "forum_rules_link": [ 708 "VCHAR_UNI", 709 "" 710 ], 711 "forum_rules_bitfield": [ 712 "VCHAR:255", 713 "" 714 ], 715 "forum_rules_options": [ 716 "UINT:11", 717 7 718 ], 719 "forum_rules_uid": [ 720 "VCHAR:8", 721 "" 722 ], 723 "forum_topics_per_page": [ 724 "USINT", 725 0 726 ], 727 "forum_type": [ 728 "TINT:4", 729 0 730 ], 731 "forum_status": [ 732 "TINT:4", 733 0 734 ], 735 "forum_last_post_id": [ 736 "ULINT", 737 0 738 ], 739 "forum_last_poster_id": [ 740 "ULINT", 741 0 742 ], 743 "forum_last_post_subject": [ 744 "STEXT_UNI", 745 "" 746 ], 747 "forum_last_post_time": [ 748 "TIMESTAMP", 749 0 750 ], 751 "forum_last_poster_name": [ 752 "VCHAR_UNI", 753 "" 754 ], 755 "forum_last_poster_colour": [ 756 "VCHAR:6", 757 "" 758 ], 759 "forum_flags": [ 760 "TINT:4", 761 32 762 ], 763 "display_on_index": [ 764 "BOOL", 765 1 766 ], 767 "enable_indexing": [ 768 "BOOL", 769 1 770 ], 771 "enable_icons": [ 772 "BOOL", 773 1 774 ], 775 "enable_prune": [ 776 "BOOL", 777 0 778 ], 779 "prune_next": [ 780 "TIMESTAMP", 781 0 782 ], 783 "prune_days": [ 784 "UINT", 785 0 786 ], 787 "prune_viewed": [ 788 "UINT", 789 0 790 ], 791 "prune_freq": [ 792 "UINT", 793 0 794 ], 795 "display_subforum_list": [ 796 "BOOL", 797 1 798 ], 799 "forum_options": [ 800 "UINT:20", 801 0 802 ], 803 "enable_shadow_prune": [ 804 "BOOL", 805 0 806 ], 807 "prune_shadow_days": [ 808 "UINT", 809 7 810 ], 811 "prune_shadow_freq": [ 812 "UINT", 813 1 814 ], 815 "prune_shadow_next": [ 816 "INT:11", 817 0 818 ], 819 "forum_posts_approved": [ 820 "UINT", 821 0 822 ], 823 "forum_posts_unapproved": [ 824 "UINT", 825 0 826 ], 827 "forum_posts_softdeleted": [ 828 "UINT", 829 0 830 ], 831 "forum_topics_approved": [ 832 "UINT", 833 0 834 ], 835 "forum_topics_unapproved": [ 836 "UINT", 837 0 838 ], 839 "forum_topics_softdeleted": [ 840 "UINT", 841 0 842 ] 843 }, 844 "PRIMARY_KEY": "forum_id", 845 "KEYS": { 846 "left_right_id": [ 847 "INDEX", 848 [ 849 "left_id", 850 "right_id" 851 ] 852 ], 853 "forum_lastpost_id": [ 854 "INDEX", 855 "forum_last_post_id" 856 ] 857 } 858 }, 859 "phpbb_forums_access": { 860 "COLUMNS": { 861 "forum_id": [ 862 "UINT", 863 0 864 ], 865 "user_id": [ 866 "ULINT", 867 0 868 ], 869 "session_id": [ 870 "CHAR:32", 871 "" 872 ] 873 }, 874 "PRIMARY_KEY": [ 875 "forum_id", 876 "user_id", 877 "session_id" 878 ] 879 }, 880 "phpbb_forums_track": { 881 "COLUMNS": { 882 "user_id": [ 883 "ULINT", 884 0 885 ], 886 "forum_id": [ 887 "UINT", 888 0 889 ], 890 "mark_time": [ 891 "TIMESTAMP", 892 0 893 ] 894 }, 895 "PRIMARY_KEY": [ 896 "user_id", 897 "forum_id" 898 ] 899 }, 900 "phpbb_forums_watch": { 901 "COLUMNS": { 902 "forum_id": [ 903 "UINT", 904 0 905 ], 906 "user_id": [ 907 "ULINT", 908 0 909 ], 910 "notify_status": [ 911 "BOOL", 912 0 913 ] 914 }, 915 "KEYS": { 916 "forum_id": [ 917 "INDEX", 918 "forum_id" 919 ], 920 "user_id": [ 921 "INDEX", 922 "user_id" 923 ], 924 "notify_stat": [ 925 "INDEX", 926 "notify_status" 927 ] 928 } 929 }, 930 "phpbb_groups": { 931 "COLUMNS": { 932 "group_id": [ 933 "UINT", 934 null, 935 "auto_increment" 936 ], 937 "group_type": [ 938 "TINT:4", 939 1 940 ], 941 "group_founder_manage": [ 942 "BOOL", 943 0 944 ], 945 "group_skip_auth": [ 946 "BOOL", 947 0 948 ], 949 "group_name": [ 950 "VCHAR_CI", 951 "" 952 ], 953 "group_desc": [ 954 "TEXT_UNI", 955 "" 956 ], 957 "group_desc_bitfield": [ 958 "VCHAR:255", 959 "" 960 ], 961 "group_desc_options": [ 962 "UINT:11", 963 7 964 ], 965 "group_desc_uid": [ 966 "VCHAR:8", 967 "" 968 ], 969 "group_display": [ 970 "BOOL", 971 0 972 ], 973 "group_avatar": [ 974 "VCHAR", 975 "" 976 ], 977 "group_avatar_type": [ 978 "VCHAR:255", 979 "" 980 ], 981 "group_avatar_width": [ 982 "USINT", 983 0 984 ], 985 "group_avatar_height": [ 986 "USINT", 987 0 988 ], 989 "group_rank": [ 990 "UINT", 991 0 992 ], 993 "group_colour": [ 994 "VCHAR:6", 995 "" 996 ], 997 "group_sig_chars": [ 998 "UINT", 999 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_icq": [ 2148 "VCHAR", 2149 "" 2150 ], 2151 "pf_phpbb_googleplus": [ 2152 "VCHAR", 2153 "" 2154 ], 2155 "pf_phpbb_twitter": [ 2156 "VCHAR", 2157 "" 2158 ], 2159 "pf_phpbb_skype": [ 2160 "VCHAR", 2161 "" 2162 ], 2163 "pf_phpbb_youtube": [ 2164 "VCHAR", 2165 "" 2166 ], 2167 "pf_phpbb_facebook": [ 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 "latest_topics": [ 2895 "INDEX", 2896 [ 2897 "forum_id", 2898 "topic_last_post_time", 2899 "topic_last_post_id", 2900 "topic_moved_id" 2901 ] 2902 ] 2903 } 2904 }, 2905 "phpbb_topics_posted": { 2906 "COLUMNS": { 2907 "user_id": [ 2908 "ULINT", 2909 0 2910 ], 2911 "topic_id": [ 2912 "ULINT", 2913 0 2914 ], 2915 "topic_posted": [ 2916 "BOOL", 2917 0 2918 ] 2919 }, 2920 "PRIMARY_KEY": [ 2921 "user_id", 2922 "topic_id" 2923 ] 2924 }, 2925 "phpbb_topics_track": { 2926 "COLUMNS": { 2927 "user_id": [ 2928 "ULINT", 2929 0 2930 ], 2931 "topic_id": [ 2932 "ULINT", 2933 0 2934 ], 2935 "forum_id": [ 2936 "UINT", 2937 0 2938 ], 2939 "mark_time": [ 2940 "TIMESTAMP", 2941 0 2942 ] 2943 }, 2944 "PRIMARY_KEY": [ 2945 "user_id", 2946 "topic_id" 2947 ], 2948 "KEYS": { 2949 "forum_id": [ 2950 "INDEX", 2951 "forum_id" 2952 ], 2953 "topic_id": [ 2954 "INDEX", 2955 [ 2956 "topic_id" 2957 ] 2958 ] 2959 } 2960 }, 2961 "phpbb_topics_watch": { 2962 "COLUMNS": { 2963 "topic_id": [ 2964 "ULINT", 2965 0 2966 ], 2967 "user_id": [ 2968 "ULINT", 2969 0 2970 ], 2971 "notify_status": [ 2972 "BOOL", 2973 0 2974 ] 2975 }, 2976 "KEYS": { 2977 "topic_id": [ 2978 "INDEX", 2979 "topic_id" 2980 ], 2981 "user_id": [ 2982 "INDEX", 2983 "user_id" 2984 ], 2985 "notify_stat": [ 2986 "INDEX", 2987 "notify_status" 2988 ] 2989 } 2990 }, 2991 "phpbb_user_group": { 2992 "COLUMNS": { 2993 "group_id": [ 2994 "UINT", 2995 0 2996 ], 2997 "user_id": [ 2998 "ULINT", 2999 0 3000 ], 3001 "group_leader": [ 3002 "BOOL", 3003 0 3004 ], 3005 "user_pending": [ 3006 "BOOL", 3007 1 3008 ] 3009 }, 3010 "KEYS": { 3011 "group_id": [ 3012 "INDEX", 3013 "group_id" 3014 ], 3015 "user_id": [ 3016 "INDEX", 3017 "user_id" 3018 ], 3019 "group_leader": [ 3020 "INDEX", 3021 "group_leader" 3022 ] 3023 } 3024 }, 3025 "phpbb_user_notifications": { 3026 "COLUMNS": { 3027 "item_type": [ 3028 "VCHAR:165", 3029 "" 3030 ], 3031 "item_id": [ 3032 "ULINT", 3033 0 3034 ], 3035 "user_id": [ 3036 "ULINT", 3037 0 3038 ], 3039 "method": [ 3040 "VCHAR:165", 3041 "" 3042 ], 3043 "notify": [ 3044 "BOOL", 3045 1 3046 ] 3047 }, 3048 "KEYS": { 3049 "user_id": [ 3050 "INDEX", 3051 [ 3052 "user_id" 3053 ] 3054 ], 3055 "uid_itm_id": [ 3056 "INDEX", 3057 [ 3058 "user_id", 3059 "item_id" 3060 ] 3061 ], 3062 "usr_itm_tpe": [ 3063 "INDEX", 3064 [ 3065 "user_id", 3066 "item_type", 3067 "item_id" 3068 ] 3069 ], 3070 "itm_usr_mthd": [ 3071 "UNIQUE", 3072 [ 3073 "item_type", 3074 "item_id", 3075 "user_id", 3076 "method" 3077 ] 3078 ] 3079 } 3080 }, 3081 "phpbb_users": { 3082 "COLUMNS": { 3083 "user_id": [ 3084 "ULINT", 3085 null, 3086 "auto_increment" 3087 ], 3088 "user_type": [ 3089 "TINT:2", 3090 0 3091 ], 3092 "group_id": [ 3093 "UINT", 3094 3 3095 ], 3096 "user_permissions": [ 3097 "MTEXT", 3098 "" 3099 ], 3100 "user_perm_from": [ 3101 "UINT", 3102 0 3103 ], 3104 "user_ip": [ 3105 "VCHAR:40", 3106 "" 3107 ], 3108 "user_regdate": [ 3109 "TIMESTAMP", 3110 0 3111 ], 3112 "username": [ 3113 "VCHAR_CI", 3114 "" 3115 ], 3116 "username_clean": [ 3117 "VCHAR_CI", 3118 "" 3119 ], 3120 "user_password": [ 3121 "VCHAR:255", 3122 "" 3123 ], 3124 "user_passchg": [ 3125 "TIMESTAMP", 3126 0 3127 ], 3128 "user_email": [ 3129 "VCHAR_UNI:100", 3130 "" 3131 ], 3132 "user_email_hash": [ 3133 "BINT", 3134 0 3135 ], 3136 "user_birthday": [ 3137 "VCHAR:10", 3138 "" 3139 ], 3140 "user_lastvisit": [ 3141 "TIMESTAMP", 3142 0 3143 ], 3144 "user_lastmark": [ 3145 "TIMESTAMP", 3146 0 3147 ], 3148 "user_lastpost_time": [ 3149 "TIMESTAMP", 3150 0 3151 ], 3152 "user_lastpage": [ 3153 "VCHAR_UNI:200", 3154 "" 3155 ], 3156 "user_last_confirm_key": [ 3157 "VCHAR:10", 3158 "" 3159 ], 3160 "user_last_search": [ 3161 "TIMESTAMP", 3162 0 3163 ], 3164 "user_warnings": [ 3165 "TINT:4", 3166 0 3167 ], 3168 "user_last_warning": [ 3169 "TIMESTAMP", 3170 0 3171 ], 3172 "user_login_attempts": [ 3173 "TINT:4", 3174 0 3175 ], 3176 "user_inactive_reason": [ 3177 "TINT:2", 3178 0 3179 ], 3180 "user_inactive_time": [ 3181 "TIMESTAMP", 3182 0 3183 ], 3184 "user_posts": [ 3185 "UINT", 3186 0 3187 ], 3188 "user_lang": [ 3189 "VCHAR:30", 3190 "" 3191 ], 3192 "user_timezone": [ 3193 "VCHAR:100", 3194 "" 3195 ], 3196 "user_dateformat": [ 3197 "VCHAR_UNI:64", 3198 "d M Y H:i" 3199 ], 3200 "user_style": [ 3201 "UINT", 3202 0 3203 ], 3204 "user_rank": [ 3205 "UINT", 3206 0 3207 ], 3208 "user_colour": [ 3209 "VCHAR:6", 3210 "" 3211 ], 3212 "user_new_privmsg": [ 3213 "INT:4", 3214 0 3215 ], 3216 "user_unread_privmsg": [ 3217 "INT:4", 3218 0 3219 ], 3220 "user_last_privmsg": [ 3221 "TIMESTAMP", 3222 0 3223 ], 3224 "user_message_rules": [ 3225 "BOOL", 3226 0 3227 ], 3228 "user_full_folder": [ 3229 "INT:11", 3230 -3 3231 ], 3232 "user_emailtime": [ 3233 "TIMESTAMP", 3234 0 3235 ], 3236 "user_topic_show_days": [ 3237 "USINT", 3238 0 3239 ], 3240 "user_topic_sortby_type": [ 3241 "VCHAR:1", 3242 "t" 3243 ], 3244 "user_topic_sortby_dir": [ 3245 "VCHAR:1", 3246 "d" 3247 ], 3248 "user_post_show_days": [ 3249 "USINT", 3250 0 3251 ], 3252 "user_post_sortby_type": [ 3253 "VCHAR:1", 3254 "t" 3255 ], 3256 "user_post_sortby_dir": [ 3257 "VCHAR:1", 3258 "a" 3259 ], 3260 "user_notify": [ 3261 "BOOL", 3262 0 3263 ], 3264 "user_notify_pm": [ 3265 "BOOL", 3266 1 3267 ], 3268 "user_notify_type": [ 3269 "TINT:4", 3270 0 3271 ], 3272 "user_allow_pm": [ 3273 "BOOL", 3274 1 3275 ], 3276 "user_allow_viewonline": [ 3277 "BOOL", 3278 1 3279 ], 3280 "user_allow_viewemail": [ 3281 "BOOL", 3282 1 3283 ], 3284 "user_allow_massemail": [ 3285 "BOOL", 3286 1 3287 ], 3288 "user_options": [ 3289 "UINT:11", 3290 230271 3291 ], 3292 "user_avatar": [ 3293 "VCHAR", 3294 "" 3295 ], 3296 "user_avatar_type": [ 3297 "VCHAR:255", 3298 "" 3299 ], 3300 "user_avatar_width": [ 3301 "USINT", 3302 0 3303 ], 3304 "user_avatar_height": [ 3305 "USINT", 3306 0 3307 ], 3308 "user_sig": [ 3309 "MTEXT_UNI", 3310 "" 3311 ], 3312 "user_sig_bbcode_uid": [ 3313 "VCHAR:8", 3314 "" 3315 ], 3316 "user_sig_bbcode_bitfield": [ 3317 "VCHAR:255", 3318 "" 3319 ], 3320 "user_jabber": [ 3321 "VCHAR_UNI", 3322 "" 3323 ], 3324 "user_actkey": [ 3325 "VCHAR:32", 3326 "" 3327 ], 3328 "user_newpasswd": [ 3329 "VCHAR:255", 3330 "" 3331 ], 3332 "user_form_salt": [ 3333 "VCHAR_UNI:32", 3334 "" 3335 ], 3336 "user_new": [ 3337 "BOOL", 3338 1 3339 ], 3340 "user_reminded": [ 3341 "TINT:4", 3342 0 3343 ], 3344 "user_reminded_time": [ 3345 "TIMESTAMP", 3346 0 3347 ] 3348 }, 3349 "PRIMARY_KEY": "user_id", 3350 "KEYS": { 3351 "user_birthday": [ 3352 "INDEX", 3353 "user_birthday" 3354 ], 3355 "user_email_hash": [ 3356 "INDEX", 3357 "user_email_hash" 3358 ], 3359 "user_type": [ 3360 "INDEX", 3361 "user_type" 3362 ], 3363 "username_clean": [ 3364 "UNIQUE", 3365 "username_clean" 3366 ] 3367 } 3368 }, 3369 "phpbb_warnings": { 3370 "COLUMNS": { 3371 "warning_id": [ 3372 "UINT", 3373 null, 3374 "auto_increment" 3375 ], 3376 "user_id": [ 3377 "ULINT", 3378 0 3379 ], 3380 "post_id": [ 3381 "ULINT", 3382 0 3383 ], 3384 "log_id": [ 3385 "ULINT", 3386 0 3387 ], 3388 "warning_time": [ 3389 "TIMESTAMP", 3390 0 3391 ] 3392 }, 3393 "PRIMARY_KEY": "warning_id" 3394 }, 3395 "phpbb_words": { 3396 "COLUMNS": { 3397 "word_id": [ 3398 "ULINT", 3399 null, 3400 "auto_increment" 3401 ], 3402 "word": [ 3403 "VCHAR_UNI", 3404 "" 3405 ], 3406 "replacement": [ 3407 "VCHAR_UNI", 3408 "" 3409 ] 3410 }, 3411 "PRIMARY_KEY": "word_id" 3412 }, 3413 "phpbb_zebra": { 3414 "COLUMNS": { 3415 "user_id": [ 3416 "ULINT", 3417 0 3418 ], 3419 "zebra_id": [ 3420 "ULINT", 3421 0 3422 ], 3423 "friend": [ 3424 "BOOL", 3425 0 3426 ], 3427 "foe": [ 3428 "BOOL", 3429 0 3430 ] 3431 }, 3432 "PRIMARY_KEY": [ 3433 "user_id", 3434 "zebra_id" 3435 ] 3436 } 3437 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Wed Nov 11 20:33:01 2020 | Cross-referenced by PHPXref 0.7.1 |