animalyst/animals.sql at master · maidis/animalyst · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- sqlite3 animals.db < animals.sql

CREATE TABLE animals (
  id INTEGER PRIMARY KEY,
  name TEXT,
  image TEXT
);

INSERT INTO animals (name, image) VALUES('dolphin', 'dolphin-marine-mammals-water-sea-64219.jpg');
INSERT INTO animals (name, image) VALUES('dog', 'night-garden-yellow-animal.jpg');
INSERT INTO animals (name, image) VALUES('owl', 'owl.jpg');
INSERT INTO animals (name, image) VALUES('panda', 'pexels-photo-1123765.jpg');
INSERT INTO animals (name, image) VALUES('owl', 'pexels-photo-105810.jpg');
INSERT INTO animals (name, image) VALUES('panda', 'pexels-photo-146087.jpg');
INSERT INTO animals (name, image) VALUES('seagull', 'pexels-photo-213697.jpg');
INSERT INTO animals (name, image) VALUES('horse', 'pexels-photo-614505.jpg');
INSERT INTO animals (name, image) VALUES('seagull', 'pexels-photo-213191.jpg');
INSERT INTO animals (name, image) VALUES('horse', 'pexels-photo-635499.jpg');
INSERT INTO animals (name, image) VALUES('cat', 'pexels-photo-669015.jpg');
INSERT INTO animals (name, image) VALUES('dog', 'pexels-photo-733416.jpg');
INSERT INTO animals (name, image) VALUES('cat', 'pexels-photo-747795.jpg');
INSERT INTO animals (name, image) VALUES('dolphin', 'pexels-photo-994473.jpg');