Skip to content

Instantly share code, notes, and snippets.

@Thersis94
Created October 19, 2019 18:41
Show Gist options
  • Save Thersis94/f9e4a27ac2ad0209d56fc754fc3907a4 to your computer and use it in GitHub Desktop.
Save Thersis94/f9e4a27ac2ad0209d56fc754fc3907a4 to your computer and use it in GitHub Desktop.
create table bookmarks (
id integer primary key generated by default as identity,
title text not null,
description text,
rating integer default 1,
url text
);
insert into bookmarks (
title,
description,
rating,
url
)
values
(
'bookmark one',
'This is bookmark one',
'1',
'https://www.google.com/'
),
(
'bookmark two',
'This is bookmark two',
'2',
'https://www.google.com/'
),
(
'bookmark three',
'This is bookmark three',
'3',
'https://www.google.com/'
),
(
'bookmark four',
'This is bookmark four',
'4',
'https://www.google.com/'
),
(
'bookmark five',
'This is bookmark five',
'5',
'https://www.google.com/'
),
(
'bookmark six',
'This is bookmark six',
'1',
'https://www.google.com/'
),
(
'bookmark seven',
'This is bookmark seven',
'2',
'https://www.google.com/'
),(
'bookmark eight',
'This is bookmark eight',
'3',
'https://www.google.com/'
),
(
'bookmark nine',
'This is bookmark nine',
'4',
'https://www.google.com/'
),
(
'bookmark ten',
'This is bookmark ten',
'5',
'https://www.google.com/'
);
select *
from bookmarks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment