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

START TRANSACTION;



--
-- Database: `pampertree`
--

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_100000_create_password_resets_table', 1),
(2, '2019_08_19_000000_create_failed_jobs_table', 1),
(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(4, '2022_08_09_095316_create_roles_table', 1),
(5, '2022_08_12_123305_create_pricing_levels_table', 1),
(6, '2022_08_12_123408_create_permissions_table', 1),
(7, '2022_10_12_095317_create_users_table', 1),
(8, '2022_08_16_090832_create_treatments_table', 2),
(10, '2022_08_16_101854_create_treatments_table', 3);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Basic access', '2022-08-12 07:31:16', '2022-08-12 07:31:16');

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

--
-- Table structure for table `pricing_levels`
--

CREATE TABLE `pricing_levels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pricing_levels`
--

INSERT INTO `pricing_levels` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'new', '2022-08-12 07:31:16', '2022-08-12 07:31:16');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', '2022-08-12 07:31:16', '2022-08-12 07:31:16'),
(2, 'Partner', '2022-08-12 07:31:16', '2022-08-12 07:31:16'),
(3, 'Staff', '2022-08-12 07:31:16', '2022-08-12 07:31:16'),
(4, 'User', '2022-08-12 07:31:16', '2022-08-12 07:31:16');

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

--
-- Table structure for table `treatments`
--

CREATE TABLE `treatments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `treatments`
--

INSERT INTO `treatments` (`id`, `parent_id`, `name`, `title`, `subtitle`, `description`, `slug`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 'Hair', 'Hairdressers and hair salons', 'Hair salons come in a variety of shapes and sizes. Whether you prefer to splurge on regular hair appointments or like to chop and change to suit your location and your budget, one thing is for certain - we all need a good trim every so often and a hair salon is the place to do it.', '', 'hairdressers-and-hair-salons', 'https://cdn1.treatwell.net/images/view/v2.i784911.w688.h458.xBCE32BC8.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(2, 0, 'Hair removal', 'Hair removal salons', 'Do you know your Brazilian from your Hollywood wax? Or the best way to rid your body of unwanted hair for good? Whether you\'re looking for long-term results or are content with your monthly wax sessions, a hair removal salon will cater to all your body hair needs under one roof.', '', 'hair-removal-salons', 'https://cdn1.treatwell.net/images/view/v2.i784914.w688.h318.xFFE1F5A1.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(3, 1, 'Ladies\' Haircuts', 'Ladies\' Haircuts', 'Never underestimate the power of a great haircut. Whether you\'re after a bob, layers or a buzzcut, using a combination of scissors, razorblades and even clippers, your hairdresser will help you to find your perfect look.', 'Never underestimate the power of a great haircut. From Jennifer Aniston’s ‘Rachel cut’ to Victoria Beckham’s famous bob, a killer cut has been known to make or break a celebrity\'s career in an instant and define the era they were created in. Using a combination of scissors, razorblades and even clippers, your hairdresser will help you to find your own signature haircut.\n\n                Today’s hair is no less newsworthy but thanks to social media, trends tend to come and go much faster than they did in Jennifer\'s Aniston\'s flicky, layered heyday. A quick look at Instagram will show you that choppy cuts with distressed, razored ends are very much the look of now. It\'s all about an undone edge and a cool girl vibe. Salon goers today prefer the ‘grown out’ look, a low-maintenance style that aims to create a care-free, just rolled out of bed effect (regardless of whether you’ve spent hours in the salon trying to perfect it!) over the precision cuts of the past.\n                \n                Like fashion, the world of hair has gone through many shifts and changes over the centuries. Popular hairstyles are constantly in flux, from the towering curls of the 70’s to the blown out perms of the 80’s, no look is complete without the perfect finishing touch of an on-trend haircut. Modern day styles have developed over time, and today there is less of a ‘one cut fits all’ method with the addition of a large variety of new techniques such as graduation, layering and blunt cuts (just to name a few), as well as a more relaxed and laid-back approach to styling. Today the rules are less rigid; people tend to go more bespoke when it comes to their haircut. Flexible, fashion forward hairdressers are able to come up with a style that perfectly compliments your unique look. Men’s haircuts are having a moment in the hairdressing world right now, and statistics show they’re spending more time than ever before perfecting their grooming routine. From fades to fusey’s (look it up!), spending time and money investing in the perfect cut is no longer just for women.\n\n                But regardless of how you choose to style your hair, nowadays, it seems as soon as we’ve got our head around one hair trend, there’s already another cropping up around the corner. So whether you visit your stylist religiously or only go for the chop once or twice a year - forget the fads for now. Sometimes all we really want is a good old trim, right?\n                \n                ', 'hairdressers-and-hair-salons', 'https://cdn1.treatwell.net/images/view/v2.i784911.w688.h458.xBCE32BC8.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(4, 1, 'Blow Dry', 'Blow Dry', 'Universally known as every girl\'s best friend, a salon blowdry uses a hairdryer to apply hot air to damp hair, leaving it soft, silky and frizz-free. Great for every hair type, a bouncy blowdry can transform your look in under 20 minutes, allowing you to achieve a texture that\'s near impossible with air or natural drying alone.', 'All hail the beloved blow dry - every girl’s best friend. Whether you do it yourself at home or splurge on weekly sessions with your stylist, everyone knows that a sleek and bouncy blow-dry can transform your look from drab to fab in under 20 minutes, not to mention put a serious spring in your step. A salon blow-dry uses a hairdryer to apply hot air to damp hair, which leaves it soft, sleek and frizz free. A texture that\'s near impossible to create with air or natural drying.\n\n                IS IT FOR ME?\n                Safe for every kind of hair, a good blow dry has the power to add a sleek sheen to even the driest of hair. It\'s not all about going straight and sleek though, if your hair is curly, a diffuser (a large circular device with brush-like teeth) can be attached to the end of the hairdryer and this will separate and add definition to your curls.\n                \n                So now you know that blow-dries can do much more than simply \'dry\' your hair. They can shape, sculpt, smooth and boost shine. Even if you were born with bone straight hair, a session with your stylist can have a huge impact on the condition and finish of your hair. The effects last up to a week, at which point you\'ll be dying to have another one! And if you really want to step it up a notch, you can go for a Brazilian or a Keratin blow-dry - these are chemical treatments designed to tame curly, frizzy hair or smooth wayward kinks. It also gives you a long-lasting shine rivalling any serum or shine spray.', 'hairdressers-and-hair-salons', 'https://cdn1.treatwell.net/images/view/v2.i784911.w688.h458.xBCE32BC8.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(5, 0, 'Massage', 'Massage Salons and Therapists', 'Tense, tight, muscles call for a massage. In the right hands your aches and pains can be massaged away within minutes. If you can’t seem to kick sore shoulders and aching joints, you need to get yourself to a massage salon, asap.', '', 'massage-salons-and-therapists', 'https://cdn1.treatwell.net/images/view/v2.i784915.w688.h467.x593C7D5F.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(6, 0, 'Nails', 'Nail salons and nail bars', 'Nail bars are the best. Go in feeling drab and un-groomed and come out looking like a million dollars. Yes, whether it\'s a quick shape and tidy, a full on set of gel nails or a bold, acrylic mani, nail salons have the power to transform your nails, and lift your mood!', '', 'nail-salons-and-nail-bars', 'https://cdn1.treatwell.net/images/view/v2.i784919.w688.h458.x11F61EC5.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(7, 0, 'Face', 'Face treatments', 'If you\'re searching for the perfect facial, many beauty salons offer a range of treatments that cater to your complexion. Filled with expertly trained staff to get to the bottom of any skin issue, booking in for a facial is an important first step to getting your skin back on track.', '', 'beauty-salons-face-treatments', 'https://cdn1.treatwell.net/images/view/v2.i784919.w688.h458.x11F61EC5.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(8, 0, 'Body', 'Body treatments', 'From tanning to exfoliation treatments, mud wraps to massages, if you\'re looking to treat your body to some serious pampering, booking into a beauty salon is the first step in your journey to utter relaxation.', '', 'beauty-salons-body-treatments', 'https://cdn1.treatwell.net/images/view/v2.i784919.w688.h458.x11F61EC5.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57'),
(9, 0, 'Men\'s', 'Men\'s treatments', '', '', 'men-s-treatments', 'https://cdn1.treatwell.net/images/view/v2.i784919.w688.h458.x11F61EC5.jpeg', '1', '2022-08-16 07:33:57', '2022-08-16 07:33:57');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pricing_levels`
--
ALTER TABLE `pricing_levels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `treatments`
--
ALTER TABLE `treatments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
COMMIT;

