Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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" +
- ");";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement