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,

  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,

  timestamp int(11) unsigned NOT NULL,

  last_edited_by int(12) unsigned DEFAULT NULL,

  edit_count int(5) unsigned,

  edit_reason varchar(255),

  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 )

);