From b1a885ac229892bac528e6fea4e011a1b240867b Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Fri, 10 Oct 2025 20:55:37 +0500 Subject: initial commit --- database.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 database.sql (limited to 'database.sql') diff --git a/database.sql b/database.sql new file mode 100644 index 0000000..ab284a5 --- /dev/null +++ b/database.sql @@ -0,0 +1,13 @@ +CREATE TABLE IF NOT EXISTS statuses ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + title TEXT NOT NULL, + contents TEXT, + posted_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP +); + +CREATE TABLE IF NOT EXISTS comments ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + name TEXT, + contents TEXT NOT NULL, + posted_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP +); \ No newline at end of file -- cgit v1.2.3