golang-sneaker-api/data.sql at master · ktross/golang-sneaker-api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
CREATE TABLE `sneakers` (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT,
  `name` VARCHAR(64) NOT NULL
);

CREATE TABLE `true_to_size` (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT,
  `sneaker_id` INTEGER NOT NULL,
  `size` INTEGER NOT NULL,
  FOREIGN KEY (sneaker_id) REFERENCES sneakers(id)
);

INSERT INTO `sneakers` (name)
VALUES
  ('Jordan 3 Retro Black Cement (2018)'),
  ('Jordan 1 Retro High NRG Patent Gold Toe'),
  ('Air Foamposite One Big Bang'),
  ('adidas Yeezy Boost 350 V2 Blue Tint');

INSERT INTO `true_to_size` (sneaker_id, size)
VALUES
  (1, 1),
  (1, 2),
  (1, 2),
  (1, 3),
  (1, 2),
  (1, 3),
  (1, 2),
  (1, 2),
  (1, 3),
  (1, 4),
  (1, 2),
  (1, 5),
  (1, 2),
  (1, 3),
  (2, 1),
  (2, 2),
  (2, 2),
  (2, 3),
  (2, 2),
  (2, 3),
  (2, 2),
  (2, 2),
  (2, 3),
  (2, 4),
  (2, 2),
  (2, 5),
  (2, 2),
  (2, 3),
  (2, 2),
  (3, 3),
  (3, 1),
  (3, 3),
  (3, 1),
  (3, 2),
  (4, 5),
  (4, 5),
  (4, 5),
  (4, 5),
  (4, 5);