-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathpropertyWebsiteDBData.sql
82 lines (81 loc) · 4.99 KB
/
propertyWebsiteDBData.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
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
USE `mydb` ;
INSERT INTO `Properties` (`propertyLocation`, `propertyName`, `capacity`, `rating`, `ammenitiesID`, `perNightPrice`, `propertyType`) VALUES
('Barcelona', 'Modernist Apartment', 4, 4.5, 1, 200.00, 'apartment'),
('Paris', 'Champs-Élysées Studio', 2, 3.5, 2, 150.00, 'apartment'),
('Rome', 'Trastevere Townhouse', 6, 4, 1, 400.00, 'house'),
('Berlin', 'Brandenburg Gate Apartment', 3, 4, 1, 250.00, 'apartment'),
('Amsterdam', 'Canal View House', 8, 4.5, 1, 600.00, 'house'),
('Vienna', 'Belvedere Palace Suite', 2, 5, 2, 300.00, 'hotel'),
('Florence', 'Duomo View Apartment', 4, 4, 1, 225.00, 'apartment'),
('Dublin', 'Temple Bar Loft', 2, 4, 2, 175.00, 'apartment'),
('Athens', 'Acropolis View Hotel', 2, 4.5, 1, 175.00, 'hotel'),
('Madrid', 'Gran Vía Apartment', 4, 4, 2, 200.00, 'apartment'),
('Venice', 'Canal-Side Penthouse', 2, 4, 1, 300.00, 'apartment'),
('Paris', 'Montmartre Studio', 2, 3, 2, 100.00, 'apartment'),
('Barcelona', 'Gothic Quarter Penthouse', 4, 4, 1, 350.00, 'apartment'),
('Rome', 'Villa Borghese House', 6, 4.5, 1, 500.00, 'house'),
('Berlin', 'Kreuzberg Loft', 2, 4, 2, 125.00, 'apartment'),
('Amsterdam', 'Jordaan Apartment', 3, 4, 1, 175.00, 'apartment'),
('Vienna', 'Schönbrunn Palace Suite', 2, 5, 2, 350.00, 'hotel'),
('Florence', 'Oltrarno Studio', 2, 3.5, 1, 125.00, 'apartment'),
('Dublin', 'Georgian Townhouse', 6, 4.5, 1, 400.00, 'house'),
('Athens', 'Plaka Guesthouse', 2, 4, 1, 150.00, 'hotel'),
('Madrid', 'Retiro Park Apartment', 3, 4.5, 1, 250.00, 'apartment'),
('Barcelona', 'Eixample Apartment', 4, 4, 1, 150, 'apartment'),
('Rome', 'Trastevere Studio', 2, 3.5, 2, 80, 'apartment'),
('Amsterdam', 'Canal View House', 6, 4, 1, 300, 'house'),
('London', 'South Bank Hotel', 2, 4.5, 2, 220, 'hotel'),
('Berlin', 'Prenzlauer Berg Loft', 2, 4, 1, 120, 'apartment'),
('Vienna', 'City Center Apartment', 3, 4.5, 1, 180, 'apartment'),
('Paris', 'Montmartre View Apartment', 4, 4, 2, 250, 'apartment'),
('Barcelona', 'Sagrada Familia Hotel', 2, 3, 1, 90, 'hotel'),
('Florence', 'Duomo View Apartment', 3, 4.5, 2, 220, 'apartment'),
('Rome', 'Colosseum View Hotel', 2, 5, 1, 300, 'hotel'),
('Vienna', 'Belvedere Garden Apartment', 2, 4, 1, 110, 'apartment'),
('Madrid', 'Retiro Park Apartment', 6, 3.5, 2, 160, 'apartment'),
('Budapest', 'Danube River View Apartment', 4, 4, 1, 200, 'apartment'),
('Paris', 'Latin Quarter Hotel', 2, 3.5, 1, 130, 'hotel'),
('Barcelona', 'Gothic Quarter House', 6, 4, 2, 350, 'house'),
('London', 'Hyde Park View Apartment', 4, 4.5, 2, 280, 'apartment'),
('Vienna', 'Stephansplatz Hotel', 2, 4, 1, 180, 'hotel'),
('Rome', 'Navona Square Apartment', 2, 4, 2, 150, 'apartment'),
('Amsterdam', 'Jordaan Houseboat', 2, 4.5, 1, 200, 'house'),
('Paris', 'Marais Apartment', 4, 4, 1, 220, 'apartment'),
('Berlin', 'Friedrichshain Loft', 2, 3.5, 2, 100, 'apartment'),
('Barcelona', 'Barceloneta Beach House', 6, 5, 1, 400, 'house'),
('Budapest', 'Castle District Apartment', 2, 4, 2, 100, 'apartment'),
('Rome', 'Villa Borghese View Hotel', 4, 4.5, 1, 300, 'hotel'),
('Paris', 'Champs-Élysées Apartment', 2, 4, 2, 200, 'apartment'),
('Barcelona', 'Modernist Apartment', 4, 4.5, 2, 180, 'apartment'),
('Rome', 'Trevi Fountain Suite', 3, 5, 1, 350, 'hotel'),
('Berlin', 'Brandenburg Gate Apartment', 6, 4, 2, 220, 'apartment'),
('Barcelona', 'Gaudi House', 5, 4.5, 2, 320, 'house'),
('Amsterdam', 'Canal View Loft', 2, 4, 1, 150, 'apartment'),
('Vienna', 'Imperial Palace Suite', 3, 5, 1, 400, 'hotel'),
('Venice', 'Grand Canal Apartment', 4, 4, 2, 300, 'apartment'),
('Dublin', 'Temple Bar Studio', 2, 3.5, 1, 120, 'apartment'),
('Lisbon', 'Alfama House', 6, 4, 2, 180, 'house'),
('Paris', 'Montmartre View Apartment', 2, 4, 1, 250, 'apartment'),
('Paris', 'Champs-Elysees Apartment', 4, 4.5, 2, 350, 'apartment'),
('Madrid', 'Puerta del Sol Studio', 2, 4, 1, 100, 'apartment'),
('Barcelona', 'Casa Batllo Penthouse', 6, 5, 2, 500, 'apartment'),
('Budapest', 'Danube View Apartment', 4, 4, 1, 200, 'apartment'),
('Rome', 'Colosseum Suite', 3, 4.5, 1, 300, 'hotel'),
('Vienna', 'Schonbrunn Palace Apartment', 2, 3.5, 1, 180, 'apartment'),
('Amsterdam', 'Red Light District Loft', 2, 3, 1, 120, 'apartment'),
('Barcelona', 'La Sagrada Familia Villa', 8, 5, 2, 700, 'house'),
('Dublin', 'Georgian House', 6, 4, 2, 250, 'house'),
('Berlin', 'Kreuzberg Loft', 2, 4, 1, 150, 'apartment'),
('Paris', 'Eiffel Tower Suite', 2, 5, 1, 500, 'hotel'),
('Venice', 'Rialto Bridge Apartment', 4, 4, 2, 280, 'apartment'),
('Rome', 'Villa Borghese House', 6, 4.5, 2, 450, 'house'),
('Lisbon', 'Bairro Alto Apartment', 3, 4, 1, 120, 'apartment'),
('Madrid', 'Retiro Park Villa', 10, 5, 2, 1200, 'house'),
('Barcelona', 'Gothic Quarter Loft', 2, 4, 1, 100, 'apartment'),
('Vienna', 'Belvedere Palace Suite', 3, 4.5, 1, 280, 'hotel'),
('Budapest', 'Buda Castle Apartment', 5, 4, 2, 320, 'apartment'),
('Amsterdam', 'Jordaan Houseboat', 2, 4, 2, 200, 'house'),
('Paris', 'Opera Garnier Apartment', 6, 4.5, 1, 400, 'apartment');