-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 13, 2023 at 11:46 AM
-- Server version: 10.4.19-MariaDB
-- PHP Version: 8.0.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `scale_crm`
--

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

--
-- Table structure for table `lookup_counties`
--

CREATE TABLE `lookup_counties` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lookup_counties`
--

INSERT INTO `lookup_counties` (`id`, `state_id`, `name`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'MOWER', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(2, 1, 'ITASCA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(3, 1, 'WASHINGTON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(4, 1, 'CHISAGO', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(5, 1, 'ANOKA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(6, 1, 'ISANTI', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(7, 1, 'PINE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(8, 1, 'GOODHUE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(9, 1, 'DAKOTA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(10, 1, 'RICE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(11, 1, 'SCOTT', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(12, 1, 'WABASHA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(13, 1, 'STEELE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(14, 1, 'KANABEC', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(15, 1, 'RAMSEY', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(16, 1, 'HENNEPIN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(17, 1, 'WRIGHT', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(18, 1, 'SIBLEY', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(19, 1, 'SHERBURNE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(20, 1, 'RENVILLE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(21, 1, 'MCLEOD', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(22, 1, 'CARVER', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(23, 1, 'MEEKER', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(24, 1, 'STEARNS', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(25, 1, 'MILLE LACS', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(26, 1, 'LAKE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(27, 1, 'SAINT LOUIS', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(28, 1, 'COOK', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(29, 1, 'CARLTON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(30, 1, 'AITKIN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(31, 1, 'OLMSTED', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(32, 1, 'WINONA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(33, 1, 'HOUSTON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(34, 1, 'FILLMORE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(35, 1, 'DODGE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(36, 1, 'BLUE EARTH', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(37, 1, 'NICOLLET', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(38, 1, 'FREEBORN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(39, 1, 'FARIBAULT', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(40, 1, 'LE SUEUR', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(41, 1, 'BROWN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(42, 1, 'WATONWAN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(43, 1, 'MARTIN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(44, 1, 'WASECA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(45, 1, 'REDWOOD', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(46, 1, 'COTTONWOOD', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(47, 1, 'NOBLES', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(48, 1, 'JACKSON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(49, 1, 'LINCOLN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(50, 1, 'MURRAY', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(51, 1, 'LYON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(52, 1, 'ROCK', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(53, 1, 'PIPESTONE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(54, 1, 'KANDIYOHI', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(55, 1, 'STEVENS', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(56, 1, 'SWIFT', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(57, 1, 'BIG STONE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(58, 1, 'LAC QUI PARLE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(59, 1, 'TRAVERSE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(60, 1, 'YELLOW MEDICINE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(61, 1, 'CHIPPEWA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(62, 1, 'GRANT', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(63, 1, 'DOUGLAS', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(64, 1, 'MORRISON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(65, 1, 'TODD', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(66, 1, 'POPE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(67, 1, 'OTTER TAIL', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(68, 1, 'BENTON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(69, 1, 'CROW WING', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(70, 1, 'CASS', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(71, 1, 'HUBBARD', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(72, 1, 'WADENA', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(73, 1, 'BECKER', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(74, 1, 'NORMAN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(75, 1, 'CLAY', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(76, 1, 'MAHNOMEN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(77, 1, 'POLK', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(78, 1, 'WILKIN', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(79, 1, 'BELTRAMI', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(80, 1, 'CLEARWATER', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(81, 1, 'LAKE OF THE WOODS', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(82, 1, 'KOOCHICHING', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(83, 1, 'ROSEAU', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(84, 1, 'PENNINGTON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(85, 1, 'MARSHALL', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(86, 1, 'RED LAKE', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL),
(87, 1, 'KITTSON', 1, 1, 1, '2023-04-12 09:42:15', '2023-04-12 09:42:15', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `lookup_counties`
--
ALTER TABLE `lookup_counties`
  ADD PRIMARY KEY (`id`),
  ADD KEY `lookup_counties_state_id_foreign` (`state_id`),
  ADD KEY `lookup_counties_created_by_foreign` (`created_by`),
  ADD KEY `lookup_counties_updated_by_foreign` (`updated_by`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `lookup_counties`
--
ALTER TABLE `lookup_counties`
  ADD CONSTRAINT `lookup_counties_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `lookup_counties_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `lookup_states` (`id`),
  ADD CONSTRAINT `lookup_counties_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
