From 128bec73070fefdb3d36044e6f2a5f50e4c28cb0 Mon Sep 17 00:00:00 2001
From: user <user@node5.net>
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

