[Summary view] [Print] [Text view]

   1  # DO NOT EDIT THIS FILE, IT IS GENERATED
   2  #
   3  # To change the contents of this file, edit
   4  # phpBB/develop/create_schema_files.php and
   5  # run it.
   6  # Table: 'phpbb_attachments'
   7  CREATE TABLE phpbb_attachments (
   8      attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   9      post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  10      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  11      in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
  12      poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  13      is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
  14      physical_filename varbinary(255) DEFAULT '' NOT NULL,
  15      real_filename varbinary(255) DEFAULT '' NOT NULL,
  16      download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  17      attach_comment blob NOT NULL,
  18      extension varbinary(100) DEFAULT '' NOT NULL,
  19      mimetype varbinary(100) DEFAULT '' NOT NULL,
  20      filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
  21      filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
  22      thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
  23      PRIMARY KEY (attach_id),
  24      KEY filetime (filetime),
  25      KEY post_msg_id (post_msg_id),
  26      KEY topic_id (topic_id),
  27      KEY poster_id (poster_id),
  28      KEY is_orphan (is_orphan)
  29  );
  30  
  31  
  32  # Table: 'phpbb_acl_groups'
  33  CREATE TABLE phpbb_acl_groups (
  34      group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  35      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  36      auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  37      auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  38      auth_setting tinyint(2) DEFAULT '0' NOT NULL,
  39      KEY group_id (group_id),
  40      KEY auth_opt_id (auth_option_id),
  41      KEY auth_role_id (auth_role_id)
  42  );
  43  
  44  
  45  # Table: 'phpbb_acl_options'
  46  CREATE TABLE phpbb_acl_options (
  47      auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
  48      auth_option varbinary(50) DEFAULT '' NOT NULL,
  49      is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
  50      is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
  51      founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
  52      PRIMARY KEY (auth_option_id),
  53      UNIQUE auth_option (auth_option)
  54  );
  55  
  56  
  57  # Table: 'phpbb_acl_roles'
  58  CREATE TABLE phpbb_acl_roles (
  59      role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
  60      role_name blob NOT NULL,
  61      role_description blob NOT NULL,
  62      role_type varbinary(10) DEFAULT '' NOT NULL,
  63      role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
  64      PRIMARY KEY (role_id),
  65      KEY role_type (role_type),
  66      KEY role_order (role_order)
  67  );
  68  
  69  
  70  # Table: 'phpbb_acl_roles_data'
  71  CREATE TABLE phpbb_acl_roles_data (
  72      role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  73      auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  74      auth_setting tinyint(2) DEFAULT '0' NOT NULL,
  75      PRIMARY KEY (role_id, auth_option_id),
  76      KEY ath_op_id (auth_option_id)
  77  );
  78  
  79  
  80  # Table: 'phpbb_acl_users'
  81  CREATE TABLE phpbb_acl_users (
  82      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  83      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  84      auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  85      auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  86      auth_setting tinyint(2) DEFAULT '0' NOT NULL,
  87      KEY user_id (user_id),
  88      KEY auth_option_id (auth_option_id),
  89      KEY auth_role_id (auth_role_id)
  90  );
  91  
  92  
  93  # Table: 'phpbb_banlist'
  94  CREATE TABLE phpbb_banlist (
  95      ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
  96      ban_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  97      ban_ip varbinary(40) DEFAULT '' NOT NULL,
  98      ban_email blob NOT NULL,
  99      ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
 100      ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,
 101      ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 102      ban_reason blob NOT NULL,
 103      ban_give_reason blob NOT NULL,
 104      PRIMARY KEY (ban_id),
 105      KEY ban_end (ban_end),
 106      KEY ban_user (ban_userid, ban_exclude),
 107      KEY ban_email (ban_email(255), ban_exclude),
 108      KEY ban_ip (ban_ip, ban_exclude)
 109  );
 110  
 111  
 112  # Table: 'phpbb_bbcodes'
 113  CREATE TABLE phpbb_bbcodes (
 114      bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 115      bbcode_tag varbinary(16) DEFAULT '' NOT NULL,
 116      bbcode_helpline blob NOT NULL,
 117      display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 118      bbcode_match blob NOT NULL,
 119      bbcode_tpl mediumblob NOT NULL,
 120      first_pass_match mediumblob NOT NULL,
 121      first_pass_replace mediumblob NOT NULL,
 122      second_pass_match mediumblob NOT NULL,
 123      second_pass_replace mediumblob NOT NULL,
 124      PRIMARY KEY (bbcode_id),
 125      KEY display_on_post (display_on_posting)
 126  );
 127  
 128  
 129  # Table: 'phpbb_bookmarks'
 130  CREATE TABLE phpbb_bookmarks (
 131      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 132      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 133      PRIMARY KEY (topic_id, user_id)
 134  );
 135  
 136  
 137  # Table: 'phpbb_bots'
 138  CREATE TABLE phpbb_bots (
 139      bot_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 140      bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 141      bot_name blob NOT NULL,
 142      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 143      bot_agent varbinary(255) DEFAULT '' NOT NULL,
 144      bot_ip varbinary(255) DEFAULT '' NOT NULL,
 145      PRIMARY KEY (bot_id),
 146      KEY bot_active (bot_active)
 147  );
 148  
 149  
 150  # Table: 'phpbb_config'
 151  CREATE TABLE phpbb_config (
 152      config_name varbinary(255) DEFAULT '' NOT NULL,
 153      config_value blob NOT NULL,
 154      is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 155      PRIMARY KEY (config_name),
 156      KEY is_dynamic (is_dynamic)
 157  );
 158  
 159  
 160  # Table: 'phpbb_confirm'
 161  CREATE TABLE phpbb_confirm (
 162      confirm_id binary(32) DEFAULT '' NOT NULL,
 163      session_id binary(32) DEFAULT '' NOT NULL,
 164      confirm_type tinyint(3) DEFAULT '0' NOT NULL,
 165      code varbinary(8) DEFAULT '' NOT NULL,
 166      seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
 167      attempts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 168      PRIMARY KEY (session_id, confirm_id),
 169      KEY confirm_type (confirm_type)
 170  );
 171  
 172  
 173  # Table: 'phpbb_disallow'
 174  CREATE TABLE phpbb_disallow (
 175      disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 176      disallow_username blob NOT NULL,
 177      PRIMARY KEY (disallow_id)
 178  );
 179  
 180  
 181  # Table: 'phpbb_drafts'
 182  CREATE TABLE phpbb_drafts (
 183      draft_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 184      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 185      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 186      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 187      save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 188      draft_subject blob NOT NULL,
 189      draft_message mediumblob NOT NULL,
 190      PRIMARY KEY (draft_id),
 191      KEY save_time (save_time)
 192  );
 193  
 194  
 195  # Table: 'phpbb_extensions'
 196  CREATE TABLE phpbb_extensions (
 197      extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 198      group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 199      extension varbinary(100) DEFAULT '' NOT NULL,
 200      PRIMARY KEY (extension_id)
 201  );
 202  
 203  
 204  # Table: 'phpbb_extension_groups'
 205  CREATE TABLE phpbb_extension_groups (
 206      group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 207      group_name blob NOT NULL,
 208      cat_id tinyint(2) DEFAULT '0' NOT NULL,
 209      allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 210      download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 211      upload_icon varbinary(255) DEFAULT '' NOT NULL,
 212      max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
 213      allowed_forums blob NOT NULL,
 214      allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 215      PRIMARY KEY (group_id)
 216  );
 217  
 218  
 219  # Table: 'phpbb_forums'
 220  CREATE TABLE phpbb_forums (
 221      forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 222      parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 223      left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 224      right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 225      forum_parents mediumblob NOT NULL,
 226      forum_name blob NOT NULL,
 227      forum_desc blob NOT NULL,
 228      forum_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
 229      forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
 230      forum_desc_uid varbinary(8) DEFAULT '' NOT NULL,
 231      forum_link blob NOT NULL,
 232      forum_password varbinary(120) DEFAULT '' NOT NULL,
 233      forum_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 234      forum_image varbinary(255) DEFAULT '' NOT NULL,
 235      forum_rules blob NOT NULL,
 236      forum_rules_link blob NOT NULL,
 237      forum_rules_bitfield varbinary(255) DEFAULT '' NOT NULL,
 238      forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
 239      forum_rules_uid varbinary(8) DEFAULT '' NOT NULL,
 240      forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
 241      forum_type tinyint(4) DEFAULT '0' NOT NULL,
 242      forum_status tinyint(4) DEFAULT '0' NOT NULL,
 243      forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 244      forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 245      forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 246      forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 247      forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 248      forum_last_post_subject blob NOT NULL,
 249      forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 250      forum_last_poster_name blob NOT NULL,
 251      forum_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,
 252      forum_flags tinyint(4) DEFAULT '32' NOT NULL,
 253      forum_options int(20) UNSIGNED DEFAULT '0' NOT NULL,
 254      display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 255      display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 256      enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 257      enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 258      enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 259      prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,
 260      prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 261      prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 262      prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 263      PRIMARY KEY (forum_id),
 264      KEY left_right_id (left_id, right_id),
 265      KEY forum_lastpost_id (forum_last_post_id)
 266  );
 267  
 268  
 269  # Table: 'phpbb_forums_access'
 270  CREATE TABLE phpbb_forums_access (
 271      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 272      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 273      session_id binary(32) DEFAULT '' NOT NULL,
 274      PRIMARY KEY (forum_id, user_id, session_id)
 275  );
 276  
 277  
 278  # Table: 'phpbb_forums_track'
 279  CREATE TABLE phpbb_forums_track (
 280      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 281      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 282      mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 283      PRIMARY KEY (user_id, forum_id)
 284  );
 285  
 286  
 287  # Table: 'phpbb_forums_watch'
 288  CREATE TABLE phpbb_forums_watch (
 289      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 290      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 291      notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 292      KEY forum_id (forum_id),
 293      KEY user_id (user_id),
 294      KEY notify_stat (notify_status)
 295  );
 296  
 297  
 298  # Table: 'phpbb_groups'
 299  CREATE TABLE phpbb_groups (
 300      group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 301      group_type tinyint(4) DEFAULT '1' NOT NULL,
 302      group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 303      group_skip_auth tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 304      group_name blob NOT NULL,
 305      group_desc blob NOT NULL,
 306      group_desc_bitfield varbinary(255) DEFAULT '' NOT NULL,
 307      group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
 308      group_desc_uid varbinary(8) DEFAULT '' NOT NULL,
 309      group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 310      group_avatar varbinary(255) DEFAULT '' NOT NULL,
 311      group_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
 312      group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 313      group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 314      group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 315      group_colour varbinary(6) DEFAULT '' NOT NULL,
 316      group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 317      group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 318      group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 319      group_max_recipients mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 320      group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 321      PRIMARY KEY (group_id),
 322      KEY group_legend_name (group_legend, group_name(255))
 323  );
 324  
 325  
 326  # Table: 'phpbb_icons'
 327  CREATE TABLE phpbb_icons (
 328      icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 329      icons_url varbinary(255) DEFAULT '' NOT NULL,
 330      icons_width tinyint(4) DEFAULT '0' NOT NULL,
 331      icons_height tinyint(4) DEFAULT '0' NOT NULL,
 332      icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 333      display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 334      PRIMARY KEY (icons_id),
 335      KEY display_on_posting (display_on_posting)
 336  );
 337  
 338  
 339  # Table: 'phpbb_lang'
 340  CREATE TABLE phpbb_lang (
 341      lang_id tinyint(4) NOT NULL auto_increment,
 342      lang_iso varbinary(30) DEFAULT '' NOT NULL,
 343      lang_dir varbinary(30) DEFAULT '' NOT NULL,
 344      lang_english_name blob NOT NULL,
 345      lang_local_name blob NOT NULL,
 346      lang_author blob NOT NULL,
 347      PRIMARY KEY (lang_id),
 348      KEY lang_iso (lang_iso)
 349  );
 350  
 351  
 352  # Table: 'phpbb_log'
 353  CREATE TABLE phpbb_log (
 354      log_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 355      log_type tinyint(4) DEFAULT '0' NOT NULL,
 356      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 357      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 358      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 359      reportee_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 360      log_ip varbinary(40) DEFAULT '' NOT NULL,
 361      log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 362      log_operation blob NOT NULL,
 363      log_data mediumblob NOT NULL,
 364      PRIMARY KEY (log_id),
 365      KEY log_type (log_type),
 366      KEY forum_id (forum_id),
 367      KEY topic_id (topic_id),
 368      KEY reportee_id (reportee_id),
 369      KEY user_id (user_id)
 370  );
 371  
 372  
 373  # Table: 'phpbb_login_attempts'
 374  CREATE TABLE phpbb_login_attempts (
 375      attempt_ip varbinary(40) DEFAULT '' NOT NULL,
 376      attempt_browser varbinary(150) DEFAULT '' NOT NULL,
 377      attempt_forwarded_for varbinary(255) DEFAULT '' NOT NULL,
 378      attempt_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 379      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 380      username blob NOT NULL,
 381      username_clean blob NOT NULL,
 382      KEY att_ip (attempt_ip, attempt_time),
 383      KEY att_for (attempt_forwarded_for, attempt_time),
 384      KEY att_time (attempt_time),
 385      KEY user_id (user_id)
 386  );
 387  
 388  
 389  # Table: 'phpbb_moderator_cache'
 390  CREATE TABLE phpbb_moderator_cache (
 391      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 392      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 393      username blob NOT NULL,
 394      group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 395      group_name blob NOT NULL,
 396      display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 397      KEY disp_idx (display_on_index),
 398      KEY forum_id (forum_id)
 399  );
 400  
 401  
 402  # Table: 'phpbb_modules'
 403  CREATE TABLE phpbb_modules (
 404      module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 405      module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 406      module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 407      module_basename varbinary(255) DEFAULT '' NOT NULL,
 408      module_class varbinary(10) DEFAULT '' NOT NULL,
 409      parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 410      left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 411      right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 412      module_langname varbinary(255) DEFAULT '' NOT NULL,
 413      module_mode varbinary(255) DEFAULT '' NOT NULL,
 414      module_auth varbinary(255) DEFAULT '' NOT NULL,
 415      PRIMARY KEY (module_id),
 416      KEY left_right_id (left_id, right_id),
 417      KEY module_enabled (module_enabled),
 418      KEY class_left_id (module_class, left_id)
 419  );
 420  
 421  
 422  # Table: 'phpbb_poll_options'
 423  CREATE TABLE phpbb_poll_options (
 424      poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
 425      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 426      poll_option_text blob NOT NULL,
 427      poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 428      KEY poll_opt_id (poll_option_id),
 429      KEY topic_id (topic_id)
 430  );
 431  
 432  
 433  # Table: 'phpbb_poll_votes'
 434  CREATE TABLE phpbb_poll_votes (
 435      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 436      poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
 437      vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 438      vote_user_ip varbinary(40) DEFAULT '' NOT NULL,
 439      KEY topic_id (topic_id),
 440      KEY vote_user_id (vote_user_id),
 441      KEY vote_user_ip (vote_user_ip)
 442  );
 443  
 444  
 445  # Table: 'phpbb_posts'
 446  CREATE TABLE phpbb_posts (
 447      post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 448      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 449      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 450      poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 451      icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 452      poster_ip varbinary(40) DEFAULT '' NOT NULL,
 453      post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 454      post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 455      post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 456      enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 457      enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 458      enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 459      enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 460      post_username blob NOT NULL,
 461      post_subject blob NOT NULL,
 462      post_text mediumblob NOT NULL,
 463      post_checksum varbinary(32) DEFAULT '' NOT NULL,
 464      post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 465      bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
 466      bbcode_uid varbinary(8) DEFAULT '' NOT NULL,
 467      post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 468      post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 469      post_edit_reason blob NOT NULL,
 470      post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 471      post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 472      post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 473      PRIMARY KEY (post_id),
 474      KEY forum_id (forum_id),
 475      KEY topic_id (topic_id),
 476      KEY poster_ip (poster_ip),
 477      KEY poster_id (poster_id),
 478      KEY post_approved (post_approved),
 479      KEY post_username (post_username(255)),
 480      KEY tid_post_time (topic_id, post_time)
 481  );
 482  
 483  
 484  # Table: 'phpbb_privmsgs'
 485  CREATE TABLE phpbb_privmsgs (
 486      msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 487      root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 488      author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 489      icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 490      author_ip varbinary(40) DEFAULT '' NOT NULL,
 491      message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 492      enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 493      enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 494      enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 495      enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 496      message_subject blob NOT NULL,
 497      message_text mediumblob NOT NULL,
 498      message_edit_reason blob NOT NULL,
 499      message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 500      message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 501      bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
 502      bbcode_uid varbinary(8) DEFAULT '' NOT NULL,
 503      message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 504      message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 505      to_address blob NOT NULL,
 506      bcc_address blob NOT NULL,
 507      message_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 508      PRIMARY KEY (msg_id),
 509      KEY author_ip (author_ip),
 510      KEY message_time (message_time),
 511      KEY author_id (author_id),
 512      KEY root_level (root_level)
 513  );
 514  
 515  
 516  # Table: 'phpbb_privmsgs_folder'
 517  CREATE TABLE phpbb_privmsgs_folder (
 518      folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 519      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 520      folder_name blob NOT NULL,
 521      pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 522      PRIMARY KEY (folder_id),
 523      KEY user_id (user_id)
 524  );
 525  
 526  
 527  # Table: 'phpbb_privmsgs_rules'
 528  CREATE TABLE phpbb_privmsgs_rules (
 529      rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 530      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 531      rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 532      rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 533      rule_string blob NOT NULL,
 534      rule_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 535      rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 536      rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 537      rule_folder_id int(11) DEFAULT '0' NOT NULL,
 538      PRIMARY KEY (rule_id),
 539      KEY user_id (user_id)
 540  );
 541  
 542  
 543  # Table: 'phpbb_privmsgs_to'
 544  CREATE TABLE phpbb_privmsgs_to (
 545      msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 546      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 547      author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 548      pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 549      pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 550      pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 551      pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 552      pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 553      pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 554      folder_id int(11) DEFAULT '0' NOT NULL,
 555      KEY msg_id (msg_id),
 556      KEY author_id (author_id),
 557      KEY usr_flder_id (user_id, folder_id)
 558  );
 559  
 560  
 561  # Table: 'phpbb_profile_fields'
 562  CREATE TABLE phpbb_profile_fields (
 563      field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 564      field_name blob NOT NULL,
 565      field_type tinyint(4) DEFAULT '0' NOT NULL,
 566      field_ident varbinary(20) DEFAULT '' NOT NULL,
 567      field_length varbinary(20) DEFAULT '' NOT NULL,
 568      field_minlen varbinary(255) DEFAULT '' NOT NULL,
 569      field_maxlen varbinary(255) DEFAULT '' NOT NULL,
 570      field_novalue blob NOT NULL,
 571      field_default_value blob NOT NULL,
 572      field_validation varbinary(60) DEFAULT '' NOT NULL,
 573      field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 574      field_show_novalue tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 575      field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 576      field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 577      field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 578      field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 579      field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 580      field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 581      field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 582      PRIMARY KEY (field_id),
 583      KEY fld_type (field_type),
 584      KEY fld_ordr (field_order)
 585  );
 586  
 587  
 588  # Table: 'phpbb_profile_fields_data'
 589  CREATE TABLE phpbb_profile_fields_data (
 590      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 591      PRIMARY KEY (user_id)
 592  );
 593  
 594  
 595  # Table: 'phpbb_profile_fields_lang'
 596  CREATE TABLE phpbb_profile_fields_lang (
 597      field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 598      lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 599      option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 600      field_type tinyint(4) DEFAULT '0' NOT NULL,
 601      lang_value blob NOT NULL,
 602      PRIMARY KEY (field_id, lang_id, option_id)
 603  );
 604  
 605  
 606  # Table: 'phpbb_profile_lang'
 607  CREATE TABLE phpbb_profile_lang (
 608      field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 609      lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 610      lang_name blob NOT NULL,
 611      lang_explain blob NOT NULL,
 612      lang_default_value blob NOT NULL,
 613      PRIMARY KEY (field_id, lang_id)
 614  );
 615  
 616  
 617  # Table: 'phpbb_ranks'
 618  CREATE TABLE phpbb_ranks (
 619      rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 620      rank_title blob NOT NULL,
 621      rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 622      rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 623      rank_image varbinary(255) DEFAULT '' NOT NULL,
 624      PRIMARY KEY (rank_id)
 625  );
 626  
 627  
 628  # Table: 'phpbb_reports'
 629  CREATE TABLE phpbb_reports (
 630      report_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 631      reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 632      post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 633      pm_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 634      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 635      user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 636      report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 637      report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 638      report_text mediumblob NOT NULL,
 639      PRIMARY KEY (report_id),
 640      KEY post_id (post_id),
 641      KEY pm_id (pm_id)
 642  );
 643  
 644  
 645  # Table: 'phpbb_reports_reasons'
 646  CREATE TABLE phpbb_reports_reasons (
 647      reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
 648      reason_title blob NOT NULL,
 649      reason_description mediumblob NOT NULL,
 650      reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 651      PRIMARY KEY (reason_id)
 652  );
 653  
 654  
 655  # Table: 'phpbb_search_results'
 656  CREATE TABLE phpbb_search_results (
 657      search_key varbinary(32) DEFAULT '' NOT NULL,
 658      search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 659      search_keywords mediumblob NOT NULL,
 660      search_authors mediumblob NOT NULL,
 661      PRIMARY KEY (search_key)
 662  );
 663  
 664  
 665  # Table: 'phpbb_search_wordlist'
 666  CREATE TABLE phpbb_search_wordlist (
 667      word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 668      word_text blob NOT NULL,
 669      word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 670      word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 671      PRIMARY KEY (word_id),
 672      UNIQUE wrd_txt (word_text(255)),
 673      KEY wrd_cnt (word_count)
 674  );
 675  
 676  
 677  # Table: 'phpbb_search_wordmatch'
 678  CREATE TABLE phpbb_search_wordmatch (
 679      post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 680      word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 681      title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 682      UNIQUE unq_mtch (word_id, post_id, title_match),
 683      KEY word_id (word_id),
 684      KEY post_id (post_id)
 685  );
 686  
 687  
 688  # Table: 'phpbb_sessions'
 689  CREATE TABLE phpbb_sessions (
 690      session_id binary(32) DEFAULT '' NOT NULL,
 691      session_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 692      session_forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 693      session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
 694      session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
 695      session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 696      session_ip varbinary(40) DEFAULT '' NOT NULL,
 697      session_browser varbinary(150) DEFAULT '' NOT NULL,
 698      session_forwarded_for varbinary(255) DEFAULT '' NOT NULL,
 699      session_page blob NOT NULL,
 700      session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 701      session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 702      session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 703      PRIMARY KEY (session_id),
 704      KEY session_time (session_time),
 705      KEY session_user_id (session_user_id),
 706      KEY session_fid (session_forum_id)
 707  );
 708  
 709  
 710  # Table: 'phpbb_sessions_keys'
 711  CREATE TABLE phpbb_sessions_keys (
 712      key_id binary(32) DEFAULT '' NOT NULL,
 713      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 714      last_ip varbinary(40) DEFAULT '' NOT NULL,
 715      last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,
 716      PRIMARY KEY (key_id, user_id),
 717      KEY last_login (last_login)
 718  );
 719  
 720  
 721  # Table: 'phpbb_sitelist'
 722  CREATE TABLE phpbb_sitelist (
 723      site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 724      site_ip varbinary(40) DEFAULT '' NOT NULL,
 725      site_hostname varbinary(255) DEFAULT '' NOT NULL,
 726      ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 727      PRIMARY KEY (site_id)
 728  );
 729  
 730  
 731  # Table: 'phpbb_smilies'
 732  CREATE TABLE phpbb_smilies (
 733      smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 734      code varbinary(150) DEFAULT '' NOT NULL,
 735      emotion varbinary(150) DEFAULT '' NOT NULL,
 736      smiley_url varbinary(50) DEFAULT '' NOT NULL,
 737      smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 738      smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 739      smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 740      display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 741      PRIMARY KEY (smiley_id),
 742      KEY display_on_post (display_on_posting)
 743  );
 744  
 745  
 746  # Table: 'phpbb_styles'
 747  CREATE TABLE phpbb_styles (
 748      style_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 749      style_name blob NOT NULL,
 750      style_copyright blob NOT NULL,
 751      style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 752      template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 753      theme_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 754      imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 755      PRIMARY KEY (style_id),
 756      UNIQUE style_name (style_name(255)),
 757      KEY template_id (template_id),
 758      KEY theme_id (theme_id),
 759      KEY imageset_id (imageset_id)
 760  );
 761  
 762  
 763  # Table: 'phpbb_styles_template'
 764  CREATE TABLE phpbb_styles_template (
 765      template_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 766      template_name blob NOT NULL,
 767      template_copyright blob NOT NULL,
 768      template_path varbinary(100) DEFAULT '' NOT NULL,
 769      bbcode_bitfield varbinary(255) DEFAULT 'kNg=' NOT NULL,
 770      template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 771      template_inherits_id int(4) UNSIGNED DEFAULT '0' NOT NULL,
 772      template_inherit_path varbinary(255) DEFAULT '' NOT NULL,
 773      PRIMARY KEY (template_id),
 774      UNIQUE tmplte_nm (template_name(255))
 775  );
 776  
 777  
 778  # Table: 'phpbb_styles_template_data'
 779  CREATE TABLE phpbb_styles_template_data (
 780      template_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 781      template_filename varbinary(100) DEFAULT '' NOT NULL,
 782      template_included blob NOT NULL,
 783      template_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
 784      template_data mediumblob NOT NULL,
 785      KEY tid (template_id),
 786      KEY tfn (template_filename)
 787  );
 788  
 789  
 790  # Table: 'phpbb_styles_theme'
 791  CREATE TABLE phpbb_styles_theme (
 792      theme_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 793      theme_name blob NOT NULL,
 794      theme_copyright blob NOT NULL,
 795      theme_path varbinary(100) DEFAULT '' NOT NULL,
 796      theme_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 797      theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
 798      theme_data mediumblob NOT NULL,
 799      PRIMARY KEY (theme_id),
 800      UNIQUE theme_name (theme_name(255))
 801  );
 802  
 803  
 804  # Table: 'phpbb_styles_imageset'
 805  CREATE TABLE phpbb_styles_imageset (
 806      imageset_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 807      imageset_name blob NOT NULL,
 808      imageset_copyright blob NOT NULL,
 809      imageset_path varbinary(100) DEFAULT '' NOT NULL,
 810      PRIMARY KEY (imageset_id),
 811      UNIQUE imgset_nm (imageset_name(255))
 812  );
 813  
 814  
 815  # Table: 'phpbb_styles_imageset_data'
 816  CREATE TABLE phpbb_styles_imageset_data (
 817      image_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 818      image_name varbinary(200) DEFAULT '' NOT NULL,
 819      image_filename varbinary(200) DEFAULT '' NOT NULL,
 820      image_lang varbinary(30) DEFAULT '' NOT NULL,
 821      image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 822      image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 823      imageset_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 824      PRIMARY KEY (image_id),
 825      KEY i_d (imageset_id)
 826  );
 827  
 828  
 829  # Table: 'phpbb_topics'
 830  CREATE TABLE phpbb_topics (
 831      topic_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 832      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 833      icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 834      topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 835      topic_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 836      topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 837      topic_title blob NOT NULL,
 838      topic_poster mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 839      topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 840      topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
 841      topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 842      topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 843      topic_replies_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 844      topic_status tinyint(3) DEFAULT '0' NOT NULL,
 845      topic_type tinyint(3) DEFAULT '0' NOT NULL,
 846      topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 847      topic_first_poster_name blob NOT NULL,
 848      topic_first_poster_colour varbinary(6) DEFAULT '' NOT NULL,
 849      topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 850      topic_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 851      topic_last_poster_name blob NOT NULL,
 852      topic_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,
 853      topic_last_post_subject blob NOT NULL,
 854      topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 855      topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 856      topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 857      topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 858      topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 859      poll_title blob NOT NULL,
 860      poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
 861      poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
 862      poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
 863      poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,
 864      poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 865      PRIMARY KEY (topic_id),
 866      KEY forum_id (forum_id),
 867      KEY forum_id_type (forum_id, topic_type),
 868      KEY last_post_time (topic_last_post_time),
 869      KEY topic_approved (topic_approved),
 870      KEY forum_appr_last (forum_id, topic_approved, topic_last_post_id),
 871      KEY fid_time_moved (forum_id, topic_last_post_time, topic_moved_id)
 872  );
 873  
 874  
 875  # Table: 'phpbb_topics_track'
 876  CREATE TABLE phpbb_topics_track (
 877      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 878      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 879      forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 880      mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 881      PRIMARY KEY (user_id, topic_id),
 882      KEY topic_id (topic_id),
 883      KEY forum_id (forum_id)
 884  );
 885  
 886  
 887  # Table: 'phpbb_topics_posted'
 888  CREATE TABLE phpbb_topics_posted (
 889      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 890      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 891      topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 892      PRIMARY KEY (user_id, topic_id)
 893  );
 894  
 895  
 896  # Table: 'phpbb_topics_watch'
 897  CREATE TABLE phpbb_topics_watch (
 898      topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 899      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 900      notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 901      KEY topic_id (topic_id),
 902      KEY user_id (user_id),
 903      KEY notify_stat (notify_status)
 904  );
 905  
 906  
 907  # Table: 'phpbb_user_group'
 908  CREATE TABLE phpbb_user_group (
 909      group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 910      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 911      group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 912      user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 913      KEY group_id (group_id),
 914      KEY user_id (user_id),
 915      KEY group_leader (group_leader)
 916  );
 917  
 918  
 919  # Table: 'phpbb_users'
 920  CREATE TABLE phpbb_users (
 921      user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
 922      user_type tinyint(2) DEFAULT '0' NOT NULL,
 923      group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
 924      user_permissions mediumblob NOT NULL,
 925      user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 926      user_ip varbinary(40) DEFAULT '' NOT NULL,
 927      user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
 928      username blob NOT NULL,
 929      username_clean blob NOT NULL,
 930      user_password varbinary(120) DEFAULT '' NOT NULL,
 931      user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
 932      user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 933      user_email blob NOT NULL,
 934      user_email_hash bigint(20) DEFAULT '0' NOT NULL,
 935      user_birthday varbinary(10) DEFAULT '' NOT NULL,
 936      user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
 937      user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
 938      user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 939      user_lastpage blob NOT NULL,
 940      user_last_confirm_key varbinary(10) DEFAULT '' NOT NULL,
 941      user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
 942      user_warnings tinyint(4) DEFAULT '0' NOT NULL,
 943      user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
 944      user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
 945      user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
 946      user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 947      user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 948      user_lang varbinary(30) DEFAULT '' NOT NULL,
 949      user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
 950      user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 951      user_dateformat varbinary(90) DEFAULT 'd M Y H:i' NOT NULL,
 952      user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 953      user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
 954      user_colour varbinary(6) DEFAULT '' NOT NULL,
 955      user_new_privmsg int(4) DEFAULT '0' NOT NULL,
 956      user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
 957      user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
 958      user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 959      user_full_folder int(11) DEFAULT '-3' NOT NULL,
 960      user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
 961      user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 962      user_topic_sortby_type varbinary(1) DEFAULT 't' NOT NULL,
 963      user_topic_sortby_dir varbinary(1) DEFAULT 'd' NOT NULL,
 964      user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 965      user_post_sortby_type varbinary(1) DEFAULT 't' NOT NULL,
 966      user_post_sortby_dir varbinary(1) DEFAULT 'a' NOT NULL,
 967      user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
 968      user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 969      user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
 970      user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 971      user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 972      user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 973      user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 974      user_options int(11) UNSIGNED DEFAULT '230271' NOT NULL,
 975      user_avatar varbinary(255) DEFAULT '' NOT NULL,
 976      user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
 977      user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 978      user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
 979      user_sig mediumblob NOT NULL,
 980      user_sig_bbcode_uid varbinary(8) DEFAULT '' NOT NULL,
 981      user_sig_bbcode_bitfield varbinary(255) DEFAULT '' NOT NULL,
 982      user_from blob NOT NULL,
 983      user_icq varbinary(15) DEFAULT '' NOT NULL,
 984      user_aim blob NOT NULL,
 985      user_yim blob NOT NULL,
 986      user_msnm blob NOT NULL,
 987      user_jabber blob NOT NULL,
 988      user_website blob NOT NULL,
 989      user_occ blob NOT NULL,
 990      user_interests blob NOT NULL,
 991      user_actkey varbinary(32) DEFAULT '' NOT NULL,
 992      user_newpasswd varbinary(120) DEFAULT '' NOT NULL,
 993      user_form_salt varbinary(96) DEFAULT '' NOT NULL,
 994      user_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
 995      user_reminded tinyint(4) DEFAULT '0' NOT NULL,
 996      user_reminded_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
 997      PRIMARY KEY (user_id),
 998      KEY user_birthday (user_birthday),
 999      KEY user_email_hash (user_email_hash),
1000      KEY user_type (user_type),
1001      UNIQUE username_clean (username_clean(255))
1002  );
1003  
1004  
1005  # Table: 'phpbb_warnings'
1006  CREATE TABLE phpbb_warnings (
1007      warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
1008      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
1009      post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
1010      log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
1011      warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
1012      PRIMARY KEY (warning_id)
1013  );
1014  
1015  
1016  # Table: 'phpbb_words'
1017  CREATE TABLE phpbb_words (
1018      word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
1019      word blob NOT NULL,
1020      replacement blob NOT NULL,
1021      PRIMARY KEY (word_id)
1022  );
1023  
1024  
1025  # Table: 'phpbb_zebra'
1026  CREATE TABLE phpbb_zebra (
1027      user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
1028      zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
1029      friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
1030      foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
1031      PRIMARY KEY (user_id, zebra_id)
1032  );
1033  
1034