--
-- Host: localhost    Database: allevia6_alleviatetaxservice_landing_page
-- ------------------------------------------------------


--
-- Table structure for table `ccpa_leads`
--

CREATE TABLE `ccpa_leads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `requestor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `requestoptions` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `street` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `apt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primary_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ccpa_leads`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `current_sit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_current_situation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_debt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `enrolled_irs` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `current_monthly_income` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primary_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crm_response` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `case_id` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `leads`
--

INSERT INTO `leads` VALUES (1,'2020-11-11 08:54:22','2020-11-11 08:54:22','self Employed',NULL,'10000','Yes','Over 1000','First','Last','test@test.com','9225558844','KY','95418',NULL,NULL),(2,'2020-11-11 09:16:20','2020-11-11 09:17:21','self Employed',NULL,'10000','Yes','Over 1000','First','Last','test@test.com','9225558844','KY','95418',NULL,'[\"cURL error 7: Failed to connect to alleviatetax.irslogics.com port 443: Connection refused (see https:\\/\\/curl.haxx.se\\/libcurl\\/c\\/libcurl-errors.html)\"]'),(3,'2020-11-12 08:18:22','2020-11-12 08:18:23','self Employed','THis is a test','0','No','Under 1000','first','last','test@test.com','999999999','LA','999999',NULL,'340973'),(4,'2020-11-19 00:50:58','2020-11-19 00:50:58','self Employed',NULL,'16000','No',NULL,'Susa','Virg','susiv@dj.dd','5852637882','AK','12234',NULL,'364605'),(5,'2020-11-19 00:59:59','2020-11-19 01:00:00','Owe More Than Expected',NULL,'500','Yes',NULL,'susi','virg','susi.fe@gng.do','5856378824','HI','14420',NULL,'364607');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--



