[2025-10-08 12:16:21] ChatID:chat_1759840646341 Q: hello A: Into file [2025-10-08 12:33:54] ChatID:xya Q: hi A: (Innn Processing...) [2025-10-08 12:33:54] ChatID:xya Q: hi A: (Processing...) [2025-10-08 12:34:27] ChatID:xya Q: hi A: (Innn Processing...) [2025-10-08 12:34:27] ChatID:xya Q: hi A: (Processing...) [2025-10-08 12:35:01] ChatID:xya Q: hi A: (Innn Processing...) [2025-10-08 12:35:01] ChatID:xya Q: hi A: (Processing...) [2025-10-08 12:35:01] In gemini [2025-10-08 12:35:02] In gemini Array [2025-10-08 12:35:59] ChatID:xya Q: how many users are there ? A: (Innn Processing...) [2025-10-08 12:35:59] ChatID:xya Q: how many users are there ? A: (Processing...) [2025-10-08 12:35:59] In gemini [2025-10-08 12:36:00] In gemini [2025-10-08 12:36:00] In gemini [2025-10-08 12:36:02] In gemini [2025-10-08 12:36:02] [SQL] ChatID:xya Q: how many users are there ? A: SQL Query```sql SELECT COUNT(*) FROM users; ```DBsraservices_production [2025-10-08 12:36:34] ChatID:chat_1759840646341 Q: hello A: (Innn Processing...) [2025-10-08 12:36:34] ChatID:chat_1759840646341 Q: hello A: (Processing...) [2025-10-08 12:36:34] In gemini [2025-10-08 12:36:35] In gemini [2025-10-08 12:36:35] [Chat] ChatID:chat_1759840646341 Q: hello A: Hello! How may I assist you today? [2025-10-08 12:36:38] ChatID:chat_1759840646341 Q: how many users are there ? A: (Innn Processing...) [2025-10-08 12:36:38] ChatID:chat_1759840646341 Q: how many users are there ? A: (Processing...) [2025-10-08 12:36:38] In gemini [2025-10-08 12:36:38] In gemini [2025-10-08 12:36:38] In gemini [2025-10-08 12:36:40] In gemini [2025-10-08 12:36:40] [SQL] ChatID:chat_1759840646341 Q: how many users are there ? A: SQL Query```sql SELECT COUNT(id) FROM users; ```DBsraservices_production [2025-10-08 12:37:02] ChatID:chat_1759840646341 Q: hello A: (Innn Processing...) [2025-10-08 12:37:02] ChatID:chat_1759840646341 Q: hello A: (Processing...) [2025-10-08 12:37:02] In gemini [2025-10-08 12:37:03] In gemini [2025-10-08 12:37:03] [Chat] ChatID:chat_1759840646341 Q: hello A: Hello! How may I assist you today? [2025-10-08 12:37:06] ChatID:chat_1759840646341 Q: how many users are there ? A: (Innn Processing...) [2025-10-08 12:37:06] ChatID:chat_1759840646341 Q: how many users are there ? A: (Processing...) [2025-10-08 12:37:06] In gemini [2025-10-08 12:37:06] In gemini [2025-10-08 12:37:06] In gemini [2025-10-08 12:37:08] In gemini [2025-10-08 12:37:08] [SQL] ChatID:chat_1759840646341 Q: how many users are there ? A: SQL Query```sql SELECT COUNT(id) FROM users; ```DBsraservices_production [2025-10-08 12:38:19] ChatID:chat_1759840646341 Q: how many users are there ? A: (Innn Processing...) [2025-10-08 12:38:19] ChatID:chat_1759840646341 Q: how many users are there ? A: (Processing...) [2025-10-08 12:38:19] In gemini [2025-10-08 12:38:20] In gemini [2025-10-08 12:38:20] In gemini [2025-10-08 12:38:21] In gemini [2025-10-08 12:38:21] [SQL] ChatID:chat_1759840646341 Q: how many users are there ? A: SQL Query```sql SELECT COUNT(*) FROM users; ```DBsraservices_production [2025-10-08 12:39:51] ChatID:chat_1759840646341 Q: how many users are there ? A: (Innn Processing...) [2025-10-08 12:39:51] ChatID:chat_1759840646341 Q: how many users are there ? A: (Processing...) [2025-10-08 12:39:51] In gemini [2025-10-08 12:39:52] In gemini [2025-10-08 12:39:52] In gemini [2025-10-08 12:39:54] In gemini [2025-10-08 12:39:54] [SQL] ChatID:chat_1759840646341 Q: how many users are there ? A: SQL Query```sql SELECT COUNT(*) FROM users; ```DBsraservices_production [2025-10-08 12:46:26] ChatID:chat_1759840646341 Q: how many users are there ? A: (Innn Processing...) [2025-10-08 12:46:26] ChatID:chat_1759840646341 Q: how many users are there ? A: (Processing...) [2025-10-08 12:46:26] In gemini [2025-10-08 12:46:27] In gemini [2025-10-08 12:46:27] In gemini [2025-10-08 12:46:29] In gemini [2025-10-08 12:46:29] [SQL] ChatID:chat_1759840646341 Q: how many users are there ? A: SQL Query```sql SELECT COUNT(id) FROM users; ```DBsraservices_production [2025-10-08 13:15:43] ChatID:chat_1759840646341 Q: give their name ? A: (Innn Processing...) [2025-10-08 13:15:43] ChatID:chat_1759840646341 Q: give their name ? A: (Processing...) [2025-10-08 13:15:43] In gemini [2025-10-08 13:15:44] In gemini [2025-10-08 13:15:44] In gemini [2025-10-08 13:15:55] In gemini [2025-10-08 13:15:55] [SQL] ChatID:chat_1759840646341 Q: give their name ? A: SQL Query```sql SELECT HUTOWNERNAME FROM T_HUTOWNERINFODETAILS; ```DBsraservices_production [2025-10-08 13:33:19] ChatID:chat_1759840646341 Q: hello A: (Innn Processing...) [2025-10-08 13:33:19] ChatID:chat_1759840646341 Q: hello A: (Processing...) [2025-10-08 13:33:19] In gemini [2025-10-08 13:33:20] In gemini [2025-10-08 13:33:20] [Chat] ChatID:chat_1759840646341 Q: hello A: Hello! How may I assist you today? [2025-10-08 13:34:40] ChatID:chat_1759840646341 Q: hello A: (Innn Processing...) [2025-10-08 13:34:40] ChatID:chat_1759840646341 Q: hello A: (Processing...) [2025-10-08 13:34:40] In gemini [2025-10-08 13:34:41] In gemini [2025-10-08 13:34:41] [Chat] ChatID:chat_1759840646341 Q: hello A: Hello! How may I assist you today? [2025-10-08 13:35:04] ChatID:chat_1759840646341 Q: how many ca users are there? A: (Innn Processing...) [2025-10-08 13:35:04] ChatID:chat_1759840646341 Q: how many ca users are there? A: (Processing...) [2025-10-08 13:35:04] In gemini [2025-10-08 13:35:05] In gemini [2025-10-08 13:35:05] In gemini [2025-10-08 13:35:07] In gemini [2025-10-08 13:35:07] [SQL] ChatID:chat_1759840646341 Q: how many ca users are there? A: SQL Query```sql SELECT COUNT(id) FROM users WHERE user_type = 'CA'; ```DBsraservices_production [2025-10-08 13:35:45] ChatID:chat_1759840646341 Q: please provide name of them A: (Innn Processing...) [2025-10-08 13:35:45] ChatID:chat_1759840646341 Q: please provide name of them A: (Processing...) [2025-10-08 13:35:45] In gemini [2025-10-08 13:35:47] In gemini [2025-10-08 13:35:47] In gemini [2025-10-08 13:35:48] In gemini [2025-10-08 13:35:48] [SQL] ChatID:chat_1759840646341 Q: please provide name of them A: SQL Query```sql SELECT first_name, last_name FROM users WHERE user_type = 'CA'; ```DBsraservices_production [2025-10-08 13:36:52] ChatID:chat_1759840646341 Q: list all cluster ids of Shri.Nandkumar Koshti A: (Innn Processing...) [2025-10-08 13:36:52] ChatID:chat_1759840646341 Q: list all cluster ids of Shri.Nandkumar Koshti A: (Processing...) [2025-10-08 13:36:52] In gemini [2025-10-08 13:36:53] In gemini [2025-10-08 13:36:53] In gemini [2025-10-08 13:36:54] In gemini [2025-10-08 13:36:54] [SQL] ChatID:chat_1759840646341 Q: list all cluster ids of Shri.Nandkumar Koshti A: SQL Query```sql SELECT cluster_id FROM users WHERE first_name = 'Shri.Nandkumar' AND last_name = 'Koshti'; ```DBsraservices_production [2025-10-08 13:37:52] ChatID:chat_1759840646341 Q: give cluster ids of all above users A: (Innn Processing...) [2025-10-08 13:37:52] ChatID:chat_1759840646341 Q: give cluster ids of all above users A: (Processing...) [2025-10-08 13:37:52] In gemini [2025-10-08 13:37:56] In gemini [2025-10-08 13:37:56] In gemini [2025-10-08 13:37:57] In gemini [2025-10-08 13:37:57] [SQL] ChatID:chat_1759840646341 Q: give cluster ids of all above users A: SQL Query```sql SELECT cluster_id FROM users WHERE user_type = 'CA'; ```DBsraservices_production [2025-10-08 13:41:15] ChatID:chat_1759840646341 Q: give cluster ids of all above users A: (Innn Processing...) [2025-10-08 13:41:15] ChatID:chat_1759840646341 Q: give cluster ids of all above users A: (Processing...) [2025-10-08 13:41:15] In gemini [2025-10-08 13:41:17] In gemini [2025-10-08 13:41:17] In gemini [2025-10-08 13:41:19] In gemini [2025-10-08 13:41:19] [SQL] ChatID:chat_1759840646341 Q: give cluster ids of all above users A: SQL Query```sql SELECT cluster_id FROM users WHERE user_type = 'CA'; ```DBsraservices_production [2025-10-08 13:44:11] ChatID:chat_1759840646341 Q: provide detail of ca3 for related documents A: (Innn Processing...) [2025-10-08 13:44:11] ChatID:chat_1759840646341 Q: provide detail of ca3 for related documents A: (Processing...) [2025-10-08 13:44:11] In gemini [2025-10-08 13:44:12] In gemini [2025-10-08 13:44:12] In gemini [2025-10-08 13:44:32] In gemini [2025-10-08 13:44:32] [SQL] ChatID:chat_1759840646341 Q: provide detail of ca3 for related documents A: SQL QueryDBsraservices_production [2025-10-08 13:45:22] ChatID:chat_1759840646341 Q: how many election documents are there ? A: (Innn Processing...) [2025-10-08 13:45:22] ChatID:chat_1759840646341 Q: how many election documents are there ? A: (Processing...) [2025-10-08 13:45:22] In gemini [2025-10-08 13:45:23] In gemini [2025-10-08 13:45:23] In gemini [2025-10-08 13:45:26] In gemini [2025-10-08 13:45:26] [SQL] ChatID:chat_1759840646341 Q: how many election documents are there ? A: SQL Query```sql SELECT COUNT(id) FROM election_document; ```DBsraservices_production [2025-10-08 14:07:55] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election A: (Innn Processing...) [2025-10-08 14:07:55] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election A: (Processing...) [2025-10-08 14:07:55] In gemini [2025-10-08 14:07:56] In gemini [2025-10-08 14:07:56] In gemini [2025-10-08 14:08:16] In gemini [2025-10-08 14:08:16] [SQL] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election A: SQL QueryDBsraservices_production [2025-10-08 14:10:10] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election A: (Innn Processing...) [2025-10-08 14:10:10] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election A: (Processing...) [2025-10-08 14:10:10] In gemini [2025-10-08 14:10:11] In gemini [2025-10-08 14:10:11] In gemini [2025-10-08 14:10:31] In gemini [2025-10-08 14:10:31] [SQL] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election A: SQL QueryDBsraservices_production [2025-10-08 14:21:42] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election ? A: (Innn Processing...) [2025-10-08 14:21:42] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election ? A: (Processing...) [2025-10-08 14:21:42] In gemini [2025-10-08 14:21:44] In gemini [2025-10-08 14:21:44] In gemini [2025-10-08 14:21:47] In gemini [2025-10-08 14:21:47] [SQL] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election ? A: SQL QuerySQL Query```sql SELECT ed.* FROM election_document AS ed JOIN users AS u ON ed.user_id = u.id WHERE u.user_type = 'CA4'; ```DBsraservices_productionDBsraservices_production [2025-10-08 14:34:40] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election ? A: (Innn Processing...) [2025-10-08 14:34:40] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election ? A: (Processing...) [2025-10-08 14:34:40] In gemini [2025-10-08 14:34:41] In gemini [2025-10-08 14:34:41] In gemini [2025-10-08 14:34:43] In gemini [2025-10-08 14:34:43] [SQL] ChatID:chat_1759840646341 Q: WANT all ca4 documents for election ? A: SQL Query```sql SELECT ed.* FROM election_document AS ed JOIN users AS u ON ed.user_id = u.id WHERE u.user_type = 'CA4'; ```DBsraservices_production [2025-10-08 14:41:18] ChatID:chat_1759840646341 Q: how are you ? A: (Innn Processing...) [2025-10-08 14:41:18] ChatID:chat_1759840646341 Q: how are you ? A: (Processing...) [2025-10-08 14:41:18] In gemini [2025-10-08 14:41:20] In gemini [2025-10-08 14:41:20] [Chat] ChatID:chat_1759840646341 Q: how are you ? A: Hello! I'm an AI assistant, so I don't have feelings, but I'm ready to help you with your queries! How can I assist you today? [2025-10-08 14:42:06] ChatID:chat_1759840646341 Q: what is AI assistance ? A: (Innn Processing...) [2025-10-08 14:42:06] ChatID:chat_1759840646341 Q: what is AI assistance ? A: (Processing...) [2025-10-08 14:42:06] In gemini [2025-10-08 14:42:07] In gemini [2025-10-08 14:42:07] [Chat] ChatID:chat_1759840646341 Q: what is AI assistance ? A: Hello! AI assistance refers to the use of artificial intelligence to help with tasks, provide information, or perform actions, often through virtual assistants, chatbots, or intelligent systems. It's designed to make interactions and tasks more efficient and convenient for users. [2025-10-09 07:00:28] ChatID:chat_1759985775824 Q: hi A: (Innn Processing...) [2025-10-09 07:00:28] ChatID:chat_1759985775824 Q: hi A: (Processing...) [2025-10-09 07:00:28] In gemini [2025-10-09 07:00:29] In gemini [2025-10-09 07:00:29] [Chat] ChatID:chat_1759985775824 Q: hi A: Hello! How may I assist you today? [2025-10-09 07:00:50] ChatID:chat_1759985775824 Q: hi A: (Innn Processing...) [2025-10-09 07:00:50] ChatID:chat_1759985775824 Q: hi A: (Processing...) [2025-10-09 07:00:50] In gemini [2025-10-09 07:00:51] In gemini [2025-10-09 07:00:51] [Chat] ChatID:chat_1759985775824 Q: hi A: Hello! How may I assist you today? [2025-10-09 07:47:06] ChatID:chat_1759985775824 Q: how many sales you have done till now ? A: (Innn Processing...) [2025-10-09 07:47:06] ChatID:chat_1759985775824 Q: how many sales you have done till now ? A: (Processing...) [2025-10-09 07:47:06] In gemini [2025-10-09 07:47:07] In gemini [2025-10-09 07:47:07] In gemini [2025-10-09 07:47:11] In gemini [2025-10-09 07:47:11] In gemini [2025-10-09 07:47:12] In gemini [2025-10-09 07:47:12] [SQL] ChatID:chat_1759985775824 Q: how many sales you have done till now ? A: I apologize, but I was unable to retrieve the sales information from the ERP system at this time. There was no response from the ERP when I tried to query for the data. [2025-10-09 07:48:33] ChatID:chat_1759985775824 Q: how many sales you have done till now ? A: (Innn Processing...) [2025-10-09 07:48:33] ChatID:chat_1759985775824 Q: how many sales you have done till now ? A: (Processing...) [2025-10-09 07:48:33] In gemini [2025-10-09 07:48:34] In gemini [2025-10-09 07:48:34] In gemini [2025-10-09 07:48:37] In gemini [2025-10-09 07:48:37] [SQL query Via gemini] ChatID:chat_1759985775824 Q: how many sales you have done till now ? A: I apologize, but I was unable to retrieve the sales information from the ERP system at this time. There was no response from the ERP when I tried to query for the data. [2025-10-09 07:48:37] In gemini [2025-10-09 07:48:39] In gemini [2025-10-09 07:48:39] [SQL] ChatID:chat_1759985775824 Q: how many sales you have done till now ? A: I apologize, but I was unable to retrieve the sales data from the ERP system at this time. There was no response from the system. [2025-10-09 08:03:30] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: (Innn Processing...) [2025-10-09 08:03:30] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: (Processing...) [2025-10-09 08:03:30] You are a smart assistant. The previous conversation was: Q: hi A: Hello! How may I assist you today? Q: hi A: Hello! How may I assist you today? Q: how many sales you have done till now ? A: I apologize, but I was unable to retrieve the sales information from the ERP system at this time. There was no response from the ERP when I tried to query for the data. Q: how many sales you have done till now ? A: I apologize, but I was unable to retrieve the sales data from the ERP system at this time. There was no response from the system. If the user's message is greeting, polite, or conversational (e.g., 'hello', 'who are you', 'how are you'), respond naturally and formally as a polite chatbot (no database needed). If the message is data or record-related (e.g., 'show pending complaints', 'how many AMCs this month'), respond only with JSON: {"intent": "query"} Message: "how many sales you have done till date ?" In gemini [2025-10-09 08:03:31] In gemini [2025-10-09 08:03:31] You are a smart assistant working inside an ERP system. Your task is to understand the user's question and decide whether it needs a SELECT SQL query or just a plain conversational response. 🟢 If the question is: - Casual or conversational (e.g., 'hi', 'hello', 'how are you?', 'what can you do?') the answer should be in 1-2 statements. - A general ERP-related query that does NOT require fetching records → Respond with a short and natural text reply (1-2 lines), friendly and human-like. 🔵 If the question needs data from the ERP database: → Generate ONLY a valid SELECT SQL query. No explanations or markdown. - You may use JOINs when relationships exist (follow schema link fields). - Use GROUP BY and aggregate functions (COUNT, SUM, AVG) if the question implies totals or summaries. - Prefer INNER JOIN for strict matching, LEFT JOIN if optional. - Always LIMIT results (e.g., 50 rows max) unless explicitly asking for all. RULES for SQL generation: - Use only tables and fields listed in the schema. - Do NOT guess field or table names. - Table names follow ERPNext convention: - Table name = 'tab' + DocType name (e.g., 'Customer' → 'tabCustomer') - If user says 'client', treat it as 'Customer' - For questions related to sales orders, use the 'tabSales Order' table - For questions related to invoices, use the 'tabSales Invoice' table - Always assign an alias to every table (e.g., `tabSales Invoice` → `si`) and use that alias for all field references. - SQL must be valid in MariaDB (MySQL). - Do NOT use unsupported functions like STRFTIME(), json_extract(), datetime(), or ||. - Do NOT use subqueries with LIMIT inside IN/ANY/ALL/SOME. 1. Always consider the full **previous conversation** for context: Q: hi A: Hello! How may I assist you today? Q: hi A: Hello! How may I assist you today? Q: how many sales you have done till now ? A: I apologize, but I was unable to retrieve the sales information from the ERP system at this time. There was no response from the ERP when I tried to query for the data. Q: how many sales you have done till now ? A: I apologize, but I was unable to retrieve the sales data from the ERP system at this time. There was no response from the system. 2. Schema information (tables, columns, relationships): /* SQLyog Community MySQL - 8.0.43-0ubuntu0.24.04.1 : Database - sraservices_production ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `T_HUTOWNERINFODETAILS` */ CREATE TABLE `T_HUTOWNERINFODETAILS` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `ClusterId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `login_id` int DEFAULT NULL, `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `SchemeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTOWNERNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Address` text COLLATE utf8mb4_general_ci, `PropertyType` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `FLOORNUM` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTLENGTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTWIDTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Area` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Jodpatra` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `submission_status` tinyint DEFAULT '0', `application_status` tinyint DEFAULT '0', `resubmit_status` tinyint DEFAULT '0', `hut_survey_status` tinyint DEFAULT '3', `save_status` tinyint DEFAULT '0', `added_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `aadhaar_logs` */ CREATE TABLE `aadhaar_logs` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `user_id` int DEFAULT NULL, `uid` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `encryptHashPIDBlock` longtext COLLATE utf8mb4_general_ci, `encryptPIDBlock` longtext COLLATE utf8mb4_general_ci, `SKey` longtext COLLATE utf8mb4_general_ci, `encUidai` text COLLATE utf8mb4_general_ci, `auaSKey` longtext COLLATE utf8mb4_general_ci, `Token` text COLLATE utf8mb4_general_ci, `txnId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `SubAUAtransId` text COLLATE utf8mb4_general_ci, `Ret` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL, `ResponseMsg` text COLLATE utf8mb4_general_ci, `ResponseTs` varchar(115) COLLATE utf8mb4_general_ci DEFAULT NULL, `ResponseCode` varchar(115) COLLATE utf8mb4_general_ci DEFAULT NULL, `response_message` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `activations` */ CREATE TABLE `activations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL, `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `completed` tinyint(1) NOT NULL DEFAULT '0', `completed_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activations_user_id_index` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `activity_log` */ CREATE TABLE `activity_log` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `log_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `subject_id` int DEFAULT NULL, `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `causer_id` int DEFAULT NULL, `causer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `properties` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_log_log_name_index` (`log_name`) ) ENGINE=InnoDB AUTO_INCREMENT=6247 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `adani_electricity_data` */ CREATE TABLE `adani_electricity_data` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `category` text COLLATE utf8mb4_unicode_ci, `service_provider` text COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text COLLATE utf8mb4_unicode_ci, `ca_no` text COLLATE utf8mb4_unicode_ci, `first_consumer_name` text COLLATE utf8mb4_unicode_ci, `first_bill` text COLLATE utf8mb4_unicode_ci, `change_name_date` text COLLATE utf8mb4_unicode_ci, `change_date` text COLLATE utf8mb4_unicode_ci, `move_in_date` text COLLATE utf8mb4_unicode_ci, `move_out_date` text COLLATE utf8mb4_unicode_ci, `legacy_customer` text COLLATE utf8mb4_unicode_ci, `house_no` text COLLATE utf8mb4_unicode_ci, `tariff` text COLLATE utf8mb4_unicode_ci, `flag_migr` text COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=360 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `adani_electricity_data_draft` */ CREATE TABLE `adani_electricity_data_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `first_consumer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `first_bill` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `change_name_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `change_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `move_in_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `move_out_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `legacy_customer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `house_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `tariff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `flag_migr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `adani_electricity_data_history` */ CREATE TABLE `adani_electricity_data_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `category` text COLLATE utf8mb4_unicode_ci, `service_provider` text COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text COLLATE utf8mb4_unicode_ci, `ca_no` text COLLATE utf8mb4_unicode_ci, `first_consumer_name` text COLLATE utf8mb4_unicode_ci, `first_bill` text COLLATE utf8mb4_unicode_ci, `change_name_date` text COLLATE utf8mb4_unicode_ci, `change_date` text COLLATE utf8mb4_unicode_ci, `move_in_date` text COLLATE utf8mb4_unicode_ci, `move_out_date` text COLLATE utf8mb4_unicode_ci, `legacy_customer` text COLLATE utf8mb4_unicode_ci, `house_no` text COLLATE utf8mb4_unicode_ci, `tariff` text COLLATE utf8mb4_unicode_ci, `flag_migr` text COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `adhar_api_details` */ CREATE TABLE `adhar_api_details` ( `id` int NOT NULL AUTO_INCREMENT, `var_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `var_value` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `certificate1` longtext COLLATE utf8mb4_general_ci, `certificate2` longtext COLLATE utf8mb4_general_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `adhar_details` */ CREATE TABLE `adhar_details` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birth_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_address` text COLLATE utf8mb4_unicode_ci, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `adhar_details_history` */ CREATE TABLE `adhar_details_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birth_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_address` text COLLATE utf8mb4_unicode_ci, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `adhar_document` */ CREATE TABLE `adhar_document` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` text COLLATE utf8mb4_unicode_ci, `dob_mr` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `address_mr` text COLLATE utf8mb4_unicode_ci, `file` longblob, `upload_date` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_adhar_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=393 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `adhar_document_draft` */ CREATE TABLE `adhar_document_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `dob_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `file` longblob, `upload_date` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_adhar_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `adhar_document_history` */ CREATE TABLE `adhar_document_history` ( `id` int NOT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` text COLLATE utf8mb4_unicode_ci, `dob_mr` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `address_mr` text COLLATE utf8mb4_unicode_ci, `file` longblob, `upload_date` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_adhar_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `adhar_document_reject` */ CREATE TABLE `adhar_document_reject` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uid_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dob` text COLLATE utf8mb4_unicode_ci, `dob_mr` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `address_mr` text COLLATE utf8mb4_unicode_ci, `file` longblob, `upload_date` datetime DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_adhar_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `agreement_details` */ CREATE TABLE `agreement_details` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `seller_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=835 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `agreement_details_draft` */ CREATE TABLE `agreement_details_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `seller_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agreement_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `agreement_details_history` */ CREATE TABLE `agreement_details_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `seller_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=821 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `agreement_document` */ CREATE TABLE `agreement_document` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date` text COLLATE utf8mb4_unicode_ci, `seller_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date_mr` text COLLATE utf8mb4_unicode_ci, `seller_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_agreement_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `agreement_document_draft` */ CREATE TABLE `agreement_document_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `seller_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `seller_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_agreement_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `agreement_document_history` */ CREATE TABLE `agreement_document_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date` text COLLATE utf8mb4_unicode_ci, `seller_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date_mr` text COLLATE utf8mb4_unicode_ci, `seller_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_agreement_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `agreement_document_reject` */ CREATE TABLE `agreement_document_reject` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date` text COLLATE utf8mb4_unicode_ci, `seller_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `aggrement_date_mr` text COLLATE utf8mb4_unicode_ci, `seller_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `purchaser_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relationship_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_agreement_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `assign_application_photopass` */ CREATE TABLE `assign_application_photopass` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `assign_application` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `bar_chart_draft_count` */ CREATE TABLE `bar_chart_draft_count` ( `id` int NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_clusters_count` int DEFAULT NULL, `pending_clusters_count` int DEFAULT NULL, `completed_clusters_count` int DEFAULT NULL, `inprogress_clusters_count` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `bar_chart_final_count` */ CREATE TABLE `bar_chart_final_count` ( `id` int NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_clusters_final_count` int DEFAULT NULL, `pending_clusters_final_count` int DEFAULT NULL, `completed_clusters_final_count` int DEFAULT NULL, `inprogress_clusters_final_count` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `bar_doughnut_chart_draft_count` */ CREATE TABLE `bar_doughnut_chart_draft_count` ( `id` int NOT NULL AUTO_INCREMENT, `total_clusters` int DEFAULT NULL, `completed_clusters` int DEFAULT NULL, `pending_clusters` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `bar_doughnut_chart_draft_count_all` */ CREATE TABLE `bar_doughnut_chart_draft_count_all` ( `id` int NOT NULL AUTO_INCREMENT, `user_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `total_clusters` int DEFAULT NULL, `completed_clusters` int DEFAULT NULL, `pending_clusters` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `bar_doughnut_chart_final_count` */ CREATE TABLE `bar_doughnut_chart_final_count` ( `id` int NOT NULL AUTO_INCREMENT, `total_clusters` int DEFAULT NULL, `completed_clusters` int DEFAULT NULL, `pending_clusters` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `bar_doughnut_chart_final_count_all` */ CREATE TABLE `bar_doughnut_chart_final_count_all` ( `id` int NOT NULL AUTO_INCREMENT, `user_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `total_clusters` int DEFAULT NULL, `completed_clusters` int DEFAULT NULL, `pending_clusters` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `bar_pie_chart_draft_count` */ CREATE TABLE `bar_pie_chart_draft_count` ( `id` int NOT NULL AUTO_INCREMENT, `total_count_draft` int DEFAULT NULL, `eligible_count` int DEFAULT NULL, `eligible_percentage` decimal(10,2) DEFAULT NULL, `not_eligible_count` int DEFAULT NULL, `not_eligible_percentage` decimal(10,2) DEFAULT NULL, `undeciede_count` int DEFAULT NULL, `undeciede_percentage` decimal(10,2) DEFAULT NULL, `eligible_charge_count` int DEFAULT NULL, `eligible_charge_percentage` decimal(10,2) DEFAULT NULL, `reject_count` int DEFAULT NULL, `reject_percentage` decimal(10,2) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `bar_pie_chart_final_count` */ CREATE TABLE `bar_pie_chart_final_count` ( `id` int NOT NULL AUTO_INCREMENT, `total_count_final` int DEFAULT NULL, `eligible_hut_id_count` int DEFAULT NULL, `eligible_hut_id_count_percentage` decimal(11,2) DEFAULT NULL, `not_eligible_hut_id_count` int DEFAULT NULL, `not_eligible_hut_id_count_percentage` decimal(10,2) DEFAULT NULL, `undeciede_count` int DEFAULT NULL, `undeciede_percentage` decimal(10,2) DEFAULT NULL, `eligible_charge_count` int DEFAULT NULL, `eligible_charge_percentage` decimal(10,2) DEFAULT NULL, `reject_hut_id_count` int DEFAULT NULL, `reject_hut_id_count_percentage` decimal(10,2) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `downloaded_draft_reports` */ CREATE TABLE `downloaded_draft_reports` ( `id` int NOT NULL AUTO_INCREMENT, `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `file_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `downloaded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int DEFAULT NULL, `type` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `downloaded_final_annexure_reports` */ CREATE TABLE `downloaded_final_annexure_reports` ( `id` int NOT NULL AUTO_INCREMENT, `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `file_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `downloaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int DEFAULT NULL, `type` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `downloaded_supplementary_report` */ CREATE TABLE `downloaded_supplementary_report` ( `id` int NOT NULL AUTO_INCREMENT, `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `file_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `downloaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int DEFAULT NULL, `type` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `election_details` */ CREATE TABLE `election_details` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no` int DEFAULT NULL, `elector_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `age` int DEFAULT NULL, `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `housing` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pincode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `file_upload` text COLLATE utf8mb4_unicode_ci, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `election_details_history` */ CREATE TABLE `election_details_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no` int DEFAULT NULL, `elector_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_sec_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `age` int DEFAULT NULL, `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `housing` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pincode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `file_upload` text COLLATE utf8mb4_unicode_ci, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `election_document` */ CREATE TABLE `election_document` ( `id` int NOT NULL AUTO_INCREMENT, `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` longtext COLLATE utf8mb4_unicode_ci, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_image` longblob, `upload_date` datetime DEFAULT NULL, `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_id_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_mr` longtext COLLATE utf8mb4_unicode_ci, `sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_election_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=261 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; insert into `electricity_document`(`id`,`elector_name`,`elector_name_mr`,`ca_number`,`ca_number_mr`,`bill_date`,`bill_date_mr`,`hut_id`,`elector_address`,`elector_address_mr`,`category`,`category_mr`,`doc_type`,`doc_type_mr`,`bill_image`,`year`,`upload_date`,`service_provider`,`service_provider_mr`,`updated_at`,`status`,`user_id`,`status_manual`,`created_at`,`updated_by`,`final_status`) values (1,'REENA SWAPNIL GAMRE',NULL,'151985032',NULL,'2022-08-27',NULL,'PN_26900001','KARANDE CHAWL SHIVAJI CHOWK JAKERUA ROAD, NR BHARAT GAS, MALAD WEST, MUMBAI 400064',NULL,'RESIDENTIAL',NULL,NULL,NULL,'/9j/4AAQSkZJRgABAgEAlgCWAAD//gAtSW50ZWwoUikgSlBFRyBMafjXEB/wAgiT/v4Kd2Ihb45JG6FtIkbP8A00FLc/HiO2GW0SRvpOP8KE9bDsQTfH6EpldFlH/bYVlap8d5opNh0okH/prVcvvco0rnN+I/ihqOv6NInkJbwrLjaDnpXJf8JLeetY63ZjWbi1bsf//Z','2023','2023-06-07 06:05:06',NULL,NULL,NULL,1,1,1,'2024-07-31 11:37:57',NULL,0); /*Table structure for table `election_document_draft` */ CREATE TABLE `election_document_draft` ( `id` int NOT NULL AUTO_INCREMENT, `voter_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_image` longblob, `upload_date` datetime DEFAULT NULL, `year` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `document_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_id_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_mr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `sr_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_election_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `election_document_history` */ CREATE TABLE `election_document_history` ( `id` int NOT NULL, `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` longtext COLLATE utf8mb4_unicode_ci, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_image` longblob, `upload_date` datetime DEFAULT NULL, `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_id_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_mr` longtext COLLATE utf8mb4_unicode_ci, `sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_election_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `election_document_reject` */ CREATE TABLE `election_document_reject` ( `id` int NOT NULL AUTO_INCREMENT, `voter_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` longtext COLLATE utf8mb4_unicode_ci, `sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_image` longblob, `upload_date` datetime DEFAULT NULL, `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hutment_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_year_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_id_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `voter_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_mr` longtext COLLATE utf8mb4_unicode_ci, `sr_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `part_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `constitution_no_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_election_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `election_integration` */ CREATE TABLE `election_integration` ( `integration_id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `hutment_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_part_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_sr_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_year` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_cont_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_voter_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `year` int DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `hutment_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_part_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_year_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `year_mr` int DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`integration_id`), KEY `IX_election_integration_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `election_integration_draft` */ CREATE TABLE `election_integration_draft` ( `integration_id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `hutment_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_part_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_sr_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_year` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_cont_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_voter_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `year` int DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `hutment_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_part_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_year_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `year_mr` int DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`integration_id`), KEY `IX_election_integration_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `election_integration_history` */ CREATE TABLE `election_integration_history` ( `integration_id` int NOT NULL DEFAULT '0', `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `hutment_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_part_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_sr_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_year` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_cont_no` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_voter_name` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `year` int DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `hutment_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_part_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_sr_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_year_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_cont_no_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `integration_voter_name_mr` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `year_mr` int DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`integration_id`), KEY `IX_election_integration_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `electricity_document` */ CREATE TABLE `electricity_document` ( `id` int NOT NULL AUTO_INCREMENT, `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_address` text COLLATE utf8mb4_unicode_ci, `elector_address_mr` text COLLATE utf8mb4_unicode_ci, `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_image` longblob, `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `upload_date` datetime DEFAULT NULL, `service_provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `service_provider_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint(1) DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_electricity_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=460 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `electricity_document_draft` */ CREATE TABLE `electricity_document_draft` ( `id` int NOT NULL AUTO_INCREMENT, `elector_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `elector_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_image` longblob, `year` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `upload_date` datetime DEFAULT NULL, `service_provider` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `service_provider_mr` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint(1) DEFAULT NULL, `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_electricity_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=263 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `electricity_document_history` */ CREATE TABLE `electricity_document_history` ( `id` int NOT NULL, `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_address` text COLLATE utf8mb4_unicode_ci, `elector_address_mr` text COLLATE utf8mb4_unicode_ci, `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_image` longblob, `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `upload_date` datetime DEFAULT NULL, `service_provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `service_provider_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint(1) DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_electricity_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `electricity_document_reject` */ CREATE TABLE `electricity_document_reject` ( `id` int NOT NULL AUTO_INCREMENT, `elector_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_name_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_number_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_date_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `elector_address` text COLLATE utf8mb4_unicode_ci, `elector_address_mr` text COLLATE utf8mb4_unicode_ci, `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `doc_type_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `bill_image` longblob, `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `upload_date` datetime DEFAULT NULL, `service_provider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `service_provider_mr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` tinyint(1) DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_electricity_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `entity_media` */ CREATE TABLE `entity_media` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `media_id` int unsigned NOT NULL, `entity_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `entity_id` bigint unsigned NOT NULL, `zone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `entity_media_entity_type_entity_id_index` (`entity_type`,`entity_id`), KEY `entity_media_media_id_index` (`media_id`), KEY `entity_media_zone_index` (`zone`), CONSTRAINT `entity_media_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `file_extensions` */ CREATE TABLE `file_extensions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `assign_toall` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `files` */ CREATE TABLE `files` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL, `folder_id` int unsigned NOT NULL DEFAULT '0', `filename` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `extension` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `download` int NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `files_user_id_index` (`user_id`), KEY `files_filename_index` (`filename`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `files_shares` */ CREATE TABLE `files_shares` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `share_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int unsigned NOT NULL, `pwd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `files` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `files_shares_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `final_annexure_details` */ CREATE TABLE `final_annexure_details` ( `id` int NOT NULL AUTO_INCREMENT, `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `total_no_of_huts` int DEFAULT NULL, `completed_status` int DEFAULT '0', `user_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `folders` */ CREATE TABLE `folders` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `parent_id` int unsigned DEFAULT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `position` int unsigned DEFAULT NULL, `assign_toall` tinyint(1) NOT NULL DEFAULT '0', `public_download` tinyint(1) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `folders_slug_unique` (`slug`), KEY `folders_parent_id_foreign` (`parent_id`), CONSTRAINT `folders_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `folders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `front_page` */ CREATE TABLE `front_page` ( `id` int NOT NULL AUTO_INCREMENT, `welcome_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `welcome_content` longtext COLLATE utf8mb4_unicode_ci, `sub_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `main_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `copyright` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `genrate_report` */ CREATE TABLE `genrate_report` ( `id` int NOT NULL AUTO_INCREMENT, `genration_date` timestamp NULL DEFAULT NULL, `scheme_name` text COLLATE utf8mb4_general_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `gumasta_details` */ CREATE TABLE `gumasta_details` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_issue_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_exp_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organisation_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `upload_file` longblob, `nature_of_business` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=274 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `gumasta_details_draft` */ CREATE TABLE `gumasta_details_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_no` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_issue_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_exp_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organisation_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `relationship` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agreement_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `upload_file` longblob, `nature_of_business` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `gumasta_details_history` */ CREATE TABLE `gumasta_details_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_issue_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `License_exp_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organisation_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `relationship` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `agreement_date` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `upload_file` longblob, `nature_of_business` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `gumasta_document` */ CREATE TABLE `gumasta_document` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name` text COLLATE utf8mb4_unicode_ci, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `valid_upto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_gumasta_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `gumasta_document_draft` */ CREATE TABLE `gumasta_document_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `valid_upto` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_gumasta_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `gumasta_document_history` */ CREATE TABLE `gumasta_document_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name` text COLLATE utf8mb4_unicode_ci, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `valid_upto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_gumasta_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `gumasta_document_reject` */ CREATE TABLE `gumasta_document_reject` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name` text COLLATE utf8mb4_unicode_ci, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `valid_upto` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` longblob, `upload_date` datetime DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_number_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_gumasta_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `head_office_members` */ CREATE TABLE `head_office_members` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `post` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `officer_image` longblob, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `hutlist_inprogress_status` */ CREATE TABLE `hutlist_inprogress_status` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_general_ci NOT NULL, `in_progress_status` tinyint DEFAULT '0', `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unique_hut_user` (`hut_id`,`user_id`), KEY `IX_sims_master_hut_ids` (`hut_id`), KEY `IX_sims_master_user_id` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1819 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `jodpatra` */ CREATE TABLE `jodpatra` ( `id` int NOT NULL AUTO_INCREMENT, `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `document_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `self_image` longblob, `declaration_image` longblob, `jodpatra_image` longblob, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `jodpatra_reject` */ CREATE TABLE `jodpatra_reject` ( `id` int NOT NULL AUTO_INCREMENT, `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `document_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `self_image` longblob, `declaration_image` longblob, `jodpatra_image` longblob, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `jurisdictions_details` */ CREATE TABLE `jurisdictions_details` ( `id` int NOT NULL AUTO_INCREMENT, `ca_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ca_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `jurisdictions` longtext COLLATE utf8mb4_unicode_ci, `cluster_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `media` */ CREATE TABLE `media` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL, `filename` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `extension` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `media_user_id_index` (`user_id`), KEY `media_filename_index` (`filename`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `message` */ CREATE TABLE `message` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `message` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `status` tinyint DEFAULT '0', `login_id` int DEFAULT NULL, `user_id` int DEFAULT NULL, `read_status` tinyint DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `migrations` */ CREATE TABLE `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `missing_document` */ CREATE TABLE `missing_document` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `cluster_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `floor_num` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `property_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint NOT NULL DEFAULT '0', `category` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=728 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `missing_election_details` */ CREATE TABLE `missing_election_details` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cluster_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `property_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `floor_num` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint DEFAULT '0', `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `missing_electricity_details` */ CREATE TABLE `missing_electricity_details` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cluster_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` text COLLATE utf8mb4_unicode_ci, `floor_num` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `property_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint DEFAULT '0', `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `mseb_electricity_data` */ CREATE TABLE `mseb_electricity_data` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `category` text COLLATE utf8mb4_unicode_ci, `service_provider` text COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text COLLATE utf8mb4_unicode_ci, `ca_no` text COLLATE utf8mb4_unicode_ci, `first_consumer_name` text COLLATE utf8mb4_unicode_ci, `first_bill` text COLLATE utf8mb4_unicode_ci, `change_name_date` text COLLATE utf8mb4_unicode_ci, `change_date` text COLLATE utf8mb4_unicode_ci, `move_in_date` text COLLATE utf8mb4_unicode_ci, `move_out_date` text COLLATE utf8mb4_unicode_ci, `legacy_customer` text COLLATE utf8mb4_unicode_ci, `house_no` text COLLATE utf8mb4_unicode_ci, `tariff` text COLLATE utf8mb4_unicode_ci, `flag_migr` text COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `mseb_electricity_data_draft` */ CREATE TABLE `mseb_electricity_data_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `first_consumer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `first_bill` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `change_name_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `change_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `move_in_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `move_out_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `legacy_customer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `house_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `tariff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `flag_migr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `mseb_electricity_data_history` */ CREATE TABLE `mseb_electricity_data_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `category` text COLLATE utf8mb4_unicode_ci, `service_provider` text COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text COLLATE utf8mb4_unicode_ci, `ca_no` text COLLATE utf8mb4_unicode_ci, `first_consumer_name` text COLLATE utf8mb4_unicode_ci, `first_bill` text COLLATE utf8mb4_unicode_ci, `change_name_date` text COLLATE utf8mb4_unicode_ci, `change_date` text COLLATE utf8mb4_unicode_ci, `move_in_date` text COLLATE utf8mb4_unicode_ci, `move_out_date` text COLLATE utf8mb4_unicode_ci, `legacy_customer` text COLLATE utf8mb4_unicode_ci, `house_no` text COLLATE utf8mb4_unicode_ci, `tariff` text COLLATE utf8mb4_unicode_ci, `flag_migr` text COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `new_owner_name` */ CREATE TABLE `new_owner_name` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `voter_name_marathi` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `hutment_dweller_to_scheme` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL, `thumb_impression` varchar(3) COLLATE utf8mb4_general_ci DEFAULT 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_general_ci; /*Table structure for table `other_document` */ CREATE TABLE `other_document` ( `id` mediumint NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` longblob, `upload_date` date DEFAULT NULL, `user_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_status` tinyint(1) DEFAULT '0', KEY `id` (`id`), KEY `IX_other_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `other_document_draft` */ CREATE TABLE `other_document_draft` ( `id` mediumint NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` longblob, `upload_date` date DEFAULT NULL, `user_id` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, KEY `id` (`id`), KEY `IX_other_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `other_document_history` */ CREATE TABLE `other_document_history` ( `id` mediumint NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` longblob, `upload_date` date DEFAULT NULL, `user_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, KEY `id` (`id`), KEY `IX_other_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `other_document_reject` */ CREATE TABLE `other_document_reject` ( `id` mediumint NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` longblob, `upload_date` date DEFAULT NULL, `user_id` int DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, KEY `id` (`id`), KEY `IX_other_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `password_resets` */ CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `persistences` */ CREATE TABLE `persistences` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL, `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `persistences_code_unique` (`code`), KEY `persistences_user_id_foreign` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6179 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `photopass_document` */ CREATE TABLE `photopass_document` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_issue_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_org_name` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `validity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `photopass_image` text COLLATE utf8mb4_unicode_ci NOT NULL, `year` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `upload_date` datetime NOT NULL, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `final_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`,`upload_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_abhay_yojana` */ CREATE TABLE `recommendation_abhay_yojana` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `user_id` int NOT NULL DEFAULT '0', `overall_remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `overall_remark_mr` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `overall_eligibility` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `final_annexure_recommendation_status` int DEFAULT NULL, `user` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `recommendation_adhar` */ CREATE TABLE `recommendation_adhar` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int NOT NULL DEFAULT '0', `eligibility_uid` tinyint DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_dob` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `overall_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_uid_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_dob_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_uid` text COLLATE utf8mb4_unicode_ci, `final_uid_mr` text COLLATE utf8mb4_unicode_ci, `final_aadharname` text COLLATE utf8mb4_unicode_ci, `final_aadharname_mr` text COLLATE utf8mb4_unicode_ci, `final_aadhardate` text COLLATE utf8mb4_unicode_ci, `final_aadhardate_mr` text COLLATE utf8mb4_unicode_ci, `final_address` text COLLATE utf8mb4_unicode_ci, `final_address_mr` text COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_adhar_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=472 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_adhar_draft` */ CREATE TABLE `recommendation_adhar_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int NOT NULL DEFAULT '0', `eligibility_uid` tinyint DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_dob` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `remark_uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_uid_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_dob_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_eligibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_uid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_uid_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_aadharname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_aadharname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_aadhardate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_aadhardate_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_adhar_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `recommendation_adhar_history` */ CREATE TABLE `recommendation_adhar_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int NOT NULL DEFAULT '0', `eligibility_uid` tinyint DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_dob` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `remark_uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_uid_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_dob_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_uid` text COLLATE utf8mb4_unicode_ci, `final_uid_mr` text COLLATE utf8mb4_unicode_ci, `final_aadharname` text COLLATE utf8mb4_unicode_ci, `final_aadharname_mr` text COLLATE utf8mb4_unicode_ci, `final_aadhardate` text COLLATE utf8mb4_unicode_ci, `final_aadhardate_mr` text COLLATE utf8mb4_unicode_ci, `final_address` text COLLATE utf8mb4_unicode_ci, `final_address_mr` text COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_adhar_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_agreement` */ CREATE TABLE `recommendation_agreement` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int NOT NULL DEFAULT '0', `eligibility_srno` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_aggrement_date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_seller_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_purchaser_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_relationship` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_srno` text COLLATE utf8mb4_unicode_ci, `remark_srno_mr` text COLLATE utf8mb4_unicode_ci, `remark_type` text COLLATE utf8mb4_unicode_ci, `remark_type_mr` text COLLATE utf8mb4_unicode_ci, `remark_aggrement_date` text COLLATE utf8mb4_unicode_ci, `remark_aggrement_date_mr` text COLLATE utf8mb4_unicode_ci, `remark_seller_name` text COLLATE utf8mb4_unicode_ci, `remark_seller_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_purchaser_name` text COLLATE utf8mb4_unicode_ci, `remark_purchaser_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_relationship` text COLLATE utf8mb4_unicode_ci, `remark_relationship_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` text COLLATE utf8mb4_unicode_ci, `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_srno` text COLLATE utf8mb4_unicode_ci, `final_srno_mr` text COLLATE utf8mb4_unicode_ci, `final_type` text COLLATE utf8mb4_unicode_ci, `final_type_mr` text COLLATE utf8mb4_unicode_ci, `final_date` text COLLATE utf8mb4_unicode_ci, `final_date_mr` text COLLATE utf8mb4_unicode_ci, `final_sname` text COLLATE utf8mb4_unicode_ci, `final_sname_mr` text COLLATE utf8mb4_unicode_ci, `final_pname` text COLLATE utf8mb4_unicode_ci, `final_pname_mr` text COLLATE utf8mb4_unicode_ci, `final_rname` text COLLATE utf8mb4_unicode_ci, `final_rname_mr` text COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_agreement_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1050 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_agreement_draft` */ CREATE TABLE `recommendation_agreement_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int NOT NULL DEFAULT '0', `eligibility_srno` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_aggrement_date` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_seller_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_purchaser_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_relationship` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_srno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_srno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_type_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_aggrement_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_aggrement_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_seller_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_seller_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_purchaser_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_purchaser_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_relationship` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_relationship_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_eligibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_srno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_srno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_type_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_sname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_sname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_pname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_pname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_rname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_rname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_agreement_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `recommendation_agreement_history` */ CREATE TABLE `recommendation_agreement_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int NOT NULL DEFAULT '0', `eligibility_srno` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_type` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_aggrement_date` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_seller_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_purchaser_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_relationship` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_srno` text COLLATE utf8mb4_unicode_ci, `remark_srno_mr` text COLLATE utf8mb4_unicode_ci, `remark_type` text COLLATE utf8mb4_unicode_ci, `remark_type_mr` text COLLATE utf8mb4_unicode_ci, `remark_aggrement_date` text COLLATE utf8mb4_unicode_ci, `remark_aggrement_date_mr` text COLLATE utf8mb4_unicode_ci, `remark_seller_name` text COLLATE utf8mb4_unicode_ci, `remark_seller_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_purchaser_name` text COLLATE utf8mb4_unicode_ci, `remark_purchaser_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_relationship` text COLLATE utf8mb4_unicode_ci, `remark_relationship_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` text COLLATE utf8mb4_unicode_ci, `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_srno` text COLLATE utf8mb4_unicode_ci, `final_srno_mr` text COLLATE utf8mb4_unicode_ci, `final_type` text COLLATE utf8mb4_unicode_ci, `final_type_mr` text COLLATE utf8mb4_unicode_ci, `final_date` text COLLATE utf8mb4_unicode_ci, `final_date_mr` text COLLATE utf8mb4_unicode_ci, `final_sname` text COLLATE utf8mb4_unicode_ci, `final_sname_mr` text COLLATE utf8mb4_unicode_ci, `final_pname` text COLLATE utf8mb4_unicode_ci, `final_pname_mr` text COLLATE utf8mb4_unicode_ci, `final_rname` text COLLATE utf8mb4_unicode_ci, `final_rname_mr` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_agreement_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_election` */ CREATE TABLE `recommendation_election` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_number` tinyint DEFAULT '0', `eligibility_type` tinyint DEFAULT '0', `eligibility_const_no` tinyint DEFAULT '0', `eligibility_sr_no` tinyint DEFAULT '0', `eligibility_part_no` tinyint DEFAULT '0', `remark_name` text COLLATE utf8mb4_unicode_ci, `remark_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` text COLLATE utf8mb4_unicode_ci, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_number` text COLLATE utf8mb4_unicode_ci, `remark_number_mr` text COLLATE utf8mb4_unicode_ci, `remark_type` text COLLATE utf8mb4_unicode_ci, `remark_type_mr` text COLLATE utf8mb4_unicode_ci, `remark_const_no` text COLLATE utf8mb4_unicode_ci, `remark_const_no_mr` text COLLATE utf8mb4_unicode_ci, `remark_sr_no` text COLLATE utf8mb4_unicode_ci, `remark_sr_no_mr` text COLLATE utf8mb4_unicode_ci, `remark_part_no` text COLLATE utf8mb4_unicode_ci, `remark_part_no_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT NULL, `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `final_electorname` text COLLATE utf8mb4_unicode_ci, `final_electorname_mr` text COLLATE utf8mb4_unicode_ci, `final_electoraddress` text COLLATE utf8mb4_unicode_ci, `final_electoraddress_mr` text COLLATE utf8mb4_unicode_ci, `final_electornumber` text COLLATE utf8mb4_unicode_ci, `final_electornumber_mr` text COLLATE utf8mb4_unicode_ci, `final_electortype` text COLLATE utf8mb4_unicode_ci, `final_electortype_mr` text COLLATE utf8mb4_unicode_ci, `final_electorconstitute` text COLLATE utf8mb4_unicode_ci, `final_electorconstitute_mr` text COLLATE utf8mb4_unicode_ci, `final_electorsr_no` text COLLATE utf8mb4_unicode_ci, `final_electorsr_no_mr` text COLLATE utf8mb4_unicode_ci, `final_electorpart_no` text COLLATE utf8mb4_unicode_ci, `final_electorpart_no_mr` text COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_election_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_election_draft` */ CREATE TABLE `recommendation_election_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_number` tinyint DEFAULT '0', `eligibility_type` tinyint DEFAULT '0', `eligibility_const_no` tinyint DEFAULT '0', `eligibility_sr_no` tinyint DEFAULT '0', `eligibility_part_no` tinyint DEFAULT '0', `remark_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_number_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_type` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_type_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_const_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_const_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_sr_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_sr_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_part_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_part_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark_mr` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT NULL, `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `final_electorname` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electorname_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electoraddress` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electoraddress_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electornumber` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electornumber_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electortype` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electortype_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electorconstitute` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electorconstitute_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electorsr_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electorsr_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electorpart_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_electorpart_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_election_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `recommendation_election_history` */ CREATE TABLE `recommendation_election_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` int DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_number` tinyint DEFAULT '0', `eligibility_type` tinyint DEFAULT '0', `eligibility_const_no` tinyint DEFAULT '0', `eligibility_sr_no` tinyint DEFAULT '0', `eligibility_part_no` tinyint DEFAULT '0', `remark_name` text COLLATE utf8mb4_unicode_ci, `remark_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` text COLLATE utf8mb4_unicode_ci, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_number` text COLLATE utf8mb4_unicode_ci, `remark_number_mr` text COLLATE utf8mb4_unicode_ci, `remark_type` text COLLATE utf8mb4_unicode_ci, `remark_type_mr` text COLLATE utf8mb4_unicode_ci, `remark_const_no` text COLLATE utf8mb4_unicode_ci, `remark_const_no_mr` text COLLATE utf8mb4_unicode_ci, `remark_sr_no` text COLLATE utf8mb4_unicode_ci, `remark_sr_no_mr` text COLLATE utf8mb4_unicode_ci, `remark_part_no` text COLLATE utf8mb4_unicode_ci, `remark_part_no_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT NULL, `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `final_electorname` text COLLATE utf8mb4_unicode_ci, `final_electorname_mr` text COLLATE utf8mb4_unicode_ci, `final_electoraddress` text COLLATE utf8mb4_unicode_ci, `final_electoraddress_mr` text COLLATE utf8mb4_unicode_ci, `final_electornumber` text COLLATE utf8mb4_unicode_ci, `final_electornumber_mr` text COLLATE utf8mb4_unicode_ci, `final_electortype` text COLLATE utf8mb4_unicode_ci, `final_electortype_mr` text COLLATE utf8mb4_unicode_ci, `final_electorconstitute` text COLLATE utf8mb4_unicode_ci, `final_electorconstitute_mr` text COLLATE utf8mb4_unicode_ci, `final_electorsr_no` text COLLATE utf8mb4_unicode_ci, `final_electorsr_no_mr` text COLLATE utf8mb4_unicode_ci, `final_electorpart_no` text COLLATE utf8mb4_unicode_ci, `final_electorpart_no_mr` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_election_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_electricity` */ CREATE TABLE `recommendation_electricity` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL DEFAULT '0', `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name` text COLLATE utf8mb4_unicode_ci, `remark_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` text COLLATE utf8mb4_unicode_ci, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_category` text COLLATE utf8mb4_unicode_ci, `remark_category_mr` text COLLATE utf8mb4_unicode_ci, `remark_serviceprovider` text COLLATE utf8mb4_unicode_ci, `remark_serviceprovider_mr` text COLLATE utf8mb4_unicode_ci, `remark_ca` text COLLATE utf8mb4_unicode_ci, `remark_ca_mr` text COLLATE utf8mb4_unicode_ci, `remark_billdate` text COLLATE utf8mb4_unicode_ci, `remark_billdate_mr` text COLLATE utf8mb4_unicode_ci, `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_category` tinyint DEFAULT '0', `eligibility_serviceprovider` tinyint DEFAULT '0', `eligibility_ca` tinyint DEFAULT '0', `eligibility_billdate` tinyint DEFAULT '0', `overall_remark` longtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` longtext COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT '0', `user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_category` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_category_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_service_provider` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_service_provider_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_ca` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_ca_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_bill_date` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_bill_date_mr` text COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_electricity_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1247 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_electricity_draft` */ CREATE TABLE `recommendation_electricity_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL DEFAULT '0', `year` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_category_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_serviceprovider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_serviceprovider_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_ca` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_ca_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_billdate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_billdate_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_category` tinyint DEFAULT '0', `eligibility_serviceprovider` tinyint DEFAULT '0', `eligibility_ca` tinyint DEFAULT '0', `eligibility_billdate` tinyint DEFAULT '0', `overall_remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark_mr` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT '0', `user` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `final_highest_percentage_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_category_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_service_provider_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_ca` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_ca_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_bill_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_bill_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_electricity_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `recommendation_electricity_history` */ CREATE TABLE `recommendation_electricity_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int NOT NULL DEFAULT '0', `year` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name` text COLLATE utf8mb4_unicode_ci, `remark_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` text COLLATE utf8mb4_unicode_ci, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_category` text COLLATE utf8mb4_unicode_ci, `remark_category_mr` text COLLATE utf8mb4_unicode_ci, `remark_serviceprovider` text COLLATE utf8mb4_unicode_ci, `remark_serviceprovider_mr` text COLLATE utf8mb4_unicode_ci, `remark_ca` text COLLATE utf8mb4_unicode_ci, `remark_ca_mr` text COLLATE utf8mb4_unicode_ci, `remark_billdate` text COLLATE utf8mb4_unicode_ci, `remark_billdate_mr` text COLLATE utf8mb4_unicode_ci, `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_category` tinyint DEFAULT '0', `eligibility_serviceprovider` tinyint DEFAULT '0', `eligibility_ca` tinyint DEFAULT '0', `eligibility_billdate` tinyint DEFAULT '0', `overall_remark` longtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` longtext COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT '0', `user` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_category` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_category_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_service_provider` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_service_provider_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_ca` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_ca_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_bill_date` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_bill_date_mr` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_electricity_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1178 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_gumasta` */ CREATE TABLE `recommendation_gumasta` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int DEFAULT '0', `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_licanse_name` tinyint DEFAULT '0', `eligibility_licanse_issue_date` tinyint DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_owner_org_name` tinyint DEFAULT '0', `eligibility_validity` tinyint DEFAULT '0', `remark_licanse_name` text COLLATE utf8mb4_unicode_ci, `remark_licanse_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_licanse_issue_date` text COLLATE utf8mb4_unicode_ci, `remark_licanse_issue_date_mr` text COLLATE utf8mb4_unicode_ci, `remark_owner_org_name` text COLLATE utf8mb4_unicode_ci, `remark_owner_org_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_owner_name` text COLLATE utf8mb4_unicode_ci, `remark_owner_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` text COLLATE utf8mb4_unicode_ci, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_validity` text COLLATE utf8mb4_unicode_ci, `remark_validity_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT '0', `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `final_highest_percentage_licno` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_licno_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_issuedate` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_issuedate_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_org` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_org_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_valid` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_valid_mr` text COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_gumasta_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_gumasta_draft` */ CREATE TABLE `recommendation_gumasta_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int DEFAULT '0', `year` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_licanse_name` tinyint DEFAULT '0', `eligibility_licanse_issue_date` tinyint DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_owner_org_name` tinyint DEFAULT '0', `eligibility_validity` tinyint DEFAULT '0', `remark_licanse_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_licanse_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_licanse_issue_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_licanse_issue_date_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_owner_org_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_owner_org_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_owner_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_validity` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_validity_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark_mr` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT '0', `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `final_highest_percentage_licno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_licno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_issuedate` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_issuedate_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_org` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_org_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_valid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_highest_percentage_valid_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_gumasta_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `recommendation_gumasta_history` */ CREATE TABLE `recommendation_gumasta_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` int DEFAULT '0', `year` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_licanse_name` tinyint DEFAULT '0', `eligibility_licanse_issue_date` tinyint DEFAULT '0', `eligibility_name` tinyint DEFAULT '0', `eligibility_address` tinyint DEFAULT '0', `eligibility_owner_org_name` tinyint DEFAULT '0', `eligibility_validity` tinyint DEFAULT '0', `remark_licanse_name` text COLLATE utf8mb4_unicode_ci, `remark_licanse_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_licanse_issue_date` text COLLATE utf8mb4_unicode_ci, `remark_licanse_issue_date_mr` text COLLATE utf8mb4_unicode_ci, `remark_owner_org_name` text COLLATE utf8mb4_unicode_ci, `remark_owner_org_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_owner_name` text COLLATE utf8mb4_unicode_ci, `remark_owner_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` text COLLATE utf8mb4_unicode_ci, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_validity` text COLLATE utf8mb4_unicode_ci, `remark_validity_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` mediumtext COLLATE utf8mb4_unicode_ci, `overall_remark_mr` mediumtext COLLATE utf8mb4_unicode_ci, `overall_eligibility` tinyint DEFAULT '0', `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `final_highest_percentage_licno` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_licno_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_issuedate` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_issuedate_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_org` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_org_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_name_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_address_mr` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_valid` text COLLATE utf8mb4_unicode_ci, `final_highest_percentage_valid_mr` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_gumasta_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_photopass` */ CREATE TABLE `recommendation_photopass` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_application_no` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_name` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_application_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_application_no_mr` text COLLATE utf8mb4_unicode_ci, `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_landarea_mr` text COLLATE utf8mb4_unicode_ci, `remark_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_ownership_mr` text COLLATE utf8mb4_unicode_ci, `remark_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_use_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark_mr` text COLLATE utf8mb4_unicode_ci, `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_applicationno` text COLLATE utf8mb4_unicode_ci, `final_applicationno_mr` text COLLATE utf8mb4_unicode_ci, `final_name` text COLLATE utf8mb4_unicode_ci, `final_name_mr` text COLLATE utf8mb4_unicode_ci, `final_address` text COLLATE utf8mb4_unicode_ci, `final_address_mr` text COLLATE utf8mb4_unicode_ci, `final_use` text COLLATE utf8mb4_unicode_ci, `final_use_mr` text COLLATE utf8mb4_unicode_ci, `final_annexure_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_recommendation_photopass_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=414 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `recommendation_photopass_draft` */ CREATE TABLE `recommendation_photopass_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(28) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_application_no` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_name` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_landarea` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_ownership` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_application_no_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_landarea` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_landarea_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_ownership` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_ownership_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `remark_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_use_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `overall_eligibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_applicationno` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_applicationno_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_name_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_address_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_use` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `final_use_mr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_photopass_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `recommendation_photopass_history` */ CREATE TABLE `recommendation_photopass_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(28) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_application_no` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_name` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `eligibility_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_application_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_application_no_mr` text COLLATE utf8mb4_unicode_ci, `remark_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_name_mr` text COLLATE utf8mb4_unicode_ci, `remark_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_address_mr` text COLLATE utf8mb4_unicode_ci, `remark_landarea` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_landarea_mr` text COLLATE utf8mb4_unicode_ci, `remark_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_ownership_mr` text COLLATE utf8mb4_unicode_ci, `remark_use` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remark_use_mr` text COLLATE utf8mb4_unicode_ci, `overall_remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overall_remark_mr` text COLLATE utf8mb4_unicode_ci, `overall_eligibility` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_applicationno` text COLLATE utf8mb4_unicode_ci, `final_applicationno_mr` text COLLATE utf8mb4_unicode_ci, `final_name` text COLLATE utf8mb4_unicode_ci, `final_name_mr` text COLLATE utf8mb4_unicode_ci, `final_address` text COLLATE utf8mb4_unicode_ci, `final_address_mr` text COLLATE utf8mb4_unicode_ci, `final_use` text COLLATE utf8mb4_unicode_ci, `final_use_mr` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IX_recommendation_photopass_hut_user_id` (`hut_id`,`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `reminders` */ CREATE TABLE `reminders` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned NOT NULL, `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `completed` tinyint(1) NOT NULL DEFAULT '0', `completed_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `reminders_user_id_foreign` (`user_id`), CONSTRAINT `reminders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_backup` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `reopen_appeal` */ CREATE TABLE `reopen_appeal` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `appeal` tinyint DEFAULT '1', `appeal_by` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `appeal_date` timestamp NULL DEFAULT NULL, `assign_date` timestamp NULL DEFAULT NULL, `completion_date` timestamp NULL DEFAULT NULL, `user_id` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `report_title` */ CREATE TABLE `report_title` ( `title_id` int NOT NULL AUTO_INCREMENT, `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `residing_at` text COLLATE utf8mb4_general_ci, `situated_at` text COLLATE utf8mb4_general_ci, PRIMARY KEY (`title_id`), KEY `title_id` (`title_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `roles` */ CREATE TABLE `roles` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `sort_order_no` int DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `roles_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `setting_translations` */ CREATE TABLE `setting_translations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `setting_id` int unsigned NOT NULL, `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `setting_translations_setting_id_locale_unique` (`setting_id`,`locale`), CONSTRAINT `setting_translations_setting_id_foreign` FOREIGN KEY (`setting_id`) REFERENCES `settings` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `settings` */ CREATE TABLE `settings` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `plainValue` text COLLATE utf8mb4_unicode_ci, `isTranslatable` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `sims_master` */ CREATE TABLE `sims_master` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint NOT NULL DEFAULT '0', `overall_status` tinyint NOT NULL DEFAULT '0', `remark` text COLLATE utf8mb4_unicode_ci, `remark_mr` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `final_status` int DEFAULT '0', `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rejected_date` timestamp NULL DEFAULT NULL, `rejected_status` tinyint DEFAULT '0', `history_type` tinyint DEFAULT '1', PRIMARY KEY (`id`), KEY `IX_sims_master_hut_user_id` (`hut_id`,`user_id`), KEY `IX_sims_master_overall_status` (`overall_status`), KEY `IX_sims_master_user_id` (`user_id`), KEY `IX_sims_master_status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `sims_master_detail` */ CREATE TABLE `sims_master_detail` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `electricity_status` tinyint DEFAULT '0', `electricity_remark` text COLLATE utf8mb4_unicode_ci, `electricity_remark_mr` text COLLATE utf8mb4_unicode_ci, `election_status` tinyint DEFAULT '0', `election_remark` text COLLATE utf8mb4_unicode_ci, `election_remark_mr` text COLLATE utf8mb4_unicode_ci, `gumasta_status` tinyint DEFAULT '0', `gumasta_remark` text COLLATE utf8mb4_unicode_ci, `gumasta_remark_mr` text COLLATE utf8mb4_unicode_ci, `photopass_status` tinyint DEFAULT '0', `photopass_remark` text COLLATE utf8mb4_unicode_ci, `photopass_remark_mr` text COLLATE utf8mb4_unicode_ci, `agreement_status` tinyint DEFAULT '0', `agreement_remark` text COLLATE utf8mb4_unicode_ci, `agreement_remark_mr` text COLLATE utf8mb4_unicode_ci, `adhar_status` tinyint DEFAULT '0', `adhar_remark` text COLLATE utf8mb4_unicode_ci, `adhar_remark_mr` text COLLATE utf8mb4_unicode_ci, `overall_status` tinyint DEFAULT '0', `overall_remark` text COLLATE utf8mb4_unicode_ci, `overall_remark_mr` text COLLATE utf8mb4_unicode_ci, `voter_name_marathi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint DEFAULT '0', `user_id` int DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `final_annexure` int DEFAULT '0', `in_progress_status` int DEFAULT '0', `rejected_status` tinyint DEFAULT '0', `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rejected_date` timestamp NULL DEFAULT NULL, `resubmission_status` tinyint DEFAULT '0', `data_type` tinyint DEFAULT '1', `reopen_status` tinyint DEFAULT '0', `final_adhar_recommendation_status` int DEFAULT '0', `abhay_yojana_status` tinyint DEFAULT '0', `abhay_yojana_remark` text COLLATE utf8mb4_unicode_ci, `abhay_yojana_remark_mr` text COLLATE utf8mb4_unicode_ci, `final_abhay_yojana_recommendation_status` int DEFAULT '0', `final_agreement_recommendation_status` int DEFAULT '0', `final_gumasta_recommendation_status` int DEFAULT '0', `final_photopass_recommendation_status` int DEFAULT '0', `final_electricity_recommendation_status` int DEFAULT '0', `final_election_recommendation_status` int DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_sims_master_detail_hut_user_id` (`hut_id`,`user_id`), KEY `IX_sims_master_detail_updated_at` (`updated_at`), KEY `IX_sims_master_user_id` (`user_id`), KEY `IX_sims_master_status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=1146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `sims_master_detail_history` */ CREATE TABLE `sims_master_detail_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `electricity_status` tinyint DEFAULT '0', `electricity_remark` text COLLATE utf8mb4_unicode_ci, `electricity_remark_mr` text COLLATE utf8mb4_unicode_ci, `election_status` tinyint DEFAULT '0', `election_remark` text COLLATE utf8mb4_unicode_ci, `election_remark_mr` text COLLATE utf8mb4_unicode_ci, `gumasta_status` tinyint DEFAULT '0', `gumasta_remark` text COLLATE utf8mb4_unicode_ci, `gumasta_remark_mr` text COLLATE utf8mb4_unicode_ci, `photopass_status` tinyint DEFAULT '0', `photopass_remark` text COLLATE utf8mb4_unicode_ci, `photopass_remark_mr` text COLLATE utf8mb4_unicode_ci, `agreement_status` tinyint DEFAULT '0', `agreement_remark` text COLLATE utf8mb4_unicode_ci, `agreement_remark_mr` text COLLATE utf8mb4_unicode_ci, `adhar_status` tinyint DEFAULT '0', `adhar_remark` text COLLATE utf8mb4_unicode_ci, `adhar_remark_mr` text COLLATE utf8mb4_unicode_ci, `overall_status` tinyint DEFAULT '0', `overall_remark` text COLLATE utf8mb4_unicode_ci, `overall_remark_mr` text COLLATE utf8mb4_unicode_ci, `voter_name_marathi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint DEFAULT '0', `user_id` int DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `final_annexure` int DEFAULT '0', `in_progress_status` int DEFAULT '0', `rejected_status` tinyint DEFAULT '0', `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rejected_date` timestamp NULL DEFAULT NULL, `resubmission_status` tinyint DEFAULT '0', `data_type` tinyint DEFAULT '1', `reopen_status` tinyint DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `unique_key` (`hut_id`,`user_id`,`data_type`), KEY `IX_sims_master_detail_hut_user_id` (`hut_id`,`user_id`), KEY `IX_sims_master_detail_updated_at` (`updated_at`), KEY `IX_sims_master_user_id` (`user_id`), KEY `IX_sims_master_status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=6964 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `sims_master_history` */ CREATE TABLE `sims_master_history` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint NOT NULL DEFAULT '0', `overall_status` tinyint NOT NULL DEFAULT '0', `remark` text COLLATE utf8mb4_unicode_ci, `remark_mr` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `final_status` int DEFAULT '0', `rejected_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `rejected_date` timestamp NULL DEFAULT NULL, `rejected_status` tinyint DEFAULT '0', `history_type` tinyint DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `unique_key` (`user_id`,`history_type`,`hut_id`), KEY `IX_sims_master_hut_user_id` (`hut_id`,`user_id`), KEY `IX_sims_master_overall_status` (`overall_status`), KEY `IX_sims_master_user_id` (`user_id`), KEY `IX_sims_master_status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=879 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `simsdoc` */ CREATE TABLE `simsdoc` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `simsDocument` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `DocumentTypeId` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `newname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `skip_repeted_close_hut` */ CREATE TABLE `skip_repeted_close_hut` ( `id` int NOT NULL AUTO_INCREMENT, `cluster_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `sra` */ CREATE TABLE `sra` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `log_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `subject_id` int DEFAULT NULL, `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `causer_id` int DEFAULT NULL, `causer_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `properties` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_log_log_name_index` (`log_name`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `sralocalusers` */ CREATE TABLE `sralocalusers` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `firstname` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `lastname` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `survey_receipt_document` */ CREATE TABLE `survey_receipt_document` ( `id` int NOT NULL AUTO_INCREMENT, `survey_receipt_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_as_per_survey_receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt` text COLLATE utf8mb4_unicode_ci, `usage_type_of_hut` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `area_of_hut` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_image` longblob, `upload_date` datetime DEFAULT CURRENT_TIMESTAMP, `year` int DEFAULT NULL, `land_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `status_manual` tinyint(1) DEFAULT '0', `name_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `usage_type_of_hut_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `final_status` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `IX_survey_receipt_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `survey_receipt_document_draft` */ CREATE TABLE `survey_receipt_document_draft` ( `id` int NOT NULL AUTO_INCREMENT, `survey_receipt_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_as_per_survey_receipt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `usage_type_of_hut` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `area_of_hut` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_image` longblob, `upload_date` datetime DEFAULT CURRENT_TIMESTAMP, `year` int DEFAULT NULL, `land_ownership` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `status_manual` tinyint(1) DEFAULT '0', `name_as_per_survey_receipt_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_no_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `usage_type_of_hut_mr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_survey_receipt_document_hut_id` (`hut_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `survey_receipt_document_history` */ CREATE TABLE `survey_receipt_document_history` ( `id` int NOT NULL AUTO_INCREMENT, `survey_receipt_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_as_per_survey_receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt` text COLLATE utf8mb4_unicode_ci, `usage_type_of_hut` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `area_of_hut` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_image` longblob, `upload_date` datetime DEFAULT CURRENT_TIMESTAMP, `year` int DEFAULT NULL, `land_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `status_manual` tinyint(1) DEFAULT '0', `name_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `usage_type_of_hut_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_survey_receipt_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `survey_receipt_document_reject` */ CREATE TABLE `survey_receipt_document_reject` ( `id` int NOT NULL AUTO_INCREMENT, `survey_receipt_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name_as_per_survey_receipt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt` text COLLATE utf8mb4_unicode_ci, `usage_type_of_hut` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `area_of_hut` varchar(99) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_image` longblob, `upload_date` datetime DEFAULT CURRENT_TIMESTAMP, `year` int DEFAULT NULL, `land_ownership` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) DEFAULT '0', `status_manual` tinyint(1) DEFAULT '0', `name_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_as_per_survey_receipt_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `survey_receipt_no_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `usage_type_of_hut_mr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_survey_receipt_document_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `t_abhay_yojana_info` */ CREATE TABLE `t_abhay_yojana_info` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `ClusterId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `SchemeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `year_selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `sulm_evivtion_report` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `upload_document` longblob, `added_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `status` tinyint(1) DEFAULT NULL, `status_manual` tinyint(1) DEFAULT '0', `final_status` tinyint(1) DEFAULT '0', KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `t_hutownerfamilyinfodetails` */ CREATE TABLE `t_hutownerfamilyinfodetails` ( `id` int NOT NULL AUTO_INCREMENT, `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `FFNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `FMNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `FLNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `UIDNO` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `FamilyInfoId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `RelName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `t_hutownerinfodetails` */ CREATE TABLE `t_hutownerinfodetails` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `ClusterId` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTSURVERYID` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `SchemeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTOWNERNAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Address` text COLLATE utf8mb4_general_ci, `PropertyType` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `FLOORNUM` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTLENGTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `HUTWIDTH` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Area` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `Jodpatra` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `submission_status` tinyint DEFAULT '0', `application_status` tinyint DEFAULT '0', `resubmit_status` tinyint DEFAULT '0', `hut_survey_status` tinyint DEFAULT '3', `save_status` tinyint DEFAULT '0', `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `jodpatra3` longblob, `jodpatra4` longblob, `form_A` longblob, `form_B` longblob, `self_assesmen` longblob, `self_declarion` longblob, `Jodpatra1` longblob, `Jodpatra2` longblob, `upload_document` longblob, `original_annexure_copy` longblob, `selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `year_selection` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `sulm_evivtion_report` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1220 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `tata_electricity_data` */ CREATE TABLE `tata_electricity_data` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `category` text COLLATE utf8mb4_unicode_ci, `service_provider` text COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text COLLATE utf8mb4_unicode_ci, `ca_no` text COLLATE utf8mb4_unicode_ci, `first_consumer_name` text COLLATE utf8mb4_unicode_ci, `first_bill` text COLLATE utf8mb4_unicode_ci, `change_name_date` text COLLATE utf8mb4_unicode_ci, `change_date` text COLLATE utf8mb4_unicode_ci, `move_in_date` text COLLATE utf8mb4_unicode_ci, `move_out_date` text COLLATE utf8mb4_unicode_ci, `legacy_customer` text COLLATE utf8mb4_unicode_ci, `house_no` text COLLATE utf8mb4_unicode_ci, `tariff` text COLLATE utf8mb4_unicode_ci, `flag_migr` text COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `tata_electricity_data_draft` */ CREATE TABLE `tata_electricity_data_draft` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `category` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `service_provider` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ca_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `first_consumer_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `first_bill` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `change_name_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `change_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `move_in_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `move_out_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `legacy_customer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `house_no` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `tariff` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `flag_migr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `tata_electricity_data_history` */ CREATE TABLE `tata_electricity_data_history` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `owner_name` text COLLATE utf8mb4_unicode_ci, `address` text COLLATE utf8mb4_unicode_ci, `category` text COLLATE utf8mb4_unicode_ci, `service_provider` text COLLATE utf8mb4_unicode_ci, `legacy_ca_no` text COLLATE utf8mb4_unicode_ci, `ca_no` text COLLATE utf8mb4_unicode_ci, `first_consumer_name` text COLLATE utf8mb4_unicode_ci, `first_bill` text COLLATE utf8mb4_unicode_ci, `change_name_date` text COLLATE utf8mb4_unicode_ci, `change_date` text COLLATE utf8mb4_unicode_ci, `move_in_date` text COLLATE utf8mb4_unicode_ci, `move_out_date` text COLLATE utf8mb4_unicode_ci, `legacy_customer` text COLLATE utf8mb4_unicode_ci, `house_no` text COLLATE utf8mb4_unicode_ci, `tariff` text COLLATE utf8mb4_unicode_ci, `flag_migr` text COLLATE utf8mb4_unicode_ci, `year` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `history_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `throttle` */ CREATE TABLE `throttle` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `user_id` int unsigned DEFAULT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `throttle_user_id_foreign` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2200 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `translation_translations` */ CREATE TABLE `translation_translations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `translation_id` int unsigned NOT NULL, `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `translation_translations_translation_id_locale_unique` (`translation_id`,`locale`), CONSTRAINT `translation_translations_translation_id_foreign` FOREIGN KEY (`translation_id`) REFERENCES `translations` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `translations` */ CREATE TABLE `translations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `translations_key_index` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `user_file_extensions` */ CREATE TABLE `user_file_extensions` ( `user_id` int unsigned NOT NULL, `file_extension_id` int unsigned NOT NULL, PRIMARY KEY (`user_id`,`file_extension_id`), KEY `user_file_extensions_file_extension_id_foreign` (`file_extension_id`), CONSTRAINT `user_file_extensions_file_extension_id_foreign` FOREIGN KEY (`file_extension_id`) REFERENCES `file_extensions` (`id`) ON DELETE CASCADE, CONSTRAINT `user_file_extensions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_backup` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `user_folders` */ CREATE TABLE `user_folders` ( `user_id` int unsigned NOT NULL, `folder_id` int unsigned NOT NULL, PRIMARY KEY (`user_id`,`folder_id`), KEY `user_folders_folder_id_foreign` (`folder_id`), CONSTRAINT `user_folders_folder_id_foreign` FOREIGN KEY (`folder_id`) REFERENCES `folders` (`id`) ON DELETE CASCADE, CONSTRAINT `user_folders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users_backup` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `user_roles` */ CREATE TABLE `user_roles` ( `user_id` int unsigned NOT NULL, `role_id` int unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`user_id`,`role_id`), KEY `user_roles_role_id_foreign` (`role_id`), CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `users` */ CREATE TABLE `users` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `file_size` text COLLATE utf8mb4_unicode_ci, `last_login` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `cluster_id` text COLLATE utf8mb4_unicode_ci, `sponsor_id` int DEFAULT '1', `otp` int DEFAULT NULL, `parent_id` int DEFAULT '1', `user_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sort_order` int DEFAULT '0', `otp_send` timestamp NULL DEFAULT NULL, `village_id` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), KEY `IX_users_parent_id_sort` (`parent_id`,`sort_order`) ) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; insert into `users`(`id`,`first_name`,`last_name`,`username`,`email`,`password`,`permissions`,`file_size`,`last_login`,`created_at`,`updated_at`,`cluster_id`,`sponsor_id`,`otp`,`parent_id`,`user_type`,`sort_order`,`otp_send`,`village_id`) values (1,'sample','data','sampledat1','sample@gmail.com','$2y$10$qtFFphezfjvMe6jo1pzcuuqk1Mz/KIukB1lqENTCj9j5rnJdIHkly','{\"admin.activity.index\":false,\"admin.sra.index\":true,\"admin.sra.frontpage\":false,\"admin.sra.front_store\":false,\"admin.sra.get_jurisdiction\":false,\"admin.sra.store_jurisdiction\":false,\"admin.sra.delete_jurisdictions\":false,\"admin.sra.get_head_office_member\":false,\"admin.sra.store_head_office_member\":false,\"admin.sra.delete_head_office_member\":false,\"admin.files.manager\":false,\"admin.files.index\":false,\"admin.files.create\":false,\"admin.files.edit\":false,\"admin.files.destroy\":false,\"admin.files-extension.index\":false,\"admin.files-extension.create\":false,\"admin.files-extension.destroy\":false,\"admin.folders.index\":false,\"admin.folders.create\":false,\"admin.folders.edit\":false,\"admin.folders.destroy\":false,\"admin.media.index\":false,\"admin.media.create\":false,\"admin.media.destroy\":false,\"admin.settings.edit\":false,\"admin.translations.index\":false,\"admin.translations.edit\":false,\"admin.users.index\":true,\"admin.users.create\":true,\"admin.users.edit\":true,\"admin.users.destroy\":true,\"admin.roles.index\":false,\"admin.roles.create\":false,\"admin.roles.edit\":false,\"admin.roles.destroy\":false}','','2024-08-02 04:44:56','2023-03-25 10:01:40','2024-08-02 04:44:56','HE_084',0,7546,0,'admin',0,'2024-08-02 04:44:56',NULL); /*Table structure for table `users_backup` */ CREATE TABLE `users_backup` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `file_size` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `last_login` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `cluster_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sponsor_id` int DEFAULT '1', `otp` int DEFAULT NULL, `parent_id` int DEFAULT '1', `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sort_order` int DEFAULT '0', `otp_send` timestamp NULL DEFAULT NULL, `village_id` text COLLATE utf8mb4_general_ci, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*Table structure for table `users_history` */ CREATE TABLE `users_history` ( `h_id` int unsigned NOT NULL AUTO_INCREMENT, `id` int DEFAULT NULL, `first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `permissions` text COLLATE utf8mb4_unicode_ci, `file_size` text COLLATE utf8mb4_unicode_ci, `last_login` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `cluster_id` text COLLATE utf8mb4_unicode_ci, `sponsor_id` int DEFAULT '1', `otp` int DEFAULT NULL, `parent_id` int DEFAULT '1', `user_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sort_order` int DEFAULT '0', `otp_send` timestamp NULL DEFAULT NULL, `village_id` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`h_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1794 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Table structure for table `voter_name_marathi` */ CREATE TABLE `voter_name_marathi` ( `id` int NOT NULL AUTO_INCREMENT, `hut_id` varchar(191) COLLATE utf8mb4_general_ci DEFAULT NULL, `voter_name_marathi` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `hutment_dweller_to_scheme` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL, `thumb_impression` varchar(3) COLLATE utf8mb4_general_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `IX_voter_name_marathi_hut_id` (`hut_id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /* Trigger structure for table `adani_electricity_data` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `adani_electricity_data_insert` AFTER INSERT ON `adani_electricity_data` FOR EACH ROW BEGIN INSERT INTO adani_electricity_data_history ( hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name, first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, flag_migr, YEAR, created_at, updated_at, user_id, history_value ) VALUES ( NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no, NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date, NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'insert' ); END */$$ DELIMITER ; /* Trigger structure for table `adani_electricity_data` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `adani_electricity_data_update` AFTER UPDATE ON `adani_electricity_data` FOR EACH ROW BEGIN INSERT INTO adani_electricity_data_history ( hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name, first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, flag_migr, YEAR, created_at, updated_at, user_id, history_value ) VALUES ( NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no, NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date, NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'update' ); END */$$ DELIMITER ; /* Trigger structure for table `adhar_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `adhar_details_insert` AFTER INSERT ON `adhar_details` FOR EACH ROW BEGIN INSERT INTO `adhar_details_history` (hut_id, uid_no, owner_name, birth_date, owner_address, `year`, created_at, updated_at, user_id, updated_by, history_value) VALUES (NEW.hut_id, NEW.uid_no, NEW.owner_name, NEW.birth_date, NEW.owner_address, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'insert'); END */$$ DELIMITER ; /* Trigger structure for table `adhar_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `adhar_details_update` AFTER UPDATE ON `adhar_details` FOR EACH ROW BEGIN INSERT INTO `adhar_details_history` (hut_id, uid_no, owner_name, birth_date, owner_address, `year`, created_at, updated_at, user_id, updated_by, history_value) VALUES (NEW.hut_id, NEW.uid_no, NEW.owner_name, NEW.birth_date, NEW.owner_address, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'update'); END */$$ DELIMITER ; /* Trigger structure for table `agreement_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `agreement_details_insert` AFTER INSERT ON `agreement_details` FOR EACH ROW BEGIN INSERT INTO `agreement_details_history` (hut_id, sr_no, document, seller_name, purchaser_name, relationship, agreement_date, `year`, created_at, updated_at, updated_by, user_id, history_value) VALUES (NEW.hut_id, NEW.sr_no, NEW.document, NEW.seller_name, NEW.purchaser_name, NEW.relationship, NEW.agreement_date, NEW.year, NEW.created_at, NEW.updated_at, NEW.updated_by, NEW.user_id, 'insert'); END */$$ DELIMITER ; /* Trigger structure for table `agreement_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `agreement_details_update` AFTER UPDATE ON `agreement_details` FOR EACH ROW BEGIN INSERT INTO `agreement_details_history` (hut_id, sr_no, document, seller_name, purchaser_name, relationship, agreement_date, `year`, created_at, updated_at, updated_by, user_id, history_value) VALUES (NEW.hut_id, NEW.sr_no, NEW.document, NEW.seller_name, NEW.purchaser_name, NEW.relationship, NEW.agreement_date, NEW.year, NEW.created_at, NEW.updated_at, NEW.updated_by, NEW.user_id, 'update'); END */$$ DELIMITER ; /* Trigger structure for table `election_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_details_update` AFTER INSERT ON `election_details` FOR EACH ROW BEGIN INSERT INTO `election_details_history` (hut_id, voter_id, sr_no, cont_no, part_no, elector_name, elector_sec_name, age, gender, housing, pincode, address, file_upload, `year`, created_at, updated_at, user_id, updated_by, history_value) VALUES (NEW.hut_id, NEW.voter_id, NEW.sr_no, NEW.cont_no, NEW.part_no, NEW.elector_name, NEW.elector_sec_name, NEW.age, NEW.gender, NEW.housing, NEW.pincode, NEW.address, NEW.file_upload, NEW.year, NEW.created_at, NEW.updated_at,NEW.user_id, NEW.updated_by, 'update'); END */$$ DELIMITER ; /* Trigger structure for table `election_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_details_insert` AFTER INSERT ON `election_details` FOR EACH ROW BEGIN INSERT INTO `election_details_history` (hut_id, voter_id, sr_no, cont_no, part_no, elector_name, elector_sec_name, age, gender, housing, pincode, address, file_upload, `year`, created_at, updated_at, user_id, updated_by, history_value) VALUES (NEW.hut_id, NEW.voter_id, NEW.sr_no, NEW.cont_no, NEW.part_no, NEW.elector_name, NEW.elector_sec_name, NEW.age, NEW.gender, NEW.housing, NEW.pincode, NEW.address, NEW.file_upload, NEW.year, NEW.created_at, NEW.updated_at,NEW.user_id, NEW.updated_by, 'insert'); END */$$ DELIMITER ; /* Trigger structure for table `election_integration` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_integration_insert` AFTER INSERT ON `election_integration` FOR EACH ROW BEGIN INSERT INTO `election_integration_history` (integration_id, hut_id, hutment_no, integration_part_no, integration_sr_no, integration_year, integration_cont_no, integration_voter_name, `year`, updated_at, hutment_no_mr, integration_part_no_mr, integration_sr_no_mr, integration_year_mr, integration_cont_no_mr, integration_voter_name_mr, year_mr, user_id, created_at, updated_by, history_value) VALUES (NEW.integration_id, NEW.hut_id, NEW.hutment_no, NEW.integration_part_no, NEW.integration_sr_no, NEW.integration_year, NEW.integration_cont_no, NEW.integration_voter_name, NEW.year, NEW.updated_at, NEW.hutment_no_mr, NEW.integration_part_no_mr, NEW.integration_sr_no_mr, NEW.integration_year_mr, NEW.integration_cont_no_mr, NEW.integration_voter_name_mr, NEW.year_mr, NEW.user_id, NEW.created_at, NEW.updated_by, 'insert'); END */$$ DELIMITER ; /* Trigger structure for table `election_integration` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `election_integration_update` AFTER INSERT ON `election_integration` FOR EACH ROW BEGIN INSERT INTO `election_integration_history` (integration_id, hut_id, hutment_no, integration_part_no, integration_sr_no, integration_year, integration_cont_no, integration_voter_name, `year`, updated_at, hutment_no_mr, integration_part_no_mr, integration_sr_no_mr, integration_year_mr, integration_cont_no_mr, integration_voter_name_mr, year_mr, user_id, created_at, updated_by, history_value) VALUES (NEW.integration_id, NEW.hut_id, NEW.hutment_no, NEW.integration_part_no, NEW.integration_sr_no, NEW.integration_year, NEW.integration_cont_no, NEW.integration_voter_name, NEW.year, NEW.updated_at, NEW.hutment_no_mr, NEW.integration_part_no_mr, NEW.integration_sr_no_mr, NEW.integration_year_mr, NEW.integration_cont_no_mr, NEW.integration_voter_name_mr, NEW.year_mr, NEW.user_id, NEW.created_at, NEW.updated_by, 'update'); END */$$ DELIMITER ; /* Trigger structure for table `gumasta_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `gumasta_details_insert` AFTER INSERT ON `gumasta_details` FOR EACH ROW BEGIN INSERT INTO `gumasta_details_history` (hut_id, License_no, License_issue_date, License_exp_date, organisation_name, name, address, relationship, agreement_date, year, upload_file, nature_of_business, created_at, updated_at, user_id, updated_by, history_value) VALUES (NEW.hut_id, NEW.License_no, NEW.License_issue_date, NEW.License_exp_date, NEW.organisation_name, NEW.name, NEW.address, NEW.relationship, NEW.agreement_date, NEW.year, NEW.upload_file, NEW.nature_of_business, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'insert'); END */$$ DELIMITER ; /* Trigger structure for table `gumasta_details` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `gumasta_details_update` AFTER INSERT ON `gumasta_details` FOR EACH ROW BEGIN INSERT INTO `gumasta_details_history` (hut_id, License_no, License_issue_date, License_exp_date, organisation_name, name, address, relationship, agreement_date, year, upload_file, nature_of_business, created_at, updated_at, user_id, updated_by, history_value) VALUES (NEW.hut_id, NEW.License_no, NEW.License_issue_date, NEW.License_exp_date, NEW.organisation_name, NEW.name, NEW.address, NEW.relationship, NEW.agreement_date, NEW.year, NEW.upload_file, NEW.nature_of_business, NEW.created_at, NEW.updated_at, NEW.user_id, NEW.updated_by, 'update'); END */$$ DELIMITER ; /* Trigger structure for table `mseb_electricity_data` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `mseb_electricity_data_insert` AFTER INSERT ON `mseb_electricity_data` FOR EACH ROW BEGIN INSERT INTO `mseb_electricity_data_history` (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name, first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, flag_migr, year, created_at, updated_at, user_id, history_value) VALUES (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no, NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date, NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'insert'); END */$$ DELIMITER ; /* Trigger structure for table `mseb_electricity_data` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `mseb_electricity_data_update` AFTER UPDATE ON `mseb_electricity_data` FOR EACH ROW BEGIN INSERT INTO `mseb_electricity_data_history` (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name, first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, flag_migr, year, created_at, updated_at, user_id, history_value) VALUES (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no, NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date, NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'update'); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_adhar` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_adhar_insert` AFTER INSERT ON `recommendation_adhar` FOR EACH ROW BEGIN INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`, `user_id`) VALUES (NEW.hut_id, 1, NEW.user_id) ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_adhar` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_adhar_delete` AFTER DELETE ON `recommendation_adhar` FOR EACH ROW BEGIN INSERT INTO `recommendation_adhar_history` ( `hut_id`, `year`, `user_id`, `eligibility_uid`, `eligibility_name`, `eligibility_dob`, `eligibility_address`, `remark_uid`, `remark_uid_mr`, `remark_name`, `remark_name_mr`, `remark_dob`, `remark_dob_mr`, `remark_address`, `remark_address_mr`, `overall_remark`, `overall_remark_mr`, `overall_eligibility`, `user`, `created_at`, `final_uid`, `final_uid_mr`, `final_aadharname`, `final_aadharname_mr`, `final_aadhardate`, `final_aadhardate_mr`, `final_address`, `final_address_mr` ) VALUES ( OLD.hut_id, OLD.year, OLD.user_id, OLD.eligibility_uid, OLD.eligibility_name, OLD.eligibility_dob, OLD.eligibility_address, OLD.remark_uid, OLD.remark_uid_mr, OLD.remark_name, OLD.remark_name_mr, OLD.remark_dob, OLD.remark_dob_mr, OLD.remark_address, OLD.remark_address_mr, OLD.overall_remark, OLD.overall_remark_mr, OLD.overall_eligibility, OLD.user, OLD.created_at, OLD.final_uid, OLD.final_uid_mr, OLD.final_aadharname, OLD.final_aadharname_mr, OLD.final_aadhardate, OLD.final_aadhardate_mr, OLD.final_address, OLD.final_address_mr ); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_agreement` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_agreement_insert` AFTER INSERT ON `recommendation_agreement` FOR EACH ROW BEGIN INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) VALUES (NEW.hut_id, 1,NEW.user_id) ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_agreement` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_agreement_delete` AFTER DELETE ON `recommendation_agreement` FOR EACH ROW BEGIN INSERT INTO `recommendation_agreement_history` ( `hut_id`, `year`, `user_id`, `eligibility_srno`, `eligibility_type`, `eligibility_aggrement_date`, `eligibility_seller_name`, `eligibility_purchaser_name`, `eligibility_relationship`, `remark_srno`, `remark_srno_mr`, `remark_type`, `remark_type_mr`, `remark_aggrement_date`, `remark_aggrement_date_mr`, `remark_seller_name`, `remark_seller_name_mr`, `remark_purchaser_name`, `remark_purchaser_name_mr`, `remark_relationship`, `remark_relationship_mr`, `overall_remark`, `overall_remark_mr`, `overall_eligibility`, `user`, `created_at`, `final_srno`, `final_srno_mr`, `final_type`, `final_type_mr`, `final_date`, `final_date_mr`, `final_sname`, `final_sname_mr`, `final_pname`, `final_pname_mr`, `final_rname`, `final_rname_mr` ) VALUES ( OLD.hut_id, OLD.year, OLD.user_id, OLD.eligibility_srno, OLD.eligibility_type, OLD.eligibility_aggrement_date, OLD.eligibility_seller_name, OLD.eligibility_purchaser_name, OLD.eligibility_relationship, OLD.remark_srno, OLD.remark_srno_mr, OLD.remark_type, OLD.remark_type_mr, OLD.remark_aggrement_date, OLD.remark_aggrement_date_mr, OLD.remark_seller_name, OLD.remark_seller_name_mr, OLD.remark_purchaser_name, OLD.remark_purchaser_name_mr, OLD.remark_relationship, OLD.remark_relationship_mr, OLD.overall_remark, OLD.overall_remark_mr, OLD.overall_eligibility, OLD.user, OLD.created_at, OLD.final_srno, OLD.final_srno_mr, OLD.final_type, OLD.final_type_mr, OLD.final_date, OLD.final_date_mr, OLD.final_sname, OLD.final_sname_mr, OLD.final_pname, OLD.final_pname_mr, OLD.final_rname, OLD.final_rname_mr ); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_election` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_election_insert` AFTER INSERT ON `recommendation_election` FOR EACH ROW BEGIN INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) VALUES (NEW.hut_id, 1,NEW.user_id) ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_election` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_election_delete` AFTER DELETE ON `recommendation_election` FOR EACH ROW BEGIN INSERT INTO `recommendation_election_history` ( `hut_id`, `year`, `user_id`, `eligibility_name`, `eligibility_address`, `eligibility_number`, `eligibility_type`, `eligibility_const_no`, `eligibility_sr_no`, `eligibility_part_no`, `remark_name`, `remark_name_mr`, `remark_address`, `remark_address_mr`, `remark_number`, `remark_number_mr`, `remark_type`, `remark_type_mr`, `remark_const_no`, `remark_const_no_mr`, `remark_sr_no`, `remark_sr_no_mr`, `remark_part_no`, `remark_part_no_mr`, `overall_remark`, `overall_remark_mr`, `overall_eligibility`, `user`, `created_at`, `final_electorname`, `final_electorname_mr`, `final_electoraddress`, `final_electoraddress_mr`, `final_electornumber`, `final_electornumber_mr`, `final_electortype`, `final_electortype_mr`, `final_electorconstitute`, `final_electorconstitute_mr`, `final_electorsr_no`, `final_electorsr_no_mr`, `final_electorpart_no`, `final_electorpart_no_mr` ) VALUES ( OLD.hut_id, OLD.year, OLD.user_id, OLD.eligibility_name, OLD.eligibility_address, OLD.eligibility_number, OLD.eligibility_type, OLD.eligibility_const_no, OLD.eligibility_sr_no, OLD.eligibility_part_no, OLD.remark_name, OLD.remark_name_mr, OLD.remark_address, OLD.remark_address_mr, OLD.remark_number, OLD.remark_number_mr, OLD.remark_type, OLD.remark_type_mr, OLD.remark_const_no, OLD.remark_const_no_mr, OLD.remark_sr_no, OLD.remark_sr_no_mr, OLD.remark_part_no, OLD.remark_part_no_mr, OLD.overall_remark, OLD.overall_remark_mr, OLD.overall_eligibility, OLD.user, OLD.created_at, OLD.final_electorname, OLD.final_electorname_mr, OLD.final_electoraddress, OLD.final_electoraddress_mr, OLD.final_electornumber, OLD.final_electornumber_mr, OLD.final_electortype, OLD.final_electortype_mr, OLD.final_electorconstitute, OLD.final_electorconstitute_mr, OLD.final_electorsr_no, OLD.final_electorsr_no_mr, OLD.final_electorpart_no, OLD.final_electorpart_no_mr ); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_electricity` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_electricity_insert` AFTER INSERT ON `recommendation_electricity` FOR EACH ROW BEGIN INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) VALUES (NEW.hut_id, 1,NEW.user_id) ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_electricity` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_electricity_delete` AFTER DELETE ON `recommendation_electricity` FOR EACH ROW BEGIN INSERT INTO `recommendation_electricity_history` ( `id`, `hut_id`, `user_id`, `year`, `remark_name`, `remark_name_mr`, `remark_address`, `remark_address_mr`, `remark_category`, `remark_category_mr`, `remark_serviceprovider`, `remark_serviceprovider_mr`, `remark_ca`, `remark_ca_mr`, `remark_billdate`, `remark_billdate_mr`, `eligibility_name`, `eligibility_address`, `eligibility_category`, `eligibility_serviceprovider`, `eligibility_ca`, `eligibility_billdate`, `overall_remark`, `overall_remark_mr`, `overall_eligibility`, `user`, `created_at`, `final_highest_percentage_name`, `final_highest_percentage_name_mr`, `final_highest_percentage_address`, `final_highest_percentage_address_mr`, `final_highest_percentage_category`, `final_highest_percentage_category_mr`, `final_highest_percentage_service_provider`, `final_highest_percentage_service_provider_mr`, `final_highest_percentage_ca`, `final_highest_percentage_ca_mr`, `final_highest_percentage_bill_date`, `final_highest_percentage_bill_date_mr` ) VALUES ( OLD.id, OLD.hut_id, OLD.user_id, OLD.year, OLD.remark_name, OLD.remark_name_mr, OLD.remark_address, OLD.remark_address_mr, OLD.remark_category, OLD.remark_category_mr, OLD.remark_serviceprovider, OLD.remark_serviceprovider_mr, OLD.remark_ca, OLD.remark_ca_mr, OLD.remark_billdate, OLD.remark_billdate_mr, OLD.eligibility_name, OLD.eligibility_address, OLD.eligibility_category, OLD.eligibility_serviceprovider, OLD.eligibility_ca, OLD.eligibility_billdate, OLD.overall_remark, OLD.overall_remark_mr, OLD.overall_eligibility, OLD.user, OLD.created_at, OLD.final_highest_percentage_name, OLD.final_highest_percentage_name_mr, OLD.final_highest_percentage_address, OLD.final_highest_percentage_address_mr, OLD.final_highest_percentage_category, OLD.final_highest_percentage_category_mr, OLD.final_highest_percentage_service_provider, OLD.final_highest_percentage_service_provider_mr, OLD.final_highest_percentage_ca, OLD.final_highest_percentage_ca_mr, OLD.final_highest_percentage_bill_date, OLD.final_highest_percentage_bill_date_mr ); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_gumasta` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_gumasta_insert` AFTER INSERT ON `recommendation_gumasta` FOR EACH ROW BEGIN INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) VALUES (NEW.hut_id, 1,NEW.user_id) ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_gumasta` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_gumasta_delete` AFTER DELETE ON `recommendation_gumasta` FOR EACH ROW BEGIN INSERT INTO `recommendation_gumasta_history` ( `hut_id`, `user_id`, `year`, `eligibility_licanse_name`, `eligibility_licanse_issue_date`, `eligibility_name`, `eligibility_address`, `eligibility_owner_org_name`, `eligibility_validity`, `remark_licanse_name`, `remark_licanse_name_mr`, `remark_licanse_issue_date`, `remark_licanse_issue_date_mr`, `remark_owner_org_name`, `remark_owner_org_name_mr`, `remark_owner_name`, `remark_owner_name_mr`, `remark_address`, `remark_address_mr`, `remark_validity`, `remark_validity_mr`, `overall_remark`, `overall_remark_mr`, `overall_eligibility`, `user`, `created_at`, `final_highest_percentage_licno`, `final_highest_percentage_licno_mr`, `final_highest_percentage_issuedate`, `final_highest_percentage_issuedate_mr`, `final_highest_percentage_org`, `final_highest_percentage_org_mr`, `final_highest_percentage_name`, `final_highest_percentage_name_mr`, `final_highest_percentage_address`, `final_highest_percentage_address_mr`, `final_highest_percentage_valid`, `final_highest_percentage_valid_mr` ) VALUES ( OLD.hut_id, OLD.user_id, OLD.year, OLD.eligibility_licanse_name, OLD.eligibility_licanse_issue_date, OLD.eligibility_name, OLD.eligibility_address, OLD.eligibility_owner_org_name, OLD.eligibility_validity, OLD.remark_licanse_name, OLD.remark_licanse_name_mr, OLD.remark_licanse_issue_date, OLD.remark_licanse_issue_date_mr, OLD.remark_owner_org_name, OLD.remark_owner_org_name_mr, OLD.remark_owner_name, OLD.remark_owner_name_mr, OLD.remark_address, OLD.remark_address_mr, OLD.remark_validity, OLD.remark_validity_mr, OLD.overall_remark, OLD.overall_remark_mr, OLD.overall_eligibility, OLD.user, OLD.created_at, OLD.final_highest_percentage_licno, OLD.final_highest_percentage_licno_mr, OLD.final_highest_percentage_issuedate, OLD.final_highest_percentage_issuedate_mr, OLD.final_highest_percentage_org, OLD.final_highest_percentage_org_mr, OLD.final_highest_percentage_name, OLD.final_highest_percentage_name_mr, OLD.final_highest_percentage_address, OLD.final_highest_percentage_address_mr, OLD.final_highest_percentage_valid, OLD.final_highest_percentage_valid_mr ); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_photopass` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `recommandation_photopass_insert` AFTER INSERT ON `recommendation_photopass` FOR EACH ROW BEGIN INSERT INTO `hutlist_inprogress_status` (`hut_id`, `in_progress_status`,`user_id`) VALUES (NEW.hut_id, 1, NEW.user_id) ON DUPLICATE KEY UPDATE `in_progress_status` = VALUES(`in_progress_status`); END */$$ DELIMITER ; /* Trigger structure for table `recommendation_photopass` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `recommendation_photopass_delete` AFTER DELETE ON `recommendation_photopass` FOR EACH ROW BEGIN INSERT INTO `recommendation_photopass_history` ( `hut_id`, `year`, `user_id`, `eligibility_application_no`, `eligibility_name`, `eligibility_address`, `eligibility_landarea`, `eligibility_ownership`, `eligibility_use`, `remark_application_no`, `remark_application_no_mr`, `remark_name`, `remark_name_mr`, `remark_address`, `remark_address_mr`, `remark_landarea`, `remark_landarea_mr`, `remark_ownership`, `remark_ownership_mr`, `remark_use`, `remark_use_mr`, `overall_remark`, `overall_remark_mr`, `overall_eligibility`, `user`, `created_at`, `final_applicationno`, `final_applicationno_mr`, `final_name`, `final_name_mr`, `final_address`, `final_address_mr`, `final_use`, `final_use_mr` ) VALUES ( OLD.hut_id, OLD.year, OLD.user_id, OLD.eligibility_application_no, OLD.eligibility_name, OLD.eligibility_address, OLD.eligibility_landarea, OLD.eligibility_ownership, OLD.eligibility_use, OLD.remark_application_no, OLD.remark_application_no_mr, OLD.remark_name, OLD.remark_name_mr, OLD.remark_address, OLD.remark_address_mr, OLD.remark_landarea, OLD.remark_landarea_mr, OLD.remark_ownership, OLD.remark_ownership_mr, OLD.remark_use, OLD.remark_use_mr, OLD.overall_remark, OLD.overall_remark_mr, OLD.overall_eligibility, OLD.user, OLD.created_at, OLD.final_applicationno, OLD.final_applicationno_mr, OLD.final_name, OLD.final_name_mr, OLD.final_address, OLD.final_address_mr, OLD.final_use, OLD.final_use_mr ); END */$$ DELIMITER ; /* Trigger structure for table `sims_master` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_history_insert` AFTER INSERT ON `sims_master` FOR EACH ROW BEGIN INSERT INTO `sims_master_history` ( `user_id`, `hut_id`, `status`, `overall_status`, `remark`, `remark_mr`, `created_at`, `updated_at`, `final_status`, `rejected_by`, `rejected_date`, `rejected_status`,`history_type` ) VALUES ( NEW.user_id, NEW.hut_id, NEW.status, NEW.overall_status, NEW.remark, NEW.remark_mr, NEW.created_at, NEW.updated_at, NEW.final_status, NEW.rejected_by, NEW.rejected_date, NEW.rejected_status, NEW.history_type ) ON DUPLICATE KEY UPDATE `status` = VALUES(`status`), `overall_status` = VALUES(`overall_status`), `remark` = VALUES(`remark`), `remark_mr` = VALUES(`remark_mr`), `created_at` = VALUES(`created_at`), `updated_at` = VALUES(`updated_at`), `final_status` = VALUES(`final_status`), `rejected_by` = VALUES(`rejected_by`), `rejected_date` = VALUES(`rejected_date`), `rejected_status` = VALUES(`rejected_status`); END */$$ DELIMITER ; /* Trigger structure for table `sims_master` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_history_update` AFTER UPDATE ON `sims_master` FOR EACH ROW BEGIN INSERT INTO `sims_master_history` ( `user_id`, `hut_id`, `status`, `overall_status`, `remark`, `remark_mr`, `created_at`, `updated_at`, `final_status`, `rejected_by`, `rejected_date`, `rejected_status`,`history_type` ) VALUES ( NEW.user_id, NEW.hut_id, NEW.status, NEW.overall_status, NEW.remark, NEW.remark_mr, NEW.created_at, NEW.updated_at, NEW.final_status, NEW.rejected_by, NEW.rejected_date, NEW.rejected_status, NEW.history_type ) ON DUPLICATE KEY UPDATE `status` = VALUES(`status`), `overall_status` = VALUES(`overall_status`), `remark` = VALUES(`remark`), `remark_mr` = VALUES(`remark_mr`), `created_at` = VALUES(`created_at`), `updated_at` = VALUES(`updated_at`), `final_status` = VALUES(`final_status`), `rejected_by` = VALUES(`rejected_by`), `rejected_date` = VALUES(`rejected_date`), `rejected_status` = VALUES(`rejected_status`); END */$$ DELIMITER ; /* Trigger structure for table `sims_master_detail` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_detail_history_insert` AFTER INSERT ON `sims_master_detail` FOR EACH ROW BEGIN INSERT INTO `sims_master_detail_history` ( `hut_id`, `electricity_status`, `electricity_remark`, `electricity_remark_mr`, `election_status`,`election_remark`,`election_remark_mr`,`gumasta_status`,`gumasta_remark`,`gumasta_remark_mr`,`photopass_status`,`photopass_remark`,`photopass_remark_mr`,`agreement_status`,`agreement_remark`,`agreement_remark_mr`,`adhar_status`,`adhar_remark`,`adhar_remark_mr`,`overall_status`,`overall_remark`,`overall_remark_mr`,`voter_name_marathi`,`status`,`user_id`,`created_at`,`updated_at`,`final_annexure`,`in_progress_status`,`rejected_status`,`rejected_by`,`rejected_date`,`resubmission_status`,`data_type` ) VALUES ( NEW.hut_id, NEW.electricity_status, NEW.electricity_remark, NEW.electricity_remark_mr, NEW.election_status, NEW.election_remark, NEW.election_remark_mr, NEW.gumasta_status, NEW.gumasta_remark, NEW.gumasta_remark_mr, NEW.photopass_status, NEW.photopass_remark, NEW.photopass_remark_mr, NEW.agreement_status, NEW.agreement_remark, NEW.agreement_remark_mr, NEW.adhar_status, NEW.adhar_remark, NEW.adhar_remark_mr, NEW.overall_status, NEW.overall_remark, NEW.overall_remark_mr, NEW.voter_name_marathi, NEW.status, NEW.user_id, NEW.created_at, NEW.updated_at, NEW.final_annexure, NEW.in_progress_status, NEW.rejected_status, NEW.rejected_by, NEW.rejected_date, NEW.resubmission_status, NEW.data_type ) ON DUPLICATE KEY UPDATE `electricity_status` = VALUES(`electricity_status`), `electricity_remark` = VALUES(`electricity_remark`), `electricity_remark_mr` = VALUES(`electricity_remark_mr`), `election_status` = VALUES(`election_status`), `election_remark` = VALUES(`election_remark`), `election_remark_mr` = VALUES(`election_remark_mr`), `gumasta_status` = VALUES(`gumasta_status`), `gumasta_remark` = VALUES(`gumasta_remark`), `gumasta_remark_mr` = VALUES(`gumasta_remark_mr`), `photopass_status` = VALUES(`photopass_status`), `photopass_remark` = VALUES(`photopass_remark`), `photopass_remark_mr` = VALUES(`photopass_remark_mr`), `agreement_status` = VALUES(`agreement_status`), `agreement_remark` = VALUES(`agreement_remark`), `agreement_remark_mr` = VALUES(`agreement_remark_mr`), `adhar_status` = VALUES(`adhar_status`), `adhar_remark` = VALUES(`adhar_remark`), `adhar_remark_mr` = VALUES(`adhar_remark_mr`), `overall_status` = VALUES(`overall_status`), `overall_remark` = VALUES(`overall_remark`), `overall_remark_mr` = VALUES(`overall_remark_mr`), `voter_name_marathi` = VALUES(`voter_name_marathi`), `status` = VALUES(`status`), `created_at` = VALUES(`created_at`), `updated_at` = VALUES(`updated_at`), `final_annexure` = VALUES(`final_annexure`), `in_progress_status` = VALUES(`in_progress_status`), `rejected_status` = VALUES(`rejected_status`), `rejected_by` = VALUES(`rejected_by`), `rejected_date` = VALUES(`rejected_date`), `resubmission_status` = VALUES(`resubmission_status`); END */$$ DELIMITER ; /* Trigger structure for table `sims_master_detail` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `sims_master_detail_history_updates` AFTER UPDATE ON `sims_master_detail` FOR EACH ROW BEGIN INSERT INTO `sims_master_detail_history` ( `hut_id`, `electricity_status`, `electricity_remark`, `electricity_remark_mr`, `election_status`,`election_remark`,`election_remark_mr`,`gumasta_status`,`gumasta_remark`,`gumasta_remark_mr`,`photopass_status`,`photopass_remark`,`photopass_remark_mr`,`agreement_status`,`agreement_remark`,`agreement_remark_mr`,`adhar_status`,`adhar_remark`,`adhar_remark_mr`,`overall_status`,`overall_remark`,`overall_remark_mr`,`voter_name_marathi`,`status`,`user_id`,`created_at`,`updated_at`,`final_annexure`,`in_progress_status`,`rejected_status`,`rejected_by`,`rejected_date`,`resubmission_status`,`data_type` ) VALUES ( NEW.hut_id, NEW.electricity_status, NEW.electricity_remark, NEW.electricity_remark_mr, NEW.election_status, NEW.election_remark, NEW.election_remark_mr, NEW.gumasta_status, NEW.gumasta_remark, NEW.gumasta_remark_mr, NEW.photopass_status, NEW.photopass_remark, NEW.photopass_remark_mr, NEW.agreement_status, NEW.agreement_remark, NEW.agreement_remark_mr, NEW.adhar_status, NEW.adhar_remark, NEW.adhar_remark_mr, NEW.overall_status, NEW.overall_remark, NEW.overall_remark_mr, NEW.voter_name_marathi, NEW.status, NEW.user_id, NEW.created_at, NEW.updated_at, NEW.final_annexure, NEW.in_progress_status, NEW.rejected_status, NEW.rejected_by, NEW.rejected_date, NEW.resubmission_status, NEW.data_type ) ON DUPLICATE KEY UPDATE `electricity_status` = VALUES(`electricity_status`), `electricity_remark` = VALUES(`electricity_remark`), `electricity_remark_mr` = VALUES(`electricity_remark_mr`), `election_status` = VALUES(`election_status`), `election_remark` = VALUES(`election_remark`), `election_remark_mr` = VALUES(`election_remark_mr`), `gumasta_status` = VALUES(`gumasta_status`), `gumasta_remark` = VALUES(`gumasta_remark`), `gumasta_remark_mr` = VALUES(`gumasta_remark_mr`), `photopass_status` = VALUES(`photopass_status`), `photopass_remark` = VALUES(`photopass_remark`), `photopass_remark_mr` = VALUES(`photopass_remark_mr`), `agreement_status` = VALUES(`agreement_status`), `agreement_remark` = VALUES(`agreement_remark`), `agreement_remark_mr` = VALUES(`agreement_remark_mr`), `adhar_status` = VALUES(`adhar_status`), `adhar_remark` = VALUES(`adhar_remark`), `adhar_remark_mr` = VALUES(`adhar_remark_mr`), `overall_status` = VALUES(`overall_status`), `overall_remark` = VALUES(`overall_remark`), `overall_remark_mr` = VALUES(`overall_remark_mr`), `voter_name_marathi` = VALUES(`voter_name_marathi`), `status` = VALUES(`status`), `created_at` = VALUES(`created_at`), `updated_at` = VALUES(`updated_at`), `final_annexure` = VALUES(`final_annexure`), `in_progress_status` = VALUES(`in_progress_status`), `rejected_status` = VALUES(`rejected_status`), `rejected_by` = VALUES(`rejected_by`), `rejected_date` = VALUES(`rejected_date`), `resubmission_status` = VALUES(`resubmission_status`); END */$$ DELIMITER ; /* Trigger structure for table `tata_electricity_data` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `tata_electricity_data_update` AFTER UPDATE ON `tata_electricity_data` FOR EACH ROW BEGIN INSERT INTO `tata_electricity_data_history` (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name, first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, flag_migr, YEAR, created_at, updated_at, user_id, history_value) VALUES (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no, NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date, NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'update'); END */$$ DELIMITER ; /* Trigger structure for table `tata_electricity_data` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'master_user'@'%' */ /*!50003 TRIGGER `tata_electricity_data_insert` AFTER UPDATE ON `tata_electricity_data` FOR EACH ROW BEGIN INSERT INTO `tata_electricity_data_history` (hut_id, owner_name, address, category, service_provider, legacy_ca_no, ca_no, first_consumer_name, first_bill, change_name_date, change_date, move_in_date, move_out_date, legacy_customer, house_no, tariff, flag_migr, YEAR, created_at, updated_at, user_id, history_value) VALUES (NEW.hut_id, NEW.owner_name, NEW.address, NEW.category, NEW.service_provider, NEW.legacy_ca_no, NEW.ca_no, NEW.first_consumer_name, NEW.first_bill, NEW.change_name_date, NEW.change_date, NEW.move_in_date, NEW.move_out_date, NEW.legacy_customer, NEW.house_no, NEW.tariff, NEW.flag_migr, NEW.year, NEW.created_at, NEW.updated_at, NEW.user_id, 'insert'); END */$$ DELIMITER ; /* Trigger structure for table `users` */ DELIMITER $$ /*!50003 CREATE */ /*!50017 DEFINER = 'root'@'localhost' */ /*!50003 TRIGGER `users_history_update` AFTER UPDATE ON `users` FOR EACH ROW BEGIN INSERT INTO `users_history` ( `id`,`first_name`, `last_name`, `username`, `email`, `password`, `permissions`, `file_size`, `last_login`, `created_at`, `updated_at`, `cluster_id`, `sponsor_id`,`otp`,`parent_id`,`user_type`,`sort_order`,`otp_send`,`village_id` ) VALUES ( new.id, NEW.first_name, NEW.last_name, NEW.username, NEW.email, NEW.password, NEW.permissions, NEW.file_size, NEW.last_login, NEW.created_at, NEW.updated_at, NEW.cluster_id, NEW.sponsor_id, NEW.otp, NEW.parent_id, NEW.user_type, NEW.sort_order, NEW.otp_send, NEW.village_id ); END */$$ DELIMITER ; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 4. User question: how many sales you have done till date ? In gemini [2025-10-09 08:03:51] In gemini [2025-10-09 08:03:51] [SQL query Via gemini] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: [2025-10-09 08:03:51] You are an ERP assistant. Convert the following database result into a natural-language answer: Question: how many sales you have done till date ? Raw Data (JSON): No response from ERP In gemini [2025-10-09 08:03:52] In gemini [2025-10-09 08:03:52] [SQL] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: I'm sorry, but I was unable to retrieve that information. The ERP system did not provide a response. [2025-10-09 08:42:07] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: (Innn Processing...) [2025-10-09 08:42:07] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: (Processing...) [2025-10-09 08:42:07] In gemini [2025-10-09 08:42:08] response [{"intent": "query"}] In gemini [2025-10-09 08:42:08] In gemini [2025-10-09 08:42:11] response [SELECT COUNT(*) FROM `tabSales Invoice` AS si] In gemini [2025-10-09 08:42:11] [SQL query Via gemini] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: SELECT COUNT(*) FROM `tabSales Invoice` AS si [2025-10-09 08:42:11] In gemini [2025-10-09 08:42:12] response [I'm sorry, I couldn't retrieve that information. The ERP system did not provide a response.] In gemini [2025-10-09 08:42:12] [SQL] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: I'm sorry, I couldn't retrieve that information. The ERP system did not provide a response. [2025-10-09 08:45:42] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: (Innn Processing...) [2025-10-09 08:45:42] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: (Processing...) [2025-10-09 08:45:42] In gemini [2025-10-09 08:45:42] response [```json {"intent": "query"} ```] In gemini [2025-10-09 08:45:42] Scheme [2025-10-09 08:45:42] In gemini [2025-10-09 08:45:48] response [I'm sorry, I couldn't retrieve that information. The ERP system did not provide a response.] In gemini [2025-10-09 08:45:48] [SQL query Via gemini] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: I'm sorry, I couldn't retrieve that information. The ERP system did not provide a response. [2025-10-09 08:45:48] In gemini [2025-10-09 08:45:50] response [I am sorry, but I do not have the information about the number of sales done till date. The ERP system did not provide a response for this query.] In gemini [2025-10-09 08:45:50] [SQL] ChatID:chat_1759985775824 Q: how many sales you have done till date ? A: I am sorry, but I do not have the information about the number of sales done till date. The ERP system did not provide a response for this query.