diff options
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 |