-
Notifications
You must be signed in to change notification settings - Fork 0
/
SuperScript.sql
119 lines (115 loc) · 15.7 KB
/
SuperScript.sql
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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
INSERT INTO Customer(Id, Name, Email, PhoneNumber, Address, City, Zipcode, State, Country)
VALUES
('1656b3f2-5f5c-4630-8d52-0c676aa827ef', 'Imogen Fiennes', '[email protected]', '806-273-5958', '51655 Northridge Trail', 'Amarillo', '79105', 'Texas', 'United States'),
('7a2c7e9c-4166-4230-8157-955eb569902c', 'Hillie Poulston', '[email protected]', '972-471-2541', '86173 Oxford Center', 'Lusacan', '4325', 'New York', 'Philippines'),
('3b6da8e7-3feb-44d5-9084-ab1da2028bb2', 'Emmet Poundford', '[email protected]', '876-184-9092', '01 Debs Point', 'Marinha', '2425-838', 'Leiria', 'Portugal'),
('df6c454b-3246-4e5b-940f-229f9a997622', 'Bathsheba Ganforth', '[email protected]', '413-239-7753', '203 Mayfield Plaza', 'Hongcheng', '12345', 'California', 'China'),
('95e65581-6c9a-4e8c-806d-f9230118125c', 'Maighdiln Kubalek', '[email protected]', '551-914-0658', '9777 Thackeray Terrace', 'Luofang', '23456', 'Texas', 'China'),
('246c9ff1-e958-444a-9c7e-c13ef8247a1a', 'Lena Arrol', '[email protected]', '800-496-1552', '4 Oak Valley Place', 'Midland', 'L4R', 'Ontario', 'Canada'),
('7ced7999-52bb-4a54-b2ce-1d7a583f26d1', 'Viole Eastcott', '[email protected]', '858-147-0315', '84 Susan Plaza', 'Kostyantynivka', '43210', 'Florida', 'Ukraine'),
('f1848a07-8227-4bbd-ac6d-be45b0c6491c', 'Dianemarie Monksfield', '[email protected]', '968-403-3647', '6 Fallview Hill', 'Jiantang', '54321', 'Illinois', 'China'),
('180859f5-bb76-4158-97ed-a234f09e7312', 'Lu Boote', '[email protected]', '514-270-0322', '3 Brickson Park Junction', 'Belize City', '87654', 'Texas', 'Belize'),
('8e11f62b-75b5-4dab-9d1b-a6740497f811', 'Brynne Vigneron', '[email protected]', '353-261-7927', '295 Scofield Circle', 'Dainan', '76543', 'California', 'China'),
('65df140e-038a-41f6-a364-9f5fa63d8b92', 'Betty Knight', '[email protected]', '343-815-2382', '9093 Autumn Leaf Hill', 'Tsybli', '34567', 'Texas', 'Ukraine'),
('0116cae4-b9a1-4ae8-8720-8b92d9697552', 'Rivi Teresse', '[email protected]', '804-383-8450', '505 Russell Plaza', 'Gävle', '78901', 'New York', 'Sweden'),
('4f93945a-4ac2-4fc9-9ca0-38cfb26e2b02', 'Claresta Verbrugge', '[email protected]', '741-151-9899', '4973 Shelley Crossing', 'Mastaiciai', '60028', 'California', 'Lithuania'),
('04dcfd38-1752-4495-a75c-73bdbed314cf', 'Regine Ondricek', '[email protected]', '551-799-7719', '30 Tony Center', 'San José de Barlovento', '12345', 'Florida', 'Venezuela'),
('9a699439-930a-4525-b062-23c5c5cc8393', 'Cathyleen Martellini', '[email protected]', '111-904-1004', '5 Del Sol Crossing', 'Shal’skiy', '186167', 'Illinois', 'Russia'),
('84ef3939-ad8a-43ad-b91c-e7caba43f679', 'Doralia Ogers', '[email protected]', '979-581-0898', '2934 Dwight Parkway', 'Cipolletti', '8324', 'California', 'Argentina'),
('0df1a19e-944c-4cf6-b28c-9b8f56f42fb9', 'Alick Hamlin', '[email protected]', '266-622-1527', '33 Oak Trail', 'Carcavelos', '2775-398', 'New York', 'Portugal'),
('9ae22d93-4337-4a11-bc5c-2de223ca061d', 'Constantia Corrin', '[email protected]', '638-465-7423', '1391 Northwestern Parkway', 'Sukawening', '98765', 'Texas', 'Indonesia'),
('c984cb44-0b76-406d-8adc-cd2492947605', 'Dynah Swayland', '[email protected]', '121-595-8119', '1631 Novick Plaza', 'Chenggang', '54321', 'California', 'China'),
('d98c23f2-f40f-424d-99aa-226fdd804143', 'Luise Gilbey', '[email protected]', '385-959-5133', '278 Debra Pass', 'Matsumoto', '996-0051', 'New York', 'Japan');
GO
INSERT INTO Supplier (Id, Name)
VALUES
('cffde204-6701-4a11-8e5c-4960c4b6196e', 'Koelpin, Hermiston and Cassin'),
('54bb00c2-80c5-4a3e-8444-bafa40fd22bb', 'Nikolaus, Bogisich and Raynor'),
('dd906347-0a71-4c9c-b3c9-87b82fe585f1', 'Schiller-Kris'),
('831b4fd0-4582-46bb-a7e4-f77a68b9b4b7', 'Boyle-Kunze'),
('3df1c51d-20f6-4b6f-b136-b8cdce21da2f', 'Hahn-Johns'),
('c03f47a4-09b3-435a-85f0-5a5e44f96fe4', 'Aufderhar, Harvey and Lebsack'),
('565eb0ca-0694-4120-b146-7f81d463e026', 'Maggio LLC'),
('6dc09a39-0d0f-4ed5-95a3-4968ea38c053', 'Rolfson-Collins'),
('740cd02a-ba65-46fd-b221-632cb8caefbd', 'Cassin-Kovacek'),
('8c82d245-82a3-4169-a551-6fbfc2d4148d', 'DuBuque, Leannon and Lynch'),
('7df824d2-a766-4a23-8148-fa063ed77c52', 'Ruecker, Brekke and Wunsch'),
('f3c94970-6ae1-49b1-9b1e-aa99cac819ed', 'Mayert-Bechtelar'),
('a3752094-447a-46a9-9a8c-dbe759e6005d', 'Boyer-Feeney'),
('b5792586-9926-42cc-a959-1f16f1551252', 'Carroll-Gulgowski'),
('de607605-84e4-4ee7-86ae-0169242ca9e6', 'Bode Group'),
('8df18dee-b1ba-431f-82c0-2629f50186e4', 'Feil, Satterfield and Schneider'),
('d2607e30-5c5c-49fa-af76-c5026a5c622b', 'Metz, Durgan and Murazik'),
('c322ce52-cb53-4593-bde9-8a2bc74a1545', 'Leffler-Bergstrom'),
('20a72fd8-607b-4d0d-a9d7-6630697ee9b3', 'Price and Sons'),
('3df09d45-f543-412f-a500-d09021b320d5', 'Padberg-Stoltenberg');
GO
INSERT INTO Item (Id, Name, Description, SupplierId)
VALUES
('11ba9ad6-3157-4dbd-8b45-8fe13cff2856', 'Galactic Gamer''s Keyboard', 'High-performance keyboard with RGB lighting, perfect for gaming enthusiasts.', 'cffde204-6701-4a11-8e5c-4960c4b6196e'),
('09a117fc-746a-4659-9160-7a7435e1e7f6', 'Celestial Crystal Necklace', 'Elegant necklace featuring a stunning crystal pendant with celestial charm.', '54bb00c2-80c5-4a3e-8444-bafa40fd22bb'),
('28eafd68-932b-4efd-8628-5d069fcc4b66', 'Starship Command Center Desk', 'Futuristic desk for your command center, designed for space enthusiasts.', 'dd906347-0a71-4c9c-b3c9-87b82fe585f1'),
('91a6400a-08ec-45e2-89fa-8998c59e5ca0', 'Astronaut''s Space Pen', 'Sleek pen inspired by astronauts, perfect for everyday use.', '831b4fd0-4582-46bb-a7e4-f77a68b9b4b7'),
('b81ca761-47bd-45ed-9417-b81fb920e886', 'Saturn''s Rings Smartphone Case', 'Protective case with a mesmerizing image of Saturn''s rings.', '3df1c51d-20f6-4b6f-b136-b8cdce21da2f'),
('568af2f8-7eb2-4086-865b-d0ba3da23027', 'Solar Flare Face Mask', 'Stay safe with a stylish face mask featuring a solar flare design.', 'c03f47a4-09b3-435a-85f0-5a5e44f96fe4'),
('1387b6b6-150f-475b-ba25-cc230989f527', 'Galactic Glassware Set', 'Unique glassware set with cosmic designs for your drinks.', '565eb0ca-0694-4120-b146-7f81d463e026'),
('45562c23-08c1-4346-a353-871098629816', 'Stardust Collectible Figurines', 'Collectible figurines inspired by stardust and galaxies.', '6dc09a39-0d0f-4ed5-95a3-4968ea38c053'),
('794eecb3-7dac-44e6-8bb7-b94b7f6e056e', 'Black Hole Energy Bars', 'Energy bars with a cosmic twist, perfect for on-the-go.', '740cd02a-ba65-46fd-b221-632cb8caefbd'),
('48d65da1-3454-4d91-8062-1b4afdb548b8', 'Cosmic Cruiser Toy', 'Fun toy featuring a futuristic cosmic cruiser design.', '8c82d245-82a3-4169-a551-6fbfc2d4148d'),
('ea536b89-ed61-462d-994b-156e0ae7254a', 'Space Shuttle Model Kit', 'Build your own space shuttle model for a mini space adventure.', '7df824d2-a766-4a23-8148-fa063ed77c52'),
('bdc60003-9d52-4a47-98ca-b611ff019eb9', 'Meteor Shower Bath Salts', 'Relaxing bath salts with a soothing meteor shower scent.', 'f3c94970-6ae1-49b1-9b1e-aa99cac819ed'),
('48a56970-3f05-4f71-9595-3dce6486d604', 'Astro Navigator GPS', 'Advanced GPS device with celestial navigation features.', 'a3752094-447a-46a9-9a8c-dbe759e6005d'),
('300d7f86-5934-45cb-8206-bcd1054459a6', 'Galactic Gourmet Cookbook', 'Cookbook filled with cosmic recipes for a culinary journey.', 'b5792586-9926-42cc-a959-1f16f1551252'),
('f6ee163c-4f21-4398-9ed0-65f70d223fd4', 'Moonlight Mocha Coffee', 'Premium coffee blend with a hint of moonlight magic.', 'de607605-84e4-4ee7-86ae-0169242ca9e6'),
('9d90283e-97a1-412f-983e-205f1f122246', 'Celestial Comforter Set', 'Luxurious comforter set with a celestial-themed design.', '8df18dee-b1ba-431f-82c0-2629f50186e4'),
('4226c38c-8022-4f81-ad4a-aa71f469ae4b', 'Astronomy Textbook', 'Comprehensive textbook for budding astronomers.', 'd2607e30-5c5c-49fa-af76-c5026a5c622b'),
('d85c83aa-8723-4799-a83c-84ed495f5e2d', 'Starship Explorer LEGO Set', 'Build your own starship with this exciting LEGO set.', 'c322ce52-cb53-4593-bde9-8a2bc74a1545'),
('9f409516-ee74-462d-acd6-4309db98eea9', 'Solar System Adventure Puzzle', 'Fun puzzle featuring the solar system''s planets.', '20a72fd8-607b-4d0d-a9d7-6630697ee9b3'),
('471eca18-cf5a-45aa-8f42-c92437e808f1', 'Astronomy Lovers'' Tote Bag', 'Stylish tote bag for astronomy enthusiasts.', '3df09d45-f543-412f-a500-d09021b320d5'),
('a0ac4f77-758c-4f80-b413-603cf6710620', 'Galactic Glow-in-the-Dark Stars', 'Decorate your room with these glowing stars.', 'cffde204-6701-4a11-8e5c-4960c4b6196e'),
('33b7d352-fc8e-446c-bc1d-baa5624416f1', 'Constellation Wall Art', 'Elegant wall art featuring stunning constellations.', '54bb00c2-80c5-4a3e-8444-bafa40fd22bb'),
('b4282065-eade-496d-8df8-b84786f4214c', 'Astronaut''s Diary', 'Keep your thoughts and adventures in this astronaut-themed diary.', 'dd906347-0a71-4c9c-b3c9-87b82fe585f1'),
('4fd4eafa-93b3-4418-9e07-18005d44e1b0', 'Meteorite Jewelry Collection', 'Unique jewelry pieces made from real meteorites.', '831b4fd0-4582-46bb-a7e4-f77a68b9b4b7'),
('a8b677a3-86a7-4ca1-9052-dbc59bf85585', 'Rocket Launch Poster', 'Poster capturing the excitement of rocket launches.', '3df1c51d-20f6-4b6f-b136-b8cdce21da2f'),
('70d14c48-af10-4fb0-9ed4-d39a6079e3f2', 'Space Adventure Storybook', 'Children''s storybook filled with space adventures.', 'c03f47a4-09b3-435a-85f0-5a5e44f96fe4'),
('a4dde8eb-7cae-40ef-9fe1-fd4406e11ef4', 'Astro Explorer Action Figure', 'Collectible action figure of an intrepid space explorer.', '565eb0ca-0694-4120-b146-7f81d463e026'),
('efbc7c5b-cb74-49f0-b64f-15527dd11d1d', 'Interstellar Scented Soap', 'Luxurious scented soap inspired by interstellar travels.', '6dc09a39-0d0f-4ed5-95a3-4968ea38c053'),
('26d61a7b-015c-4223-bc35-d817afe4ecda', 'Cosmic Kaleidoscope', 'Kaleidoscope with cosmic patterns for endless wonder.', '740cd02a-ba65-46fd-b221-632cb8caefbd'),
('dfea3129-8f09-4fb6-815b-c042e2627427', 'Rocketship Night Light', 'Adorable night light shaped like a rocketship.', '8c82d245-82a3-4169-a551-6fbfc2d4148d'),
('4967cdb8-ee28-43af-8a99-f66f848eedbf', 'Space Adventure Backpack', 'Cool backpack for young space adventurers.', '7df824d2-a766-4a23-8148-fa063ed77c52'),
('f8cc4337-7d95-4f3e-b561-e802c90fef8c', 'Celestial Coffee Mug', 'Elegant coffee mug with celestial designs.', 'f3c94970-6ae1-49b1-9b1e-aa99cac819ed'),
('f3ee4a81-eca7-41f3-aa4f-cd4eeda6a0ed', 'Starship Commander Cap', 'Stylish cap for aspiring starship commanders.', 'a3752094-447a-46a9-9a8c-dbe759e6005d'),
('7db2d05d-cbe7-410a-ba6a-24eb5293ccc1', 'Astronomy Calendar', 'Beautiful calendar featuring celestial imagery.', 'b5792586-9926-42cc-a959-1f16f1551252'),
('96b65948-d294-4fcf-bbfb-fde55ff58170', 'Galactic Gourmet Apron', 'Apron for the cosmic chef in your life.', 'de607605-84e4-4ee7-86ae-0169242ca9e6'),
('de8f84ff-e41c-4803-a5a8-b1b888298767', 'Rocketship Wall Clock', 'Unique wall clock shaped like a rocketship.', '8df18dee-b1ba-431f-82c0-2629f50186e4'),
('bc5e3e1d-0ab7-4f43-a163-1ddf0e2dd641', 'Space Adventure Notebook', 'Notebook with cosmic cover designs for your ideas.', 'd2607e30-5c5c-49fa-af76-c5026a5c622b'),
('2f04bbf4-9d65-4127-b0fe-bd2eff05ceea', 'Stardust Planner', 'Stylish planner with stardust-inspired motifs.', 'c322ce52-cb53-4593-bde9-8a2bc74a1545'),
('44b677fe-9f58-48df-8932-78e00b99d705', 'Meteor Shower Wall Art', 'Artwork capturing the beauty of a meteor shower.', '20a72fd8-607b-4d0d-a9d7-6630697ee9b3'),
('cdfa62bf-afb0-4a50-9e2f-96301c5555f2', 'Astronomer''s Telescope', 'High-quality telescope for exploring the night sky.', '3df09d45-f543-412f-a500-d09021b320d5'),
('16da42a7-ab2d-4d9a-a4a5-ccfd1ee85bbe', 'Space Odyssey Poster', 'Poster inspired by the epic journey of space exploration.', 'cffde204-6701-4a11-8e5c-4960c4b6196e'),
('9536d737-6621-4072-b4b4-eb6475d8d5b9', 'Astronomy Enthusiast Mug', 'Mug for coffee or tea with celestial designs.', '54bb00c2-80c5-4a3e-8444-bafa40fd22bb'),
('ff651d3f-9cb3-48e0-a0c7-f981ecb4497d', 'Celestial Coasters', 'Set of coasters featuring stunning celestial artwork.', 'dd906347-0a71-4c9c-b3c9-87b82fe585f1'),
('57d23ec2-1a4e-47ce-9188-010ebb7916b7', 'Starry Night Phone Case', 'Stylish phone case with a starry night design.', '831b4fd0-4582-46bb-a7e4-f77a68b9b4b7'),
('32e9add9-9501-49d8-9c40-6634d8563e36', 'Astronomy Enthusiast Mug', 'Mug for coffee or tea with celestial designs.', '3df1c51d-20f6-4b6f-b136-b8cdce21da2f'),
('73db5ac0-7123-4a43-ae36-3cb85bcf68a7', 'Meteor Shower Bath Salts', 'Relaxing bath salts with a soothing meteor shower scent.', 'c03f47a4-09b3-435a-85f0-5a5e44f96fe4'),
('bff2d0ff-3540-45fa-a826-292b90379d12', 'Rocket Fuel Water Bottle', 'Stay hydrated with a rocket fuel-inspired water bottle.', 'f3c94970-6ae1-49b1-9b1e-aa99cac819ed'),
('a0fa4b06-f95f-4869-8579-a2cce4f0ac96', 'Cosmic Canvas Tote', 'Stylish tote bag with cosmic designs for your essentials.', '20a72fd8-607b-4d0d-a9d7-6630697ee9b3'),
('ae50fcb7-0846-4423-bbc7-e11defcab999', 'Solar Flare Face Mask', 'Protective face mask with a stunning solar flare design.', '8df18dee-b1ba-431f-82c0-2629f50186e4'),
('9e186cb6-44ee-4adb-8951-5766277e1ca6', 'AstroBlast Sneakers', 'Trendy sneakers with an astro-inspired design for comfort and style.', 'd2607e30-5c5c-49fa-af76-c5026a5c622b'),
('b6c28ca5-3e94-4caf-81e5-ca4afbebd922', 'Cosmic Commander Jacket', 'Stylish jacket with cosmic flair for space enthusiasts.', 'c322ce52-cb53-4593-bde9-8a2bc74a1545'),
('b991a7b9-8c78-424c-9a92-cc2fb5658c6f', 'Celestial Crystal Earrings', 'Elegant earrings featuring celestial-inspired crystals.', '3df09d45-f543-412f-a500-d09021b320d5'),
('90acad3f-79b9-45e7-a0cd-615d545338a9', 'Galactic Puzzle Collection', 'Collection of puzzles with stunning galactic artwork.', 'cffde204-6701-4a11-8e5c-4960c4b6196e'),
('d6ebbac8-53a9-407f-9694-12847f605938', 'Starship Explorer LEGO Set', 'Build your own starship with this exciting LEGO set.', '54bb00c2-80c5-4a3e-8444-bafa40fd22bb'),
('6622d48f-2502-4e5e-b4dd-05902f5c147f', 'Rocketship Night Light', 'Adorable night light shaped like a rocketship.', 'dd906347-0a71-4c9c-b3c9-87b82fe585f1'),
('df11a5c2-69a0-4dfc-b565-987b1c37701a', 'Cosmic Kaleidoscope', 'Kaleidoscope with cosmic patterns for endless wonder.', '831b4fd0-4582-46bb-a7e4-f77a68b9b4b7'),
('572ab6cc-9428-405d-a1cf-7f44c820b16f', 'Space Odyssey Poster', 'Poster inspired by the epic journey of space exploration.', '3df1c51d-20f6-4b6f-b136-b8cdce21da2f'),
('181f4d0d-e976-45ae-abb2-688da7abe8d3', 'Meteorite Jewelry Collection', 'Unique jewelry pieces made from real meteorites.', 'c03f47a4-09b3-435a-85f0-5a5e44f96fe4'),
('341ee57c-016d-4829-8e52-7b433fbf9778', 'Galactic Gourmet Cookbook', 'Cookbook filled with cosmic recipes for a culinary journey.', 'f3c94970-6ae1-49b1-9b1e-aa99cac819ed'),
('b875f4a5-e9f9-49e6-8ac1-6da5418e97b7', 'Astronomy Lovers'' Tote Bag', 'Stylish tote bag for astronomy enthusiasts.', '20a72fd8-607b-4d0d-a9d7-6630697ee9b3'),
('45f53697-7617-44a6-9a61-199b71ef006b', 'Galactic Glow-in-the-Dark Stars', 'Decorate your room with these glowing stars.', '7df824d2-a766-4a23-8148-fa063ed77c52'),
('779a6dc3-3652-438f-95d7-39a7d5ff9c27', 'Constellation Wall Art', 'Elegant wall art featuring stunning constellations.', '8c82d245-82a3-4169-a551-6fbfc2d4148d'),
('34ff06a9-255f-4df6-a221-aaafdb07b99c', 'Astronaut''s Diary', 'Keep your thoughts and adventures in this astronaut-themed diary.', '6dc09a39-0d0f-4ed5-95a3-4968ea38c053'),
('98cdee69-04f0-486d-9c2d-61dd247f17a6', 'Stardust Collectible Figurines', 'Collectible figurines inspired by stardust and galaxies.', '740cd02a-ba65-46fd-b221-632cb8caefbd'),
('16f44c6f-6df6-4744-bae9-49c5a94eab0e', 'Black Hole Energy Bars', 'Energy bars with a cosmic twist, perfect for on-the-go.', '8df18dee-b1ba-431f-82c0-2629f50186e4'),
('ec3aa6d9-4c73-44f4-92c2-bb4189953e71', 'Cosmic Cruiser Toy', 'Fun toy featuring a futuristic cosmic cruiser design.', 'd2607e30-5c5c-49fa-af76-c5026a5c622b'),
('cb9ac4d8-373a-43d1-bd1e-e0a63c1f122f', 'Space Shuttle Model Kit', 'Build your own space shuttle model for a mini space adventure.', 'c322ce52-cb53-4593-bde9-8a2bc74a1545');