Verzeichnisstruktur phpBB-3.1.0


Veröffentlicht
27.10.2014

So funktioniert es


Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück

Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis.
Auf den Verzeichnisnamen klicken, dies zeigt nur das Verzeichnis mit Inhalt an

(Beispiel Datei-Icons)

Auf das Icon klicken um den Quellcode anzuzeigen

schema.json

Zuletzt modifiziert: 09.10.2024, 12:52 - Dateigröße: 72.96 KiB


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