-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `fit3048_mie`
--

-- --------------------------------------------------------

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo_url` text NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `name`, `logo_url`, `is_visible`, `created`, `modified`) VALUES
(1, 'Crown Weddings', 'clients/1f23622c-bc47-4d20-bbe1-31ae8c793662.png', 1, '2025-08-17 15:33:46', '2025-08-17 15:33:46'),
(2, 'Leonda By The Yarra', 'clients/509d9d5f-f004-4b10-ac76-6c6337aa80b4.png', 1, '2025-08-17 15:33:54', '2025-08-17 15:33:54'),
(3, 'Potters', 'clients/586e1896-f9cc-4a73-a276-98cc854fdcb6.png', 1, '2025-08-17 15:34:02', '2025-08-17 15:34:02'),
(4, 'The Brighton Savoy', 'clients/6932b5ce-86af-44f7-a46c-7e85b3e534ad.png', 1, '2025-08-17 15:34:41', '2025-08-17 15:34:41'),
(5, 'Mercedes Benz', 'clients/4744af93-49b3-44d0-81e8-5b84548015c2.png', 1, '2025-08-17 15:34:56', '2025-08-17 15:34:56'),
(6, 'Richmond', 'clients/afadc8d8-a600-490a-a482-3bff1404f256.png', 1, '2025-08-17 15:35:12', '2025-08-17 15:35:12'),
(7, 'Spring Racing Carnival', 'clients/bb79e3ff-9f38-4b7c-abf4-8d97f58173ad.jpg', 1, '2025-08-17 15:35:31', '2025-08-17 15:35:31'),
(8, 'Loreal Paris', 'clients/e46b31bc-08c1-4a29-b010-667365e06480.png', 1, '2025-08-17 15:35:45', '2025-08-17 15:35:45'),
(9, 'Boost', 'clients/eb8faebf-9225-4ff5-9747-a84113636e61.png', 1, '2025-08-17 15:35:56', '2025-08-17 15:35:56'),
(10, 'Showtime Event Group', 'clients/769c8b23-d2f8-4066-88c4-f3aa084cd615.png', 1, '2025-08-17 15:36:11', '2025-08-17 15:36:11');

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--
CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `company_name` varchar(50) DEFAULT NULL,
  `event_date` date DEFAULT NULL,
  `event_venue_suburb` varchar(255) DEFAULT NULL,
  `event_starttime` time DEFAULT NULL,
  `event_endtime` time DEFAULT NULL,
  `message` text NOT NULL,
  `reply_status` tinyint(1) NOT NULL DEFAULT 0,
  `submission_datetime` datetime NOT NULL DEFAULT current_timestamp(),
  `preferred_contact` varchar(20) NOT NULL,
  `event_type_id` int(11) DEFAULT NULL,
  `package_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contacts_services`
--
CREATE TABLE `contacts_services` (
  `id` int(11) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `contact_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


-- --------------------------------------------------------
--
-- Table structure for table `contacts_sources`
--

CREATE TABLE `contacts_sources` (
  `id` int(11) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `contact_id` int(11) NOT NULL,
  `source_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


-- --------------------------------------------------------

--
-- Table structure for table `event_types`
--
CREATE TABLE `event_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_types`
--

INSERT INTO `event_types` (`id`, `name`) VALUES
(1, 'Wedding'),
(2, 'Corporate'),
(3, 'Private'),
(4, 'Photobooth'),
(5, 'Projector Hire');

-- --------------------------------------------------------

--
-- Table structure for table `services`
--
CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `title` VARCHAR(255) NOT NULL,     
  `description` VARCHAR(110) NOT NULL,
  `icon_class` VARCHAR(100) NOT NULL,
  `is_visible` TINYINT(1) NOT NULL DEFAULT 0,
  `created` DATETIME NOT NULL DEFAULT current_timestamp(),
  `modified` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `title`, `description`, `icon_class`, `is_visible`) VALUES
(1, 'DJ & MC Services', 'Professional DJ and MC services to keep your event lively and entertaining.', 'fas fa-music', 1),
(2, 'Live Musicians', 'Live musicians to add a unique touch to your event.', 'fas fa-guitar', 1),
(3, 'Photobooth', 'Fun photobooth setups for guests to capture memories.', 'fas fa-camera', 1),
(4, 'Special Effects', 'Wow your guests with spark machines, dry ice, or confetti cannons to add unforgettable moments to your event.', 'fas fa-lightbulb', 1),
(5, 'Lighting & Sound', 'State-of-the-art lighting and sound equipment for the perfect ambiance.', 'fas fa-lightbulb', 1),
(6, 'Custom Playlists', 'Work with us to create a personalized playlist that captures your unique style and keeps the dance floor full all night long.', 'fas fa-music', 1),
(7, 'Flexible Packages', 'Pick and choose services, or create a fully customised package for your needs.', 'fas fa-gift', 1),
(8, 'Full Event Support', 'Delivery, setup, pack-down, and on-site technical assistance included.', 'fas fa-lightbulb', 1),
(9, 'Projector & AV Services', 'Crystal-clear projectors and professional audio-visual equipment for speeches, slideshows, and special presentations that enhance your event.', 'fas fa-video', 1),
(10, 'An open booth', 'Can accommodate multiple guests at once for group photos.', 'fas fa-door-open', 1),
(11, 'Delivery & Setup', 'Our team arrives approx an hour early for delivery, setup, and backup support.', 'fas fa-truck', 1),
(12, 'Unlimited Prints', 'High-quality prints for guests to enjoy during operating time.', 'fas fa-print', 1),
(13, 'Prop Box', 'A prop box full of items for added entertainment and fun photos.', 'fas fa-box-open', 1),
(14, 'Customizable Photo Strip', 'Artwork design included at no extra fee by our design team OR BYO artwork.', 'fas fa-palette', 1),
(15, 'Photo Strips for Every Guest', 'Ensuring all guests leave with a memorable keepsake.', 'fas fa-user', 1),
(16, 'Online Sharing', 'Convenient sharing of photos post-event through our online gallery.', 'fas fa-share-alt', 1),
(17, 'Color or B&W Prints', 'Guests can choose between color and black & white instant prints.', 'fas fa-adjust', 1),
(18, 'Professional Attendant', 'A dedicated attendant ensures an enjoyable and smooth photo experience.', 'fas fa-user-tie', 1),
(19, 'Bright Projectors', 'Our high-lumen projectors work perfectly even in bright daylight conditions, with adjustable positioning to fit any wall or screen in your venue.', 'fas fa-video', 1),
(20, 'Ultra-Close Projectors', 'Special projectors that can sit close to the wall while still creating huge images, perfect for tight spaces or when you need equipment out of the way.', 'fas fa-compress', 1),
(21, 'Professional Screens', 'Choose from 2-metre screens up to custom sizes, all made with premium materials to ensure your logos, family photos, or same-day wedding videos look amazing.', 'fas fa-desktop', 1),
(22, '60-Inch TV on Stand', 'Our professional TV mounted on a sturdy truss delivers bright, crystal-clear images in any lighting condition, perfect for smaller venues or outdoor events.', 'fas fa-tv', 1),
(23, 'DJ + Visual Package', 'Book our DJ and get free party visuals on screen, with music synced through the projector, custom VJ services, and music video mixing all included.', 'fas fa-music', 1),
(24, 'PLUS!', 'Every rental includes full delivery, setup, pack-down and on-site technical support - we handle everything so you can enjoy your event!', 'fas fa-tools', 1);
-- --------------------------------------------------------

--
-- Table structure for table `event_types_services`
--
CREATE TABLE `event_types_services` (
  `id` int(11) NOT NULL,
  `event_type_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `created` DATETIME NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `event_types_services`
--
INSERT INTO `event_types_services` (`id`, `event_type_id`, `service_id`) VALUES
-- Wedding
(1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),
-- Corporate
(10,2,1),(11,2,3),(12,2,5),(13,2,7),(14,2,8),(15,2,9),
-- Private
(16,3,1),(17,3,3),(18,3,5),(19,3,7),(20,3,8),(21,3,9),
-- Photobooth
(22,4,10), (23,4,11), (24,4,12), (25,4,13), (26,4,14), (27,4,15), (28,4,16), (29,4,17), (30,4,18),
-- Projector Hire
(31,5,19), (32,5,20), (33,5,21), (34,5,22), (35,5,23), (36,5,24);

--
-- Table structure for table `packages`
--
CREATE TABLE `packages` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(55) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `packages`
--
INSERT INTO `packages` (`id`, `name`, `description`, `price`, `is_visible`) VALUES
(1, 'Essential Package', 'DJ, MC, Sound & Ceremony', 1200.00, 1),
(2, 'Premium Package', '+ Lighting, Photo Booth & AV', 2500.00, 1),
(3, 'Luxury Package', '+ Live Musicians & VIP Service', 4000.00, 1);

-- --------------------------------------------------------

--
-- Table structure for table `packages_services`
--
CREATE TABLE `packages_services` (
  `id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `created` DATETIME NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `packages_services`
--
INSERT INTO `packages_services` (`id`, `package_id`, `service_id`) VALUES
-- Essential Package
(1,1,1),(2,1,5),(3,1,8),
-- Premium Package
(4,2,1),(5,2,3),(6,2,5),(7,2,7),(8,2,8),(9,2,9),
-- Luxury Package
(10,3,1),(11,3,2),(12,3,3),(13,3,4),(14,3,5),(15,3,6),(16,3,7),(17,3,8),(18,3,9);

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL,
  `question` varchar(255) NOT NULL,
  `answer` varchar(255) NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `is_visible`) VALUES
(1, 'What services do you offer?', 'We offer DJ and MC services, live musicians, photobooth, special effects such as fireworks and dry ice for your first dance, and other interactive entertainment options.', 1),
(2, 'What types of events do you provide entertainment for?', 'We specialize in providing entertainment for weddings, but we also provide entertainment for corporate events, private parties, and other special occasions.', 1),
(3, 'Do you have a backup plan in case of equipment failure?', 'Yes, we have backup equipment on hand in case of any unexpected equipment failure.', 1),
(4, 'Do you have insurance?', 'Yes, we carry liability insurance for all of our services.', 1),
(5, 'What is the cancellation policy?', 'Our cancellation policy is detailed in our contract. Generally, cancellations made with less than two weeks notice may result in a loss of deposit, and cancellations within 48 hours will result in full payment.', 1),
(6, 'How do I book your services?', 'You can book our services by contacting us through our website, calling us on the phone, or by emailing us. We will be happy to schedule a consultation to discuss your entertainment needs.', 1),
(7, 'Are your prices negotiable?', 'We have competitive pricing and our services are customizable, so you can tailor your package to suit your needs and budget. We are open to discussing any specific needs or requirements you may have.', 1),
(8, 'Do you have a planning meeting before the event?', 'Yes, we offer a pre-event planning meeting to ensure that we understand your vision and preferences for your special day.', 1),
(9, 'Do you provide lighting and sound equipment?', 'Yes, all of our packages include state-of-the-art lighting, speakers, and microphones.', 1),
(10, 'Can you tailor the entertainment to fit our style?', 'Yes, we pride ourselves on our ability to tailor the music/entertainment package to reflect your own style and preferences.', 1);
-- --------------------------------------------------------

--
-- Table structure for table `sources`
--

CREATE TABLE `sources` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sources`
--

INSERT INTO `sources` (`id`, `name`, `created`, `modified`) VALUES
(1, 'Facebook', '2025-08-17 13:06:51', '2025-08-17 13:06:51'),
(2, 'Google', '2025-08-17 13:06:55', '2025-08-17 13:06:55'),
(3, 'Instagram', '2025-08-17 13:07:03', '2025-08-17 13:07:03'),
(4, 'Referral', '2025-08-17 13:07:08', '2025-08-17 13:07:08');

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `client_name` varchar(255) NOT NULL,
  `video_url` varchar(255) NOT NULL,
  `quote` varchar(255) NOT NULL,
  `rating` int(1) NOT NULL DEFAULT 5,
  `is_visible` tinyint(1) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonials`
--
INSERT INTO `testimonials` (`id`, `client_name`, `video_url`, `quote`, `rating`, `is_visible`) VALUES
(1, 'Crown Weddings Bride', 'https://www.youtube.com/embed/1Inu8z_3Ssw', 'Every single guest was on the dance floor—David made our wedding unforgettable!', 5, 1),
(2, 'Leonda Couple', 'https://www.youtube.com/embed/xaEhI1remQ4', 'The dance floor was packed all night—our guests said it was the best wedding they’ve ever been to.', 5, 1),
(3, 'Independent Bride', 'https://www.youtube.com/embed/6PUEfoAA33Y', 'David planned everything seamlessly, from live musicians to lighting—he made our day truly spectacular.', 5, 1),
(4, 'Brighton Savoy Couple', 'https://www.youtube.com/embed/ppuibd6a9K0', 'David made our wedding night absolutely perfect—an amazing party we’ll never forget.', 5, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `photobooth_accessories`
--
CREATE TABLE photobooth_accessories (
  `id` int(11) NOT NULL,
  `name` VARCHAR(100) NOT NULL,  
  `description` VARCHAR(100) NOT NULL,
  `image_url` TEXT DEFAULT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 0,      
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
);

-- Dumping data for table `photobooth_accessories`
INSERT INTO `photobooth_accessories` (`id`, `name`, `description`, `image_url`, `is_visible`) VALUES
(1, 'Backdrops', 'Pick from a wide range of backdrops to match your event’s theme.', 'photobooth/accessory_68cbe79107ddd4.93797989.jpg', 1),
(2, 'Fun Props Collection', 'An extensive collection of props to make your photos hilarious and memorable', 'photobooth/accessory_68cbdbb04805a6.74826984.jpg', 1),
(3, 'Photo Strips', 'Classic vertical photo strip layouts that guests love to take home', 'photobooth/accessory_68cbdbc3151d93.68008566.jpg', 1);

--
-- Table structure for table `photobooth_items`
--
CREATE TABLE photobooth_items (
  `id` int(11) NOT NULL,
  `name` VARCHAR(100) NOT NULL,  
  `description` VARCHAR(100) DEFAULT NULL,
  `image_url` TEXT NOT NULL,
  `is_visible` tinyint(1) NOT NULL DEFAULT 0,   
  `photobooth_accessory_id` int(11) NOT NULL,   
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
);

--
-- Dumping data for table `photobooth_items`
--
INSERT INTO `photobooth_items` (`id`, `name`, `description`, `image_url`, `is_visible`, `photobooth_accessory_id`, `created`, `modified`) VALUES
(1, 'Gold', '', 'photobooth_items/item_68cbde39458df5.67000121.jpg', 1, 1, '2025-09-18 20:26:01', '2025-09-18 20:26:01'),
(8, 'Silver', '', 'photobooth_items/item_68cbee55092cc2.78461505.jpg', 1, 1, '2025-09-18 21:34:45', '2025-09-18 21:34:48'),
(9, 'Red', '', 'photobooth_items/item_68cbee629a2318.47057978.jpg', 1, 1, '2025-09-18 21:34:58', '2025-09-18 21:35:03'),
(10, 'Christmas', '', 'photobooth_items/item_68cbee92b0c429.37110870.jpg', 1, 1, '2025-09-18 21:35:46', '2025-09-18 21:35:46'),
(11, 'Festive Lights', '', 'photobooth_items/item_68cbeea2723f22.27620075.jpg', 1, 1, '2025-09-18 21:36:02', '2025-09-18 21:36:02'),
(12, 'Wooden', '', 'photobooth_items/item_68cbeeae0bf867.80110658.jpg', 1, 1, '2025-09-18 21:36:14', '2025-09-18 21:36:14'),
(14, 'Floral Paradise', '', 'photobooth_items/item_68cbeedfada145.32848436.jpg', 1, 1, '2025-09-18 21:37:03', '2025-09-18 21:37:03'),
(15, 'Blossom', '', 'photobooth_items/item_68cbeeeb1f4b69.71156150.jpg', 1, 1, '2025-09-18 21:37:15', '2025-09-18 21:37:15'),
(16, 'Glossy Purple', '', 'photobooth_items/item_68cbeef9a852e8.89114576.jpg', 1, 1, '2025-09-18 21:37:29', '2025-09-18 21:37:29'),
(17, 'Orange', '', 'photobooth_items/item_68cbef04ed5af4.43526490.jpg', 1, 1, '2025-09-18 21:37:41', '2025-09-18 21:37:41'),
(18, 'Rainbow Blocks', '', 'photobooth_items/item_68cbef14b893c5.43486716.jpg', 1, 1, '2025-09-18 21:37:56', '2025-09-18 21:37:56'),
(19, 'Jungle', '', 'photobooth_items/item_68cbef20906138.73062084.jpg', 1, 1, '2025-09-18 21:38:08', '2025-09-18 21:38:08'),
(20, 'Graduations', 'Playful signs and fun props to make your school celebration unforgettable!', 'photobooth_items/item_68cbef457eb892.20496586.png', 1, 2, '2025-09-18 21:38:45', '2025-09-18 21:38:45'),
(21, 'Party Masks', 'Colorful masks, mustaches, and character pieces for playful photos', 'photobooth_items/item_68cbef57314829.68478153.jpg', 1, 2, '2025-09-18 21:39:03', '2025-09-18 21:39:03'),
(22, 'Speech Bubbles', 'Custom signs, speech bubbles, and message boards for interactive photos', 'photobooth_items/item_68cbef687d6ab1.99162750.png', 1, 2, '2025-09-18 21:39:20', '2025-09-18 21:39:20'),
(23, 'Wedding Props', 'Fun and quirky wedding props!', 'photobooth_items/item_68cbef7b0ef9e5.80671858.png', 1, 2, '2025-09-18 21:39:39', '2025-09-18 21:39:39'),
(24, 'Party Favorites', 'Quirky glasses, bow ties, and playful signs!', 'photobooth_items/item_68cbef8e2013b6.36970680.png', 1, 2, '2025-09-18 21:39:58', '2025-09-18 21:39:58'),
(25, 'Corporate Props', 'Suitable for business events and networking', 'photobooth_items/item_68cbef9fdf89a3.70289650.jpg', 1, 2, '2025-09-18 21:40:15', '2025-09-18 21:40:15'),
(26, 'Wedding Bliss', '', 'photobooth_items/item_68cbefb6dd2f42.51172372.jpg', 1, 3, '2025-09-18 21:40:38', '2025-09-18 21:40:38'),
(27, 'Party Time', '', 'photobooth_items/item_68cbefc8b84ca6.68744506.jpg', 1, 3, '2025-09-18 21:40:56', '2025-09-18 21:40:56'),
(28, 'Corporate Fun', '', 'photobooth_items/item_68cbefd7ad7b63.66487607.jpg', 1, 3, '2025-09-18 21:41:11', '2025-09-18 21:41:11'),
(29, 'Birthday Bash', '', 'photobooth_items/item_68cbefe7653387.99727536.jpg', 1, 3, '2025-09-18 21:41:27', '2025-09-18 21:41:27');
--
-- Indexes for dumped tables
--

--
-- Indexes for table `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_CONTACT_EVENT_TYPE` (`event_type_id`);

--
-- Indexes for table `contacts_sources`
--
ALTER TABLE `contacts_sources`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_contacts_sources` (`contact_id`,`source_id`),
  ADD UNIQUE KEY `uniq_contact_source_pair` (`contact_id`,`source_id`),
  ADD KEY `FK_CONTACT_SOURCES_SOURCES` (`source_id`);


--
-- Indexes for table `event_types`
--
ALTER TABLE `event_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_event_types_name` (`name`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sources`
--
ALTER TABLE `sources`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_services_title` (`title`);

--
-- Indexes for table `event_types_services`
--
ALTER TABLE `event_types_services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_event_types_services` (`event_type_id`,`service_id`),
  ADD KEY `FK_EVENT_TYPES_SERVICES_EVENT_TYPES` (`event_type_id`),
  ADD KEY `FK_EVENT_TYPES_SERVICES_SERVICES` (`service_id`);

--
-- Indexes for table `photobooth_accessories`
--
ALTER TABLE `photobooth_accessories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_photobooth_accessories_name` (`name`);

--
-- Indexes for table `photobooth_items`
--
ALTER TABLE `photobooth_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_PHOTOBOOTH_ITEMS_ACCESSORIES` (`photobooth_accessory_id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_packages_name` (`name`);

-- 
-- Indexes for table `packages_services`
--
ALTER TABLE `packages_services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_packages_services` (`package_id`,`service_id`),
  ADD KEY `FK_PACKAGES_SERVICES_PACKAGES` (`package_id`),
  ADD KEY `FK_PACKAGES_SERVICES_SERVICES` (`service_id`);

--
-- Indexes for table `contacts_services`
--
ALTER TABLE `contacts_services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_contacts_services` (`contact_id`,`service_id`),
  ADD KEY `FK_CONTACT_SERVICES_SERVICES` (`service_id`),
  ADD KEY `FK_CONTACT_SERVICES_CONTACTS` (`contact_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;


--
-- AUTO_INCREMENT for table `event_types`
--
ALTER TABLE `event_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sources`
--
ALTER TABLE `sources`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--

-- 
-- AUTO_INCREMENT for table `contacts_sources`
--
ALTER TABLE `contacts_sources`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `event_types_services`
--
ALTER TABLE `event_types_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `photobooth_accessories`
--
ALTER TABLE `photobooth_accessories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `photobooth_items`
--
ALTER TABLE `photobooth_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `packages_services`
--
ALTER TABLE `packages_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contacts_services`
--
ALTER TABLE `contacts_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

-- Constraints for dumped tables
--

--
-- Constraints for table `contacts`
--
ALTER TABLE `contacts`
  ADD CONSTRAINT `FK_CONTACT_EVENT_TYPE` FOREIGN KEY (`event_type_id`) REFERENCES `event_types` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CONTACT_PACKAGE` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `event_types_services`
--
ALTER TABLE `event_types_services`
  ADD CONSTRAINT `FK_EVENT_TYPES_SERVICES_EVENT_TYPES` FOREIGN KEY (`event_type_id`) REFERENCES `event_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_EVENT_TYPES_SERVICES_SERVICES` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
--
-- Constraints for table `contacts_sources`
--
ALTER TABLE `contacts_sources`
  ADD CONSTRAINT `FK_CONTACT_SOURCES_CONTACTS` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CONTACT_SOURCES_SOURCES` FOREIGN KEY (`source_id`) REFERENCES `sources` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `photobooth_items`
--  
ALTER TABLE `photobooth_items`
  ADD CONSTRAINT `FK_PHOTOBOOTH_ITEMS_ACCESSORIES` FOREIGN KEY (`photobooth_accessory_id`) REFERENCES `photobooth_accessories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `packages_services`
--
ALTER TABLE `packages_services`
  ADD CONSTRAINT `FK_PACKAGES_SERVICES_PACKAGES` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_PACKAGES_SERVICES_SERVICES` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `contacts_services`
--
ALTER TABLE `contacts_services`
  ADD CONSTRAINT `FK_CONTACT_SERVICES_CONTACTS` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_CONTACT_SERVICES_SERVICES` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

CREATE TABLE `content_blocks` (
  `id` int(11) NOT NULL,
  `parent` varchar(128) NOT NULL,
  `slug` varchar(128) NOT NULL,
  `label` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `type` varchar(32) NOT NULL,
  `value` text DEFAULT NULL,
  `previous_value` text DEFAULT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `content_blocks`
--

INSERT INTO `content_blocks` (`id`, `parent`, `slug`, `label`, `description`, `type`, `value`, `previous_value`, `modified`) VALUES
(1, 'global', 'site-description', 'Site Description', 'Main site description shown in browser title bars and SEO meta tags.', 'text', 'DJ Hire Melbourne | Wedding DJ Hire Melbourne | Wedding Bands', NULL, '2025-09-19 10:00:36'),
(2, 'global', 'favicon', 'Favicon', 'Small icon shown in browser tabs and bookmarks.', 'image', 'favicon-mie.png', NULL, '2025-09-19 10:00:36'),
(3, 'global', 'testimonial-reviews-script', 'Reviews Widget Script', '', 'text', 'https://reviewsonmywebsite.com/js/v2/embed.js?id=4a24b3ba631386ba5f4ec3ef018ac9ca', NULL, '2025-09-19 10:00:36'),
(4, 'global', 'testimonial-reviews-token', 'Reviews Widget ROMW Token', '', 'text', 'OgRxvAtFze6jGIj4moBPXgVuzjU20cDFXUGIY28seuDAEqgUoV', NULL, '2025-09-19 10:00:36'),
(5, 'homepage-hero', 'wedding-columns-bg', 'Wedding Columns Background', 'Default background image for the Wedding hero section', 'image', 'img/weddinghp.jpg', NULL, '2025-09-19 10:00:36'),
(6, 'homepage-hero', 'wedding-dj-video', 'Wedding DJ Video', 'Video background for Wedding DJ hero column', 'image', 'video/wedding.mp4', NULL, '2025-09-19 10:00:36'),
(7, 'homepage-hero', 'wedding-dj-title', 'Wedding DJ Title', 'Title for Wedding DJ hero column', 'text', 'Wedding DJ', NULL, '2025-09-19 10:00:36'),
(8, 'homepage-hero', 'wedding-dj-subtitle', 'Wedding DJ Subtitle', 'Subtitle for Wedding DJ hero column', 'text', 'Ceremony to last dance', NULL, '2025-09-19 10:00:36'),
(9, 'homepage-hero', 'corporate-columns-bg', 'Corporate Columns Background', 'Default background image for the Corporate hero section', 'image', 'img/corporatehp.jpg', NULL, '2025-09-19 10:00:36'),
(10, 'homepage-hero', 'corporate-dj-video', 'Corporate DJ Video', 'Video background for Corporate DJ hero column', 'file', 'video/corporate.mp4', NULL, '2025-09-19 10:00:36'),
(11, 'homepage-hero', 'corporate-dj-title', 'Corporate DJ Title', 'Title for Corporate DJ hero column', 'text', 'Corporate DJ', NULL, '2025-09-19 10:00:36'),
(12, 'homepage-hero', 'corporate-dj-subtitle', 'Corporate DJ Subtitle', 'Subtitle for Corporate DJ hero column', 'text', 'Professional & Polished', NULL, '2025-09-19 10:00:36'),
(13, 'homepage-hero', 'private-columns-bg', 'Private Columns Background', 'Default background image for the Private hero section', 'image', 'img/privatehp.jpg', NULL, '2025-09-19 10:00:36'),
(14, 'homepage-hero', 'private-parties-video', 'Private Parties Video', 'Video background for Private Parties hero column', 'file', 'video/private.mp4', NULL, '2025-09-19 10:00:36'),
(15, 'homepage-hero', 'private-parties-title', 'Private Parties Title', 'Title for Private Parties hero column', 'text', 'Private Parties', NULL, '2025-09-19 10:00:36'),
(16, 'homepage-hero', 'private-parties-subtitle', 'Private Parties Subtitle', 'Subtitle for Private Parties hero column', 'text', 'Birthdays & More', NULL, '2025-09-19 10:00:36'),
(17, 'homepage-welcome', 'welcome-image', 'Welcome Section Image', 'Main image in the welcome section', 'image', 'img/djmelb2.jpg', NULL, '2025-09-19 10:00:36'),
(18, 'homepage-welcome', 'welcome-title', 'Welcome Title', 'Main welcome heading on homepage', 'text', 'Welcome to Melbourne Interactive Entertainment!', NULL, '2025-09-19 10:00:36'),
(19, 'homepage-welcome', 'welcome-content', 'Welcome Content', 'Main welcome text content on homepage', 'text', 'Our team have been entertaining clients for over a decade. We provide unforgettable entertainment for weddings, corporate and private events. Our services include DJs or a unique mix of DJs and live musicians, which we call a DJ Band. We apply the perfect combination of enthusiasm and guest engagement that will lift the room\'s energy. Our promise is to take the stress out of planning your event. Our holistic approach includes ensuring your event is seamless from beginning to end. We include bespoke planning and advice along the way as well as dedicated help on the night to help maximise your celebration. Our DJs can play a limitless number of the songs you know and love, whilst the live musicians bring along the interactive, visual and engaging experience of a live band. We\'ll take you and your guests on a musical journey so that each stage of your event has just the right musical style and atmosphere. We are often considered one of the leading DJ hire in Melbourne.', NULL, '2025-09-19 10:00:36'),
(20, 'homepage-welcome', 'welcome-image', 'Welcome Image', 'Image shown in welcome section', 'image', 'img/djmelb2.jpg', NULL, '2025-09-19 10:00:36'),
(21, 'homepage-services', 'photobooth-bg', 'Photobooth Service Image', 'Background image for Photobooth service slide', 'image', 'img/service3.jpg', NULL, '2025-09-19 10:00:36'),
(22, 'homepage-services', 'photobooth-title', 'Photobooth Title', 'Title for Photobooth service', 'text', 'Photobooth', NULL, '2025-09-19 10:00:36'),
(23, 'homepage-services', 'photobooth-subtitle', 'Photobooth Subtitle', 'Subtitle for Photobooth service', 'text', 'Instant prints. Fun props. Share-worthy memories.', NULL, '2025-09-19 10:00:36'),
(24, 'homepage-services', 'projector-bg', 'Projector Hire Service Image', 'Background image for Projector Hire service slide', 'image', 'img/service4.jpg', NULL, '2025-09-19 10:00:36'),
(25, 'homepage-services', 'projector-title', 'Projector Title', 'Title for Projector Hire', 'text', 'Projector Hire', NULL, '2025-09-19 10:00:36'),
(26, 'homepage-services', 'projector-subtitle', 'Projector Subtitle', 'Subtitle for Projector Hire', 'text', 'Crystal-clear visuals for presentations, events, and special moments.', NULL, '2025-09-19 10:00:36'),
(27, 'about-hero', 'about-hero-bg', 'Hero Background Image', 'Main background image for About Us hero section', 'image', 'djservices3.jpg', NULL, '2025-09-19 10:00:36'),
(28, 'about-hero', 'about-hero-title', 'Hero Title', 'Heading text overlay on About Us hero image', 'text', 'ABOUT US', NULL, '2025-09-19 10:00:36'),
(29, 'about-metrics', 'metrics-title', 'Section Title', 'Main heading for Why Clients Trust Us section', 'text', 'Why Clients Trust Us.', NULL, '2025-09-19 10:00:36'),
(30, 'about-metrics', 'metrics-subtitle', 'Section Subtitle', 'Subtitle text under metrics section', 'text', 'From weddings to corporate functions, our proven experience and dedication set the stage for unforgettable celebrations.', NULL, '2025-09-19 10:00:36'),
(31, 'about-metrics', 'metric-1-number', 'Metric 1 Number', 'Number displayed for first metric', 'text', '17+', NULL, '2025-09-19 10:00:36'),
(32, 'about-metrics', 'metric-1-caption', 'Metric 1 Caption', 'Caption displayed for first metric', 'text', 'Years of delivering unforgettable DJ and live entertainment for weddings, corporate events and private parties.', NULL, '2025-09-19 10:00:36'),
(33, 'about-metrics', 'metric-2-number', 'Metric 2 Number', 'Number displayed for second metric', 'text', '2007', NULL, '2025-09-19 10:00:36'),
(34, 'about-metrics', 'metric-2-caption', 'Metric 2 Caption', 'Caption displayed for second metric', 'text', 'Established in Melbourne and proudly entertaining across Victoria and interstate ever since.', NULL, '2025-09-19 10:00:36'),
(35, 'about-metrics', 'metric-3-number', 'Metric 3 Number', 'Number displayed for third metric', 'text', '200+', NULL, '2025-09-19 10:00:36'),
(36, 'about-metrics', 'metric-3-caption', 'Metric 3 Caption', 'Caption displayed for third metric', 'text', 'Glowing 5-star reviews from couples, clients and guests who loved the energy we bring.', NULL, '2025-09-19 10:00:36'),
(37, 'about-metrics', 'metric-4-number', 'Metric 4 Number', 'Number displayed for fourth metric', 'text', '3', NULL, '2025-09-19 10:00:36'),
(38, 'about-metrics', 'metric-4-caption', 'Metric 4 Caption', 'Caption displayed for fourth metric', 'text', 'Dedicated to private celebrations, corporate functions, and unforgettable weddings.', NULL, '2025-09-19 10:00:36'),
(39, 'about-metrics', 'metric-5-number', 'Metric 5 Number', 'Number displayed for fifth metric', 'text', '100%', NULL, '2025-09-19 10:00:36'),
(40, 'about-metrics', 'metric-5-caption', 'Metric 5 Caption', 'Caption displayed for fifth metric', 'text', 'Total dedication from your first enquiry through to the last dance of the night.', NULL, '2025-09-19 10:00:36'),
(41, 'about-success', 'success-title', 'Section Title', 'Main heading for success stories', 'text', 'Client Success Stories', NULL, '2025-09-19 10:00:36'),
(42, 'about-success', 'success-subtitle', 'Section Subtitle', 'Subtitle for success stories section', 'text', 'Real moments, real reactions—see what our clients say.', NULL, '2025-09-19 10:00:36'),
(43, 'faq-hero', 'faq-hero-bg', 'FAQ Background Image', 'Main background image for FAQ hero section', 'image', 'djservices5.jpg', NULL, '2025-09-19 10:00:36'),
(44, 'faq-hero', 'faq-hero-title', 'FAQ Title', 'Heading text overlay on FAQ hero image', 'text', 'Frequently Asked Questions', NULL, '2025-09-19 10:00:36'),
(45, 'wedding-hero', 'wedding-hero-bg', 'Wedding Hero Background Image', 'Main background image for Wedding Services hero section', 'image', 'weddings.jpg', NULL, '2025-09-19 10:00:36'),
(46, 'wedding-hero', 'wedding-hero-title', 'Wedding Hero Title', 'Heading text overlay on Wedding Services hero image', 'text', 'Your Perfect Wedding Day', NULL, '2025-09-19 10:00:36'),
(47, 'wedding-hero', 'wedding-hero-subtitle', 'Wedding Hero Subtitle', 'Subtitle text overlay on Wedding Services hero image', 'text', 'Magical moments, unforgettable weddings — your celebration, your way.', NULL, '2025-09-19 10:00:36'),
(48, 'wedding-why', 'wedding-why-title', 'Why Choose Us Title', 'Main heading for Why Couples Choose Us section', 'text', 'Why Couples Choose Us', NULL, '2025-09-19 10:00:36'),
(49, 'wedding-why', 'wedding-why-subtitle', 'Why Choose Us Subtitle', 'Subtitle for Why Couples Choose Us section', 'text', 'Over 200 five-star reviews and countless magical moments since 2007', NULL, '2025-09-19 10:00:36'),
(50, 'wedding-why', 'wedding-why-feature1-title', 'Feature 1 Title', 'Title for first wedding feature block', 'text', 'Personalized Approach', NULL, '2025-09-19 10:00:36'),
(51, 'wedding-why', 'wedding-why-feature1-text', 'Feature 1 Text', 'Description for first wedding feature block', 'text', 'We work closely with you to understand your vision and create a completely customized entertainment experience.', NULL, '2025-09-19 10:00:36'),
(52, 'wedding-why', 'wedding-why-feature1-icon', 'Feature 1 Icon', 'Font Awesome icon class for first wedding feature', 'text', 'fas fa-heart', NULL, '2025-09-19 10:00:36'),
(53, 'wedding-why', 'wedding-why-feature2-title', 'Feature 2 Title', 'Title for second wedding feature block', 'text', '17+ Years Experience', NULL, '2025-09-19 10:00:36'),
(54, 'wedding-why', 'wedding-why-feature2-text', 'Feature 2 Text', 'Description for second wedding feature block', 'text', 'Since 2007, we\'ve perfected the art of DJ services, ensuring flawless execution on your special day.', NULL, '2025-09-19 10:00:36'),
(55, 'wedding-why', 'wedding-why-feature2-icon', 'Feature 2 Icon', 'Font Awesome icon class for second wedding feature', 'text', 'fas fa-clock', NULL, '2025-09-19 10:00:36'),
(56, 'wedding-why', 'wedding-why-feature3-title', 'Feature 3 Title', 'Title for third wedding feature block', 'text', 'Trusted Professionals', NULL, '2025-09-19 10:00:36'),
(57, 'wedding-why', 'wedding-why-feature3-text', 'Feature 3 Text', 'Description for third wedding feature block', 'text', 'Australia\'s top venues, planners, and couples trust us to deliver exceptional entertainment experiences.', NULL, '2025-09-19 10:00:36'),
(58, 'wedding-why', 'wedding-why-feature3-icon', 'Feature 3 Icon', 'Font Awesome icon class for third wedding feature', 'text', 'fas fa-handshake', NULL, '2025-09-19 10:00:36'),
(59, 'wedding-services', 'wedding-services-title', 'Wedding Services Title', 'Main heading for Wedding Services carousel', 'text', 'Complete Wedding Entertainment', NULL, '2025-09-19 10:00:36'),
(60, 'wedding-services', 'wedding-services-subtitle', 'Wedding Services Subtitle', 'Subtitle under services heading', 'text', 'Everything you need to keep your guests dancing and create lasting memories', NULL, '2025-09-19 10:00:36'),
(61, 'wedding-gallery', 'wedding-gallery-title', 'Wedding Gallery Title', 'Main heading for wedding gallery section', 'text', 'See Your Wedding in Action', NULL, '2025-09-19 10:00:36'),
(62, 'wedding-gallery', 'wedding-gallery-subtitle', 'Wedding Gallery Subtitle', 'Subtitle for wedding gallery section', 'text', 'Real weddings, real celebrations, real magic', NULL, '2025-09-19 10:00:36'),
(63, 'wedding-gallery', 'wedding-gallery-video1', 'Gallery Video 1', 'YouTube embed URL for first wedding gallery video', 'text', 'https://www.youtube.com/embed/8Jrq_9su4mA?si=5qYY4KedavaGQiYO', NULL, '2025-09-19 10:00:36'),
(64, 'wedding-gallery', 'wedding-gallery-video2', 'Gallery Video 2', 'YouTube embed URL for second wedding gallery video', 'text', 'https://www.youtube.com/embed/-i-0uzIKS8E?si=Qih381ioZOPZS71h', NULL, '2025-09-19 10:00:36'),
(65, 'wedding-gallery', 'wedding-gallery-video3', 'Gallery Video 3', 'YouTube embed URL for third wedding gallery video', 'text', 'https://www.youtube.com/embed/lH2BTkTXZEI?si=BZkgVR1sOra2f8uk', NULL, '2025-09-19 10:00:36'),
(66, 'wedding-gallery', 'wedding-gallery-video4', 'Gallery Video 4', 'YouTube embed URL for fourth wedding gallery video', 'text', 'https://www.youtube.com/embed/Bnh0F5shSM4?si=AIjaXDrp9jTyWO_v', NULL, '2025-09-19 10:00:36'),
(67, 'corporate-hero', 'corporate-hero-bg', 'Corporate Hero Background Image', 'Main background image for Corporate DJ hero section', 'image', 'corporate-hero.jpg', NULL, '2025-09-19 10:00:36'),
(68, 'corporate-hero', 'corporate-hero-title', 'Corporate Hero Title', 'Heading text overlay on Corporate DJ hero image', 'text', 'CORPORATE DJ', NULL, '2025-09-19 10:00:36'),
(69, 'corporate-hero', 'corporate-hero-subtitle', 'Corporate Hero Subtitle', 'Subtitle text overlay on Corporate DJ hero image', 'text', 'Tailored DJ & Event for Corporate Experiences', NULL, '2025-09-19 10:00:36'),
(70, 'corporate-why', 'corporate-why-title', 'Section Title', 'Heading for Why Corporates Choose Us section', 'text', 'Why Corporates Choose Us', NULL, '2025-09-19 10:00:36'),
(71, 'corporate-why', 'corporate-why-subtitle', 'Section Subtitle', 'Subtitle for Why Corporates Choose Us section', 'text', 'Over 200 five-star reviews and countless magical moments since 2007', NULL, '2025-09-19 10:00:36'),
(72, 'corporate-why', 'corporate-why-feature1-icon', 'Feature 1 Icon', 'Font Awesome icon class for first corporate feature', 'text', 'fas fa-heart', NULL, '2025-09-19 10:00:36'),
(73, 'corporate-why', 'corporate-why-feature1-title', 'Feature 1 Title', 'Title for first corporate feature block', 'text', 'Personalized Approach', NULL, '2025-09-19 10:00:36'),
(74, 'corporate-why', 'corporate-why-feature1-text', 'Feature 1 Text', 'Description for first corporate feature block', 'text', 'We work closely with you to understand your vision and create a completely customized entertainment experience.', NULL, '2025-09-19 10:00:36'),
(75, 'corporate-why', 'corporate-why-feature2-icon', 'Feature 2 Icon', 'Font Awesome icon class for second corporate feature', 'text', 'fas fa-clock', NULL, '2025-09-19 10:00:36'),
(76, 'corporate-why', 'corporate-why-feature2-title', 'Feature 2 Title', 'Title for second corporate feature block', 'text', '17+ Years Experience', NULL, '2025-09-19 10:00:36'),
(77, 'corporate-why', 'corporate-why-feature2-text', 'Feature 2 Text', 'Description for second corporate feature block', 'text', 'Since 2007, we\'ve perfected the art of DJ services, ensuring flawless execution at every corporate event.', NULL, '2025-09-19 10:00:36'),
(78, 'corporate-why', 'corporate-why-feature3-icon', 'Feature 3 Icon', 'Font Awesome icon class for third corporate feature', 'text', 'fas fa-handshake', NULL, '2025-09-19 10:00:36'),
(79, 'corporate-why', 'corporate-why-feature3-title', 'Feature 3 Title', 'Title for third corporate feature block', 'text', 'Trusted Professionals', NULL, '2025-09-19 10:00:36'),
(80, 'corporate-why', 'corporate-why-feature3-text', 'Feature 3 Text', 'Description for third corporate feature block', 'text', 'Australia\'s top venues, planners, and companies trust us to deliver exceptional entertainment experiences.', NULL, '2025-09-19 10:00:36'),
(81, 'corporate-services', 'corporate-services-title', 'Services Title', 'Main heading for corporate services section', 'text', 'Complete DJ Entertainment', NULL, '2025-09-19 10:00:36'),
(82, 'corporate-services', 'corporate-services-subtitle', 'Services Subtitle', 'Subtitle for corporate services section', 'text', 'Everything you need to energize your event and create lasting memories', NULL, '2025-09-19 10:00:36'),
(83, 'corporate-gallery', 'corporate-gallery-title', 'Gallery Title', 'Main heading for corporate gallery section', 'text', 'See Your Event in Action', NULL, '2025-09-19 10:00:36'),
(84, 'corporate-gallery', 'corporate-gallery-subtitle', 'Gallery Subtitle', 'Subtitle for corporate gallery section', 'text', 'Real corporate events, real celebrations, real impact', NULL, '2025-09-19 10:00:36'),
(85, 'corporate-gallery', 'corporate-gallery-video1', 'Gallery Video 1', 'YouTube embed URL for first corporate gallery video', 'text', 'https://www.youtube.com/embed/TltL4_QlvsA?si=uN47x8TYavgJVGV4', NULL, '2025-09-19 10:00:36'),
(86, 'corporate-gallery', 'corporate-gallery-video2', 'Gallery Video 2', 'YouTube embed URL for second corporate gallery video', 'text', 'https://www.youtube.com/embed/S1C4fHuzPVg?si=h2LfkjjnHmbLrOnG', NULL, '2025-09-19 10:00:36'),
(87, 'corporate-gallery', 'corporate-gallery-video3', 'Gallery Video 3', 'YouTube embed URL for third corporate gallery video', 'text', 'https://www.youtube.com/embed/BwWz4QkBfaE?si=Gto-bIqUl5EE08cX', NULL, '2025-09-19 10:00:36'),
(88, 'corporate-gallery', 'corporate-gallery-video4', 'Gallery Video 4', 'YouTube embed URL for fourth corporate gallery video', 'text', 'https://www.youtube.com/embed/k5W_DlDaGcA?si=zenUaaxjNZN_K6u2', NULL, '2025-09-19 10:00:36'),
(89, 'private-hero', 'private-hero-bg', 'Private Hero Background Image', 'Main background image for Private Event hero section', 'image', 'private-hero.jpg', NULL, '2025-09-19 10:00:36'),
(90, 'private-hero', 'private-hero-title', 'Private Hero Title', 'Heading text overlay on Private Event hero image', 'text', 'Private Event', NULL, '2025-09-19 10:00:36'),
(91, 'private-hero', 'private-hero-subtitle', 'Private Hero Subtitle', 'Subtitle text overlay on Private Event hero image', 'text', 'Crafting the perfect atmosphere for your special occasion', NULL, '2025-09-19 10:00:36'),
(92, 'private-why', 'private-why-title', 'Section Title', 'Heading for Why Customers Choose Us section on private events page', 'text', 'Why Customers Choose Us', NULL, '2025-09-19 10:00:36'),
(93, 'private-why', 'private-why-subtitle', 'Section Subtitle', 'Subtitle for Why Customers Choose Us section on private events page', 'text', 'Over 200 five-star reviews and countless magical moments since 2007', NULL, '2025-09-19 10:00:36'),
(94, 'private-why', 'private-why-feature1-icon', 'Feature 1 Icon', 'Font Awesome icon class for first private event feature', 'text', 'fas fa-heart', NULL, '2025-09-19 10:00:36'),
(95, 'private-why', 'private-why-feature1-title', 'Feature 1 Title', 'Title for first private event feature block', 'text', 'Personalized Approach', NULL, '2025-09-19 10:00:36'),
(96, 'private-why', 'private-why-feature1-text', 'Feature 1 Text', 'Description for first private event feature block', 'text', 'We work closely with you to understand your vision and create a completely customized entertainment experience.', NULL, '2025-09-19 10:00:36'),
(97, 'private-why', 'private-why-feature2-icon', 'Feature 2 Icon', 'Font Awesome icon class for second private event feature', 'text', 'fas fa-clock', NULL, '2025-09-19 10:00:36'),
(98, 'private-why', 'private-why-feature2-title', 'Feature 2 Title', 'Title for second private event feature block', 'text', '17+ Years Experience', NULL, '2025-09-19 10:00:36'),
(99, 'private-why', 'private-why-feature2-text', 'Feature 2 Text', 'Description for second private event feature block', 'text', 'Since 2007, we\'ve perfected the art of DJ services, ensuring flawless execution on your special day.', NULL, '2025-09-19 10:00:36'),
(100, 'private-why', 'private-why-feature3-icon', 'Feature 3 Icon', 'Font Awesome icon class for third private event feature', 'text', 'fas fa-handshake', NULL, '2025-09-19 10:00:36'),
(101, 'private-why', 'private-why-feature3-title', 'Feature 3 Title', 'Title for third private event feature block', 'text', 'Trusted Professionals', NULL, '2025-09-19 10:00:36'),
(102, 'private-why', 'private-why-feature3-text', 'Feature 3 Text', 'Description for third private event feature block', 'text', 'Australia\'s top venues, planners, and clients trust us to deliver exceptional entertainment experiences.', NULL, '2025-09-19 10:00:36'),
(103, 'private-services', 'private-services-title', 'Services Title', 'Main heading for private event services section', 'text', 'Complete DJ Entertainment', NULL, '2025-09-19 10:00:36'),
(104, 'private-services', 'private-services-subtitle', 'Services Subtitle', 'Subtitle for private event services section', 'text', 'Everything you need to keep your guests dancing and create lasting memories', NULL, '2025-09-19 10:00:36'),
(105, 'private-gallery', 'private-gallery-title', 'Gallery Title', 'Main heading for private event gallery section', 'text', 'See Your Event in Action', NULL, '2025-09-19 10:00:36'),
(106, 'private-gallery', 'private-gallery-subtitle', 'Gallery Subtitle', 'Subtitle for private event gallery section', 'text', 'Real private events, real celebrations, real magic', NULL, '2025-09-19 10:00:36'),
(107, 'private-gallery', 'private-gallery-video1', 'Gallery Video 1', 'YouTube embed URL for first private event gallery video', 'text', 'https://www.youtube.com/embed/dFkhO-mWoc4?si=gKI3_bJUPVTaw5-W', NULL, '2025-09-19 10:00:36'),
(108, 'private-gallery', 'private-gallery-video2', 'Gallery Video 2', 'YouTube embed URL for second private event gallery video', 'text', 'https://www.youtube.com/embed/vB-yBgV9rcM?si=0uDrJ6Fp1VX1JY_4', NULL, '2025-09-19 10:00:36'),
(109, 'private-gallery', 'private-gallery-video3', 'Gallery Video 3', 'YouTube embed URL for third private event gallery video', 'text', 'https://www.youtube.com/embed/bSdogZe0dM4?si=lfMuYU4wTUbKglsR', NULL, '2025-09-19 10:00:36'),
(110, 'private-gallery', 'private-gallery-video4', 'Gallery Video 4', 'YouTube embed URL for fourth private event gallery video', 'text', 'https://www.youtube.com/embed/bdwgd1b1QWk?si=eATawCT4dMBAfxAM', NULL, '2025-09-19 10:00:36'),
(111, 'cta-info', 'cta-button-text', 'Consultation Button Text', 'Button text for free consultation call-to-action', 'text', 'Get Your Free Consultation', NULL, '2025-09-19 10:00:36'),
(112, 'cta-info', 'cta-phone', 'CTA Phone Number', 'Contact phone number displayed in CTA section', 'text', '+61 0418 957 154', NULL, '2025-09-19 10:00:36'),
(113, 'cta-info', 'cta-email', 'CTA Email', 'Contact email address displayed in CTA section', 'text', 'info@djband.com.au', NULL, '2025-09-19 10:00:36'),
(114, 'cta-info', 'cta-booking-note', 'CTA Booking Note', 'Small note text displayed under Book Online icon', 'text', 'Free consultation available', NULL, '2025-09-19 10:00:36'),
(115, 'photobooth-hero', 'photobooth-hero-bg', 'Hero Background Image', 'Main background image for Photobooth hero section', 'image', 'photobooth-hero.jpg', NULL, '2025-09-19 10:00:36'),
(116, 'photobooth-hero', 'photobooth-hero-title', 'Hero Title', 'Heading text overlay on Photobooth hero image', 'text', 'Photobooth', NULL, '2025-09-19 10:00:36'),
(117, 'photobooth-hero', 'photobooth-hero-subtitle', 'Hero Subtitle', 'Subtitle text overlay on Photobooth hero image', 'text', 'Create unforgettable memories at your event or celebration', NULL, '2025-09-19 10:00:36'),
(118, 'photobooth-why', 'photobooth-why-title', 'Section Title', 'Main heading for photobooth features section', 'text', 'Your Perfect Photo Booth Experience', NULL, '2025-09-19 10:00:36'),
(119, 'photobooth-why', 'photobooth-why-subtitle', 'Section Subtitle', 'Subtitle for photobooth features section', 'text', 'Perfect for weddings, corporate events, and milestone celebrations', NULL, '2025-09-19 10:00:36'),
(120, 'photobooth-why', 'photobooth-why-feature1-icon', 'Feature 1 Icon', 'Font Awesome icon class for first photobooth feature', 'text', 'fas fa-heart', NULL, '2025-09-19 10:00:36'),
(121, 'photobooth-why', 'photobooth-why-feature1-title', 'Feature 1 Title', 'Title for first photobooth feature block', 'text', 'Beyond the Party', NULL, '2025-09-19 10:00:36'),
(122, 'photobooth-why', 'photobooth-why-feature1-text', 'Feature 1 Text', 'Description for first photobooth feature block', 'text', 'While you focus on your big day, our photo booth keeps guests entertained and sends them home with memorable keepsakes from all those candid moments between dancing and dining', NULL, '2025-09-19 10:00:36'),
(123, 'photobooth-why', 'photobooth-why-feature2-icon', 'Feature 2 Icon', 'Font Awesome icon class for second photobooth feature', 'text', 'fas fa-clock', NULL, '2025-09-19 10:00:36'),
(124, 'photobooth-why', 'photobooth-why-feature2-title', 'Feature 2 Title', 'Title for second photobooth feature block', 'text', 'Perfect for Every Occasion', NULL, '2025-09-19 10:00:36'),
(125, 'photobooth-why', 'photobooth-why-feature2-text', 'Feature 2 Text', 'Description for second photobooth feature block', 'text', 'From intimate celebrations to large-scale public events, our versatile photo booth service adapts to any venue and occasion, bringing fun and memorable experiences to guests of all ages', NULL, '2025-09-19 10:00:36'),
(126, 'photobooth-why', 'photobooth-why-feature3-icon', 'Feature 3 Icon', 'Font Awesome icon class for third photobooth feature', 'text', 'fas fa-handshake', NULL, '2025-09-19 10:00:36'),
(127, 'photobooth-why', 'photobooth-why-feature3-title', 'Feature 3 Title', 'Title for third photobooth feature block', 'text', 'Affordable & Reliable', NULL, '2025-09-19 10:00:36'),
(128, 'photobooth-why', 'photobooth-why-feature3-text', 'Feature 3 Text', 'Description for third photobooth feature block', 'text', 'Quality photo booth entertainment shouldn\'t break your budget. Our reliable service delivers exceptional value without compromising on style or professionalism', NULL, '2025-09-19 10:00:36'),
(129, 'photobooth-services', 'photobooth-services-title', 'Section Title', 'Main heading for photobooth services section', 'text', 'What do we Offer?', NULL, '2025-09-19 10:00:36'),
(130, 'photobooth-services', 'photobooth-services-subtitle', 'Section Subtitle', 'Subtitle for photobooth services section', 'text', 'Everything you need to make your event even more special', NULL, '2025-09-19 10:00:36'),
(131, 'photobooth-standard', 'photobooth-standard-title', 'Section Title', 'Main heading for standard photobooth section', 'text', 'Standard Photobooth', NULL, '2025-09-19 10:00:36'),
(132, 'photobooth-standard', 'photobooth-standard-subtitle', 'Section Subtitle', 'Subtitle for standard photobooth section', 'text', 'Choose from our collection of accessories to match your event\'s theme', NULL, '2025-09-19 10:00:36'),
(133, 'photobooth-mirror', 'photobooth-mirror-title', 'Section Title', 'Main heading for mirror photobooth section', 'text', 'Mirror Photobooth', NULL, '2025-09-19 10:00:36'),
(134, 'photobooth-mirror', 'photobooth-mirror-subtitle', 'Section Subtitle', 'Subtitle for mirror photobooth section', 'text', 'Make Your Wedding Unforgettable', NULL, '2025-09-19 10:00:36'),
(135, 'photobooth-mirror', 'photobooth-mirror-image1', 'Mirror Image 1', 'First image in mirror photobooth carousel', 'image', 'mirror1.jpg', NULL, '2025-09-19 10:00:36'),
(136, 'photobooth-mirror', 'photobooth-mirror-image2', 'Mirror Image 2', 'Second image in mirror photobooth carousel', 'image', 'mirror2.jpg', NULL, '2025-09-19 10:00:36'),
(137, 'photobooth-mirror', 'photobooth-mirror-image3', 'Mirror Image 3', 'Third image in mirror photobooth carousel', 'image', 'mirror3.jpg', NULL, '2025-09-19 10:00:36'),
(138, 'photobooth-mirror', 'photobooth-mirror-image4', 'Mirror Image 4', 'Fourth image in mirror photobooth carousel', 'image', 'mirror4.jpg', NULL, '2025-09-19 10:00:36'),
(139, 'photobooth-mirror', 'photobooth-mirror-image5', 'Mirror Image 5', 'Fifth image in mirror photobooth carousel', 'image', 'mirror5.jpg', NULL, '2025-09-19 10:00:36'),
(140, 'photobooth-mirror', 'photobooth-mirror-description-heading', 'Description Heading', 'Heading for mirror photobooth description section', 'text', 'Why Choose Our Mirror Photobooth?', NULL, '2025-09-19 10:00:36'),
(141, 'photobooth-mirror', 'photobooth-mirror-features', 'Features List', 'HTML list of mirror photobooth features and benefits', 'html', '<ul class=\"features-list\">\n                    <li><strong>Cutting-edge Technology:</strong> State-of-the-art mirror interface that delights guests and creates instant, shareable memories.</li>\n                    <li><strong>Elegant Design:</strong> Modern and stylish setup that complements any wedding or event décor.</li>\n                    <li><strong>Customizable Experience:</strong> Tailor animations, themes, and props to match your event perfectly.</li>\n                </ul>', NULL, '2025-09-19 10:00:36'),
(142, 'photobooth-mirror', 'photobooth-mirror-description', 'Description', 'Main description text for mirror photobooth service', 'html', 'Make your celebration unforgettable with an interactive experience that\'s fun for all ages. Your guests will love the mirror, the photos, and the memories!', NULL, '2025-09-19 10:00:36'),
(143, 'projector-hero', 'projector-hero-bg', 'Hero Background Image', 'Main background image for Projector Hire hero section', 'image', 'service4.jpg', NULL, '2025-09-19 10:00:36'),
(144, 'projector-hero', 'projector-hero-title', 'Hero Title', 'Heading text overlay on Projector Hire hero image', 'text', 'Projector Hire', NULL, '2025-09-19 10:00:36'),
(145, 'projector-hero', 'projector-hero-subtitle', 'Hero Subtitle', 'Subtitle text overlay on Projector Hire hero image', 'text', 'Deserves Perfect Entertainment', NULL, '2025-09-19 10:00:36'),
(146, 'projector-why', 'projector-why-title', 'Section Title', 'Main heading for Why Events Choose Our Projectors section', 'text', 'Why Events Choose Our Projectors', NULL, '2025-09-19 10:00:36'),
(147, 'projector-why', 'projector-why-subtitle', 'Section Subtitle', 'Subtitle for Why Events Choose Our Projectors section', 'text', 'Professional AV solutions for Melbourne events since 2007', NULL, '2025-09-19 10:00:36'),
(148, 'projector-why', 'projector-why-feature1-icon', 'Feature 1 Icon', 'Font Awesome icon class for first projector feature', 'text', 'fas fa-video', NULL, '2025-09-19 10:00:36'),
(149, 'projector-why', 'projector-why-feature1-title', 'Feature 1 Title', 'Title for first projector feature block', 'text', 'Personalized Approach', NULL, '2025-09-19 10:00:36'),
(150, 'projector-why', 'projector-why-feature1-text', 'Feature 1 Text', 'Description for first projector feature block', 'text', 'We work closely with you to understand your vision and create a completely customized entertainment experience.', NULL, '2025-09-19 10:00:36'),
(151, 'projector-why', 'projector-why-feature2-icon', 'Feature 2 Icon', 'Font Awesome icon class for second projector feature', 'text', 'fas fa-cogs', NULL, '2025-09-19 10:00:36'),
(152, 'projector-why', 'projector-why-feature2-title', 'Feature 2 Title', 'Title for second projector feature block', 'text', 'Complete Service', NULL, '2025-09-19 10:00:36'),
(153, 'projector-why', 'projector-why-feature2-text', 'Feature 2 Text', 'Description for second projector feature block', 'text', 'Full setup, packup, and technical support included. Compatible with DJ services for seamless audio-visual integration', NULL, '2025-09-19 10:00:36'),
(154, 'projector-why', 'projector-why-feature3-icon', 'Feature 3 Icon', 'Font Awesome icon class for third projector feature', 'text', 'fas fa-handshake', NULL, '2025-09-19 10:00:36'),
(155, 'projector-why', 'projector-why-feature3-title', 'Feature 3 Title', 'Title for third projector feature block', 'text', 'Trusted Professionals', NULL, '2025-09-19 10:00:36'),
(156, 'projector-why', 'projector-why-feature3-text', 'Feature 3 Text', 'Description for third projector feature block', 'text', 'We\'ve done it all - weddings, birthdays, corporate events, festivals, sporting events, markets, school events and parties across Melbourne.', NULL, '2025-09-19 10:00:36'),
(157, 'projector-services', 'projector-services-title', 'Services Title', 'Main heading for projector services section', 'text', 'Complete Projection Solutions', NULL, '2025-09-19 10:00:36'),
(158, 'projector-services', 'projector-services-subtitle', 'Services Subtitle', 'Subtitle for projector services section', 'text', 'Everything you need for stunning visual displays at your event', NULL, '2025-09-19 10:00:36');


--
-- Indexes for table `content_blocks`
--
ALTER TABLE `content_blocks`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `content_blocks`
--
ALTER TABLE `content_blocks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--

-- Table structure for table `content_blocks_phinxlog`
--

CREATE TABLE `content_blocks_phinxlog` (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `content_blocks_phinxlog`
--

INSERT INTO `content_blocks_phinxlog` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`) VALUES
(20230402063959, 'ContentBlocksMigration', '2025-09-14 04:24:26', '2025-09-14 04:24:26', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `content_blocks_phinxlog`
--
ALTER TABLE `content_blocks_phinxlog`
  ADD PRIMARY KEY (`version`);


COMMIT;



