BEGIN;CREATE TABLE "bt_thread" (
    "id" integer unsigned NOT NULL PRIMARY KEY,
    "title" varchar(50) NOT NULL,
    "board_id" integer unsigned NOT NULL,
    "forum_id" integer unsigned NOT NULL
)
;
CREATE TABLE "bt_bluepost" (
    "id" integer unsigned NOT NULL PRIMARY KEY,
    "thread_id" integer NOT NULL REFERENCES "bt_thread" ("id"),
    "date" datetime NOT NULL,
    "num_reply" integer unsigned NOT NULL,
    "author" varchar(50) NOT NULL,
    "isblue" bool NOT NULL,
    "post_content" text NOT NULL
)
;