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