Geo Tv data LeAKED

| | | | || || ___|| \ | | || ||_ _ | \ | | | | | | || |\ \/ / _ \|  _ \
| |_| | || ||___ \|  \| | || |_| | |  \| | | |_| | || |_\  / | | | |_) |
|  _  |__   _|__) | |\  |__   _| | | |\  | |  _  |__   _/  \ |_| |  _ <
|_| |_|  |_||____/|_| \_|  |_||___ |_| \_| |_| |_|  |_|/_/\_\___/|_| \_\

 ____  _   _  ____
|  _ \| | | |/ ___|
| |_) | |_| | |
|  __/|  _  | |___
|_|   |_| |_|\____|




Target :http://election2013.geo.tv/

Valun Found : Unknown


login email:admin@admin.com

pass:admin

Mysql Complete Data :
/*

SQLyog Ultimate v8.55
MySQL - 5.5.8-log : Database - election2013

*********************************************************************

*/



/*!40101 SET NAMES utf8 */;



/*!40101 SET SQL_MODE=''*/;



/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

#CREATE DATABASE /*!32312 IF NOT EXISTS*/`election2013` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;



USE `geoboxer_elect2013`;



/*Table structure for table `pak_accounts_type` */



DROP TABLE IF EXISTS `pak_accounts_type`;



CREATE TABLE `pak_accounts_type` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `ACCOUNTS_NAME` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_accounts_type` */



/*Table structure for table `pak_admins` */



DROP TABLE IF EXISTS `pak_admins`;



CREATE TABLE `pak_admins` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `USER_ID` varchar(255) DEFAULT '',
  `PASSWORD` varchar(255) DEFAULT '',
  `USER_TYPE` tinyint(3) unsigned DEFAULT '2',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_admins` */



/*Table structure for table `pak_assets_conclusion` */



DROP TABLE IF EXISTS `pak_assets_conclusion`;



CREATE TABLE `pak_assets_conclusion` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` int(10) DEFAULT NULL,
  `CURRENT_ASSETS` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `PREVIOUS_ASSETS` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `TOTAL_ASSETS` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `TOTAL_EXPEND` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `EXPEND_INC_DEC` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



/*Data for the table `pak_assets_conclusion` */



insert  into `pak_assets_conclusion`(`ID`,`CANDIDATE_ID`,`CURRENT_ASSETS`,`PREVIOUS_ASSETS`,`TOTAL_ASSETS`,`TOTAL_EXPEND`,`EXPEND_INC_DEC`) values (1,1,'10000','10000','200000','1500','200'),(2,2,'10000','10000','10000','10000','10000'),(3,3,'10000','10000','10000','10000','10000'),(4,4,'10000','10000','10000','10000','10000'),(5,5,'10000','10000','10000','10000','10000'),(6,6,'10000','10000','10000','10000','10000'),(7,7,'10000','10000','10000','10000','10000'),(8,8,'10000','10000','10000','10000','10000'),(9,9,'10000','10000','10000','10000','10000');



/*Table structure for table `pak_assets_created` */



DROP TABLE IF EXISTS `pak_assets_created`;



CREATE TABLE `pak_assets_created` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `DETAIL` text,
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_assets_created` */



/*Table structure for table `pak_assets_outside` */



DROP TABLE IF EXISTS `pak_assets_outside`;



CREATE TABLE `pak_assets_outside` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `NAME_OF_BUSINESS` text,
  `CAPITAL_AMOUNT` varchar(20) DEFAULT '',
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `CAP_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_assets_outside` */



/*Table structure for table `pak_assets_pakistan` */



DROP TABLE IF EXISTS `pak_assets_pakistan`;



CREATE TABLE `pak_assets_pakistan` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `NAME_OF_BUSINESS` text,
  `CAPITAL_AMOUNT` varchar(20) DEFAULT '',
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `CAP_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_assets_pakistan` */



/*Table structure for table `pak_assets_remitted` */



DROP TABLE IF EXISTS `pak_assets_remitted`;



CREATE TABLE `pak_assets_remitted` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `ASSETS_TYPE` tinyint(3) unsigned DEFAULT '0',
  `COST` varchar(50) DEFAULT '0',
  `PRESENT_VALUE` varchar(50) DEFAULT '0',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_assets_remitted` */



/*Table structure for table `pak_assets_transferred` */



DROP TABLE IF EXISTS `pak_assets_transferred`;



CREATE TABLE `pak_assets_transferred` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `TRANSFERRED_TYPE` tinyint(3) unsigned DEFAULT '0',
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_assets_transferred` */



/*Table structure for table `pak_assets_type` */



DROP TABLE IF EXISTS `pak_assets_type`;



CREATE TABLE `pak_assets_type` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `ASSETS_NAME` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;



/*Data for the table `pak_assets_type` */



insert  into `pak_assets_type`(`ID`,`ASSETS_NAME`,`STATUS`) values (1,'Animals',1),(2,'Birds',1),(3,'Farm House',1),(4,'Guns',1),(5,'Stones',1);



/*Table structure for table `pak_bank_detail` */



DROP TABLE IF EXISTS `pak_bank_detail`;



CREATE TABLE `pak_bank_detail` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `ACCOUNT_NUMBER` varchar(20) DEFAULT '0',
  `BANK_NAME` varchar(255) DEFAULT '',
  `BRANCH_NAME` varchar(255) DEFAULT '',
  `ACCOUNT_TYPE` tinyint(3) unsigned DEFAULT '0',
  `COST` varchar(20) DEFAULT '0',
  `PRESENT_VALUE` varchar(20) DEFAULT '0',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_bank_detail` */



/*Table structure for table `pak_cadidate_spouse` */



DROP TABLE IF EXISTS `pak_cadidate_spouse`;



CREATE TABLE `pak_cadidate_spouse` (
  `ID` decimal(18,0) NOT NULL DEFAULT '0',
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `SPOUSE_NAME` text,
  `RELATION` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_cadidate_spouse` */



/*Table structure for table `pak_candidate` */



DROP TABLE IF EXISTS `pak_candidate`;



CREATE TABLE `pak_candidate` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_NAME` varchar(255) DEFAULT '',
  `FATHER_NAME` varchar(255) DEFAULT '',
  `PROVINCE` tinyint(3) unsigned DEFAULT '0',
  `PARTY` tinyint(3) unsigned DEFAULT '0',
  `DATE` datetime DEFAULT NULL,
  `STATUS` tinyint(1) DEFAULT '1',
  `ADDRESS` text,
  `RELATION` text,
  `ACCOUNT_NUMBER` varchar(50) DEFAULT '',
  `BRANCH` text,
  `TOTAL_AMOUNT` varchar(50) DEFAULT '',
  `EDUCATION` text,
  `OCCUPATION` text,
  `NIC` varchar(50) DEFAULT '',
  `NTN` varchar(50) DEFAULT '',
  `NUMBER_OF_CASES` varchar(255) DEFAULT '',
  `COURT_NAMES` longtext,
  `TRAVELED_DETAILS` longtext,
  `IMPORTANT_CONTRIBUTION` longtext,
  `PAID_AMOUNT_TO_PARTY` longtext,
  `RECEIVED_AMOUNT_BY_PARTY` longtext,
  `SPOUSE_DETAILS` longtext,
  `SPOUSE_COMPANY_DETAILS` longtext,
  `SPOUSE_ASSETS` longtext,
  `OPERATOR_ID` decimal(18,0) DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;



/*Data for the table `pak_candidate` */



insert  into `pak_candidate`(`ID`,`CANDIDATE_NAME`,`FATHER_NAME`,`PROVINCE`,`PARTY`,`DATE`,`STATUS`,`ADDRESS`,`RELATION`,`ACCOUNT_NUMBER`,`BRANCH`,`TOTAL_AMOUNT`,`EDUCATION`,`OCCUPATION`,`NIC`,`NTN`,`NUMBER_OF_CASES`,`COURT_NAMES`,`TRAVELED_DETAILS`,`IMPORTANT_CONTRIBUTION`,`PAID_AMOUNT_TO_PARTY`,`RECEIVED_AMOUNT_BY_PARTY`,`SPOUSE_DETAILS`,`SPOUSE_COMPANY_DETAILS`,`SPOUSE_ASSETS`,`OPERATOR_ID`) values (1,'Abdul Shakoor','xyz',1,1,NULL,1,'a123','testing','12345','al-rehman','1000000','BS','Engineer','123465789123','13456789','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(2,'Nabil Gabol','abc',2,1,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(3,'Khush Bakht Shujat','dsdsagsd',3,1,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(4,'Chudary Shujat','abc',4,1,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(5,'Mustansur Hussain Tararr','abc',3,1,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(6,'Waseem Akhtar','abc',2,1,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(7,'Faryal Talpur','abc',4,6,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(8,'Hamza Shareef','abc',3,7,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(9,'xyz','abc',2,6,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(10,'xyz','abc',4,5,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(11,'xyz','abc',3,4,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(12,'xyz','abc',2,3,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(13,'xyz','abc',1,2,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(14,'xyz','abc',1,1,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(15,'xyz','abc',4,2,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(16,'xyz','abc',3,3,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(17,'xyz','abc',2,4,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(18,'xyz','abc',1,5,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(19,'xyz','abc',4,6,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(20,'xyz','abc',3,7,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(21,'xyz','abc',1,6,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(22,'xyz','abc',2,5,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0'),(23,'xyz','abc',1,4,NULL,1,NULL,NULL,'',NULL,'',NULL,NULL,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0');



/*Table structure for table `pak_candidate_agricultural_tax` */



DROP TABLE IF EXISTS `pak_candidate_agricultural_tax`;



CREATE TABLE `pak_candidate_agricultural_tax` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `TAX_YEAR` varchar(10) DEFAULT '',
  `LAND_HOLDING` longtext,
  `AGRICULTURAL_INCOME` varchar(50) DEFAULT '',
  `TOTAL_TAX_PAID` varchar(50) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_candidate_agricultural_tax` */



/*Table structure for table `pak_candidate_constituency` */



DROP TABLE IF EXISTS `pak_candidate_constituency`;



CREATE TABLE `pak_candidate_constituency` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `CONST_NUMBER` varchar(50) DEFAULT '',
  `CONST_TYPE` varchar(50) DEFAULT '',
  `PROVINCE_ID` int(10) DEFAULT NULL,
  `CITY_ID` int(10) DEFAULT NULL,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;



/*Data for the table `pak_candidate_constituency` */



insert  into `pak_candidate_constituency`(`ID`,`CANDIDATE_ID`,`CONST_NUMBER`,`CONST_TYPE`,`PROVINCE_ID`,`CITY_ID`,`STATUS`) values (1,'1','1','1',1,NULL,1),(2,'13','2','1',2,NULL,1),(3,'20','3','1',3,NULL,1),(4,'22','4','1',4,NULL,1),(5,'5','5','2',1,NULL,1),(6,'15','6','2',2,NULL,1),(7,'13','7','2',3,NULL,1),(8,'17','8','2',4,NULL,1),(9,'18','9','2',1,NULL,1),(10,'14','1','2',2,NULL,1),(11,'2','2','2',3,NULL,1),(12,'19','3','2',4,NULL,1),(13,'23','4','2',1,NULL,1),(14,'3','5','2',2,NULL,1),(15,'4','6','2',3,NULL,1),(16,'5','7','2',4,NULL,1),(17,'6','8','2',1,NULL,1),(18,'21','9','2',2,NULL,1),(19,'7','1','1',3,NULL,1),(20,'20','2','1',4,NULL,1),(21,'12','3','1',1,NULL,1),(22,'8','4','1',2,NULL,1),(23,'9','5','1',3,NULL,1),(24,'21','6','1',4,NULL,1),(25,'16','7','1',1,NULL,1),(26,'11','8','1',2,NULL,1),(27,'10','9','1',3,NULL,1),(28,'7','1','1',1,NULL,1),(29,'9','2','1',2,NULL,1),(30,'8','3','1',3,NULL,1),(31,'6','4','1',4,NULL,1),(32,'5','5','1',1,NULL,1),(33,'4','6','1',2,NULL,1),(34,'3','7','1',3,NULL,1),(35,'2','8','1',4,NULL,1),(36,'10','8','1',1,NULL,1),(37,'11','1','1',2,NULL,1),(38,'12','2','1',3,NULL,1),(39,'16','3','1',4,NULL,1),(40,'19','4','1',1,NULL,1),(41,'18','5','1',2,NULL,1),(42,'17','6','1',3,NULL,1),(43,'15','7','1',4,NULL,1),(44,'14','8','1',1,NULL,1);



/*Table structure for table `pak_candidate_income_tax` */



DROP TABLE IF EXISTS `pak_candidate_income_tax`;



CREATE TABLE `pak_candidate_income_tax` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `TOTAL_INCOME` varchar(50) DEFAULT '',
  `SOURCE_OF_INCOME` longtext,
  `TAX_YEAR` varchar(10) DEFAULT '',
  `TOTAL_TAX_PAID` varchar(50) DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;



/*Data for the table `pak_candidate_income_tax` */



insert  into `pak_candidate_income_tax`(`ID`,`CANDIDATE_ID`,`TOTAL_INCOME`,`SOURCE_OF_INCOME`,`TAX_YEAR`,`TOTAL_TAX_PAID`) values (1,'1','500000','smuglling','2012','5000'),(2,'1','123456','sdfsdf','2011','456123'),(3,'1','123456','sdfsdf','2011','456123'),(4,'1','123456','sdfsdf','2011','456123'),(5,'1','123456','sdfsdf','2011','456123');



/*Table structure for table `pak_cash_bank` */



DROP TABLE IF EXISTS `pak_cash_bank`;



CREATE TABLE `pak_cash_bank` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `CASH_IN_HAND` varchar(50) DEFAULT '0',
  `CASH_AT_BANK` varchar(50) DEFAULT '',
  `CH_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `CB_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_cash_bank` */



/*Table structure for table `pak_cash_type` */



DROP TABLE IF EXISTS `pak_cash_type`;



CREATE TABLE `pak_cash_type` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `CASH_NAME` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_cash_type` */



/*Table structure for table `pak_city` */



DROP TABLE IF EXISTS `pak_city`;



CREATE TABLE `pak_city` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `PROVINCE_ID` int(10) DEFAULT NULL,
  `CITY_NAME` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



/*Data for the table `pak_city` */



insert  into `pak_city`(`id`,`PROVINCE_ID`,`CITY_NAME`) values (1,1,'Lahore'),(2,1,'Kasur'),(3,1,'Okara'),(4,1,'Sahiwal'),(5,1,'Pakpattan'),(6,1,'Shiekhupura'),(7,1,'Sargodha'),(8,1,'Khushab'),(9,1,'Mian Wali'),(10,1,'Bhakkar'),(11,1,'Jhang'),(12,1,'Chinot'),(13,1,'Toba Tek Singh'),(14,1,'Faisalabad'),(15,1,'Nankana'),(16,1,'Mandi Bahudin'),(17,1,'Hafizabad'),(18,1,'Gujrat'),(19,1,'Jhelum'),(20,1,'Rawalpindi'),(21,1,'Attock'),(22,1,'Chakwal'),(23,1,'Gujranwala'),(24,1,'Sialkot'),(25,1,'Narowal'),(26,1,'Multan'),(27,1,'Muzzaffargarh'),(28,1,'D.G Khan'),(29,1,'Rajan pur'),(30,1,'Lohdran'),(31,1,'Vehari'),(32,1,'Bahawalpur'),(33,1,'Bahawalnagar'),(34,1,'Khanewal'),(35,1,'Rahim Yar Khan'),(36,1,'Layyah'),(37,2,'Dadu'),(38,2,'Jamsharo'),(39,2,'Nausheroferoz'),(40,2,'Sanghar'),(41,2,'Tando Allah Yar'),(42,2,'Matiari'),(43,2,'Hyderabad'),(44,2,'Jacobabad'),(45,2,'Kashmor'),(46,2,'Larkana'),(47,2,'Sukkur'),(48,2,'Ghotki'),(49,2,'Shikarpur'),(50,2,'Khairpur'),(51,2,'Thatta'),(52,2,'Mirpur Khas'),(53,2,'Badin'),(54,2,'Shaheed Benazir Abad Nawab Shah'),(55,2,'Tando Muhammad Khan'),(56,2,'Umar kot'),(57,2,'Tharparkar'),(58,2,'Qamber Shahdadkot District'),(59,2,'Karachi'),(60,3,'Haripur'),(61,3,'Sakardu'),(62,3,'Shangla Alpori Basham'),(63,3,'Abbottabad'),(64,3,'Mansehra'),(65,3,'Mardan'),(66,3,'Nowshera'),(67,3,'Swabi'),(68,3,'Malakand'),(69,3,'Bannu'),(70,3,'D.I. Khan'),(71,3,'Tank'),(72,3,'Charsada'),(73,3,'Lower Dir'),(74,3,'Dir Bala'),(75,3,'Hangu'),(76,3,'Chitral'),(77,3,'Battagram'),(78,3,'Buner'),(79,3,'Para Chinar'),(80,3,'Karak'),(81,3,'Kohistan'),(82,3,'Lakki Marwat'),(83,3,'Swat'),(84,4,'Quetta'),(85,4,'Khuzdar'),(86,4,'Zhob'),(87,4,'Loralai'),(88,4,'Sibi'),(89,4,'Pishin'),(90,4,'killa Saif ullah'),(91,4,'killa Abdullah'),(92,4,'Kalat'),(93,4,'Nushki'),(94,4,'Ziarat'),(95,4,'Panjgur'),(96,4,'Awaran'),(97,4,'Barkhan'),(98,4,'Chagai'),(99,4,'Dera Bugti'),(100,4,'Gwadar'),(101,4,'Jafarabad'),(102,4,'Jhal Magsi'),(103,4,'Kech/Turbat'),(104,4,'Kharan'),(105,4,'Kohlu'),(106,4,'Lesbala'),(107,4,'Mastung'),(108,4,'Musakhel'),(109,4,'Nasirabad'),(110,4,'Sherani'),(111,4,'Bolan'),(112,4,'Washuk'),(113,4,'Harnai'),(114,4,'Hub Lasbela  Balochistan'),(115,6,'Khyber Agency'),(116,6,'Bara, Khyber Agency'),(117,6,'Bajor Agency'),(118,6,'Khar Bajor'),(119,6,'Mohmand Agency'),(120,6,'S. Waziristan'),(121,6,'N. Waziristan'),(122,6,'Sadda, Kurram  Agency'),(123,6,'Jamrud, Dara Adam Khail');



/*Table structure for table `pak_constituency` */



DROP TABLE IF EXISTS `pak_constituency`;



CREATE TABLE `pak_constituency` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `PROVINCE_ID` int(5) DEFAULT NULL,
  `TYPE_ID` int(5) DEFAULT NULL,
  `CONSTITUENCY_NAME` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



/*Data for the table `pak_constituency` */



insert  into `pak_constituency`(`ID`,`PROVINCE_ID`,`TYPE_ID`,`CONSTITUENCY_NAME`) values (1,1,1,'NA001'),(2,1,1,'NA047'),(3,1,1,'NA003'),(4,2,1,'NA004'),(5,3,1,'NA005'),(6,4,1,'NA006'),(7,3,1,'NA007'),(8,2,1,'NA008'),(9,1,1,'NA009'),(10,2,1,'NA010'),(11,3,1,'NA011'),(12,4,1,'NA012'),(13,3,1,'NA013'),(14,2,1,'NA014'),(15,1,1,'NA015'),(16,2,1,'NA016'),(17,3,1,'NA017'),(18,4,1,'NA018'),(19,3,1,'NA019'),(20,2,1,'NA020'),(21,4,1,'NA021'),(22,3,1,'NA022'),(23,2,1,'NA023'),(24,3,1,'NA024'),(25,4,1,'NA025'),(26,2,1,'NA026'),(27,2,1,'NA027'),(28,2,1,'NA028'),(29,3,1,'NA029'),(30,4,1,'NA030'),(31,3,1,'NA031'),(32,2,1,'NA032'),(33,3,1,'NA033'),(34,4,1,'NA034'),(35,3,1,'NA035'),(36,2,1,'NA036'),(37,3,1,'NA037'),(38,4,1,'NA038'),(39,3,1,'NA039'),(40,2,1,'NA040'),(41,3,1,'NA041'),(42,1,1,'NA042'),(43,3,1,'NA043'),(44,1,1,'NA044'),(45,4,1,'NA045'),(46,1,1,'NA046'),(47,1,1,'NA002'),(48,1,2,'PS001'),(49,2,2,'PS001'),(50,3,2,'PS001'),(51,4,2,'PS001'),(52,3,2,'PS001'),(53,2,2,'PS001'),(54,3,2,'PS001'),(55,4,2,'PS001'),(56,3,2,'PS001'),(57,2,2,'PS001'),(58,3,2,'PS001'),(59,4,2,'PS001'),(60,1,2,'PS001'),(61,2,2,'PS001'),(62,1,2,'PS001'),(63,2,2,'PS001'),(64,3,2,'PS001'),(65,4,2,'PS001'),(66,1,2,'PS001'),(67,2,2,'PS001'),(68,3,2,'PS001'),(69,4,2,'PS001'),(70,1,2,'PS001'),(71,2,2,'PS001'),(72,3,2,'PS001'),(73,4,2,'PS001'),(74,3,2,'PS001'),(75,2,2,'PS002');



/*Table structure for table `pak_currency_type` */



DROP TABLE IF EXISTS `pak_currency_type`;



CREATE TABLE `pak_currency_type` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `CURRENCY_NAME` varchar(255) DEFAULT '',
  `CURRENCY_CODE` varchar(4) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_currency_type` */



/*Table structure for table `pak_furniture` */



DROP TABLE IF EXISTS `pak_furniture`;



CREATE TABLE `pak_furniture` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `DETAILS` longtext,
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



/*Data for the table `pak_furniture` */



insert  into `pak_furniture`(`ID`,`CANDIDATE_ID`,`DETAILS`,`COST`,`PRESENT_VALUE`,`C_CUR_TYPE`,`P_CUR_TYPE`,`REMARKS`,`STATUS`) values (1,'1','test dummy data test dummy data test dummy data test dummy data test dummy data test dummy data ','10000','5000',0,0,'test dummy data ',1);



/*Table structure for table `pak_investments` */



DROP TABLE IF EXISTS `pak_investments`;



CREATE TABLE `pak_investments` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `INVESTMENT_TYPE` tinyint(3) unsigned DEFAULT '0',
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;



/*Data for the table `pak_investments` */



insert  into `pak_investments`(`ID`,`CANDIDATE_ID`,`INVESTMENT_TYPE`,`COST`,`PRESENT_VALUE`,`C_CUR_TYPE`,`P_CUR_TYPE`,`REMARKS`,`STATUS`) values (1,'1',1,'5000','5000',0,0,'test dummy data',1),(2,'1',2,'1000','2500',0,0,'test dummy data',1),(3,'1',1,'4000','650',0,0,'test dummy data',1);



/*Table structure for table `pak_investments_type` */



DROP TABLE IF EXISTS `pak_investments_type`;



CREATE TABLE `pak_investments_type` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `INVESTMENTS_NAME` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;



/*Data for the table `pak_investments_type` */



insert  into `pak_investments_type`(`ID`,`INVESTMENTS_NAME`,`STATUS`) values (1,'Agriculture',1),(2,'Real State',1),(3,'Dollars',1),(4,'Food',1),(5,'Gold',1),(6,'Import Export',1);



/*Table structure for table `pak_jewellery` */



DROP TABLE IF EXISTS `pak_jewellery`;



CREATE TABLE `pak_jewellery` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `WEIGHT` varchar(50) DEFAULT '0',
  `DESCRIPTION` text,
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



/*Data for the table `pak_jewellery` */



insert  into `pak_jewellery`(`ID`,`CANDIDATE_ID`,`WEIGHT`,`DESCRIPTION`,`COST`,`PRESENT_VALUE`,`C_CUR_TYPE`,`P_CUR_TYPE`,`REMARKS`,`STATUS`) values (1,'1','250','test dummy data	','2500000','250000000',0,0,'test dummy data	',1);



/*Table structure for table `pak_liabilities` */



DROP TABLE IF EXISTS `pak_liabilities`;



CREATE TABLE `pak_liabilities` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `LIABILITIES_TYPE` int(10) DEFAULT NULL,
  `AMOUNT` varchar(20) DEFAULT '',
  `A_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;



/*Data for the table `pak_liabilities` */



insert  into `pak_liabilities`(`ID`,`CANDIDATE_ID`,`LIABILITIES_TYPE`,`AMOUNT`,`A_CUR_TYPE`,`REMARKS`,`STATUS`) values (1,'1',1,'50000',0,'test dummy data',1),(2,'1',2,'100000',0,'test dummy data test dummy data',1);



/*Table structure for table `pak_liabilities_detail` */



DROP TABLE IF EXISTS `pak_liabilities_detail`;



CREATE TABLE `pak_liabilities_detail` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `LIABILITIES_NAME` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;



/*Data for the table `pak_liabilities_detail` */



insert  into `pak_liabilities_detail`(`ID`,`LIABILITIES_NAME`,`STATUS`) values (1,'Loan',1),(2,'Etc',1),(3,'other',1);



/*Table structure for table `pak_motor_vehicles` */



DROP TABLE IF EXISTS `pak_motor_vehicles`;



CREATE TABLE `pak_motor_vehicles` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `MAKE` varchar(255) DEFAULT '0',
  `MODEL` varchar(255) DEFAULT '',
  `REGISTRATION_NUMBER` varchar(255) DEFAULT '',
  `COST` varchar(20) NOT NULL DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



/*Data for the table `pak_motor_vehicles` */



insert  into `pak_motor_vehicles`(`ID`,`CANDIDATE_ID`,`MAKE`,`MODEL`,`REGISTRATION_NUMBER`,`COST`,`PRESENT_VALUE`,`C_CUR_TYPE`,`P_CUR_TYPE`,`REMARKS`,`STATUS`) values (1,'1','Toyota','2008','AFR','100000','100000',0,0,'test dummy data	',1);



/*Table structure for table `pak_other_assets` */



DROP TABLE IF EXISTS `pak_other_assets`;



CREATE TABLE `pak_other_assets` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `ASSETS_TYPE` text,
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_other_assets` */



/*Table structure for table `pak_party` */



DROP TABLE IF EXISTS `pak_party`;



CREATE TABLE `pak_party` (
  `ID` tinyint(10) unsigned NOT NULL AUTO_INCREMENT,
  `PARTY` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;



/*Data for the table `pak_party` */



insert  into `pak_party`(`ID`,`PARTY`,`STATUS`) values (1,'PML(N)',1),(2,'PML(Q)',1),(3,'PPP',1),(4,'MQM',1),(5,'ANP',1),(6,'PTI',1),(7,'PML',1);



/*Table structure for table `pak_property_outside` */



DROP TABLE IF EXISTS `pak_property_outside`;



CREATE TABLE `pak_property_outside` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `DETAIL` text,
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_property_outside` */



/*Table structure for table `pak_property_pakistan` */



DROP TABLE IF EXISTS `pak_property_pakistan`;



CREATE TABLE `pak_property_pakistan` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `DETAIL` text,
  `COST` varchar(20) DEFAULT '',
  `PRESENT_VALUE` varchar(20) DEFAULT '',
  `C_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `P_CUR_TYPE` tinyint(3) unsigned DEFAULT '0',
  `REMARKS` longtext,
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_property_pakistan` */



/*Table structure for table `pak_proposer` */



DROP TABLE IF EXISTS `pak_proposer`;



CREATE TABLE `pak_proposer` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `PROVINCE_ID` int(10) DEFAULT NULL,
  `P_NAME` varchar(255) DEFAULT '',
  `P_NIC` varchar(50) DEFAULT '',
  `P_SR_NO` varchar(50) DEFAULT '',
  `P_ELECTORIAL_AREA` varchar(255) DEFAULT '',
  `P_TEHSIL` varchar(255) DEFAULT '',
  `P_DISTRICT` varchar(255) DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



/*Data for the table `pak_proposer` */



insert  into `pak_proposer`(`ID`,`CANDIDATE_ID`,`PROVINCE_ID`,`P_NAME`,`P_NIC`,`P_SR_NO`,`P_ELECTORIAL_AREA`,`P_TEHSIL`,`P_DISTRICT`) values (1,'1',1,'Churassi','12345-1234567-1','123','LaloKhait','Wastee','pata nahi');



/*Table structure for table `pak_province` */



DROP TABLE IF EXISTS `pak_province`;



CREATE TABLE `pak_province` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `PROVINCE` varchar(50) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;



/*Data for the table `pak_province` */



insert  into `pak_province`(`ID`,`PROVINCE`,`STATUS`) values (1,'Sindh',1),(2,'Punjab',1),(3,'Balochistan',1),(4,'Fata',1);



/*Table structure for table `pak_seconder` */



DROP TABLE IF EXISTS `pak_seconder`;



CREATE TABLE `pak_seconder` (
  `ID` bigint(18) NOT NULL AUTO_INCREMENT,
  `CANDIDATE_ID` decimal(18,0) DEFAULT '0',
  `PROVINCE_ID` int(10) DEFAULT NULL,
  `S_NAME` varchar(255) DEFAULT '',
  `S_NIC` varchar(50) DEFAULT '',
  `S_SR_NO` varchar(50) DEFAULT '',
  `S_ELECTORIAL_AREA` varchar(255) DEFAULT '',
  `S_TEHSIL` varchar(255) DEFAULT '',
  `S_DISTRICT` varchar(255) DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



/*Data for the table `pak_seconder` */



insert  into `pak_seconder`(`ID`,`CANDIDATE_ID`,`PROVINCE_ID`,`S_NAME`,`S_NIC`,`S_SR_NO`,`S_ELECTORIAL_AREA`,`S_TEHSIL`,`S_DISTRICT`) values (1,'1',1,'Mustansar','12313165465','123','lalokhait','abc','xyz');



/*Table structure for table `pak_transferred_type` */



DROP TABLE IF EXISTS `pak_transferred_type`;



CREATE TABLE `pak_transferred_type` (
  `ID` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `TRANSFERRED_NAME` varchar(255) DEFAULT '',
  `STATUS` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pak_transferred_type` */



/*Table structure for table `pk_constituency_national` */



DROP TABLE IF EXISTS `pk_constituency_national`;



CREATE TABLE `pk_constituency_national` (
  `Id` bigint(18) NOT NULL AUTO_INCREMENT,
  `ProvinceId` decimal(18,0) NOT NULL DEFAULT '0',
  `ConstituencyName` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;



/*Data for the table `pk_constituency_national` */



insert  into `pk_constituency_national`(`Id`,`ProvinceId`,`ConstituencyName`) values (1,'1','NA001'),(2,'2','NA002'),(3,'1','NA003'),(4,'2','NA004'),(5,'2','NA004'),(6,'2','NA004'),(7,'2','NA004'),(8,'2','NA004'),(9,'2','NA004'),(10,'2','NA004'),(11,'2','NA004'),(12,'2','NA004'),(13,'2','NA004'),(14,'2','NA004'),(15,'2','NA004'),(16,'2','NA004'),(17,'2','NA004'),(18,'2','NA004'),(19,'2','NA004'),(20,'2','NA004'),(21,'2','NA004'),(22,'2','NA004'),(23,'2','NA004'),(24,'2','NA004'),(25,'2','NA004'),(26,'2','NA004'),(27,'2','NA004'),(28,'2','NA004'),(29,'2','NA004'),(30,'2','NA004'),(31,'2','NA004'),(32,'2','NA004'),(33,'2','NA004'),(34,'2','NA004'),(35,'2','NA004'),(36,'2','NA004'),(37,'2','NA004'),(38,'2','NA004'),(39,'2','NA004');



/*Table structure for table `pk_constituency_prov` */



DROP TABLE IF EXISTS `pk_constituency_prov`;



CREATE TABLE `pk_constituency_prov` (
  `Id` bigint(18) NOT NULL AUTO_INCREMENT,
  `ProvinceId` decimal(18,0) NOT NULL DEFAULT '0',
  `ConstituencyName` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `pk_constituency_prov` */



/*Table structure for table `shippers` */



DROP TABLE IF EXISTS `shippers`;



CREATE TABLE `shippers` (
  `ShipperID` int(11) NOT NULL AUTO_INCREMENT,
  `CompanyName` varchar(40) NOT NULL DEFAULT '',
  `Phone` varchar(24) DEFAULT '',
  PRIMARY KEY (`ShipperID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



/*Data for the table `shippers` */



/*Table structure for table `users` */



DROP TABLE IF EXISTS `users`;



CREATE TABLE `users` (
  `users_id` int(20) NOT NULL AUTO_INCREMENT,
  `users_isAdmin` tinyint(1) DEFAULT '1',
  `users_fname` varchar(255) DEFAULT NULL,
  `users_lname` varchar(255) DEFAULT NULL,
  `users_email` varchar(255) DEFAULT NULL,
  `users_password` varchar(255) DEFAULT NULL,
  `users_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`users_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



/*Data for the table `users` */



insert  into `users`(`users_id`,`users_isAdmin`,`users_fname`,`users_lname`,`users_email`,`users_password`,`users_status`) values (1,1,'Muhammed','Mubashir','admin@admin.com','21232f297a57a5a743894a0e4a801fc3',1);



/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;