[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  
   7  # Table: 'phpbb_attachments'
   8  CREATE TABLE phpbb_attachments (
   9      attach_id INTEGER NOT NULL,
  10      post_msg_id INTEGER DEFAULT 0 NOT NULL,
  11      topic_id INTEGER DEFAULT 0 NOT NULL,
  12      in_message INTEGER DEFAULT 0 NOT NULL,
  13      poster_id INTEGER DEFAULT 0 NOT NULL,
  14      is_orphan INTEGER DEFAULT 1 NOT NULL,
  15      physical_filename VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
  16      real_filename VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
  17      download_count INTEGER DEFAULT 0 NOT NULL,
  18      attach_comment BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
  19      extension VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
  20      mimetype VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
  21      filesize INTEGER DEFAULT 0 NOT NULL,
  22      filetime INTEGER DEFAULT 0 NOT NULL,
  23      thumbnail INTEGER DEFAULT 0 NOT NULL
  24  );;
  25  
  26  ALTER TABLE phpbb_attachments ADD PRIMARY KEY (attach_id);;
  27  
  28  CREATE INDEX phpbb_attachments_filetime ON phpbb_attachments(filetime);;
  29  CREATE INDEX phpbb_attachments_post_msg_id ON phpbb_attachments(post_msg_id);;
  30  CREATE INDEX phpbb_attachments_topic_id ON phpbb_attachments(topic_id);;
  31  CREATE INDEX phpbb_attachments_poster_id ON phpbb_attachments(poster_id);;
  32  CREATE INDEX phpbb_attachments_is_orphan ON phpbb_attachments(is_orphan);;
  33  
  34  CREATE GENERATOR phpbb_attachments_gen;;
  35  SET GENERATOR phpbb_attachments_gen TO 0;;
  36  
  37  CREATE TRIGGER t_phpbb_attachments FOR phpbb_attachments
  38  BEFORE INSERT
  39  AS
  40  BEGIN
  41      NEW.attach_id = GEN_ID(phpbb_attachments_gen, 1);
  42  END;;
  43  
  44  
  45  # Table: 'phpbb_acl_groups'
  46  CREATE TABLE phpbb_acl_groups (
  47      group_id INTEGER DEFAULT 0 NOT NULL,
  48      forum_id INTEGER DEFAULT 0 NOT NULL,
  49      auth_option_id INTEGER DEFAULT 0 NOT NULL,
  50      auth_role_id INTEGER DEFAULT 0 NOT NULL,
  51      auth_setting INTEGER DEFAULT 0 NOT NULL
  52  );;
  53  
  54  CREATE INDEX phpbb_acl_groups_group_id ON phpbb_acl_groups(group_id);;
  55  CREATE INDEX phpbb_acl_groups_auth_opt_id ON phpbb_acl_groups(auth_option_id);;
  56  CREATE INDEX phpbb_acl_groups_auth_role_id ON phpbb_acl_groups(auth_role_id);;
  57  
  58  # Table: 'phpbb_acl_options'
  59  CREATE TABLE phpbb_acl_options (
  60      auth_option_id INTEGER NOT NULL,
  61      auth_option VARCHAR(50) CHARACTER SET NONE DEFAULT '' NOT NULL,
  62      is_global INTEGER DEFAULT 0 NOT NULL,
  63      is_local INTEGER DEFAULT 0 NOT NULL,
  64      founder_only INTEGER DEFAULT 0 NOT NULL
  65  );;
  66  
  67  ALTER TABLE phpbb_acl_options ADD PRIMARY KEY (auth_option_id);;
  68  
  69  CREATE UNIQUE INDEX phpbb_acl_options_auth_option ON phpbb_acl_options(auth_option);;
  70  
  71  CREATE GENERATOR phpbb_acl_options_gen;;
  72  SET GENERATOR phpbb_acl_options_gen TO 0;;
  73  
  74  CREATE TRIGGER t_phpbb_acl_options FOR phpbb_acl_options
  75  BEFORE INSERT
  76  AS
  77  BEGIN
  78      NEW.auth_option_id = GEN_ID(phpbb_acl_options_gen, 1);
  79  END;;
  80  
  81  
  82  # Table: 'phpbb_acl_roles'
  83  CREATE TABLE phpbb_acl_roles (
  84      role_id INTEGER NOT NULL,
  85      role_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
  86      role_description BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
  87      role_type VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
  88      role_order INTEGER DEFAULT 0 NOT NULL
  89  );;
  90  
  91  ALTER TABLE phpbb_acl_roles ADD PRIMARY KEY (role_id);;
  92  
  93  CREATE INDEX phpbb_acl_roles_role_type ON phpbb_acl_roles(role_type);;
  94  CREATE INDEX phpbb_acl_roles_role_order ON phpbb_acl_roles(role_order);;
  95  
  96  CREATE GENERATOR phpbb_acl_roles_gen;;
  97  SET GENERATOR phpbb_acl_roles_gen TO 0;;
  98  
  99  CREATE TRIGGER t_phpbb_acl_roles FOR phpbb_acl_roles
 100  BEFORE INSERT
 101  AS
 102  BEGIN
 103      NEW.role_id = GEN_ID(phpbb_acl_roles_gen, 1);
 104  END;;
 105  
 106  
 107  # Table: 'phpbb_acl_roles_data'
 108  CREATE TABLE phpbb_acl_roles_data (
 109      role_id INTEGER DEFAULT 0 NOT NULL,
 110      auth_option_id INTEGER DEFAULT 0 NOT NULL,
 111      auth_setting INTEGER DEFAULT 0 NOT NULL
 112  );;
 113  
 114  ALTER TABLE phpbb_acl_roles_data ADD PRIMARY KEY (role_id, auth_option_id);;
 115  
 116  CREATE INDEX phpbb_acl_roles_data_ath_op_id ON phpbb_acl_roles_data(auth_option_id);;
 117  
 118  # Table: 'phpbb_acl_users'
 119  CREATE TABLE phpbb_acl_users (
 120      user_id INTEGER DEFAULT 0 NOT NULL,
 121      forum_id INTEGER DEFAULT 0 NOT NULL,
 122      auth_option_id INTEGER DEFAULT 0 NOT NULL,
 123      auth_role_id INTEGER DEFAULT 0 NOT NULL,
 124      auth_setting INTEGER DEFAULT 0 NOT NULL
 125  );;
 126  
 127  CREATE INDEX phpbb_acl_users_user_id ON phpbb_acl_users(user_id);;
 128  CREATE INDEX phpbb_acl_users_auth_option_id ON phpbb_acl_users(auth_option_id);;
 129  CREATE INDEX phpbb_acl_users_auth_role_id ON phpbb_acl_users(auth_role_id);;
 130  
 131  # Table: 'phpbb_banlist'
 132  CREATE TABLE phpbb_banlist (
 133      ban_id INTEGER NOT NULL,
 134      ban_userid INTEGER DEFAULT 0 NOT NULL,
 135      ban_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
 136      ban_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 137      ban_start INTEGER DEFAULT 0 NOT NULL,
 138      ban_end INTEGER DEFAULT 0 NOT NULL,
 139      ban_exclude INTEGER DEFAULT 0 NOT NULL,
 140      ban_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 141      ban_give_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
 142  );;
 143  
 144  ALTER TABLE phpbb_banlist ADD PRIMARY KEY (ban_id);;
 145  
 146  CREATE INDEX phpbb_banlist_ban_end ON phpbb_banlist(ban_end);;
 147  CREATE INDEX phpbb_banlist_ban_user ON phpbb_banlist(ban_userid, ban_exclude);;
 148  CREATE INDEX phpbb_banlist_ban_email ON phpbb_banlist(ban_email, ban_exclude);;
 149  CREATE INDEX phpbb_banlist_ban_ip ON phpbb_banlist(ban_ip, ban_exclude);;
 150  
 151  CREATE GENERATOR phpbb_banlist_gen;;
 152  SET GENERATOR phpbb_banlist_gen TO 0;;
 153  
 154  CREATE TRIGGER t_phpbb_banlist FOR phpbb_banlist
 155  BEFORE INSERT
 156  AS
 157  BEGIN
 158      NEW.ban_id = GEN_ID(phpbb_banlist_gen, 1);
 159  END;;
 160  
 161  
 162  # Table: 'phpbb_bbcodes'
 163  CREATE TABLE phpbb_bbcodes (
 164      bbcode_id INTEGER DEFAULT 0 NOT NULL,
 165      bbcode_tag VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,
 166      bbcode_helpline VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 167      display_on_posting INTEGER DEFAULT 0 NOT NULL,
 168      bbcode_match BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 169      bbcode_tpl BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 170      first_pass_match BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 171      first_pass_replace BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 172      second_pass_match BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 173      second_pass_replace BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
 174  );;
 175  
 176  ALTER TABLE phpbb_bbcodes ADD PRIMARY KEY (bbcode_id);;
 177  
 178  CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes(display_on_posting);;
 179  
 180  # Table: 'phpbb_bookmarks'
 181  CREATE TABLE phpbb_bookmarks (
 182      topic_id INTEGER DEFAULT 0 NOT NULL,
 183      user_id INTEGER DEFAULT 0 NOT NULL
 184  );;
 185  
 186  ALTER TABLE phpbb_bookmarks ADD PRIMARY KEY (topic_id, user_id);;
 187  
 188  
 189  # Table: 'phpbb_bots'
 190  CREATE TABLE phpbb_bots (
 191      bot_id INTEGER NOT NULL,
 192      bot_active INTEGER DEFAULT 1 NOT NULL,
 193      bot_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 194      user_id INTEGER DEFAULT 0 NOT NULL,
 195      bot_agent VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 196      bot_ip VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
 197  );;
 198  
 199  ALTER TABLE phpbb_bots ADD PRIMARY KEY (bot_id);;
 200  
 201  CREATE INDEX phpbb_bots_bot_active ON phpbb_bots(bot_active);;
 202  
 203  CREATE GENERATOR phpbb_bots_gen;;
 204  SET GENERATOR phpbb_bots_gen TO 0;;
 205  
 206  CREATE TRIGGER t_phpbb_bots FOR phpbb_bots
 207  BEFORE INSERT
 208  AS
 209  BEGIN
 210      NEW.bot_id = GEN_ID(phpbb_bots_gen, 1);
 211  END;;
 212  
 213  
 214  # Table: 'phpbb_config'
 215  CREATE TABLE phpbb_config (
 216      config_name VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 217      config_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 218      is_dynamic INTEGER DEFAULT 0 NOT NULL
 219  );;
 220  
 221  ALTER TABLE phpbb_config ADD PRIMARY KEY (config_name);;
 222  
 223  CREATE INDEX phpbb_config_is_dynamic ON phpbb_config(is_dynamic);;
 224  
 225  # Table: 'phpbb_confirm'
 226  CREATE TABLE phpbb_confirm (
 227      confirm_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
 228      session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
 229      confirm_type INTEGER DEFAULT 0 NOT NULL,
 230      code VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
 231      seed INTEGER DEFAULT 0 NOT NULL,
 232      attempts INTEGER DEFAULT 0 NOT NULL
 233  );;
 234  
 235  ALTER TABLE phpbb_confirm ADD PRIMARY KEY (session_id, confirm_id);;
 236  
 237  CREATE INDEX phpbb_confirm_confirm_type ON phpbb_confirm(confirm_type);;
 238  
 239  # Table: 'phpbb_disallow'
 240  CREATE TABLE phpbb_disallow (
 241      disallow_id INTEGER NOT NULL,
 242      disallow_username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
 243  );;
 244  
 245  ALTER TABLE phpbb_disallow ADD PRIMARY KEY (disallow_id);;
 246  
 247  
 248  CREATE GENERATOR phpbb_disallow_gen;;
 249  SET GENERATOR phpbb_disallow_gen TO 0;;
 250  
 251  CREATE TRIGGER t_phpbb_disallow FOR phpbb_disallow
 252  BEFORE INSERT
 253  AS
 254  BEGIN
 255      NEW.disallow_id = GEN_ID(phpbb_disallow_gen, 1);
 256  END;;
 257  
 258  
 259  # Table: 'phpbb_drafts'
 260  CREATE TABLE phpbb_drafts (
 261      draft_id INTEGER NOT NULL,
 262      user_id INTEGER DEFAULT 0 NOT NULL,
 263      topic_id INTEGER DEFAULT 0 NOT NULL,
 264      forum_id INTEGER DEFAULT 0 NOT NULL,
 265      save_time INTEGER DEFAULT 0 NOT NULL,
 266      draft_subject VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 267      draft_message BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
 268  );;
 269  
 270  ALTER TABLE phpbb_drafts ADD PRIMARY KEY (draft_id);;
 271  
 272  CREATE INDEX phpbb_drafts_save_time ON phpbb_drafts(save_time);;
 273  
 274  CREATE GENERATOR phpbb_drafts_gen;;
 275  SET GENERATOR phpbb_drafts_gen TO 0;;
 276  
 277  CREATE TRIGGER t_phpbb_drafts FOR phpbb_drafts
 278  BEFORE INSERT
 279  AS
 280  BEGIN
 281      NEW.draft_id = GEN_ID(phpbb_drafts_gen, 1);
 282  END;;
 283  
 284  
 285  # Table: 'phpbb_extensions'
 286  CREATE TABLE phpbb_extensions (
 287      extension_id INTEGER NOT NULL,
 288      group_id INTEGER DEFAULT 0 NOT NULL,
 289      extension VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL
 290  );;
 291  
 292  ALTER TABLE phpbb_extensions ADD PRIMARY KEY (extension_id);;
 293  
 294  
 295  CREATE GENERATOR phpbb_extensions_gen;;
 296  SET GENERATOR phpbb_extensions_gen TO 0;;
 297  
 298  CREATE TRIGGER t_phpbb_extensions FOR phpbb_extensions
 299  BEFORE INSERT
 300  AS
 301  BEGIN
 302      NEW.extension_id = GEN_ID(phpbb_extensions_gen, 1);
 303  END;;
 304  
 305  
 306  # Table: 'phpbb_extension_groups'
 307  CREATE TABLE phpbb_extension_groups (
 308      group_id INTEGER NOT NULL,
 309      group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 310      cat_id INTEGER DEFAULT 0 NOT NULL,
 311      allow_group INTEGER DEFAULT 0 NOT NULL,
 312      download_mode INTEGER DEFAULT 1 NOT NULL,
 313      upload_icon VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 314      max_filesize INTEGER DEFAULT 0 NOT NULL,
 315      allowed_forums BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
 316      allow_in_pm INTEGER DEFAULT 0 NOT NULL
 317  );;
 318  
 319  ALTER TABLE phpbb_extension_groups ADD PRIMARY KEY (group_id);;
 320  
 321  
 322  CREATE GENERATOR phpbb_extension_groups_gen;;
 323  SET GENERATOR phpbb_extension_groups_gen TO 0;;
 324  
 325  CREATE TRIGGER t_phpbb_extension_groups FOR phpbb_extension_groups
 326  BEFORE INSERT
 327  AS
 328  BEGIN
 329      NEW.group_id = GEN_ID(phpbb_extension_groups_gen, 1);
 330  END;;
 331  
 332  
 333  # Table: 'phpbb_forums'
 334  CREATE TABLE phpbb_forums (
 335      forum_id INTEGER NOT NULL,
 336      parent_id INTEGER DEFAULT 0 NOT NULL,
 337      left_id INTEGER DEFAULT 0 NOT NULL,
 338      right_id INTEGER DEFAULT 0 NOT NULL,
 339      forum_parents BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
 340      forum_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 341      forum_desc BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 342      forum_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 343      forum_desc_options INTEGER DEFAULT 7 NOT NULL,
 344      forum_desc_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
 345      forum_link VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 346      forum_password VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 347      forum_style INTEGER DEFAULT 0 NOT NULL,
 348      forum_image VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 349      forum_rules BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 350      forum_rules_link VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 351      forum_rules_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 352      forum_rules_options INTEGER DEFAULT 7 NOT NULL,
 353      forum_rules_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
 354      forum_topics_per_page INTEGER DEFAULT 0 NOT NULL,
 355      forum_type INTEGER DEFAULT 0 NOT NULL,
 356      forum_status INTEGER DEFAULT 0 NOT NULL,
 357      forum_posts INTEGER DEFAULT 0 NOT NULL,
 358      forum_topics INTEGER DEFAULT 0 NOT NULL,
 359      forum_topics_real INTEGER DEFAULT 0 NOT NULL,
 360      forum_last_post_id INTEGER DEFAULT 0 NOT NULL,
 361      forum_last_poster_id INTEGER DEFAULT 0 NOT NULL,
 362      forum_last_post_subject VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 363      forum_last_post_time INTEGER DEFAULT 0 NOT NULL,
 364      forum_last_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 365      forum_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
 366      forum_flags INTEGER DEFAULT 32 NOT NULL,
 367      forum_options INTEGER DEFAULT 0 NOT NULL,
 368      display_subforum_list INTEGER DEFAULT 1 NOT NULL,
 369      display_on_index INTEGER DEFAULT 1 NOT NULL,
 370      enable_indexing INTEGER DEFAULT 1 NOT NULL,
 371      enable_icons INTEGER DEFAULT 1 NOT NULL,
 372      enable_prune INTEGER DEFAULT 0 NOT NULL,
 373      prune_next INTEGER DEFAULT 0 NOT NULL,
 374      prune_days INTEGER DEFAULT 0 NOT NULL,
 375      prune_viewed INTEGER DEFAULT 0 NOT NULL,
 376      prune_freq INTEGER DEFAULT 0 NOT NULL
 377  );;
 378  
 379  ALTER TABLE phpbb_forums ADD PRIMARY KEY (forum_id);;
 380  
 381  CREATE INDEX phpbb_forums_left_right_id ON phpbb_forums(left_id, right_id);;
 382  CREATE INDEX phpbb_forums_forum_lastpost_id ON phpbb_forums(forum_last_post_id);;
 383  
 384  CREATE GENERATOR phpbb_forums_gen;;
 385  SET GENERATOR phpbb_forums_gen TO 0;;
 386  
 387  CREATE TRIGGER t_phpbb_forums FOR phpbb_forums
 388  BEFORE INSERT
 389  AS
 390  BEGIN
 391      NEW.forum_id = GEN_ID(phpbb_forums_gen, 1);
 392  END;;
 393  
 394  
 395  # Table: 'phpbb_forums_access'
 396  CREATE TABLE phpbb_forums_access (
 397      forum_id INTEGER DEFAULT 0 NOT NULL,
 398      user_id INTEGER DEFAULT 0 NOT NULL,
 399      session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL
 400  );;
 401  
 402  ALTER TABLE phpbb_forums_access ADD PRIMARY KEY (forum_id, user_id, session_id);;
 403  
 404  
 405  # Table: 'phpbb_forums_track'
 406  CREATE TABLE phpbb_forums_track (
 407      user_id INTEGER DEFAULT 0 NOT NULL,
 408      forum_id INTEGER DEFAULT 0 NOT NULL,
 409      mark_time INTEGER DEFAULT 0 NOT NULL
 410  );;
 411  
 412  ALTER TABLE phpbb_forums_track ADD PRIMARY KEY (user_id, forum_id);;
 413  
 414  
 415  # Table: 'phpbb_forums_watch'
 416  CREATE TABLE phpbb_forums_watch (
 417      forum_id INTEGER DEFAULT 0 NOT NULL,
 418      user_id INTEGER DEFAULT 0 NOT NULL,
 419      notify_status INTEGER DEFAULT 0 NOT NULL
 420  );;
 421  
 422  CREATE INDEX phpbb_forums_watch_forum_id ON phpbb_forums_watch(forum_id);;
 423  CREATE INDEX phpbb_forums_watch_user_id ON phpbb_forums_watch(user_id);;
 424  CREATE INDEX phpbb_forums_watch_notify_stat ON phpbb_forums_watch(notify_status);;
 425  
 426  # Table: 'phpbb_groups'
 427  CREATE TABLE phpbb_groups (
 428      group_id INTEGER NOT NULL,
 429      group_type INTEGER DEFAULT 1 NOT NULL,
 430      group_founder_manage INTEGER DEFAULT 0 NOT NULL,
 431      group_skip_auth INTEGER DEFAULT 0 NOT NULL,
 432      group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 433      group_desc BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 434      group_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 435      group_desc_options INTEGER DEFAULT 7 NOT NULL,
 436      group_desc_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
 437      group_display INTEGER DEFAULT 0 NOT NULL,
 438      group_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 439      group_avatar_type INTEGER DEFAULT 0 NOT NULL,
 440      group_avatar_width INTEGER DEFAULT 0 NOT NULL,
 441      group_avatar_height INTEGER DEFAULT 0 NOT NULL,
 442      group_rank INTEGER DEFAULT 0 NOT NULL,
 443      group_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
 444      group_sig_chars INTEGER DEFAULT 0 NOT NULL,
 445      group_receive_pm INTEGER DEFAULT 0 NOT NULL,
 446      group_message_limit INTEGER DEFAULT 0 NOT NULL,
 447      group_max_recipients INTEGER DEFAULT 0 NOT NULL,
 448      group_legend INTEGER DEFAULT 1 NOT NULL
 449  );;
 450  
 451  ALTER TABLE phpbb_groups ADD PRIMARY KEY (group_id);;
 452  
 453  CREATE INDEX phpbb_groups_group_legend_name ON phpbb_groups(group_legend, group_name);;
 454  
 455  CREATE GENERATOR phpbb_groups_gen;;
 456  SET GENERATOR phpbb_groups_gen TO 0;;
 457  
 458  CREATE TRIGGER t_phpbb_groups FOR phpbb_groups
 459  BEFORE INSERT
 460  AS
 461  BEGIN
 462      NEW.group_id = GEN_ID(phpbb_groups_gen, 1);
 463  END;;
 464  
 465  
 466  # Table: 'phpbb_icons'
 467  CREATE TABLE phpbb_icons (
 468      icons_id INTEGER NOT NULL,
 469      icons_url VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 470      icons_width INTEGER DEFAULT 0 NOT NULL,
 471      icons_height INTEGER DEFAULT 0 NOT NULL,
 472      icons_order INTEGER DEFAULT 0 NOT NULL,
 473      display_on_posting INTEGER DEFAULT 1 NOT NULL
 474  );;
 475  
 476  ALTER TABLE phpbb_icons ADD PRIMARY KEY (icons_id);;
 477  
 478  CREATE INDEX phpbb_icons_display_on_posting ON phpbb_icons(display_on_posting);;
 479  
 480  CREATE GENERATOR phpbb_icons_gen;;
 481  SET GENERATOR phpbb_icons_gen TO 0;;
 482  
 483  CREATE TRIGGER t_phpbb_icons FOR phpbb_icons
 484  BEFORE INSERT
 485  AS
 486  BEGIN
 487      NEW.icons_id = GEN_ID(phpbb_icons_gen, 1);
 488  END;;
 489  
 490  
 491  # Table: 'phpbb_lang'
 492  CREATE TABLE phpbb_lang (
 493      lang_id INTEGER NOT NULL,
 494      lang_iso VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
 495      lang_dir VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
 496      lang_english_name VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 497      lang_local_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 498      lang_author VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
 499  );;
 500  
 501  ALTER TABLE phpbb_lang ADD PRIMARY KEY (lang_id);;
 502  
 503  CREATE INDEX phpbb_lang_lang_iso ON phpbb_lang(lang_iso);;
 504  
 505  CREATE GENERATOR phpbb_lang_gen;;
 506  SET GENERATOR phpbb_lang_gen TO 0;;
 507  
 508  CREATE TRIGGER t_phpbb_lang FOR phpbb_lang
 509  BEFORE INSERT
 510  AS
 511  BEGIN
 512      NEW.lang_id = GEN_ID(phpbb_lang_gen, 1);
 513  END;;
 514  
 515  
 516  # Table: 'phpbb_log'
 517  CREATE TABLE phpbb_log (
 518      log_id INTEGER NOT NULL,
 519      log_type INTEGER DEFAULT 0 NOT NULL,
 520      user_id INTEGER DEFAULT 0 NOT NULL,
 521      forum_id INTEGER DEFAULT 0 NOT NULL,
 522      topic_id INTEGER DEFAULT 0 NOT NULL,
 523      reportee_id INTEGER DEFAULT 0 NOT NULL,
 524      log_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
 525      log_time INTEGER DEFAULT 0 NOT NULL,
 526      log_operation BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 527      log_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
 528  );;
 529  
 530  ALTER TABLE phpbb_log ADD PRIMARY KEY (log_id);;
 531  
 532  CREATE INDEX phpbb_log_log_type ON phpbb_log(log_type);;
 533  CREATE INDEX phpbb_log_forum_id ON phpbb_log(forum_id);;
 534  CREATE INDEX phpbb_log_topic_id ON phpbb_log(topic_id);;
 535  CREATE INDEX phpbb_log_reportee_id ON phpbb_log(reportee_id);;
 536  CREATE INDEX phpbb_log_user_id ON phpbb_log(user_id);;
 537  
 538  CREATE GENERATOR phpbb_log_gen;;
 539  SET GENERATOR phpbb_log_gen TO 0;;
 540  
 541  CREATE TRIGGER t_phpbb_log FOR phpbb_log
 542  BEFORE INSERT
 543  AS
 544  BEGIN
 545      NEW.log_id = GEN_ID(phpbb_log_gen, 1);
 546  END;;
 547  
 548  
 549  # Table: 'phpbb_login_attempts'
 550  CREATE TABLE phpbb_login_attempts (
 551      attempt_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
 552      attempt_browser VARCHAR(150) CHARACTER SET NONE DEFAULT '' NOT NULL,
 553      attempt_forwarded_for VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 554      attempt_time INTEGER DEFAULT 0 NOT NULL,
 555      user_id INTEGER DEFAULT 0 NOT NULL,
 556      username VARCHAR(255) CHARACTER SET UTF8 DEFAULT 0 NOT NULL COLLATE UNICODE,
 557      username_clean VARCHAR(255) CHARACTER SET UTF8 DEFAULT 0 NOT NULL COLLATE UNICODE
 558  );;
 559  
 560  CREATE INDEX phpbb_login_attempts_att_ip ON phpbb_login_attempts(attempt_ip, attempt_time);;
 561  CREATE INDEX phpbb_login_attempts_att_for ON phpbb_login_attempts(attempt_forwarded_for, attempt_time);;
 562  CREATE INDEX phpbb_login_attempts_att_time ON phpbb_login_attempts(attempt_time);;
 563  CREATE INDEX phpbb_login_attempts_user_id ON phpbb_login_attempts(user_id);;
 564  
 565  # Table: 'phpbb_moderator_cache'
 566  CREATE TABLE phpbb_moderator_cache (
 567      forum_id INTEGER DEFAULT 0 NOT NULL,
 568      user_id INTEGER DEFAULT 0 NOT NULL,
 569      username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 570      group_id INTEGER DEFAULT 0 NOT NULL,
 571      group_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 572      display_on_index INTEGER DEFAULT 1 NOT NULL
 573  );;
 574  
 575  CREATE INDEX phpbb_moderator_cache_disp_idx ON phpbb_moderator_cache(display_on_index);;
 576  CREATE INDEX phpbb_moderator_cache_forum_id ON phpbb_moderator_cache(forum_id);;
 577  
 578  # Table: 'phpbb_modules'
 579  CREATE TABLE phpbb_modules (
 580      module_id INTEGER NOT NULL,
 581      module_enabled INTEGER DEFAULT 1 NOT NULL,
 582      module_display INTEGER DEFAULT 1 NOT NULL,
 583      module_basename VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 584      module_class VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
 585      parent_id INTEGER DEFAULT 0 NOT NULL,
 586      left_id INTEGER DEFAULT 0 NOT NULL,
 587      right_id INTEGER DEFAULT 0 NOT NULL,
 588      module_langname VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 589      module_mode VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 590      module_auth VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
 591  );;
 592  
 593  ALTER TABLE phpbb_modules ADD PRIMARY KEY (module_id);;
 594  
 595  CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules(left_id, right_id);;
 596  CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules(module_enabled);;
 597  CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules(module_class, left_id);;
 598  
 599  CREATE GENERATOR phpbb_modules_gen;;
 600  SET GENERATOR phpbb_modules_gen TO 0;;
 601  
 602  CREATE TRIGGER t_phpbb_modules FOR phpbb_modules
 603  BEFORE INSERT
 604  AS
 605  BEGIN
 606      NEW.module_id = GEN_ID(phpbb_modules_gen, 1);
 607  END;;
 608  
 609  
 610  # Table: 'phpbb_poll_options'
 611  CREATE TABLE phpbb_poll_options (
 612      poll_option_id INTEGER DEFAULT 0 NOT NULL,
 613      topic_id INTEGER DEFAULT 0 NOT NULL,
 614      poll_option_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 615      poll_option_total INTEGER DEFAULT 0 NOT NULL
 616  );;
 617  
 618  CREATE INDEX phpbb_poll_options_poll_opt_id ON phpbb_poll_options(poll_option_id);;
 619  CREATE INDEX phpbb_poll_options_topic_id ON phpbb_poll_options(topic_id);;
 620  
 621  # Table: 'phpbb_poll_votes'
 622  CREATE TABLE phpbb_poll_votes (
 623      topic_id INTEGER DEFAULT 0 NOT NULL,
 624      poll_option_id INTEGER DEFAULT 0 NOT NULL,
 625      vote_user_id INTEGER DEFAULT 0 NOT NULL,
 626      vote_user_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL
 627  );;
 628  
 629  CREATE INDEX phpbb_poll_votes_topic_id ON phpbb_poll_votes(topic_id);;
 630  CREATE INDEX phpbb_poll_votes_vote_user_id ON phpbb_poll_votes(vote_user_id);;
 631  CREATE INDEX phpbb_poll_votes_vote_user_ip ON phpbb_poll_votes(vote_user_ip);;
 632  
 633  # Table: 'phpbb_posts'
 634  CREATE TABLE phpbb_posts (
 635      post_id INTEGER NOT NULL,
 636      topic_id INTEGER DEFAULT 0 NOT NULL,
 637      forum_id INTEGER DEFAULT 0 NOT NULL,
 638      poster_id INTEGER DEFAULT 0 NOT NULL,
 639      icon_id INTEGER DEFAULT 0 NOT NULL,
 640      poster_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
 641      post_time INTEGER DEFAULT 0 NOT NULL,
 642      post_approved INTEGER DEFAULT 1 NOT NULL,
 643      post_reported INTEGER DEFAULT 0 NOT NULL,
 644      enable_bbcode INTEGER DEFAULT 1 NOT NULL,
 645      enable_smilies INTEGER DEFAULT 1 NOT NULL,
 646      enable_magic_url INTEGER DEFAULT 1 NOT NULL,
 647      enable_sig INTEGER DEFAULT 1 NOT NULL,
 648      post_username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 649      post_subject VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 650      post_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 651      post_checksum VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
 652      post_attachment INTEGER DEFAULT 0 NOT NULL,
 653      bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 654      bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
 655      post_postcount INTEGER DEFAULT 1 NOT NULL,
 656      post_edit_time INTEGER DEFAULT 0 NOT NULL,
 657      post_edit_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 658      post_edit_user INTEGER DEFAULT 0 NOT NULL,
 659      post_edit_count INTEGER DEFAULT 0 NOT NULL,
 660      post_edit_locked INTEGER DEFAULT 0 NOT NULL
 661  );;
 662  
 663  ALTER TABLE phpbb_posts ADD PRIMARY KEY (post_id);;
 664  
 665  CREATE INDEX phpbb_posts_forum_id ON phpbb_posts(forum_id);;
 666  CREATE INDEX phpbb_posts_topic_id ON phpbb_posts(topic_id);;
 667  CREATE INDEX phpbb_posts_poster_ip ON phpbb_posts(poster_ip);;
 668  CREATE INDEX phpbb_posts_poster_id ON phpbb_posts(poster_id);;
 669  CREATE INDEX phpbb_posts_post_approved ON phpbb_posts(post_approved);;
 670  CREATE INDEX phpbb_posts_post_username ON phpbb_posts(post_username);;
 671  CREATE INDEX phpbb_posts_tid_post_time ON phpbb_posts(topic_id, post_time);;
 672  
 673  CREATE GENERATOR phpbb_posts_gen;;
 674  SET GENERATOR phpbb_posts_gen TO 0;;
 675  
 676  CREATE TRIGGER t_phpbb_posts FOR phpbb_posts
 677  BEFORE INSERT
 678  AS
 679  BEGIN
 680      NEW.post_id = GEN_ID(phpbb_posts_gen, 1);
 681  END;;
 682  
 683  
 684  # Table: 'phpbb_privmsgs'
 685  CREATE TABLE phpbb_privmsgs (
 686      msg_id INTEGER NOT NULL,
 687      root_level INTEGER DEFAULT 0 NOT NULL,
 688      author_id INTEGER DEFAULT 0 NOT NULL,
 689      icon_id INTEGER DEFAULT 0 NOT NULL,
 690      author_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
 691      message_time INTEGER DEFAULT 0 NOT NULL,
 692      enable_bbcode INTEGER DEFAULT 1 NOT NULL,
 693      enable_smilies INTEGER DEFAULT 1 NOT NULL,
 694      enable_magic_url INTEGER DEFAULT 1 NOT NULL,
 695      enable_sig INTEGER DEFAULT 1 NOT NULL,
 696      message_subject VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 697      message_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 698      message_edit_reason VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 699      message_edit_user INTEGER DEFAULT 0 NOT NULL,
 700      message_attachment INTEGER DEFAULT 0 NOT NULL,
 701      bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 702      bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
 703      message_edit_time INTEGER DEFAULT 0 NOT NULL,
 704      message_edit_count INTEGER DEFAULT 0 NOT NULL,
 705      to_address BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 706      bcc_address BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 707      message_reported INTEGER DEFAULT 0 NOT NULL
 708  );;
 709  
 710  ALTER TABLE phpbb_privmsgs ADD PRIMARY KEY (msg_id);;
 711  
 712  CREATE INDEX phpbb_privmsgs_author_ip ON phpbb_privmsgs(author_ip);;
 713  CREATE INDEX phpbb_privmsgs_message_time ON phpbb_privmsgs(message_time);;
 714  CREATE INDEX phpbb_privmsgs_author_id ON phpbb_privmsgs(author_id);;
 715  CREATE INDEX phpbb_privmsgs_root_level ON phpbb_privmsgs(root_level);;
 716  
 717  CREATE GENERATOR phpbb_privmsgs_gen;;
 718  SET GENERATOR phpbb_privmsgs_gen TO 0;;
 719  
 720  CREATE TRIGGER t_phpbb_privmsgs FOR phpbb_privmsgs
 721  BEFORE INSERT
 722  AS
 723  BEGIN
 724      NEW.msg_id = GEN_ID(phpbb_privmsgs_gen, 1);
 725  END;;
 726  
 727  
 728  # Table: 'phpbb_privmsgs_folder'
 729  CREATE TABLE phpbb_privmsgs_folder (
 730      folder_id INTEGER NOT NULL,
 731      user_id INTEGER DEFAULT 0 NOT NULL,
 732      folder_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 733      pm_count INTEGER DEFAULT 0 NOT NULL
 734  );;
 735  
 736  ALTER TABLE phpbb_privmsgs_folder ADD PRIMARY KEY (folder_id);;
 737  
 738  CREATE INDEX phpbb_privmsgs_folder_user_id ON phpbb_privmsgs_folder(user_id);;
 739  
 740  CREATE GENERATOR phpbb_privmsgs_folder_gen;;
 741  SET GENERATOR phpbb_privmsgs_folder_gen TO 0;;
 742  
 743  CREATE TRIGGER t_phpbb_privmsgs_folder FOR phpbb_privmsgs_folder
 744  BEFORE INSERT
 745  AS
 746  BEGIN
 747      NEW.folder_id = GEN_ID(phpbb_privmsgs_folder_gen, 1);
 748  END;;
 749  
 750  
 751  # Table: 'phpbb_privmsgs_rules'
 752  CREATE TABLE phpbb_privmsgs_rules (
 753      rule_id INTEGER NOT NULL,
 754      user_id INTEGER DEFAULT 0 NOT NULL,
 755      rule_check INTEGER DEFAULT 0 NOT NULL,
 756      rule_connection INTEGER DEFAULT 0 NOT NULL,
 757      rule_string VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 758      rule_user_id INTEGER DEFAULT 0 NOT NULL,
 759      rule_group_id INTEGER DEFAULT 0 NOT NULL,
 760      rule_action INTEGER DEFAULT 0 NOT NULL,
 761      rule_folder_id INTEGER DEFAULT 0 NOT NULL
 762  );;
 763  
 764  ALTER TABLE phpbb_privmsgs_rules ADD PRIMARY KEY (rule_id);;
 765  
 766  CREATE INDEX phpbb_privmsgs_rules_user_id ON phpbb_privmsgs_rules(user_id);;
 767  
 768  CREATE GENERATOR phpbb_privmsgs_rules_gen;;
 769  SET GENERATOR phpbb_privmsgs_rules_gen TO 0;;
 770  
 771  CREATE TRIGGER t_phpbb_privmsgs_rules FOR phpbb_privmsgs_rules
 772  BEFORE INSERT
 773  AS
 774  BEGIN
 775      NEW.rule_id = GEN_ID(phpbb_privmsgs_rules_gen, 1);
 776  END;;
 777  
 778  
 779  # Table: 'phpbb_privmsgs_to'
 780  CREATE TABLE phpbb_privmsgs_to (
 781      msg_id INTEGER DEFAULT 0 NOT NULL,
 782      user_id INTEGER DEFAULT 0 NOT NULL,
 783      author_id INTEGER DEFAULT 0 NOT NULL,
 784      pm_deleted INTEGER DEFAULT 0 NOT NULL,
 785      pm_new INTEGER DEFAULT 1 NOT NULL,
 786      pm_unread INTEGER DEFAULT 1 NOT NULL,
 787      pm_replied INTEGER DEFAULT 0 NOT NULL,
 788      pm_marked INTEGER DEFAULT 0 NOT NULL,
 789      pm_forwarded INTEGER DEFAULT 0 NOT NULL,
 790      folder_id INTEGER DEFAULT 0 NOT NULL
 791  );;
 792  
 793  CREATE INDEX phpbb_privmsgs_to_msg_id ON phpbb_privmsgs_to(msg_id);;
 794  CREATE INDEX phpbb_privmsgs_to_author_id ON phpbb_privmsgs_to(author_id);;
 795  CREATE INDEX phpbb_privmsgs_to_usr_flder_id ON phpbb_privmsgs_to(user_id, folder_id);;
 796  
 797  # Table: 'phpbb_profile_fields'
 798  CREATE TABLE phpbb_profile_fields (
 799      field_id INTEGER NOT NULL,
 800      field_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 801      field_type INTEGER DEFAULT 0 NOT NULL,
 802      field_ident VARCHAR(20) CHARACTER SET NONE DEFAULT '' NOT NULL,
 803      field_length VARCHAR(20) CHARACTER SET NONE DEFAULT '' NOT NULL,
 804      field_minlen VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 805      field_maxlen VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 806      field_novalue VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 807      field_default_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 808      field_validation VARCHAR(20) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 809      field_required INTEGER DEFAULT 0 NOT NULL,
 810      field_show_novalue INTEGER DEFAULT 0 NOT NULL,
 811      field_show_on_reg INTEGER DEFAULT 0 NOT NULL,
 812      field_show_on_vt INTEGER DEFAULT 0 NOT NULL,
 813      field_show_profile INTEGER DEFAULT 0 NOT NULL,
 814      field_hide INTEGER DEFAULT 0 NOT NULL,
 815      field_no_view INTEGER DEFAULT 0 NOT NULL,
 816      field_active INTEGER DEFAULT 0 NOT NULL,
 817      field_order INTEGER DEFAULT 0 NOT NULL
 818  );;
 819  
 820  ALTER TABLE phpbb_profile_fields ADD PRIMARY KEY (field_id);;
 821  
 822  CREATE INDEX phpbb_profile_fields_fld_type ON phpbb_profile_fields(field_type);;
 823  CREATE INDEX phpbb_profile_fields_fld_ordr ON phpbb_profile_fields(field_order);;
 824  
 825  CREATE GENERATOR phpbb_profile_fields_gen;;
 826  SET GENERATOR phpbb_profile_fields_gen TO 0;;
 827  
 828  CREATE TRIGGER t_phpbb_profile_fields FOR phpbb_profile_fields
 829  BEFORE INSERT
 830  AS
 831  BEGIN
 832      NEW.field_id = GEN_ID(phpbb_profile_fields_gen, 1);
 833  END;;
 834  
 835  
 836  # Table: 'phpbb_profile_fields_data'
 837  CREATE TABLE phpbb_profile_fields_data (
 838      user_id INTEGER DEFAULT 0 NOT NULL
 839  );;
 840  
 841  ALTER TABLE phpbb_profile_fields_data ADD PRIMARY KEY (user_id);;
 842  
 843  
 844  # Table: 'phpbb_profile_fields_lang'
 845  CREATE TABLE phpbb_profile_fields_lang (
 846      field_id INTEGER DEFAULT 0 NOT NULL,
 847      lang_id INTEGER DEFAULT 0 NOT NULL,
 848      option_id INTEGER DEFAULT 0 NOT NULL,
 849      field_type INTEGER DEFAULT 0 NOT NULL,
 850      lang_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
 851  );;
 852  
 853  ALTER TABLE phpbb_profile_fields_lang ADD PRIMARY KEY (field_id, lang_id, option_id);;
 854  
 855  
 856  # Table: 'phpbb_profile_lang'
 857  CREATE TABLE phpbb_profile_lang (
 858      field_id INTEGER DEFAULT 0 NOT NULL,
 859      lang_id INTEGER DEFAULT 0 NOT NULL,
 860      lang_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 861      lang_explain BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 862      lang_default_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
 863  );;
 864  
 865  ALTER TABLE phpbb_profile_lang ADD PRIMARY KEY (field_id, lang_id);;
 866  
 867  
 868  # Table: 'phpbb_ranks'
 869  CREATE TABLE phpbb_ranks (
 870      rank_id INTEGER NOT NULL,
 871      rank_title VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 872      rank_min INTEGER DEFAULT 0 NOT NULL,
 873      rank_special INTEGER DEFAULT 0 NOT NULL,
 874      rank_image VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
 875  );;
 876  
 877  ALTER TABLE phpbb_ranks ADD PRIMARY KEY (rank_id);;
 878  
 879  
 880  CREATE GENERATOR phpbb_ranks_gen;;
 881  SET GENERATOR phpbb_ranks_gen TO 0;;
 882  
 883  CREATE TRIGGER t_phpbb_ranks FOR phpbb_ranks
 884  BEFORE INSERT
 885  AS
 886  BEGIN
 887      NEW.rank_id = GEN_ID(phpbb_ranks_gen, 1);
 888  END;;
 889  
 890  
 891  # Table: 'phpbb_reports'
 892  CREATE TABLE phpbb_reports (
 893      report_id INTEGER NOT NULL,
 894      reason_id INTEGER DEFAULT 0 NOT NULL,
 895      post_id INTEGER DEFAULT 0 NOT NULL,
 896      pm_id INTEGER DEFAULT 0 NOT NULL,
 897      user_id INTEGER DEFAULT 0 NOT NULL,
 898      user_notify INTEGER DEFAULT 0 NOT NULL,
 899      report_closed INTEGER DEFAULT 0 NOT NULL,
 900      report_time INTEGER DEFAULT 0 NOT NULL,
 901      report_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
 902  );;
 903  
 904  ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;
 905  
 906  CREATE INDEX phpbb_reports_post_id ON phpbb_reports(post_id);;
 907  CREATE INDEX phpbb_reports_pm_id ON phpbb_reports(pm_id);;
 908  
 909  CREATE GENERATOR phpbb_reports_gen;;
 910  SET GENERATOR phpbb_reports_gen TO 0;;
 911  
 912  CREATE TRIGGER t_phpbb_reports FOR phpbb_reports
 913  BEFORE INSERT
 914  AS
 915  BEGIN
 916      NEW.report_id = GEN_ID(phpbb_reports_gen, 1);
 917  END;;
 918  
 919  
 920  # Table: 'phpbb_reports_reasons'
 921  CREATE TABLE phpbb_reports_reasons (
 922      reason_id INTEGER NOT NULL,
 923      reason_title VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 924      reason_description BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 925      reason_order INTEGER DEFAULT 0 NOT NULL
 926  );;
 927  
 928  ALTER TABLE phpbb_reports_reasons ADD PRIMARY KEY (reason_id);;
 929  
 930  
 931  CREATE GENERATOR phpbb_reports_reasons_gen;;
 932  SET GENERATOR phpbb_reports_reasons_gen TO 0;;
 933  
 934  CREATE TRIGGER t_phpbb_reports_reasons FOR phpbb_reports_reasons
 935  BEFORE INSERT
 936  AS
 937  BEGIN
 938      NEW.reason_id = GEN_ID(phpbb_reports_reasons_gen, 1);
 939  END;;
 940  
 941  
 942  # Table: 'phpbb_search_results'
 943  CREATE TABLE phpbb_search_results (
 944      search_key VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
 945      search_time INTEGER DEFAULT 0 NOT NULL,
 946      search_keywords BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
 947      search_authors BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL
 948  );;
 949  
 950  ALTER TABLE phpbb_search_results ADD PRIMARY KEY (search_key);;
 951  
 952  
 953  # Table: 'phpbb_search_wordlist'
 954  CREATE TABLE phpbb_search_wordlist (
 955      word_id INTEGER NOT NULL,
 956      word_text VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
 957      word_common INTEGER DEFAULT 0 NOT NULL,
 958      word_count INTEGER DEFAULT 0 NOT NULL
 959  );;
 960  
 961  ALTER TABLE phpbb_search_wordlist ADD PRIMARY KEY (word_id);;
 962  
 963  CREATE UNIQUE INDEX phpbb_search_wordlist_wrd_txt ON phpbb_search_wordlist(word_text);;
 964  CREATE INDEX phpbb_search_wordlist_wrd_cnt ON phpbb_search_wordlist(word_count);;
 965  
 966  CREATE GENERATOR phpbb_search_wordlist_gen;;
 967  SET GENERATOR phpbb_search_wordlist_gen TO 0;;
 968  
 969  CREATE TRIGGER t_phpbb_search_wordlist FOR phpbb_search_wordlist
 970  BEFORE INSERT
 971  AS
 972  BEGIN
 973      NEW.word_id = GEN_ID(phpbb_search_wordlist_gen, 1);
 974  END;;
 975  
 976  
 977  # Table: 'phpbb_search_wordmatch'
 978  CREATE TABLE phpbb_search_wordmatch (
 979      post_id INTEGER DEFAULT 0 NOT NULL,
 980      word_id INTEGER DEFAULT 0 NOT NULL,
 981      title_match INTEGER DEFAULT 0 NOT NULL
 982  );;
 983  
 984  CREATE UNIQUE INDEX phpbb_search_wordmatch_unq_mtch ON phpbb_search_wordmatch(word_id, post_id, title_match);;
 985  CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch(word_id);;
 986  CREATE INDEX phpbb_search_wordmatch_post_id ON phpbb_search_wordmatch(post_id);;
 987  
 988  # Table: 'phpbb_sessions'
 989  CREATE TABLE phpbb_sessions (
 990      session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
 991      session_user_id INTEGER DEFAULT 0 NOT NULL,
 992      session_forum_id INTEGER DEFAULT 0 NOT NULL,
 993      session_last_visit INTEGER DEFAULT 0 NOT NULL,
 994      session_start INTEGER DEFAULT 0 NOT NULL,
 995      session_time INTEGER DEFAULT 0 NOT NULL,
 996      session_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
 997      session_browser VARCHAR(150) CHARACTER SET NONE DEFAULT '' NOT NULL,
 998      session_forwarded_for VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
 999      session_page VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1000      session_viewonline INTEGER DEFAULT 1 NOT NULL,
1001      session_autologin INTEGER DEFAULT 0 NOT NULL,
1002      session_admin INTEGER DEFAULT 0 NOT NULL
1003  );;
1004  
1005  ALTER TABLE phpbb_sessions ADD PRIMARY KEY (session_id);;
1006  
1007  CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions(session_time);;
1008  CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions(session_user_id);;
1009  CREATE INDEX phpbb_sessions_session_fid ON phpbb_sessions(session_forum_id);;
1010  
1011  # Table: 'phpbb_sessions_keys'
1012  CREATE TABLE phpbb_sessions_keys (
1013      key_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
1014      user_id INTEGER DEFAULT 0 NOT NULL,
1015      last_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
1016      last_login INTEGER DEFAULT 0 NOT NULL
1017  );;
1018  
1019  ALTER TABLE phpbb_sessions_keys ADD PRIMARY KEY (key_id, user_id);;
1020  
1021  CREATE INDEX phpbb_sessions_keys_last_login ON phpbb_sessions_keys(last_login);;
1022  
1023  # Table: 'phpbb_sitelist'
1024  CREATE TABLE phpbb_sitelist (
1025      site_id INTEGER NOT NULL,
1026      site_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
1027      site_hostname VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
1028      ip_exclude INTEGER DEFAULT 0 NOT NULL
1029  );;
1030  
1031  ALTER TABLE phpbb_sitelist ADD PRIMARY KEY (site_id);;
1032  
1033  
1034  CREATE GENERATOR phpbb_sitelist_gen;;
1035  SET GENERATOR phpbb_sitelist_gen TO 0;;
1036  
1037  CREATE TRIGGER t_phpbb_sitelist FOR phpbb_sitelist
1038  BEFORE INSERT
1039  AS
1040  BEGIN
1041      NEW.site_id = GEN_ID(phpbb_sitelist_gen, 1);
1042  END;;
1043  
1044  
1045  # Table: 'phpbb_smilies'
1046  CREATE TABLE phpbb_smilies (
1047      smiley_id INTEGER NOT NULL,
1048      code VARCHAR(50) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1049      emotion VARCHAR(50) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1050      smiley_url VARCHAR(50) CHARACTER SET NONE DEFAULT '' NOT NULL,
1051      smiley_width INTEGER DEFAULT 0 NOT NULL,
1052      smiley_height INTEGER DEFAULT 0 NOT NULL,
1053      smiley_order INTEGER DEFAULT 0 NOT NULL,
1054      display_on_posting INTEGER DEFAULT 1 NOT NULL
1055  );;
1056  
1057  ALTER TABLE phpbb_smilies ADD PRIMARY KEY (smiley_id);;
1058  
1059  CREATE INDEX phpbb_smilies_display_on_post ON phpbb_smilies(display_on_posting);;
1060  
1061  CREATE GENERATOR phpbb_smilies_gen;;
1062  SET GENERATOR phpbb_smilies_gen TO 0;;
1063  
1064  CREATE TRIGGER t_phpbb_smilies FOR phpbb_smilies
1065  BEFORE INSERT
1066  AS
1067  BEGIN
1068      NEW.smiley_id = GEN_ID(phpbb_smilies_gen, 1);
1069  END;;
1070  
1071  
1072  # Table: 'phpbb_styles'
1073  CREATE TABLE phpbb_styles (
1074      style_id INTEGER NOT NULL,
1075      style_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1076      style_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1077      style_active INTEGER DEFAULT 1 NOT NULL,
1078      template_id INTEGER DEFAULT 0 NOT NULL,
1079      theme_id INTEGER DEFAULT 0 NOT NULL,
1080      imageset_id INTEGER DEFAULT 0 NOT NULL
1081  );;
1082  
1083  ALTER TABLE phpbb_styles ADD PRIMARY KEY (style_id);;
1084  
1085  CREATE UNIQUE INDEX phpbb_styles_style_name ON phpbb_styles(style_name);;
1086  CREATE INDEX phpbb_styles_template_id ON phpbb_styles(template_id);;
1087  CREATE INDEX phpbb_styles_theme_id ON phpbb_styles(theme_id);;
1088  CREATE INDEX phpbb_styles_imageset_id ON phpbb_styles(imageset_id);;
1089  
1090  CREATE GENERATOR phpbb_styles_gen;;
1091  SET GENERATOR phpbb_styles_gen TO 0;;
1092  
1093  CREATE TRIGGER t_phpbb_styles FOR phpbb_styles
1094  BEFORE INSERT
1095  AS
1096  BEGIN
1097      NEW.style_id = GEN_ID(phpbb_styles_gen, 1);
1098  END;;
1099  
1100  
1101  # Table: 'phpbb_styles_template'
1102  CREATE TABLE phpbb_styles_template (
1103      template_id INTEGER NOT NULL,
1104      template_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1105      template_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1106      template_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
1107      bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT 'kNg=' NOT NULL,
1108      template_storedb INTEGER DEFAULT 0 NOT NULL,
1109      template_inherits_id INTEGER DEFAULT 0 NOT NULL,
1110      template_inherit_path VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL
1111  );;
1112  
1113  ALTER TABLE phpbb_styles_template ADD PRIMARY KEY (template_id);;
1114  
1115  CREATE UNIQUE INDEX phpbb_styles_template_tmplte_nm ON phpbb_styles_template(template_name);;
1116  
1117  CREATE GENERATOR phpbb_styles_template_gen;;
1118  SET GENERATOR phpbb_styles_template_gen TO 0;;
1119  
1120  CREATE TRIGGER t_phpbb_styles_template FOR phpbb_styles_template
1121  BEFORE INSERT
1122  AS
1123  BEGIN
1124      NEW.template_id = GEN_ID(phpbb_styles_template_gen, 1);
1125  END;;
1126  
1127  
1128  # Table: 'phpbb_styles_template_data'
1129  CREATE TABLE phpbb_styles_template_data (
1130      template_id INTEGER DEFAULT 0 NOT NULL,
1131      template_filename VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
1132      template_included BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
1133      template_mtime INTEGER DEFAULT 0 NOT NULL,
1134      template_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
1135  );;
1136  
1137  CREATE INDEX phpbb_styles_template_data_tid ON phpbb_styles_template_data(template_id);;
1138  CREATE INDEX phpbb_styles_template_data_tfn ON phpbb_styles_template_data(template_filename);;
1139  
1140  # Table: 'phpbb_styles_theme'
1141  CREATE TABLE phpbb_styles_theme (
1142      theme_id INTEGER NOT NULL,
1143      theme_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1144      theme_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1145      theme_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL,
1146      theme_storedb INTEGER DEFAULT 0 NOT NULL,
1147      theme_mtime INTEGER DEFAULT 0 NOT NULL,
1148      theme_data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL
1149  );;
1150  
1151  ALTER TABLE phpbb_styles_theme ADD PRIMARY KEY (theme_id);;
1152  
1153  CREATE UNIQUE INDEX phpbb_styles_theme_theme_name ON phpbb_styles_theme(theme_name);;
1154  
1155  CREATE GENERATOR phpbb_styles_theme_gen;;
1156  SET GENERATOR phpbb_styles_theme_gen TO 0;;
1157  
1158  CREATE TRIGGER t_phpbb_styles_theme FOR phpbb_styles_theme
1159  BEFORE INSERT
1160  AS
1161  BEGIN
1162      NEW.theme_id = GEN_ID(phpbb_styles_theme_gen, 1);
1163  END;;
1164  
1165  
1166  # Table: 'phpbb_styles_imageset'
1167  CREATE TABLE phpbb_styles_imageset (
1168      imageset_id INTEGER NOT NULL,
1169      imageset_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1170      imageset_copyright VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1171      imageset_path VARCHAR(100) CHARACTER SET NONE DEFAULT '' NOT NULL
1172  );;
1173  
1174  ALTER TABLE phpbb_styles_imageset ADD PRIMARY KEY (imageset_id);;
1175  
1176  CREATE UNIQUE INDEX phpbb_styles_imageset_imgset_nm ON phpbb_styles_imageset(imageset_name);;
1177  
1178  CREATE GENERATOR phpbb_styles_imageset_gen;;
1179  SET GENERATOR phpbb_styles_imageset_gen TO 0;;
1180  
1181  CREATE TRIGGER t_phpbb_styles_imageset FOR phpbb_styles_imageset
1182  BEFORE INSERT
1183  AS
1184  BEGIN
1185      NEW.imageset_id = GEN_ID(phpbb_styles_imageset_gen, 1);
1186  END;;
1187  
1188  
1189  # Table: 'phpbb_styles_imageset_data'
1190  CREATE TABLE phpbb_styles_imageset_data (
1191      image_id INTEGER NOT NULL,
1192      image_name VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,
1193      image_filename VARCHAR(200) CHARACTER SET NONE DEFAULT '' NOT NULL,
1194      image_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
1195      image_height INTEGER DEFAULT 0 NOT NULL,
1196      image_width INTEGER DEFAULT 0 NOT NULL,
1197      imageset_id INTEGER DEFAULT 0 NOT NULL
1198  );;
1199  
1200  ALTER TABLE phpbb_styles_imageset_data ADD PRIMARY KEY (image_id);;
1201  
1202  CREATE INDEX phpbb_styles_imageset_data_i_d ON phpbb_styles_imageset_data(imageset_id);;
1203  
1204  CREATE GENERATOR phpbb_styles_imageset_data_gen;;
1205  SET GENERATOR phpbb_styles_imageset_data_gen TO 0;;
1206  
1207  CREATE TRIGGER t_phpbb_styles_imageset_data FOR phpbb_styles_imageset_data
1208  BEFORE INSERT
1209  AS
1210  BEGIN
1211      NEW.image_id = GEN_ID(phpbb_styles_imageset_data_gen, 1);
1212  END;;
1213  
1214  
1215  # Table: 'phpbb_topics'
1216  CREATE TABLE phpbb_topics (
1217      topic_id INTEGER NOT NULL,
1218      forum_id INTEGER DEFAULT 0 NOT NULL,
1219      icon_id INTEGER DEFAULT 0 NOT NULL,
1220      topic_attachment INTEGER DEFAULT 0 NOT NULL,
1221      topic_approved INTEGER DEFAULT 1 NOT NULL,
1222      topic_reported INTEGER DEFAULT 0 NOT NULL,
1223      topic_title VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1224      topic_poster INTEGER DEFAULT 0 NOT NULL,
1225      topic_time INTEGER DEFAULT 0 NOT NULL,
1226      topic_time_limit INTEGER DEFAULT 0 NOT NULL,
1227      topic_views INTEGER DEFAULT 0 NOT NULL,
1228      topic_replies INTEGER DEFAULT 0 NOT NULL,
1229      topic_replies_real INTEGER DEFAULT 0 NOT NULL,
1230      topic_status INTEGER DEFAULT 0 NOT NULL,
1231      topic_type INTEGER DEFAULT 0 NOT NULL,
1232      topic_first_post_id INTEGER DEFAULT 0 NOT NULL,
1233      topic_first_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1234      topic_first_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
1235      topic_last_post_id INTEGER DEFAULT 0 NOT NULL,
1236      topic_last_poster_id INTEGER DEFAULT 0 NOT NULL,
1237      topic_last_poster_name VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1238      topic_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
1239      topic_last_post_subject VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1240      topic_last_post_time INTEGER DEFAULT 0 NOT NULL,
1241      topic_last_view_time INTEGER DEFAULT 0 NOT NULL,
1242      topic_moved_id INTEGER DEFAULT 0 NOT NULL,
1243      topic_bumped INTEGER DEFAULT 0 NOT NULL,
1244      topic_bumper INTEGER DEFAULT 0 NOT NULL,
1245      poll_title VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1246      poll_start INTEGER DEFAULT 0 NOT NULL,
1247      poll_length INTEGER DEFAULT 0 NOT NULL,
1248      poll_max_options INTEGER DEFAULT 1 NOT NULL,
1249      poll_last_vote INTEGER DEFAULT 0 NOT NULL,
1250      poll_vote_change INTEGER DEFAULT 0 NOT NULL
1251  );;
1252  
1253  ALTER TABLE phpbb_topics ADD PRIMARY KEY (topic_id);;
1254  
1255  CREATE INDEX phpbb_topics_forum_id ON phpbb_topics(forum_id);;
1256  CREATE INDEX phpbb_topics_forum_id_type ON phpbb_topics(forum_id, topic_type);;
1257  CREATE INDEX phpbb_topics_last_post_time ON phpbb_topics(topic_last_post_time);;
1258  CREATE INDEX phpbb_topics_topic_approved ON phpbb_topics(topic_approved);;
1259  CREATE INDEX phpbb_topics_forum_appr_last ON phpbb_topics(forum_id, topic_approved, topic_last_post_id);;
1260  CREATE INDEX phpbb_topics_fid_time_moved ON phpbb_topics(forum_id, topic_last_post_time, topic_moved_id);;
1261  
1262  CREATE GENERATOR phpbb_topics_gen;;
1263  SET GENERATOR phpbb_topics_gen TO 0;;
1264  
1265  CREATE TRIGGER t_phpbb_topics FOR phpbb_topics
1266  BEFORE INSERT
1267  AS
1268  BEGIN
1269      NEW.topic_id = GEN_ID(phpbb_topics_gen, 1);
1270  END;;
1271  
1272  
1273  # Table: 'phpbb_topics_track'
1274  CREATE TABLE phpbb_topics_track (
1275      user_id INTEGER DEFAULT 0 NOT NULL,
1276      topic_id INTEGER DEFAULT 0 NOT NULL,
1277      forum_id INTEGER DEFAULT 0 NOT NULL,
1278      mark_time INTEGER DEFAULT 0 NOT NULL
1279  );;
1280  
1281  ALTER TABLE phpbb_topics_track ADD PRIMARY KEY (user_id, topic_id);;
1282  
1283  CREATE INDEX phpbb_topics_track_topic_id ON phpbb_topics_track(topic_id);;
1284  CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track(forum_id);;
1285  
1286  # Table: 'phpbb_topics_posted'
1287  CREATE TABLE phpbb_topics_posted (
1288      user_id INTEGER DEFAULT 0 NOT NULL,
1289      topic_id INTEGER DEFAULT 0 NOT NULL,
1290      topic_posted INTEGER DEFAULT 0 NOT NULL
1291  );;
1292  
1293  ALTER TABLE phpbb_topics_posted ADD PRIMARY KEY (user_id, topic_id);;
1294  
1295  
1296  # Table: 'phpbb_topics_watch'
1297  CREATE TABLE phpbb_topics_watch (
1298      topic_id INTEGER DEFAULT 0 NOT NULL,
1299      user_id INTEGER DEFAULT 0 NOT NULL,
1300      notify_status INTEGER DEFAULT 0 NOT NULL
1301  );;
1302  
1303  CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch(topic_id);;
1304  CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch(user_id);;
1305  CREATE INDEX phpbb_topics_watch_notify_stat ON phpbb_topics_watch(notify_status);;
1306  
1307  # Table: 'phpbb_user_group'
1308  CREATE TABLE phpbb_user_group (
1309      group_id INTEGER DEFAULT 0 NOT NULL,
1310      user_id INTEGER DEFAULT 0 NOT NULL,
1311      group_leader INTEGER DEFAULT 0 NOT NULL,
1312      user_pending INTEGER DEFAULT 1 NOT NULL
1313  );;
1314  
1315  CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group(group_id);;
1316  CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group(user_id);;
1317  CREATE INDEX phpbb_user_group_group_leader ON phpbb_user_group(group_leader);;
1318  
1319  # Table: 'phpbb_users'
1320  CREATE TABLE phpbb_users (
1321      user_id INTEGER NOT NULL,
1322      user_type INTEGER DEFAULT 0 NOT NULL,
1323      group_id INTEGER DEFAULT 3 NOT NULL,
1324      user_permissions BLOB SUB_TYPE TEXT CHARACTER SET NONE DEFAULT '' NOT NULL,
1325      user_perm_from INTEGER DEFAULT 0 NOT NULL,
1326      user_ip VARCHAR(40) CHARACTER SET NONE DEFAULT '' NOT NULL,
1327      user_regdate INTEGER DEFAULT 0 NOT NULL,
1328      username VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1329      username_clean VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1330      user_password VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1331      user_passchg INTEGER DEFAULT 0 NOT NULL,
1332      user_pass_convert INTEGER DEFAULT 0 NOT NULL,
1333      user_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1334      user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,
1335      user_birthday VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
1336      user_lastvisit INTEGER DEFAULT 0 NOT NULL,
1337      user_lastmark INTEGER DEFAULT 0 NOT NULL,
1338      user_lastpost_time INTEGER DEFAULT 0 NOT NULL,
1339      user_lastpage VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1340      user_last_confirm_key VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,
1341      user_last_search INTEGER DEFAULT 0 NOT NULL,
1342      user_warnings INTEGER DEFAULT 0 NOT NULL,
1343      user_last_warning INTEGER DEFAULT 0 NOT NULL,
1344      user_login_attempts INTEGER DEFAULT 0 NOT NULL,
1345      user_inactive_reason INTEGER DEFAULT 0 NOT NULL,
1346      user_inactive_time INTEGER DEFAULT 0 NOT NULL,
1347      user_posts INTEGER DEFAULT 0 NOT NULL,
1348      user_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,
1349      user_timezone DOUBLE PRECISION DEFAULT 0 NOT NULL,
1350      user_dst INTEGER DEFAULT 0 NOT NULL,
1351      user_dateformat VARCHAR(30) CHARACTER SET UTF8 DEFAULT 'd M Y H:i' NOT NULL COLLATE UNICODE,
1352      user_style INTEGER DEFAULT 0 NOT NULL,
1353      user_rank INTEGER DEFAULT 0 NOT NULL,
1354      user_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,
1355      user_new_privmsg INTEGER DEFAULT 0 NOT NULL,
1356      user_unread_privmsg INTEGER DEFAULT 0 NOT NULL,
1357      user_last_privmsg INTEGER DEFAULT 0 NOT NULL,
1358      user_message_rules INTEGER DEFAULT 0 NOT NULL,
1359      user_full_folder INTEGER DEFAULT -3 NOT NULL,
1360      user_emailtime INTEGER DEFAULT 0 NOT NULL,
1361      user_topic_show_days INTEGER DEFAULT 0 NOT NULL,
1362      user_topic_sortby_type VARCHAR(1) CHARACTER SET NONE DEFAULT 't' NOT NULL,
1363      user_topic_sortby_dir VARCHAR(1) CHARACTER SET NONE DEFAULT 'd' NOT NULL,
1364      user_post_show_days INTEGER DEFAULT 0 NOT NULL,
1365      user_post_sortby_type VARCHAR(1) CHARACTER SET NONE DEFAULT 't' NOT NULL,
1366      user_post_sortby_dir VARCHAR(1) CHARACTER SET NONE DEFAULT 'a' NOT NULL,
1367      user_notify INTEGER DEFAULT 0 NOT NULL,
1368      user_notify_pm INTEGER DEFAULT 1 NOT NULL,
1369      user_notify_type INTEGER DEFAULT 0 NOT NULL,
1370      user_allow_pm INTEGER DEFAULT 1 NOT NULL,
1371      user_allow_viewonline INTEGER DEFAULT 1 NOT NULL,
1372      user_allow_viewemail INTEGER DEFAULT 1 NOT NULL,
1373      user_allow_massemail INTEGER DEFAULT 1 NOT NULL,
1374      user_options INTEGER DEFAULT 230271 NOT NULL,
1375      user_avatar VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
1376      user_avatar_type INTEGER DEFAULT 0 NOT NULL,
1377      user_avatar_width INTEGER DEFAULT 0 NOT NULL,
1378      user_avatar_height INTEGER DEFAULT 0 NOT NULL,
1379      user_sig BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
1380      user_sig_bbcode_uid VARCHAR(8) CHARACTER SET NONE DEFAULT '' NOT NULL,
1381      user_sig_bbcode_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,
1382      user_from VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1383      user_icq VARCHAR(15) CHARACTER SET NONE DEFAULT '' NOT NULL,
1384      user_aim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1385      user_yim VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1386      user_msnm VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1387      user_jabber VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1388      user_website VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1389      user_occ BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
1390      user_interests BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,
1391      user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,
1392      user_newpasswd VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1393      user_form_salt VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1394      user_new INTEGER DEFAULT 1 NOT NULL,
1395      user_reminded INTEGER DEFAULT 0 NOT NULL,
1396      user_reminded_time INTEGER DEFAULT 0 NOT NULL
1397  );;
1398  
1399  ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);;
1400  
1401  CREATE INDEX phpbb_users_user_birthday ON phpbb_users(user_birthday);;
1402  CREATE INDEX phpbb_users_user_email_hash ON phpbb_users(user_email_hash);;
1403  CREATE INDEX phpbb_users_user_type ON phpbb_users(user_type);;
1404  CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users(username_clean);;
1405  
1406  CREATE GENERATOR phpbb_users_gen;;
1407  SET GENERATOR phpbb_users_gen TO 0;;
1408  
1409  CREATE TRIGGER t_phpbb_users FOR phpbb_users
1410  BEFORE INSERT
1411  AS
1412  BEGIN
1413      NEW.user_id = GEN_ID(phpbb_users_gen, 1);
1414  END;;
1415  
1416  
1417  # Table: 'phpbb_warnings'
1418  CREATE TABLE phpbb_warnings (
1419      warning_id INTEGER NOT NULL,
1420      user_id INTEGER DEFAULT 0 NOT NULL,
1421      post_id INTEGER DEFAULT 0 NOT NULL,
1422      log_id INTEGER DEFAULT 0 NOT NULL,
1423      warning_time INTEGER DEFAULT 0 NOT NULL
1424  );;
1425  
1426  ALTER TABLE phpbb_warnings ADD PRIMARY KEY (warning_id);;
1427  
1428  
1429  CREATE GENERATOR phpbb_warnings_gen;;
1430  SET GENERATOR phpbb_warnings_gen TO 0;;
1431  
1432  CREATE TRIGGER t_phpbb_warnings FOR phpbb_warnings
1433  BEFORE INSERT
1434  AS
1435  BEGIN
1436      NEW.warning_id = GEN_ID(phpbb_warnings_gen, 1);
1437  END;;
1438  
1439  
1440  # Table: 'phpbb_words'
1441  CREATE TABLE phpbb_words (
1442      word_id INTEGER NOT NULL,
1443      word VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,
1444      replacement VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE
1445  );;
1446  
1447  ALTER TABLE phpbb_words ADD PRIMARY KEY (word_id);;
1448  
1449  
1450  CREATE GENERATOR phpbb_words_gen;;
1451  SET GENERATOR phpbb_words_gen TO 0;;
1452  
1453  CREATE TRIGGER t_phpbb_words FOR phpbb_words
1454  BEFORE INSERT
1455  AS
1456  BEGIN
1457      NEW.word_id = GEN_ID(phpbb_words_gen, 1);
1458  END;;
1459  
1460  
1461  # Table: 'phpbb_zebra'
1462  CREATE TABLE phpbb_zebra (
1463      user_id INTEGER DEFAULT 0 NOT NULL,
1464      zebra_id INTEGER DEFAULT 0 NOT NULL,
1465      friend INTEGER DEFAULT 0 NOT NULL,
1466      foe INTEGER DEFAULT 0 NOT NULL
1467  );;
1468  
1469  ALTER TABLE phpbb_zebra ADD PRIMARY KEY (user_id, zebra_id);;
1470  
1471