dummy_data.sql 2.01 KB
Newer Older
Sorrel Harriet's avatar
Sorrel Harriet committed
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
INSERT INTO Genre (name)
VALUES
('Reggae'),
('Funk and Soul'),
('Jazz'),
('Classical'),
('Electronic'),
('Pop');

INSERT INTO Band (name, genre_id)
VALUES
('The Wailers', 1),
('The Aces', 2),
('The Beatles', 6);

INSERT INTO Artist (first_name, last_name, band_id) 
VALUES
('Bob', 'Marley', 1),
('Peter', 'Tosh', 1),
('Burning', 'Spear', NULL),
('Alton', 'Ellis', NULL),
('Gregory', 'Issacs', NULL),
('Desmond', 'Dekker', 2),
('John', 'Lennon', 3),
('Madonna', NULL, NULL);

INSERT INTO Album (upc, title, year, artist_id, price, genre_id) 
VALUES
('123425364732', 'Soul Rebel', 1970, 1, 25.99, 1 ),
('017263547261', 'Catch A Fire', 1973, 1, 25.99, 1 ),
('018263526272', 'Natty Dread', 1974, 1, 20.99, 1 ),
('018273527273', 'Babylon By Bus', 1978, 1, 24.99, 1 ),
('491827364626', 'Night Nurse', 1982, 5, 17.99, 1 ),
('018276272828', 'Mr Issacs', 1982, 5, 9.99, 1 ),
('018273662728', 'Black and Dekker', 1980, 6, 19.99, 1 ),
('726517237627', 'Sunday Coming', 1970, 4, 15.99, 1 ),
('018274372722', 'Imagine', 1971, 7, 11.99, 6 ),
('018273727287', 'Like a Virgin', 1984, 8, 9.99, 6 );

INSERT INTO Track (name, album_upc, track_number)
VALUES
('Sunday Coming', '726517237627', 1),
('Imagine', '018274372722', 1),
('Material Girl', '018273727287', 1),
('Angel', '018273727287', 2),
('Like a Virgin', '018273727287', 3),
('Crippled Inside', '018274372722', 2),
('These Eyes', '726517237627', 2),
('Hurting Me', '726517237627', 3);

INSERT INTO Customer (username, email_address, password, first_name, last_name, address_1, address_2, postcode)
VALUES
Sorrel Harriet's avatar
Sorrel Harriet committed
53
54
('sharr003', 's.harriet@gold.ac.uk', 'SOME_HASHED_VALUE', 'Sorrel', 'Harriet', '12 Fake Street', 'London', 'SE140PL'),
('ktack001', 'k.tackie@hotmail.com', 'SOME_HASHED_VALUE', 'Kobi', 'Tackie', '12 Fake Street', 'London', 'SE140PL');
Sorrel Harriet's avatar
Sorrel Harriet committed
55
56
57

INSERT INTO Transaction (customer_id, delivery)
VALUES
Sorrel Harriet's avatar
Sorrel Harriet committed
58
59
60
(1, 'next working day'),
(1, 'first class'),
(2, 'second class');
Sorrel Harriet's avatar
Sorrel Harriet committed
61
62
63
64

INSERT INTO LineItem (trans_id, album_upc, quantity)
VALUES
(1, '018273727287', 1),
Sorrel Harriet's avatar
Sorrel Harriet committed
65
66
(2, '018273727287', 1),
(3, '491827364626', 1),
Sorrel Harriet's avatar
Sorrel Harriet committed
67
(1, '018274372722', 2);