From 38b8178cce160b3d2e6c8b3256c7655f4d0a27cd Mon Sep 17 00:00:00 2001 From: "user@node5.net" Date: Mon, 15 Jun 2026 21:24:56 +0200 Subject: internalize needed files for starting the program --- src/create_db.sql | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 src/create_db.sql (limited to 'src/create_db.sql') diff --git a/src/create_db.sql b/src/create_db.sql new file mode 100644 index 0000000..ee0f968 --- /dev/null +++ b/src/create_db.sql @@ -0,0 +1,25 @@ +CREATE TABLE comment ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + comment text NOT NULL, -- URL of the page the comment belongs to, this is the relation between the markdown and this database + page_url text, + visitor_url text, -- The website the user claims to be from, if they have their own self hosted website + nickname text, + show_visitor_url bool, + contact text, -- A means of contacting this person, email phone, or similar + show_contact bool, -- True: Publicly show the contact information, False: Site creators eyes only + public bool, -- Indicates if the comment is to be publicly viewable, or if it''s merely for the creator + approved bool DEFAULT FALSE, + created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP +); + +INSERT INTO comment (comment, page_url, nickname, visitor_url, show_visitor_url, contact, show_contact, public, approved) + VALUES ('Hello world!', '/', 'user@node5.net', 'https://blog.node5.net/', TRUE, 'Leave a comment on this blog', TRUE, TRUE, TRUE); + +INSERT INTO comment (comment, page_url, nickname, visitor_url, show_visitor_url, contact, show_contact, public, approved) + VALUES ('Test private means of contact', '/', NULL, NULL, TRUE, 'Death star plans', FALSE, TRUE, TRUE); + +INSERT INTO comment (comment, page_url, nickname, visitor_url, show_visitor_url, contact, show_contact, public, approved) + VALUES ('Test private comment', '/', NULL, NULL, TRUE, 'Don''t', TRUE, FALSE, TRUE); + +INSERT INTO comment (comment, page_url, nickname, visitor_url, show_visitor_url, contact, show_contact, public, approved) + VALUES ('Test unapproved comment', '/', NULL, NULL, TRUE, NULL, TRUE, TRUE, FALSE); -- cgit v1.3.1