/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.16-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: opd_prep -- ------------------------------------------------------ -- Server version 10.11.16-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_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 `mst_activity` -- DROP TABLE IF EXISTS `mst_activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_activity` ( `id` int(11) NOT NULL AUTO_INCREMENT, `form_id` int(11) DEFAULT NULL, `database_id` int(11) DEFAULT NULL, `activity_type` varchar(255) DEFAULT NULL, `activity_by` int(11) DEFAULT NULL, `activity_datetime` datetime DEFAULT NULL, `old_data` longtext DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_mst_activity_form` (`form_id`), KEY `idx_mst_activity_database` (`database_id`), KEY `idx_mst_activity_by` (`activity_by`), KEY `idx_mst_activity_datetime` (`activity_datetime`) ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_activity` -- LOCK TABLES `mst_activity` WRITE; /*!40000 ALTER TABLE `mst_activity` DISABLE KEYS */; INSERT INTO `mst_activity` VALUES (1,1003,1,'Add',3,'2026-03-21 15:57:07',NULL), (2,1003,1,'Edit',3,'2026-03-21 15:57:52',NULL), (3,1003,1,'Edit',3,'2026-03-21 15:58:00',NULL), (4,1003,1,'Delete',3,'2026-03-21 15:58:25',NULL), (5,1002,1,'Add',3,'2026-03-21 15:58:54',NULL), (6,1002,1,'Edit',3,'2026-03-21 16:00:20',NULL), (7,1002,1,'Delete',3,'2026-03-21 16:00:50',NULL), (8,1004,1,'Add',3,'2026-03-21 16:01:42',NULL), (9,1004,1,'Edit',3,'2026-03-21 16:02:12',NULL), (10,1004,2,'Add',3,'2026-03-21 16:02:33',NULL), (11,1004,1,'Delete',3,'2026-03-21 16:02:51',NULL), (12,1004,2,'Delete',3,'2026-03-21 16:02:53',NULL), (13,1004,1,'Add',3,'2026-03-21 16:03:06',NULL), (14,1004,1,'Edit',3,'2026-03-21 16:03:17',NULL), (15,1004,1,'Delete',3,'2026-03-21 16:03:26',NULL), (16,1003,2,'Add',1,'2026-03-23 10:48:13',NULL), (17,1003,2,'Edit',1,'2026-03-23 10:50:24',NULL), (18,1003,2,'Edit',1,'2026-03-23 10:50:53',NULL), (19,1003,2,'Edit',1,'2026-03-23 10:51:16',NULL), (20,1003,2,'Delete',1,'2026-03-23 10:51:24',NULL), (21,1002,2,'Add',1,'2026-03-23 10:54:06',NULL), (22,1002,2,'Edit',1,'2026-03-23 10:55:18',NULL), (23,1002,2,'Edit',1,'2026-03-23 10:55:56',NULL), (24,1002,2,'Edit',1,'2026-03-23 10:56:02',NULL), (25,1002,2,'Edit',1,'2026-03-23 10:56:36',NULL), (26,1002,2,'Delete',1,'2026-03-23 10:57:07',NULL), (27,1004,3,'Add',1,'2026-03-23 10:59:04',NULL), (28,1004,3,'Edit',1,'2026-03-23 10:59:36',NULL), (29,1004,3,'Edit',1,'2026-03-23 11:01:01',NULL), (30,1004,3,'Delete',1,'2026-03-23 11:01:10',NULL), (31,1004,2,'Add',1,'2026-03-23 11:01:34',NULL), (32,1004,2,'Edit',1,'2026-03-23 11:01:57',NULL), (33,1004,2,'Delete',1,'2026-03-23 11:02:19',NULL), (34,1003,3,'Add',1,'2026-03-23 12:08:12',NULL), (35,1003,3,'Delete',1,'2026-03-23 12:09:57',NULL), (36,1002,3,'Add',1,'2026-03-23 16:05:37',NULL), (37,1002,4,'Add',1,'2026-03-23 16:06:26',NULL), (38,1002,5,'Add',1,'2026-03-23 16:06:58',NULL); /*!40000 ALTER TABLE `mst_activity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_company` -- DROP TABLE IF EXISTS `mst_company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_company` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `short_name` varchar(50) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `phone_no` varchar(255) DEFAULT NULL, `company_address` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `pincode` int(11) DEFAULT NULL, `company_logo` varchar(255) DEFAULT NULL, `gst_no` varchar(255) DEFAULT NULL, `pan_no` varchar(255) DEFAULT NULL, `udhyam_no` varchar(255) DEFAULT NULL, `udhyam_type` varchar(255) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, `old_database_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_mst_company_old_id` (`old_database_id`), KEY `idx_mst_company_name` (`name`(100)) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_company` -- LOCK TABLES `mst_company` WRITE; /*!40000 ALTER TABLE `mst_company` DISABLE KEYS */; INSERT INTO `mst_company` VALUES (1,'PREP SOLUTION','PS','prep@gmail.com','9974528897','abc','ASD','24',380015,'main_1767950647.png','24BMCPB0844G1ZO','BMCPB0844G','123','micro',0,'2025-11-20 05:27:31',1,'2026-01-09 14:54:07',NULL), (2,'GAUTAM LABDHI','GL','gautam@gmail.com','9974528896','BLOCK - F, 1 TO 8, SUMEL BUSINESS PARK-1, B/H, NEW CLOTH MARKET, SARANGPUR, SHERKOTDA','AHMEDABAD','24',382415,'main_1767950575.png','27ABCDE1234F1Z8','ABCDE1231K','123','small',0,'2025-11-20 05:27:31',1,'2026-03-10 14:45:01',NULL); /*!40000 ALTER TABLE `mst_company` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_company_certificate` -- DROP TABLE IF EXISTS `mst_company_certificate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_company_certificate` ( `id` int(11) NOT NULL AUTO_INCREMENT, `certification_id` int(11) DEFAULT NULL, `certificate_name` varchar(255) DEFAULT NULL, `company_attachment` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_mst_company_cert_certification` (`certification_id`), KEY `idx_mst_company_cert_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_company_certificate` -- LOCK TABLES `mst_company_certificate` WRITE; /*!40000 ALTER TABLE `mst_company_certificate` DISABLE KEYS */; /*!40000 ALTER TABLE `mst_company_certificate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_complain_name` -- DROP TABLE IF EXISTS `mst_complain_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_complain_name` ( `id` int(11) NOT NULL AUTO_INCREMENT, `complain_name` varchar(255) DEFAULT NULL, `diagnosis` varchar(255) DEFAULT NULL, `complain` varchar(255) DEFAULT NULL, `advice` varchar(255) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_complain_name` -- LOCK TABLES `mst_complain_name` WRITE; /*!40000 ALTER TABLE `mst_complain_name` DISABLE KEYS */; /*!40000 ALTER TABLE `mst_complain_name` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_doctor` -- DROP TABLE IF EXISTS `mst_doctor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_doctor` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `clinic_name` varchar(255) DEFAULT NULL, `address1` varchar(255) DEFAULT NULL, `address2` varchar(255) DEFAULT NULL, `area` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `pincode` int(11) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `mobile_no` varchar(255) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_doctor` -- LOCK TABLES `mst_doctor` WRITE; /*!40000 ALTER TABLE `mst_doctor` DISABLE KEYS */; /*!40000 ALTER TABLE `mst_doctor` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_drug` -- DROP TABLE IF EXISTS `mst_drug`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_drug` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(255) DEFAULT NULL, `type` int(11) DEFAULT NULL, `generic_name` varchar(255) DEFAULT NULL, `side_effect` varchar(255) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_drug` -- LOCK TABLES `mst_drug` WRITE; /*!40000 ALTER TABLE `mst_drug` DISABLE KEYS */; INSERT INTO `mst_drug` VALUES (3,'1001',1,'S','SA',1,'2026-03-23 16:05:37',NULL,NULL), (4,'SD',2,'SD','SAD',1,'2026-03-23 16:06:26',NULL,NULL), (5,'FD',3,'DFDSF','FGDF',1,'2026-03-23 16:06:58',NULL,NULL); /*!40000 ALTER TABLE `mst_drug` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_drug_details` -- DROP TABLE IF EXISTS `mst_drug_details`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_drug_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `drug_id` int(11) DEFAULT NULL, `trade_name` varchar(255) DEFAULT NULL, `company` varchar(255) DEFAULT NULL, `price` double(30,10) DEFAULT NULL, `priority` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_drug_details` -- LOCK TABLES `mst_drug_details` WRITE; /*!40000 ALTER TABLE `mst_drug_details` DISABLE KEYS */; INSERT INTO `mst_drug_details` VALUES (11,4,'1DS','FD',43.0000000000,'Medium'), (12,4,'2DSF','FD',43.0000000000,'High'), (13,4,'3FDC','SD',2.0000000000,'Low'), (14,4,'SD','DF',20.0000000000,'High'); /*!40000 ALTER TABLE `mst_drug_details` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_family` -- DROP TABLE IF EXISTS `mst_family`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_family` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sr_no` int(11) DEFAULT NULL, `code` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `address1` varchar(255) DEFAULT NULL, `address2` varchar(255) DEFAULT NULL, `area` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `pincode` int(11) NOT NULL, `email_id` varchar(255) DEFAULT NULL, `mobile_no` varchar(255) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_family` -- LOCK TABLES `mst_family` WRITE; /*!40000 ALTER TABLE `mst_family` DISABLE KEYS */; /*!40000 ALTER TABLE `mst_family` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_family_deatils` -- DROP TABLE IF EXISTS `mst_family_deatils`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_family_deatils` ( `id` int(11) NOT NULL AUTO_INCREMENT, `family_head_id` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `mobile_no` varchar(255) DEFAULT NULL, `dob` date DEFAULT NULL, `age` int(11) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `blood_group` varchar(255) DEFAULT NULL, `history` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_family_deatils` -- LOCK TABLES `mst_family_deatils` WRITE; /*!40000 ALTER TABLE `mst_family_deatils` DISABLE KEYS */; /*!40000 ALTER TABLE `mst_family_deatils` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_form_master` -- DROP TABLE IF EXISTS `mst_form_master`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_form_master` ( `form_id` int(11) NOT NULL AUTO_INCREMENT, `form_code` int(11) DEFAULT NULL, `form_name` varchar(255) DEFAULT NULL, `form_url` text DEFAULT NULL, `category` varchar(255) DEFAULT NULL, PRIMARY KEY (`form_id`), KEY `idx_mst_form_master_code` (`form_code`), KEY `idx_mst_form_master_name` (`form_name`(100)) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_form_master` -- LOCK TABLES `mst_form_master` WRITE; /*!40000 ALTER TABLE `mst_form_master` DISABLE KEYS */; INSERT INTO `mst_form_master` VALUES (1,9001,'User Registration','configuration/user/list-user.php','Configuration'), (2,9002,'Company Master','configuration/company/list-company.php','Configuration'), (3,9003,'Year Master','configuration/year/list-year.php','Configuration'), (4,9004,'State','configuration/state/list-state.php','Configuration'), (5,9005,'Form','configuration/form/list-form.php','Configuration'), (6,1001,'Family Master','master/family/list-family.php','Master'), (7,1002,'Drug Master','master/drug/list-drug.php','Master'), (8,1003,'Doctor Master','master/doctor/list-doctor.php','Master'), (9,1004,'Complain Name','master/complain-name/list-complain-name.php','Master'); /*!40000 ALTER TABLE `mst_form_master` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_settings` -- DROP TABLE IF EXISTS `mst_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `number_decimal` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_settings` -- LOCK TABLES `mst_settings` WRITE; /*!40000 ALTER TABLE `mst_settings` DISABLE KEYS */; INSERT INTO `mst_settings` VALUES (1,2); /*!40000 ALTER TABLE `mst_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_state` -- DROP TABLE IF EXISTS `mst_state`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_state` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `code` varchar(11) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, `old_database_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_mst_state_old_id` (`old_database_id`), KEY `idx_mst_state_name` (`name`(100)), KEY `idx_mst_state_code` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_state` -- LOCK TABLES `mst_state` WRITE; /*!40000 ALTER TABLE `mst_state` DISABLE KEYS */; INSERT INTO `mst_state` VALUES (1,'JAMMU AND KASHMIR','1',0,'2026-02-20 08:58:16',NULL,NULL,1), (2,'HIMACHAL PRADESH','2',0,'2026-02-20 08:58:16',NULL,NULL,2), (3,'PUNJAB','3',0,'2026-02-20 08:58:16',NULL,NULL,3), (4,'CHANDIGARH','4',0,'2026-02-20 08:58:16',NULL,NULL,4), (5,'UTTARAKHAND','5',0,'2026-02-20 08:58:16',NULL,NULL,5), (6,'HARYANA','6',0,'2026-02-20 08:58:16',NULL,NULL,6), (7,'DELHI','7',0,'2026-02-20 08:58:16',NULL,NULL,7), (8,'RAJASTHAN','8',0,'2026-02-20 08:58:16',NULL,NULL,8), (9,'UTTAR PRADESH','9',0,'2026-02-20 08:58:16',NULL,NULL,9), (10,'BIHAR','10',0,'2026-02-20 08:58:16',NULL,NULL,10), (11,'SIKKIM','11',0,'2026-02-20 08:58:16',NULL,NULL,11), (12,'ARUNACHAL PRADESH','12',0,'2026-02-20 08:58:16',NULL,NULL,12), (13,'NAGALAND','13',0,'2026-02-20 08:58:16',NULL,NULL,13), (14,'MANIPUR','14',0,'2026-02-20 08:58:16',NULL,NULL,14), (15,'MIZORAM','15',0,'2026-02-20 08:58:16',NULL,NULL,15), (16,'TRIPURA','16',0,'2026-02-20 08:58:16',NULL,NULL,16), (17,'MEGHALAYA','17',0,'2026-02-20 08:58:16',NULL,NULL,17), (18,'ASSAM','18',0,'2026-02-20 08:58:16',NULL,NULL,18), (19,'WEST BENGAL','19',0,'2026-02-20 08:58:16',NULL,NULL,19), (20,'JHARKHAND','20',0,'2026-02-20 08:58:16',NULL,NULL,20), (21,'ODISHA','21',0,'2026-02-20 08:58:16',NULL,NULL,21), (22,'CHATTISGARH','22',0,'2026-02-20 08:58:16',NULL,NULL,22), (23,'MADHYA PRADESH','23',0,'2026-02-20 08:58:16',NULL,NULL,23), (24,'GUJARAT','24',0,'2026-02-20 08:58:16',NULL,NULL,24), (25,'DADRA AND NAGAR HAVELI AND DAMAN AND DIU (NEWLY MERGED UT)','26',0,'2026-02-20 08:58:16',NULL,NULL,25), (26,'MAHARASHTRA','27',0,'2026-02-20 08:58:16',NULL,NULL,26), (27,'ANDHRA PRADESH(BEFORE DIVISION)','28',0,'2026-02-20 08:58:16',NULL,NULL,27), (28,'KARNATAKA','29',0,'2026-02-20 08:58:16',NULL,NULL,28), (29,'GOA','30',0,'2026-02-20 08:58:16',NULL,NULL,29), (30,'LAKSHADWEEP','31',0,'2026-02-20 08:58:16',NULL,NULL,30), (31,'KERALA','32',0,'2026-02-20 08:58:16',NULL,NULL,31), (32,'TAMIL NADU','33',0,'2026-02-20 08:58:16',NULL,NULL,32), (33,'PUDUCHERRY','34',0,'2026-02-20 08:58:16',NULL,NULL,33), (34,'ANDAMAN AND NICOBAR ISLANDS','35',0,'2026-02-20 08:58:16',NULL,NULL,34), (35,'TELANGANA','36',0,'2026-02-20 08:58:16',NULL,NULL,35), (36,'ANDHRA PRADESH (NEWLY ADDED)','37',0,'2026-02-20 08:58:16',NULL,NULL,36), (37,'LADAKH (NEWLY ADDED)','38',0,'2026-02-20 08:58:16',NULL,NULL,37), (38,'OTHER TERRITORY','97',0,'2026-02-20 08:58:16',NULL,NULL,38), (39,'CENTRE JURISDICTION','99',0,'2026-02-20 08:58:16',NULL,NULL,39); /*!40000 ALTER TABLE `mst_state` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_user_form_role` -- DROP TABLE IF EXISTS `mst_user_form_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_user_form_role` ( `user_form_role_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `form_id` int(11) DEFAULT NULL, `form_code` varchar(100) DEFAULT NULL, `can_insert` int(11) DEFAULT NULL, `can_update` int(11) DEFAULT NULL, `can_delete` int(11) DEFAULT NULL, `can_view` int(11) DEFAULT NULL, `can_list` int(11) DEFAULT NULL, `form_master_catogory_id` int(11) DEFAULT NULL, `is_customized` int(11) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, PRIMARY KEY (`user_form_role_id`), KEY `idx_mst_user_form_role_user` (`user_id`), KEY `idx_mst_user_form_role_form` (`form_id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_user_form_role` -- LOCK TABLES `mst_user_form_role` WRITE; /*!40000 ALTER TABLE `mst_user_form_role` DISABLE KEYS */; INSERT INTO `mst_user_form_role` VALUES (1,1,1,'9001',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (2,1,2,'9002',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (3,1,3,'9003',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (4,1,4,'9004',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (5,1,5,'9005',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (6,1,6,'1001',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (7,1,7,'1002',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (8,1,8,'1003',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:37',1,'2026-03-21 16:11:37'), (9,1,9,'1004',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:11:38',1,'2026-03-21 16:11:38'), (10,3,1,'9001',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:17',1,'2026-03-21 16:12:17'), (11,3,2,'9002',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:17',1,'2026-03-21 16:12:17'), (12,3,3,'9003',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:17',1,'2026-03-21 16:12:17'), (13,3,4,'9004',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:17',1,'2026-03-21 16:12:17'), (14,3,5,'9005',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:17',1,'2026-03-21 16:12:17'), (15,3,6,'1001',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:17',1,'2026-03-21 16:12:17'), (16,3,7,'1002',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:18',1,'2026-03-21 16:12:18'), (17,3,8,'1003',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:18',1,'2026-03-21 16:12:18'), (18,3,9,'1004',1,1,1,1,1,NULL,NULL,1,'2026-03-21 16:12:18',1,'2026-03-21 16:12:18'); /*!40000 ALTER TABLE `mst_user_form_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_users` -- DROP TABLE IF EXISTS `mst_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(255) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `p_salt` varchar(255) DEFAULT NULL, `profile_img` varchar(255) DEFAULT NULL, `mobile_no` varchar(50) DEFAULT NULL, `is_super_admin` int(11) DEFAULT NULL, `contractor_id` text DEFAULT NULL COMMENT 'Assign Contractor', `mobile_otp` int(11) DEFAULT NULL, `is_dark_theme` varchar(255) DEFAULT NULL, `is_active` int(11) DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, `old_database_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_mst_users_old_id` (`old_database_id`), KEY `idx_mst_users_username` (`user_name`(100)), KEY `idx_mst_users_email` (`email_id`(100)), KEY `idx_mst_users_active` (`is_active`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_users` -- LOCK TABLES `mst_users` WRITE; /*!40000 ALTER TABLE `mst_users` DISABLE KEYS */; INSERT INTO `mst_users` VALUES (1,'root','root@123.com','ea93f870b326647870756ac09176c31928478cbd1a4abe7f415a5f2411603597','939b0fabda486414eb761acfc08918aa','','9974528896',1,NULL,298263,'light',1,1,'2025-07-10 09:41:36',1,'2025-12-30 16:02:26',NULL), (2,'PRANJAL','PRANJAL123@GMAIL.COM','bb93c3e7d92f2a3accdd6971259699f8ed85fa837a9557e0a557e7b49279cbcd','54f0c8c9512e4b5dfdde49726407569e',NULL,'7894561247',NULL,NULL,NULL,'light',1,1,'2026-03-05 10:03:50',1,'2026-03-17 11:10:12',NULL), (3,'PATEL','PATEL@GMAIL.COM','19ef44248cbf9c071fc1fd6125bf3f3e0bdcc442eee8d0f4bbc92458c7d06504','f41a772b3386bd97230f32e2df1fa9a2',NULL,'9974528897',NULL,NULL,290935,'light',1,1,'2026-03-19 09:42:22',NULL,NULL,NULL); /*!40000 ALTER TABLE `mst_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mst_year` -- DROP TABLE IF EXISTS `mst_year`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `mst_year` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year_name` varchar(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `inserted_by` int(11) DEFAULT NULL, `inserted_datetime` datetime DEFAULT NULL, `modify_by` int(11) DEFAULT NULL, `modify_datetime` datetime DEFAULT NULL, `old_database_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_mst_year_old_id` (`old_database_id`), KEY `idx_mst_year_name` (`year_name`(100)) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mst_year` -- LOCK TABLES `mst_year` WRITE; /*!40000 ALTER TABLE `mst_year` DISABLE KEYS */; INSERT INTO `mst_year` VALUES (1,'2025-2026','2025-04-01','2026-03-31',1,'2026-01-09 12:49:12',NULL,NULL,NULL), (2,'2026-2027','2026-04-01','2027-03-31',1,'2026-01-09 12:50:29',NULL,NULL,NULL); /*!40000 ALTER TABLE `mst_year` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'opd_prep' -- -- -- Dumping routines for database 'opd_prep' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-03-23 10:43:29