1 CREATE TABLE decir_forums(

     2   forum_id int(12) unsigned NOT NULL auto_increment,

     3   forum_type tinyint(2) unsigned NOT NULL DEFAULT 1,

     4   forum_name varchar(255) NOT NULL,

     5   forum_desc text NOT NULL,

     6   parent int(12) unsigned NOT NULL DEFAULT 0,

     7   forum_order int(12) unsigned NOT NULL DEFAULT 1,

     8   last_post_id int(18) unsigned,

     9   last_post_topic int(12) unsigned,

    10   last_post_user int(12) unsigned,

    11   num_topics int(15) unsigned,

    12   num_posts int(18) unsigned,

    13   forum_extra text,

    14   PRIMARY KEY ( forum_id )

    15 );

    16 CREATE TABLE decir_topics(

    17   topic_id int(15) unsigned NOT NULL auto_increment,

    18   forum_id int(12) unsigned NOT NULL,

    19   topic_title varchar(255) NOT NULL,

    20   topic_icon tinyint(3) unsigned NOT NULL,

    21   topic_starter int(12) unsigned NOT NULL,

    22   topic_type tinyint(2) unsigned NOT NULL DEFAULT 1,

    23   topic_locked tinyint(1) unsigned NOT NULL DEFAULT 0,

    24   topic_moved tinyint(1) unsigned NOT NULL DEFAULT 0,

    25   timestamp int(11) unsigned NOT NULL,

    26   PRIMARY KEY ( topic_id )

    27 );

    28 CREATE TABLE decir_posts(

    29   post_id bigint(18) unsigned NOT NULL auto_increment,

    30   topic_id bigint(15) unsigned NOT NULL,

    31   poster_id int(12) unsigned NOT NULL,

    32   poster_name varchar(255) NOT NULL,

    33   timestamp int(11) unsigned NOT NULL,

    34   last_edited_by int(12) unsigned DEFAULT NULL,

    35   edit_count int(5) unsigned,

    36   edit_reason varchar(255),

    37   PRIMARY KEY ( post_id )

    38 );

    39 CREATE TABLE decir_posts_text(

    40   post_id bigint(18) unsigned NOT NULL,

    41   post_text longtext NOT NULL,

    42   bbcode_uid varchar(10) NOT NULL,

    43   PRIMARY KEY ( post_id )

    44 );

    45 CREATE TABLE decir_hits(

    46   hit_id bigint(21) unsigned NOT NULL auto_increment,

    47   user_id int(12) unsigned NOT NULL DEFAULT 1,

    48   topic_id bigint(15) unsigned NOT NULL,

    49   timestamp int(11) unsigned NOT NULL,

    50   PRIMARY KEY ( hit_id )

    51 );