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

START TRANSACTION;



--
-- Database: `webbbcosite`
--

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

--
-- Table structure for table `addons`
--

CREATE TABLE `addons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feature_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `installation` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `developmemt` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addons`
--

INSERT INTO `addons` (`id`, `creator_id`, `name`, `slug`, `short_description`, `full_description`, `feature_image`, `url`, `status`, `created_at`, `updated_at`, `installation`, `developmemt`) VALUES
(1, NULL, 'Demo 1', 'demo-1', '<ul class=\"mb-0\">\r\n<li>Version: <strong>1.10.1</strong></li>\r\n<li>Last updated: <strong>2 hours ago</strong></li>\r\n<li>Active installations: <strong>6,000+</strong></li>\r\n<li>PHP Version: <strong>5.6 or higher</strong></li>\r\n<li>Languages: <strong>English</strong></li>\r\n</ul>', '<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>', NULL, NULL, 1, '2019-08-24 10:27:45', '2019-08-24 10:27:45', '<p>when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>', NULL);

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

--
-- Table structure for table `addon_prices`
--

CREATE TABLE `addon_prices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `addon_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price_group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price` decimal(10,2) 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 `addon_prices`
--

INSERT INTO `addon_prices` (`id`, `addon_id`, `price_group_id`, `creator_id`, `price`, `created_at`, `updated_at`) VALUES
(1, 1, 4, NULL, '20.00', NULL, NULL),
(2, 1, 5, NULL, '30.00', NULL, NULL),
(3, 1, 6, NULL, '40.00', NULL, NULL);

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feature_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` tinyint(1) DEFAULT 0,
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'publish',
  `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 `categories`
--

INSERT INTO `categories` (`id`, `parent_id`, `user_id`, `sort_order`, `title`, `slug`, `feature_image`, `description`, `is_featured`, `type`, `meta_title`, `meta_keywords`, `meta_description`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 1, 0, 'Hotel', 'hotel', 'xJCGQS6GxCLfDPd2KHrTABYK0.png', '', NULL, 'template', 'Hotel', NULL, NULL, 'publish', '2019-08-24 09:30:59', '2019-08-24 09:30:59'),
(2, 0, 1, 0, 'Law', 'law', 'Pf0e1IOW7vp8Rg74mY93TIupo.png', '', NULL, 'template', 'Law', NULL, NULL, 'publish', '2019-08-24 09:31:12', '2019-08-24 09:31:12'),
(3, 0, 1, 0, 'Restaurant', 'restaurant', 'mQRkGMw9dVsfTtQGhs2ZvK66p.png', '', NULL, 'template', 'Restaurant', NULL, NULL, 'publish', '2019-08-24 09:31:40', '2019-08-24 09:31:40'),
(4, 0, 1, 0, 'Photography', 'photography', 'c7jCzzXq1sNNciTjn1v3ZkHfa.png', '', NULL, 'template', 'Photography', NULL, NULL, 'publish', '2019-08-24 09:32:01', '2019-08-24 09:32:01'),
(5, 0, 1, 0, 'Education', 'education', '4E5jsoj9vLmmmTZT89R4C0Ax6.png', '', NULL, 'template', 'Education', NULL, NULL, 'publish', '2019-08-24 09:32:19', '2019-08-24 09:32:19'),
(6, 0, 1, 0, 'Business', 'business', 'CMADGYzxcBLwyQegqo8wremR3.png', '', NULL, 'template', 'Business', NULL, NULL, 'publish', '2019-08-24 09:32:35', '2019-08-24 09:32:35'),
(7, 0, 1, 0, 'Health and Beauty', 'health-and-beauty', '0BkDJ7er4q82pkDOnqLx9rrn3.png', '', NULL, 'template', 'Health and Beauty', NULL, NULL, 'publish', '2019-08-24 09:33:01', '2019-08-24 09:33:01'),
(8, 0, 1, 0, 'Personal Services', 'personal-services', '6VgpTZbdmOQz5DZOVB8qJZFym.png', '', NULL, 'template', 'Personal Services', NULL, NULL, 'publish', '2019-08-24 09:33:20', '2019-08-24 09:33:20'),
(9, 0, 1, 0, 'Portfolio', 'portfolio', 'NX6egbGUQpRTWwwzZqMgs3lZn.png', '', NULL, 'template', 'Portfolio', NULL, NULL, 'publish', '2019-08-24 09:33:36', '2019-08-24 09:33:36'),
(10, 0, 1, 0, 'Dog', 'dog', 'SuRLCajW9lVjpGiQn4n1ZSvcn.jpg', '', NULL, 'template', 'Dog', NULL, NULL, 'publish', '2019-08-24 09:33:52', '2019-08-24 09:33:52');

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

--
-- Table structure for table `category_post`
--

CREATE TABLE `category_post` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `post_id` bigint(20) UNSIGNED DEFAULT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) 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
(40, '2019_08_07_065210_create_media_table', 1),
(41, '2019_08_07_065716_create_users_table', 1),
(42, '2019_08_07_070513_create_categories_table', 1),
(43, '2019_08_07_070726_create_password_rests_table', 1),
(44, '2019_08_07_071715_create_posts_table', 1),
(45, '2019_08_07_074234_create_category_post_table', 1),
(46, '2019_08_21_150850_create_prices_group_table', 1),
(47, '2019_08_22_163210_create_templates_table', 1),
(48, '2019_08_22_183106_create_template_prices_table', 1),
(49, '2019_08_23_182056_create_addons_table', 1),
(50, '2019_08_24_044313_create_addon_prices_table', 1),
(51, '2019_08_24_055020_create_websites_table', 1),
(52, '2019_08_24_060337_create_packages_table', 1),
(53, '2019_08_24_060355_create_package_prices_table', 1);

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feature_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `package_prices`
--

CREATE TABLE `package_prices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price_group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feature_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `template` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'detail-page',
  `type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'publish',
  `is_featured` tinyint(1) DEFAULT 0,
  `is_home` int(11) DEFAULT 0,
  `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 `posts`
--

INSERT INTO `posts` (`id`, `parent_id`, `creator_id`, `sort_order`, `title`, `slug`, `url`, `feature_image`, `short_description`, `full_description`, `meta_title`, `meta_keywords`, `meta_description`, `template`, `type`, `status`, `is_featured`, `is_home`, `created_at`, `updated_at`) VALUES
(1, NULL, 1, NULL, 'About Us', 'about-us', NULL, 'wtbiLb3YwFpa6sC1e3eDO0RjJ.jpg', '', '&lt;h1 class=&quot;works-section-title&quot;&gt;Choose a Template&lt;/h1&gt;\r\n&lt;p class=&quot;works-section-para&quot;&gt;We have hundreds of stunning ready-made template to choose.We have hundreds of stunning ready-made template to choose.We have hundreds of stunning ready-made template to choose&lt;/p&gt;', 'About', NULL, NULL, 'about-page', 'page', 'publish', NULL, NULL, '2019-08-24 08:26:14', '2019-08-24 08:35:40'),
(3, NULL, 1, NULL, 'Contact Us', 'contact-us', NULL, NULL, '', '&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span class=&quot;font-size-20 font-color-white font-weight-700&quot;&gt;Address&lt;/span&gt;\r\n&lt;p class=&quot;font-color-white&quot;&gt;Moda Center Hudson st,&lt;br /&gt; New York, NY US&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span class=&quot;font-size-20 font-color-white font-weight-700&quot;&gt;Let&#039;s Talk&lt;/span&gt;\r\n&lt;p class=&quot;font-color-03a9f5&quot;&gt;+92123456789&lt;/p&gt;\r\n&lt;/div&gt;\r\n&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;span class=&quot;font-size-20 font-color-white font-weight-700&quot;&gt;General Support&lt;/span&gt;\r\n&lt;div&gt;&lt;a href=&quot;#&quot;&gt;contact@bizinaweb.com&lt;/a&gt;&lt;/div&gt;\r\n&lt;/div&gt;', 'Contact Us', NULL, NULL, 'contact-page', 'page', 'publish', NULL, NULL, '2019-08-24 09:13:12', '2019-08-24 09:13:12'),
(4, NULL, 1, NULL, 'Domain', 'domain', NULL, NULL, '', '', 'Domain', NULL, NULL, 'domain-page', 'page', 'publish', NULL, NULL, '2019-08-24 09:20:49', '2019-08-24 09:20:49');

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

--
-- Table structure for table `prices_group`
--

CREATE TABLE `prices_group` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` tinyint(4) DEFAULT 0,
  `status` tinyint(4) DEFAULT 1,
  `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 `prices_group`
--

INSERT INTO `prices_group` (`id`, `creator_id`, `name`, `slug`, `type`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Template Week 1 Price', 'template-week-1', 1, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(2, NULL, 'Template Week 2 Price', 'template-week-2', 1, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(3, NULL, 'Template Week 3 Price', 'template-week-3', 1, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(4, NULL, 'Addon Week 1 Price', 'addon-week-1', 0, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(5, NULL, 'Addon Week 2 Price', 'addon-week-2', 0, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(6, NULL, 'Addon Week 3 Price', 'addon-week-3', 0, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(7, NULL, 'Package Week 1 Price', 'package-week-1', 2, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(8, NULL, 'Package Week 2 Price', 'package-week-2', 2, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55'),
(9, NULL, 'Package Week 3 Price', 'package-week-3', 2, 1, '2019-08-24 08:08:55', '2019-08-24 08:08:55');

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feature_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT 1,
  `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 `templates`
--

INSERT INTO `templates` (`id`, `category_id`, `creator_id`, `name`, `slug`, `short_description`, `full_description`, `feature_image`, `url`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'Build Your Site', 'build-your-site', '<ul class=\"portfolio-meta\">\r\n<li>Price $</li>\r\n<li>Created by John Doe</li>\r\n<li>Completed on 17 Oct 2016</li>\r\n<li>Skills HTML5 / PHP / CSS3</li>\r\n<li>Share</li>\r\n</ul>', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus malesuada justo quis libero interdum laoreet. Nulla in felis tortor. Mauris suscipit imperdiet dictum. Cras posuere laoreet consequat. Phasellus vel luctus mauris. Praesent ac neque a nunc vehicula ornare. Cras eget diam ac erat commodo aliquet.</p>\r\n<p>Nam tincidunt risus sed tortor feugiat, vulputate rhoncus urna hendrerit. Donec quis est vehicula, fermentum lorem vel, convallis velit. Sed imperdiet ut ligula id condimentum. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Ut tincidunt dui neque, id venenatis neque facilisis vitae. Aliquam facilisis fermentum neque et finibus. Vivamus rhoncus sem quis fermentum pulvinar. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce aliquam, est sed aliquet accumsan, nisl risus dapibus turpis, in venenatis erat arcu quis diam. Vestibulum imperdiet rhoncus varius. Nunc porta molestie nisl, et commodo felis tristique in. Sed non commodo arcu, ut accumsan diam. Aliquam eu dolor nibh. Fusce orci felis, sollicitudin placerat nulla ac, scelerisque mattis neque. In ultrices magna nec convallis iaculis. Nulla fringilla ultricies lorem.</p>\r\n<p>Curabitur id mi turpis. In laoreet dignissim interdum. Curabitur nec euismod libero, sit amet convallis nibh. Vivamus imperdiet sodales elit et dignissim. Ut gravida, sem at suscipit mattis, ante ex hendrerit dolor, in hendrerit mauris libero eu elit. Nullam id purus suscipit, rutrum arcu ut, sagittis erat. Praesent mi ligula, egestas sit amet commodo venenatis, finibus ac sapien. Praesent suscipit mauris ut metus ornare pharetra. Etiam tincidunt ante molestie elit porta accumsan. Phasellus blandit dui purus, in rutrum risus fringilla sed. Nunc tincidunt nunc nec sapien scelerisque, non luctus sem convallis. Cras ac nisl ac nulla aliquet sodales eget sed turpis. Morbi mattis varius auctor. Nam vel ante mauris. Nam vel malesuada sapien. Etiam pharetra interdum massa iaculis vehicula.</p>', 'HwI09n3xZWNCAmF6jfPPb5GZV.jpg', NULL, 1, '2019-08-24 09:39:25', '2019-08-24 10:17:30');

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

--
-- Table structure for table `template_prices`
--

CREATE TABLE `template_prices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `template_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price_group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `creator_id` bigint(20) UNSIGNED DEFAULT NULL,
  `price` decimal(10,2) 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 `template_prices`
--

INSERT INTO `template_prices` (`id`, `template_id`, `price_group_id`, `creator_id`, `price`, `created_at`, `updated_at`) VALUES
(7, 1, 1, NULL, '52.00', NULL, NULL),
(8, 1, 2, NULL, '20.00', NULL, NULL),
(9, 1, 3, NULL, '30.00', NULL, NULL);

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

--
-- Table structure for table `websites`
--

CREATE TABLE `websites` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `domain` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `phone` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_line_1` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_line_2` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `addon_prices`
--
ALTER TABLE `addon_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `addon_prices_addon_id_foreign` (`addon_id`),
  ADD KEY `addon_prices_price_group_id_foreign` (`price_group_id`),
  ADD KEY `addon_prices_creator_id_foreign` (`creator_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_user_id_foreign` (`user_id`);

--
-- Indexes for table `category_post`
--
ALTER TABLE `category_post`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_post_creator_id_foreign` (`creator_id`),
  ADD KEY `category_post_post_id_foreign` (`post_id`),
  ADD KEY `category_post_category_id_foreign` (`category_id`);

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

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

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

--
-- Indexes for table `package_prices`
--
ALTER TABLE `package_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_prices_package_id_foreign` (`package_id`),
  ADD KEY `package_prices_price_group_id_foreign` (`price_group_id`),
  ADD KEY `package_prices_creator_id_foreign` (`creator_id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `posts_creator_id_foreign` (`creator_id`);

--
-- Indexes for table `prices_group`
--
ALTER TABLE `prices_group`
  ADD PRIMARY KEY (`id`),
  ADD KEY `prices_group_creator_id_foreign` (`creator_id`);

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

--
-- Indexes for table `template_prices`
--
ALTER TABLE `template_prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `template_prices_template_id_foreign` (`template_id`),
  ADD KEY `template_prices_price_group_id_foreign` (`price_group_id`),
  ADD KEY `template_prices_creator_id_foreign` (`creator_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  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=54;

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `addon_prices`
--
ALTER TABLE `addon_prices`
  ADD CONSTRAINT `addon_prices_addon_id_foreign` FOREIGN KEY (`addon_id`) REFERENCES `addons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `addon_prices_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `addon_prices_price_group_id_foreign` FOREIGN KEY (`price_group_id`) REFERENCES `prices_group` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_post`
--
ALTER TABLE `category_post`
  ADD CONSTRAINT `category_post_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_post_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_post_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `package_prices`
--
ALTER TABLE `package_prices`
  ADD CONSTRAINT `package_prices_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_prices_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_prices_price_group_id_foreign` FOREIGN KEY (`price_group_id`) REFERENCES `prices_group` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `posts`
--
ALTER TABLE `posts`
  ADD CONSTRAINT `posts_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `prices_group`
--
ALTER TABLE `prices_group`
  ADD CONSTRAINT `prices_group_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `template_prices`
--
ALTER TABLE `template_prices`
  ADD CONSTRAINT `template_prices_creator_id_foreign` FOREIGN KEY (`creator_id`) REFERENCES `app_users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `template_prices_price_group_id_foreign` FOREIGN KEY (`price_group_id`) REFERENCES `prices_group` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `template_prices_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE CASCADE;
COMMIT;

