CREATE TABLE IF NOT EXISTS "user_forums" ( "user_id" INTEGER NOT NULL, "forum_id" INTEGER NOT NULL, PRIMARY KEY ("user_id", "forum_id"), FOREIGN KEY ("user_id") REFERENCES "users"("id"), FOREIGN KEY ("forum_id") REFERENCES "forums"("id") );