All pastes #221460 Raw Edit

Unnamed

public text v1 · immutable
#221460 ·published 2006-10-25 18:25 UTC
rendered paste body
			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
			)
            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;