-- Dunkeld Country & Equestrian Estate map seed for hotel_id=1
-- Run after uploading v4, or upload the map once in Admin > Interactive Resort Map.
INSERT INTO resort_maps (hotel_id,map_file,file_type,title,status)
SELECT 1,'uploads/maps/dunkeld-resort-map.jpg','image','Dunkeld Country & Equestrian Estate','active'
WHERE NOT EXISTS (SELECT 1 FROM resort_maps WHERE hotel_id=1 AND map_file='uploads/maps/dunkeld-resort-map.jpg');

SET @map_id := (SELECT id FROM resort_maps WHERE hotel_id=1 AND map_file='uploads/maps/dunkeld-resort-map.jpg' ORDER BY id DESC LIMIT 1);
DELETE FROM resort_map_points WHERE map_id=@map_id;
INSERT INTO resort_map_points (hotel_id,map_id,title,description,icon,x_percent,y_percent,target_link,category,status,sort_order) VALUES
(1,@map_id,'Main Entrance','Main entrance from Gravel Road.','location-dot',9.4,87.2,'','Entrance','active',1),
(1,@map_id,'Hotel Rooms','Hotel room area on the western side of the estate.','bed',18.2,55.0,'rooms.php?id=1','Accommodation','active',2),
(1,@map_id,'House','House area near the western ponds.','house',14.6,72.5,'','Accommodation','active',3),
(1,@map_id,'Country Cottage','Country Cottage near the central lake area.','house',37.2,58.0,'','Accommodation','active',4),
(1,@map_id,'Lakeview Chalet','Lakeview Chalet.','house',43.8,48.5,'','Accommodation','active',5),
(1,@map_id,'Country Manor','Country Manor accommodation wing.','building',60.6,70.2,'rooms.php?id=1','Accommodation','active',6),
(1,@map_id,'THC Units','THC Units beside Country Manor.','building',55.0,62.0,'rooms.php?id=1','Accommodation','active',7),
(1,@map_id,'Indoor Heated Pool','Indoor heated pool and putt-putt area.','person-swimming',51.6,78.0,'','Leisure','active',8),
(1,@map_id,'Tennis Courts','Tennis courts near Wilde Eend.','table-tennis-paddle-ball',39.0,79.2,'','Leisure','active',9),
(1,@map_id,'Equestrian Main Gate','Main equestrian access gate.','horse',78.8,87.5,'','Equestrian','active',10),
(1,@map_id,'Stables','Equestrian stables.','horse',85.5,50.0,'','Equestrian','active',11),
(1,@map_id,'Forest Activity Area','Forest/activity area shown at the north of the estate.','tree',58.0,18.0,'','Activities','active',12);