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

START TRANSACTION;



--
-- Database: `sow_app_db`
--

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

--
-- Table structure for table `belonging`
--

CREATE TABLE `belonging` (
  `belonging_id` bigint(20) UNSIGNED NOT NULL,
  `belonging_client_id` int(10) UNSIGNED NOT NULL,
  `belonging_type` enum('category','sub_category','question') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('created','edited','hidden','deleted') COLLATE utf8mb4_unicode_ci NOT NULL,
  `belonging_new_type_id` int(10) UNSIGNED DEFAULT NULL,
  `edited_hidden_deleted_old_type_id` int(10) UNSIGNED DEFAULT NULL,
  `customized_for_client` int(11) DEFAULT NULL,
  `belonging_created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `belonging_updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `categorie_id` bigint(20) UNSIGNED NOT NULL,
  `categorie_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_categorie_active` tinyint(1) NOT NULL DEFAULT 1,
  `categorie_isDefault` tinyint(1) NOT NULL DEFAULT 1,
  `categorie_created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `categorie_updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`categorie_id`, `categorie_name`, `is_categorie_active`, `categorie_isDefault`, `categorie_created_at`, `categorie_updated_at`) VALUES
(1, 'Sitewide Creative', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(2, 'Global Elements', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(3, 'Core Ecommerce Pages', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(4, 'Advanced Ecommerce Features', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(5, 'Brand Pages', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(6, 'Development Environment Setup', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(7, 'Launch and Post-launch', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(8, 'Measurement and Conversion Optimization', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(9, 'Consulting Services', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01');

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

--
-- Table structure for table `client_requirements`
--

CREATE TABLE `client_requirements` (
  `client_requirement_id` bigint(20) UNSIGNED NOT NULL,
  `client_requirement_site` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_requirement_question_checks` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `price_id` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `client_id` int(10) UNSIGNED NOT NULL,
  `client_requirement_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `client_requirement_created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `client_requirement_updated_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
(1607, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(1608, '2022_02_09_135232_create_clients_table', 1),
(1609, '2022_02_10_102928_create_sessions_table', 1),
(1610, '2022_02_11_141351_create_questions_table', 1),
(1611, '2022_02_11_142554_create_sub_categories_table', 1),
(1612, '2022_02_11_143153_create_categories_table', 1),
(1613, '2022_02_11_143724_create_prices_table', 1),
(1614, '2022_02_16_150612_create_client_requirements_table', 1),
(1615, '2022_02_22_101219_create_belonging_table', 1);

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

--
-- Table structure for table `prices`
--

CREATE TABLE `prices` (
  `price_id` bigint(20) UNSIGNED NOT NULL,
  `price` double(8,2) UNSIGNED NOT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price_isDefault` tinyint(1) NOT NULL DEFAULT 0,
  `client_id` int(10) UNSIGNED DEFAULT NULL,
  `price_created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `price_updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` (`price_id`, `price`, `currency`, `currency_symbol`, `price_isDefault`, `client_id`, `price_created_at`, `price_updated_at`) VALUES
(1, 20.00, 'USD', '$', 1, NULL, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(2, 20.00, 'USD', '$', 0, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(3, 20.00, 'USD', '$', 0, 2, '2022-03-09 10:52:01', '2022-03-09 10:52:01');

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `question_id` bigint(20) UNSIGNED NOT NULL,
  `question_name` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `question_design_hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question_development_hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question_others_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `question_is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sub_categorie_id` int(10) UNSIGNED NOT NULL,
  `categorie_id` int(10) UNSIGNED NOT NULL,
  `question_isDefault` tinyint(1) NOT NULL DEFAULT 1,
  `question_created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `question_updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`question_id`, `question_name`, `question_design_hours`, `question_development_hours`, `question_others_time`, `question_is_active`, `sub_categorie_id`, `categorie_id`, `question_isDefault`, `question_created_at`, `question_updated_at`) VALUES
(1, 'Translate clients brand visual identity and strategic vision into two different concepts. After this presentation, we\'ll move into detailed design of each page and feature, as outlined below.', '16', '0', '0', 1, 1, 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(2, 'Photography guidelines for product imagery, editorial blocks, and any graphical elements. Option to be shot in-house or handed off to contracted photographer.', '4', '0', '0', 1, 2, 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(3, 'Contains logo, brand mark, navigational links, cart button, (and/or search field, account links)', '2', '4', '0', 1, 3, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(4, 'Announcement bar', '0.5', '2', '0', 1, 3, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(5, 'Sticky header', '0.5', '2', '0', 1, 3, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(6, 'Mega menu', '4', '8', '0', 1, 3, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(7, 'Contains logo, brand mark, navigational links, customer service info, (and/or search field)', '2.5', '2', '0', 1, 4, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(8, 'Newsletter signup', '0.5', '1', '0', 1, 4, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(9, 'Klaviyo newsletter signup integration', '0.5', '3', '0', 1, 4, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(10, 'Pop-up newsletter that reveals after a visitor has landed on the site for more than 5 seconds, or scrolled pass above the fold. Registers close button click and resets to reveal after 7 days', '1.5', '1', '0', 1, 5, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(11, 'Klaviyo integration', '0', '0.5', '0', 1, 5, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(12, 'MailChimp integration', '0', '0.5', '0', 1, 5, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(13, 'Confirm cookie acceptance in compliance to CCPA and GDPR policies', '1', '1', '0', 1, 6, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(14, 'A place to house site-wide announcements or sales', '0.5', '2', '0', 1, 7, 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(15, 'Up to 5 custom fully-editable and sortable content sections', '18', '22', '0', 1, 8, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(16, 'Up to 8 custom fully-editable and sortable content sections', '27', '31', '0', 1, 8, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(17, 'Branded collection hero and product grid that includes the items various states (sold out, discount)', '4', '4', '0', 1, 9, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(18, 'Product quick-add with multiple variants (and/or color swatches)', '1', '4', '0', 1, 9, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(19, 'Product image states that changes on hover or color swatches', '0', '1', '0', 1, 9, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(20, 'Pop-up quick-shop module', '2', '6', '0', 1, 9, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(21, 'Product filter and sorting', '2', '8', '0', 1, 9, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(22, 'Editable content', '0', '4', '0', 1, 9, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(23, 'An index of Collections rather than Products.', '4', '4', '0', 1, 10, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(24, 'Image slider, product details, product pricing states (original, discounted price, sold out), add to cart button, variant selector, related products (manual or pulls from the same collection)', '6', '8', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(25, 'Quantity selector (choose between selector or +/- buttons)', '0.5', '0.5', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(26, 'Text based charts (e.g. size chart, nutrition label)', '1', '2', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(27, 'Ability to add video in gallery', '0.5', '0.5', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(28, 'Ability to zoom in gallery (optional to open up lightbox)', '0.5', '2', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(29, 'Sticky add to cart bar', '1.5', '1', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(30, 'Product reviews (Yotpo, Okendo, or Shopify product reviews)', '1', '4', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(31, 'Recently viewed / Recommended products', '1', '4', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(32, 'Product badging system (e.g. best seller, exclusive)', '0.5', '1', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(33, 'Product back in stock notifications (integration with a back in stock app or Klaviyo notifications)', '1', '2', '0', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(34, 'Advanced related product logic: if/else statements, exclusion of certain collections, surfacing related variants...etc (more discovery needed)', 'VARIES', 'VARIES', 'VARIES', 1, 11, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(35, 'Search field in header + search with empty and results page for products', '3', '6', '0', 1, 12, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(36, 'Search results on type (smart result function)', '0.5', '3', '0', 1, 12, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(37, 'Cart item + summary, and call to action for checkout', '4', '4', '0', 1, 13, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(38, 'Cart slide out that contains always up to date cart items, with the ability to adjust product quantity or remove product entirely', '3', '6', '0', 1, 13, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(39, 'Ability to add gift wrapping (with the option to charge customers an additional price)', '0.5', '2', '0', 1, 13, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(40, 'Ability to add cart note', '0.5', '2', '0', 1, 13, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(41, 'Free shipping progress bar (by animating a meter that fills in proportion with the cart value, we can incentivise higher cart values to unlock free shipping)', '0.5', '3', '0', 1, 13, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(42, 'In-cart product up-sell', '2', '4', '0', 1, 13, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(43, 'Login, signup, and password recovery state', '2', '4', '0', 1, 14, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(44, 'Customer address page', '1', '2', '0', 1, 14, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(45, 'Customer order history page', '1', '2', '0', 1, 14, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(46, 'Light styling updates to make on-brand with logo and color', '0', '0.5', '0', 1, 15, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(47, 'Shopify plus checkout customization (More discovery needed)', 'VARIES', 'VARIES', 'VARIES', 1, 15, 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(48, 'Integation with ZenDesk, Tidio, Gorgias', '0', '0.5', '0', 1, 16, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(49, 'Utilizing Shopify\'s native gift card capability', '1', '4', '0', 1, 17, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(50, 'Integration on product single page', '1.5', '3.5', '0', 1, 18, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(51, 'Cross-integration with product quick-add', '0', '4', '0', 1, 18, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(52, 'Cart page line item with description or highlighted state', '0.5', '1', '0', 1, 18, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(53, 'Subscription portal', 'VARIES', 'VARIES', 'VARIES', 1, 18, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(54, 'Integration with Wishlist King and wishlist add/remove button on product listing and single page', '2', '8', '0', 1, 19, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(55, 'Integration with Yotpo, Smile.io, Rise, or Conjured', '2', '8', '0', 1, 20, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(56, 'Integrate with Refersion to create an afflilate signup page, share unique affiliate tracking links, and configure commissions per each affiliate sale', '2', '8', '0', 1, 21, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(57, 'Integration with Klarna or Afterpay', '0.5', '2', '0', 1, 22, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(58, 'Cross-integration with product quick-add', '0', '2', '0', 1, 22, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(59, 'Integrate the Destini product locator widget onto a page, allowing customers to search your products by physical location (integration only – Destini setup, data entry/upkeep, etc. is out of scope)', '1', '4', '0', 1, 23, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(60, 'Integration with ShipScout', '0', '3', '0', 1, 24, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(61, 'More discovery needed', 'VARIES', 'VARIES', 'VARIES', 1, 25, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(62, 'example of use cases: featured products, specific product lines', 'VARIES', 'VARIES', 'VARIES', 1, 26, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(63, 'example of use cases: featured products, specific product lines', 'VARIES', 'VARIES', 'VARIES', 1, 27, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(64, 'More discovery needed', 'VARIES', 'VARIES', 'VARIES', 1, 28, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(65, 'More discovery needed', 'VARIES', 'VARIES', 'VARIES', 1, 29, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(66, 'More discovery needed', 'VARIES', 'VARIES', 'VARIES', 1, 30, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(67, 'More discovery needed', 'VARIES', 'VARIES', 'VARIES', 1, 31, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(68, 'More discovery needed', 'VARIES', 'VARIES', 'VARIES', 1, 32, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(69, 'Designed specifically to convert users coming in from online ads, these pages may be themed to allign with certain campaigns', 'VARIES', 'VARIES', 'VARIES', 1, 33, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(70, 'Specify', 'VARIES', 'VARIES', 'VARIES', 1, 34, 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(71, 'Up to 3 custom fully-editable and content sections', '6', '8', '0', 1, 35, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(72, 'Contact form with customer service information with submit success and error state. The alternative is to use a simple email/mailto link for contact buttons.', '4', '4', '0', 1, 36, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(73, 'Dedicated page for subscription, includes 3 section: intro, buy element and additional description', '8', '6', '0', 1, 37, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(74, 'Questions and answers with the ability to group and section faqs', '2', '4', '0', 1, 38, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(75, 'Ability to search within the FAQ page', '0.5', '2', '0', 1, 38, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(76, 'Standard text page with content editable using the wysiwyg editor in admin. Used to host privacy policy, terms of service..etc pages', '1', '1', '0', 1, 39, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(77, 'Page not found, with a link back to shop or homepage', '1', '1', '0', 1, 40, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(78, 'Featured article and additional articles in list or grid style with thumbnail and non-thumbnail states', '4', '4', '0', 1, 41, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(79, 'Article filtering', '1', '4', '0', 1, 41, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(80, 'Article featured image, content, and related articles', '4', '6', '0', 1, 42, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(81, 'Product up-sell, and editorial blocks', '2', '6', '0', 1, 42, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(82, 'Product or brand testimonials with image, quote, and byline, in grid or slider format', '4', '6', '0', 1, 43, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(83, 'A separate page or module to highlight the press received', '4', '4', '0', 1, 44, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(84, 'Specify', 'VARIES', 'VARIES', 'VARIES', 1, 45, 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(85, 'Set up store to production', '0', '2', '0', 1, 46, 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(86, 'For stores with existing content and product setup.', '0', '2', '0', 1, 47, 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(87, 'Development store', '0', '2', '0', 1, 48, 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(88, 'More discovery needed', 'VARIES', 'VARIES', 'VARIES', 1, 49, 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(89, 'Launch assessment + DNS config', '0', '0', '1', 1, 50, 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(90, 'Post-launch 30-day bug support', '0', '0', '0', 1, 51, 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(91, 'Post-launch remote training', '0', '0', '1', 1, 52, 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(92, 'Site management guide', '0', '0', '2', 1, 53, 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(93, 'Default integration', '0', '0', '0', 1, 54, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(94, 'Default integration', '0', '2', '2', 1, 55, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(95, 'Default integration', '0', '0', '0', 1, 56, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(96, 'Default integration', '0', '1', '0', 1, 57, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(97, 'Default integration', '0', '0', '0', 1, 58, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(98, 'Ecommerce events', '0', '0', '0', 1, 58, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(99, 'Advanced integration with custom events', 'VARIES', 'VARIES', 'VARIES', 1, 58, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(100, 'Custom reporting dashboards (data visualizations to group and view your data at a glance)', 'VARIES', 'VARIES', 'VARIES', 1, 58, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(101, 'Setup: Google Optimize integration, analyze past thirty days of data to identify pain points and opportunites to boost conversion', '0', '0.5', '8', 1, 59, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(102, 'Planning: Create bank of hypotheses detailed with supporting data, estimated business impact, dev effort, etc. to review with client team', '0', '0', '6', 1, 59, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(103, 'Implementation and management: Prioritize test ideas, establish cadence (depending on web traffic volume and retainer hours) for tests/month, analyze and share results, put winners into production.', 'VARIES', 'VARIES', 'VARIES', 1, 59, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(104, 'Silo marketing./landing pages (in collaboration with your growth agency) to pair with your advertisements', 'VARIES', 'VARIES', 'VARIES', 1, 60, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(105, 'Strategy, creative planning, art direction, and asset production for varied advertising mediums', 'VARIES', 'VARIES', 'VARIES', 1, 61, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(106, 'Sitemap updates, keyword research and meta content development, 301 redirections', 'VARIES', 'VARIES', 'VARIES', 1, 62, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(107, 'Using Google Lighthouse for measurement', 'VARIES', 'VARIES', 'VARIES', 1, 63, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(108, 'Specify', 'VARIES', 'VARIES', 'VARIES', 1, 64, 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(109, '- High level technical strategy approach\n            - User journey mapping\n            - Unique growth opportunities to leverage\n            - Tactical plan across merchandising, product discovery, retention/loyalty, and CRO\n            - Measurable KPIs\n            - Feature and future state roadmapping \n            - Summary of growth model and budget (development under separate line item)\n            - Assortment strategy', '0', '0', '24', 1, 65, 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(110, '- Lightweight projection model for Year 1-3 including estimated expenses, investment and target growth trajectory (Requires key inputs and collaboration with brand team related to COGs, assumptions around brand-level marketing, resourcing, and operational expectations). \n\n            - Provide a 3-year financial summary in flexible revenue & expense format and a detailed view by month baking in key assumptions tied to strategy, goals, expected investment, and roadmap.', '0', '0', '1', 1, 66, 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(111, 'Work with brand stakeholders to define necessary business logic and processes around inventory management, order management, fulfillment/logistics, returns management, and customer support as it relates to DTC.\n\n            - Act as an advisor to support definement of process and business needs/logic (keeping in mind short v. long term plans)\n            - Advise on development of key policies needed for customer presentation on site\n            - Facilitate linking operational needs to end ecommerce experience, working towards proper expectation setting for customers\n            - Advise on packaging changes and future opportunities\n            - Identify additional third party needs\n            - Light advisory support through ERP integration to ensure Shopify to ERP integrations match business requirements', '0', '0', '24', 1, 67, 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(112, 'Strategic approach, defining key workflows & staffing solutions.', '0', '0', '24', 1, 68, 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `sub_categorie_id` bigint(20) UNSIGNED NOT NULL,
  `sub_categorie_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categorie_id` int(10) UNSIGNED NOT NULL,
  `sub_categorie_isDefault` tinyint(1) NOT NULL DEFAULT 1,
  `sub_categorie_created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `sub_categorie_updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`sub_categorie_id`, `sub_categorie_name`, `categorie_id`, `sub_categorie_isDefault`, `sub_categorie_created_at`, `sub_categorie_updated_at`) VALUES
(1, 'Creative concepting', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(2, 'Product photography guide', 1, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(3, 'Header', 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(4, 'Footer', 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(5, 'Pop-up newsletter signup module', 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(6, 'Cookies Notice', 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(7, 'Fixed Announcement Bar', 2, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(8, 'Homepage', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(9, 'Product listing page (collection page)', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(10, 'Collection listing page', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(11, 'Product single page', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(12, 'Search', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(13, 'Cart page', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(14, 'Account pages', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(15, 'Branded checkout flow', 3, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(16, 'Live chat', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(17, 'Gift card page', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(18, 'Product subscriptions', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(19, 'Wishlist', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(20, 'Refer a friend', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(21, 'Affiliate programs', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(22, 'Buy now, pay later', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(23, 'Store locator', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(24, 'A/B Test shipping rates', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(25, 'Wholesale', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(26, 'Product listing page (additional)', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(27, 'Product single page (additional)', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(28, 'Product engraving and/or customization', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(29, 'User generated content', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(30, 'Advanced cross-sell', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(31, 'Bundle builder', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(32, 'Custom product finder', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(33, 'Ad landing page', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(34, 'OTHERS - client to specify', 4, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(35, 'About page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(36, 'Contact page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(37, 'Subscribe and Save page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(38, 'FAQ page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(39, 'General page template', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(40, '404 page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(41, 'Blog index page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(42, 'Blog single page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(43, 'Testimonials page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(44, 'Press page', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(45, 'OTHERS - client to specify', 5, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(46, 'Production (live) Shopify instance', 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(47, 'Staging (preview) Shopify instance', 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(48, 'Dedicated Dev Store', 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(49, 'Content upload and/or migration', 6, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(50, 'Launch assessment + DNS config', 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(51, 'Post-launch 30-day bug support', 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(52, 'Post-launch remote training', 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(53, 'Site management guide', 7, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(54, 'Facebook Pixels', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(55, 'Facebook Conversions API', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(56, 'Pinterest pixels', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(57, 'Sitewide schema and rich snippets', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(58, 'Google Analytics, Google Tag Manager', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(59, 'A/B testing program', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(60, 'Marketing/landing pages', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(61, 'Advertising media', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(62, 'Post-launch SEO optimization', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(63, 'Post-launch speed optimization', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(64, 'OTHERS - client specific', 8, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(65, 'Ecommerce Strategy', 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(66, 'Growth Model', 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(67, 'Operations Strategy', 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01'),
(68, 'Customer Service', 9, 1, '2022-03-09 10:52:01', '2022-03-09 10:52:01');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `belonging`
--
ALTER TABLE `belonging`
  ADD PRIMARY KEY (`belonging_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`categorie_id`);

--
-- Indexes for table `client_requirements`
--
ALTER TABLE `client_requirements`
  ADD PRIMARY KEY (`client_requirement_id`);

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

--
-- Indexes for table `prices`
--
ALTER TABLE `prices`
  ADD PRIMARY KEY (`price_id`);

--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
  ADD PRIMARY KEY (`question_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`sub_categorie_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `client_requirements`
--
ALTER TABLE `client_requirements`
  MODIFY `client_requirement_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=1616;

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

--
-- AUTO_INCREMENT for table `questions`
--
ALTER TABLE `questions`
  MODIFY `question_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `sub_categorie_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;
COMMIT;

