[BLOB], 'logo/1685327379.png', 1, NULL, NULL);

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

--
-- Table structure for table `product_types`
--

CREATE TABLE IF NOT EXISTS `product_types` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_type` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_types_product_type_unique` (`product_type`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_types`
--


INSERT INTO `product_types` (`id`, `product_type`, `created_at`, `updated_at`) VALUES
(1, 'Default', NULL, NULL);

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

--
-- Table structure for table `states`
--

CREATE TABLE IF NOT EXISTS `states` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `state_name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `presearch` tinyint NOT NULL DEFAULT '0',
  `is_active` tinyint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `state_name`, `short_code`, `url`, `presearch`, `is_active`, `created_at`, `updated_at`) VALUES
(7, 'Alabama', 'AL', 'https://publicrecords.netronline.com/state/AL', 0, 1, NULL, NULL),
(8, 'Alaska', 'AK', 'https://publicrecords.netronline.com/state/AK', 0, 1, NULL, NULL),
(9, 'Arizona', 'AZ', 'https://publicrecords.netronline.com/state/AZ', 0, 1, NULL, NULL),
(10, 'Arkansas', 'AR', 'https://publicrecords.netronline.com/state/AR', 0, 1, NULL, NULL),
(11, 'California', 'CA', 'https://publicrecords.netronline.com/state/CA', 0, 1, NULL, NULL),
(12, 'Colorado', 'CO', 'https://publicrecords.netronline.com/state/CO', 0, 1, NULL, NULL),
(13, 'Connecticut', 'CT', 'https://publicrecords.netronline.com/state/CT', 0, 1, NULL, NULL),
(14, 'Delaware', 'DE', 'https://publicrecords.netronline.com/state/DE', 0, 1, NULL, NULL),
(15, 'District of Columbia', 'DC', 'https://publicrecords.netronline.com/state/DC', 0, 1, NULL, NULL),
(16, 'Florida', 'FL', 'https://publicrecords.netronline.com/state/FL', 0, 1, NULL, NULL),
(17, 'Georgia', 'GA', 'https://publicrecords.netronline.com/state/GA', 1, 1, NULL, NULL),
(18, 'Hawaii', 'HI', 'https://publicrecords.netronline.com/state/HI', 0, 1, NULL, NULL),
(19, 'Idaho', 'ID', 'https://publicrecords.netronline.com/state/ID', 0, 1, NULL, NULL),
(20, 'Illinois', 'IL', 'https://publicrecords.netronline.com/state/IL', 0, 1, NULL, NULL),
(21, 'Indiana', 'IN', 'https://publicrecords.netronline.com/state/IN', 1, 1, NULL, NULL),
(22, 'Iowa', 'IA', 'https://publicrecords.netronline.com/state/IA', 0, 1, NULL, NULL),
(23, 'Kansas', 'KS', 'https://publicrecords.netronline.com/state/KS', 0, 1, NULL, NULL),
(24, 'Kentucky', 'KY', 'https://publicrecords.netronline.com/state/KY', 0, 1, NULL, NULL),
(25, 'Louisiana', 'LA', 'https://publicrecords.netronline.com/state/LA', 0, 1, NULL, NULL),
(26, 'Maine', 'ME', 'https://publicrecords.netronline.com/state/ME', 0, 1, NULL, NULL),
(27, 'Maryland', 'MD', 'https://publicrecords.netronline.com/state/MD', 0, 1, NULL, NULL),
(28, 'Massachusetts', 'MA', 'https://publicrecords.netronline.com/state/MA', 0, 1, NULL, NULL),
(29, 'Michigan', 'MI', 'https://publicrecords.netronline.com/state/MI', 0, 1, NULL, NULL),
(30, 'Minnesota', 'MN', 'https://publicrecords.netronline.com/state/MN', 0, 1, NULL, NULL),
(31, 'Mississippi', 'MS', 'https://publicrecords.netronline.com/state/MS', 0, 1, NULL, NULL),
(32, 'Missouri', 'MO', 'https://publicrecords.netronline.com/state/MO', 0, 1, NULL, NULL),
(33, 'Montana', 'MT', 'https://publicrecords.netronline.com/state/MT', 0, 1, NULL, NULL),
(34, 'Nebraska', 'NE', 'https://publicrecords.netronline.com/state/NE', 0, 1, NULL, NULL),
(35, 'Nevada', 'NV', 'https://publicrecords.netronline.com/state/NV', 0, 1, NULL, NULL),
(36, 'New Hampshire', 'NH', 'https://publicrecords.netronline.com/state/NH', 0, 1, NULL, NULL),
(37, 'New Jersey', 'NJ', 'https://publicrecords.netronline.com/state/NJ', 0, 1, NULL, NULL),
(38, 'New Mexico', 'NM', 'https://publicrecords.netronline.com/state/NM', 0, 1, NULL, NULL),
(39, 'New York', 'NY', 'https://publicrecords.netronline.com/state/NY', 0, 1, NULL, NULL),
(40, 'North Carolina', 'NC', 'https://publicrecords.netronline.com/state/NC', 0, 1, NULL, NULL),
(41, 'North Dakota', 'ND', 'https://publicrecords.netronline.com/state/ND', 0, 1, NULL, NULL),
(42, 'Ohio', 'OH', 'https://publicrecords.netronline.com/state/OH', 1, 1, NULL, NULL),
(44, 'Oklahoma', 'OK', 'https://publicrecords.netronline.com/state/OK', 0, 1, NULL, NULL),
(45, 'Oregon', 'OR', 'https://publicrecords.netronline.com/state/OR', 0, 1, NULL, NULL),
(46, 'Pennsylvania', 'PA', 'https://publicrecords.netronline.com/state/PA', 1, 1, NULL, NULL),
(47, 'Rhode Island', 'RI', 'https://publicrecords.netronline.com/state/RI', 0, 1, NULL, NULL),
(48, 'South Carolina', 'SC', 'https://publicrecords.netronline.com/state/SC', 1, 1, NULL, NULL),
(49, 'South Dakota', 'SD', 'https://publicrecords.netronline.com/state/SD', 0, 1, NULL, NULL),
(50, 'Tennessee', 'TN', 'https://publicrecords.netronline.com/state/TN', 0, 1, NULL, NULL),
(51, 'Texas', 'TX', 'https://publicrecords.netronline.com/state/TX', 0, 1, NULL, NULL),
(52, 'Utah', 'UT', 'https://publicrecords.netronline.com/state/UT', 0, 1, NULL, NULL),
(53, 'Vermont', 'VT', 'https://publicrecords.netronline.com/state/VT', 0, 1, NULL, NULL),
(54, 'Virginia', 'VA', 'https://publicrecords.netronline.com/state/VA', 0, 1, NULL, NULL),
(55, 'Washington', 'WA', 'https://publicrecords.netronline.com/state/WA', 0, 1, NULL, NULL),
(56, 'West Virginia', 'WV', 'https://publicrecords.netronline.com/state/WV', 0, 1, NULL, NULL),
(57, 'Wisconsin', 'WI', 'https://publicrecords.netronline.com/state/WI', 0, 1, NULL, NULL),
(58, 'Wyoming', 'WY', 'https://publicrecords.netronline.com/state/WY', 0, 1, NULL, NULL);

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

--
-- Table structure for table `status_types`
--

CREATE TABLE IF NOT EXISTS `status_types` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `status_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_types`
--

INSERT INTO `status_types` (`id`, `status_type`, `created_at`, `updated_at`) VALUES
(1, 'Order Received', NULL, NULL),
(2, 'Open', NULL, NULL),
(3, 'In Progress', NULL, NULL),
(4, 'Follow Up', NULL, NULL),
(5, 'Clarification Req', NULL, NULL),
(6, 'Clarification Rec', NULL, NULL),
(7, 'Qc Queue', NULL, NULL),
(8, 'Completed', NULL, NULL),
(9, 'Closed', NULL, NULL),
(10, 'Cancelled', NULL, NULL),
(11, 'Pending', NULL, NULL),
(12, 'Mail Away', NULL, NULL),
(13, 'On Hold', NULL, NULL);

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

--
-- Table structure for table `supporting_docs`
--

CREATE TABLE IF NOT EXISTS `supporting_docs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `pdf_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_types`
--

CREATE TABLE IF NOT EXISTS `user_types` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` (`id`, `user_type`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', NULL, NULL),
(2, 'Admin', NULL, NULL),
(3, 'Client', NULL, NULL),
(4, 'User', NULL, NULL),
(5, 'QC', NULL, NULL);
COMMIT;

