diff options
author | John Ankarström <john@ankarstrom.se> | 2021-09-18 22:51:30 +0200 |
---|---|---|
committer | John Ankarström <john@ankarstrom.se> | 2021-09-18 22:51:44 +0200 |
commit | 9ff1b81d65c370a938cd9d9c033e04e395f00704 (patch) | |
tree | 3f507a48d8d39f27a36b3fab32b0a230abe512f4 /Makefile | |
parent | 2b915a42f6665b4110338cfde30eedc55abe7f3c (diff) | |
download | cforum-9ff1b81d65c370a938cd9d9c033e04e395f00704.tar.gz |
New user
Diffstat (limited to 'Makefile')
-rw-r--r-- | Makefile | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -33,5 +33,5 @@ db: 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.');" sqlite3 db "INSERT INTO posts values(1, 1, 1462138896, NULL, 'Re: Hello World!', 'This is the second post!');" - sqlite3 db "CREATE TABLE atts(post INT NOT NULL, name NOT NULL, description, mime NOT NULL, data BLOB, FOREIGN KEY (post) REFERENCES posts(oid));" + sqlite3 db "CREATE TABLE atts(post INT NOT NULL, name NOT NULL, desc, mime NOT NULL, data BLOB, FOREIGN KEY (post) REFERENCES posts(oid));" sqlite3 db "$$(printf "INSERT INTO atts values(1, 'example', 'Some example shell code.', 'text/plain', '#!/bin/sh\necho Hello World!');")"
\ No newline at end of file |