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

START TRANSACTION;



--
-- Database: `varizpwk_varifarms_new`
--

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

--
-- Table structure for table `action_events`
--

CREATE TABLE `action_events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actionable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actionable_id` bigint(20) UNSIGNED NOT NULL,
  `target_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fields` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'running',
  `exception` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `original` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `changes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `action_events`
--

INSERT INTO `action_events` (`id`, `batch_id`, `user_id`, `name`, `actionable_type`, `actionable_id`, `target_type`, `target_id`, `model_type`, `model_id`, `fields`, `status`, `exception`, `created_at`, `updated_at`, `original`, `changes`) VALUES
(1, '9436960e-b157-4967-a959-e1482491088e', 1, 'Delete', 'App\\User', 2, 'App\\User', 2, 'App\\User', 2, '', 'finished', '', '2021-08-22 12:41:06', '2021-08-22 12:41:06', NULL, NULL),
(2, '9436961f-d74c-4215-b0fa-03372fa661f4', 1, 'Delete', 'App\\User', 3, 'App\\User', 3, 'App\\User', 3, '', 'finished', '', '2021-08-22 12:41:18', '2021-08-22 12:41:18', NULL, NULL),
(3, '943ed7b1-296a-442f-ab64-3236af0f96f2', 1, 'Update', 'App\\Partner', 4, 'App\\Partner', 4, 'App\\Partner', 4, '', 'finished', '', '2021-08-26 15:11:15', '2021-08-26 15:11:15', '{\"status\":\"0\"}', '{\"status\":true}'),
(4, '94409a4d-07bf-4d4e-bb8f-22698126addd', 1, 'Delete', 'App\\User', 7, 'App\\User', 7, 'App\\User', 7, '', 'finished', '', '2021-08-27 12:11:15', '2021-08-27 12:11:15', NULL, NULL),
(5, '945d9fd3-04d8-4f35-881f-7cef0b305e76', 1, 'Delete', 'App\\User', 8, 'App\\User', 8, 'App\\User', 8, '', 'finished', '', '2021-09-10 22:25:42', '2021-09-10 22:25:42', NULL, NULL),
(6, '946565f6-078c-43e4-80a1-ce580cdc8c02', 1, 'Delete', 'App\\Contact', 1, 'App\\Contact', 1, 'App\\Contact', 1, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(7, '946565f6-12b5-493b-bfaa-f41143bf6e93', 1, 'Delete', 'App\\Contact', 2, 'App\\Contact', 2, 'App\\Contact', 2, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(8, '946565f6-1464-42a4-a5be-e6339be95bd6', 1, 'Delete', 'App\\Contact', 3, 'App\\Contact', 3, 'App\\Contact', 3, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(9, '946565f6-15cf-4cc5-92c8-63cd9f3b0636', 1, 'Delete', 'App\\Contact', 4, 'App\\Contact', 4, 'App\\Contact', 4, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(10, '946565f6-1735-4738-8eeb-319fd1c6eec5', 1, 'Delete', 'App\\Contact', 5, 'App\\Contact', 5, 'App\\Contact', 5, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(11, '946565f6-1880-4e14-9b3b-2e6db0cfb751', 1, 'Delete', 'App\\Contact', 6, 'App\\Contact', 6, 'App\\Contact', 6, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(12, '946565f6-1a04-4daf-89a9-9c8fd9147246', 1, 'Delete', 'App\\Contact', 7, 'App\\Contact', 7, 'App\\Contact', 7, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(13, '946565f6-1b35-48ad-8fba-ae0ee3526507', 1, 'Delete', 'App\\Contact', 8, 'App\\Contact', 8, 'App\\Contact', 8, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(14, '946565f6-1c7a-49ad-8824-6476a11396c1', 1, 'Delete', 'App\\Contact', 9, 'App\\Contact', 9, 'App\\Contact', 9, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(15, '946565f6-1d9a-405a-823e-eff2e0df7e8d', 1, 'Delete', 'App\\Contact', 10, 'App\\Contact', 10, 'App\\Contact', 10, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(16, '946565f6-1ef1-45cf-87e0-e9341a74d351', 1, 'Delete', 'App\\Contact', 11, 'App\\Contact', 11, 'App\\Contact', 11, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(17, '946565f6-2069-48e3-9115-b4d9498d6d05', 1, 'Delete', 'App\\Contact', 12, 'App\\Contact', 12, 'App\\Contact', 12, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(18, '946565f6-21b5-4e68-860e-24584cdc1480', 1, 'Delete', 'App\\Contact', 13, 'App\\Contact', 13, 'App\\Contact', 13, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(19, '946565f6-230a-46d8-b58b-b7e3ecd09bc5', 1, 'Delete', 'App\\Contact', 14, 'App\\Contact', 14, 'App\\Contact', 14, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(20, '946565f6-2439-4e85-94db-bd2f3998d920', 1, 'Delete', 'App\\Contact', 15, 'App\\Contact', 15, 'App\\Contact', 15, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(21, '946565f6-259e-434b-96a8-262512d31fc9', 1, 'Delete', 'App\\Contact', 16, 'App\\Contact', 16, 'App\\Contact', 16, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(22, '946565f6-26cf-4943-a592-963a20885a19', 1, 'Delete', 'App\\Contact', 17, 'App\\Contact', 17, 'App\\Contact', 17, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(23, '946565f6-2b8c-4e3c-bc26-f069b53872f3', 1, 'Delete', 'App\\Contact', 18, 'App\\Contact', 18, 'App\\Contact', 18, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(24, '946565f6-2d17-4f9d-8445-811c29b086ff', 1, 'Delete', 'App\\Contact', 19, 'App\\Contact', 19, 'App\\Contact', 19, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(25, '946565f6-2efd-4c0a-8931-f916db956206', 1, 'Delete', 'App\\Contact', 20, 'App\\Contact', 20, 'App\\Contact', 20, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(26, '946565f6-3022-41db-91b1-f0a71f794ff5', 1, 'Delete', 'App\\Contact', 21, 'App\\Contact', 21, 'App\\Contact', 21, '', 'finished', '', '2021-09-14 19:10:32', '2021-09-14 19:10:32', NULL, NULL),
(27, '9494c83e-661b-4be0-822e-abaeac535266', 1, 'Delete', 'App\\Contact', 22, 'App\\Contact', 22, 'App\\Contact', 22, '', 'finished', '', '2021-10-08 08:29:16', '2021-10-08 08:29:16', NULL, NULL),
(28, '9494c83e-6e36-4533-8bb6-28a380d648b1', 1, 'Delete', 'App\\Contact', 23, 'App\\Contact', 23, 'App\\Contact', 23, '', 'finished', '', '2021-10-08 08:29:16', '2021-10-08 08:29:16', NULL, NULL),
(29, '9494c83e-6f7d-40f1-80d8-f8881cbc0561', 1, 'Delete', 'App\\Contact', 24, 'App\\Contact', 24, 'App\\Contact', 24, '', 'finished', '', '2021-10-08 08:29:16', '2021-10-08 08:29:16', NULL, NULL),
(30, '9494c83e-70c5-4479-9417-8fb974c746c5', 1, 'Delete', 'App\\Contact', 25, 'App\\Contact', 25, 'App\\Contact', 25, '', 'finished', '', '2021-10-08 08:29:16', '2021-10-08 08:29:16', NULL, NULL),
(31, '9494c83e-7216-449a-8224-513e9dd56097', 1, 'Delete', 'App\\Contact', 26, 'App\\Contact', 26, 'App\\Contact', 26, '', 'finished', '', '2021-10-08 08:29:16', '2021-10-08 08:29:16', NULL, NULL),
(32, '9494c83e-7405-43ee-8ce5-4c69bf75218a', 1, 'Delete', 'App\\Contact', 27, 'App\\Contact', 27, 'App\\Contact', 27, '', 'finished', '', '2021-10-08 08:29:16', '2021-10-08 08:29:16', NULL, NULL),
(33, '9494c83e-7528-44c8-ab95-07a5a042b2b6', 1, 'Delete', 'App\\Contact', 28, 'App\\Contact', 28, 'App\\Contact', 28, '', 'finished', '', '2021-10-08 08:29:16', '2021-10-08 08:29:16', NULL, NULL),
(34, '94998039-20e1-497e-970f-5173707a6b13', 1, 'Delete', 'App\\User', 6, 'App\\User', 6, 'App\\User', 6, '', 'finished', '', '2021-10-10 16:47:01', '2021-10-10 16:47:01', NULL, NULL),
(35, '949ff124-4ca6-4437-a149-53e6d9a60d7c', 1, 'Delete', 'App\\Contact', 29, 'App\\Contact', 29, 'App\\Contact', 29, '', 'finished', '', '2021-10-13 21:37:44', '2021-10-13 21:37:44', NULL, NULL),
(36, '949ff124-54a7-472e-8688-784d50c22149', 1, 'Delete', 'App\\Contact', 30, 'App\\Contact', 30, 'App\\Contact', 30, '', 'finished', '', '2021-10-13 21:37:44', '2021-10-13 21:37:44', NULL, NULL),
(37, '949ff124-55fd-45ea-9b0e-6b96cc25924f', 1, 'Delete', 'App\\Contact', 31, 'App\\Contact', 31, 'App\\Contact', 31, '', 'finished', '', '2021-10-13 21:37:44', '2021-10-13 21:37:44', NULL, NULL),
(38, '949ff124-5778-4241-a56b-d2f97084dc3c', 1, 'Delete', 'App\\Contact', 32, 'App\\Contact', 32, 'App\\Contact', 32, '', 'finished', '', '2021-10-13 21:37:44', '2021-10-13 21:37:44', NULL, NULL);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL 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 `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `phone`, `email`, `subject`, `message`, `status`, `created_at`, `updated_at`) VALUES
(33, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'how to turn eyeballs into phone calls', 'Hi, Eric here with a quick thought about your website varifarms.com...\r\n\r\nI’m on the internet a lot and I look at a lot of business websites.\r\n\r\nLike yours, many of them have great content. \r\n\r\nBut all too often, they come up short when it comes to engaging and connecting with anyone who visits.\r\n\r\nI get it – it’s hard.  Studies show 7 out of 10 people who land on a site, abandon it in moments without leaving even a trace.  You got the eyeball, but nothing else.\r\n\r\nHere’s a solution for you…\r\n\r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Name, Email address and Phone Number.  You’ll know immediately they’re interested and you can call them directly to talk with them literally while they’re still on the web looking at your site.\r\n\r\nCLICK HERE https://talkwithwebvisitors.com to try out a Live Demo with Talk With Web Visitor now to see exactly how it works.\r\n\r\nIt could be huge for your business – and because you’ve got that phone number, with our new SMS Text With Lead feature, you can automatically start a text (SMS) conversation – immediately… and contacting someone in that 5 minute window is 100 times more powerful than reaching out 30 minutes or more later.\r\n\r\nPlus, with text messaging you can follow up later with new offers, content links, even just follow up notes to keep the conversation going.\r\n\r\nEverything I’ve just described is extremely simple to implement, cost-effective, and profitable. \r\n \r\nCLICK HERE https://talkwithwebvisitors.com to discover what Talk With Web Visitor can do for your business.\r\n\r\nYou could be converting up to 100X more eyeballs into leads today!\r\n\r\nEric\r\nPS: Talk With Web Visitor offers a FREE 14 days trial – and it even includes International Long Distance Calling. \r\nYou have customers waiting to talk with you right now… don’t keep them waiting. \r\nCLICK HERE https://talkwithwebvisitors.com to try Talk With Web Visitor now.\r\n\r\nIf you\'d like to unsubscribe click here http://talkwithwebvisitors.com/unsubscribe.aspx?d=varifarms.com', 0, '2021-10-14 16:00:01', '2021-10-14 16:00:01');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED 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 `investments`
--

CREATE TABLE `investments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `units` int(11) NOT NULL,
  `duration` int(11) NOT NULL COMMENT 'months',
  `percent` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `payout_amount` int(11) NOT NULL,
  `payout_date` datetime NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'invested',
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `requested_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `channel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(10) UNSIGNED NOT NULL,
  `thread_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT 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;

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

--
-- 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_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2014_10_28_175635_create_threads_table', 1),
(4, '2014_10_28_175710_create_messages_table', 1),
(5, '2014_10_28_180224_create_participants_table', 1),
(6, '2014_11_03_154831_add_soft_deletes_to_participants_table', 1),
(7, '2014_12_04_124531_add_softdeletes_to_threads_table', 1),
(8, '2017_03_30_152742_add_soft_deletes_to_messages_table', 1),
(9, '2018_01_01_000000_create_action_events_table', 1),
(10, '2019_05_10_000000_add_fields_to_action_events_table', 1),
(11, '2019_08_19_000000_create_failed_jobs_table', 1),
(12, '2020_10_21_153133_create_investments_table', 1),
(13, '2020_10_24_062036_add_bank_fields_to_users', 1),
(14, '2020_10_24_122233_create_visits_table', 1),
(15, '2020_11_25_081030_add_channel_to_investment', 1),
(16, '2021_03_16_071939_create_contacts_table', 1),
(17, '2021_03_18_043325_create_partners_table', 1),
(18, '2021_03_18_050058_create_quotes_table', 1),
(19, '2021_03_18_052543_create_projects_table', 1);

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

--
-- Table structure for table `participants`
--

CREATE TABLE `participants` (
  `id` int(10) UNSIGNED NOT NULL,
  `thread_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `last_read` timestamp NULL 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;

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `have_farm` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `experience` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `financing` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL 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 `partners`
--

INSERT INTO `partners` (`id`, `name`, `phone`, `email`, `state`, `city`, `business`, `have_farm`, `activity`, `experience`, `financing`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Kate', 'Not provided', 'misskateo@gmail.com', 'Edo', 'Benin', 'Marketplace for farmers to sell produce and source goods needed for farming', 'No', 'Others', 'Yes', 'Yes', 1, '2021-05-03 16:53:37', '2021-05-07 11:15:42'),
(3, 'Amuchi Emmanuel', '+2348066077773', 'imagemaker.studio@yahoo.com', 'Lagos', 'Lagos', 'Lagos', 'Yes', 'Others', 'Yes', 'No', 1, '2021-05-08 11:22:13', '2021-05-11 11:08:07'),
(4, 'Enobong Etim', '09090170168', 'enobongetim@yahoo.com', 'Akwa Ibom', 'Uyo', 'Poultry', 'Yes', 'Poultry/Egg', 'Yes', 'No', 1, '2021-07-28 00:07:44', '2021-08-26 15:11:15');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `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 `quotes`
--

CREATE TABLE `quotes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `farm_product` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `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 `threads`
--

CREATE TABLE `threads` (
  `id` int(10) UNSIGNED NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ticket` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unattended',
  `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;

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

--
-- Table structure for table `visits`
--

CREATE TABLE `visits` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `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 `action_events`
--
ALTER TABLE `action_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `action_events_actionable_type_actionable_id_index` (`actionable_type`,`actionable_id`),
  ADD KEY `action_events_batch_id_model_type_model_id_index` (`batch_id`,`model_type`,`model_id`),
  ADD KEY `action_events_user_id_index` (`user_id`);

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `participants`
--
ALTER TABLE `participants`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `threads`
--
ALTER TABLE `threads`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `investments`
--
ALTER TABLE `investments`
  ADD CONSTRAINT `investments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `visits`
--
ALTER TABLE `visits`
  ADD CONSTRAINT `visits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

