aboutsummaryrefslogtreecommitdiff
path: root/Makefile
diff options
context:
space:
mode:
authorJohn Ankarström <john@ankarstrom.se>2021-09-17 23:47:58 +0200
committerJohn Ankarström <john@ankarstrom.se>2021-09-17 23:47:58 +0200
commit7d65ce8c8e304dc8367f4492948514f2acc07a3b (patch)
tree1d1e8584ad326cf3ea7701e2a726a0f0ae1cb6cf /Makefile
parent56509ab16c8d2225182eb0400e5c6a4900870391 (diff)
downloadcforum-7d65ce8c8e304dc8367f4492948514f2acc07a3b.tar.gz
Whatever
Diffstat (limited to 'Makefile')
-rw-r--r--Makefile3
1 files changed, 2 insertions, 1 deletions
diff --git a/Makefile b/Makefile
index f6fdc96..37472bd 100644
--- a/Makefile
+++ b/Makefile
@@ -16,4 +16,5 @@ db:
sqlite3 db "CREATE TABLE users(name, full, hash NOT NULL, PRIMARY KEY (name));"
sqlite3 db "INSERT INTO users values('john', 'John Ankarström', '123');"
sqlite3 db "CREATE TABLE posts(parent INT, user INT NOT NULL, created INT NOT NULL, edited INT, subject NOT NULL, text NOT NULL, FOREIGN KEY (user) REFERENCES users(oid));"
- sqlite3 db "INSERT INTO posts values(NULL, 1, 1462137896, NULL, 'Hello World!', 'This is the first post.');" \ No newline at end of file
+ sqlite3 db "INSERT INTO posts values(NULL, 1, 1462137896, NULL, 'Hello World!', 'This is the first post.');"
+ sqlite3 db "INSERT INTO posts values(1, 1, 1462138896, NULL, 'Re: Hello World!', 'This is the second post!');" \ No newline at end of file