From 128bec73070fefdb3d36044e6f2a5f50e4c28cb0 Mon Sep 17 00:00:00 2001 From: user Date: Wed, 28 Feb 2024 16:09:26 +0100 Subject: comments rename field username -> nickname --- create_db.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'create_db.sql') diff --git a/create_db.sql b/create_db.sql index b8aacbe..c4202af 100644 --- a/create_db.sql +++ b/create_db.sql @@ -3,7 +3,7 @@ CREATE TABLE comment ( comment text NOT NULL, page_url text, visitor_url text, - username text, + nickname text, show_visitor_url bool, contact text, show_contact bool, @@ -18,14 +18,14 @@ comment on column comment.contact is 'A means of contacting this person, email p comment on column comment.show_contact is 'True: Publicly show the contact information, False: Site creators eyes only'; comment on column comment.public is 'Indicates if the comment is to be publicly viewable, or if it''s merely for the creator'; -INSERT INTO comment (comment, page_url, username, visitor_url, show_visitor_url, contact, show_contact, public, approved) +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, username, visitor_url, show_visitor_url, contact, show_contact, public, approved) +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, username, visitor_url, show_visitor_url, contact, show_contact, public, approved) +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, username, visitor_url, show_visitor_url, contact, show_contact, public, approved) +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); \ No newline at end of file -- cgit 1.4.1