Created
May 6, 2019 19:14
-
-
Save jamster10/8b9c7ac8d296dd1f77884f3129b02287 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE USER "dunder-mifflin" SUPERUSER; | |
CREATE DATABASE bookmarks OWNER "dunder-mifflin"; | |
\c bookmarks; | |
create table bookmarks ( | |
id BIGSERIAL NOT NULL PRIMARY KEY, | |
title VARCHAR(50) NOT NULL, | |
url VARCHAR(100) NOT NULL, | |
content VARCHAR(200) | |
); | |
insert into bookmarks (title, url, content) values ('Duobam', 'https://msu.edu', 'Morbi porttitor lore ligula.'); | |
insert into bookmarks (title, url, content) values ('Treeflex', 'http://mac.com', 'Curabitur gravida nisi at nibh. In hac habitasse platea dictumst.'); | |
insert into bookmarks (title, url, content) values ('Namfix', 'https://utexas.edu', 'Nulla mollis molestie lorem. Quisque ut erat. Curabitur gravida nisi at nibh. In hac habitasse platea dictumst.'); | |
insert into bookmarks (title, url, content) values ('Redhold', 'http://wiley.com', 'Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus. Phasellus in felis.'); | |
insert into bookmarks (title, url, content) values ('Daltfresh', 'http://hhs.gov', 'Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in f.'); | |
insert into bookmarks (title, url, content) values ('Sonair', 'https://jalbum.net', 'Nulla nisl. Nunc nisl. Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu massa.'); | |
insert into bookmarks (title, url, content) values ('Aerified', 'https://angelfire.com', 'In blandit ultrices enim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin interdum mauris non ligula pellentesque ultrices.'); | |
insert into bookmarks (title, url, content) values ('Ronstring', 'https://typepad.com', 'Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus. In sagittis dui vel nisl.'); | |
insert into bookmarks (title, url, content) values ('Ronstring', 'http://ocn.ne.jp', 'In hac habitasse platea dictumst. Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat.'); | |
insert into bookmarks (title, url, content) values ('Otcom', 'https://sciencedaily.com', 'Aliquam quis turpis eget elit sodales scelerisque. Mauris sit amet eros.'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment