initialize_database.ts

  const thread_table_sql = "CREATE TABLE IF NOT EXISTS Threads (" +
                             "thread_id TEXT PRIMARY KEY," +
                             "author INTEGER REFERENCES Users(user_id)," +
                             "board string REFERENCES Boards(board_id)," +
                             "name TEXT NOT NULL," +
                             "description TEXT NOT NULL," +
                             "created_at TIMESTAMP NOT NULL" +
                           ");";
  const post_table_sql = "CREATE TABLE IF NOT EXISTS Posts (" +
                           "post_id TEXT PRIMARY KEY," +
                           "author INTEGER REFERENCES Users(user_id)," +
                           "thread TEXT REFERENCES Threads(thread_id)," +
                           "title TEXT," +
                           "content TEXT," +
                           "reply_to string REFERENCES Posts(post_id)," +
                           "created_at TIMESTAMP NOT NULL" +
                         ");";