CREATE TABLE decir_forums(
  forum_id int(12) unsigned NOT NULL auto_increment,
  forum_type tinyint(2) unsigned NOT NULL DEFAULT 1,
  forum_name varchar(255) NOT NULL,
  forum_desc text NOT NULL,
  parent int(12) unsigned NOT NULL DEFAULT 0,
  forum_order int(12) unsigned NOT NULL DEFAULT 1,
  last_post_id int(18) unsigned,
  last_post_topic int(12) unsigned,
  last_post_user int(12) unsigned,
  num_topics int(15) unsigned,
  num_posts int(18) unsigned,
  forum_extra text,
  PRIMARY KEY ( forum_id )
);
CREATE TABLE decir_topics(
  topic_id int(15) unsigned NOT NULL auto_increment,
  forum_id int(12) unsigned NOT NULL,
  topic_title varchar(255) NOT NULL,
  topic_icon tinyint(3) unsigned NOT NULL,
  topic_starter int(12) unsigned NOT NULL,
  topic_type tinyint(2) unsigned NOT NULL DEFAULT 1,
  topic_locked tinyint(1) unsigned NOT NULL DEFAULT 0,
  topic_moved tinyint(1) unsigned NOT NULL DEFAULT 0,
  timestamp int(11) unsigned NOT NULL,
  topic_deleted tinyint(1) NOT NULL DEFAULT 0,
  topic_deletor int(12) DEFAULT NULL,
  topic_delete_reason varchar(255) DEFAULT NULL,
  PRIMARY KEY ( topic_id )
);
CREATE TABLE decir_posts(
  post_id bigint(18) unsigned NOT NULL auto_increment,
  topic_id bigint(15) unsigned NOT NULL,
  poster_id int(12) unsigned NOT NULL,
  poster_name varchar(255) NOT NULL,
  post_subject varchar(255) NOT NULL DEFAULT '',
  timestamp int(11) unsigned NOT NULL,
  last_edited_by int(12) unsigned DEFAULT NULL,
  edit_count int(5) unsigned NOT NULL DEFAULT 0,
  edit_reason varchar(255),
  post_deleted tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY ( post_id )
);
CREATE TABLE decir_posts_text(
  post_id bigint(18) unsigned NOT NULL,
  post_text longtext NOT NULL,
  bbcode_uid varchar(10) NOT NULL,
  PRIMARY KEY ( post_id )
);
CREATE TABLE decir_hits(
  hit_id bigint(21) unsigned NOT NULL auto_increment,
  user_id int(12) unsigned NOT NULL DEFAULT 1,
  topic_id bigint(15) unsigned NOT NULL,
  timestamp int(11) unsigned NOT NULL,
  PRIMARY KEY ( hit_id )
);