Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS posts;
- CREATE TABLE posts (
- id INTEGER PRIMARY KEY autoincrement,
- title string NOT NULL,
- name string NOT NULL,
- text string NOT NULL
- );
- DROP TABLE IF EXISTS replies;
- CREATE TABLE replies (
- replyid INTEGER PRIMARY KEY autoincrement,
- OPid INTEGER
- name string NOT NULL,
- text string NOT NULL,
- FOREIGN KEY(OPid) REFERENCES posts(id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement