-- phpMyAdmin SQL Dump -- version 4.4.15.10 -- https://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 03, 2018 at 03:48 PM -- Server version: 5.7.19 -- PHP Version: 5.4.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `sbmpunjab` -- -- -------------------------------------------------------- -- -- Table structure for table `authentications` -- CREATE TABLE IF NOT EXISTS `authentications` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL COMMENT 'refer to users.id', `provider` varchar(100) NOT NULL, `provider_uid` varchar(255) NOT NULL, `email` varchar(200) NOT NULL, `display_name` varchar(150) NOT NULL, `first_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `profile_url` varchar(300) NOT NULL, `website_url` varchar(300) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL, `email` varchar(200) NOT NULL, `password` varchar(200) NOT NULL, `first_name` varchar(200) NOT NULL, `last_name` varchar(200) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `zsk_additional_validation` -- CREATE TABLE IF NOT EXISTS `zsk_additional_validation` ( `id` mediumint(255) NOT NULL, `date_submission` date DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `district_name` varchar(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `constituency_name` varchar(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `division_name` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `village_name` varchar(255) DEFAULT NULL, `mis_village_id` int(255) DEFAULT NULL, `gram_sabha_meeting_date` date DEFAULT NULL, `no_ihhl_cross_verification` mediumint(255) DEFAULT NULL, `house_hold_name` varchar(255) DEFAULT NULL, `house_hold_name_yes` mediumint(255) DEFAULT NULL, `nodal_officer_name` varchar(255) DEFAULT NULL, `nodal_officer_designation` varchar(255) DEFAULT NULL, `nodal_officer_phno` varchar(255) DEFAULT NULL, `cross_verification_name` varchar(255) DEFAULT NULL, `cross_verification_designation` varchar(255) DEFAULT NULL, `cross_verification_phno` varchar(255) DEFAULT NULL, `cross_verification_done` varchar(255) DEFAULT NULL, `cross_verification_date` date DEFAULT NULL, `letter_number` varchar(255) DEFAULT NULL, `cross_verification_report` varchar(255) DEFAULT NULL, `approval_letter_beneficiary` varchar(255) DEFAULT NULL, `bank_account_opened` varchar(255) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `branch_name` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `Batch` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_add_on` -- CREATE TABLE IF NOT EXISTS `zsk_add_on` ( `AddOnID` bigint(20) NOT NULL, `AddOnName` varchar(255) DEFAULT NULL, `AddOnFile` varchar(255) DEFAULT NULL, `Description1` text, `Description2` text, `Description3` text, `Description4` text, `Description5` text, `CreatedDate` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_app_odf_complaints` -- CREATE TABLE IF NOT EXISTS `zsk_app_odf_complaints` ( `id` int(11) NOT NULL, `block_id` int(11) DEFAULT NULL, `district_id` int(11) DEFAULT NULL, `village_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `address` text, `lat` varchar(60) DEFAULT NULL, `long` varchar(60) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_arbitration_case` -- CREATE TABLE IF NOT EXISTS `zsk_arbitration_case` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `date_of_receipt` date DEFAULT NULL, `arbitration_case` varchar(255) DEFAULT NULL, `particulars_case` varchar(255) DEFAULT NULL, `date_next_hearing` date DEFAULT NULL, `reply_filed` varchar(255) DEFAULT NULL, `reply_filed_date` date DEFAULT NULL, `present_status` varchar(255) DEFAULT NULL, `delay_occured` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_audit_latrine_complete` -- CREATE TABLE IF NOT EXISTS `zsk_audit_latrine_complete` ( `id` int(255) NOT NULL, `latrine_id` int(255) DEFAULT NULL, `firm_name` varchar(255) DEFAULT NULL, `auditor_name` varchar(255) DEFAULT NULL, `phone_number` int(255) DEFAULT NULL, `final_audit_status` varchar(255) DEFAULT NULL, `final_audit_complete` varchar(255) DEFAULT NULL, `auditor_statisfied` varchar(255) DEFAULT NULL, `final_audit_date` date DEFAULT NULL, `balance_amount` int(255) DEFAULT NULL, `audit_observation` text, `CreatedDate` datetime DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_audit_offline` -- CREATE TABLE IF NOT EXISTS `zsk_audit_offline` ( `id` int(11) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `district` varchar(255) NOT NULL, `block_id` int(255) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `village_name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_audit_uc` -- CREATE TABLE IF NOT EXISTS `zsk_audit_uc` ( `id` mediumint(255) NOT NULL, `request_id` varchar(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `ca_email_id` varchar(255) DEFAULT NULL, `audit_validated` int(255) DEFAULT NULL, `audit_additional_validated` int(25) DEFAULT NULL, `audit_amount_division` int(255) DEFAULT NULL, `audit_amount_gpwsc` int(255) DEFAULT NULL, `audit_interest_income` float DEFAULT NULL, `audit_other_income` float DEFAULT NULL, `total_amount_date` date DEFAULT NULL, `audit_incentive_date` date DEFAULT NULL, `audit_amount_incentive` float DEFAULT NULL, `audit_total_amount` float DEFAULT NULL, `audit_balance_GPWSC` float DEFAULT NULL, `audit_observations` text, `audit_certificate` varchar(255) DEFAULT NULL, `letter_number` varchar(255) DEFAULT NULL, `letter_dispatch_date` date DEFAULT NULL, `letter_vide` varchar(255) DEFAULT NULL, `audit_completed` varchar(10) DEFAULT NULL, `audit_pending` int(5) DEFAULT '0', `reason_audit_pedency` text, `date_pedency` date DEFAULT NULL, `xen_audit_pedency` text, `xen_audit_date` date DEFAULT NULL, `survey_village_undertaken` varchar(10) DEFAULT NULL, `survey_village_remarks` varchar(255) DEFAULT NULL, `list_beneficiaries` varchar(10) DEFAULT NULL, `list_beneficiaries_remarks` varchar(255) DEFAULT NULL, `bdpo_appointed` varchar(10) DEFAULT NULL, `bdpo_appointed_remarks` varchar(255) DEFAULT NULL, `gpwsc_opened_account` varchar(10) DEFAULT NULL, `gpwsc_opened_account_remarks` varchar(255) DEFAULT NULL, `bank_reconciliation` varchar(10) DEFAULT NULL, `bank_reconciliation_remarks` varchar(255) DEFAULT NULL, `applications_taken` varchar(10) DEFAULT NULL, `applications_taken_remarks` varchar(255) DEFAULT NULL, `grantee_agencies` varchar(10) DEFAULT NULL, `grantee_agencies_remarks` varchar(255) DEFAULT NULL, `unrelated_expenditure` varchar(10) DEFAULT NULL, `unrelated_expenditure_remarks` varchar(255) DEFAULT NULL, `doc_uploaded` varchar(10) DEFAULT NULL, `doc_uploaded_remarks` varchar(255) DEFAULT NULL, `sanction_forms_generated` varchar(10) DEFAULT NULL, `sanction_forms_remarks` varchar(255) DEFAULT NULL, `photo_base_unit` varchar(10) DEFAULT NULL, `photo_base_unit_remarks` varchar(255) DEFAULT NULL, `complete_base_unit` varchar(10) DEFAULT NULL, `complete_base_unit_remarks` varchar(255) DEFAULT NULL, `online_funds_first` varchar(10) DEFAULT NULL, `online_funds_first_remarks` varchar(255) DEFAULT NULL, `pic_complete_ihhl` varchar(10) DEFAULT NULL, `pic_complete_ihhl_remarks` varchar(255) DEFAULT NULL, `online_funds_second` varchar(10) DEFAULT NULL, `online_funds_second_remarks` varchar(255) DEFAULT NULL, `state_share_received` varchar(10) DEFAULT NULL, `state_share_received_remarks` varchar(255) DEFAULT NULL, `interest_money` varchar(10) DEFAULT NULL, `interest_money_remarks` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_backup` -- CREATE TABLE IF NOT EXISTS `zsk_backup` ( `BackUpID` bigint(20) NOT NULL, `ReferenceID` bigint(20) NOT NULL DEFAULT '0', `Page` varchar(200) NOT NULL DEFAULT '', `Dumps` longtext NOT NULL, `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_banners` -- CREATE TABLE IF NOT EXISTS `zsk_banners` ( `BannerID` bigint(20) NOT NULL, `BannerName` varchar(250) NOT NULL DEFAULT '', `BannerType` varchar(255) DEFAULT NULL, `Content` text, `Image` varchar(250) NOT NULL DEFAULT '', `Alignment` varchar(50) NOT NULL DEFAULT '', `Parameters` varchar(250) NOT NULL DEFAULT '', `FlashWidth` varchar(255) DEFAULT NULL, `FlashHeight` varchar(255) DEFAULT NULL, `URLType` varchar(50) NOT NULL DEFAULT '', `URL` varchar(255) DEFAULT NULL, `Clicks` bigint(20) NOT NULL DEFAULT '0', `Position` int(11) DEFAULT '0', `Active` int(11) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(255) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(2555) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(255) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_album` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_album` ( `id` bigint(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_id` int(255) DEFAULT NULL, `beneficiary_name` longtext NOT NULL, `phone_number` bigint(255) DEFAULT NULL, `best_toilet` int(5) DEFAULT NULL, `toilet_image1` varchar(2555) DEFAULT NULL, `toilet_image2` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `binary_image` longblob, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_amritsar` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_amritsar` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(255) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_barnala` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_barnala` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(255) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_bathinda` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_bathinda` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_category` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_category` ( `id` bigint(255) NOT NULL, `category` mediumtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_faridkot` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_faridkot` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_fatehgarh` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_fatehgarh` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_fazilka` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_fazilka` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_firozpur` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_firozpur` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_gurdaspur` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_gurdaspur` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_hoshiarpur` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_hoshiarpur` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_images` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_images` ( `ImageID` bigint(200) NOT NULL, `beneficiary_id` bigint(200) NOT NULL DEFAULT '0', `Image` varchar(5000) DEFAULT NULL, `stage_binary_image` varchar(5000) DEFAULT NULL, `Complete` tinyint(1) DEFAULT '0', `Stage` tinyint(1) NOT NULL, `Install_Date` date DEFAULT NULL, `Amount` mediumint(20) NOT NULL DEFAULT '0', `advance_payment` varchar(255) NOT NULL DEFAULT 'No', `flag` tinyint(4) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `Position` int(11) NOT NULL DEFAULT '0', `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `stage_latitude` double DEFAULT NULL, `stage_longitude` double DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_images_bathinda` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_images_bathinda` ( `ImageID` bigint(200) NOT NULL, `beneficiary_id` bigint(200) NOT NULL DEFAULT '0', `Image` varchar(5000) DEFAULT NULL, `stage_binary_image` varchar(5000) DEFAULT NULL, `Complete` tinyint(1) DEFAULT '0', `Stage` tinyint(1) NOT NULL, `Install_Date` date DEFAULT NULL, `Amount` mediumint(20) NOT NULL DEFAULT '0', `advance_payment` varchar(255) NOT NULL DEFAULT 'No', `flag` tinyint(4) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `Position` int(11) NOT NULL DEFAULT '0', `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `stage_latitude` double DEFAULT NULL, `stage_longitude` double DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_images_firozpur` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_images_firozpur` ( `ImageID` bigint(200) NOT NULL, `beneficiary_id` bigint(200) NOT NULL DEFAULT '0', `Image` varchar(5000) DEFAULT NULL, `stage_binary_image` varchar(5000) DEFAULT NULL, `Complete` tinyint(1) DEFAULT '0', `Stage` tinyint(1) NOT NULL, `Install_Date` date DEFAULT NULL, `Amount` mediumint(20) NOT NULL DEFAULT '0', `advance_payment` varchar(255) NOT NULL DEFAULT 'No', `flag` tinyint(4) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `Position` int(11) NOT NULL DEFAULT '0', `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `stage_latitude` double DEFAULT NULL, `stage_longitude` double DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_images_gurdaspur` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_images_gurdaspur` ( `ImageID` bigint(200) NOT NULL, `beneficiary_id` bigint(200) NOT NULL DEFAULT '0', `Image` varchar(5000) DEFAULT NULL, `stage_binary_image` varchar(5000) DEFAULT NULL, `Complete` tinyint(1) DEFAULT '0', `Stage` tinyint(1) NOT NULL, `Install_Date` date DEFAULT NULL, `Amount` mediumint(20) NOT NULL DEFAULT '0', `advance_payment` varchar(255) NOT NULL DEFAULT 'No', `flag` tinyint(4) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `Position` int(11) NOT NULL DEFAULT '0', `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `stage_latitude` double DEFAULT NULL, `stage_longitude` double DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_images_hoshiarpur` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_images_hoshiarpur` ( `ImageID` bigint(200) NOT NULL, `beneficiary_id` bigint(200) NOT NULL DEFAULT '0', `Image` varchar(5000) DEFAULT NULL, `stage_binary_image` varchar(5000) DEFAULT NULL, `Complete` tinyint(1) DEFAULT '0', `Stage` tinyint(1) NOT NULL, `Install_Date` date DEFAULT NULL, `Amount` mediumint(20) NOT NULL DEFAULT '0', `advance_payment` varchar(255) NOT NULL DEFAULT 'No', `flag` tinyint(4) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `Position` int(11) NOT NULL DEFAULT '0', `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `stage_latitude` double DEFAULT NULL, `stage_longitude` double DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_images_pathankot` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_images_pathankot` ( `ImageID` bigint(200) NOT NULL, `beneficiary_id` bigint(200) NOT NULL DEFAULT '0', `Image` varchar(5000) DEFAULT NULL, `stage_binary_image` varchar(5000) DEFAULT NULL, `Complete` tinyint(1) DEFAULT '0', `Stage` tinyint(1) NOT NULL, `Install_Date` date DEFAULT NULL, `Amount` mediumint(20) NOT NULL DEFAULT '0', `advance_payment` varchar(255) NOT NULL DEFAULT 'No', `flag` tinyint(4) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `Position` int(11) NOT NULL DEFAULT '0', `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `stage_latitude` double DEFAULT NULL, `stage_longitude` double DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_jalandhar` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_jalandhar` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_kapurthala` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_kapurthala` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_latrine_detail` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_latrine_detail` ( `id` int(255) NOT NULL, `beneficiary_id` int(255) DEFAULT NULL, `ImageID` int(255) DEFAULT NULL, `Amount` int(255) DEFAULT NULL, `village_id` bigint(255) DEFAULT NULL, `cast` varchar(255) DEFAULT NULL, `latrine_type` varchar(255) DEFAULT NULL, `base_type` varchar(255) DEFAULT NULL, `junction_chamber` varchar(255) DEFAULT NULL, `soakage_pit` varchar(255) DEFAULT NULL, `anaerobic_filter` varchar(25) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_ludhiana` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_ludhiana` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_mansa` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_mansa` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_moga` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_moga` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_mohali` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_mohali` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_muktsar` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_muktsar` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_pathankot` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_pathankot` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_patiala` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_patiala` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(255) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(2555) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(255) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_picture_stages` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_picture_stages` ( `id` bigint(255) NOT NULL, `beneficiary_id` bigint(255) NOT NULL, `picture_stage1` varchar(2555) NOT NULL, `stage_completion` tinyint(1) NOT NULL DEFAULT '0', `picture_stage2` varchar(2555) NOT NULL, `toilet_construction` tinyint(1) NOT NULL DEFAULT '0', `picture_stage3` varchar(2555) NOT NULL, `first_installament_date` date DEFAULT NULL, `second_installament_date` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_ropar` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_ropar` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_sangrur` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_sangrur` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_sbsnagar` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_sbsnagar` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_taran` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_taran` ( `id` bigint(255) NOT NULL, `beneficiary_name` longtext NOT NULL, `father_spouse_name` longtext NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` bigint(255) NOT NULL, `constituency_id` bigint(255) NOT NULL, `block_id` bigint(255) NOT NULL, `divisions_id` bigint(255) NOT NULL, `village_id` bigint(255) NOT NULL, `beneficiary_category_id` int(11) NOT NULL, `cast` varchar(25) DEFAULT NULL, `religion` varchar(25) DEFAULT NULL, `id_proof_type` int(11) NOT NULL, `id_proof_number` varchar(255) NOT NULL, `adhar_card_number` varchar(255) DEFAULT NULL, `elec_bill_image` varchar(5000) DEFAULT NULL, `elec_conn_account_no` varchar(2555) DEFAULT NULL, `phone_number` bigint(255) DEFAULT NULL, `bank_pass_book_image` varchar(5000) DEFAULT NULL, `bank_name` mediumtext NOT NULL, `branch_name` mediumtext NOT NULL, `bank_account_number` varchar(255) NOT NULL, `ifsc_code` varchar(255) NOT NULL, `beneficiary_image` varchar(5000) DEFAULT NULL, `bene_latitude` double DEFAULT NULL, `bene_longittude` double DEFAULT NULL, `apporder_no` int(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `Position` mediumint(200) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_beneficiary_tele_calling` -- CREATE TABLE IF NOT EXISTS `zsk_beneficiary_tele_calling` ( `id` mediumint(255) NOT NULL, `tele_caller_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `beneficiary_name` varchar(255) DEFAULT NULL, `phone_number` varchar(255) DEFAULT NULL, `tele_call_date` datetime DEFAULT NULL, `call_matured` smallint(1) DEFAULT NULL, `beneficiary_sensitized` smallint(1) DEFAULT NULL, `latrine_started` smallint(1) DEFAULT NULL, `first_install` smallint(1) DEFAULT NULL, `second_install` smallint(1) DEFAULT NULL, `latrine_completed` smallint(1) DEFAULT NULL, `latrine_using` smallint(1) DEFAULT NULL, `latrine_constructed` varchar(255) DEFAULT NULL, `feedback` text, `calling_round` tinyint(1) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_blocks` -- CREATE TABLE IF NOT EXISTS `zsk_blocks` ( `id` int(11) NOT NULL, `district_id` int(11) NOT NULL, `district_name` varchar(255) NOT NULL, `block_name` varchar(255) NOT NULL, `beneficiary_table` varchar(100) DEFAULT NULL, `active` tinyint(4) DEFAULT NULL, `no_gp_goi` int(255) DEFAULT NULL, `latrine_to_constructed_goi` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_block_division_relation` -- CREATE TABLE IF NOT EXISTS `zsk_block_division_relation` ( `id` int(255) NOT NULL, `circle_id` int(255) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `district_name` varchar(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `division_name` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_ca` -- CREATE TABLE IF NOT EXISTS `zsk_ca` ( `id` int(11) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` int(25) DEFAULT NULL, `district` varchar(255) NOT NULL, `ca_name` varchar(255) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `mobile_no` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_ce_latrine_complete` -- CREATE TABLE IF NOT EXISTS `zsk_ce_latrine_complete` ( `id` int(255) NOT NULL, `latrine_id` int(255) DEFAULT NULL, `ce_name` varchar(255) DEFAULT NULL, `ce_letter_number` varchar(255) DEFAULT NULL, `ce_letter_date` date DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cholorination` -- CREATE TABLE IF NOT EXISTS `zsk_cholorination` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `venue` varchar(255) DEFAULT NULL, `no_of_participant` varchar(255) DEFAULT NULL, `female_no_participant` int(255) DEFAULT NULL, `male_no_participant` int(255) DEFAULT NULL, `date` date DEFAULT NULL, `designation` varchar(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_circle` -- CREATE TABLE IF NOT EXISTS `zsk_circle` ( `id` int(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle` varchar(2555) NOT NULL, `SE` varchar(25) DEFAULT NULL, `contact_no` varchar(25) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_circle_latrine_complete` -- CREATE TABLE IF NOT EXISTS `zsk_circle_latrine_complete` ( `id` int(255) NOT NULL, `latrine_id` int(255) DEFAULT NULL, `se_name` varchar(255) DEFAULT NULL, `circle_letter_number` varchar(255) DEFAULT NULL, `circle_letter_date` date DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_circle_sample_duty` -- CREATE TABLE IF NOT EXISTS `zsk_circle_sample_duty` ( `id` int(255) NOT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `letter_date` date DEFAULT NULL, `no_beneficiary_cross_verification` varchar(255) DEFAULT NULL, `no_beneficiary_baseline_survey` varchar(255) DEFAULT NULL, `compliance_report_received` varchar(255) DEFAULT NULL, `report_received_date` date DEFAULT NULL, `reminder_issue_date` date DEFAULT NULL, `CreatedDate` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_constituency_list` -- CREATE TABLE IF NOT EXISTS `zsk_constituency_list` ( `id` bigint(255) NOT NULL, `district_id` bigint(255) NOT NULL, `district_name` longtext NOT NULL, `constituency_name` longtext NOT NULL, `active` int(255) DEFAULT NULL, `no_gp_goi` int(255) DEFAULT NULL, `latrine_to_constructed_goi` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_contempt_petition_a_category` -- CREATE TABLE IF NOT EXISTS `zsk_contempt_petition_a_category` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `date_of_receipt` date DEFAULT NULL, `cwp_title` varchar(255) DEFAULT NULL, `particulars_case` varchar(255) DEFAULT NULL, `date_next_hearing` date DEFAULT NULL, `date_upto_action_taken` date DEFAULT NULL, `date_on_action_taken` date DEFAULT NULL, `reply_filed` varchar(255) DEFAULT NULL, `action_taken_stipluated_period` varchar(255) DEFAULT NULL, `present_status` varchar(255) DEFAULT NULL, `delay_occured` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_controllers` -- CREATE TABLE IF NOT EXISTS `zsk_controllers` ( `ControllerID` int(11) NOT NULL, `UserName` varchar(200) NOT NULL DEFAULT '', `Password` varchar(200) NOT NULL DEFAULT '', `district_id` varchar(200) DEFAULT NULL, `Name` varchar(200) NOT NULL DEFAULT '', `Address1` varchar(200) NOT NULL DEFAULT '', `City` varchar(100) NOT NULL DEFAULT '', `State` varchar(100) NOT NULL DEFAULT '', `Country` varchar(100) NOT NULL DEFAULT '0', `ZipCode` varchar(50) NOT NULL DEFAULT '', `EmailAddress` varchar(100) NOT NULL DEFAULT '', `Phone` varchar(50) NOT NULL DEFAULT '', `Active` int(11) NOT NULL DEFAULT '0', `AllowPages` text NOT NULL, `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `PrevLastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_counter` -- CREATE TABLE IF NOT EXISTS `zsk_counter` ( `CounterID` int(11) NOT NULL, `Visits` bigint(20) DEFAULT NULL, `CounterDate` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `zsk_countries` -- CREATE TABLE IF NOT EXISTS `zsk_countries` ( `CountryID` int(11) NOT NULL, `ShippingID` tinyint(4) NOT NULL DEFAULT '0', `CountryName` varchar(100) NOT NULL DEFAULT '', `CountryISOCode1` char(2) NOT NULL DEFAULT '', `CountryISOCode2` char(3) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_credit_card` -- CREATE TABLE IF NOT EXISTS `zsk_credit_card` ( `CreditCardID` bigint(20) NOT NULL, `OrderID` bigint(250) NOT NULL DEFAULT '0', `CardName` varchar(200) DEFAULT NULL, `CardNo` varchar(24) DEFAULT NULL, `CardType` varchar(100) DEFAULT NULL, `ExpiryMonth` varchar(20) DEFAULT NULL, `ExpiryYear` varchar(5) DEFAULT NULL, `StartMonth` varchar(20) DEFAULT NULL, `StartYear` varchar(5) DEFAULT NULL, `CVV` varchar(5) DEFAULT NULL, `CardDisplay` tinyint(1) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_bathinda` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_bathinda` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_firozpur` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_firozpur` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_gurdaspur` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_gurdaspur` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_hoshiarpur` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_hoshiarpur` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_jalandhar` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_jalandhar` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_kapurthala` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_kapurthala` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_pathankot` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_pathankot` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_patiala` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_patiala` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_report` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_report` ( `id` int(255) NOT NULL, `district` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_ropar` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_ropar` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_beneficiary_payorder_sangrur` -- CREATE TABLE IF NOT EXISTS `zsk_cron_beneficiary_payorder_sangrur` ( `id` int(255) NOT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `pics_stage1` int(255) DEFAULT NULL, `payorder_stage1` int(255) DEFAULT NULL, `pics_stage2` int(255) DEFAULT NULL, `payorder_stage2` int(255) DEFAULT NULL, `pics_stage3` int(255) DEFAULT NULL, `payorder_stage3` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_daily_sanitation_block` -- CREATE TABLE IF NOT EXISTS `zsk_cron_daily_sanitation_block` ( `id` int(255) NOT NULL, `block_id` int(255) DEFAULT NULL, `village_validated` int(255) DEFAULT NULL, `triggering` int(255) DEFAULT NULL, `nigrani` int(255) DEFAULT NULL, `beneficiary_online` int(255) DEFAULT NULL, `stage1_image` int(255) DEFAULT NULL, `stage2_image` int(255) DEFAULT NULL, `stage3_image` int(255) DEFAULT NULL, `odf_village_sbm` int(255) DEFAULT NULL, `audit_request` int(255) DEFAULT NULL, `goi_pics_uploaded` int(255) DEFAULT NULL, `goi_latrine_completed` int(255) DEFAULT NULL, `goi_village_made_odf` int(255) DEFAULT NULL, `daily_index` double DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_daily_sanitation_circle` -- CREATE TABLE IF NOT EXISTS `zsk_cron_daily_sanitation_circle` ( `id` int(255) NOT NULL, `circle_id` int(255) DEFAULT NULL, `village_validated_circle` int(255) DEFAULT NULL, `triggering_circle` int(255) DEFAULT NULL, `nigrani_circle` int(255) DEFAULT NULL, `beneficiary_online_circle` int(255) DEFAULT NULL, `stage1_image_circle` int(255) DEFAULT NULL, `stage2_image_circle` int(255) DEFAULT NULL, `stage3_image_circle` int(255) DEFAULT NULL, `odf_village_sbm_circle` int(255) DEFAULT NULL, `audit_request_circle` int(255) DEFAULT NULL, `goi_pics_uploaded_circle` int(255) DEFAULT NULL, `goi_latrine_completed_circle` int(255) DEFAULT NULL, `goi_village_made_odf_circle` int(255) DEFAULT NULL, `daily_index_circle` float DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_daily_sanitation_district` -- CREATE TABLE IF NOT EXISTS `zsk_cron_daily_sanitation_district` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `total_villages_district` int(255) DEFAULT NULL, `village_validated_district` int(255) DEFAULT NULL, `triggering_required_district` int(255) DEFAULT NULL, `triggering_district` int(255) DEFAULT NULL, `nigrani_district` int(255) DEFAULT NULL, `latrine_validated_district` int(255) DEFAULT NULL, `beneficiary_online_district` int(255) DEFAULT NULL, `stage1_image_district` int(255) DEFAULT NULL, `stage2_image_district` int(255) DEFAULT NULL, `stage3_image_district` int(255) DEFAULT NULL, `odf_village_sbm_district` int(255) DEFAULT NULL, `odf_village_zero_district` int(255) DEFAULT NULL, `audit_request_district` int(255) DEFAULT NULL, `goi_pics_uploaded_district` int(255) DEFAULT NULL, `goi_latrine_completed_district` int(255) DEFAULT NULL, `goi_village_made_odf_district` int(255) DEFAULT NULL, `daily_index_district` float DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_daily_sanitation_division` -- CREATE TABLE IF NOT EXISTS `zsk_cron_daily_sanitation_division` ( `id` int(255) NOT NULL, `division_id` int(255) DEFAULT NULL, `division_officer` varchar(255) DEFAULT NULL, `total_villages_division` int(255) DEFAULT NULL, `village_validated_division` int(255) DEFAULT NULL, `triggering_required_division` int(255) DEFAULT NULL, `triggering_division` int(255) DEFAULT NULL, `nigrani_division` int(255) DEFAULT NULL, `latrine_validated_division` int(255) DEFAULT NULL, `beneficiary_online_division` int(255) DEFAULT NULL, `stage1_image_division` int(255) DEFAULT NULL, `stage2_image_division` int(255) DEFAULT NULL, `stage3_image_division` int(255) DEFAULT NULL, `odf_village_sbm_division` int(255) DEFAULT NULL, `odf_village_zero_division` int(255) DEFAULT NULL, `audit_request_division` int(255) DEFAULT NULL, `goi_pics_uploaded_division` int(255) DEFAULT NULL, `goi_latrine_completed_division` int(255) DEFAULT NULL, `goi_village_made_odf_division` int(255) DEFAULT NULL, `daily_index_division` float DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_latrine_image_report` -- CREATE TABLE IF NOT EXISTS `zsk_cron_latrine_image_report` ( `id` int(255) NOT NULL, `district` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `latrine_validated` int(255) DEFAULT NULL, `beneficiary_online` int(255) DEFAULT NULL, `stage1_image` int(255) DEFAULT NULL, `stage2_image` int(255) DEFAULT NULL, `latrine_completed` int(255) DEFAULT NULL, `stage3_payorder` int(255) DEFAULT NULL, `CreatedDate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_mobile_iec` -- CREATE TABLE IF NOT EXISTS `zsk_cron_mobile_iec` ( `id` int(255) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `circle_iec_designation` varchar(255) DEFAULT NULL, `circle_iec_name` varchar(255) DEFAULT NULL, `officer_designation` varchar(255) DEFAULT NULL, `officer_name` varchar(255) DEFAULT NULL, `officer_contact` varchar(255) DEFAULT NULL, `user_visits` int(255) DEFAULT NULL, `CreatedDate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_mobile_sanitation` -- CREATE TABLE IF NOT EXISTS `zsk_cron_mobile_sanitation` ( `id` int(255) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `sanitation_designation` varchar(255) DEFAULT NULL, `sanitation_name` varchar(255) DEFAULT NULL, `officer_designation` varchar(255) DEFAULT NULL, `officer_name` varchar(255) DEFAULT NULL, `officer_contact` varchar(255) DEFAULT NULL, `user_visits` int(255) DEFAULT NULL, `CreatedDate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_mobile_water` -- CREATE TABLE IF NOT EXISTS `zsk_cron_mobile_water` ( `id` int(255) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `water_designation` varchar(255) DEFAULT NULL, `water_name` varchar(255) DEFAULT NULL, `officer_designation` varchar(255) DEFAULT NULL, `officer_name` varchar(255) DEFAULT NULL, `officer_contact` varchar(255) DEFAULT NULL, `user_visits` int(255) DEFAULT NULL, `CreatedDate` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_nigrani_report` -- CREATE TABLE IF NOT EXISTS `zsk_cron_nigrani_report` ( `id` int(255) NOT NULL, `district` varchar(255) DEFAULT NULL, `district_id` int(25) DEFAULT NULL, `gp_validated` int(255) DEFAULT NULL, `camp_reqd` int(25) DEFAULT NULL, `camp_conducted` int(25) DEFAULT NULL, `camp_previous` int(25) DEFAULT NULL, `total_camp` int(25) DEFAULT NULL, `motivator_register` int(25) DEFAULT NULL, `master_register` int(25) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_sanitation_block` -- CREATE TABLE IF NOT EXISTS `zsk_cron_sanitation_block` ( `id` int(255) NOT NULL, `block_id` int(255) DEFAULT NULL, `total_villages` int(255) DEFAULT NULL, `village_validated` int(255) DEFAULT NULL, `triggering_required` int(255) DEFAULT NULL, `triggering` int(255) DEFAULT NULL, `nigrani` int(255) DEFAULT NULL, `latrine_validated` int(255) DEFAULT NULL, `beneficiary_online` int(255) DEFAULT NULL, `stage1_image` int(255) DEFAULT NULL, `stage2_image` int(255) DEFAULT NULL, `stage3_image` int(255) DEFAULT NULL, `odf_village_sbm` int(255) DEFAULT NULL, `odf_village_zero` int(255) DEFAULT NULL, `audit_request` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_sanitation_circle` -- CREATE TABLE IF NOT EXISTS `zsk_cron_sanitation_circle` ( `id` int(255) NOT NULL, `circle_id` int(255) DEFAULT NULL, `total_villages_circle` int(255) DEFAULT NULL, `village_validated_circle` int(255) DEFAULT NULL, `triggering_required_circle` int(255) DEFAULT NULL, `triggering_circle` int(255) DEFAULT NULL, `nigrani_circle` int(255) DEFAULT NULL, `latrine_validated_circle` int(255) DEFAULT NULL, `beneficiary_online_circle` int(255) DEFAULT NULL, `stage1_image_circle` int(255) DEFAULT NULL, `stage2_image_circle` int(255) DEFAULT NULL, `stage3_image_circle` int(255) DEFAULT NULL, `odf_village_sbm_circle` int(255) DEFAULT NULL, `odf_village_zero_circle` int(255) DEFAULT NULL, `audit_request_circle` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_sanitation_district` -- CREATE TABLE IF NOT EXISTS `zsk_cron_sanitation_district` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `total_villages_district` int(255) DEFAULT NULL, `village_validated_district` int(255) DEFAULT NULL, `triggering_required_district` int(255) DEFAULT NULL, `triggering_district` int(255) DEFAULT NULL, `nigrani_district` int(255) DEFAULT NULL, `latrine_validated_district` int(255) DEFAULT NULL, `beneficiary_online_district` int(255) DEFAULT NULL, `stage1_image_district` int(255) DEFAULT NULL, `stage2_image_district` int(255) DEFAULT NULL, `stage3_image_district` int(255) DEFAULT NULL, `odf_village_sbm_district` int(255) DEFAULT NULL, `odf_village_zero_district` int(255) DEFAULT NULL, `audit_request_district` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_sanitation_division` -- CREATE TABLE IF NOT EXISTS `zsk_cron_sanitation_division` ( `id` int(255) NOT NULL, `division_id` int(255) DEFAULT NULL, `division_officer` varchar(255) DEFAULT NULL, `total_villages_division` int(255) DEFAULT NULL, `village_validated_division` int(255) DEFAULT NULL, `triggering_required_division` int(255) DEFAULT NULL, `triggering_division` int(255) DEFAULT NULL, `nigrani_division` int(255) DEFAULT NULL, `latrine_validated_division` int(255) DEFAULT NULL, `beneficiary_online_division` int(255) DEFAULT NULL, `stage1_image_division` int(255) DEFAULT NULL, `stage2_image_division` int(255) DEFAULT NULL, `stage3_image_division` int(255) DEFAULT NULL, `odf_village_sbm_division` int(255) DEFAULT NULL, `odf_village_zero_division` int(255) DEFAULT NULL, `audit_request_division` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_village_beneficiary_count` -- CREATE TABLE IF NOT EXISTS `zsk_cron_village_beneficiary_count` ( `id` int(255) NOT NULL, `district_id` int(25) DEFAULT NULL, `district` varchar(25) DEFAULT NULL, `block_id` int(25) DEFAULT NULL, `block` varchar(25) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `village_name` varchar(25) DEFAULT NULL, `beneficiary_count` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cron_weekly_nigrani` -- CREATE TABLE IF NOT EXISTS `zsk_cron_weekly_nigrani` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `gp_validated` int(255) DEFAULT NULL, `camp_reqd` int(255) DEFAULT NULL, `camp_conducted` int(255) DEFAULT NULL, `date_to` date DEFAULT NULL, `date_from` date DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_cross_verification_list` -- CREATE TABLE IF NOT EXISTS `zsk_cross_verification_list` ( `id` mediumint(255) NOT NULL, `date_submission` date DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `gram_sabha_meeting_date` date DEFAULT NULL, `no_ihhl_base_line` mediumint(255) DEFAULT NULL, `no_ihhl_cross_verification` mediumint(255) DEFAULT NULL, `house_hold_name` varchar(255) DEFAULT NULL, `house_hold_name_yes` mediumint(255) DEFAULT NULL, `nodal_officer_name` varchar(255) DEFAULT NULL, `nodal_officer_designation` varchar(255) DEFAULT NULL, `nodal_officer_phno` varchar(255) DEFAULT NULL, `nodal_officer_verification` varchar(255) DEFAULT NULL, `nodal_officer_date` date DEFAULT NULL, `nodal_officer_report` varchar(255) DEFAULT NULL, `cross_verification_name` varchar(255) DEFAULT NULL, `cross_verification_designation` varchar(255) DEFAULT NULL, `cross_verification_done` varchar(255) DEFAULT NULL, `cross_verification_date` date DEFAULT NULL, `cross_verification_report` varchar(255) DEFAULT NULL, `cross_verification_phno` varchar(255) DEFAULT NULL, `motivator_application_checked` varchar(255) DEFAULT NULL, `motivator_application_filled` varchar(255) DEFAULT NULL, `beneficiary_list` varchar(255) DEFAULT NULL, `gramsabha_list` varchar(255) DEFAULT NULL, `nodal_checked` varchar(255) DEFAULT NULL, `nodal_checked_random` varchar(255) DEFAULT NULL, `cross_checked` varchar(255) DEFAULT NULL, `letter_number` varchar(255) DEFAULT NULL, `bank_account_opened` int(10) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `branch_name` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` mediumint(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_currencies` -- CREATE TABLE IF NOT EXISTS `zsk_currencies` ( `CurrencyID` int(11) NOT NULL, `CurrencyName` varchar(100) NOT NULL DEFAULT '', `Code` varchar(5) NOT NULL DEFAULT '', `Symbol` varchar(10) NOT NULL DEFAULT '', `Image` varchar(100) NOT NULL DEFAULT '', `Value` float NOT NULL DEFAULT '0', `Prefix` tinyint(4) NOT NULL DEFAULT '0', `Active` tinyint(4) NOT NULL DEFAULT '0', `DefaultValue` tinyint(4) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_daily_latrine` -- CREATE TABLE IF NOT EXISTS `zsk_daily_latrine` ( `id` int(11) NOT NULL, `date` date DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_daily_latrine_details` -- CREATE TABLE IF NOT EXISTS `zsk_daily_latrine_details` ( `id` int(255) NOT NULL, `lat_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `pics_uploaded` int(255) DEFAULT NULL, `latrine_completed` int(255) DEFAULT NULL, `village_made_odf` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_daily_water_supply_recovery` -- CREATE TABLE IF NOT EXISTS `zsk_daily_water_supply_recovery` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `water_charges` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_ddo_code` -- CREATE TABLE IF NOT EXISTS `zsk_ddo_code` ( `id` int(255) NOT NULL, `dso` varchar(255) DEFAULT NULL, `ddo_code` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_district` -- CREATE TABLE IF NOT EXISTS `zsk_district` ( `id` int(11) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district` varchar(255) NOT NULL, `beneficiary_table` varchar(125) DEFAULT NULL, `beneficiary_table_const` varchar(155) DEFAULT NULL, `beneficiary_images_table` varchar(255) DEFAULT NULL, `active` tinyint(2) DEFAULT NULL, `district_allocated` varchar(25) DEFAULT NULL, `Priority` varchar(255) DEFAULT NULL, `Sub_priority` varchar(255) DEFAULT NULL, `Target_Date` date DEFAULT NULL, `Achievement_Date` date DEFAULT NULL, `latrine_base_line` int(255) DEFAULT NULL, `latrine_constructed_15_16` int(255) DEFAULT NULL, `latrine_constructed_16_17` int(255) DEFAULT NULL, `gp_count` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_divisions_list` -- CREATE TABLE IF NOT EXISTS `zsk_divisions_list` ( `id` bigint(255) NOT NULL, `district_id` bigint(255) NOT NULL, `district_name` longtext NOT NULL, `division_name` varchar(2555) NOT NULL, `beneficiary_table` varchar(255) DEFAULT NULL, `base_line_survey_goi` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_docsan` -- CREATE TABLE IF NOT EXISTS `zsk_docsan` ( `person_name` varchar(255) DEFAULT NULL, `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `position` varchar(255) DEFAULT NULL, `contact_no` varchar(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_docsan_images` -- CREATE TABLE IF NOT EXISTS `zsk_docsan_images` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `event_name` varchar(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `prog_pic5` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_emails` -- CREATE TABLE IF NOT EXISTS `zsk_emails` ( `id` int(11) NOT NULL, `sr_no` int(2) DEFAULT NULL, `district` varchar(100) DEFAULT NULL, `division_email_id` varchar(255) DEFAULT NULL, `SBM_email_id` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `zsk_envweek` -- CREATE TABLE IF NOT EXISTS `zsk_envweek` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `coordinator_name` varchar(25) DEFAULT NULL, `designation` varchar(25) DEFAULT NULL, `activity_name` varchar(255) DEFAULT NULL, `activity` text, `attendance` int(255) DEFAULT NULL, `date` date DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_env_circle_specialist` -- CREATE TABLE IF NOT EXISTS `zsk_env_circle_specialist` ( `id` int(255) DEFAULT NULL, `zone_id` int(25) DEFAULT NULL, `zone` varchar(255) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `specialist_name` varchar(25) DEFAULT NULL, `category` varchar(25) DEFAULT NULL, `contact_no` varchar(25) DEFAULT NULL, `joining_date` date DEFAULT NULL, `transfer_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_final_audit_gpwsc` -- CREATE TABLE IF NOT EXISTS `zsk_final_audit_gpwsc` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `gpwsc_name` varchar(255) DEFAULT NULL, `executive_name` varchar(255) DEFAULT NULL, `sub_engineer_name` varchar(255) DEFAULT NULL, `ae_je_name` varchar(255) DEFAULT NULL, `sarpanch_name` varchar(255) DEFAULT NULL, `sarpanch_phoneno` int(255) DEFAULT NULL, `gpwsc_account_no` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `no_of_latrine` mediumint(255) DEFAULT NULL, `validated_beneficiaries` int(255) DEFAULT NULL, `amount_allocation_division` int(255) DEFAULT NULL, `amount_gpwsc` int(255) DEFAULT NULL, `interest_income` int(255) DEFAULT NULL, `other_income` int(255) DEFAULT NULL, `total_amount_date` date DEFAULT NULL, `incentive_date` date DEFAULT NULL, `amount_gpwsc_incentive` int(255) DEFAULT NULL, `ee_letter_no` varchar(255) DEFAULT NULL, `ee_letter_date` date DEFAULT NULL, `scanned_copy` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_final_audit_gpwsc_2c` -- CREATE TABLE IF NOT EXISTS `zsk_final_audit_gpwsc_2c` ( `id` mediumint(255) NOT NULL, `request_id` varchar(255) DEFAULT NULL, `flag` tinyint(4) DEFAULT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `bank_report` varchar(255) DEFAULT NULL, `beneficiary_report` varchar(255) DEFAULT NULL, `gpwsc_account_no` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `no_of_latrine` mediumint(255) DEFAULT NULL, `validated_beneficiaries` int(255) DEFAULT NULL, `additional_validated` int(25) DEFAULT NULL, `latrines_notrequired` int(255) DEFAULT NULL, `amount_allocation_division` int(255) DEFAULT NULL, `amount_gpwsc` int(255) DEFAULT NULL, `amount_division_db` int(255) DEFAULT NULL, `amount_gpwsc_db` int(255) DEFAULT NULL, `interest_income` float DEFAULT NULL, `other_income` float DEFAULT NULL, `total_amount_date` date DEFAULT NULL, `incentive_date` date DEFAULT NULL, `amount_gpwsc_incentive` float DEFAULT NULL, `total_amount` float DEFAULT NULL, `received_amount` int(255) DEFAULT NULL, `transferred_amount` int(255) DEFAULT NULL, `balance_GPWSC` float DEFAULT NULL, `executive_name` varchar(255) DEFAULT NULL, `executive_nodal_name` varchar(255) DEFAULT NULL, `sub_engineer_name` varchar(255) DEFAULT NULL, `ae_je_name` varchar(255) DEFAULT NULL, `ca_email_id` varchar(255) DEFAULT NULL, `audit_balance` float DEFAULT NULL, `uc_report` varchar(255) DEFAULT NULL, `letter_number` varchar(255) DEFAULT NULL, `letter_dispatch_date` date DEFAULT NULL, `letter_vide` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_bank_account` -- CREATE TABLE IF NOT EXISTS `zsk_funds_bank_account` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `bill_number` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_bank_account_details` -- CREATE TABLE IF NOT EXISTS `zsk_funds_bank_account_details` ( `id` int(255) NOT NULL, `bank_id` int(255) DEFAULT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `no_of_units` int(255) DEFAULT NULL, `bank_interest` int(255) DEFAULT NULL, `amount_wb` int(255) DEFAULT NULL, `amount_goi` int(255) DEFAULT NULL, `funds_issued` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_hod_details` -- CREATE TABLE IF NOT EXISTS `zsk_funds_hod_details` ( `id` int(255) NOT NULL, `letter_no` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `funds_world_bank` double DEFAULT NULL, `funds_sbm_goi` double DEFAULT NULL, `support_activities` double DEFAULT NULL, `total_amount` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_hod_details_backup` -- CREATE TABLE IF NOT EXISTS `zsk_funds_hod_details_backup` ( `id` int(255) NOT NULL, `funds_hod_id` bigint(255) DEFAULT NULL COMMENT 'FK to zsk_funds_hod_dso', `dso_id` bigint(255) DEFAULT NULL, `no_of_ihhl` int(255) DEFAULT NULL, `no_of_village_odf` bigint(255) DEFAULT NULL, `funds_world_bank` bigint(255) DEFAULT NULL, `funds_sbm_goi` bigint(255) DEFAULT NULL, `support_activities` bigint(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_hod_details_ii` -- CREATE TABLE IF NOT EXISTS `zsk_funds_hod_details_ii` ( `id` int(255) NOT NULL, `funds_hod_id` bigint(255) DEFAULT NULL COMMENT 'FK to zsk_funds_hod_dso', `dso_id` bigint(255) DEFAULT NULL, `no_of_ihhl2` int(255) DEFAULT NULL, `no_of_village_odf2` bigint(255) DEFAULT NULL, `funds_world_bank2` bigint(255) DEFAULT NULL, `funds_sbm_goi2` bigint(255) DEFAULT NULL, `support_activities2` bigint(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_hod_dso` -- CREATE TABLE IF NOT EXISTS `zsk_funds_hod_dso` ( `id` int(255) NOT NULL, `hod_letter_number` varchar(255) DEFAULT NULL, `funds_allocation` double DEFAULT NULL, `date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_hod_dso_backup` -- CREATE TABLE IF NOT EXISTS `zsk_funds_hod_dso_backup` ( `id` int(255) NOT NULL, `funds_allocation` bigint(255) DEFAULT NULL, `hod_letter_number` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_hod_dso_ii` -- CREATE TABLE IF NOT EXISTS `zsk_funds_hod_dso_ii` ( `id` int(255) NOT NULL, `funds_allocation2` bigint(255) DEFAULT NULL, `hod_letter_number2` varchar(255) DEFAULT NULL, `date2` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_lapse_details` -- CREATE TABLE IF NOT EXISTS `zsk_funds_lapse_details` ( `id` int(255) NOT NULL, `letter_no` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `support_activities` double DEFAULT NULL, `ihhl` double DEFAULT NULL, `total_amount` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_loc` -- CREATE TABLE IF NOT EXISTS `zsk_funds_loc` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `bill_number` varchar(255) DEFAULT NULL, `date` date DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_funds_loc_details` -- CREATE TABLE IF NOT EXISTS `zsk_funds_loc_details` ( `id` int(255) NOT NULL, `loc_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `no_of_units` int(255) DEFAULT NULL, `bank_interest` int(255) DEFAULT NULL, `amount_wb` int(255) DEFAULT NULL, `amount_goi` int(255) DEFAULT NULL, `funds_issued` int(255) DEFAULT NULL, `constituency_id` int(11) DEFAULT NULL, `funds_cleared` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_girlchild` -- CREATE TABLE IF NOT EXISTS `zsk_girlchild` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` varchar(255) DEFAULT NULL, `division_id` varchar(255) DEFAULT NULL, `venue` varchar(255) DEFAULT NULL, `no_of_participant` varchar(255) DEFAULT NULL, `female_no_participant` int(255) DEFAULT NULL, `male_no_participant` int(255) DEFAULT NULL, `teacher_no_participant` int(255) DEFAULT NULL, `other_no_participant` int(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_google_drive_links` -- CREATE TABLE IF NOT EXISTS `zsk_google_drive_links` ( `id` int(255) NOT NULL, `document_name` varchar(255) DEFAULT NULL, `link` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_gp_master` -- CREATE TABLE IF NOT EXISTS `zsk_gp_master` ( `id` bigint(255) NOT NULL, `district_id` bigint(255) DEFAULT NULL, `constituency_id` bigint(255) DEFAULT NULL, `block_id` bigint(255) DEFAULT NULL, `division_id` bigint(255) DEFAULT NULL, `village_id` bigint(255) DEFAULT NULL, `sarpanch_name` longtext, `phno_sarpanch` bigint(255) DEFAULT NULL, `je_name` longtext, `phno_je` bigint(255) DEFAULT NULL, `bank_name` varchar(2555) DEFAULT NULL, `branch_name` longtext, `bank_account_number` bigint(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `mis_village_id` varchar(255) DEFAULT NULL, `batch` varchar(255) NOT NULL DEFAULT 'TRANCHE II', `op_water_suppply` int(25) NOT NULL, `no_latrines_baseline` mediumint(255) NOT NULL, `motivator_name` varchar(2555) NOT NULL, `motivator_picture` varchar(2555) NOT NULL, `motivator_mobile_no` int(255) NOT NULL, `nodal_officer_name` varchar(2555) NOT NULL, `nodal_officer_designation` varchar(2555) NOT NULL, `nodal_officer_mobile_no` mediumint(255) NOT NULL, `cross_officer_name` varchar(2555) NOT NULL, `cross_officer_designation` varchar(2555) NOT NULL, `cross_officer_mobile_no` mediumint(255) NOT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_gp_punjab_list` -- CREATE TABLE IF NOT EXISTS `zsk_gp_punjab_list` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `no_of_block` int(255) DEFAULT NULL, `no_of_gp` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_gram_panchayat_list` -- CREATE TABLE IF NOT EXISTS `zsk_gram_panchayat_list` ( `id` bigint(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `beneficiary_table` varchar(255) DEFAULT NULL, `district_name` longtext NOT NULL, `block_id` bigint(255) NOT NULL, `block_name` longtext, `village_name` longtext NOT NULL, `mis_village_id` varchar(255) DEFAULT NULL, `CreateDate` datetime DEFAULT NULL, `blocked_village` int(25) DEFAULT '0', `status` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_id_proof` -- CREATE TABLE IF NOT EXISTS `zsk_id_proof` ( `id` bigint(255) NOT NULL, `proof_name` mediumtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_iec_circle_specialist` -- CREATE TABLE IF NOT EXISTS `zsk_iec_circle_specialist` ( `id` int(255) DEFAULT NULL, `zone_id` int(25) DEFAULT NULL, `zone` varchar(255) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `specialist_name` varchar(25) DEFAULT NULL, `category` varchar(25) DEFAULT NULL, `contact_no` varchar(25) DEFAULT NULL, `joining_date` date DEFAULT NULL, `transfer_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_image_type` -- CREATE TABLE IF NOT EXISTS `zsk_image_type` ( `id` mediumint(255) NOT NULL, `image_category` varchar(2555) DEFAULT NULL, `tag_name` varchar(2555) DEFAULT NULL, `type` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_issue_entry` -- CREATE TABLE IF NOT EXISTS `zsk_issue_entry` ( `id` int(255) NOT NULL, `person_name` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `phone_number` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `issue` text, `issue_file` varchar(255) DEFAULT NULL, `issue_resolved` varchar(25) DEFAULT NULL, `comments` text, `resolve_date` date DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_keywords` -- CREATE TABLE IF NOT EXISTS `zsk_keywords` ( `KeywordID` int(11) NOT NULL, `Keyword` varchar(200) NOT NULL DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_language` -- CREATE TABLE IF NOT EXISTS `zsk_language` ( `id` int(255) NOT NULL, `language` varchar(255) DEFAULT NULL, `newspaper_name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_latrine_completed` -- CREATE TABLE IF NOT EXISTS `zsk_latrine_completed` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `no_of_latrine` mediumint(255) DEFAULT NULL, `ce_letter_number` varchar(255) DEFAULT NULL, `ce_letter_date` date DEFAULT NULL, `scanned_copy` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_latrine_construction_contract` -- CREATE TABLE IF NOT EXISTS `zsk_latrine_construction_contract` ( `id` int(255) NOT NULL, `district_id` bigint(255) DEFAULT NULL, `contract_total_amount` bigint(255) DEFAULT NULL, `date` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_latrine_construction_csr` -- CREATE TABLE IF NOT EXISTS `zsk_latrine_construction_csr` ( `id` int(255) NOT NULL, `district_id` bigint(255) DEFAULT NULL, `csr_total_amount` bigint(255) DEFAULT NULL, `date` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_latrine_construction_goi` -- CREATE TABLE IF NOT EXISTS `zsk_latrine_construction_goi` ( `id` int(255) NOT NULL, `district_id` bigint(255) DEFAULT NULL, `total_amount` bigint(255) DEFAULT NULL, `csr_entry` int(255) DEFAULT NULL, `date` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_latrine_details_2014_2015` -- CREATE TABLE IF NOT EXISTS `zsk_latrine_details_2014_2015` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `pics_uploaded` int(255) DEFAULT NULL, `latrine_completed` int(255) DEFAULT NULL, `village_made_odf` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_latrine_details_2015_2016` -- CREATE TABLE IF NOT EXISTS `zsk_latrine_details_2015_2016` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `block` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `pics_uploaded` int(255) DEFAULT NULL, `latrine_completed` int(255) DEFAULT NULL, `village_made_odf` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_latrine_verification` -- CREATE TABLE IF NOT EXISTS `zsk_latrine_verification` ( `person_name` varchar(255) DEFAULT NULL, `verification_date` date DEFAULT NULL, `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `no_of_latrines_validated` varchar(255) DEFAULT NULL, `no_of_latrines_constructed` varchar(255) DEFAULT NULL, `sanitary_latrines` varchar(255) DEFAULT NULL, `sanitary_latrines_details` varchar(255) DEFAULT NULL, `provision_handwashing` varchar(255) DEFAULT NULL, `provision_handwashing_details` text, `superstructure_of_latrine` varchar(255) DEFAULT NULL, `superstructure_of_latrine_details` text, `provision_of_ventilation` varchar(255) DEFAULT NULL, `household_using_toilet` varchar(255) DEFAULT NULL, `space_leachpits` varchar(255) DEFAULT NULL, `space_leachpits_details` text, `soakage_pit` varchar(255) DEFAULT NULL, `soakage_pit_details` text, `observations` text, `latrine_verified_picture` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_manufacturers` -- CREATE TABLE IF NOT EXISTS `zsk_manufacturers` ( `MNID` int(11) NOT NULL, `MNName` varchar(200) DEFAULT NULL, `MNAddress1` varchar(100) DEFAULT NULL, `MNAddress2` varchar(100) DEFAULT NULL, `MNCity` varchar(100) DEFAULT NULL, `MNState` varchar(100) DEFAULT NULL, `MNCountry` varchar(200) DEFAULT NULL, `MNZipCode` varchar(50) DEFAULT NULL, `MNPhone` varchar(50) DEFAULT NULL, `MNFax` varchar(50) DEFAULT NULL, `MNWebsite` varchar(250) DEFAULT NULL, `Image` varchar(200) DEFAULT NULL, `Description` text, `UpperBanner1` varchar(100) NOT NULL, `Template` varchar(100) NOT NULL, `CreatedDate` datetime DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_mapping_migrant` -- CREATE TABLE IF NOT EXISTS `zsk_mapping_migrant` ( `id` mediumint(255) NOT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `longitude1` varchar(255) DEFAULT NULL, `longitude2` varchar(255) DEFAULT NULL, `longitude3` varchar(255) DEFAULT NULL, `latitude1` varchar(255) DEFAULT NULL, `latitude2` varchar(255) DEFAULT NULL, `latitude3` varchar(255) DEFAULT NULL, `place` varchar(255) DEFAULT NULL, `place_other` varchar(255) DEFAULT NULL, `person_detail` varchar(255) DEFAULT NULL, `person_detail_other` varchar(255) DEFAULT NULL, `no_person_residing` int(255) DEFAULT NULL, `toilet_facility` varchar(255) DEFAULT NULL, `toilet_type` varchar(255) DEFAULT NULL, `place_picture` varchar(255) DEFAULT NULL, `odf_or_not` varchar(25) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_motivator` -- CREATE TABLE IF NOT EXISTS `zsk_master_motivator` ( `id` mediumint(255) NOT NULL, `smart_phone_yes` tinyint(1) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `master_name1` varchar(255) DEFAULT NULL, `emp_code_master1` varchar(255) DEFAULT NULL, `phone_number_master1` mediumint(255) DEFAULT NULL, `master_name2` varchar(255) DEFAULT NULL, `emp_code_master2` varchar(255) DEFAULT NULL, `phone_number_master2` mediumint(255) DEFAULT NULL, `tranche` varchar(255) DEFAULT NULL, `master_village_id` varchar(100) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_motivator_villages` -- CREATE TABLE IF NOT EXISTS `zsk_master_motivator_villages` ( `id` int(11) NOT NULL, `master_motivator_id` int(11) DEFAULT NULL COMMENT 'FK : id of zsk_master_motivator table', `vill_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sanitation_assign` -- CREATE TABLE IF NOT EXISTS `zsk_master_sanitation_assign` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `motivator_id` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sanitation_assign_details` -- CREATE TABLE IF NOT EXISTS `zsk_master_sanitation_assign_details` ( `id` int(255) NOT NULL, `master_id` int(255) DEFAULT NULL, `zone_id` int(5) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `cluster_id` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sanitation_mobile` -- CREATE TABLE IF NOT EXISTS `zsk_master_sanitation_mobile` ( `id` int(255) NOT NULL, `moti_id` int(255) DEFAULT NULL, `motivator_mm_id` varchar(255) DEFAULT NULL, `mobile_amount` int(255) DEFAULT NULL, `request_no` int(255) DEFAULT NULL, `mobile_payorder_no` varchar(255) DEFAULT NULL, `travel_date` date DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sanitation_paystage1` -- CREATE TABLE IF NOT EXISTS `zsk_master_sanitation_paystage1` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `motivator_id` varchar(255) DEFAULT NULL, `master_motivator_id` int(255) DEFAULT NULL, `cluster_id` varchar(255) DEFAULT NULL, `stage1_amount` int(255) DEFAULT NULL, `stage1_payorder_no` varchar(255) DEFAULT NULL, `stage2_amount` int(255) DEFAULT NULL, `stage2_payorder_no` varchar(255) DEFAULT NULL, `stage3_amount` int(255) DEFAULT NULL, `stage3_payorder_no` varchar(255) DEFAULT NULL, `stage4_amount` int(255) DEFAULT NULL, `stage4_payorder_no` varchar(255) DEFAULT NULL, `stage5_amount` int(255) DEFAULT NULL, `stage5_payorder_no` varchar(255) DEFAULT NULL, `stage6_amount` int(255) DEFAULT NULL, `stage6_payorder_no` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sanitation_paystage1_details` -- CREATE TABLE IF NOT EXISTS `zsk_master_sanitation_paystage1_details` ( `id` int(255) NOT NULL, `pay_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `photo_id` int(255) DEFAULT NULL, `activity_id` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sanitation_register` -- CREATE TABLE IF NOT EXISTS `zsk_master_sanitation_register` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) NOT NULL, `mobile_app_id` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `father_name` varchar(255) DEFAULT NULL, `sex` varchar(255) DEFAULT NULL, `mobile_number` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `qualification` varchar(255) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `branch_name` varchar(255) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `motivator_live` varchar(25) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `motivator_picture` varchar(255) DEFAULT NULL, `motivator_registered` int(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sanitation_travel` -- CREATE TABLE IF NOT EXISTS `zsk_master_sanitation_travel` ( `id` int(255) NOT NULL, `moti_id` int(255) DEFAULT NULL, `motivator_mm_id` varchar(255) DEFAULT NULL, `travel_amount` int(255) DEFAULT NULL, `request_no` int(255) DEFAULT NULL, `travel_payorder_no` varchar(255) DEFAULT NULL, `travel_date` date DEFAULT NULL, `travel_visits` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_sewerage_scheme` -- CREATE TABLE IF NOT EXISTS `zsk_master_sewerage_scheme` ( `id` bigint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `constituency_id` varchar(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `sub_division_id` mediumint(255) DEFAULT NULL, `block_id` varchar(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `je_name` varchar(255) DEFAULT NULL, `sarpanch_name` varchar(255) DEFAULT NULL, `sarpanch_phoneno` mediumint(255) DEFAULT NULL, `contractor_name` varchar(255) DEFAULT NULL, `no_of_houses_census` mediumint(255) DEFAULT NULL, `no_of_houses_mis` mediumint(255) DEFAULT NULL, `no_of_houses_sewerpipe` mediumint(255) DEFAULT NULL, `no_of_connection_gpwsc` mediumint(255) DEFAULT NULL, `no_of_connection_physical` mediumint(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_water_assign` -- CREATE TABLE IF NOT EXISTS `zsk_master_water_assign` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `motivator_id` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_water_assign_details` -- CREATE TABLE IF NOT EXISTS `zsk_master_water_assign_details` ( `id` int(255) NOT NULL, `master_id` int(255) DEFAULT NULL, `zone_id` int(5) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `cluster_id` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_master_water_register` -- CREATE TABLE IF NOT EXISTS `zsk_master_water_register` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) NOT NULL, `mobile_app_id` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `father_name` varchar(255) DEFAULT NULL, `sex` varchar(255) DEFAULT NULL, `mobile_number` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `qualification` varchar(255) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `branch_name` varchar(255) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `motivator_live` varchar(25) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `motivator_picture` varchar(255) DEFAULT NULL, `motivator_registered` int(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_merged_validation` -- CREATE TABLE IF NOT EXISTS `zsk_merged_validation` ( `id` mediumint(255) NOT NULL, `date_submission` date DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `district_name` varchar(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `constituency_name` varchar(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `division_name` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `village_name` varchar(255) DEFAULT NULL, `mis_village_id` int(255) DEFAULT NULL, `gram_sabha_meeting_date` date DEFAULT NULL, `no_ihhl_base_line` mediumint(255) DEFAULT NULL, `no_ihhl_cross_verification` mediumint(255) DEFAULT NULL, `house_hold_name` varchar(255) DEFAULT NULL, `house_hold_name_yes` mediumint(255) DEFAULT NULL, `nodal_officer_name` varchar(255) DEFAULT NULL, `nodal_officer_designation` varchar(255) DEFAULT NULL, `nodal_officer_phno` varchar(255) DEFAULT NULL, `cross_verification_name` varchar(255) DEFAULT NULL, `cross_verification_designation` varchar(255) DEFAULT NULL, `cross_verification_phno` varchar(255) DEFAULT NULL, `cross_verification_done` varchar(255) DEFAULT NULL, `cross_verification_date` date DEFAULT NULL, `letter_number` varchar(255) DEFAULT NULL, `cross_verification_report` varchar(255) DEFAULT NULL, `bank_account_opened` varchar(255) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `branch_name` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `Batch` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_modules` -- CREATE TABLE IF NOT EXISTS `zsk_modules` ( `ModuleID` tinyint(4) NOT NULL DEFAULT '0', `ModuleName` varchar(200) NOT NULL DEFAULT '', `Description` text NOT NULL, `ModuleType` varchar(200) NOT NULL DEFAULT '', `ModuleFile` varchar(200) NOT NULL DEFAULT '', `Active` tinyint(4) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_monthly_flag_env_a` -- CREATE TABLE IF NOT EXISTS `zsk_monthly_flag_env_a` ( `id` int(255) NOT NULL, `water_supply_scheme` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `je_name` varchar(255) DEFAULT NULL, `sde` varchar(255) DEFAULT NULL, `lpcd_design` varchar(255) DEFAULT NULL, `env_category` varchar(255) DEFAULT NULL, `water_quality_issues` text, `treatment_plant_loc` varchar(255) DEFAULT NULL, `treatment_plant_loc_issues` text, `isolated_site` varchar(255) DEFAULT NULL, `isolated_site_issues` text, `treatment_plants` varchar(255) DEFAULT NULL, `treatment_plants_issues` text, `clearance_trees` varchar(255) DEFAULT NULL, `clearance_trees_issues` text, `joint_inspection` varchar(255) DEFAULT NULL, `joint_inspection_issues` text, `located_away` varchar(255) DEFAULT NULL, `located_away_issues` text, `construction_camps_layout` varchar(255) DEFAULT NULL, `construction_camps_layout_issues` text, `construction_camps` varchar(255) DEFAULT NULL, `construction_camps_issues` text, `contractor_consultations` varchar(255) DEFAULT NULL, `contractor_consultations_issues` text, `contractor_water_utilize` varchar(255) DEFAULT NULL, `contractor_water_utilize_issues` text, `new_bore_wells` varchar(255) DEFAULT NULL, `new_bore_wells_issues` text, `surface_water_body` varchar(255) DEFAULT NULL, `surface_water_body_issues` text, `curing_concrete` varchar(255) DEFAULT NULL, `curing_concrete_issues` text, `disposal_sites` varchar(255) DEFAULT NULL, `disposal_sites_issues` text, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_monthly_flag_env_b` -- CREATE TABLE IF NOT EXISTS `zsk_monthly_flag_env_b` ( `id` int(255) NOT NULL, `water_supply_scheme` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `je_name` varchar(255) DEFAULT NULL, `sde` varchar(255) DEFAULT NULL, `lpcd_design` varchar(255) DEFAULT NULL, `env_category` varchar(255) DEFAULT NULL, `water_quality_issues` text, `illegal_tree` varchar(255) DEFAULT NULL, `illegal_tree_issues` text, `vegetation_clearance` varchar(255) DEFAULT NULL, `vegetation_clearance_issues` text, `losse_soil` varchar(255) DEFAULT NULL, `losse_soil_issues` text, `damage_roots` varchar(255) DEFAULT NULL, `damage_roots_issues` text, `lean_season` varchar(255) DEFAULT NULL, `lean_season_issues` text, `refill_trench` varchar(255) DEFAULT NULL, `refill_trench_issues` text, `excavated_areas` varchar(255) DEFAULT NULL, `excavated_areas_issues` text, `proper_barricading` varchar(255) DEFAULT NULL, `proper_barricading_issues` text, `sign_boards` varchar(255) DEFAULT NULL, `sign_boards_issues` text, `construction_material` varchar(255) DEFAULT NULL, `construction_material_issues` text, `construction_site` varchar(255) DEFAULT NULL, `construction_site_issues` text, `hazardous_material` varchar(255) DEFAULT NULL, `hazardous_material_issues` text, `water_logging` varchar(255) DEFAULT NULL, `water_logging_issues` text, `protective_guards` varchar(255) DEFAULT NULL, `protective_guards_issues` text, `store_tools` varchar(10) DEFAULT NULL, `store_tools_issues` text, `scrap_lumber` varchar(10) DEFAULT NULL, `scrap_lumber_issues` text, `losse_material` varchar(10) DEFAULT NULL, `losse_material_issues` text, `good_housekeeping` varchar(10) DEFAULT NULL, `good_housekeeping_issues` text, `machineries` varchar(10) DEFAULT NULL, `machineries_issues` text, `high_noise` varchar(10) DEFAULT NULL, `high_noise_issues` text, `generators` varchar(10) DEFAULT NULL, `generators_issues` text, `special_care` varchar(10) DEFAULT NULL, `special_care_issues` text, `noise_emission` varchar(10) DEFAULT NULL, `noise_emission_issues` text, `maintained_vehicles` varchar(10) DEFAULT NULL, `maintained_vehicles_issues` text, `dusty_areas` varchar(10) DEFAULT NULL, `dusty_areas_issues` text, `construction_debris` varchar(10) DEFAULT NULL, `construction_debris_issues` text, `nose_mask` varchar(10) DEFAULT NULL, `nose_mask_issues` text, `air_pollution` varchar(10) DEFAULT NULL, `air_pollution_issues` text, `no_washing_vehicles` varchar(10) DEFAULT NULL, `no_washing_vehicles_issues` text, `debris_disposed` varchar(10) DEFAULT NULL, `debris_disposed_issues` text, `own_water` varchar(10) DEFAULT NULL, `own_water_issues` text, `area_compacted` varchar(10) DEFAULT NULL, `area_compacted_issues` text NOT NULL, `losse_earth` varchar(10) DEFAULT NULL, `loose_earth_issues` text, `cooking_fuel` varchar(10) DEFAULT NULL, `cooking_fue_issues` text, `proper_sanitation` varchar(10) DEFAULT NULL, `proper_sanitation_issues` text, `drinking_water` varchar(10) DEFAULT NULL, `drinking_water_issues` text, `logging_condition` varchar(10) DEFAULT NULL, `logging_condition_issues` text, `safe_access` varchar(10) DEFAULT NULL, `safe_access_issues` text, `passage_way` varchar(10) DEFAULT NULL, `passage_way_issues` text, `first_aid` varchar(10) DEFAULT NULL, `firat_aid_issues` text, `nursing_homes` varchar(10) DEFAULT NULL, `nursing_homes_issues` text, `vehicle_available` varchar(10) DEFAULT NULL, `vehicle_available_issues` text, `safety_workmen` varchar(10) DEFAULT NULL, `safety_workmen_issues` text, `child_labour` varchar(10) DEFAULT NULL, `child_labour_issues` text, `personal_equipment` varchar(10) DEFAULT NULL, `personal_equipment_issues` text, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_monthly_reports` -- CREATE TABLE IF NOT EXISTS `zsk_monthly_reports` ( `id` bigint(20) NOT NULL, `village_id` int(11) NOT NULL, `district_id` int(11) NOT NULL, `block_id` int(255) DEFAULT NULL, `water_reading` bigint(20) NOT NULL, `water_pump_hrs` double(10,2) NOT NULL, `water_supply_avg` int(11) NOT NULL, `hourly_pump_discharge` bigint(20) NOT NULL, `water_charges_basedon` tinyint(4) NOT NULL, `elec_mtr_current` bigint(20) NOT NULL, `leakage_count` int(11) NOT NULL, `elec_maint_reqd` tinyint(1) NOT NULL, `disinfection_maint_reqd` tinyint(1) NOT NULL, `water_disruption_hrs` double(10,2) NOT NULL, `is_ohsr_cleaned` tinyint(1) NOT NULL, `water_pressure_issues` tinyint(4) NOT NULL, `hh_not_covered_count` int(11) NOT NULL, `income` double(10,2) NOT NULL, `tot_expenditure` double(10,2) NOT NULL, `balance_in_acct` double(10,2) NOT NULL, `is_ro_functional` tinyint(1) NOT NULL, `no_of_cardholders` int(11) NOT NULL, `issues_with_sewerage` tinyint(4) NOT NULL, `date_created` datetime DEFAULT NULL, `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by` tinytext NOT NULL, `created_from_app` tinyint(1) NOT NULL, `latitude` double NOT NULL, `longitude` double NOT NULL, `created_on` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator` -- CREATE TABLE IF NOT EXISTS `zsk_motivator` ( `id` mediumint(255) NOT NULL, `smart_phone_yes` tinyint(1) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `master_name` varchar(255) DEFAULT NULL, `emp_code_master` varchar(255) DEFAULT NULL, `phone_number_master` mediumint(255) DEFAULT NULL, `tranche` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_images` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_images` ( `id` mediumint(255) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `district_id` text, `male_sensitized` varchar(2555) DEFAULT NULL, `female_sensitized` varchar(2555) DEFAULT NULL, `image_type` varchar(25555) DEFAULT NULL, `moti_image` varchar(25555) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `moti_latitude` double DEFAULT NULL, `moti_longitude` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_payorders_activity` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_payorders_activity` ( `id` int(255) NOT NULL, `activity` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `constituency_id` int(100) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `cluster_name` varchar(255) DEFAULT NULL, `cluster_type` varchar(25) DEFAULT 'Sanitation', `unique_id` varchar(255) DEFAULT NULL, `cluster_creation_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_assign` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_assign` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `motivator_id` varchar(255) DEFAULT NULL, `cluster_id` varchar(25) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_details` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_details` ( `id` int(255) NOT NULL, `cluster_id` int(255) DEFAULT NULL, `zone_id` int(5) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_mobile` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_mobile` ( `id` int(255) NOT NULL, `moti_id` int(255) DEFAULT NULL, `motivator_mm_id` varchar(255) DEFAULT NULL, `mobile_amount` int(255) DEFAULT NULL, `request_no` int(255) DEFAULT NULL, `mobile_payorder_no` varchar(255) DEFAULT NULL, `travel_date` date DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_payorders_activity` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_payorders_activity` ( `id` int(255) NOT NULL, `activity` varchar(255) DEFAULT NULL, `Stage` varchar(25) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_paystage` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_paystage` ( `id` int(255) NOT NULL, `pay_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `stage` varchar(255) DEFAULT NULL, `collect_ben_form` varchar(255) DEFAULT NULL, `assist_nodal_officer` varchar(255) DEFAULT NULL, `prepare_ben_list` varchar(255) DEFAULT NULL, `completion_ben_validate` varchar(255) DEFAULT NULL, `support_motivator` varchar(255) DEFAULT NULL, `latrine_usage` varchar(255) DEFAULT NULL, `completed_latrine_GOI` varchar(25) DEFAULT NULL, `organise_early_annoucement` varchar(25) DEFAULT NULL, `low_cost_toilet` varchar(255) DEFAULT NULL, `constructed_ihhl` varchar(255) DEFAULT NULL, `village_attain_odf` varchar(255) DEFAULT NULL, `all_latrine_inuse` varchar(255) DEFAULT NULL, `early_morning_annoucement` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_paystage1` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_paystage1` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `motivator_id` varchar(255) DEFAULT NULL, `master_motivator_id` int(255) DEFAULT NULL, `cluster_id` varchar(255) DEFAULT NULL, `stage1_amount` int(255) DEFAULT NULL, `stage1_payorder_no` varchar(255) DEFAULT NULL, `stage2_amount` int(255) DEFAULT NULL, `stage2_payorder_no` varchar(255) DEFAULT NULL, `stage3_amount` int(255) DEFAULT NULL, `stage3_payorder_no` varchar(255) DEFAULT NULL, `stage4_amount` int(255) DEFAULT NULL, `stage4_payorder_no` varchar(255) DEFAULT NULL, `stage5_amount` int(255) DEFAULT NULL, `stage5_payorder_no` varchar(255) DEFAULT NULL, `stage6_amount` int(255) DEFAULT NULL, `stage6_payorder_no` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_paystage1_details` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_paystage1_details` ( `id` int(255) NOT NULL, `pay_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `photo_id` int(255) DEFAULT NULL, `activity_id` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_register` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_register` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) NOT NULL, `mobile_app_id` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `father_name` varchar(255) DEFAULT NULL, `sex` varchar(255) DEFAULT NULL, `mobile_number` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `qualification` varchar(255) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `branch_name` varchar(255) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `motivator_live` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `motivator_picture` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_sanitation_travel` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_sanitation_travel` ( `id` int(255) NOT NULL, `moti_id` int(255) DEFAULT NULL, `motivator_mm_id` varchar(255) DEFAULT NULL, `travel_amount` int(255) DEFAULT NULL, `request_no` int(255) DEFAULT NULL, `travel_payorder_no` varchar(255) DEFAULT NULL, `travel_date` date DEFAULT NULL, `travel_visits` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_triggering_report` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_triggering_report` ( `id` int(255) NOT NULL, `district` varchar(255) DEFAULT NULL, `district_id` int(25) DEFAULT NULL, `gp_validated` int(255) DEFAULT NULL, `camp_reqd` int(25) DEFAULT NULL, `camp_conducted` int(25) DEFAULT NULL, `camp_previous` int(25) DEFAULT NULL, `total_camp` int(25) DEFAULT NULL, `motivator_register` int(25) DEFAULT NULL, `master_register` int(25) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_villages` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_villages` ( `id` int(11) NOT NULL, `motivator_id` int(11) DEFAULT NULL COMMENT 'FK : id of zsk_master_motivator table', `vill_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `constituency_id` int(100) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `cluster_name` varchar(255) DEFAULT NULL, `cluster_type` varchar(25) DEFAULT 'Water', `unique_id` varchar(255) DEFAULT NULL, `cluster_creation_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_assign` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_assign` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `motivator_id` varchar(255) DEFAULT NULL, `cluster_id` varchar(25) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_details` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_details` ( `id` int(255) NOT NULL, `cluster_id` int(255) DEFAULT NULL, `zone_id` int(5) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_mobile` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_mobile` ( `id` int(255) NOT NULL, `moti_id` int(255) DEFAULT NULL, `motivator_mm_id` varchar(255) DEFAULT NULL, `mobile_amount` int(255) DEFAULT NULL, `request_no` int(255) DEFAULT NULL, `mobile_payorder_no` varchar(255) DEFAULT NULL, `travel_date` date DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_paystage1` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_paystage1` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `motivator_id` varchar(255) DEFAULT NULL, `master_motivator_id` int(255) DEFAULT NULL, `cluster_id` varchar(255) DEFAULT NULL, `stage1_amount` int(255) DEFAULT NULL, `stage1_payorder_no` varchar(255) DEFAULT NULL, `stage2_amount` int(255) DEFAULT NULL, `stage2_payorder_no` varchar(255) DEFAULT NULL, `stage3_amount` int(255) DEFAULT NULL, `stage3_payorder_no` varchar(255) DEFAULT NULL, `stage4_amount` int(255) DEFAULT NULL, `stage4_payorder_no` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_paystage1_details` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_paystage1_details` ( `id` int(255) NOT NULL, `pay_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `photo_id` int(255) DEFAULT NULL, `activity_id` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_paystage2` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_paystage2` ( `id` int(255) NOT NULL, `pay_id` int(255) DEFAULT NULL, `zone_id` int(5) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `cluster_id` varchar(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `one_ward_meeting` int(255) DEFAULT NULL, `water_testing_camp` int(255) DEFAULT NULL, `awareness_activity_school` int(255) DEFAULT NULL, `water_supplied_OHSR` int(255) DEFAULT NULL, `participatory_rural` int(255) DEFAULT NULL, `capacity_building_GPWSC` int(255) DEFAULT NULL, `conduct_iec_cb` int(255) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `amount` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_paystage3` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_paystage3` ( `id` int(255) NOT NULL, `pay_id` int(255) DEFAULT NULL, `zone_id` int(5) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `cluster_id` varchar(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `water_supply_hour` int(255) DEFAULT NULL, `iec_activity` int(255) DEFAULT NULL, `capacitating_gpwsc_community` int(255) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `amount` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_paystage4` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_paystage4` ( `id` int(255) NOT NULL, `pay_id` int(255) DEFAULT NULL, `zone_id` int(5) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `cluster_id` varchar(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `training_gpwsc_member` int(255) DEFAULT NULL, `gpwsc_revenue_collection` int(255) DEFAULT NULL, `gpwsc_handing_scheme` int(255) DEFAULT NULL, `awareness_hand_washing` int(255) DEFAULT NULL, `post_implementation_audit` int(255) DEFAULT NULL, `payorder_no` int(255) DEFAULT NULL, `amount` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAdress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_priority` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_priority` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `cluster_id` varchar(25) DEFAULT NULL, `Priority` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_priority_details` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_priority_details` ( `id` int(255) NOT NULL, `priority_id` int(255) DEFAULT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `cluster_id` varchar(25) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `village_type` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_register` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_register` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) NOT NULL, `mobile_app_id` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `father_name` varchar(255) DEFAULT NULL, `sex` varchar(255) DEFAULT NULL, `mobile_number` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `qualification` varchar(255) DEFAULT NULL, `email_id` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `branch_name` varchar(255) DEFAULT NULL, `bank_account_number` varchar(255) DEFAULT NULL, `ifsc_code` varchar(255) DEFAULT NULL, `motivator_live` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `motivator_picture` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_motivator_water_travel` -- CREATE TABLE IF NOT EXISTS `zsk_motivator_water_travel` ( `id` int(255) NOT NULL, `moti_id` int(255) DEFAULT NULL, `motivator_mm_id` varchar(255) DEFAULT NULL, `travel_amount` int(255) DEFAULT NULL, `request_no` int(255) DEFAULT NULL, `travel_payorder_no` varchar(255) DEFAULT NULL, `travel_date` date DEFAULT NULL, `travel_visits` int(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_moti_test` -- CREATE TABLE IF NOT EXISTS `zsk_moti_test` ( `id` int(25) DEFAULT NULL, `year` int(25) DEFAULT NULL, `month` int(25) DEFAULT NULL, `dat` int(255) DEFAULT NULL, `moti_image` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_newsletters` -- CREATE TABLE IF NOT EXISTS `zsk_newsletters` ( `NewsletterID` int(11) NOT NULL, `Subject` varchar(255) NOT NULL DEFAULT '', `Sender` text NOT NULL, `Description` text NOT NULL, `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_newspaper` -- CREATE TABLE IF NOT EXISTS `zsk_newspaper` ( `id` int(11) NOT NULL, `zone_id` int(11) DEFAULT NULL, `circle_id` int(11) DEFAULT NULL, `district_id` int(11) DEFAULT NULL, `language` varchar(255) DEFAULT NULL, `newspaper_name` varchar(255) DEFAULT NULL, `news_heading` varchar(255) DEFAULT NULL, `date_news_publication` date DEFAULT NULL, `news_image1` varchar(255) DEFAULT NULL, `news_image2` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_news_flash` -- CREATE TABLE IF NOT EXISTS `zsk_news_flash` ( `id` mediumint(255) NOT NULL, `title` text, `Content` text, `Active` int(11) DEFAULT NULL, `Latest` int(25) DEFAULT NULL, `Position` int(25) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_nomination_entry` -- CREATE TABLE IF NOT EXISTS `zsk_nomination_entry` ( `id` mediumint(255) NOT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `champion_name` varchar(255) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `phone_number` varchar(255) DEFAULT NULL, `adhar_number` varchar(255) DEFAULT NULL, `contribution` text, `champion_pic` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_odf_complaint` -- CREATE TABLE IF NOT EXISTS `zsk_odf_complaint` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `complaint_whatsapp` int(255) DEFAULT NULL, `complaint_whatsapp_district` int(255) DEFAULT NULL, `complaint_whatsapp_resolved` int(255) DEFAULT NULL, `complaint_emails` int(255) DEFAULT NULL, `complaint_emails_district` int(255) DEFAULT NULL, `complaint_emails_resolved` int(255) DEFAULT NULL, `complaint_snk` int(255) DEFAULT NULL, `complaint_snk_district` int(255) DEFAULT NULL, `complaint_snk_resolved` int(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_odf_entry` -- CREATE TABLE IF NOT EXISTS `zsk_odf_entry` ( `id` mediumint(255) NOT NULL, `circle_id` mediumint(255) DEFAULT NULL, `zone_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `no_houses` mediumint(255) DEFAULT NULL, `no_latrines_notrequired` mediumint(255) DEFAULT NULL, `no_of_houses_latrine` mediumint(255) DEFAULT NULL, `no_houses_latrine_member` mediumint(255) DEFAULT NULL, `gp_declared_odf_panch` mediumint(255) DEFAULT NULL, `gp_resolution` varchar(2555) DEFAULT NULL, `cross_officer_district_level` varchar(2555) DEFAULT NULL, `cross_verification_date` date DEFAULT NULL, `cross_report_copy` varchar(2555) DEFAULT NULL, `no_swachh_club` mediumint(255) DEFAULT NULL, `gp_declared_odf_district` mediumint(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_odf_target` -- CREATE TABLE IF NOT EXISTS `zsk_odf_target` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `target` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_odf_verification` -- CREATE TABLE IF NOT EXISTS `zsk_odf_verification` ( `person_name` varchar(255) DEFAULT NULL, `verification_date` date DEFAULT NULL, `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `constituency_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `household_toilet_facility` varchar(255) DEFAULT NULL, `household_using_toilet` varchar(255) DEFAULT NULL, `fly_proofing_toilet` varchar(255) DEFAULT NULL, `safe_septage_disposal` varchar(255) DEFAULT NULL, `safe_septage_disposal_details` text, `handwashing_before_meals` varchar(2555) DEFAULT NULL, `handwashing_with_soap` varchar(2555) DEFAULT NULL, `soap_water_available` varchar(255) DEFAULT NULL, `visible_faeces_found` varchar(2555) DEFAULT NULL, `school_toilet_utilized` varchar(255) DEFAULT NULL, `school_toilet_utilized_details` text, `safe_confinement_excreta` varchar(255) DEFAULT NULL, `safe_confinement_excreta_details` text, `angarwari_toilet_utilized` varchar(255) DEFAULT NULL, `angarwari_toilet_utilized_details` text, `safe_excreta_angarwari` varchar(255) DEFAULT NULL, `safe_excreta_angarwari_details` text, `observations` text, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_other_files` -- CREATE TABLE IF NOT EXISTS `zsk_other_files` ( `FileID` bigint(20) NOT NULL, `ReferenceID` varchar(100) DEFAULT NULL, `ReferenceType` varchar(100) DEFAULT NULL, `Upload` varchar(100) DEFAULT NULL, `UploadType` varchar(100) DEFAULT NULL, `Active` tinyint(1) DEFAULT NULL, `Position` int(11) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `zsk_other_news` -- CREATE TABLE IF NOT EXISTS `zsk_other_news` ( `NewsID` int(11) NOT NULL, `NewsTitle` varchar(250) NOT NULL DEFAULT '', `URLName` varchar(200) NOT NULL DEFAULT '', `MetaTitle` varchar(250) DEFAULT NULL, `MetaKeywords` tinytext, `MetaDescription` tinytext, `NewsDate` date DEFAULT NULL, `Description` text NOT NULL, `LongDescription` text NOT NULL, `Active` tinyint(4) NOT NULL DEFAULT '0', `HomePage` tinyint(4) NOT NULL DEFAULT '0', `Image` varchar(50) NOT NULL DEFAULT '', `File` varchar(200) DEFAULT NULL, `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `zsk_other_reports` -- CREATE TABLE IF NOT EXISTS `zsk_other_reports` ( `ReportID` int(11) NOT NULL, `ReportTitle` varchar(250) NOT NULL DEFAULT '', `LongDescription` text NOT NULL, `Active` tinyint(4) NOT NULL DEFAULT '0', `Position` int(11) DEFAULT NULL, `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `zsk_pacosan` -- CREATE TABLE IF NOT EXISTS `zsk_pacosan` ( `person_name` varchar(255) DEFAULT NULL, `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `position` varchar(255) DEFAULT NULL, `contact_no` varchar(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_pacosan_images` -- CREATE TABLE IF NOT EXISTS `zsk_pacosan_images` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `event_name` varchar(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `prog_pic5` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_pages` -- CREATE TABLE IF NOT EXISTS `zsk_pages` ( `PageID` bigint(20) NOT NULL, `PageName` varchar(255) DEFAULT '', `LinkTitle` varchar(255) DEFAULT '', `Active` tinyint(4) DEFAULT '0', `CreatedDate` datetime DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_passed_bills` -- CREATE TABLE IF NOT EXISTS `zsk_passed_bills` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `water_supply_scheme` varchar(255) DEFAULT NULL, `programme_name_id` int(255) DEFAULT NULL, `programme_component_id` int(255) DEFAULT NULL, `contractor_name` varchar(255) DEFAULT NULL, `date_start_work` date DEFAULT NULL, `date_of_passing_bill` date DEFAULT NULL, `amount` bigint(255) DEFAULT NULL, `remarks` text, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_passed_bills_programme_component` -- CREATE TABLE IF NOT EXISTS `zsk_passed_bills_programme_component` ( `id` int(255) NOT NULL, `programme_id` int(255) DEFAULT NULL, `component` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_passed_bills_programme_name` -- CREATE TABLE IF NOT EXISTS `zsk_passed_bills_programme_name` ( `id` int(255) NOT NULL, `programme_name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_plantation` -- CREATE TABLE IF NOT EXISTS `zsk_plantation` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` varchar(255) DEFAULT NULL, `division_id` varchar(255) DEFAULT NULL, `nodal_officer` varchar(255) DEFAULT NULL, `water_supply_scheme` varchar(255) DEFAULT NULL, `no_sapling_planted` int(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_revenue_collector` -- CREATE TABLE IF NOT EXISTS `zsk_revenue_collector` ( `id` mediumint(255) NOT NULL, `district_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(25) DEFAULT NULL, `revenue_name` varchar(255) DEFAULT NULL, `adhaar_number` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `revenue_picture` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_revenue_habitation` -- CREATE TABLE IF NOT EXISTS `zsk_revenue_habitation` ( `id` int(255) NOT NULL, `village_id` varchar(255) NOT NULL, `village_name` varchar(255) NOT NULL, `sbm_district_id` int(255) DEFAULT NULL, `district_id` varchar(255) NOT NULL, `district_name` varchar(255) NOT NULL, `block_id` varchar(255) NOT NULL, `sbm_block_id` int(25) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL, `scheme_id` varchar(255) DEFAULT NULL, `scheme_name` varchar(255) DEFAULT NULL, `scheme_operate_by` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_revenue_villages` -- CREATE TABLE IF NOT EXISTS `zsk_revenue_villages` ( `id` int(11) NOT NULL, `motivator_id` int(11) DEFAULT NULL COMMENT 'FK : id of zsk_master_motivator table', `vill_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_revenue_village_habitation` -- CREATE TABLE IF NOT EXISTS `zsk_revenue_village_habitation` ( `id` int(255) NOT NULL, `circle` varchar(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_name` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `constituency` varchar(255) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL, `sbm_block_id` int(255) DEFAULT NULL, `scheme_name` varchar(255) DEFAULT NULL, `scheme_id` varchar(255) DEFAULT NULL, `source` varchar(255) DEFAULT NULL, `village_name` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `operated_by` varchar(255) DEFAULT NULL, `supply_hours` int(255) DEFAULT NULL, `service_level` varchar(255) DEFAULT NULL, `water_quality_issue` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_rfp_form` -- CREATE TABLE IF NOT EXISTS `zsk_rfp_form` ( `id` int(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `firm_name` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_ro_scheme` -- CREATE TABLE IF NOT EXISTS `zsk_ro_scheme` ( `id` bigint(255) NOT NULL, `date_of_report` text, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `subdivisional_engineer` varchar(255) DEFAULT NULL, `emp_code` mediumint(255) DEFAULT NULL, `no_ro_plants_sub_division` varchar(255) DEFAULT NULL, `no_of_houses` mediumint(255) DEFAULT NULL, `no_connection_wed` mediumint(255) DEFAULT NULL, `no_connection_week` mediumint(255) DEFAULT NULL, `no_ro_plants_week` mediumint(255) DEFAULT NULL, `no_ro_plants_JE` mediumint(255) DEFAULT NULL, `no_ro_non_functional_major_week` mediumint(255) DEFAULT NULL, `no_ro_non_functional_minor_week` mediumint(255) DEFAULT NULL, `no_ro_plants_month` mediumint(255) DEFAULT NULL, `no_ro_plants_major_rectified` mediumint(255) DEFAULT NULL, `no_ro_plants_minor_rectified` mediumint(255) DEFAULT NULL, `no_plants_penetration_less25` mediumint(255) DEFAULT NULL, `no_plants_penetration_25` mediumint(255) DEFAULT NULL, `no_plants_penetration_50` mediumint(255) DEFAULT NULL, `no_plants_penetration_75` mediumint(255) DEFAULT NULL, `no_estimates` mediumint(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_rural_gp_list` -- CREATE TABLE IF NOT EXISTS `zsk_rural_gp_list` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `block` varchar(255) DEFAULT NULL, `gram_sabha_area` varchar(255) DEFAULT NULL, `village_name` varchar(255) DEFAULT NULL, `blocked_village` int(25) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sample_duty` -- CREATE TABLE IF NOT EXISTS `zsk_sample_duty` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `officer_appointed` varchar(255) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL, `duty_allocation_date` date DEFAULT NULL, `no_of_villages_record_check` varchar(255) DEFAULT NULL, `no_of_village_physical_verification` varchar(255) DEFAULT NULL, `compliance_report_received` varchar(255) DEFAULT NULL, `report_received_date` date DEFAULT NULL, `reminder_issue_date` date DEFAULT NULL, `no_beneficiary_cross_verification` varchar(255) DEFAULT NULL, `no_eligible_beneficiary` varchar(255) DEFAULT NULL, `CreatedDate` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sanitation_document` -- CREATE TABLE IF NOT EXISTS `zsk_sanitation_document` ( `id` int(255) NOT NULL, `document_name` varchar(255) DEFAULT NULL, `sanitation_doc` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sanitation_specialist` -- CREATE TABLE IF NOT EXISTS `zsk_sanitation_specialist` ( `id` int(255) NOT NULL DEFAULT '0', `zone_id` int(25) DEFAULT NULL, `zone` varchar(255) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `district_id` int(25) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `division_id` int(25) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `specialist_name` varchar(25) DEFAULT NULL, `category` varchar(25) DEFAULT NULL, `contact_no` varchar(25) DEFAULT NULL, `executive_name` varchar(255) DEFAULT NULL, `executive_contact_no` varchar(255) DEFAULT NULL, `joining_date` date DEFAULT NULL, `transfer_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sankalp_essay` -- CREATE TABLE IF NOT EXISTS `zsk_sankalp_essay` ( `id` int(255) NOT NULL, `volunteer_name` varchar(255) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `Phone` varchar(100) DEFAULT NULL, `Email` varchar(200) NOT NULL, `queries` text, `Photo` varchar(255) DEFAULT NULL, `Photo2` varchar(255) DEFAULT NULL, `Photo3` varchar(255) DEFAULT NULL, `Consent_letter` varchar(250) DEFAULT NULL, `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sankalp_video` -- CREATE TABLE IF NOT EXISTS `zsk_sankalp_video` ( `id` int(255) NOT NULL, `volunteer_name` varchar(255) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `Phone` varchar(100) DEFAULT NULL, `Email` varchar(200) NOT NULL, `queries` text, `Photo` varchar(255) DEFAULT NULL, `Consent_letter` varchar(250) DEFAULT NULL, `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sbm_monitoring` -- CREATE TABLE IF NOT EXISTS `zsk_sbm_monitoring` ( `id` bigint(255) NOT NULL, `date_of_report` text, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `ae_je` varchar(255) DEFAULT NULL, `emp_code` mediumint(255) DEFAULT NULL, `no_gp` varchar(255) DEFAULT NULL, `no_gp_beneficiary_complete` mediumint(255) DEFAULT NULL, `no_gp_community_complete` mediumint(255) DEFAULT NULL, `no_gp_nigrani` mediumint(255) DEFAULT NULL, `no_latrines_constructed` mediumint(255) DEFAULT NULL, `no_latrines_constructed_Iststage` mediumint(255) DEFAULT NULL, `no_latrines_completed` mediumint(255) DEFAULT NULL, `no_mason_teams_enagaged` mediumint(255) DEFAULT NULL, `no_village_declaredODF` mediumint(255) DEFAULT NULL, `no_village_declaredODF_oct` mediumint(255) DEFAULT NULL, `no_snk_complaints_pending` mediumint(255) DEFAULT NULL, `complaints_received` mediumint(255) DEFAULT NULL, `complaints_closed` mediumint(255) DEFAULT NULL, `total_complaints_pending` mediumint(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_seo` -- CREATE TABLE IF NOT EXISTS `zsk_seo` ( `URLID` bigint(20) NOT NULL, `URLName` varchar(255) NOT NULL, `MetaTitle` varchar(255) NOT NULL, `MetaKeyword` text NOT NULL, `MetaDescription` text NOT NULL, `RedirectEnabled` tinyint(1) NOT NULL, `RedirectURL` varchar(255) NOT NULL, `RefrenceType` varchar(50) NOT NULL, `ReferenceID` bigint(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sewerage_issue` -- CREATE TABLE IF NOT EXISTS `zsk_sewerage_issue` ( `id` bigint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `constituency_id` varchar(255) DEFAULT NULL, `block_id` varchar(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `inspecting_officer` varchar(255) DEFAULT NULL, `inspecting_officer_designation` varchar(255) DEFAULT NULL, `date_inspection` date DEFAULT NULL, `issue1` text, `issue2` text, `issue3` text, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sewerage_scheme` -- CREATE TABLE IF NOT EXISTS `zsk_sewerage_scheme` ( `id` bigint(255) NOT NULL, `date_of_report` text, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `division_id` mediumint(255) DEFAULT NULL, `executive_engineer` varchar(255) DEFAULT NULL, `emp_code` mediumint(255) DEFAULT NULL, `type_of_scheme` varchar(255) DEFAULT NULL, `no_sewerage_world_bank` mediumint(255) DEFAULT NULL, `no_of_houses` mediumint(255) DEFAULT NULL, `no_connection_wed` mediumint(255) DEFAULT NULL, `no_connection_week` mediumint(255) DEFAULT NULL, `no_sewerage_scheme_executive` mediumint(255) DEFAULT NULL, `no_sewerage_scheme_SDE` mediumint(255) DEFAULT NULL, `no_scheme_non_functional_week` mediumint(255) DEFAULT NULL, `no_scheme_non_functional_inspection` mediumint(255) DEFAULT NULL, `no_scheme_rectified` mediumint(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sird_payorder` -- CREATE TABLE IF NOT EXISTS `zsk_sird_payorder` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(100) DEFAULT NULL, `sird_id` varchar(255) DEFAULT NULL, `cluster_id` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sird_sanitation` -- CREATE TABLE IF NOT EXISTS `zsk_sird_sanitation` ( `id` int(255) NOT NULL, `zone_id` int(25) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `district_id` int(25) DEFAULT NULL, `division_id` int(25) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_sms` -- CREATE TABLE IF NOT EXISTS `zsk_sms` ( `id` int(255) NOT NULL, `RecipientType` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `multiplemobile` varchar(255) DEFAULT NULL, `message` text, `template` varchar(255) DEFAULT NULL, `CreateDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_static_water_supply` -- CREATE TABLE IF NOT EXISTS `zsk_static_water_supply` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `no_rural_scheme` varchar(255) DEFAULT NULL, `no_scheme_dwss` varchar(255) DEFAULT NULL, `no_private_connection` varchar(255) DEFAULT NULL, `pending_water_charges` varchar(255) DEFAULT NULL, `amount_paid_pspcl` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_subdivisions_list` -- CREATE TABLE IF NOT EXISTS `zsk_subdivisions_list` ( `id` int(255) NOT NULL, `circle_id` int(255) DEFAULT NULL, `circle_name` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `district_name` varchar(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `sub_division` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_success_state_story` -- CREATE TABLE IF NOT EXISTS `zsk_success_state_story` ( `id` mediumint(255) NOT NULL, `champion_name` varchar(255) DEFAULT NULL, `success_file` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_success_story` -- CREATE TABLE IF NOT EXISTS `zsk_success_story` ( `id` mediumint(255) NOT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` mediumint(255) DEFAULT NULL, `village_id` mediumint(255) DEFAULT NULL, `champion_name` varchar(255) DEFAULT NULL, `success_file` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_supervisor_images` -- CREATE TABLE IF NOT EXISTS `zsk_supervisor_images` ( `id` mediumint(255) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `male_sensitized` varchar(2555) DEFAULT NULL, `female_sensitized` varchar(2555) DEFAULT NULL, `image_type` varchar(25555) DEFAULT NULL, `super_image` varchar(25555) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL, `super_latitude` double DEFAULT NULL, `super_longitude` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_supervisor_ROvisit_images` -- CREATE TABLE IF NOT EXISTS `zsk_supervisor_ROvisit_images` ( `id` int(11) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `district_id` text, `male_sensitized` int(11) NOT NULL DEFAULT '0', `female_sensitized` int(11) NOT NULL DEFAULT '0', `date_created` datetime DEFAULT NULL, `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `super_latitude` double DEFAULT '0', `super_longitude` double DEFAULT '0', `image_type` varchar(255) DEFAULT NULL, `super_image` varchar(2555) DEFAULT NULL, `ro_functional` tinyint(1) DEFAULT NULL, `monthly_rate` int(11) DEFAULT NULL, `UV_working` tinyint(1) DEFAULT NULL, `TDS_working` tinyint(1) DEFAULT NULL, `env_condition` tinyint(1) DEFAULT NULL, `Regular_IEC` tinyint(1) DEFAULT NULL, `Penetration` double DEFAULT NULL, `water_sample` tinyint(1) DEFAULT NULL, `Method` varchar(2555) DEFAULT NULL, `No_of_water_supplied` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_supervisor_SBMVisit_images` -- CREATE TABLE IF NOT EXISTS `zsk_supervisor_SBMVisit_images` ( `id` int(11) NOT NULL, `user_Id` varchar(255) DEFAULT NULL, `village_id` varchar(255) NOT NULL, `district_id` text, `male_sensitized` int(11) DEFAULT '0', `female_sensitized` int(11) DEFAULT '0', `date_created` datetime DEFAULT NULL, `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `super_latitude` double DEFAULT NULL, `super_longitude` double DEFAULT NULL, `image_type` varchar(255) DEFAULT NULL, `super_image` varchar(255) DEFAULT NULL, `MotivatorActice` tinyint(1) DEFAULT NULL, `nigrani` tinyint(1) DEFAULT NULL, `ODFDeclared` tinyint(1) DEFAULT NULL, `ODFSustained` tinyint(1) DEFAULT NULL, `latApproved` int(11) DEFAULT NULL, `latCompleted` int(11) DEFAULT NULL, `latProgress` int(11) DEFAULT NULL, `mason` int(11) DEFAULT NULL, `swachta_club` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_supervisor_sewer_images` -- CREATE TABLE IF NOT EXISTS `zsk_supervisor_sewer_images` ( `id` int(11) NOT NULL, `user_id` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `district_id` text, `male_sensitized` int(11) NOT NULL DEFAULT '0', `female_sensitized` int(11) NOT NULL DEFAULT '0', `date_created` datetime DEFAULT NULL, `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `super_latitude` double NOT NULL DEFAULT '0', `super_longitude` double NOT NULL DEFAULT '0', `image_type` varchar(255) NOT NULL, `super_image` varchar(2555) NOT NULL, `stp_functional` tinyint(1) DEFAULT NULL, `blockage_count` mediumint(9) DEFAULT NULL, `env_condition` varchar(255) DEFAULT NULL, `cham_cleaned` tinyint(1) DEFAULT NULL, `charges_paid` tinyint(1) DEFAULT NULL, `working_sewer` double DEFAULT NULL, `pending_bill` double DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_supervisor_Watervisit_images` -- CREATE TABLE IF NOT EXISTS `zsk_supervisor_Watervisit_images` ( `id` int(11) NOT NULL, `user_Id` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `district_id` text, `male_sensitized` varchar(255) NOT NULL DEFAULT '0', `female_sensitized` int(11) DEFAULT '0', `date_created` datetime DEFAULT NULL, `date_uploaded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `super_latitude` double NOT NULL DEFAULT '0', `super_longitude` double DEFAULT '0', `image_type` varchar(255) DEFAULT NULL, `super_image` varchar(2555) DEFAULT NULL, `supply_functional` tinyint(1) DEFAULT NULL, `house_getting_water` int(11) DEFAULT NULL, `Disinfection` tinyint(1) DEFAULT NULL, `panel_functional` tinyint(1) DEFAULT NULL, `water_supply` tinyint(1) DEFAULT NULL, `no_of_leaks` int(11) DEFAULT '0', `Pending_Electtricity` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_swachhta` -- CREATE TABLE IF NOT EXISTS `zsk_swachhta` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `division_id` varchar(255) DEFAULT NULL, `swachhta_activity` varchar(255) DEFAULT NULL, `swachhta_activity_count` int(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_swachh_sewa` -- CREATE TABLE IF NOT EXISTS `zsk_swachh_sewa` ( `id` mediumint(255) NOT NULL, `district_id` mediumint(255) DEFAULT NULL, `division_id` varchar(255) DEFAULT NULL, `swachhta_activity` varchar(255) DEFAULT NULL, `swachhta_activity_count` int(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_tariff_resolution` -- CREATE TABLE IF NOT EXISTS `zsk_tariff_resolution` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `resolution_received` varchar(255) DEFAULT NULL, `resolution_copy` varchar(255) DEFAULT NULL, `elec_bill` varchar(255) DEFAULT NULL, `elec_bill_200` int(255) DEFAULT NULL, `elec_bill_500` int(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_tele_caller_list` -- CREATE TABLE IF NOT EXISTS `zsk_tele_caller_list` ( `id` mediumint(255) NOT NULL, `tele_caller_name` varchar(255) NOT NULL, `district` varchar(255) DEFAULT NULL, `phone_no` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_template` -- CREATE TABLE IF NOT EXISTS `zsk_template` ( `id` int(255) NOT NULL, `subject` varchar(255) DEFAULT NULL, `RecipientType` varchar(255) DEFAULT NULL, `mobile` varchar(255) DEFAULT NULL, `multiplemobile` text, `message` text, `CreateDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_toilet_campaign` -- CREATE TABLE IF NOT EXISTS `zsk_toilet_campaign` ( `id` mediumint(255) NOT NULL, `zone_id` mediumint(255) DEFAULT NULL, `circle_id` mediumint(255) DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `block_id` varchar(255) DEFAULT NULL, `division_id` varchar(255) DEFAULT NULL, `campaigns` varchar(255) DEFAULT NULL, `other_text` varchar(255) DEFAULT NULL, `female_no_participant` int(255) DEFAULT NULL, `male_no_participant` int(255) DEFAULT NULL, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_tranche_cross_verification` -- CREATE TABLE IF NOT EXISTS `zsk_tranche_cross_verification` ( `id` mediumint(255) NOT NULL, `date_submission` date DEFAULT NULL, `district_id` mediumint(255) DEFAULT NULL, `district_name` varchar(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `constituency_name` varchar(255) DEFAULT NULL, `division_name` varchar(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL, `village_name` varchar(255) DEFAULT NULL, `mis_village_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `gram_sabha_meeting_date` date DEFAULT NULL, `no_ihhl_base_line` mediumint(255) DEFAULT NULL, `no_ihhl_cross_verification` mediumint(255) DEFAULT NULL, `increase_decrease_ihhl` varchar(255) DEFAULT NULL, `house_hold_name` varchar(255) DEFAULT NULL, `house_hold_name_yes` mediumint(255) DEFAULT NULL, `nodal_officer_name` varchar(255) DEFAULT NULL, `nodal_officer_designation` varchar(255) DEFAULT NULL, `nodal_officer_phno` varchar(255) DEFAULT NULL, `cross_verification_name` varchar(255) DEFAULT NULL, `cross_verification_designation` varchar(255) DEFAULT NULL, `cross_verification_phno` varchar(255) DEFAULT NULL, `cross_verification_done` varchar(255) DEFAULT NULL, `cross_verification_date` date DEFAULT NULL, `letter_number` varchar(255) DEFAULT NULL, `sample_verification_officer` varchar(255) DEFAULT NULL, `sample_verification_designation` varchar(255) DEFAULT NULL, `email_date` date DEFAULT NULL, `record_verification` varchar(255) DEFAULT NULL, `final_report_date` date DEFAULT NULL, `interim_report_date` date DEFAULT NULL, `latrine_number` int(255) DEFAULT NULL, `variation_cross_verification` int(255) DEFAULT NULL, `observation` text, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_triggering` -- CREATE TABLE IF NOT EXISTS `zsk_triggering` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `population_village` bigint(255) DEFAULT NULL, `no_of_triggering_required` bigint(255) DEFAULT NULL, `no_of_triggering_done_village` bigint(255) DEFAULT NULL, `no_of_school_village` bigint(255) DEFAULT NULL, `triggering_done_school` varchar(255) DEFAULT NULL, `no_of_angarwari` bigint(255) DEFAULT NULL, `trigerring_done_angarwari` varchar(255) DEFAULT NULL, `date_triggering` date DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_triggering_done_school` -- CREATE TABLE IF NOT EXISTS `zsk_triggering_done_school` ( `id` int(255) NOT NULL, `triggering_id` bigint(255) DEFAULT NULL, `trigger_school_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_triggering_done_village` -- CREATE TABLE IF NOT EXISTS `zsk_triggering_done_village` ( `id` int(255) NOT NULL, `triggering_id` bigint(255) DEFAULT NULL, `trigger_village_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_users` -- CREATE TABLE IF NOT EXISTS `zsk_users` ( `UserID` varchar(100) NOT NULL DEFAULT '', `UserName` varchar(250) NOT NULL DEFAULT '', `Email` varchar(200) NOT NULL, `Password` varchar(200) NOT NULL, `ProfilePhoto` varchar(255) DEFAULT NULL, `FirstName` varchar(50) NOT NULL DEFAULT '', `LastName` varchar(50) NOT NULL DEFAULT '', `DOB` date NOT NULL DEFAULT '0000-00-00', `Gender` varchar(10) DEFAULT NULL, `Goal` varchar(200) DEFAULT NULL, `Address1` varchar(250) NOT NULL DEFAULT '', `Address2` varchar(250) NOT NULL DEFAULT '', `Sector` varchar(255) NOT NULL, `City` varchar(100) DEFAULT NULL, `State` varchar(100) DEFAULT NULL, `Area` varchar(200) DEFAULT NULL, `Country` varchar(100) DEFAULT NULL, `ZipCode` varchar(100) DEFAULT NULL, `Phone` varchar(100) DEFAULT NULL, `Active` tinyint(4) NOT NULL DEFAULT '0', `newproduct_alert` tinyint(4) DEFAULT NULL, `ActivationCode` varchar(100) NOT NULL DEFAULT '', `ForgetCode` varchar(100) DEFAULT NULL, `ActiveOnce` tinyint(4) NOT NULL DEFAULT '0', `WholeSaler` tinyint(1) DEFAULT NULL, `VIPStatus` tinyint(1) DEFAULT NULL, `GvAmount` double DEFAULT NULL, `AccountCode` varchar(10) DEFAULT NULL, `CustomerContact` char(1) DEFAULT NULL, `PriceType` char(1) DEFAULT NULL, `PersonCode` char(3) DEFAULT NULL, `GroupCode` varchar(10) DEFAULT NULL, `MarketingCode` varchar(10) DEFAULT NULL, `PrevLastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `LastLogin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `FB_Username` varchar(255) DEFAULT NULL, `FB_Userid` varchar(255) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_users_newsletter` -- CREATE TABLE IF NOT EXISTS `zsk_users_newsletter` ( `UserID` varchar(100) NOT NULL DEFAULT '', `DisplayName` varchar(200) DEFAULT NULL, `Email` varchar(100) NOT NULL DEFAULT '', `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_user_registration` -- CREATE TABLE IF NOT EXISTS `zsk_user_registration` ( `id` mediumint(255) NOT NULL DEFAULT '0', `district` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `user_name` varchar(255) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_village_habitation` -- CREATE TABLE IF NOT EXISTS `zsk_village_habitation` ( `id` int(255) NOT NULL, `village_id` varchar(255) NOT NULL, `village_name` varchar(255) NOT NULL, `district_id` varchar(255) NOT NULL, `district_name` varchar(255) NOT NULL, `block_id` varchar(255) NOT NULL, `sbm_block_id` int(25) DEFAULT NULL, `block_name` varchar(255) DEFAULT NULL, `habitation_type` varchar(255) DEFAULT NULL, `parent_habitation_name` varchar(255) DEFAULT NULL, `households` int(255) DEFAULT NULL, `sbm_district_id` int(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_village_vise_expenditure` -- CREATE TABLE IF NOT EXISTS `zsk_village_vise_expenditure` ( `id` int(255) NOT NULL, `location_id` varchar(255) DEFAULT NULL, `scheme_id` varchar(255) DEFAULT NULL, `scheme_name` varchar(255) DEFAULT NULL, `village_id` varchar(255) DEFAULT NULL, `contract_amount` bigint(255) DEFAULT NULL, `expenditure` bigint(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_vlc_feedback` -- CREATE TABLE IF NOT EXISTS `zsk_vlc_feedback` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `name_training` varchar(255) DEFAULT NULL, `trainer_name` varchar(255) DEFAULT NULL, `place_training` varchar(255) DEFAULT NULL, `date_training` date DEFAULT NULL, `training_imp` varchar(255) DEFAULT NULL, `training_topic` varchar(255) DEFAULT NULL, `topic_knowledge` varchar(255) DEFAULT NULL, `trainers` varchar(255) DEFAULT NULL, `quality` varchar(255) DEFAULT NULL, `training_suggestions` varchar(255) DEFAULT NULL, `training_online` varchar(255) DEFAULT NULL, `suggestions` text, `other_suggestions` text, `prog_pic1` varchar(255) DEFAULT NULL, `prog_pic2` varchar(255) DEFAULT NULL, `prog_pic3` varchar(255) DEFAULT NULL, `prog_pic4` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_volunteer_registration` -- CREATE TABLE IF NOT EXISTS `zsk_volunteer_registration` ( `id` int(255) NOT NULL, `ProfilePhoto` varchar(255) DEFAULT NULL, `volunteer_name` varchar(255) DEFAULT NULL, `father_name` varchar(255) DEFAULT NULL, `Phone` varchar(100) DEFAULT NULL, `Email` varchar(200) NOT NULL, `Address` text, `City` varchar(100) DEFAULT NULL, `State` varchar(100) DEFAULT NULL, `ZipCode` varchar(100) DEFAULT NULL, `nationality` varchar(255) DEFAULT NULL, `Gender` varchar(10) DEFAULT NULL, `age` int(200) DEFAULT NULL, `preferred_district` varchar(100) DEFAULT NULL, `degree1` varchar(250) DEFAULT NULL, `college1` varchar(250) DEFAULT NULL, `year1` int(100) DEFAULT NULL, `degree2` varchar(250) DEFAULT NULL, `college2` varchar(250) DEFAULT NULL, `year2` int(100) DEFAULT NULL, `experience` text, `queries` text, `Consent_letter` varchar(250) DEFAULT NULL, `CreatedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_wall_writing` -- CREATE TABLE IF NOT EXISTS `zsk_wall_writing` ( `id` bigint(255) NOT NULL, `district_id` bigint(255) DEFAULT NULL, `constituency_id` bigint(255) DEFAULT NULL, `block_id` bigint(255) DEFAULT NULL, `division_id` bigint(255) DEFAULT NULL, `village_id` bigint(255) DEFAULT NULL, `water_image_upload` varchar(255) DEFAULT NULL, `type_wall` varchar(255) DEFAULT NULL, `image_upload` varchar(255) DEFAULT NULL, `sanitation_image_upload` varchar(2555) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `wall_specimen` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_wall_writings_type` -- CREATE TABLE IF NOT EXISTS `zsk_wall_writings_type` ( `id` int(255) NOT NULL, `name_wall_writing` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_water_quality_specialist` -- CREATE TABLE IF NOT EXISTS `zsk_water_quality_specialist` ( `id` int(255) NOT NULL DEFAULT '0', `zone_id` int(25) DEFAULT NULL, `zone` varchar(255) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `district_id` int(25) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `division_id` int(25) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `specialist_name` varchar(25) DEFAULT NULL, `category` varchar(25) DEFAULT NULL, `contact_no` varchar(25) DEFAULT NULL, `executive_name` varchar(255) DEFAULT NULL, `executive_contact_no` varchar(255) DEFAULT NULL, `joining_date` date DEFAULT NULL, `transfer_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_water_scheme_name` -- CREATE TABLE IF NOT EXISTS `zsk_water_scheme_name` ( `id` int(255) NOT NULL, `scheme_id` varchar(255) DEFAULT NULL, `scheme_name` varchar(255) DEFAULT NULL, `component` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_water_specialist` -- CREATE TABLE IF NOT EXISTS `zsk_water_specialist` ( `id` int(255) NOT NULL DEFAULT '0', `zone_id` int(25) DEFAULT NULL, `zone` varchar(255) DEFAULT NULL, `circle_id` int(25) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `district_id` int(25) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `division_id` int(25) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `specialist_name` varchar(25) DEFAULT NULL, `category` varchar(25) DEFAULT NULL, `contact_no` varchar(25) DEFAULT NULL, `executive_name` varchar(255) DEFAULT NULL, `executive_contact_no` varchar(255) DEFAULT NULL, `joining_date` date DEFAULT NULL, `transfer_date` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_water_supplyoperation` -- CREATE TABLE IF NOT EXISTS `zsk_water_supplyoperation` ( `id` mediumint(255) NOT NULL, `operation_name` varchar(25555) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_water_supply_2a` -- CREATE TABLE IF NOT EXISTS `zsk_water_supply_2a` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `scheme_name` varchar(255) DEFAULT NULL, `component` varchar(255) DEFAULT NULL, `repair_updation_system` varchar(255) DEFAULT NULL, `new_connection_existing` varchar(255) DEFAULT NULL, `additional_pipeline` varchar(255) DEFAULT NULL, `new_connection_additional` bigint(255) DEFAULT NULL, `water_supply_hours` bigint(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_water_supply_scheme_progress` -- CREATE TABLE IF NOT EXISTS `zsk_water_supply_scheme_progress` ( `id` int(255) NOT NULL, `district_id` int(255) DEFAULT NULL, `constituency_id` int(255) DEFAULT NULL, `block_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `location_id` varchar(255) DEFAULT NULL, `village_id` int(255) DEFAULT NULL, `scheme_name` varchar(255) DEFAULT NULL, `component` varchar(255) DEFAULT '1a', `tubewell` varchar(255) DEFAULT NULL, `tubewell_image` varchar(255) DEFAULT NULL, `pump_chamber` varchar(255) DEFAULT NULL, `pump_chamber_image` varchar(255) DEFAULT NULL, `machinery_installed` varchar(255) DEFAULT NULL, `ohsr_progress` varchar(255) DEFAULT NULL, `ohsr_progress_image` varchar(255) DEFAULT NULL, `distribution_system` varchar(255) DEFAULT NULL, `distribution_system_image` varchar(255) DEFAULT NULL, `new_connection` varchar(255) DEFAULT NULL, `scheme_commsioned` varchar(255) DEFAULT NULL, `scheme_completed` tinyint(4) DEFAULT NULL, `water_supply_hours` bigint(255) DEFAULT NULL, `commissioning_date` date DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL, `user_id` varchar(255) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_uploaded` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_water_supply_scheme_visit` -- CREATE TABLE IF NOT EXISTS `zsk_water_supply_scheme_visit` ( `id` int(11) NOT NULL, `supply_scheme` tinytext, `supply_percentage` float DEFAULT NULL, `disinfection_regular` tinytext, `cp_functional` tinytext, `ohsr` tinytext, `leakages` int(11) DEFAULT NULL, `pending_bills` float DEFAULT NULL, `village_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `water_images` text, `lat_water_images` double DEFAULT NULL, `lon_water_images` double DEFAULT NULL, `chlorinator_image` text, `lat_chlorinator_image` double DEFAULT NULL, `lon_chlorinator_image` double DEFAULT NULL, `villagers_interaction_image` text, `lat_villagers_interaction_image` double DEFAULT NULL, `lon_villagers_interaction_image` double DEFAULT NULL, `created_date` datetime DEFAULT NULL, `supervisor_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='this table is for app water supply scheme visit'; -- -------------------------------------------------------- -- -- Table structure for table `zsk_whos_online` -- CREATE TABLE IF NOT EXISTS `zsk_whos_online` ( `UserID` varchar(100) DEFAULT NULL, `UserName` varchar(250) DEFAULT NULL, `EmailAddress` varchar(200) DEFAULT NULL, `FullName` varchar(200) DEFAULT NULL, `EntryDate` datetime DEFAULT NULL, `LastClick` datetime DEFAULT NULL, `LastURL` text, `IPAddress` varchar(100) DEFAULT NULL, `SessionID` varchar(100) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_writ_petition_b_category` -- CREATE TABLE IF NOT EXISTS `zsk_writ_petition_b_category` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `date_of_receipt` date DEFAULT NULL, `cwp_title` varchar(255) DEFAULT NULL, `particulars_case` varchar(255) DEFAULT NULL, `date_upto_action_taken` date DEFAULT NULL, `date_on_action_taken` date DEFAULT NULL, `action_taken_stipluated_period` varchar(255) DEFAULT NULL, `present_status` varchar(255) DEFAULT NULL, `delay_occured` varchar(255) DEFAULT NULL, `compliance_decision` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_writ_petition_c_category` -- CREATE TABLE IF NOT EXISTS `zsk_writ_petition_c_category` ( `id` int(255) NOT NULL, `zone_id` int(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `date_of_receipt` date DEFAULT NULL, `cwp_title` varchar(255) DEFAULT NULL, `particulars_case` varchar(255) DEFAULT NULL, `date_next_hearing` date DEFAULT NULL, `reply_filed` varchar(255) DEFAULT NULL, `reply_filed_date` date DEFAULT NULL, `present_status` varchar(255) DEFAULT NULL, `delay_occured` varchar(255) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IPAddress` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_zone` -- CREATE TABLE IF NOT EXISTS `zsk_zone` ( `id` int(255) NOT NULL, `chief_engineer` varchar(255) DEFAULT NULL, `contact_no` varchar(255) DEFAULT NULL, `zone` varchar(2555) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `zsk_zone_circle_district_coordinator` -- CREATE TABLE IF NOT EXISTS `zsk_zone_circle_district_coordinator` ( `id` int(255) NOT NULL, `zone` varchar(255) DEFAULT NULL, `zone_id` int(255) DEFAULT NULL, `circle` varchar(255) DEFAULT NULL, `circle_id` int(255) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `district_id` int(255) DEFAULT NULL, `division` varchar(255) DEFAULT NULL, `division_id` int(255) DEFAULT NULL, `officer` varchar(255) DEFAULT NULL, `officer_name` varchar(255) DEFAULT NULL, `officer_contact` varchar(255) DEFAULT NULL, `environment` varchar(255) DEFAULT NULL, `env_name` varchar(255) DEFAULT NULL, `env_contact` varchar(255) DEFAULT NULL, `circle_iec` varchar(255) DEFAULT NULL, `circle_iec_name` varchar(255) DEFAULT NULL, `circle_iec_contact` varchar(255) DEFAULT NULL, `circle_iec_mobile_app_id` varchar(255) DEFAULT NULL, `water` varchar(255) DEFAULT NULL, `water_name` varchar(255) DEFAULT NULL, `water_contact` varchar(255) DEFAULT NULL, `water_mobile_app_id` varchar(255) DEFAULT NULL, `water_quality` varchar(255) DEFAULT NULL, `water_quality_name` varchar(255) DEFAULT NULL, `water_quality_contact` varchar(255) DEFAULT NULL, `sanitation` varchar(255) DEFAULT NULL, `sanitation_name` varchar(255) DEFAULT NULL, `sanitation_contact` varchar(255) DEFAULT NULL, `sanitation_mobile_app_id` varchar(255) DEFAULT NULL, `block_level` varchar(255) DEFAULT NULL, `block_level_name` varchar(255) DEFAULT NULL, `block_level_contact` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `authentications` -- ALTER TABLE `authentications` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `provider_uid` (`provider_uid`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_additional_validation` -- ALTER TABLE `zsk_additional_validation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_add_on` -- ALTER TABLE `zsk_add_on` ADD PRIMARY KEY (`AddOnID`); -- -- Indexes for table `zsk_app_odf_complaints` -- ALTER TABLE `zsk_app_odf_complaints` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_arbitration_case` -- ALTER TABLE `zsk_arbitration_case` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_audit_latrine_complete` -- ALTER TABLE `zsk_audit_latrine_complete` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_audit_offline` -- ALTER TABLE `zsk_audit_offline` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_audit_uc` -- ALTER TABLE `zsk_audit_uc` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_backup` -- ALTER TABLE `zsk_backup` ADD PRIMARY KEY (`BackUpID`); -- -- Indexes for table `zsk_banners` -- ALTER TABLE `zsk_banners` ADD PRIMARY KEY (`BannerID`); -- -- Indexes for table `zsk_beneficiary` -- ALTER TABLE `zsk_beneficiary` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_album` -- ALTER TABLE `zsk_beneficiary_album` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_amritsar` -- ALTER TABLE `zsk_beneficiary_amritsar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_barnala` -- ALTER TABLE `zsk_beneficiary_barnala` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_bathinda` -- ALTER TABLE `zsk_beneficiary_bathinda` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_category` -- ALTER TABLE `zsk_beneficiary_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_faridkot` -- ALTER TABLE `zsk_beneficiary_faridkot` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_fatehgarh` -- ALTER TABLE `zsk_beneficiary_fatehgarh` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_fazilka` -- ALTER TABLE `zsk_beneficiary_fazilka` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_firozpur` -- ALTER TABLE `zsk_beneficiary_firozpur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_gurdaspur` -- ALTER TABLE `zsk_beneficiary_gurdaspur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_hoshiarpur` -- ALTER TABLE `zsk_beneficiary_hoshiarpur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_images` -- ALTER TABLE `zsk_beneficiary_images` ADD PRIMARY KEY (`ImageID`); -- -- Indexes for table `zsk_beneficiary_images_bathinda` -- ALTER TABLE `zsk_beneficiary_images_bathinda` ADD PRIMARY KEY (`ImageID`); -- -- Indexes for table `zsk_beneficiary_images_firozpur` -- ALTER TABLE `zsk_beneficiary_images_firozpur` ADD PRIMARY KEY (`ImageID`); -- -- Indexes for table `zsk_beneficiary_images_gurdaspur` -- ALTER TABLE `zsk_beneficiary_images_gurdaspur` ADD PRIMARY KEY (`ImageID`); -- -- Indexes for table `zsk_beneficiary_images_hoshiarpur` -- ALTER TABLE `zsk_beneficiary_images_hoshiarpur` ADD PRIMARY KEY (`ImageID`); -- -- Indexes for table `zsk_beneficiary_images_pathankot` -- ALTER TABLE `zsk_beneficiary_images_pathankot` ADD PRIMARY KEY (`ImageID`); -- -- Indexes for table `zsk_beneficiary_jalandhar` -- ALTER TABLE `zsk_beneficiary_jalandhar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_kapurthala` -- ALTER TABLE `zsk_beneficiary_kapurthala` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_latrine_detail` -- ALTER TABLE `zsk_beneficiary_latrine_detail` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_ludhiana` -- ALTER TABLE `zsk_beneficiary_ludhiana` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_mansa` -- ALTER TABLE `zsk_beneficiary_mansa` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_moga` -- ALTER TABLE `zsk_beneficiary_moga` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_mohali` -- ALTER TABLE `zsk_beneficiary_mohali` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_muktsar` -- ALTER TABLE `zsk_beneficiary_muktsar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_pathankot` -- ALTER TABLE `zsk_beneficiary_pathankot` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_patiala` -- ALTER TABLE `zsk_beneficiary_patiala` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_picture_stages` -- ALTER TABLE `zsk_beneficiary_picture_stages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_ropar` -- ALTER TABLE `zsk_beneficiary_ropar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_sangrur` -- ALTER TABLE `zsk_beneficiary_sangrur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_sbsnagar` -- ALTER TABLE `zsk_beneficiary_sbsnagar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_taran` -- ALTER TABLE `zsk_beneficiary_taran` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_beneficiary_tele_calling` -- ALTER TABLE `zsk_beneficiary_tele_calling` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_blocks` -- ALTER TABLE `zsk_blocks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_block_division_relation` -- ALTER TABLE `zsk_block_division_relation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_ca` -- ALTER TABLE `zsk_ca` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_ce_latrine_complete` -- ALTER TABLE `zsk_ce_latrine_complete` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cholorination` -- ALTER TABLE `zsk_cholorination` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_circle` -- ALTER TABLE `zsk_circle` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_circle_latrine_complete` -- ALTER TABLE `zsk_circle_latrine_complete` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_circle_sample_duty` -- ALTER TABLE `zsk_circle_sample_duty` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_constituency_list` -- ALTER TABLE `zsk_constituency_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_contempt_petition_a_category` -- ALTER TABLE `zsk_contempt_petition_a_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_controllers` -- ALTER TABLE `zsk_controllers` ADD PRIMARY KEY (`ControllerID`); -- -- Indexes for table `zsk_counter` -- ALTER TABLE `zsk_counter` ADD PRIMARY KEY (`CounterID`); -- -- Indexes for table `zsk_countries` -- ALTER TABLE `zsk_countries` ADD PRIMARY KEY (`CountryID`), ADD KEY `IDX_COUNTRIES_NAME` (`CountryName`); -- -- Indexes for table `zsk_credit_card` -- ALTER TABLE `zsk_credit_card` ADD PRIMARY KEY (`CreditCardID`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_bathinda` -- ALTER TABLE `zsk_cron_beneficiary_payorder_bathinda` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_firozpur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_firozpur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_gurdaspur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_gurdaspur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_hoshiarpur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_hoshiarpur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_jalandhar` -- ALTER TABLE `zsk_cron_beneficiary_payorder_jalandhar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_kapurthala` -- ALTER TABLE `zsk_cron_beneficiary_payorder_kapurthala` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_pathankot` -- ALTER TABLE `zsk_cron_beneficiary_payorder_pathankot` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_patiala` -- ALTER TABLE `zsk_cron_beneficiary_payorder_patiala` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_report` -- ALTER TABLE `zsk_cron_beneficiary_payorder_report` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_ropar` -- ALTER TABLE `zsk_cron_beneficiary_payorder_ropar` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_beneficiary_payorder_sangrur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_sangrur` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_daily_sanitation_block` -- ALTER TABLE `zsk_cron_daily_sanitation_block` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_daily_sanitation_circle` -- ALTER TABLE `zsk_cron_daily_sanitation_circle` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_daily_sanitation_district` -- ALTER TABLE `zsk_cron_daily_sanitation_district` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_daily_sanitation_division` -- ALTER TABLE `zsk_cron_daily_sanitation_division` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_latrine_image_report` -- ALTER TABLE `zsk_cron_latrine_image_report` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_mobile_iec` -- ALTER TABLE `zsk_cron_mobile_iec` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_mobile_sanitation` -- ALTER TABLE `zsk_cron_mobile_sanitation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_mobile_water` -- ALTER TABLE `zsk_cron_mobile_water` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_nigrani_report` -- ALTER TABLE `zsk_cron_nigrani_report` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_sanitation_block` -- ALTER TABLE `zsk_cron_sanitation_block` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_sanitation_circle` -- ALTER TABLE `zsk_cron_sanitation_circle` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_sanitation_district` -- ALTER TABLE `zsk_cron_sanitation_district` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_sanitation_division` -- ALTER TABLE `zsk_cron_sanitation_division` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_village_beneficiary_count` -- ALTER TABLE `zsk_cron_village_beneficiary_count` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cron_weekly_nigrani` -- ALTER TABLE `zsk_cron_weekly_nigrani` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_cross_verification_list` -- ALTER TABLE `zsk_cross_verification_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_currencies` -- ALTER TABLE `zsk_currencies` ADD PRIMARY KEY (`CurrencyID`); -- -- Indexes for table `zsk_daily_latrine` -- ALTER TABLE `zsk_daily_latrine` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_daily_latrine_details` -- ALTER TABLE `zsk_daily_latrine_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_daily_water_supply_recovery` -- ALTER TABLE `zsk_daily_water_supply_recovery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_ddo_code` -- ALTER TABLE `zsk_ddo_code` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_district` -- ALTER TABLE `zsk_district` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_divisions_list` -- ALTER TABLE `zsk_divisions_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_docsan` -- ALTER TABLE `zsk_docsan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_docsan_images` -- ALTER TABLE `zsk_docsan_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_emails` -- ALTER TABLE `zsk_emails` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_envweek` -- ALTER TABLE `zsk_envweek` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_final_audit_gpwsc` -- ALTER TABLE `zsk_final_audit_gpwsc` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_final_audit_gpwsc_2c` -- ALTER TABLE `zsk_final_audit_gpwsc_2c` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_bank_account` -- ALTER TABLE `zsk_funds_bank_account` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_bank_account_details` -- ALTER TABLE `zsk_funds_bank_account_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_hod_details` -- ALTER TABLE `zsk_funds_hod_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_hod_details_backup` -- ALTER TABLE `zsk_funds_hod_details_backup` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_hod_details_ii` -- ALTER TABLE `zsk_funds_hod_details_ii` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_hod_dso` -- ALTER TABLE `zsk_funds_hod_dso` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_hod_dso_backup` -- ALTER TABLE `zsk_funds_hod_dso_backup` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_hod_dso_ii` -- ALTER TABLE `zsk_funds_hod_dso_ii` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_lapse_details` -- ALTER TABLE `zsk_funds_lapse_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_loc` -- ALTER TABLE `zsk_funds_loc` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_funds_loc_details` -- ALTER TABLE `zsk_funds_loc_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_girlchild` -- ALTER TABLE `zsk_girlchild` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_google_drive_links` -- ALTER TABLE `zsk_google_drive_links` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_gp_master` -- ALTER TABLE `zsk_gp_master` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_gp_punjab_list` -- ALTER TABLE `zsk_gp_punjab_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_gram_panchayat_list` -- ALTER TABLE `zsk_gram_panchayat_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_id_proof` -- ALTER TABLE `zsk_id_proof` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_image_type` -- ALTER TABLE `zsk_image_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_issue_entry` -- ALTER TABLE `zsk_issue_entry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_keywords` -- ALTER TABLE `zsk_keywords` ADD PRIMARY KEY (`KeywordID`); -- -- Indexes for table `zsk_language` -- ALTER TABLE `zsk_language` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_latrine_completed` -- ALTER TABLE `zsk_latrine_completed` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_latrine_construction_contract` -- ALTER TABLE `zsk_latrine_construction_contract` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_latrine_construction_csr` -- ALTER TABLE `zsk_latrine_construction_csr` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_latrine_construction_goi` -- ALTER TABLE `zsk_latrine_construction_goi` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_latrine_details_2014_2015` -- ALTER TABLE `zsk_latrine_details_2014_2015` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_latrine_details_2015_2016` -- ALTER TABLE `zsk_latrine_details_2015_2016` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_latrine_verification` -- ALTER TABLE `zsk_latrine_verification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_manufacturers` -- ALTER TABLE `zsk_manufacturers` ADD PRIMARY KEY (`MNID`); -- -- Indexes for table `zsk_mapping_migrant` -- ALTER TABLE `zsk_mapping_migrant` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_motivator` -- ALTER TABLE `zsk_master_motivator` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_motivator_villages` -- ALTER TABLE `zsk_master_motivator_villages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sanitation_assign` -- ALTER TABLE `zsk_master_sanitation_assign` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sanitation_assign_details` -- ALTER TABLE `zsk_master_sanitation_assign_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sanitation_mobile` -- ALTER TABLE `zsk_master_sanitation_mobile` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sanitation_paystage1` -- ALTER TABLE `zsk_master_sanitation_paystage1` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sanitation_paystage1_details` -- ALTER TABLE `zsk_master_sanitation_paystage1_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sanitation_register` -- ALTER TABLE `zsk_master_sanitation_register` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sanitation_travel` -- ALTER TABLE `zsk_master_sanitation_travel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_sewerage_scheme` -- ALTER TABLE `zsk_master_sewerage_scheme` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_water_assign` -- ALTER TABLE `zsk_master_water_assign` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_water_assign_details` -- ALTER TABLE `zsk_master_water_assign_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_master_water_register` -- ALTER TABLE `zsk_master_water_register` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_merged_validation` -- ALTER TABLE `zsk_merged_validation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_monthly_flag_env_a` -- ALTER TABLE `zsk_monthly_flag_env_a` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_monthly_flag_env_b` -- ALTER TABLE `zsk_monthly_flag_env_b` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_monthly_reports` -- ALTER TABLE `zsk_monthly_reports` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator` -- ALTER TABLE `zsk_motivator` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_images` -- ALTER TABLE `zsk_motivator_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_payorders_activity` -- ALTER TABLE `zsk_motivator_payorders_activity` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation` -- ALTER TABLE `zsk_motivator_sanitation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_assign` -- ALTER TABLE `zsk_motivator_sanitation_assign` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_details` -- ALTER TABLE `zsk_motivator_sanitation_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_mobile` -- ALTER TABLE `zsk_motivator_sanitation_mobile` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_payorders_activity` -- ALTER TABLE `zsk_motivator_sanitation_payorders_activity` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_paystage` -- ALTER TABLE `zsk_motivator_sanitation_paystage` ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `zsk_motivator_sanitation_paystage1` -- ALTER TABLE `zsk_motivator_sanitation_paystage1` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_paystage1_details` -- ALTER TABLE `zsk_motivator_sanitation_paystage1_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_register` -- ALTER TABLE `zsk_motivator_sanitation_register` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_sanitation_travel` -- ALTER TABLE `zsk_motivator_sanitation_travel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_triggering_report` -- ALTER TABLE `zsk_motivator_triggering_report` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_villages` -- ALTER TABLE `zsk_motivator_villages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water` -- ALTER TABLE `zsk_motivator_water` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_assign` -- ALTER TABLE `zsk_motivator_water_assign` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_details` -- ALTER TABLE `zsk_motivator_water_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_mobile` -- ALTER TABLE `zsk_motivator_water_mobile` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_paystage1` -- ALTER TABLE `zsk_motivator_water_paystage1` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_paystage1_details` -- ALTER TABLE `zsk_motivator_water_paystage1_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_paystage2` -- ALTER TABLE `zsk_motivator_water_paystage2` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_paystage3` -- ALTER TABLE `zsk_motivator_water_paystage3` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_paystage4` -- ALTER TABLE `zsk_motivator_water_paystage4` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_priority` -- ALTER TABLE `zsk_motivator_water_priority` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_priority_details` -- ALTER TABLE `zsk_motivator_water_priority_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_register` -- ALTER TABLE `zsk_motivator_water_register` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_motivator_water_travel` -- ALTER TABLE `zsk_motivator_water_travel` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_newsletters` -- ALTER TABLE `zsk_newsletters` ADD PRIMARY KEY (`NewsletterID`); -- -- Indexes for table `zsk_newspaper` -- ALTER TABLE `zsk_newspaper` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_nomination_entry` -- ALTER TABLE `zsk_nomination_entry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_odf_complaint` -- ALTER TABLE `zsk_odf_complaint` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_odf_entry` -- ALTER TABLE `zsk_odf_entry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_odf_target` -- ALTER TABLE `zsk_odf_target` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_odf_verification` -- ALTER TABLE `zsk_odf_verification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_other_files` -- ALTER TABLE `zsk_other_files` ADD PRIMARY KEY (`FileID`); -- -- Indexes for table `zsk_other_news` -- ALTER TABLE `zsk_other_news` ADD PRIMARY KEY (`NewsID`); -- -- Indexes for table `zsk_other_reports` -- ALTER TABLE `zsk_other_reports` ADD PRIMARY KEY (`ReportID`); -- -- Indexes for table `zsk_pacosan` -- ALTER TABLE `zsk_pacosan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_pacosan_images` -- ALTER TABLE `zsk_pacosan_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_pages` -- ALTER TABLE `zsk_pages` ADD PRIMARY KEY (`PageID`); -- -- Indexes for table `zsk_passed_bills` -- ALTER TABLE `zsk_passed_bills` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_passed_bills_programme_component` -- ALTER TABLE `zsk_passed_bills_programme_component` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_passed_bills_programme_name` -- ALTER TABLE `zsk_passed_bills_programme_name` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_plantation` -- ALTER TABLE `zsk_plantation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_revenue_collector` -- ALTER TABLE `zsk_revenue_collector` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_revenue_habitation` -- ALTER TABLE `zsk_revenue_habitation` ADD PRIMARY KEY (`id`), ADD KEY `village_id` (`village_name`); -- -- Indexes for table `zsk_revenue_villages` -- ALTER TABLE `zsk_revenue_villages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_revenue_village_habitation` -- ALTER TABLE `zsk_revenue_village_habitation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_rfp_form` -- ALTER TABLE `zsk_rfp_form` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_ro_scheme` -- ALTER TABLE `zsk_ro_scheme` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_rural_gp_list` -- ALTER TABLE `zsk_rural_gp_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sample_duty` -- ALTER TABLE `zsk_sample_duty` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sanitation_document` -- ALTER TABLE `zsk_sanitation_document` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sanitation_specialist` -- ALTER TABLE `zsk_sanitation_specialist` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `zsk_sankalp_essay` -- ALTER TABLE `zsk_sankalp_essay` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sankalp_video` -- ALTER TABLE `zsk_sankalp_video` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sbm_monitoring` -- ALTER TABLE `zsk_sbm_monitoring` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_seo` -- ALTER TABLE `zsk_seo` ADD PRIMARY KEY (`URLID`); -- -- Indexes for table `zsk_sewerage_issue` -- ALTER TABLE `zsk_sewerage_issue` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sewerage_scheme` -- ALTER TABLE `zsk_sewerage_scheme` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sird_payorder` -- ALTER TABLE `zsk_sird_payorder` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sird_sanitation` -- ALTER TABLE `zsk_sird_sanitation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_sms` -- ALTER TABLE `zsk_sms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_static_water_supply` -- ALTER TABLE `zsk_static_water_supply` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_subdivisions_list` -- ALTER TABLE `zsk_subdivisions_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_success_state_story` -- ALTER TABLE `zsk_success_state_story` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_success_story` -- ALTER TABLE `zsk_success_story` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_supervisor_images` -- ALTER TABLE `zsk_supervisor_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_supervisor_ROvisit_images` -- ALTER TABLE `zsk_supervisor_ROvisit_images` ADD PRIMARY KEY (`id`), ADD KEY `image_type` (`image_type`), ADD KEY `image_type_2` (`image_type`), ADD KEY `image_type_3` (`image_type`); -- -- Indexes for table `zsk_supervisor_SBMVisit_images` -- ALTER TABLE `zsk_supervisor_SBMVisit_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_supervisor_sewer_images` -- ALTER TABLE `zsk_supervisor_sewer_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_supervisor_Watervisit_images` -- ALTER TABLE `zsk_supervisor_Watervisit_images` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_swachhta` -- ALTER TABLE `zsk_swachhta` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_swachh_sewa` -- ALTER TABLE `zsk_swachh_sewa` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_tariff_resolution` -- ALTER TABLE `zsk_tariff_resolution` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_tele_caller_list` -- ALTER TABLE `zsk_tele_caller_list` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_template` -- ALTER TABLE `zsk_template` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_toilet_campaign` -- ALTER TABLE `zsk_toilet_campaign` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_tranche_cross_verification` -- ALTER TABLE `zsk_tranche_cross_verification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_triggering` -- ALTER TABLE `zsk_triggering` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_triggering_done_school` -- ALTER TABLE `zsk_triggering_done_school` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_triggering_done_village` -- ALTER TABLE `zsk_triggering_done_village` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_users` -- ALTER TABLE `zsk_users` ADD PRIMARY KEY (`UserID`); -- -- Indexes for table `zsk_user_registration` -- ALTER TABLE `zsk_user_registration` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `zsk_village_habitation` -- ALTER TABLE `zsk_village_habitation` ADD PRIMARY KEY (`id`), ADD KEY `village_id` (`village_id`); -- -- Indexes for table `zsk_village_vise_expenditure` -- ALTER TABLE `zsk_village_vise_expenditure` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_vlc_feedback` -- ALTER TABLE `zsk_vlc_feedback` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_volunteer_registration` -- ALTER TABLE `zsk_volunteer_registration` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_wall_writing` -- ALTER TABLE `zsk_wall_writing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_wall_writings_type` -- ALTER TABLE `zsk_wall_writings_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_water_quality_specialist` -- ALTER TABLE `zsk_water_quality_specialist` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `zsk_water_scheme_name` -- ALTER TABLE `zsk_water_scheme_name` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_water_specialist` -- ALTER TABLE `zsk_water_specialist` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`); -- -- Indexes for table `zsk_water_supplyoperation` -- ALTER TABLE `zsk_water_supplyoperation` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_water_supply_2a` -- ALTER TABLE `zsk_water_supply_2a` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_water_supply_scheme_progress` -- ALTER TABLE `zsk_water_supply_scheme_progress` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_water_supply_scheme_visit` -- ALTER TABLE `zsk_water_supply_scheme_visit` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_writ_petition_b_category` -- ALTER TABLE `zsk_writ_petition_b_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_writ_petition_c_category` -- ALTER TABLE `zsk_writ_petition_c_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_zone` -- ALTER TABLE `zsk_zone` ADD PRIMARY KEY (`id`); -- -- Indexes for table `zsk_zone_circle_district_coordinator` -- ALTER TABLE `zsk_zone_circle_district_coordinator` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `authentications` -- ALTER TABLE `authentications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_additional_validation` -- ALTER TABLE `zsk_additional_validation` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_add_on` -- ALTER TABLE `zsk_add_on` MODIFY `AddOnID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_app_odf_complaints` -- ALTER TABLE `zsk_app_odf_complaints` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_arbitration_case` -- ALTER TABLE `zsk_arbitration_case` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_audit_latrine_complete` -- ALTER TABLE `zsk_audit_latrine_complete` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_audit_offline` -- ALTER TABLE `zsk_audit_offline` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_audit_uc` -- ALTER TABLE `zsk_audit_uc` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_backup` -- ALTER TABLE `zsk_backup` MODIFY `BackUpID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_banners` -- ALTER TABLE `zsk_banners` MODIFY `BannerID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary` -- ALTER TABLE `zsk_beneficiary` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_album` -- ALTER TABLE `zsk_beneficiary_album` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_amritsar` -- ALTER TABLE `zsk_beneficiary_amritsar` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_barnala` -- ALTER TABLE `zsk_beneficiary_barnala` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_bathinda` -- ALTER TABLE `zsk_beneficiary_bathinda` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_category` -- ALTER TABLE `zsk_beneficiary_category` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_faridkot` -- ALTER TABLE `zsk_beneficiary_faridkot` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_fatehgarh` -- ALTER TABLE `zsk_beneficiary_fatehgarh` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_fazilka` -- ALTER TABLE `zsk_beneficiary_fazilka` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_firozpur` -- ALTER TABLE `zsk_beneficiary_firozpur` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_gurdaspur` -- ALTER TABLE `zsk_beneficiary_gurdaspur` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_hoshiarpur` -- ALTER TABLE `zsk_beneficiary_hoshiarpur` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_images` -- ALTER TABLE `zsk_beneficiary_images` MODIFY `ImageID` bigint(200) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_images_bathinda` -- ALTER TABLE `zsk_beneficiary_images_bathinda` MODIFY `ImageID` bigint(200) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_images_firozpur` -- ALTER TABLE `zsk_beneficiary_images_firozpur` MODIFY `ImageID` bigint(200) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_images_gurdaspur` -- ALTER TABLE `zsk_beneficiary_images_gurdaspur` MODIFY `ImageID` bigint(200) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_images_hoshiarpur` -- ALTER TABLE `zsk_beneficiary_images_hoshiarpur` MODIFY `ImageID` bigint(200) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_images_pathankot` -- ALTER TABLE `zsk_beneficiary_images_pathankot` MODIFY `ImageID` bigint(200) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_jalandhar` -- ALTER TABLE `zsk_beneficiary_jalandhar` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_kapurthala` -- ALTER TABLE `zsk_beneficiary_kapurthala` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_latrine_detail` -- ALTER TABLE `zsk_beneficiary_latrine_detail` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_ludhiana` -- ALTER TABLE `zsk_beneficiary_ludhiana` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_mansa` -- ALTER TABLE `zsk_beneficiary_mansa` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_moga` -- ALTER TABLE `zsk_beneficiary_moga` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_mohali` -- ALTER TABLE `zsk_beneficiary_mohali` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_muktsar` -- ALTER TABLE `zsk_beneficiary_muktsar` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_pathankot` -- ALTER TABLE `zsk_beneficiary_pathankot` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_patiala` -- ALTER TABLE `zsk_beneficiary_patiala` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_picture_stages` -- ALTER TABLE `zsk_beneficiary_picture_stages` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_ropar` -- ALTER TABLE `zsk_beneficiary_ropar` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_sangrur` -- ALTER TABLE `zsk_beneficiary_sangrur` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_sbsnagar` -- ALTER TABLE `zsk_beneficiary_sbsnagar` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_taran` -- ALTER TABLE `zsk_beneficiary_taran` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_beneficiary_tele_calling` -- ALTER TABLE `zsk_beneficiary_tele_calling` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_blocks` -- ALTER TABLE `zsk_blocks` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_block_division_relation` -- ALTER TABLE `zsk_block_division_relation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_ca` -- ALTER TABLE `zsk_ca` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_ce_latrine_complete` -- ALTER TABLE `zsk_ce_latrine_complete` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cholorination` -- ALTER TABLE `zsk_cholorination` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_circle` -- ALTER TABLE `zsk_circle` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_circle_latrine_complete` -- ALTER TABLE `zsk_circle_latrine_complete` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_circle_sample_duty` -- ALTER TABLE `zsk_circle_sample_duty` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_constituency_list` -- ALTER TABLE `zsk_constituency_list` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_contempt_petition_a_category` -- ALTER TABLE `zsk_contempt_petition_a_category` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_controllers` -- ALTER TABLE `zsk_controllers` MODIFY `ControllerID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_counter` -- ALTER TABLE `zsk_counter` MODIFY `CounterID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_countries` -- ALTER TABLE `zsk_countries` MODIFY `CountryID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_credit_card` -- ALTER TABLE `zsk_credit_card` MODIFY `CreditCardID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_bathinda` -- ALTER TABLE `zsk_cron_beneficiary_payorder_bathinda` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_firozpur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_firozpur` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_gurdaspur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_gurdaspur` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_hoshiarpur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_hoshiarpur` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_jalandhar` -- ALTER TABLE `zsk_cron_beneficiary_payorder_jalandhar` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_kapurthala` -- ALTER TABLE `zsk_cron_beneficiary_payorder_kapurthala` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_pathankot` -- ALTER TABLE `zsk_cron_beneficiary_payorder_pathankot` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_patiala` -- ALTER TABLE `zsk_cron_beneficiary_payorder_patiala` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_report` -- ALTER TABLE `zsk_cron_beneficiary_payorder_report` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_ropar` -- ALTER TABLE `zsk_cron_beneficiary_payorder_ropar` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_beneficiary_payorder_sangrur` -- ALTER TABLE `zsk_cron_beneficiary_payorder_sangrur` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_daily_sanitation_block` -- ALTER TABLE `zsk_cron_daily_sanitation_block` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_daily_sanitation_circle` -- ALTER TABLE `zsk_cron_daily_sanitation_circle` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_daily_sanitation_district` -- ALTER TABLE `zsk_cron_daily_sanitation_district` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_daily_sanitation_division` -- ALTER TABLE `zsk_cron_daily_sanitation_division` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_latrine_image_report` -- ALTER TABLE `zsk_cron_latrine_image_report` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_mobile_iec` -- ALTER TABLE `zsk_cron_mobile_iec` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_mobile_sanitation` -- ALTER TABLE `zsk_cron_mobile_sanitation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_mobile_water` -- ALTER TABLE `zsk_cron_mobile_water` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_nigrani_report` -- ALTER TABLE `zsk_cron_nigrani_report` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_sanitation_block` -- ALTER TABLE `zsk_cron_sanitation_block` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_sanitation_circle` -- ALTER TABLE `zsk_cron_sanitation_circle` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_sanitation_district` -- ALTER TABLE `zsk_cron_sanitation_district` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_sanitation_division` -- ALTER TABLE `zsk_cron_sanitation_division` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_village_beneficiary_count` -- ALTER TABLE `zsk_cron_village_beneficiary_count` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cron_weekly_nigrani` -- ALTER TABLE `zsk_cron_weekly_nigrani` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_cross_verification_list` -- ALTER TABLE `zsk_cross_verification_list` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_currencies` -- ALTER TABLE `zsk_currencies` MODIFY `CurrencyID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_daily_latrine` -- ALTER TABLE `zsk_daily_latrine` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_daily_latrine_details` -- ALTER TABLE `zsk_daily_latrine_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_daily_water_supply_recovery` -- ALTER TABLE `zsk_daily_water_supply_recovery` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_ddo_code` -- ALTER TABLE `zsk_ddo_code` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_district` -- ALTER TABLE `zsk_district` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_divisions_list` -- ALTER TABLE `zsk_divisions_list` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_docsan` -- ALTER TABLE `zsk_docsan` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_docsan_images` -- ALTER TABLE `zsk_docsan_images` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_emails` -- ALTER TABLE `zsk_emails` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_envweek` -- ALTER TABLE `zsk_envweek` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_final_audit_gpwsc` -- ALTER TABLE `zsk_final_audit_gpwsc` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_final_audit_gpwsc_2c` -- ALTER TABLE `zsk_final_audit_gpwsc_2c` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_bank_account` -- ALTER TABLE `zsk_funds_bank_account` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_bank_account_details` -- ALTER TABLE `zsk_funds_bank_account_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_hod_details` -- ALTER TABLE `zsk_funds_hod_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_hod_details_backup` -- ALTER TABLE `zsk_funds_hod_details_backup` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_hod_details_ii` -- ALTER TABLE `zsk_funds_hod_details_ii` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_hod_dso` -- ALTER TABLE `zsk_funds_hod_dso` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_hod_dso_backup` -- ALTER TABLE `zsk_funds_hod_dso_backup` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_hod_dso_ii` -- ALTER TABLE `zsk_funds_hod_dso_ii` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_lapse_details` -- ALTER TABLE `zsk_funds_lapse_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_loc` -- ALTER TABLE `zsk_funds_loc` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_funds_loc_details` -- ALTER TABLE `zsk_funds_loc_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_girlchild` -- ALTER TABLE `zsk_girlchild` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_google_drive_links` -- ALTER TABLE `zsk_google_drive_links` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_gp_master` -- ALTER TABLE `zsk_gp_master` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_gp_punjab_list` -- ALTER TABLE `zsk_gp_punjab_list` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_gram_panchayat_list` -- ALTER TABLE `zsk_gram_panchayat_list` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_id_proof` -- ALTER TABLE `zsk_id_proof` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_image_type` -- ALTER TABLE `zsk_image_type` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_issue_entry` -- ALTER TABLE `zsk_issue_entry` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_keywords` -- ALTER TABLE `zsk_keywords` MODIFY `KeywordID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_language` -- ALTER TABLE `zsk_language` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_latrine_completed` -- ALTER TABLE `zsk_latrine_completed` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_latrine_construction_contract` -- ALTER TABLE `zsk_latrine_construction_contract` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_latrine_construction_csr` -- ALTER TABLE `zsk_latrine_construction_csr` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_latrine_construction_goi` -- ALTER TABLE `zsk_latrine_construction_goi` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_latrine_details_2014_2015` -- ALTER TABLE `zsk_latrine_details_2014_2015` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_latrine_details_2015_2016` -- ALTER TABLE `zsk_latrine_details_2015_2016` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_latrine_verification` -- ALTER TABLE `zsk_latrine_verification` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_manufacturers` -- ALTER TABLE `zsk_manufacturers` MODIFY `MNID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_mapping_migrant` -- ALTER TABLE `zsk_mapping_migrant` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_motivator` -- ALTER TABLE `zsk_master_motivator` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_motivator_villages` -- ALTER TABLE `zsk_master_motivator_villages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sanitation_assign` -- ALTER TABLE `zsk_master_sanitation_assign` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sanitation_assign_details` -- ALTER TABLE `zsk_master_sanitation_assign_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sanitation_mobile` -- ALTER TABLE `zsk_master_sanitation_mobile` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sanitation_paystage1` -- ALTER TABLE `zsk_master_sanitation_paystage1` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sanitation_paystage1_details` -- ALTER TABLE `zsk_master_sanitation_paystage1_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sanitation_register` -- ALTER TABLE `zsk_master_sanitation_register` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sanitation_travel` -- ALTER TABLE `zsk_master_sanitation_travel` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_sewerage_scheme` -- ALTER TABLE `zsk_master_sewerage_scheme` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_water_assign` -- ALTER TABLE `zsk_master_water_assign` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_water_assign_details` -- ALTER TABLE `zsk_master_water_assign_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_master_water_register` -- ALTER TABLE `zsk_master_water_register` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_merged_validation` -- ALTER TABLE `zsk_merged_validation` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_monthly_flag_env_a` -- ALTER TABLE `zsk_monthly_flag_env_a` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_monthly_flag_env_b` -- ALTER TABLE `zsk_monthly_flag_env_b` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_monthly_reports` -- ALTER TABLE `zsk_monthly_reports` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator` -- ALTER TABLE `zsk_motivator` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_images` -- ALTER TABLE `zsk_motivator_images` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_payorders_activity` -- ALTER TABLE `zsk_motivator_payorders_activity` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation` -- ALTER TABLE `zsk_motivator_sanitation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_assign` -- ALTER TABLE `zsk_motivator_sanitation_assign` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_details` -- ALTER TABLE `zsk_motivator_sanitation_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_mobile` -- ALTER TABLE `zsk_motivator_sanitation_mobile` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_payorders_activity` -- ALTER TABLE `zsk_motivator_sanitation_payorders_activity` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_paystage` -- ALTER TABLE `zsk_motivator_sanitation_paystage` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_paystage1` -- ALTER TABLE `zsk_motivator_sanitation_paystage1` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_paystage1_details` -- ALTER TABLE `zsk_motivator_sanitation_paystage1_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_register` -- ALTER TABLE `zsk_motivator_sanitation_register` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_sanitation_travel` -- ALTER TABLE `zsk_motivator_sanitation_travel` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_triggering_report` -- ALTER TABLE `zsk_motivator_triggering_report` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_villages` -- ALTER TABLE `zsk_motivator_villages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water` -- ALTER TABLE `zsk_motivator_water` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_assign` -- ALTER TABLE `zsk_motivator_water_assign` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_details` -- ALTER TABLE `zsk_motivator_water_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_mobile` -- ALTER TABLE `zsk_motivator_water_mobile` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_paystage1` -- ALTER TABLE `zsk_motivator_water_paystage1` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_paystage1_details` -- ALTER TABLE `zsk_motivator_water_paystage1_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_paystage2` -- ALTER TABLE `zsk_motivator_water_paystage2` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_paystage3` -- ALTER TABLE `zsk_motivator_water_paystage3` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_paystage4` -- ALTER TABLE `zsk_motivator_water_paystage4` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_priority` -- ALTER TABLE `zsk_motivator_water_priority` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_priority_details` -- ALTER TABLE `zsk_motivator_water_priority_details` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_register` -- ALTER TABLE `zsk_motivator_water_register` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_motivator_water_travel` -- ALTER TABLE `zsk_motivator_water_travel` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_newsletters` -- ALTER TABLE `zsk_newsletters` MODIFY `NewsletterID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_newspaper` -- ALTER TABLE `zsk_newspaper` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_nomination_entry` -- ALTER TABLE `zsk_nomination_entry` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_odf_complaint` -- ALTER TABLE `zsk_odf_complaint` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_odf_entry` -- ALTER TABLE `zsk_odf_entry` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_odf_target` -- ALTER TABLE `zsk_odf_target` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_odf_verification` -- ALTER TABLE `zsk_odf_verification` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_other_files` -- ALTER TABLE `zsk_other_files` MODIFY `FileID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_other_news` -- ALTER TABLE `zsk_other_news` MODIFY `NewsID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_other_reports` -- ALTER TABLE `zsk_other_reports` MODIFY `ReportID` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_pacosan` -- ALTER TABLE `zsk_pacosan` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_pacosan_images` -- ALTER TABLE `zsk_pacosan_images` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_pages` -- ALTER TABLE `zsk_pages` MODIFY `PageID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_passed_bills` -- ALTER TABLE `zsk_passed_bills` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_passed_bills_programme_component` -- ALTER TABLE `zsk_passed_bills_programme_component` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_passed_bills_programme_name` -- ALTER TABLE `zsk_passed_bills_programme_name` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_plantation` -- ALTER TABLE `zsk_plantation` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_revenue_collector` -- ALTER TABLE `zsk_revenue_collector` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_revenue_habitation` -- ALTER TABLE `zsk_revenue_habitation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_revenue_villages` -- ALTER TABLE `zsk_revenue_villages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_revenue_village_habitation` -- ALTER TABLE `zsk_revenue_village_habitation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_rfp_form` -- ALTER TABLE `zsk_rfp_form` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_ro_scheme` -- ALTER TABLE `zsk_ro_scheme` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_rural_gp_list` -- ALTER TABLE `zsk_rural_gp_list` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sample_duty` -- ALTER TABLE `zsk_sample_duty` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sanitation_document` -- ALTER TABLE `zsk_sanitation_document` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sankalp_essay` -- ALTER TABLE `zsk_sankalp_essay` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sankalp_video` -- ALTER TABLE `zsk_sankalp_video` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sbm_monitoring` -- ALTER TABLE `zsk_sbm_monitoring` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_seo` -- ALTER TABLE `zsk_seo` MODIFY `URLID` bigint(20) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sewerage_issue` -- ALTER TABLE `zsk_sewerage_issue` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sewerage_scheme` -- ALTER TABLE `zsk_sewerage_scheme` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sird_payorder` -- ALTER TABLE `zsk_sird_payorder` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sird_sanitation` -- ALTER TABLE `zsk_sird_sanitation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_sms` -- ALTER TABLE `zsk_sms` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_static_water_supply` -- ALTER TABLE `zsk_static_water_supply` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_subdivisions_list` -- ALTER TABLE `zsk_subdivisions_list` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_success_state_story` -- ALTER TABLE `zsk_success_state_story` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_success_story` -- ALTER TABLE `zsk_success_story` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_supervisor_images` -- ALTER TABLE `zsk_supervisor_images` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_supervisor_ROvisit_images` -- ALTER TABLE `zsk_supervisor_ROvisit_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_supervisor_SBMVisit_images` -- ALTER TABLE `zsk_supervisor_SBMVisit_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_supervisor_sewer_images` -- ALTER TABLE `zsk_supervisor_sewer_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_supervisor_Watervisit_images` -- ALTER TABLE `zsk_supervisor_Watervisit_images` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_swachhta` -- ALTER TABLE `zsk_swachhta` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_swachh_sewa` -- ALTER TABLE `zsk_swachh_sewa` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_tariff_resolution` -- ALTER TABLE `zsk_tariff_resolution` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_tele_caller_list` -- ALTER TABLE `zsk_tele_caller_list` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_template` -- ALTER TABLE `zsk_template` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_toilet_campaign` -- ALTER TABLE `zsk_toilet_campaign` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_tranche_cross_verification` -- ALTER TABLE `zsk_tranche_cross_verification` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_triggering` -- ALTER TABLE `zsk_triggering` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_triggering_done_school` -- ALTER TABLE `zsk_triggering_done_school` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_triggering_done_village` -- ALTER TABLE `zsk_triggering_done_village` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_village_habitation` -- ALTER TABLE `zsk_village_habitation` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_village_vise_expenditure` -- ALTER TABLE `zsk_village_vise_expenditure` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_vlc_feedback` -- ALTER TABLE `zsk_vlc_feedback` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_volunteer_registration` -- ALTER TABLE `zsk_volunteer_registration` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_wall_writing` -- ALTER TABLE `zsk_wall_writing` MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_wall_writings_type` -- ALTER TABLE `zsk_wall_writings_type` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_water_scheme_name` -- ALTER TABLE `zsk_water_scheme_name` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_water_supplyoperation` -- ALTER TABLE `zsk_water_supplyoperation` MODIFY `id` mediumint(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_water_supply_2a` -- ALTER TABLE `zsk_water_supply_2a` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_water_supply_scheme_progress` -- ALTER TABLE `zsk_water_supply_scheme_progress` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_water_supply_scheme_visit` -- ALTER TABLE `zsk_water_supply_scheme_visit` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_writ_petition_b_category` -- ALTER TABLE `zsk_writ_petition_b_category` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_writ_petition_c_category` -- ALTER TABLE `zsk_writ_petition_c_category` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_zone` -- ALTER TABLE `zsk_zone` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `zsk_zone_circle_district_coordinator` -- ALTER TABLE `zsk_zone_circle_district_coordinator` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT; /*!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 */;