src/main/resources/data.sql - master - 86/practice

src/main/resources/data.sql
37 строк3 KB
Danil Tkach
init
18 июн 2026, 20:12
18 июн 2026, 20:12e148f75
INSERT IGNORE INTO regions (name)
VALUES ('Азия'),
       ('Европа');

INSERT IGNORE INTO countries (name, region_id)
VALUES ('Грузия', (SELECT id FROM regions WHERE name = 'Азия')),
       ('Германия', (SELECT id FROM regions WHERE name = 'Европа')),
       ('Финляндия', (SELECT id FROM regions WHERE name = 'Европа')),
       ('Голландия', (SELECT id FROM regions WHERE name = 'Европа')),
       ('Турция', (SELECT id FROM regions WHERE name = 'Азия'));

INSERT IGNORE INTO product_types (name)
VALUES ('Спортивные снаряды'),
       ('Маты'),
       ('Ринг');

INSERT IGNORE INTO sales (country_id, product_type_id, quantity)
VALUES ((SELECT id FROM countries WHERE name = 'Грузия'),
        (SELECT id FROM product_types WHERE name = 'Спортивные снаряды'), 200),
       ((SELECT id FROM countries WHERE name = 'Грузия'), (SELECT id FROM product_types WHERE name = 'Маты'), 600),
       ((SELECT id FROM countries WHERE name = 'Грузия'), (SELECT id FROM product_types WHERE name = 'Ринг'), 700),
       ((SELECT id FROM countries WHERE name = 'Германия'),
        (SELECT id FROM product_types WHERE name = 'Спортивные снаряды'), 400),
       ((SELECT id FROM countries WHERE name = 'Германия'), (SELECT id FROM product_types WHERE name = 'Маты'), 400),
       ((SELECT id FROM countries WHERE name = 'Германия'), (SELECT id FROM product_types WHERE name = 'Ринг'), 500),
       ((SELECT id FROM countries WHERE name = 'Финляндия'),
        (SELECT id FROM product_types WHERE name = 'Спортивные снаряды'), 500),
       ((SELECT id FROM countries WHERE name = 'Финляндия'), (SELECT id FROM product_types WHERE name = 'Маты'), 3000),
       ((SELECT id FROM countries WHERE name = 'Финляндия'), (SELECT id FROM product_types WHERE name = 'Ринг'), 400),
       ((SELECT id FROM countries WHERE name = 'Голландия'),
        (SELECT id FROM product_types WHERE name = 'Спортивные снаряды'), 30),
       ((SELECT id FROM countries WHERE name = 'Голландия'), (SELECT id FROM product_types WHERE name = 'Маты'), 1000),
       ((SELECT id FROM countries WHERE name = 'Голландия'), (SELECT id FROM product_types WHERE name = 'Ринг'), 300),
       ((SELECT id FROM countries WHERE name = 'Турция'),
        (SELECT id FROM product_types WHERE name = 'Спортивные снаряды'), 40),
       ((SELECT id FROM countries WHERE name = 'Турция'), (SELECT id FROM product_types WHERE name = 'Маты'), 500),
       ((SELECT id FROM countries WHERE name = 'Турция'), (SELECT id FROM product_types WHERE name = 'Ринг'), 266);