Add database helper functions

1 files changed, 4 insertions, 4 deletions

diff --git a/Makefile b/Makefile
index 4e788a9..f6fdc96 100644
--- a/Makefile
+++ b/Makefile
@@ -13,7 +13,7 @@ cforum: $(C) $(TPL)
 db:
 	sqlite3 db "CREATE TABLE settings(key, value, PRIMARY KEY (key));"
 	sqlite3 db "INSERT INTO settings values('name', 'C Forum');"
-	sqlite3 db "CREATE TABLE users(name, hash NOT NULL, PRIMARY KEY (name));"
-	sqlite3 db "INSERT INTO users values('john', '123');"
-	sqlite3 db "CREATE TABLE posts(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(1, 0, NULL, 'Hello World!', 'This is the first post.');"
\ No newline at end of file
+	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