Darien

CREATE TABLE  IF NOT EXISTS forum_threads (
    forum_threads_id     INT NOT NULL ,
    forum_threads_name   VARCHAR( 50 ) NOT NULL ,
    forum_threads_user   VARCHAR( 32 ) NOT NULL ,
    forum_threads_active TINYINT NOT NULL,
    primary key (forum_threads_id)
)
ENGINE=INNODB;


CREATE TABLE forum_posts (
    forum_posts_id     INT NOT NULL ,
    forum_threads_id   INT NOT NULL ,
    forum_posts_text   MEDIUMBLOB NOT NULL ,
    forum_posts_active TINYINT NOT NULL,
    INDEX par_ind (forum_threads_id),
    FOREIGN KEY (forum_threads_id) REFERENCES forum_threads(forum_threads_id)
    ON DELETE CASCADE
)
ENGINE=INNODB;