lab-sql-mysql-db-creation/seeding.sql at main · synergeo/lab-sql-mysql-db-creation · 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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
USE lab_mysql;


INSERT INTO cars
    (vin, manufacturer, model, car_year, color)
VALUES
    ('3K096I98581DHSNUP', 'Volkswagen', 'Tiguan', 2019, 'Blue'),
    ('ZM8G7BEUQZ97IH46V', 'Peugeot', 'Rifter', 2019, 'Red'),
    ('RKXVNNIHLVVZOUB4M', 'Ford', 'Fusion', 2018, 'White'),
    ('HKNDGS7CU31E9Z7JW', 'Toyota', 'RAV4', 2018, 'Silver'),
    ('DAM41UDN3CHU2WVF6', 'Volvo', 'V60', 2019, 'Gray'),
    ('DAM41UDN3CHU2WVF6', 'Volvo', 'V60 Cross Country', 2019, 'Gray');


INSERT INTO customers
    (
        cust_id,
        cust_name,
        cust_phone,
        cust_email,
        cust_address,
        cust_city,
        cust_state,
        cust_country,
        cust_zipcode
    )
VALUES
    (
        10001,
        'Pablo Picasso',
        '+34 636 17 63 82',
        NULL,
        'Paseo de la Chopera, 14',
        'Madrid',
        'Madrid',
        'Spain',
        '28045'
    ),
    (
        20001,
        'Abraham Lincoln',
        '+1 305 907 7086',
        NULL,
        '120 SW 8th St',
        'Miami',
        'Florida',
        'United States',
        '33130'
    ),
    (
        30001,
        'Napoléon Bonaparte',
        '+33 1 79 75 40 00',
        NULL,
        '40 Rue du Colisée',
        'Paris',
        'Île-de-France',
        'France',
        '75008'
    );


INSERT INTO salespersons
    (staff_id, name, store)
VALUES
    ('00001', 'Petey Cruiser', 'Madrid'),
    ('00002', 'Anna Sthesia', 'Barcelona'),
    ('00003', 'Paul Molive', 'Berlin'),
    ('00004', 'Gail Forcewind', 'Paris'),
    ('00005', 'Paige Turner', 'Miami'),
    ('00006', 'Bob Frapples', 'Mexico City'),
    ('00007', 'Walter Melon', 'Amsterdam'),
    ('00008', 'Shonda Leer', 'São Paulo');


INSERT INTO invoices
    (
        invoice_number,
        invoice_date,
        car_id,
        customer_id,
        salesperson_id
    )
VALUES
    ('852399038', '2018-08-22', 1, 1, 3),
    ('731166526', '2018-12-31', 3, 3, 5),
    ('271135104', '2019-01-22', 2, 2, 7);