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

START TRANSACTION;



--
-- Database: `keystone`
--

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

--
-- Table structure for table `Activity`
--

CREATE TABLE `Activity` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `content` json NOT NULL,
  `heroImage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featuredImage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gradientBackground` tinyint(1) NOT NULL DEFAULT '0',
  `excerpt` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Activity`
--

INSERT INTO `Activity` (`id`, `name`, `slug`, `content`, `heroImage`, `featuredImage`, `gradientBackground`, `excerpt`) VALUES
('659d43d0-f3da-421e-bbb3-b29e41081f23', 'Rooftop Mini-Golf ', 'rooftop-mini-golf ', '[{\"type\": \"paragraph\", \"children\": [{\"text\": \"Crave’s Rooftop Mini-Golf Course in Pigeon Forge offers 19 holes \\nof adventure and fun as you golf your way through this two-tiered \\noutdoor course. Multi-challenge holes give you more than one way to win \\nas you putt through a fully handicap accessible candy-coated wonderland \\nthat tests the skill of all ages.\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Complete delightfully competitive environments like Rock Candy \\nMountain, Bubblegum Garden, and the Jellybean Jungle, filled with \\ncrystalline candy stalagmites, gumball trees, and giant lollipops. Watch\\n out for the jellybean Crave-men! This exciting course winds it’s way \\nfrom ground level, up a hill and then onto the roof. Get ready for the \\nbest outdoor, mini-golf adventure ever.\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Looking for an indoor adventure? Click Here to See our Sweet \"}, {\"href\": \"https://www.cravegolf.com/activities/indoor-mini-golf/\", \"type\": \"link\", \"children\": [{\"text\": \"Indoor Mini-Golf Course\"}]}, {\"text\": \"\"}]}]', '38908dfd-5c78-11ee-89b2-0242ac110002', '455efad8-5c73-11ee-89b2-0242ac110002', 1, 'Crave’s Rooftop Mini-Golf Course in Pigeon Forge offers 19 holes \nof adventure and fun as you golf your way through this two-tiered \noutdoor course. Multi-challenge holes give you more than one way to win \nas you putt through a fully handicap accessible candy-coated wonderland \nthat tests the skill of all ages.'),
('bc102fda-5b61-4486-b914-b0e7929b0902', 'Indoor Mini-Golf ', 'indoor-mini-golf ', '[{\"type\": \"heading\", \"level\": 2, \"children\": [{\"text\": \"Indoor Course\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Crave’s Indoor Mini-Golf Course in Pigeon Forge, TN weaves you \\nthrough a dreamland of cliffs made of cocoa, ice cream sculpted canyons \\nand a safari that is sure to satisfy anyone’s sweet tooth. Make sure to \\nplay “Crave Style” to add more fun and increase the difficulty of your \\ngame.  Then, take a journey on the Sugar Safari. Interact with sugar \\ncone characters while avoiding a delectable variety of obstacles. Every \\nplayer of your group will compete to be the ultimate Craver on this \\nsweeter than sweet 19 hole course which is fully handicap accessible. \\nGuests can enjoy the massive climate-controlled course no matter what \\nthe weather is doing.\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Looking for an outdoor adventure? Click Here to See our Sweet Rooftop \"}, {\"href\": \"https://www.cravegolf.com/activities/rooftop-mini-golf/\", \"type\": \"link\", \"children\": [{\"text\": \"Mini-Golf Course\"}]}, {\"text\": \"!\"}]}]', '0fd4ebae-5c7a-11ee-89b2-0242ac110002', '77aced20-5c78-11ee-89b2-0242ac110002', 1, 'Crave’s Indoor Mini-Golf Course in Pigeon Forge, TN weaves you \nthrough a dreamland of cliffs made of cocoa, ice cream sculpted canyons \nand a safari that is sure to satisfy anyone’s sweet tooth. Make sure to \nplay “Crave Style” to add more fun and increase the difficulty of your \ngame. ');

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

--
-- Table structure for table `ContactSubmission`
--

CREATE TABLE `ContactSubmission` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `lastName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `needs` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `message` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `submissionDate` datetime(3) DEFAULT CURRENT_TIMESTAMP(3)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ContactSubmission`
--

INSERT INTO `ContactSubmission` (`id`, `firstName`, `lastName`, `email`, `phone`, `needs`, `message`, `submissionDate`) VALUES
('13a46365-4afd-45d1-be9c-c33ffb220fe9', 'Titus', 'Moore', 'titus@ucreate.us', '9999999999', 'group', 'This is my message', '2023-10-18 22:35:52.527');

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

--
-- Table structure for table `Footer`
--

CREATE TABLE `Footer` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `friendTitle` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `friendsBackground` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footerMenu` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `showMap` tinyint(1) NOT NULL DEFAULT '0',
  `tripAdvisorAward` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Footer`
--

INSERT INTO `Footer` (`id`, `friendTitle`, `friendsBackground`, `footerMenu`, `showMap`, `tripAdvisorAward`) VALUES
('0786fa08-c8cc-4691-a53a-968f7879a992', 'Check Out Our Friends', '8cce8a62-5c6b-11ee-89b2-0242ac110002', '6f91dcf2-c7a1-4e13-82b9-9640f2af7686', 1, '93117d50-b549-4227-9906-752dc83730f4');

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

--
-- Table structure for table `Friend`
--

CREATE TABLE `Friend` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirectUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Friend`
--

INSERT INTO `Friend` (`id`, `redirectUrl`, `logo`, `label`) VALUES
('100403c0-03fb-4f7c-b0d9-6af1a8334d63', 'https://www.sweetcandycompany.com/', '2bb4330b-5c6a-11ee-89b2-0242ac110002', 'Sweet Candy Company'),
('1dfdd28e-534c-4015-91da-f9067f8fac08', 'https://www.toyboxgolf.com/', '737e21a7-5c6c-11ee-89b2-0242ac110002', 'Toy Box Golf'),
('38bc1c86-a13b-4049-a34d-919f76695eab', 'https://www.cravegolf.com/activities/zombie-escape-room/', 'a1fb5248-5c69-11ee-89b2-0242ac110002', 'Zombie Research Lab'),
('53472833-2a78-46d9-8b30-79f45e8d4ff4', 'https://www.skypiratesgolf.com/', 'ccbb0cd3-5c79-11ee-89b2-0242ac110002', 'Sky Pirates Golf'),
('7f92de0f-610a-4ef9-9a86-4487d4aa7fb4', 'https://www.topjump.com/', 'fb04aaa4-5c6a-11ee-89b2-0242ac110002', 'Top Jump'),
('8508c2d6-3b5d-4a5f-b0e6-91f5d7541653', 'https://lumberjackfeud.com/', '2c6ef266-5c6b-11ee-89b2-0242ac110002', 'Lumberjack Feud'),
('96eab82e-6769-4153-81d0-882767ef2193', 'https://www.cravegolf.com/activities/mayday-escape-room/', 'f8fc1dd7-5c78-11ee-89b2-0242ac110002', 'Mayday Escape Room'),
('b0efc071-7e64-4e1c-a831-f9fd74c9874e', 'https://www.topjump.com/activities/sugar-rush/', '396e80cd-5c69-11ee-89b2-0242ac110002', 'Sugar Rush');

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

--
-- Table structure for table `Header`
--

CREATE TABLE `Header` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `backgroundImage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menu` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `waiverButton` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `buyNowButton` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Header`
--

INSERT INTO `Header` (`id`, `backgroundImage`, `menu`, `waiverButton`, `buyNowButton`) VALUES
('f20bda4e-02ee-405d-bbc4-7b53f4ff9ad6', 'cf2d9de9-55e1-11ee-a68e-0242ac110002', '6f91dcf2-c7a1-4e13-82b9-9640f2af7686', 'https://google.com', 'https://google.com');

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

--
-- Table structure for table `Image`
--

CREATE TABLE `Image` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `altText` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `image_filesize` int DEFAULT NULL,
  `image_extension` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_width` int DEFAULT NULL,
  `image_height` int DEFAULT NULL,
  `image_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Image`
--

INSERT INTO `Image` (`id`, `name`, `altText`, `image_filesize`, `image_extension`, `image_width`, `image_height`, `image_id`) VALUES
('00b93b65-5c72-11ee-89b2-0242ac110002', 'Submarine Door', 'Submarine door with a splash of water', 90112, 'png', 703, 533, '80c3705e-f2fb-4fcb-aa17-2a6e1d677466'),
('06eb9d82-f1a3-4117-9bef-11a910bdba7a', 'Sweet Shop 2', 'A view inside the sweet shop with giant lollipops', 274076, 'jpg', 1200, 1000, '42c134fa-640c-4280-af93-e3f7485955f3'),
('08fddbe2-ff9c-4b1a-b060-8777bfef5042', 'Ice Cream', 'Ice Cream with Candy', 75483, 'png', 640, 663, 'a7328823-2fe3-4725-b753-c50a6698a562'),
('09b35d32-804d-407e-a372-20cd9df2c985', 'Cakes Slider Background', 'Stacked cakes with golf balls', 75004, 'jpg', 1584, 548, 'c8d2d767-1ed1-4d08-bcb5-c73a53bea3b8'),
('0a72ab31-1d2d-4150-91ab-76e6664e1e22', 'mother daughter escape room', 'mother and daughter solve escape room puzzle together', 262743, 'jpg', 1728, 1152, 'a9ad4064-3504-460e-b9c7-cda25f8f2a5e'),
('0cdc953e-2dc0-4b91-81dc-3d00f5f6f655', 'Submarine Background', 'submarine background', 67710, 'jpg', 1755, 548, '9bb8b6a6-226e-4f8d-819c-286ee6d523fd'),
('0fd4ebae-5c7a-11ee-89b2-0242ac110002', 'Blue with Sprinkles', 'Blue Background with off color sprinkles', 49152, 'jpg', 1516, 758, 'sprinkle-background-blue'),
('131c29fe-002e-4ae3-b759-2380e322e6d2', 'indoor course 8', 'Couple talks about the next mini golf hole', 140173, 'jpg', 1200, 1000, 'afd7673b-1157-4c9f-acac-f6ccbb4f4122'),
('14208134-5c73-11ee-89b2-0242ac110002', 'Google Icon', 'Google Logo', 8192, 'png', 500, 500, '179fb61f-a9e5-4b7f-81c8-b1fea0bdcdf1'),
('205ba4ba-56c4-11ee-a68e-0242ac110002', 'Crave Logo Dark Contrast', 'crave-mini-golf-logo', 25923, 'png', 653, 339, 'crave-footer-logo_white'),
('21728555-a741-4230-abc9-8978265848e0', 'crave outdoor course 6', 'Giant lollipop statues on outdoor mini golf course', 253639, 'jpg', 1200, 1000, '3d548b3c-3e8b-4ef1-b645-4603cdaf2fff'),
('227ce392-28d6-4c93-95f0-35d2adfa6848', 'crave indoor course 9', 'large ice cream scoop statues', 161002, 'jpg', 1200, 1000, '74c4819c-246f-45cf-8126-ed989ee661dd'),
('23ff0e25-5156-43d7-a190-71b0704453b1', 'Boy jumping with putter', 'Boy jumps in air with putter', 217840, 'jpg', 1728, 1152, '138ce76d-4649-47ca-86fb-6d58781ed26e'),
('24a7fa5d-5c76-11ee-89b2-0242ac110002', 'Putt Putt Inside', 'A great place for to pass the time', 495616, 'jpg', 1365, 2048, 'a9dd0313-b769-49f2-bb69-9956671dab7b'),
('2bb4330b-5c6a-11ee-89b2-0242ac110002', 'Sweet Logo', 'Sweet Logo', 36864, 'png', 198, 97, '4b3f6157-3df0-437f-be47-610795a6f221'),
('2c6ef266-5c6b-11ee-89b2-0242ac110002', 'Lumberjack Feud', 'Lumberjack Feud Logo', 8192, 'png', 198, 198, '8f032075-9f84-4f8d-bb16-103a5c67858c'),
('3133a996-5c77-11ee-89b2-0242ac110002', 'Slider with Location', 'Yellow background with Crave Golf exterior', 200704, 'png', 1620, 547, 'acbc2d86-fa2d-4b53-9e3a-4482be157685'),
('335ddfaa-5c69-11ee-89b2-0242ac110002', 'Putt Putt with Trains', 'Mini-Golf course with train', 421888, 'jpg', 2048, 1365, '2ee77453-06d9-4810-8a5e-41b9d34fa204'),
('372733ef-6a7d-4a7d-ab88-48e66da06ed2', 'mini bowling 10', 'Mini bowling lane', 234110, 'jpg', 1152, 1728, 'bf310297-602e-488a-afc7-530fbd9fcda9'),
('38908dfd-5c78-11ee-89b2-0242ac110002', 'Green with Sprinkles', 'Green Background with Sprinkles', 28672, 'jpg', 1516, 758, 'd6bebe6f-5d39-490e-9913-0198c5fe1dac'),
('396e80cd-5c69-11ee-89b2-0242ac110002', 'Sugar Rush Logo', 'sugar-rush', 40129, 'png', 189, 100, '2eba345f-2e83-40fd-a66b-5e326b785deb'),
('455efad8-5c73-11ee-89b2-0242ac110002', 'Family enjoying the putting experience', 'Family enjoying the putting experience', 323584, 'jpg', 1728, 1152, '269b4d79-1899-47c6-87c8-8aa1dafb414a'),
('4681c2f2-9e7b-4413-b616-8ec8818eaa4f', 'Blue Stripes', 'Blue Stripe Background', 419, 'jpg', 50, 11, '27b6b81b-6089-4ffe-9ad2-ef28415123a5'),
('4913899e-5c6c-11ee-89b2-0242ac110002', 'Confused Child', 'Young child looking confused', 65536, 'jpg', 720, 960, '71db9b43-2bc7-4d3a-bf40-6fd24c81f3fe'),
('4b61d876-7e53-4d7c-b2c0-1e442e00a53a', 'sweet shop 9', 'girl holds prize in crave sweet shop', 139469, 'jpg', 1200, 1000, 'e2eba3ee-3ff8-4634-8938-ba15871c7686'),
('56eb36c1-e780-428f-97f5-5ac197b86b3a', 'mini bowling 5', 'friends chat with bowling alleys in the background', 208006, 'jpg', 1200, 1000, '4a47aa1e-7460-4dde-8108-04f6adcfc05e'),
('56fcffb9-b4c9-43e8-97be-2c1a7ff818ef', 'Mini bowling 2', 'top view of bowling lanes', 207386, 'jpg', 1200, 1000, '68951871-cf18-4f18-a7c7-2602ac874d33'),
('5c34b277-f4c9-46ae-a67b-3e1bea5cd9cd', 'mini bowling 8', 'boy vigorously throws bowling bowl in mini bowling alley', 301054, 'jpg', 1728, 1152, '7d88a37e-ee5a-40c0-89e5-8deff563207d'),
('6045cfc3-6bc9-43e2-9a6d-62e8392e39e6', 'sweet shop 4', 'Shelf of skittles and other candies', 174773, 'jpg', 1200, 1000, 'a56feffd-b8e2-4d60-89e0-7171a73995f8'),
('61d09127-5c73-11ee-89b2-0242ac110002', 'Facebook Icon', 'Facebook Logo', 4096, 'png', 500, 500, '470e7aa9-f340-4fe2-a297-16932c1428ab'),
('6303fed4-5c6a-11ee-89b2-0242ac110002', 'Crave Exterior', 'Crave Golf Exterior View', 204800, 'jpg', 2048, 639, '05fbdf2e-5bc9-4cfa-a2b3-888f7814dc73'),
('66df7287-2cfc-4807-8340-e7d3b670cd8a', 'Zombie Hand', 'Zombie Hand on bloody background', 179849, 'jpg', 1755, 548, '215ff864-9f4d-4f48-a413-bcc98024b134'),
('66e4111e-ac7c-432b-b533-637960161b4d', 'Yellow Background Speed', 'Yellow background with speed lines', 28841, 'jpg', 1620, 547, '1ff56e94-bfde-4bba-9fac-25eacc0268ad'),
('679c927d-6c5b-4b21-ad23-0432f1f48555', 'crave group', 'Group of happy people at crave', 366369, 'jpg', 1355, 2048, 'a2a08429-3e70-485f-8f0b-6c9d0bfc6c77'),
('6b14c501-8551-4713-b53d-2878280a9bc5', 'Confetti', 'confetti', 20827, 'png', 1790, 883, 'a1436b31-ef5d-4aa4-9b07-87af8fd8fe2f'),
('721d541d-5c75-11ee-89b2-0242ac110002', 'Our Friends', 'Golf with our friends', 1658880, 'jpg', 3200, 2133, '6232e5a2-218f-4bd5-89b1-5c4e62df699e'),
('72b03203-5c72-11ee-89b2-0242ac110002', 'Spinning Wheel Lollipop', 'Spinning Wheel on a Lollipop', 106496, 'png', 739, 761, '81e9043e-ab9a-4f6a-a981-0196c304663c'),
('737e21a7-5c6c-11ee-89b2-0242ac110002', 'Toy Box Mini Golf', 'Toy Box Mini Golf Logo', 8192, 'png', 150, 128, '75d1dd60-9c45-4623-8cda-9830dbc41f4f'),
('74eeea59-8197-4bcd-b318-749740ba03cd', 'crave v1a 08', 'father and son play a game at crave', 254218, 'jpg', 1152, 1728, '8782ae64-e0a6-4d42-9af2-92d91bc55ff2'),
('77aced20-5c78-11ee-89b2-0242ac110002', 'Kid Friendly', 'Mother congratulating daughter on putt', 299008, 'webp', 2048, 1365, 'da5b7375-1da6-43ae-8771-ed8e93897fcc'),
('7ec8d814-c1d8-40f8-a35d-8aff3242ca83', 'candy-store-v2a', 'wall of jelly bean dispensers', 571349, 'jpg', 1642, 1094, 'd9d5c782-7800-4d1c-ba59-b3b41178159a'),
('7f745406-5c76-11ee-89b2-0242ac110002', 'Victory', 'Person celebrating a victory', 393216, 'jpg', 1094, 1642, 'a302137a-f2c5-4014-985e-66ccd6585fdd'),
('815ce2b8-9ea4-41b5-9268-3987cc4ea744', 'Crave Exterior Slider Element', 'crave exterior', 96177, 'png', 1460, 547, 'd6f22370-a72e-43f3-91a0-0c7b83b66fcd'),
('854af729-91ca-4b8c-a64e-95739602eb22', 'mini bowling 6', 'Mini bowling lanes', 197188, 'jpg', 1200, 1000, 'a3a03e86-73b7-4ea9-8b50-ee999cc868c8'),
('8904bc5a-7583-4cd3-999f-4ff75a9c320a', 'Candy Wings', 'A girl poses in front of a mural of candy wings', 147235, 'jpg', 944, 833, '73e0941e-d066-4e5e-952e-789a6dd78a56'),
('8cce8a62-5c6b-11ee-89b2-0242ac110002', 'Orange Sprinkles Background', 'Orange Field with off color sprinkles', 40960, 'jpg', 1516, 758, '26ec2db4-7fe6-4a4d-a829-2f9b2740d741'),
('93117d50-b549-4227-9906-752dc83730f4', 'Trip Advisor Award', 'Trip Advisor Travelers Choice Award 2023', 66010, 'png', 1100, 1174, 'e2ea161b-777a-4bf2-9b91-0099c67094b0'),
('9502cd0a-5c6a-11ee-89b2-0242ac110002', 'Crave Logo - Old', 'Crave Golf Club', 24576, 'png', 166, 79, '7be902f5-c8cd-46d9-8519-3842ec387401'),
('9593b45e-dea1-4b6b-b281-116b207887cb', 'mini bowling 3', 'view of empty mini bowling lanes', 169829, 'jpg', 1200, 1000, '828b59be-3095-45dc-aeaa-8caaf470ad9a'),
('96342dd9-ffc5-4558-8fac-f2f1971dea4b', 'crave candy store v18a', 'woman and child look at candy in crave candy store', 310606, 'jpg', 1094, 1642, '2e6271b1-a173-4c51-9b5a-eeee5c6cbf56'),
('98235a7c-fa17-494c-bbba-fbcceb337876', 'Green Stripes', 'Green Stripe Background', 401, 'jpg', 50, 11, '546b6eed-c7e7-431d-8c1b-184a5b251009'),
('9d5cda58-1fae-4bab-babb-3d7207e8db27', 'outdoor course 7', 'view of the outdoor course', 134796, 'jpg', 1086, 724, 'f0dda1b4-8370-461f-b864-213ce134eed3'),
('a1fb5248-5c69-11ee-89b2-0242ac110002', 'Zombie Research Lab', 'Zombie Research Lab Logo', 27332, 'png', 560, 364, '3ddfab1b-9525-44bd-abb9-efa89b0abb30'),
('a4511412-dfc7-46c8-8215-3304b2e245f3', 'sweet shop 1', 'man carrying giant lollipop over his shoulder', 232115, 'jpg', 1200, 1000, '0456b810-fd83-40ba-96df-f4c8f2657ec5'),
('a7a09362-5c74-11ee-89b2-0242ac110002', 'Ice Cream Family Photo', 'A great place for family photos', 737280, 'webp', 1705, 2048, '815bfc82-77ea-4690-8d31-d7c343a7e58e'),
('a93bc22a-cfd4-4e86-b7c0-f466ae93cf2e', 'escape room 3', 'two women working on an escape room puzzle', 364110, 'jpg', 2048, 1365, 'f7c81699-0eb3-4dde-9d32-e7192f7fbbcc'),
('b2c5ab8b-1ac3-40db-8c19-beaea4535361', 'Purple Stripes', 'purple striped background', 402, 'jpg', 51, 16, '068055a5-fc10-45c3-9644-12adbc927a77'),
('b3a40a9d-093e-4595-81ef-6aed7b63b676', 'Escape Room Wires', 'Two women solve a wire puzzle', 411010, 'jpg', 2048, 1365, '1ac76ad8-d942-40ae-860c-f2ad2589cdb7'),
('b51185db-acd0-4b5c-8e18-802fd212cb84', 'Excited Girl', 'celebratory girl', 46320, 'png', 693, 526, '91dff0e5-f6af-43af-beb2-633d14b014f5'),
('b640d5ec-36ac-44a8-b53d-39161d608893', 'Happy Family Slider Background', 'family happy with golfing', 72605, 'jpg', 1584, 548, '56c6e5b0-c902-4d67-b94e-c50ce164ce71'),
('b64d64ce-5c77-11ee-89b2-0242ac110002', 'The course exterior', 'The exterior of the crave golf putt putt course', 2273289, 'jpg', 3200, 2133, 'acfe4f8a-2ba7-41e3-88e7-17b5b2baf455'),
('bb2a662b-6331-4fb2-88b6-100771e20a40', 'Orange Stripes', 'Orange Stripe Background', 402, 'jpg', 50, 11, 'dcf05a34-1abc-4de8-9fcf-61428aa379d0'),
('bdbe1a17-74b1-4725-88a4-24729ab1124a', 'crave v1a 03', 'couple sits on a bench at outdoor mini golf course', 320413, 'jpg', 1152, 1728, '43bdd3cf-2160-4add-9dfe-4b51bb2e61de'),
('c036287d-ecc4-472c-9c3b-85bff8787923', 'indoor course 7', 'Giant ice cream statues in crave\'s indoor course', 148802, 'jpg', 1200, 1000, 'dd64842f-2275-460c-bc18-34cee84e57b3'),
('c0badc71-5c78-11ee-89b2-0242ac110002', 'Kid successful putt', 'Girl celebrating her putt', 49152, 'jpg', 400, 604, 'db324c10-d0a7-4880-bb53-0ada12b4b76c'),
('c10da2a9-49eb-4b14-bda5-b46054b0ebd0', 'crave outdoor course 3', 'crave outdoor golf course view', 168405, 'jpg', 1200, 1000, '2d41dac0-2861-496a-8866-2b6b41ee15ce'),
('c14c3a5c-935e-4774-8e07-ee89bc3f373c', 'Pink Stripes', 'Pink Stripe Background', 403, 'jpg', 50, 11, 'fca3a601-dce3-42c2-b3e1-845546c43cf4'),
('c7cb3b6b-7b9f-461b-b3ea-4a07348db296', 'Victory Celebration', 'Mother and Celebrating the completion of the course', 200560, 'jpg', 1152, 1728, '4f575da2-d901-4415-b2c4-fddf6b293944'),
('c924de48-5c6a-11ee-89b2-0242ac110002', 'Fun for the whole family', 'Family enjoying mini-golf at Crave Golf', 356352, 'webp', 2048, 1365, '8cb37dad-aee3-4f5e-9a1e-a910b402eff6'),
('c9cc50b5-10b8-4b40-955c-4986a190554f', 'crave indoor course v39a', 'Indoor golf course with large ice cream statue', 318662, 'jpg', 1094, 1642, '740ec095-93b1-4654-8598-8a9badac3597'),
('ca4658de-2ae3-4a55-a518-ecdcf949d33f', 'Escape Room vault', 'Two girls puzzle over a vault in an escape room', 105815, 'jpg', 1152, 1728, 'e7355972-7da7-457a-8c8e-86dbf8d2b20e'),
('cae36540-c7c0-4c71-a7f6-0c3e4ab8fd45', 'crave 0937', 'Crave indoor mini golf course', 341625, 'jpg', 1555, 1037, '72e1b959-1ef1-4745-81d7-35965a45a9a7'),
('cc1c897c-7ad5-4d19-ae13-0d249f6a0c01', 'Outdoor Course', 'A Veiw of Crave\'s Outdoor Course with a danger keep out mineshaft', 125133, 'jpg', 1200, 1000, '32179ec4-76d8-4217-84d0-43b43e3f61aa'),
('ccbb0cd3-5c79-11ee-89b2-0242ac110002', 'Sky Pirates of Mermaid Bay', 'Sky Pirates of Mermaid Pay A golf adventure logo', 24576, 'png', 200, 133, 'f873bd24-a647-400f-9a84-1d461d5c8cb2'),
('cce423f2-5c75-11ee-89b2-0242ac110002', 'Immersive Environments', 'Explore Our Immersive Environments', 266440, 'jpg', 1728, 1152, '7697680d-91db-47e8-874c-bcf8e92937aa'),
('cf2d9de9-55e1-11ee-a68e-0242ac110002', 'Navigation background', 'white-background-with-off-white-decoration', 18791, 'jpg', 1584, 95, '5b5371b0-945f-4890-8e8b-f36451c3522e'),
('d13d31d4-5c74-11ee-89b2-0242ac110002', 'Blue Vertical Background', 'Blue Background with Off color decorations', 12288, 'jpg', 615, 812, '989e4aff-0b40-4d4e-9015-3e7ecc0dfd66'),
('d6d87319-5c69-11ee-89b2-0242ac110002', 'Tip Advisor Logo', 'Trip Advisor Logo', 12288, 'png', 500, 325, '3ef9c0d3-b0da-49d0-8ba6-7ff6c049c1ba'),
('db1c8eed-5c72-11ee-89b2-0242ac110002', 'Bowling Ball and Pins', 'Bowling Ball and Pins', 45056, 'png', 640, 439, '96bad931-fa4a-4d15-871a-d166037657cf'),
('db4ced8a-2e49-4e32-8d6a-95fde7cce017', 'crave v1a 04', 'girl putts at candy giant\'s mouth', 301325, 'jpg', 1728, 1152, 'd5bb337c-df81-4028-88ae-f2c632bc8cb8'),
('e26c0f39-55dd-11ee-a68e-0242ac110002', 'Main Logo', 'Crave Golf Club', 110878, 'png', 2088, 991, '8add16ee-b9f0-4616-86f3-b4192c530dcf'),
('e32c9172-17bb-4271-8690-b7cf4dcab1c1', 'family fun 2', 'a family excited bowls at crave mini bowling', 291135, 'jpg', 1152, 1728, '33b12377-0d0e-4885-996d-ed5ead9fccda'),
('f4944b2c-55d9-11ee-a68e-0242ac110002', 'Group Mini Golf', 'group-mini-golf', 3163854, 'jpg', 3200, 2133, '2c5a14a8-2e3f-489e-8443-0577f058ce41'),
('f5079cfb-5c77-11ee-89b2-0242ac110002', 'Pink with Sprinkles', 'Pink Background with off color sprinkles', 40960, 'jpg', 1516, 758, 'c65c5ce5-ecb9-4757-9be3-e731db83d250'),
('f8fc1dd7-5c78-11ee-89b2-0242ac110002', 'Mayday Logo', 'Mayday A Deep Sea Adventure', 5438, 'png', 611, 200, 'eba6ace8-6728-46b4-ba58-52f8a82857e9'),
('fb04aaa4-5c6a-11ee-89b2-0242ac110002', 'Top Jump Trampoline & Extreme Arena', 'Top Jump Logo', 4096, 'png', 184, 100, '8ef6714a-f459-4c25-8268-57e57dc999da'),
('fd893350-5c6b-11ee-89b2-0242ac110002', 'We\'re Number -- Mini-Golf in America', 'We\'re number 1, best mini golf course in America', 45056, 'png', 810, 263, '42b8b103-5421-4f92-8b82-954195b152a5');

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

--
-- Table structure for table `Logo`
--

CREATE TABLE `Logo` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `headerLogo_filesize` int DEFAULT NULL,
  `headerLogo_extension` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headerLogo_width` int DEFAULT NULL,
  `headerLogo_height` int DEFAULT NULL,
  `headerLogo_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footerLogo_filesize` int DEFAULT NULL,
  `footerLogo_extension` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footerLogo_width` int DEFAULT NULL,
  `footerLogo_height` int DEFAULT NULL,
  `footerLogo_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `Menu`
--

CREATE TABLE `Menu` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Menu`
--

INSERT INTO `Menu` (`id`, `name`) VALUES
('6f91dcf2-c7a1-4e13-82b9-9640f2af7686', 'Main Navigation');

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

--
-- Table structure for table `MenuItem`
--

CREATE TABLE `MenuItem` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `parent` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menuOrder` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `MenuItem`
--

INSERT INTO `MenuItem` (`id`, `title`, `url`, `parent`, `menuOrder`) VALUES
('028d470c-a129-4604-a44f-1cddd2950f27', 'Crave Style', 'about/crave-style', '0737bd9d-b862-41ee-a3c5-ae44fe5624dc', 5),
('0737bd9d-b862-41ee-a3c5-ae44fe5624dc', 'About Us', '/about', NULL, 0),
('17b5acc3-d243-4171-96d6-fe70d7474ee4', 'Indoor Mini-Golf', '/activities/indoor-mini-golf', 'a7ec9b1f-4b2d-4e43-b025-909434502e13', 2),
('247823be-491c-446c-85d3-213bfdfcc88c', 'Church Groups', 'groups/church-groups', NULL, 1),
('2d7d4e03-fa73-4bd4-af92-55070b135dde', 'Rules & Regulations', '/about/rules-and-regulations', '0737bd9d-b862-41ee-a3c5-ae44fe5624dc', 6),
('35e05a69-c410-413a-b86f-64240fd1f419', 'Zombie Escape Room', 'activities/escape-rooms/zombie-escape-room', 'd3ef089c-a5c5-4f7a-b5f2-0d67f4a18fe1', 2),
('41572745-e7cd-417a-99d0-fc163642cb00', 'Scout Trips', 'groups/scout-trips', 'c84d820a-921a-4880-8693-da5d48ccdbc4', 4),
('4cf54be7-5b6b-4258-a963-f12a5d3e74eb', 'Candy Shop', 'activities/candy-shop', 'a7ec9b1f-4b2d-4e43-b025-909434502e13', 5),
('5166d211-55d1-450d-8cac-8779c2ad951b', 'Mayday Escape', 'activities/escape-rooms/mayday-escape', 'd3ef089c-a5c5-4f7a-b5f2-0d67f4a18fe1', 1),
('5795a184-977c-496d-9e7a-386e612431d0', 'Contact Us', 'about/contact-us', '0737bd9d-b862-41ee-a3c5-ae44fe5624dc', 1),
('5d28ee44-4c39-40e2-889f-d12e1064f059', 'Reviews', '/about/reviews', '0737bd9d-b862-41ee-a3c5-ae44fe5624dc', 4),
('5f53aa44-ddce-43c2-bfed-fa0a129794b4', 'Rooftop Mini-Golf', 'activities/rooftop-mini-golf', 'a7ec9b1f-4b2d-4e43-b025-909434502e13', 0),
('64b77e2c-5b49-4d12-a1c9-f907df3ad9c7', 'Church Youth Groups', 'groups/church-youth-groups', 'c84d820a-921a-4880-8693-da5d48ccdbc4', 1),
('7426c0f7-9f1b-44f3-a5b5-f228fee7113d', 'Groups', 'groups/groups', NULL, 2),
('7a43799d-70d4-4615-afad-ea015c77f30b', 'Hours & Pricing', 'https://buy.cravegolf.com/areas/areas', NULL, 2),
('7cdb42ae-73d2-4653-9c9f-3ecdc78e2b51', 'Gallery', 'about/gallery', '0737bd9d-b862-41ee-a3c5-ae44fe5624dc', 3),
('9346de15-f4a3-46be-8d6e-bcafa2adf530', 'Field Trips', 'groups/field-trips', 'c84d820a-921a-4880-8693-da5d48ccdbc4', 2),
('9b03beda-1332-43b4-8b0f-98c1e2505fad', 'Jobs', 'https://www.topconcepts.us/jobs/', NULL, 5),
('9c4ce3d0-fb80-4409-95e6-6cde43588eaf', 'Escape Room FAQs', 'activities/escape-rooms/escape-room-faqs', 'd3ef089c-a5c5-4f7a-b5f2-0d67f4a18fe1', 1),
('a7a42dc7-e5a2-4356-99b0-e285f6cbfff7', 'Indoor Mini-Golf', 'indoor-mini-golf', 'a7ec9b1f-4b2d-4e43-b025-909434502e13', 2),
('a7ec9b1f-4b2d-4e43-b025-909434502e13', 'Activities', '/activities', NULL, 1),
('baf346c1-5084-4492-9acd-efc76739c1e7', 'Sport Teams', '/groups/sport-teams', 'c84d820a-921a-4880-8693-da5d48ccdbc4', 3),
('c84d820a-921a-4880-8693-da5d48ccdbc4', 'Groups', '/groups', NULL, 4),
('d3ef089c-a5c5-4f7a-b5f2-0d67f4a18fe1', 'Escape Rooms', '/activities/escape-rooms', 'a7ec9b1f-4b2d-4e43-b025-909434502e13', 3),
('ed30c1d5-477e-4b09-a283-673613cb3137', 'Mini-Bowling', 'activities/mini-bowling', 'a7ec9b1f-4b2d-4e43-b025-909434502e13', 4),
('ed39d512-628c-4990-95e3-21393a363937', 'Blogs', '/news-press', '0737bd9d-b862-41ee-a3c5-ae44fe5624dc', 0),
('fbef337c-aff2-4a20-8b82-846ffdacb19a', 'Parties', '/parties', NULL, 3);

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

--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `content` json NOT NULL,
  `footer` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `header` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` (`id`, `name`, `slug`, `content`, `footer`, `header`, `parent`) VALUES
('40f6d472-92fd-4fd2-82d8-12802869cba7', 'Home', 'home', '[{\"type\": \"component-block\", \"props\": {\"items\": [{\"slideType\": {\"value\": {\"url\": \"https://player.vimeo.com/progressive_redirect/playback/803141592/rendition/1080p/file.mp4?loc=external&signature=c4ef2a6b5797f0ea0387351b2b493dd1a13905627e2422aa623e69a78ca1b97e\"}, \"discriminant\": \"video\"}}, {\"slideType\": {\"value\": {\"effects\": [{\"value\": {\"position\": {\"offset\": \"0\", \"vertical\": \"100\", \"horizontal\": \"50\", \"layerIndex\": 1, \"effectPriority\": 1}, \"direction\": \"up\", \"slideContent\": [{\"content\": {\"value\": {\"image\": {\"id\": \"815ce2b8-9ea4-41b5-9268-3987cc4ea744\"}, \"imageScale\": 1}, \"discriminant\": \"imageContent\"}}]}, \"discriminant\": \"slide\"}, {\"value\": {\"position\": {\"offset\": \"-2rem 0\", \"vertical\": \"50\", \"horizontal\": \"50\", \"layerIndex\": 5, \"effectPriority\": 2}, \"slideContent\": [{\"content\": {\"value\": {\"image\": {\"id\": \"fd893350-5c6b-11ee-89b2-0242ac110002\"}, \"imageScale\": 1}, \"discriminant\": \"imageContent\"}}]}, \"discriminant\": \"fade\"}, {\"value\": {\"position\": {\"offset\": \"0 4rem\", \"vertical\": \"100\", \"horizontal\": \"0\", \"layerIndex\": 2, \"effectPriority\": 3}, \"direction\": \"up\", \"slideContent\": [{\"content\": {\"value\": {\"image\": {\"id\": \"b51185db-acd0-4b5c-8e18-802fd212cb84\"}, \"imageScale\": 1}, \"discriminant\": \"imageContent\"}}]}, \"discriminant\": \"slide\"}, {\"value\": {\"position\": {\"offset\": \"0\", \"vertical\": \"0\", \"horizontal\": \"0\", \"layerIndex\": 0, \"effectPriority\": 4}, \"direction\": \"down\", \"slideContent\": [{\"content\": {\"value\": {\"image\": {\"id\": \"6b14c501-8551-4713-b53d-2878280a9bc5\"}, \"imageScale\": 1}, \"discriminant\": \"imageContent\"}}]}, \"discriminant\": \"slide\"}], \"mainImage\": {\"id\": \"66e4111e-ac7c-432b-b533-637960161b4d\"}}, \"discriminant\": \"image\"}}, {\"slideType\": {\"value\": {\"effects\": [{\"value\": {\"position\": {\"offset\": \"-3rem 6rem\", \"vertical\": \"25\", \"horizontal\": \"0\", \"layerIndex\": 1, \"effectPriority\": 1}, \"direction\": \"down\", \"slideContent\": [{\"content\": {\"value\": {\"image\": {\"id\": \"f8fc1dd7-5c78-11ee-89b2-0242ac110002\"}, \"imageScale\": 1}, \"discriminant\": \"imageContent\"}}]}, \"discriminant\": \"slide\"}, {\"value\": {\"position\": {\"offset\": \"0 6rem\", \"vertical\": \"50\", \"horizontal\": \"0\", \"layerIndex\": 1, \"effectPriority\": 1}, \"direction\": \"right\", \"slideContent\": [{\"content\": {\"value\": {\"link\": \"/activities/mayday-escape-room\", \"text\": \"Plan Your Escape\", \"color\": \"green\"}, \"discriminant\": \"button\"}}]}, \"discriminant\": \"slide\"}], \"mainImage\": {\"id\": \"0cdc953e-2dc0-4b91-81dc-3d00f5f6f655\"}}, \"discriminant\": \"image\"}}, {\"slideType\": {\"value\": {\"effects\": [{\"value\": {\"position\": {\"offset\": \"0\", \"vertical\": \"25\", \"horizontal\": \"66.6\", \"layerIndex\": 1, \"effectPriority\": 1}, \"direction\": \"down\", \"slideContent\": [{\"content\": {\"value\": {\"image\": {\"id\": \"a1fb5248-5c69-11ee-89b2-0242ac110002\"}, \"imageScale\": 1}, \"discriminant\": \"imageContent\"}}]}, \"discriminant\": \"slide\"}, {\"value\": {\"position\": {\"offset\": \"3rem -5rem\", \"vertical\": \"66.6\", \"horizontal\": \"66.6\", \"layerIndex\": 1, \"effectPriority\": 1}, \"direction\": \"left\", \"slideContent\": [{\"content\": {\"value\": {\"link\": \"/activities/zombie-escape-error\", \"text\": \"Plan Your Escape\", \"color\": \"pink\"}, \"discriminant\": \"button\"}}]}, \"discriminant\": \"slide\"}], \"mainImage\": {\"id\": \"66df7287-2cfc-4807-8340-e7d3b670cd8a\"}}, \"discriminant\": \"image\"}}, {\"slideType\": {\"value\": {\"effects\": [{\"value\": {\"position\": {\"offset\": \"0\", \"vertical\": \"50\", \"horizontal\": \"75\", \"layerIndex\": 1, \"effectPriority\": 1}, \"slideContent\": [{\"content\": {\"value\": {\"button\": {\"link\": \"https://cravegolf.centeredgeonline.com/retail\", \"text\": \"Buy Now\", \"color\": \"blue\"}, \"content\": \"Play Our Sweeeet Indoor Course\", \"fontSize\": \"85\", \"textContainerWidth\": 15}, \"discriminant\": \"text\"}}]}, \"discriminant\": \"fade\"}], \"mainImage\": {\"id\": \"09b35d32-804d-407e-a372-20cd9df2c985\"}}, \"discriminant\": \"image\"}}, {\"slideType\": {\"value\": {\"effects\": [{\"value\": {\"position\": {\"offset\": \"0\", \"vertical\": \"25\", \"horizontal\": \"33.3\", \"layerIndex\": 1, \"effectPriority\": 1}, \"slideContent\": [{\"content\": {\"value\": {\"button\": {\"link\": \"https://cravegolf.centeredgeonline.com/retail\", \"text\": \"Buy Now\", \"color\": \"green\"}, \"content\": \"GOLF LIKE NEVER BEFORE, EVEN ON THE ROOF\", \"fontSize\": \"64\", \"textContainerWidth\": 29}, \"discriminant\": \"text\"}}]}, \"discriminant\": \"fade\"}], \"mainImage\": {\"id\": \"b640d5ec-36ac-44a8-b53d-39161d608893\"}}, \"discriminant\": \"image\"}}]}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"slider\"}, {\"type\": \"background\", \"children\": [{\"type\": \"heading\", \"level\": 1, \"children\": [{\"text\": \"WELCOME TO CRAVE\"}], \"textAlign\": \"center\"}, {\"type\": \"heading\", \"level\": 2, \"children\": [{\"text\": \"Best \"}, {\"href\": \"https://www.cravegolf.com/activities/indoor-mini-golf/\", \"type\": \"link\", \"children\": [{\"text\": \"Mini-Golf in Pigeon Forge\"}]}, {\"text\": \" & Ranked #1 \"}, {\"href\": \"https://www.cravegolf.com/activities/rooftop-mini-golf/\", \"type\": \"link\", \"children\": [{\"text\": \"Mini-Golf Course\"}]}, {\"text\": \" in the Country featuring 19-hole Indoor Course & 19-hole Rooftop Course!\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Indoor family miniature golf course\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Outdoor rooftop adventure miniature golf course\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Escape rooms\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Mini bowling\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Candy store\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Soft serve ice cream\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Handicap accessible\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}], \"textAlign\": \"center\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Come get your CRAVE on!\"}], \"textAlign\": \"center\"}], \"backgroundSettings\": {\"type\": \"image\", \"value\": \"{\\\"id\\\":\\\"f5079cfb-5c77-11ee-89b2-0242ac110002\\\",\\\"label\\\":\\\"Pink with Sprinkles\\\",\\\"data\\\":{\\\"__typename\\\":\\\"Image\\\"}}\", \"contrast\": \"dark\", \"imageSettings\": {\"fixed\": true, \"repeating\": true}}}, {\"type\": \"background\", \"children\": [{\"type\": \"component-block\", \"props\": {\"image\": {\"id\": \"6303fed4-5c6a-11ee-89b2-0242ac110002\"}, \"scale\": \"1\", \"anchorBottom\": false}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"image\"}], \"backgroundSettings\": {\"type\": \"color\", \"value\": \"#ffffff\", \"contrast\": \"light\", \"imageSettings\": {\"fixed\": false, \"repeating\": false}}}, {\"type\": \"background\", \"children\": [{\"type\": \"layout\", \"layout\": [1, 1], \"children\": [{\"type\": \"layout-area\", \"children\": [{\"type\": \"component-block\", \"props\": {\"image\": {\"id\": \"72b03203-5c72-11ee-89b2-0242ac110002\"}, \"scale\": \".75\", \"anchorBottom\": true}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"image\"}]}, {\"type\": \"layout-area\", \"children\": [{\"type\": \"heading\", \"level\": 2, \"children\": [{\"text\": \"A New Way to Play!\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Introducing “Crave Style” – a unique approach to mini golf, featuring\\n wacky twists and quirky challenges you won’t find anywhere else!\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://www.cravegolf.com/about-us/crave-style/\", \"type\": \"link\", \"children\": [{\"text\": \"Learn More\"}]}, {\"text\": \"\"}]}]}]}], \"backgroundSettings\": {\"type\": \"image\", \"value\": \"{\\\"id\\\":\\\"bb2a662b-6331-4fb2-88b6-100771e20a40\\\",\\\"label\\\":\\\"Orange Stripes\\\",\\\"data\\\":{\\\"__typename\\\":\\\"Image\\\"}}\", \"contrast\": \"dark\", \"imageSettings\": {\"fixed\": true, \"repeating\": true}}}, {\"type\": \"background\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"This is a placeholder for reviews\"}]}], \"backgroundSettings\": {\"type\": \"color\", \"value\": \"#ffffff\", \"contrast\": \"light\", \"imageSettings\": {\"fixed\": false, \"repeating\": false}}}, {\"type\": \"background\", \"children\": [{\"type\": \"layout\", \"layout\": [1, 1], \"children\": [{\"type\": \"layout-area\", \"children\": [{\"type\": \"heading\", \"level\": 2, \"children\": [{\"text\": \"Check out our Mini-Bowling Alley\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Prove you’re the kingpin and challenge your friends and family to an exciting game at our unique mini-bowling alley!\"}]}, {\"type\": \"component-block\", \"props\": {\"buttons\": [{\"href\": \"https://www.cravegolf.com/activities/mini-bowling/\", \"label\": \"Learn More\", \"style\": \"secondary\"}]}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"button\"}]}, {\"type\": \"layout-area\", \"children\": [{\"type\": \"component-block\", \"props\": {\"image\": {\"id\": \"db1c8eed-5c72-11ee-89b2-0242ac110002\"}, \"scale\": \"1\", \"anchorBottom\": true}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"image\"}]}]}], \"backgroundSettings\": {\"type\": \"image\", \"value\": \"{\\\"id\\\":\\\"d13d31d4-5c74-11ee-89b2-0242ac110002\\\",\\\"label\\\":\\\"Blue Vertical Background\\\",\\\"data\\\":{\\\"__typename\\\":\\\"Image\\\"}}\", \"contrast\": \"dark\", \"imageSettings\": {\"fixed\": true, \"repeating\": true}}}, {\"type\": \"background\", \"children\": [{\"type\": \"layout\", \"layout\": [1, 1], \"children\": [{\"type\": \"layout-area\", \"children\": [{\"type\": \"component-block\", \"props\": {\"image\": {\"id\": \"00b93b65-5c72-11ee-89b2-0242ac110002\"}, \"scale\": \"1\", \"anchorBottom\": true}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"image\"}]}, {\"type\": \"layout-area\", \"children\": [{\"type\": \"heading\", \"level\": 2, \"children\": [{\"text\": \"Choose Your Adventure—Escape if you can!\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Solve puzzles, find clues and use teamwork to find your way out. Pit \\nyour wits against the clock to escape zombies or a sinking sub. Crave \\nEscape Rooms are perfect for families and groups looking for an \\nexciting, action-packed experience.\"}]}, {\"type\": \"component-block\", \"props\": {\"buttons\": [{\"href\": \"https://www.cravegolf.com/activities/mayday-escape-room/\", \"label\": \"Mayday\", \"style\": \"secondary\"}, {\"href\": \"https://www.cravegolf.com/activities/zombie-escape-room/\", \"label\": \"Zombie\", \"style\": \"secondary\"}]}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"button\"}]}]}], \"backgroundSettings\": {\"type\": \"image\", \"value\": \"{\\\"id\\\":\\\"38908dfd-5c78-11ee-89b2-0242ac110002\\\",\\\"label\\\":\\\"Green with Sprinkles\\\",\\\"data\\\":{\\\"__typename\\\":\\\"Image\\\"}}\", \"contrast\": \"dark\", \"imageSettings\": {\"fixed\": true, \"repeating\": false}}}, {\"type\": \"background\", \"children\": [{\"type\": \"layout\", \"layout\": [1, 1], \"children\": [{\"type\": \"layout-area\", \"children\": [{\"type\": \"heading\", \"level\": 2, \"children\": [{\"text\": \"Welcome to Flavor Nation!\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Get bowls or cups full of soft serve fantasticness. Create your all-time favorite. Or build a new creation for you to enjoy.\"}]}]}, {\"type\": \"layout-area\", \"children\": [{\"type\": \"component-block\", \"props\": {\"image\": {\"id\": \"08fddbe2-ff9c-4b1a-b060-8777bfef5042\"}, \"scale\": \"1\", \"anchorBottom\": true}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"image\"}]}]}], \"backgroundSettings\": {\"type\": \"image\", \"value\": \"{\\\"id\\\":\\\"b2c5ab8b-1ac3-40db-8c19-beaea4535361\\\",\\\"label\\\":\\\"Purple Stripes\\\",\\\"data\\\":{\\\"__typename\\\":\\\"Image\\\"}}\", \"contrast\": \"dark\", \"imageSettings\": {\"fixed\": true, \"repeating\": true}}}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}]', '0786fa08-c8cc-4691-a53a-968f7879a992', 'f20bda4e-02ee-405d-bbc4-7b53f4ff9ad6', NULL),
('48be264b-bbdd-4289-8825-35e1524f12d8', 'Gallery', 'gallery', '[{\"type\": \"component-block\", \"props\": {\"title\": null, \"backgroundImage\": {\"id\": \"8cce8a62-5c6b-11ee-89b2-0242ac110002\"}}, \"children\": [{\"type\": \"component-block-prop\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"Gallery\"}]}], \"propPath\": [\"title\"]}], \"component\": \"titleHero\"}, {\"type\": \"layout\", \"layout\": [1], \"children\": [{\"type\": \"layout-area\", \"children\": [{\"type\": \"component-block\", \"props\": {\"items\": [{\"url\": \"https://www.youtube.com/embed/BkusI2yYyzw?start=52&feature=oembed\", \"altText\": \"Once in a lifetime triple hole in one\"}, {\"url\": \"https://www.youtube.com/embed/dUCO8loLCnk?feature=oembed\", \"altText\": \"Most fun mini golf course ever\"}, {\"url\": \"https://www.youtube.com/embed/GzQFjmRcMTA?feature=oembed\", \"altText\": \"Embedded video\"}, {\"url\": \"https://www.youtube.com/embed/FQSlCKN14K0?feature=oembed\", \"altText\": \"Embedded video\"}]}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"videoGallery\"}]}]}, {\"type\": \"component-block\", \"props\": {\"galleryImages\": [{\"id\": \"335ddfaa-5c69-11ee-89b2-0242ac110002\"}, {\"id\": \"455efad8-5c73-11ee-89b2-0242ac110002\"}, {\"id\": \"7f745406-5c76-11ee-89b2-0242ac110002\"}, {\"id\": \"c7cb3b6b-7b9f-461b-b3ea-4a07348db296\"}, {\"id\": \"ca4658de-2ae3-4a55-a518-ecdcf949d33f\"}, {\"id\": \"cc1c897c-7ad5-4d19-ae13-0d249f6a0c01\"}, {\"id\": \"b3a40a9d-093e-4595-81ef-6aed7b63b676\"}, {\"id\": \"7ec8d814-c1d8-40f8-a35d-8aff3242ca83\"}, {\"id\": \"8904bc5a-7583-4cd3-999f-4ff75a9c320a\"}, {\"id\": \"4b61d876-7e53-4d7c-b2c0-1e442e00a53a\"}, {\"id\": \"23ff0e25-5156-43d7-a190-71b0704453b1\"}, {\"id\": \"854af729-91ca-4b8c-a64e-95739602eb22\"}, {\"id\": \"6045cfc3-6bc9-43e2-9a6d-62e8392e39e6\"}, {\"id\": \"56eb36c1-e780-428f-97f5-5ac197b86b3a\"}, {\"id\": \"06eb9d82-f1a3-4117-9bef-11a910bdba7a\"}, {\"id\": \"a4511412-dfc7-46c8-8215-3304b2e245f3\"}, {\"id\": \"9593b45e-dea1-4b6b-b281-116b207887cb\"}, {\"id\": \"96342dd9-ffc5-4558-8fac-f2f1971dea4b\"}, {\"id\": \"56fcffb9-b4c9-43e8-97be-2c1a7ff818ef\"}, {\"id\": \"227ce392-28d6-4c93-95f0-35d2adfa6848\"}, {\"id\": \"131c29fe-002e-4ae3-b759-2380e322e6d2\"}, {\"id\": \"db4ced8a-2e49-4e32-8d6a-95fde7cce017\"}, {\"id\": \"c036287d-ecc4-472c-9c3b-85bff8787923\"}, {\"id\": \"e32c9172-17bb-4271-8690-b7cf4dcab1c1\"}, {\"id\": \"21728555-a741-4230-abc9-8978265848e0\"}, {\"id\": \"c10da2a9-49eb-4b14-bda5-b46054b0ebd0\"}, {\"id\": \"a93bc22a-cfd4-4e86-b7c0-f466ae93cf2e\"}, {\"id\": \"9d5cda58-1fae-4bab-babb-3d7207e8db27\"}, {\"id\": \"74eeea59-8197-4bcd-b318-749740ba03cd\"}, {\"id\": \"bdbe1a17-74b1-4725-88a4-24729ab1124a\"}, {\"id\": \"0a72ab31-1d2d-4150-91ab-76e6664e1e22\"}, {\"id\": \"5c34b277-f4c9-46ae-a67b-3e1bea5cd9cd\"}, {\"id\": \"cae36540-c7c0-4c71-a7f6-0c3e4ab8fd45\"}, {\"id\": \"c9cc50b5-10b8-4b40-955c-4986a190554f\"}, {\"id\": \"372733ef-6a7d-4a7d-ab88-48e66da06ed2\"}, {\"id\": \"679c927d-6c5b-4b21-ad23-0432f1f48555\"}]}, \"children\": [{\"type\": \"component-inline-prop\", \"children\": [{\"text\": \"\"}]}], \"component\": \"imageGallery\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}]', '0786fa08-c8cc-4691-a53a-968f7879a992', 'f20bda4e-02ee-405d-bbc4-7b53f4ff9ad6', 'caccb1ce-91d7-4eb2-80df-78f944ffc25d'),
('4f069d57-ebc6-4202-9f2c-54c165972ce0', 'Contact', 'contact-us', '[{\"type\": \"component-block\", \"props\": {\"title\": null, \"backgroundImage\": {\"id\": \"8cce8a62-5c6b-11ee-89b2-0242ac110002\"}}, \"children\": [{\"type\": \"component-block-prop\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"Contact Us\"}]}], \"propPath\": [\"title\"]}], \"component\": \"titleHero\"}, {\"type\": \"background\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"Feel free to contact us at \"}, {\"href\": \"tel: (865) 366-3403\", \"type\": \"link\", \"children\": [{\"text\": \"(865) 366-3403\"}]}, {\"text\": \".\"}]}, {\"type\": \"component-block\", \"props\": {\"title\": null, \"content\": null}, \"children\": [{\"type\": \"component-block-prop\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}], \"propPath\": [\"title\"]}, {\"type\": \"component-block-prop\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}], \"propPath\": [\"content\"]}], \"component\": \"contactForm\"}], \"backgroundSettings\": {\"type\": \"color\", \"value\": \"#ffffff\", \"contrast\": \"light\", \"imageSettings\": {\"fixed\": false, \"repeating\": false}}}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}]', '0786fa08-c8cc-4691-a53a-968f7879a992', 'f20bda4e-02ee-405d-bbc4-7b53f4ff9ad6', 'caccb1ce-91d7-4eb2-80df-78f944ffc25d'),
('7f5722f4-3e16-4476-b384-66254e664fb6', 'Testing', 'testing', '[{\"type\": \"background\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"This is the content that I am doing\"}]}], \"backgroundSettings\": {\"type\": \"color\", \"fixed\": false, \"value\": \"#55AB32\", \"contrast\": \"light\"}}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}]', '0786fa08-c8cc-4691-a53a-968f7879a992', 'f20bda4e-02ee-405d-bbc4-7b53f4ff9ad6', NULL),
('866a1f88-2826-4944-9fb5-4f69d791f332', 'Crave Style', 'crave-style', '[{\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}, {\"type\": \"component-block\", \"props\": {\"title\": null, \"backgroundImage\": {\"id\": \"38908dfd-5c78-11ee-89b2-0242ac110002\"}}, \"children\": [{\"type\": \"component-block-prop\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"Crave Style\"}]}], \"propPath\": [\"title\"]}], \"component\": \"titleHero\"}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}]', '0786fa08-c8cc-4691-a53a-968f7879a992', 'f20bda4e-02ee-405d-bbc4-7b53f4ff9ad6', 'caccb1ce-91d7-4eb2-80df-78f944ffc25d'),
('caccb1ce-91d7-4eb2-80df-78f944ffc25d', 'About Us', 'about', '[{\"type\": \"paragraph\", \"children\": [{\"text\": \"This is the page about us\"}]}]', '0786fa08-c8cc-4691-a53a-968f7879a992', 'f20bda4e-02ee-405d-bbc4-7b53f4ff9ad6', NULL);

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

--
-- Table structure for table `Post`
--

CREATE TABLE `Post` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `content` json NOT NULL,
  `author` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `datePublished` datetime(3) DEFAULT CURRENT_TIMESTAMP(3),
  `keywords` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `featuredImage` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `excerpt` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Post`
--

INSERT INTO `Post` (`id`, `title`, `content`, `author`, `type`, `datePublished`, `keywords`, `featuredImage`, `slug`, `excerpt`) VALUES
('3e3e961e-6c73-4c25-9789-378d83ccc39a', 'Hello World', '[{\"type\": \"paragraph\", \"children\": [{\"text\": \"This is the content that is incredible to read. Reasons why:\"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"I wrote it\"}]}]}, {\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"You\'re reading it\"}]}]}, {\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"It is the \"}, {\"bold\": true, \"text\": \"first\", \"italic\": true}, {\"text\": \" post written\"}]}]}]}, {\"type\": \"layout\", \"layout\": [1, 1], \"children\": [{\"type\": \"layout-area\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"Pros of this\"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"I am here, you could be too\"}]}]}, {\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"This will nest\"}]}]}]}]}, {\"type\": \"layout-area\", \"children\": [{\"type\": \"paragraph\", \"children\": [{\"text\": \"Cons\"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"There isn\'t any, let\'s go\"}]}]}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}]}]', 'f3ebcd7f-810a-4056-a141-04815a20a2b9', '', '2023-09-30 02:10:20.995', '', '6303fed4-5c6a-11ee-89b2-0242ac110002', 'hello-world', 'This is the first post that has been written. It will explain why you should care/read it. It was written by the Titus Moore as a part of the initial crave build out. '),
('862142c7-d613-42b3-b7de-cb583510325f', 'Where to Bring your Group in Pigeon Forge ', '[{\"type\": \"paragraph\", \"children\": [{\"text\": \"Planning a family reunion, field trip, church outing, or special \\noccasion in Pigeon Forge, Tennessee? Great! We know you’ll have a blast \\nvisiting the mountains- but if you’re looking for activities the whole \\nfamily will enjoy, check these out! \"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://topjump.com/\", \"type\": \"link\", \"children\": [{\"text\": \"TopJump Trampoline and Extreme Arena\"}]}, {\"text\": \"\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Whether you’re celebrating a birthday or want to do an over-night \\nlock-in, TopJump throws some pretty amazing parties! Group rates start \\nwhen you have at least 10 people attending. Their expert party planners \\nwill take over so you can enjoy those special moments with family and \\nfriends. Play time, food, decorations, and party-planning services are \\nall included in your low rate, too! Wanna learn more? \"}, {\"href\": \"https://topjump.com/groups/\", \"type\": \"link\", \"children\": [{\"text\": \"Click here\"}]}, {\"text\": \"! \"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://lumberjackfeud.com\", \"type\": \"link\", \"children\": [{\"text\": \"Paula Deen’s Lumberjack Feud Supper Show\"}]}, {\"text\": \"\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Paula Deen\'s Lumberjack Feud Supper Show.  The most affordable dinner show in Pigeon Forge.  Groups.\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://lumberjackfeud.com\", \"type\": \"link\", \"children\": [{\"text\": \"Paula Deen’s Lumberjack Feud Supper Show\"}]}, {\"text\": \"\\n is the most affordable dinner show in Pigeon Forge, and is truly a \\nblast for all ages. Kick back and enjoy the show with your group and \\nexperience the lumberjack lifestyle for yourself at the \"}, {\"href\": \"https://lumberjackfeudadventurepark.com\", \"type\": \"link\", \"children\": [{\"text\": \"Adventure Park\"}]}, {\"text\": \"!\\n Group rates here begin with parties of 15 or more- perfect for that \\nfamily reunion you’ve been planning! The excitement that comes with \\nwatching world-class timbersports athletes is unmatched. You’ll create \\nmemories that will last a lifetime! \"}, {\"href\": \"https://lumberjackfeud.com/groups/\", \"type\": \"link\", \"children\": [{\"text\": \"Click this link\"}]}, {\"text\": \" to learn more about visiting Paula Deen’s Lumberjack Feud Supper Show with your crew! \"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://www.toyboxgolf.com/\", \"type\": \"link\", \"children\": [{\"text\": \"Toy Box Mini Golf\"}]}, {\"text\": \"\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Mini golf is a timeless family game, and the more the merrier! Toy Box Mini Golf opened in 2021 as the \"}, {\"text\": \"world’s first \", \"italic\": true}, {\"text\": \"toy-themed\\n mini golf course. And boy oh boy, is it AMAZING! Giant fighting robots \\nnever cease their battle next to a toppling block tower. Let your \\nimagination run wild with your group of 10 or more there! (Bonus- \\ncombine your group outing with a visit to TopJump next door and save \\n$$$). \"}, {\"href\": \"https://www.toyboxgolf.com/groups/\", \"type\": \"link\", \"children\": [{\"text\": \"Check them out here\"}]}, {\"text\": \" for booking information! \"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"Visit us! \"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Did you know we \"}, {\"text\": \"love \", \"italic\": true}, {\"text\": \"hosting groups? Crave Golf Club is the \\nperfect place to plan a party in Pigeon Forge. We combine indoor and \\noutdoor fun and make your day a breeze by planning out the details with \\nyou ahead of time! Learn more on our \"}, {\"href\": \"https://www.cravegolf.com/groups/\", \"type\": \"link\", \"children\": [{\"text\": \"groups page here\"}]}, {\"text\": \"! \"}]}]', 'b5741030-ebbe-4a88-aa8d-8ef6e94a1a23', '', '2022-10-11 04:00:00.000', '', '24a7fa5d-5c76-11ee-89b2-0242ac110002', 'where-to-bring-your-group-in-pigeon-forge', 'Planning a family reunion, field trip, church outing, or special \noccasion in Pigeon Forge, Tennessee? Great! We know you’ll have a blast \nvisiting the mountains- but if you’re looking for activities the whole \nfamily will enjoy, check these out! '),
('a0c071da-ba2a-46f9-9fba-0ca7fcadc4cd', 'Where to Shop in the Smokies', '[{\"type\": \"paragraph\", \"children\": [{\"text\": \"‘Tis the season to shop for holiday gifts for your loved ones! \\nShopping on vacation is way more fun than shopping at home- we can all \\nagree. While you’re on your winter trip to the Smoky Mountains, be sure \\nto support these small businesses in Sevier County where you’re sure to \\nfind everything on your list and more! \"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://coalminersdaughtermercantile.com/\", \"type\": \"link\", \"children\": [{\"text\": \"The Coal Miner’s Daughter Mercantile\"}]}, {\"text\": \"\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"This unique shop in Lumberjack Square is home to over 45 small \\nbusinesses! They welcome local vendors into their store to sell gifts \\nmade/ chosen with love and creativity. You’ll find everything from \\npersonalized tumblers to never-before-seen jewelry, to fashionable \\ncollars for your furry friends. We highly recommend stopping by- you \\nnever know what treasures are waiting inside! \"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Location: 2530 Parkway Pigeon Forge, TN inside Lumberjack Square\"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"Funky Bears Gift Shop\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Family owned and operated, Funky Bears Gift Shop has some of the most\\n unique and personable gifts we’ve seen around town! From the necessary \\nGSM souvenirs to fashionable daily wear, they’ve got it. We especially \\nlove their fun jewelry selection! \"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Location: 2530 Parkway Pigeon Forge, TN inside Lumberjack Square\"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://greatsmokyartsandcrafts.com/\", \"type\": \"link\", \"children\": [{\"text\": \"Great Smoky Arts & Crafts Community\"}]}, {\"text\": \"\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"“Hand Made in Gatlinburg, TN” is their motto and boy do they mean it!\\n In this quiet community you’ll find quilts, candles, leather goods, \\njewelry, and more \"}, {\"text\": \"all \", \"italic\": true}, {\"text\": \"hand made by local merchants! If you’re a one-of-a-kind gifter, this is the place to shop! \"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Location: 8-mile loop in Gatlinburg, TN. Follow GPS to “Arts and Crafts Village” and to Glades Road  \"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://www.baakboutique.com/\", \"type\": \"link\", \"children\": [{\"text\": \"BAAKK Boutique\"}]}, {\"text\": \"\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"This family-owned boutique has two convenient locations in \\nSevierville and Pigeon Forge! They specialize in women’s’ fashion. The \\nowner, April, always makes sure to have the trendiest pieces in stock so\\n you’ll never miss a fad. The staff is so helpful- you’ll feel at ease \\nshopping for the ladies in your life! \"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Location: 1732 Newport Hwy #13 Sevierville, TN \"}, {\"bold\": true, \"text\": \"and \"}, {\"text\": \"2655 Teaster Lane Ste 290 Pigeon Forge, TN in the Mountain Mile \"}]}, {\"type\": \"unordered-list\", \"children\": [{\"type\": \"list-item\", \"children\": [{\"type\": \"list-item-content\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://www.old-mill.com/pigeon-river-pottery/\", \"type\": \"link\", \"children\": [{\"text\": \"Pigeon River Pottery\"}]}, {\"text\": \"\"}]}]}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"If The Old Mill District is on your must-see list, stop by this shop \\nfor stunning hand-made pottery gifts. Your loved ones are sure to adore a\\n unique piece to add to their kitchen collection! The designs of the \\npottery mimic the beauty of the Smoky Mountains and are just as \\npractical as they are beautiful. \"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Location: 175 Old Mille Ave. Pigeon Forge, TN in The Old Mill District \"}]}, {\"type\": \"divider\", \"children\": [{\"text\": \"\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Above all, Christmas is about being with friends and family! We wish \\nyou a wonderful Christmas and hope you find everything you’re looking \\nfor at these small businesses in Sevier County! \"}]}]', 'b5741030-ebbe-4a88-aa8d-8ef6e94a1a23', '', '2022-11-23 05:00:00.000', '', '6303fed4-5c6a-11ee-89b2-0242ac110002', 'where-to-shop-in-the-smokies', '‘Tis the season to shop for holiday gifts for your loved ones! \nShopping on vacation is way more fun than shopping at home- we can all \nagree.'),
('ccb5b03c-4e09-4b40-9ce9-e3a53465e74c', 'Winter Activities in The Smokies', '[{\"type\": \"paragraph\", \"children\": [{\"text\": \"It’s the most wonderful time of the year! Visiting the Smokies in the\\n winter is magical; lights and decorations everywhere and, if we’re \\nlucky, snow-capped mountain views! There’s no shortage of fun things to \\ndo in the chilly weather. At Crave we have indoor mini-golf, \\nmini-bowling, AND escape rooms! So let’s get into it: here are a few of \\nour other favorite things! \"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"\"}, {\"href\": \"https://lumberjackfeud.com/\", \"type\": \"link\", \"children\": [{\"text\": \"Paula Deen’s Lumberjack Feud Show\"}]}, {\"text\": \"\\n is a great time, even in the winter! The grandstands are \\nclimate-controlled to ensure guests are comfortable no matter the \\ntemperature. The show is full of exciting timbersports and fun for the \\nwhole family. Experience Christmas at Lumberjack Feud through January 2,\\n 2020!\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"There’s no better way to stay warm than to work up a sweat playing at \"}, {\"href\": \"https://topjump.com/\", \"type\": \"link\", \"children\": [{\"text\": \"TopJump Trampoline & Extreme Arena\"}]}, {\"text\": \"!\\n With 30,000 square feet of indoor space filled with trampolines, a \\nclimbing area, dodgeball, and basketball, there’s something fun for \\neveryone there.\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Is a visit to Sevier County really complete without going to \"}, {\"href\": \"https://www.dollywood.com/themepark/Festivals/Smoky-Mountain-Christmas\", \"type\": \"link\", \"children\": [{\"text\": \"Dollywood\"}]}, {\"text\": \"?\\n We don’t think so! This time of year is so fun at Dollywood: 5 million \\ntwinkling lights fill the park and this year for the first time ever, \\nfireworks light up the sky for the Smoky Mountain Christmas.  \"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Ice skating is a must and at \"}, {\"href\": \"https://obergatlinburg.com/\", \"type\": \"link\", \"children\": [{\"text\": \"Ober Gatlinburg\"}]}, {\"text\": \",\\n you can! Immersing yourself in the Smokies is best here simply because \\nof the tram ride OR drive to the top! The views are unbeatable and the \\nactivities and fun are endless! Feeling more adventurous? Try out snow \\ntubing, snow skiing, or snowboarding on the only slopes in Tennessee!\"}]}, {\"type\": \"paragraph\", \"children\": [{\"text\": \"Be sure to add these things to your itinerary for your next visit to the Smokies! See y’all soon!\"}]}]', 'b5741030-ebbe-4a88-aa8d-8ef6e94a1a23', '', '2020-12-08 05:00:00.000', '', 'b64d64ce-5c77-11ee-89b2-0242ac110002', 'winter-activities-in-the-smokies', 'It’s the most wonderful time of the year! Visiting the Smokies in the\n winter is magical; lights and decorations everywhere and, if we’re \nlucky, snow-capped mountain views! ');

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

--
-- Table structure for table `Review`
--

CREATE TABLE `Review` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Reviewer` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `ReviewSource` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `ReviewContent` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `SocialMediaIcon`
--

CREATE TABLE `SocialMediaIcon` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `icon` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `SocialMediaIcon`
--

INSERT INTO `SocialMediaIcon` (`id`, `name`, `icon`, `url`) VALUES
('63402d3e-0df4-4d5a-a8e8-797e7cc8e3e0', 'Instagram', 'instagram', 'https://www.instagram.com/cravegolfclub/'),
('7ec95ead-ff65-45e1-b007-1169346e1722', 'Facebook', 'facebook', 'https://www.facebook.com/cravegolfclub'),
('8113dbb3-8a68-4c03-aa3d-5a154eafaca1', 'Yelp', 'yelp', 'https://www.yelp.com/biz/crave-golf-club-pigeon-forge'),
('9d50c5e5-fdc0-40c5-a0d6-9d400c13375b', 'Twitter', 'twitter', 'https://twitter.com/cravegolfclub'),
('bb1f53c0-901f-4e3e-92f4-a98ddaf2a480', 'Pinterest', 'pintrest', 'https://www.pinterest.com/cravegolfclub/'),
('f63589b7-43b2-4a28-871a-36016db9a7df', 'Trip Advisor', 'tripadvisor', 'https://www.tripadvisor.com/Attraction_Review-g55270-d12946805-Reviews-Crave_Golf_Club-Pigeon_Forge_Tennessee.html');

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

--
-- Table structure for table `Tag`
--

CREATE TABLE `Tag` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `Tag`
--

INSERT INTO `Tag` (`id`, `name`) VALUES
('73d3c74a-134c-481d-986d-d336251e73a9', 'December, 2020'),
('7f14a5cc-0599-4322-9cef-8716daa53646', 'October, 2022'),
('b012c591-bfa1-497e-9279-e6c51f9abc26', 'September, 2023');

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

--
-- Table structure for table `_Activity_sliderImages`
--

CREATE TABLE `_Activity_sliderImages` (
  `A` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `B` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_Activity_sliderImages`
--

INSERT INTO `_Activity_sliderImages` (`A`, `B`) VALUES
('bc102fda-5b61-4486-b914-b0e7929b0902', '455efad8-5c73-11ee-89b2-0242ac110002'),
('bc102fda-5b61-4486-b914-b0e7929b0902', '4913899e-5c6c-11ee-89b2-0242ac110002'),
('bc102fda-5b61-4486-b914-b0e7929b0902', '77aced20-5c78-11ee-89b2-0242ac110002'),
('bc102fda-5b61-4486-b914-b0e7929b0902', 'c0badc71-5c78-11ee-89b2-0242ac110002'),
('bc102fda-5b61-4486-b914-b0e7929b0902', 'c924de48-5c6a-11ee-89b2-0242ac110002');

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

--
-- Table structure for table `_Footer_friends`
--

CREATE TABLE `_Footer_friends` (
  `A` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `B` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_Footer_friends`
--

INSERT INTO `_Footer_friends` (`A`, `B`) VALUES
('0786fa08-c8cc-4691-a53a-968f7879a992', '100403c0-03fb-4f7c-b0d9-6af1a8334d63'),
('0786fa08-c8cc-4691-a53a-968f7879a992', '1dfdd28e-534c-4015-91da-f9067f8fac08'),
('0786fa08-c8cc-4691-a53a-968f7879a992', '38bc1c86-a13b-4049-a34d-919f76695eab'),
('0786fa08-c8cc-4691-a53a-968f7879a992', '53472833-2a78-46d9-8b30-79f45e8d4ff4'),
('0786fa08-c8cc-4691-a53a-968f7879a992', '7f92de0f-610a-4ef9-9a86-4487d4aa7fb4'),
('0786fa08-c8cc-4691-a53a-968f7879a992', '8508c2d6-3b5d-4a5f-b0e6-91f5d7541653'),
('0786fa08-c8cc-4691-a53a-968f7879a992', '96eab82e-6769-4153-81d0-882767ef2193'),
('0786fa08-c8cc-4691-a53a-968f7879a992', 'b0efc071-7e64-4e1c-a831-f9fd74c9874e');

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

--
-- Table structure for table `_Menu_menuItems`
--

CREATE TABLE `_Menu_menuItems` (
  `A` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `B` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_Menu_menuItems`
--

INSERT INTO `_Menu_menuItems` (`A`, `B`) VALUES
('6f91dcf2-c7a1-4e13-82b9-9640f2af7686', '0737bd9d-b862-41ee-a3c5-ae44fe5624dc'),
('6f91dcf2-c7a1-4e13-82b9-9640f2af7686', '7a43799d-70d4-4615-afad-ea015c77f30b'),
('6f91dcf2-c7a1-4e13-82b9-9640f2af7686', '9b03beda-1332-43b4-8b0f-98c1e2505fad'),
('6f91dcf2-c7a1-4e13-82b9-9640f2af7686', 'a7ec9b1f-4b2d-4e43-b025-909434502e13'),
('6f91dcf2-c7a1-4e13-82b9-9640f2af7686', 'c84d820a-921a-4880-8693-da5d48ccdbc4'),
('6f91dcf2-c7a1-4e13-82b9-9640f2af7686', 'fbef337c-aff2-4a20-8b82-846ffdacb19a');

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

--
-- Table structure for table `_Post_tags`
--

CREATE TABLE `_Post_tags` (
  `A` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `B` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_Post_tags`
--

INSERT INTO `_Post_tags` (`A`, `B`) VALUES
('ccb5b03c-4e09-4b40-9ce9-e3a53465e74c', '73d3c74a-134c-481d-986d-d336251e73a9'),
('862142c7-d613-42b3-b7de-cb583510325f', '7f14a5cc-0599-4322-9cef-8716daa53646'),
('3e3e961e-6c73-4c25-9789-378d83ccc39a', 'b012c591-bfa1-497e-9279-e6c51f9abc26');

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

--
-- Table structure for table `_SiteConfig_socialMedia`
--

CREATE TABLE `_SiteConfig_socialMedia` (
  `A` int NOT NULL,
  `B` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `_SiteConfig_socialMedia`
--

INSERT INTO `_SiteConfig_socialMedia` (`A`, `B`) VALUES
(1, '63402d3e-0df4-4d5a-a8e8-797e7cc8e3e0'),
(1, '7ec95ead-ff65-45e1-b007-1169346e1722'),
(1, '8113dbb3-8a68-4c03-aa3d-5a154eafaca1'),
(1, '9d50c5e5-fdc0-40c5-a0d6-9d400c13375b'),
(1, 'bb1f53c0-901f-4e3e-92f4-a98ddaf2a480'),
(1, 'f63589b7-43b2-4a28-871a-36016db9a7df');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Activity`
--
ALTER TABLE `Activity`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Activity_slug_key` (`slug`),
  ADD KEY `Activity_heroImage_idx` (`heroImage`),
  ADD KEY `Activity_featuredImage_idx` (`featuredImage`);

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

--
-- Indexes for table `Footer`
--
ALTER TABLE `Footer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Footer_friendsBackground_idx` (`friendsBackground`),
  ADD KEY `Footer_footerMenu_idx` (`footerMenu`),
  ADD KEY `Footer_tripAdvisorAward_idx` (`tripAdvisorAward`);

--
-- Indexes for table `Friend`
--
ALTER TABLE `Friend`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Friend_logo_idx` (`logo`);

--
-- Indexes for table `Header`
--
ALTER TABLE `Header`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Header_backgroundImage_idx` (`backgroundImage`),
  ADD KEY `Header_menu_idx` (`menu`);

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

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

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

--
-- Indexes for table `MenuItem`
--
ALTER TABLE `MenuItem`
  ADD PRIMARY KEY (`id`),
  ADD KEY `MenuItem_parent_idx` (`parent`);

--
-- Indexes for table `Page`
--
ALTER TABLE `Page`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Page_slug_key` (`slug`),
  ADD KEY `Page_header_idx` (`header`),
  ADD KEY `Page_footer_idx` (`footer`),
  ADD KEY `Page_parent_idx` (`parent`);

--
-- Indexes for table `Post`
--
ALTER TABLE `Post`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `Post_slug_key` (`slug`),
  ADD KEY `Post_author_idx` (`author`),
  ADD KEY `Post_featuredImage_idx` (`featuredImage`);

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

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

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

--
-- Indexes for table `_Activity_sliderImages`
--
ALTER TABLE `_Activity_sliderImages`
  ADD UNIQUE KEY `_Activity_sliderImages_AB_unique` (`A`,`B`),
  ADD KEY `_Activity_sliderImages_B_index` (`B`);

--
-- Indexes for table `_Footer_friends`
--
ALTER TABLE `_Footer_friends`
  ADD UNIQUE KEY `_Footer_friends_AB_unique` (`A`,`B`),
  ADD KEY `_Footer_friends_B_index` (`B`);

--
-- Indexes for table `_Menu_menuItems`
--
ALTER TABLE `_Menu_menuItems`
  ADD UNIQUE KEY `_Menu_menuItems_AB_unique` (`A`,`B`),
  ADD KEY `_Menu_menuItems_B_index` (`B`);

--
-- Indexes for table `_Post_tags`
--
ALTER TABLE `_Post_tags`
  ADD UNIQUE KEY `_Post_tags_AB_unique` (`A`,`B`),
  ADD KEY `_Post_tags_B_index` (`B`);

--
-- Indexes for table `_SiteConfig_socialMedia`
--
ALTER TABLE `_SiteConfig_socialMedia`
  ADD UNIQUE KEY `_SiteConfig_socialMedia_AB_unique` (`A`,`B`),
  ADD KEY `_SiteConfig_socialMedia_B_index` (`B`);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `Activity`
--
ALTER TABLE `Activity`
  ADD CONSTRAINT `Activity_featuredImage_fkey` FOREIGN KEY (`featuredImage`) REFERENCES `Image` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Activity_heroImage_fkey` FOREIGN KEY (`heroImage`) REFERENCES `Image` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `Footer`
--
ALTER TABLE `Footer`
  ADD CONSTRAINT `Footer_footerMenu_fkey` FOREIGN KEY (`footerMenu`) REFERENCES `Menu` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Footer_friendsBackground_fkey` FOREIGN KEY (`friendsBackground`) REFERENCES `Image` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Footer_tripAdvisorAward_fkey` FOREIGN KEY (`tripAdvisorAward`) REFERENCES `Image` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `Friend`
--
ALTER TABLE `Friend`
  ADD CONSTRAINT `Friend_logo_fkey` FOREIGN KEY (`logo`) REFERENCES `Image` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `Header`
--
ALTER TABLE `Header`
  ADD CONSTRAINT `Header_backgroundImage_fkey` FOREIGN KEY (`backgroundImage`) REFERENCES `Image` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Header_menu_fkey` FOREIGN KEY (`menu`) REFERENCES `Menu` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `MenuItem`
--
ALTER TABLE `MenuItem`
  ADD CONSTRAINT `MenuItem_parent_fkey` FOREIGN KEY (`parent`) REFERENCES `MenuItem` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `Page`
--
ALTER TABLE `Page`
  ADD CONSTRAINT `Page_footer_fkey` FOREIGN KEY (`footer`) REFERENCES `Footer` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Page_header_fkey` FOREIGN KEY (`header`) REFERENCES `Header` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Page_parent_fkey` FOREIGN KEY (`parent`) REFERENCES `Page` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `Post`
--
ALTER TABLE `Post`
  ADD CONSTRAINT `Post_author_fkey` FOREIGN KEY (`author`) REFERENCES `User` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `Post_featuredImage_fkey` FOREIGN KEY (`featuredImage`) REFERENCES `Image` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `_Activity_sliderImages`
--
ALTER TABLE `_Activity_sliderImages`
  ADD CONSTRAINT `_Activity_sliderImages_A_fkey` FOREIGN KEY (`A`) REFERENCES `Activity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `_Activity_sliderImages_B_fkey` FOREIGN KEY (`B`) REFERENCES `Image` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `_Footer_friends`
--
ALTER TABLE `_Footer_friends`
  ADD CONSTRAINT `_Footer_friends_A_fkey` FOREIGN KEY (`A`) REFERENCES `Footer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `_Footer_friends_B_fkey` FOREIGN KEY (`B`) REFERENCES `Friend` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `_Menu_menuItems`
--
ALTER TABLE `_Menu_menuItems`
  ADD CONSTRAINT `_Menu_menuItems_A_fkey` FOREIGN KEY (`A`) REFERENCES `Menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `_Menu_menuItems_B_fkey` FOREIGN KEY (`B`) REFERENCES `MenuItem` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `_Post_tags`
--
ALTER TABLE `_Post_tags`
  ADD CONSTRAINT `_Post_tags_A_fkey` FOREIGN KEY (`A`) REFERENCES `Post` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `_Post_tags_B_fkey` FOREIGN KEY (`B`) REFERENCES `Tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `_SiteConfig_socialMedia`
--
ALTER TABLE `_SiteConfig_socialMedia`
  ADD CONSTRAINT `_SiteConfig_socialMedia_A_fkey` FOREIGN KEY (`A`) REFERENCES `SiteConfig` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `_SiteConfig_socialMedia_B_fkey` FOREIGN KEY (`B`) REFERENCES `SocialMediaIcon` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

