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

--
-- Table structure for table `drfuel_consents`
--

CREATE TABLE `drfuel_consents` (
  `id` bigint UNSIGNED NOT NULL,
  `consent_timestamp` datetime DEFAULT CURRENT_TIMESTAMP,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `industry_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `daily_consumption` int NOT NULL,
  `contact_person` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `executive_authority` tinyint(1) DEFAULT '0',
  `data_collection_consent` tinyint(1) DEFAULT '0',
  `consulting_opportunity` tinyint(1) DEFAULT '0',
  `confidentiality_agreement` tinyint(1) DEFAULT '0',
  `commitment_accuracy` tinyint(1) DEFAULT '0',
  `followup_consent` tinyint(1) DEFAULT '0',
  `consent_stage` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'authorized',
  `assessment_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `drfuel_consents`
--

INSERT INTO `drfuel_consents` (`id`, `consent_timestamp`, `company_name`, `industry_type`, `daily_consumption`, `contact_person`, `designation`, `contact_email`, `executive_authority`, `data_collection_consent`, `consulting_opportunity`, `confidentiality_agreement`, `commitment_accuracy`, `followup_consent`, `consent_stage`, `assessment_id`, `created_at`, `updated_at`) VALUES
(1, '2025-09-27 05:07:27', 'Company Name', NULL, 300, '66', '66', 'demo@gmial.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2025-09-27 05:07:28', '2025-09-27 05:14:40'),
(5, '2025-09-27 05:27:18', 's', NULL, 300, '66', '66', 'demo@gmial.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2025-09-27 05:27:19', '2025-09-27 05:27:19'),
(6, '2025-09-27 05:43:55', 'Sujata', NULL, 300, 'Contact Person Name', 'Demo Designation', 'demo@gmial.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2025-09-27 05:43:55', '2025-09-27 05:43:55'),
(7, '2025-09-27 05:45:56', 'Sujata', NULL, 300, 'Contact Person Name', 'Demo Designation', 'demo@gmial.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2025-09-27 05:45:56', '2025-09-27 05:45:56'),
(8, '2025-09-27 05:46:46', 'Sujata', NULL, 300, 'Contact Person Name', 'Demo Designation', 'demo@gmial.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2025-09-27 05:46:47', '2025-09-27 05:46:47'),
(9, '2025-09-27 05:50:54', 'Sujata', 'cement', 300, 'Contact Person Name', 'Demo Designation', 'demo@gmial.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2025-09-27 05:50:54', '2025-09-27 05:50:54'),
(10, '2025-10-08 07:42:10', 'VISHAL', 'steel-metal', 300, 'VISHAL LARA', 'CEO', 'MR.VISHAL@GMAIL.COM', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2025-10-08 07:42:58', '2025-10-08 07:42:58'),
(11, '2026-01-28 11:39:18', 'bhagya paper limited ', 'paper-pulp', 150, 'kulbhushan verma ', 'deputy general manager ', 'mr.vishalnarang2@gmail.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2026-01-28 11:39:04', '2026-01-28 11:39:04'),
(12, '2026-05-14 10:42:42', 'ram shah', 'power-generation', 200, 'amit ji ', 'director ', 'gm.pppower@gmail.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2026-05-14 10:42:43', '2026-05-14 10:42:43'),
(13, '2026-05-14 11:11:22', 'ram shah', 'power-generation', 200, 'amit ji ', 'd', 'sss@ddd.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2026-05-14 11:11:23', '2026-05-14 11:11:23'),
(14, '2026-05-14 12:28:20', 'mjmj', 'steel-metal', 1220, 'mjhmhjm', 'jhmjhmjh', 'ww@gmail.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2026-05-14 12:28:18', '2026-05-14 12:28:18'),
(15, '2026-05-14 13:39:21', 'demo', 'cement', 332, 'demo', 'asd', 'asdasd@gmail.com', 1, 1, 1, 1, 1, 1, 'authorized', NULL, '2026-05-14 13:40:07', '2026-05-14 13:40:07');
