CREATE TABLE  Threads (
       threadID INT NOT NULL AUTO_INCREMENT
     , threadSubject VARCHAR(100) NOT NULL
     , threadContent TEXT NOT NULL
     , link VARCHAR(200)
     , poster VARCHAR(100) NOT NULL
     , PRIMARY KEY (threadID)
);

CREATE TABLE  ThreadReplies (
       replyID INT NOT NULL AUTO_INCREMENT
     , replySubject VARCHAR(100)
     , replyContent TEXT NOT NULL
     , poster VARCHAR(100) NOT NULL
     , PRIMARY KEY (replyID)
);

CREATE TABLE  ThreadsRepliesRelationship (
       threadID INT NOT NULL
     , replyID INT NOT NULL
     , INDEX (threadID)
     , CONSTRAINT ThreadsFK FOREIGN KEY (threadID)
                  REFERENCES  Threads (threadID) ON DELETE CASCADE
     , INDEX (replyID)
     , CONSTRAINT RepliesFK FOREIGN KEY (replyID)
                  REFERENCES  ThreadReplies (replyID) ON DELETE CASCADE
);