-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsertData.sql
98 lines (95 loc) · 6.11 KB
/
insertData.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
/* populate clients table */
INSERT INTO clients (first_name,surname,address,phone,mobile,email,subscribed) VALUES
("Nomlanga","Simmons","P.O. Box 101, 8611 Elit. St., NSW 9006","0258089701","0456205615","[email protected]","1"),
("Cyrus","Moreno","7130 Egestas. Street, NSW 4714","0202507332","0436141039","[email protected]","1"),
("Anjolie","Estrada","33 Batman Avenue, NSW 7674","0243179835","0414161968","[email protected]","0"),
("Indira","Gilbert","9136 Cras St., VIC 1516","0347220538","0409401558","[email protected]","1"),
("Steven","Lamb","3601 Justo Rd., WA 1590","0854795618","0423805118","[email protected]","0"),
("Jonah","Crawford","796 Consectetuer St., SA 2725","0826227442","0426062795","[email protected]","0"),
("Colin","Douglas","3 Orchard Av., VIC 3312","0336732162","0431875142","[email protected]","0"),
("Kirby","Butler","2557 Sem Road, QLD 7698","0321439992","0722598663","[email protected]","0"),
("James","Parrish","6Tellus Avenue, TAS 7457","0375630640","0436761829","[email protected]","1"),
("Marsden","Carlson","66 Ullamcorper, Rd., QLD 7911","0777802486","0430784851","[email protected]","1"),
("Mufutau","Rivers","4671 Albert Avenue, VIC 6818","0364577183","0473196359","[email protected]","1"),
("Gail","Haynes","2197 Nulla Street, VIC 9088","0370831856","0466303978","[email protected]","1"),
("Dorian","Reeves","279 Alexandra Av., VIC 3037","0342453870","0471191851","[email protected]","1"),
("Cade","Burris","P.O. Box 818, 1413 Eugene Street, NSW 5602","0266557872","0495497437","[email protected]","1"),
("Nasim","Maxwell","7126 Mauris Rd., SA 9763","0164513211","0883580041","[email protected]","0"),
("Winifred","Farrell","594 Posuere Av., WA 6284","0810252632","0447390827","[email protected]","1"),
("Hayley","Farley","357 Albert Rd., VIC 4929","0399309555","0461196684","[email protected]","1"),
("Dexter","Franks","P.O. Box 453, 5335 Nec St., QLD 8980","0788811816","0417966332","[email protected]","0"),
("Lael","Workman","741 Lectus Avenue, QLD 7112","0782325774","0410205256","[email protected]","1"),
("Imogene","Alvarado","71 Laoreet Rd., QLD 6683","0726879408","0451691550","[email protected]","0"),
("Davis","Campbell","7197 Pellentesque Rd., NSW 1926","0281999763","0437189331","[email protected]","0"),
("Allistair","Chan","9467 Amet Rd., NSW 8160","0247335320","0258079618","[email protected]","1");
/* populate products table */
INSERT INTO products (name,purchase_price,sale_price) VALUES
("wedding planner organiser book", "32", "30"),
("invitation cards (per dozen)", "60", "55.95"),
("guest book", "60", "55.75"),
("passport cover", "20", "15.95"),
("reception banquet (per person)", "50", "45"),
("wedding cake", "500", "450"),
("Moet champagne", "100", "75.50"),
("white wine", "30", "28"),
("red wine", "30", "27"),
("spring water", "10", "8.50"),
("bridal dress", "450", "420.95"),
("grooms suit", "300", "273.99"),
("limousine rental (per day)", "600", "550"),
("minibus rental (per day)", "300", "270"),
("wedding photos", "500", "490.95"),
("video recording", "400", "380.85"),
("car decoration ribbon", "10", "9.50"),
("wedding ring pillow", "40", "38.50"),
("wedding signs", "30", "28.50"),
("cake topper", "40", "37.75"),
("wedding cake knife set", "50", "45.80"),
("bouquet", "100", "92.50");
/* populate projects table */
INSERT INTO projects (client_id,name,description,address,quote,other_information) VALUES
(1,"Melbourne Town Hall","The wedding will take place in the Melbourne Town Hall","49 Vulputate St., VIC 3345","12209",""),
(1,"Botanic Garden","The wedding is near the Botanic Garden","2 Ligula. Road, VIC 5652","6431","vegetarian"),
(3,"Sheriton Hotel","At Sheriton Hotel with an approx 500 guests.","64 Ute Road, SA 5668","6386","non-smoker"),
(4,"Sydney Opera House","Near Sydney Opera House. Going to use private yacht.","75 Auctor Rd, NSW 2312","1049",""),
(5,"Lakes Entrance","","89 Vel Rd, VIC 9974","2081","Dont mind spending more money."),
(6,"MCG","Ceremony at the MCG and reception at the Hilton Hotel","67 Mus. St, VIC 9131","19409",""),
(5,"Blue Mountain","Ceremony at Blue Mountain","12 Fusce Ave, NSW 6605","16009","Going to have an overseas holidays 2 days after the wedding."),
(8,"Gold Coast","Reception at Gold Coast","52 Molestie St, QLD 7544","11386",""),
(9,"Dandeong Observatory","The wedding is in Dandeong Observatory","01 Donec Rd, VIC 2249","15313","Need disability access to the venue."),
(10,"Rialto Tower","Reception is at Rialto Tower","31 Libero St, VIC 2040","15646",""),
(11,"China Town","Wedding is at Melbourne China Town","19 Nec Street, VIC 1692","10745","Requested Buddhist ceremony."),
(12,"St Kilda Beach","Wedding ceremony is at St Kilda Beach.","58 Laoreet Ave, VIC 3291","9343","Prefer British pop music."),
(13,"Lorne","Reception at Lorne. Expected ~20 guests","35 Facilisis Rd, VIC 9470","6351",""),
(14,"Mornington Peninsula","Wedding at Rosebud in Mornington Peninsula","9 Vel Avenue, VIC 7620","0797",""),
(15,"Taronga Zoo","Wedding at Taronga Zoo as the bride works there.","18 Erat. Rd, NSW 1890","6326","Needs hot meals"),
(16,"Coolangatta","Wedding ceremony at Coolangatta","76 Dignissim St, QLD 4887","8079",""),
(17,"Mordialloc Beach","Wedding at Mordialloc Beach","36 Nunc St, VIC 9923","9132","They would have their own band performing in the wedding."),
(18,"Hilton Hotel","Ceremony at Hilton Hotel","99 Elm Rd, VIC 9658","3773",""),
(17,"Peninsula Hot Spring","Wedding at Peninsula Hot Spring","5 Blandit St, VIC 3791","14491",""),
(20,"St Kilda foreshore","Simple ceremony at St Kilda foreshore","79 Parturient Av, VIC 7404","12797","LGBT couple."),
(13,"Horsham","Wedding at a Horsham homestead","90 Viverra. St, VIC 6380","13100","");
/* populate categories_products table */
INSERT INTO categories_products (category_id, product_id) VALUES
(1,1),
(1,2),
(1,3),
(1,4),
(2,5),
(2,6),
(3,7),
(3,8),
(3,9),
(3,10),
(4,11),
(4,12),
(5,13),
(5,14),
(6,15),
(6,16),
(7,17),
(7,18),
(7,19),
(7,20),
(7,21),
(7,22);