diff options
| author | user <user@node5.net> | 2024-02-28 16:09:26 +0100 |
|---|---|---|
| committer | user <user@node5.net> | 2024-02-28 16:09:26 +0100 |
| commit | 128bec73070fefdb3d36044e6f2a5f50e4c28cb0 (patch) | |
| tree | f13bb916f9560878d8db7026b7ff33f266fcbb4c /create_db.sql | |
| parent | 77cbfd6a96225c1e2f6f3f34f93c5565260f5f55 (diff) | |
comments rename field username -> nickname
Diffstat (limited to 'create_db.sql')
| -rw-r--r-- | create_db.sql | 10 |
1 files changed, 5 insertions, 5 deletions
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 |