--
-- Host: localhost    Database: faisalanwar_zain
-- ------------------------------------------------------


--
-- Current Database: `faisalanwar_zain`
--


--
-- Table structure for table `account_type`
--

CREATE TABLE `account_type` (
  `account_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_type` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`account_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_type`
--

INSERT INTO `account_type` (`account_type_id`, `account_type`) VALUES (1,'Sale Account'),(2,'Purchase Account'),(4,'Bank Account'),(5,'General Expense Account'),(7,'Factory Expense Account'),(8,'Sale & Purchase Account'),(9,'Advance Account Expenses');

--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `account_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(255) DEFAULT NULL,
  `account_address` varchar(255) DEFAULT NULL,
  `opening_balance` decimal(18,2) DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `ph_number` varchar(255) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `account_type` varchar(255) DEFAULT NULL,
  `salesman_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`account_id`, `account_name`, `account_number`, `account_address`, `opening_balance`, `description`, `ph_number`, `date`, `account_type`, `salesman_id`) VALUES (1,'Fancy Mills','0001','Faisalabad',0.00,NULL,'000000000000','2020-04-14 18:36:00','2',0),(2,'Al Noor Cotton','0002','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(3,'Usama Cotton','0003','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(4,'Sharif Cotton','0004','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(5,'Rizwan Cotton','0005','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(6,'Rana Husain - AN','0006','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(7,'Imran Cotton','0007','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(8,'Asima Ansari Cotton','0008','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(9,'Kashif Sb (Paper Con)','0009','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(10,'Abid Sb (Bags)','0010','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(11,'Abdul Rehman (Bags)','0011','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(12,'Noor Store','0012','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(13,'Muhammad Anwar','0013','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(14,'Akhtar Attari','0014','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(15,'Abu Huraira','0015','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(16,'Ayub Khan','0016','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(17,'Molvi Afzal','0017','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(18,'Liaqat Waseem','0018','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(19,'Molvi Arshad','0019','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(20,'Hafiz Muavia','0020','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(21,'Rana Khalid','0021','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(22,'Zahid Samanabad','0022','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(23,'Usman Awais','0023','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(24,'Saleem Nishatabad','0024','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(25,'Shahid Ghulamabad','0025','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(26,'Shabbir Haidarabad','0026','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(27,'Abdul Ghaffar Sb','0027','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(28,'Mueen uddin Multan','0028','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(29,'Muhammad Muazam Sb','0029','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(30,'Arshad Samnabad','0030','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(31,'Naseer Wan Store','0031','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(32,'Umer Farhan Sb','0032','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(33,'Babar Transporter','0033','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(34,'Asif Transporter','0034','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(35,'Shahbaz Transporter','0035','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(36,'Molvi Tariq Madina Azeem','0036','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(37,'Azmat Traders','0037','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(38,'Toufiq Traders','0038','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(39,'Maraj Belt','0039','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(40,'Pakistan Bearing','0040','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(41,'Sarfaraz Electric','0041','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(42,'Nadeem Electric','0042','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(43,'Ramzan Traders','0043','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(44,'Mahar Enterpriser (Abid Sb)','0044','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(45,'Nawaz Traders','0045','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(46,'Khalid Cyclinder (Fire)','0046','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0),(47,'Ilyas Laiti','0047','Faisalabad',0.00,NULL,'0','2020-04-14 18:36:00','2',0);

--
-- Table structure for table `batches`
--

CREATE TABLE `batches` (
  `batch_id` int(11) NOT NULL AUTO_INCREMENT,
  `batch_no` varchar(255) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `max_qty` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`batch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `batches`
--


--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3ughfbjbc4et14ri4v9ri9lppet6a9fi','196.194.129.131',1586008262,'__ci_last_regenerate|i:1586008139;email|s:15:\"admin@eeizo.com\";name|s:13:\"Zartab Fatima\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('8repd1gg9508f3cipphm1omifjkpc3et','196.194.129.131',1586010153,'__ci_last_regenerate|i:1586010153;'),('n0ogv3mdahpsafstre66qsueafn1ju52','182.185.239.51',1586069509,'__ci_last_regenerate|i:1586069509;'),('q3b2vv6fhmcfhjhkg0k3gqmd6gict00d','182.185.239.51',1586069529,'__ci_last_regenerate|i:1586069529;'),('jc0j8nepi16eu59c7r2njn6mlus9484n','182.185.239.51',1586069546,'__ci_last_regenerate|i:1586069546;'),('3hdqiptipm45r61tqfqu80e18rp087q7','103.255.5.66',1586069907,'__ci_last_regenerate|i:1586069629;failed|b:0;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;'),('jqq1ofpnrtap5sscbm6tpqnp23b37bni','196.194.129.131',1586072122,'__ci_last_regenerate|i:1586071921;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('qe7ulrmdmic1nki4fsujo0o9l0iq4kp9','196.194.129.131',1586072572,'__ci_last_regenerate|i:1586072496;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('janhqovq0s7qqjlbm7sboacrln63men9','196.194.129.131',1586073106,'__ci_last_regenerate|i:1586072824;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('lvlcbm63d9g3vuubm15qnaj9fspc5aa6','196.194.129.131',1586073580,'__ci_last_regenerate|i:1586073287;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('n2mh6umrmrt66a8mjhndvr2ef97sfn4h','196.194.129.131',1586073657,'__ci_last_regenerate|i:1586073601;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('g31lk2ogj902skge5qdboahm3stb3g7j','196.194.129.131',1586074229,'__ci_last_regenerate|i:1586074003;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('75unvcklh53vsqd77l3bp99gqsd5ptbc','196.194.129.131',1586074552,'__ci_last_regenerate|i:1586074309;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('kq2n5li7d7hb1pe552nrakkrd9p0hpcn','196.194.129.131',1586074944,'__ci_last_regenerate|i:1586074655;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('i0ub2vc63k6pmife30sssfj664hasrc8','196.194.129.131',1586075053,'__ci_last_regenerate|i:1586074956;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('nphhcjnk08as1eommj8a13h8ifija79c','196.194.129.131',1586075660,'__ci_last_regenerate|i:1586075405;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('2gsq15afoqfrtau2qhntkd7u6qc12n09','196.194.129.131',1586075879,'__ci_last_regenerate|i:1586075744;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('3uvlqf4l7ih34od415f6euaaoo4gudpq','196.194.129.131',1586076561,'__ci_last_regenerate|i:1586076308;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('rkdkpi6s3fa1k87isis84m5gdhkmum3a','196.194.140.149',1586235711,'__ci_last_regenerate|i:1586235711;'),('qdmqscqqlirrht49q1kn68fv1m9lhopn','196.194.140.149',1586235804,'__ci_last_regenerate|i:1586235804;'),('tj9afn973nlr9saj9bcv0n9f2quq0s99','196.194.140.149',1586235929,'__ci_last_regenerate|i:1586235929;'),('59iv96930dvvgeff2knmmcpsimhg3gbm','196.194.140.149',1586236000,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('ri8rtnvla63iem9gac4n31m7jgmhlii0','196.194.140.149',1586236000,'__ci_last_regenerate|i:1586236000;'),('c59fsplb89mrhr5duprku4ussa2skfmb','196.194.140.149',1586236001,'__ci_last_regenerate|i:1586236001;'),('thdloslbbg4nafb3kp31up02bkg41rjt','196.194.140.149',1586236028,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('a91qj32ed61scnnf47kv7jfp2dr5tr5n','196.194.140.149',1586236028,'__ci_last_regenerate|i:1586236028;'),('tbktfmifs8e45a5rbg2c3lb5f4g2vg6r','196.194.140.149',1586236029,'__ci_last_regenerate|i:1586236029;'),('4p8c9ei89q131vr0m3n0j725cut8er57','196.194.140.149',1586236056,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('sd04m6fsh6fel9hsq610alv82uivp4of','196.194.140.149',1586236056,'__ci_last_regenerate|i:1586236056;'),('cqenvh354kp7if6soc2cnrdg4a5bue77','196.194.140.149',1586236057,'__ci_last_regenerate|i:1586236057;'),('l4k6vf6lr47koqc5634vbmfi6c9h3oqu','196.194.140.149',1586236202,'__ci_last_regenerate|i:1586236202;'),('i8gf30jh6kpmhbhkjk8hm8oumbdql6l9','196.194.140.149',1586236220,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('07dm0q99j7hmdcpk6k7pnc8u691ra94g','196.194.140.149',1586236221,'__ci_last_regenerate|i:1586236221;'),('p88pfiq3vjjbh5h619mops1u309tkbsg','196.194.140.149',1586236222,'__ci_last_regenerate|i:1586236222;'),('1f2q3fda6ih66sf3ocgdkcatmnut28ri','196.194.140.149',1586236311,'__ci_last_regenerate|i:1586236311;'),('gjqh4d6dcqdodtm2s0vf99to8p9tqms1','103.255.5.65',1586236354,'__ci_last_regenerate|i:1586236337;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('3d7dve65fu7lm9iea1oqe5vhjgug275n','196.194.140.149',1586236562,'__ci_last_regenerate|i:1586236562;'),('q193q4iqmj7rnuj0662rtmstgg9rl14d','196.194.140.149',1586236608,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('a4smnhtvab5hr1o36ov7l8alg5870mbe','196.194.140.149',1586236608,'__ci_last_regenerate|i:1586236608;'),('oj5akv7ucm9qgltiu6m9arfn2rf1d86i','196.194.140.149',1586236608,'__ci_last_regenerate|i:1586236608;'),('1app2g74du3gcohdj53dd8fbfo5tpn5e','196.194.140.149',1586236624,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('n4b9g93krd834kq8msj2qft7ftgei2qc','196.194.140.149',1586236624,'__ci_last_regenerate|i:1586236624;'),('hl3p71gnmt8vd8fqisvpi0lnkoo9anf5','196.194.140.149',1586236625,'__ci_last_regenerate|i:1586236625;'),('d54c3okv1l16ql7t61p97oo2kl2cj56m','196.194.140.149',1586236641,'__ci_last_regenerate|i:1586236641;'),('3fg4o5fns6j61fva7luh513rviup7449','196.194.140.149',1586236642,'__ci_last_regenerate|i:1586236642;'),('8tuatm5atn71djlne4mh0d0tnt963qik','196.194.140.149',1586236668,'__ci_last_regenerate|i:1586236668;'),('d65mi9do98af8u5eibttl5eb8p036m18','196.194.140.149',1586236705,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('mg6evb6fmuo10ad36ugco12kvlbti45s','196.194.140.149',1586236705,'__ci_last_regenerate|i:1586236705;'),('tm9f00jqndrp7nfve5khm0dqd61oqh3p','196.194.140.149',1586236706,'__ci_last_regenerate|i:1586236706;'),('2tk369a62aces8ebg82h62b8p8ttbcv8','196.194.140.149',1586236739,'__ci_last_regenerate|i:1586236739;'),('gj32qggkn6b4ifsr4khehs20r41o7gc1','196.194.140.149',1586242591,'__ci_last_regenerate|i:1586242591;'),('6of7ofavcmgi7k3h7470cnihqjb04flv','196.194.140.149',1586242639,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('impr24f0b1bp4i7npre9i90sni55rfhq','196.194.140.149',1586242644,'__ci_last_regenerate|i:1586242644;'),('8ir7m5j6ekih54li1k1orcqt9fg80mpg','196.194.140.149',1586242644,'__ci_last_regenerate|i:1586242644;'),('hrv0h6m9nl8itarsg5lief44c2ei4rum','196.194.140.149',1586242667,'__ci_last_regenerate|i:1586242667;'),('l3h84aof3q5igtss8q7sgg618eevm1o3','196.194.140.149',1586242711,'__ci_last_regenerate|i:1586242711;'),('j5jm1l7hi5uet8cevt00uekulf3vsnig','196.194.140.149',1586242740,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('fjeon8t6efu4cvtfg94uuglo0l92s53t','196.194.140.149',1586242741,'__ci_last_regenerate|i:1586242741;'),('3ta12b4q65cofbefagmtti87ud5j1o5d','196.194.140.149',1586242741,'__ci_last_regenerate|i:1586242741;'),('melb655i6pjsv0dsi78ogdnatnm4qv0o','196.194.140.149',1586242942,'__ci_last_regenerate|i:1586242942;'),('huani44cpolo3o244btqhagjq1gps0dt','119.160.97.63',1586254500,'__ci_last_regenerate|i:1586254500;'),('a4v9l9g7rijb3taof756dmaqvusutgr4','119.160.97.63',1586254515,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('10gp3e57hjbfto298ekiud5d0irfs79t','119.160.97.63',1586254515,'__ci_last_regenerate|i:1586254515;'),('vq4v5v9s7op9aifn33963u7jgspqdjc8','119.160.97.63',1586254515,'__ci_last_regenerate|i:1586254515;'),('dcgd3rh5e19p6fic0mibote7gm34o2kg','119.160.97.63',1586254555,'email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('l39ma2o2itklnkeijh4spmitn3p33rqg','119.160.97.63',1586254555,'__ci_last_regenerate|i:1586254555;'),('cva9d0r8df0nlbpfg46s687v2j5kk5n1','119.160.97.63',1586254555,'__ci_last_regenerate|i:1586254555;'),('nthfsvt03uo82j7rkigorliipflhccpu','119.160.97.63',1586254565,'__ci_last_regenerate|i:1586254565;'),('4nhl1668pelqauknq6q9g473qn1gnabh','119.160.97.63',1586254565,'__ci_last_regenerate|i:1586254565;'),('c4u8krup8uqbj7t5o3jj9omk3fjeg7kj','182.185.239.51',1586357055,'__ci_last_regenerate|i:1586357055;'),('3r4nd2tr2pn3shk78ol6u3obkn8aknlb','182.185.239.51',1586357055,'__ci_last_regenerate|i:1586357055;'),('fj2rgbvcaang9u2buvfjg7b75licoibj','182.185.239.51',1586357058,'__ci_last_regenerate|i:1586357055;'),('6p5vpgstq0417ia6e7qk4bc7qkdunmc2','111.119.187.39',1586414918,'__ci_last_regenerate|i:1586414865;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('53g7n67ds6nildmhuhk81ok5891vji1c','103.255.5.42',1586757797,'__ci_last_regenerate|i:1586757772;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('0rj98f3d6u7vh7lcr6rjcp5vdmpu28ag','182.185.208.15',1586762049,'__ci_last_regenerate|i:1586762049;'),('ggnhi48qmkr5i6sv8m57clgotjbj0sbp','182.185.239.51',1586890428,'__ci_last_regenerate|i:1586889111;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('f5p9nn1bn5bggbr1n0bsn31vdb3vqnvd','119.160.102.197',1586889140,'__ci_last_regenerate|i:1586889140;'),('j1joa7p3ntr5qlg3p224ujnsr44uqm97','182.185.239.51',1586890471,'__ci_last_regenerate|i:1586890429;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('1bkacotpea21uuipv05iajmf92udj6ok','103.255.4.24',1586933944,'__ci_last_regenerate|i:1586933803;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('4ela5s7mc166cehp60aakt0lahpq25de','103.255.4.24',1586934269,'__ci_last_regenerate|i:1586934121;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('j6vi6rj9u7mbbuafsa39lu88jobedobh','103.255.4.24',1586934548,'__ci_last_regenerate|i:1586934459;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('5gj2b7gdvrk175s1kepfqtcug7sgoajv','103.255.4.24',1586936387,'__ci_last_regenerate|i:1586936296;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('4li6dfdin89bipuuf0s18lmgpntjuso2','103.255.4.24',1586936702,'__ci_last_regenerate|i:1586936702;email|s:15:\"admin@eeizo.com\";name|s:5:\"Admin\";user_id|s:1:\"1\";user_group_id|s:1:\"1\";company_logo|s:9:\"logo1.png\";company_view_logo|s:8:\"logo.png\";company_invoice_logo|s:10:\"Header.png\";company_name|s:18:\"Al Kabeer Spinning\";currency_symbol|s:2:\"Rs\";company_address|s:11:\" Faisalabad\";del_code|s:0:\"\";logged_in|b:1;failed|b:0;'),('mp029njt733hmv8cnporr46scs5s193r','103.255.5.38',1587200062,'__ci_last_regenerate|i:1587200062;');

--
-- Table structure for table `employee_ledger`
--

CREATE TABLE `employee_ledger` (
  `employee_ledger_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) DEFAULT NULL,
  `ledger_amount` decimal(8,2) DEFAULT NULL,
  `type` enum('Advance','Salary') DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `ledger_date` datetime NOT NULL DEFAULT current_timestamp(),
  `month` varchar(255) DEFAULT NULL,
  `year` varchar(255) DEFAULT NULL,
  `employee_ledger_temp_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`employee_ledger_id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_ledger`
--


--
-- Table structure for table `employee_ledger_detail`
--

CREATE TABLE `employee_ledger_detail` (
  `employee_ledger_detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_ledger_id` int(11) NOT NULL,
  `type` enum('Allowance','Deduction') DEFAULT NULL,
  `detail_name` varchar(500) DEFAULT NULL,
  `detail_amount` decimal(8,2) DEFAULT NULL,
  PRIMARY KEY (`employee_ledger_detail_id`,`employee_ledger_id`),
  KEY `employee_ledger_id` (`employee_ledger_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_ledger_detail`
--


--
-- Table structure for table `employee_ledger_detail_temp`
--

CREATE TABLE `employee_ledger_detail_temp` (
  `employee_ledger_detail_temp_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_ledger_temp_id` int(11) NOT NULL,
  `type` enum('Allowance','Deduction') DEFAULT NULL,
  `detail_name` varchar(500) DEFAULT NULL,
  `detail_amount` decimal(8,2) DEFAULT NULL,
  PRIMARY KEY (`employee_ledger_detail_temp_id`,`employee_ledger_temp_id`),
  KEY `employee_ledger_id` (`employee_ledger_temp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_ledger_detail_temp`
--


--
-- Table structure for table `employee_ledger_temp`
--

CREATE TABLE `employee_ledger_temp` (
  `employee_ledger_temp_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) DEFAULT NULL,
  `ledger_amount` decimal(8,2) DEFAULT NULL,
  `type` enum('Advance','Salary') DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `ledger_date` datetime NOT NULL DEFAULT current_timestamp(),
  `month` varchar(255) DEFAULT NULL,
  `year` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`employee_ledger_temp_id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_ledger_temp`
--


--
-- Table structure for table `employee_salary`
--

CREATE TABLE `employee_salary` (
  `employee_salary_id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) DEFAULT NULL,
  `salary` decimal(8,2) DEFAULT NULL,
  `inc_amount` decimal(8,2) DEFAULT NULL,
  `inc_description` varchar(500) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`employee_salary_id`),
  KEY `employee_id` (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee_salary`
--


--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `employee_id` int(11) NOT NULL AUTO_INCREMENT,
  `emp_name` varchar(255) DEFAULT NULL,
  `emp_father_name` varchar(255) DEFAULT NULL,
  `emp_dob` date DEFAULT NULL,
  `emp_cnic` varchar(255) DEFAULT NULL,
  `emp_gender` enum('Male','Female') DEFAULT NULL,
  `emp_phone` varchar(255) DEFAULT NULL,
  `emp_local_address` varchar(255) DEFAULT NULL,
  `emp_permanent_address` varchar(255) DEFAULT NULL,
  `emp_nationality` varchar(255) DEFAULT NULL,
  `emp_marital_status` varchar(255) DEFAULT NULL,
  `emp_photo` varchar(255) DEFAULT NULL,
  `emp_unique_id` varchar(255) DEFAULT NULL,
  `emp_designation` varchar(255) DEFAULT NULL,
  `emp_doj` date DEFAULT NULL,
  `emp_status` tinyint(4) NOT NULL DEFAULT 0,
  `emp_documents` varchar(500) DEFAULT NULL,
  `emp_desc` varchar(500) DEFAULT NULL,
  `emp_department` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`employee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employees`
--


--
-- Table structure for table `gate_pass`
--

CREATE TABLE `gate_pass` (
  `gate_pass_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `type` enum('OUTWARD','INWARD') DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  `total_discount` decimal(18,2) DEFAULT 0.00,
  `payment_method` enum('Cash','Bank') DEFAULT NULL,
  `gate_pass_total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('Confirmed','Pending') DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `gate_pass_no` varchar(50) DEFAULT NULL,
  `bag` varchar(255) DEFAULT NULL,
  `carton` varchar(255) DEFAULT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `builty_no` varchar(255) DEFAULT NULL,
  `voucher_no` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `driver_name` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(255) DEFAULT NULL,
  `return_invoice_id` int(11) DEFAULT NULL,
  `tax` decimal(18,2) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`gate_pass_id`),
  KEY `return_invoice_id` (`return_invoice_id`),
  KEY `tax` (`tax`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `gate_pass`
--


--
-- Table structure for table `gate_pass_items`
--

CREATE TABLE `gate_pass_items` (
  `gate_pass_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `gate_pass_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_unit` varchar(255) DEFAULT NULL,
  `product` int(11) NOT NULL,
  `qty` decimal(18,2) DEFAULT NULL,
  `remaining_qty` decimal(18,2) DEFAULT NULL,
  `return_qty` decimal(18,2) DEFAULT NULL,
  `discount` decimal(18,2) DEFAULT 0.00,
  `batch` varchar(255) DEFAULT NULL,
  `product_sale_price` decimal(18,2) DEFAULT NULL,
  `product_purchase_price` decimal(18,2) DEFAULT NULL,
  `gate_pass_subtotal` decimal(18,2) DEFAULT 0.00,
  PRIMARY KEY (`gate_pass_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `gate_pass_items`
--


--
-- Table structure for table `general_setting`
--

CREATE TABLE `general_setting` (
  `g_s_id` int(11) NOT NULL AUTO_INCREMENT,
  `company_logo` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `currency_symbol` varchar(255) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `company_ph_number` text DEFAULT NULL,
  `company_view_logo` varchar(255) DEFAULT NULL,
  `company_invoice_logo` varchar(255) DEFAULT NULL,
  `del_code` int(11) DEFAULT NULL,
  PRIMARY KEY (`g_s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `general_setting`
--

INSERT INTO `general_setting` (`g_s_id`, `company_logo`, `company_name`, `currency_symbol`, `company_address`, `company_ph_number`, `company_view_logo`, `company_invoice_logo`, `del_code`) VALUES (1,'logo1.png','Al Kabeer Spinning','Rs',' Faisalabad','03219696313','logo.png','Header.png',NULL);

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `type` enum('Purchase','Sale','Sale Return','Purchase Return') DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  `total_discount` decimal(18,2) DEFAULT 0.00,
  `payment_method` enum('Cash','Bank') DEFAULT NULL,
  `invoice_total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('Confirmed','Pending') DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `invoice_no` varchar(50) DEFAULT NULL,
  `bag` varchar(255) DEFAULT NULL,
  `carton` varchar(255) DEFAULT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `builty_no` varchar(255) DEFAULT NULL,
  `carriage` decimal(18,2) DEFAULT NULL,
  `voucher_no` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `driver_name` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(255) DEFAULT NULL,
  `return_invoice_id` int(11) DEFAULT NULL,
  `tax` decimal(18,2) DEFAULT NULL,
  `return_invoice_no` varchar(55) DEFAULT NULL,
  `created_by` int(11) DEFAULT 1,
  `created_by_name` varchar(255) DEFAULT NULL,
  `builty_total` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`invoice_id`),
  KEY `return_invoice_id` (`return_invoice_id`),
  KEY `tax` (`tax`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice`
--

INSERT INTO `invoice` (`invoice_id`, `account_id`, `type`, `batch_no`, `total_discount`, `payment_method`, `invoice_total`, `payment_status`, `description`, `date_created`, `invoice_no`, `bag`, `carton`, `cargo`, `builty_no`, `carriage`, `voucher_no`, `destination`, `driver_name`, `mobile_no`, `return_invoice_id`, `tax`, `return_invoice_no`, `created_by`, `created_by_name`, `builty_total`) VALUES (1,3,'Purchase',NULL,0.00,'Cash',60000.00,'Pending','','2020-04-03 08:06:43','P-00001',NULL,NULL,NULL,'',NULL,' P-V # 00001',NULL,NULL,NULL,NULL,0.00,NULL,1,'',NULL),(3,4,'Sale',NULL,0.00,'Cash',90000.00,'Pending','','2020-04-03 08:21:58','S-00001','','','','',0.00,'S-V # 00001','','','',NULL,0.00,NULL,1,'',NULL);

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `invoice_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `qty` decimal(18,2) DEFAULT NULL,
  `discount` decimal(18,2) DEFAULT 0.00,
  `batch` varchar(255) DEFAULT NULL,
  `product_sale_price` decimal(18,2) DEFAULT NULL,
  `product_purchase_price` decimal(18,2) DEFAULT NULL,
  `invoice_subtotal` decimal(18,2) DEFAULT 0.00,
  PRIMARY KEY (`invoice_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invoice_items`
--

INSERT INTO `invoice_items` (`invoice_item_id`, `invoice_id`, `product_id`, `qty`, `discount`, `batch`, `product_sale_price`, `product_purchase_price`, `invoice_subtotal`) VALUES (1,1,3,3000.00,0.00,NULL,NULL,20.00,60000.00),(3,3,1,3000.00,0.00,'',30.00,NULL,90000.00);

--
-- Table structure for table `issue`
--

CREATE TABLE `issue` (
  `issue_id` int(11) NOT NULL AUTO_INCREMENT,
  `warehouse_id` varchar(255) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `production` tinyint(4) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `return_issue_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`issue_id`),
  KEY `date` (`date`),
  KEY `warehouse_id` (`warehouse_id`),
  KEY `section_id` (`section_id`),
  KEY `return_issue_id` (`return_issue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `issue`
--

INSERT INTO `issue` (`issue_id`, `warehouse_id`, `section_id`, `production`, `description`, `date`, `return_issue_id`) VALUES (1,NULL,1,1,'','2020-04-05 08:15:04',NULL);

--
-- Table structure for table `journals`
--

CREATE TABLE `journals` (
  `journal_id` int(11) NOT NULL AUTO_INCREMENT,
  `from_account` int(11) DEFAULT NULL,
  `to_account` int(11) DEFAULT NULL,
  `amount` decimal(18,2) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `CPV` varchar(255) DEFAULT NULL,
  `CRV` varchar(255) DEFAULT NULL,
  `voucher_no` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`journal_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `journals`
--

INSERT INTO `journals` (`journal_id`, `from_account`, `to_account`, `amount`, `description`, `date`, `CPV`, `CRV`, `voucher_no`) VALUES (1,4,0,20000.00,'','2020-04-03 08:31:38',NULL,NULL,'J-V # 00001'),(2,0,3,10000.00,'','2020-04-03 08:31:38',NULL,NULL,'J-V # 00002'),(3,0,5,200.00,'','2020-04-03 08:31:38',NULL,NULL,'J-V # 00003'),(4,0,8,300.00,'','2020-04-03 08:37:37',NULL,NULL,'J-V # 00004'),(5,0,6,200.00,'','2020-04-03 08:37:37',NULL,NULL,'J-V # 00005'),(6,0,7,1000.00,'','2020-04-03 08:37:37',NULL,NULL,'J-V # 00006');

--
-- Table structure for table `ledger`
--

CREATE TABLE `ledger` (
  `ledger_id` int(11) NOT NULL AUTO_INCREMENT,
  `debit_amount` decimal(18,2) DEFAULT NULL,
  `credit_amount` decimal(18,2) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `type` enum('Journal','Invoice','adjustment','salary') DEFAULT NULL,
  `invoice_ref` int(11) DEFAULT NULL,
  `journal_ref` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `temp_credit` decimal(10,2) DEFAULT NULL,
  `salary_ref` int(11) DEFAULT NULL,
  PRIMARY KEY (`ledger_id`),
  KEY `account_id` (`account_id`),
  KEY `date` (`date`),
  KEY `salary_ref` (`salary_ref`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ledger`
--

INSERT INTO `ledger` (`ledger_id`, `debit_amount`, `credit_amount`, `description`, `type`, `invoice_ref`, `journal_ref`, `account_id`, `date`, `temp_credit`, `salary_ref`) VALUES (1,NULL,60000.00,' P-V # 00001<br><br><br>','Invoice',1,NULL,3,'2020-04-03 08:06:43',NULL,NULL),(3,90000.00,NULL,'S-V # 00001<br><br><br>','Invoice',3,NULL,4,'2020-04-03 08:21:58',NULL,NULL),(4,NULL,20000.00,'J-V # 00001','Journal',NULL,1,0,'2020-04-03 08:31:38',NULL,NULL),(5,10000.00,NULL,'J-V # 00002','Journal',NULL,2,0,'2020-04-03 08:31:38',NULL,NULL),(6,200.00,NULL,'J-V # 00003','Journal',NULL,3,0,'2020-04-03 08:31:38',NULL,NULL),(7,300.00,NULL,'J-V # 00004','Journal',NULL,4,0,'2020-04-03 08:37:37',NULL,NULL),(8,200.00,NULL,'J-V # 00005','Journal',NULL,5,0,'2020-04-03 08:37:37',NULL,NULL),(9,1000.00,NULL,'J-V # 00006','Journal',NULL,6,0,'2020-04-03 08:37:37',NULL,NULL);

--
-- Table structure for table `loss_gain_modes`
--

CREATE TABLE `loss_gain_modes` (
  `loss_gain_mode_id` int(11) NOT NULL AUTO_INCREMENT,
  `loss_gain_mode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`loss_gain_mode_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `loss_gain_modes`
--


--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `module_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(255) DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `icon` varchar(255) DEFAULT NULL,
  `module_path` varchar(255) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`module_id`, `module_name`, `parent_id`, `icon`, `module_path`, `sort_order`, `status`) VALUES (1,'Settings',0,'icon-linecons-cog',NULL,17,1),(2,'Users',1,NULL,'users',60,1),(3,'Sections',1,NULL,'sections',61,0),(4,'Warehouses',1,NULL,'warehouses',62,0),(5,'Units',1,NULL,'units',63,1),(6,'Products',0,'icon-linecons-params',NULL,2,1),(7,'Accounts',0,'icon-linecons-diamond',NULL,14,1),(8,'Purchases',0,'icon-linecons-shop','',6,1),(9,'Product Categories',1,NULL,'product_category',64,1),(10,'Sales',0,'icon-linecons-money','',8,1),(11,'Issue from Warehouse',0,'icon-linecons-doc','issue',9,0),(12,'Production',0,'icon-linecons-database','',7,1),(13,'Journals',0,'icon-linecons-note','journal',9,1),(14,'Reports',0,'icon-linecons-doc',NULL,18,1),(15,'Account Statement',14,NULL,'reports/account_statement',799,1),(16,'Warehoue Statement',14,'icon-linecons-desktop','reports/warehouse_statement',801,0),(17,'General Statement',14,NULL,'reports/general_statement',800,0),(18,'Section Statement',14,'icon-linecons-desktop','reports/section_statement',802,0),(19,'Raw Meterial Statement',14,'icon-linecons-desktop','reports/product_statement',803,1),(24,'Financial Statement',14,'icon-linecons-desktop','reports/financial_statement',804,0),(25,'Cash Book',14,'icon-linecons-desktop','reports/cash_memo',798,1),(26,'Received For Production',12,'icon-linecons-doc','Received',152,0),(27,'Loss / Gain Modes',1,NULL,'Loss_gain_modes',65,1),(28,'Process',12,'icon-linecons-database','Process',153,1),(29,'Batches',1,'','batch',66,1),(30,'Final Good Statement',14,'icon-linecons-desktop','reports/final_statement',805,0),(31,'Sale Statement',14,'icon-linecons-desktop','reports/sale_statement',806,1),(32,'Purchase Statement',14,'icon-linecons-desktop','reports/purchase_statement',807,1),(33,'Sale Orders',10,'icon-linecons-desktop','sale_order',300,1),(34,'Purchase Orders',8,'icon-linecons-desktop','purchase_order',200,1),(35,'List Accounts',7,'icon-linecons-desktop','accounts',601,1),(36,'Accounts Adjustments',7,'icon-linecons-desktop','accounts_adjustment',602,1),(37,'List Products',6,'icon-linecons-desktop','products',90,1),(38,'Product Adjustments',6,'icon-linecons-desktop','product_adjustment',91,1),(39,'Account Type',7,'icon-linecons-desktop','account_type',603,1),(40,'Bank Statement',14,'icon-linecons-desktop','reports/bank_statement',800,1),(41,'General Expenses Statement',14,'icon-linecons-desktop','reports/general_expenses_statement',808,1),(42,'Raw Warehouse Statement',14,'icon-linecons-desktop','reports/warehouse_general_statement',809,1),(43,'General Setting',1,'icon-linecons-desktop','general_setting',59,1),(44,'HRM',0,'icon-linecons-user',NULL,15,0),(45,'List Employees',44,'icon-linecons-desktop','employees',501,1),(46,'Paid Salaries',44,'icon-linecons-desktop','employees/payslip',503,1),(47,'Advance',44,'icon-linecons-desktop','employees/advance',504,1),(48,'Employee Salary Record',14,'icon-linecons-desktop','reports/salary_statement',813,0),(49,'Increment',44,'icon-linecons-desktop','employees/increment',505,1),(50,'Sale Closing Statement',14,'icon-linecons-desktop','reports/sale_closing_statement',811,0),(51,'Purchase Closing Statement',14,'icon-linecons-desktop','reports/purchase_closing_statement',810,0),(52,'Dashboard',0,'icon-linecons-desktop','dashboard',1,1),(53,'Create Pay Slip',44,'icon-linecons-desktop','employees/payslip_temp',502,1),(54,'Finished Goods',14,'icon-linecons-desktop','reports/today_final_statement',812,0),(55,'Receiving Bay ',0,'icon-linecons-paper-plane',NULL,3,0),(56,'Receiving Bay Slips',55,'icon-linecons-desktop','receiving_bay',81,1),(57,'Receiving Bay Stock',55,'icon-linecons-desktop','receiving_bay/stock',82,1),(58,'List Purchases',8,'icon-linecons-paper-plane','purchase',201,1),(59,'List Sales',10,'icon-linecons-money','sale',301,1),(60,'Issue from Warehouse',12,'icon-linecons-doc','issue',151,0),(61,'Final Production',12,'icon-linecons-database','production',154,1),(62,'Services',1,'icon-linecons-beaker','Services',67,1),(63,'Outward Gate Pass',0,'icon-linecons-truck','gate_passOutward',5,0),(64,'Inward Gate Pass',0,'icon-linecons-fire','gate_passInward',4,0),(65,'Service Invoice',0,'icon-linecons-heart','service_invoice',10,1),(66,'Recipe',1,'icon-linecons-database','recipe',66,1),(67,'List Sale Returns',10,'icon-linecons-database','sale_return',302,1),(68,'List Purchase Returns',8,'icon-linecons-database','purchase_return',202,1),(69,'Section Adjustments',6,'icon-linecons-desktop','section_adjustment',91,0),(70,'Sale Statement Summary',14,'icon-linecons-desktop','reports/sale_statement_summary',806,0),(71,'Payable/Receiveable Report',14,'icon-linecons-desktop','reports/balance_report',806,1),(72,'Profit & Loss Report',14,'icon-linecons-desktop','reports/profit_loss',806,1),(73,'Salesman',1,'icon-linecons-database','salesman',66,1),(74,'Product Stock',14,'icon-linecons-desktop','reports/product_stock',806,1),(75,'Account Wise Profit & Loss',14,'icon-linecons-desktop','reports/ac_profit_loss',806,1);

--
-- Table structure for table `ordr`
--

CREATE TABLE `ordr` (
  `ordr_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `type` enum('Purchase','Sale','Purchase Return','Sale Return') DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  `total_discount` decimal(18,2) DEFAULT 0.00,
  `payment_method` enum('Cash','Bank') DEFAULT NULL,
  `ordr_total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('Confirmed','Pending') DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `ordr_no` varchar(50) DEFAULT NULL,
  `bag` varchar(255) DEFAULT NULL,
  `carton` varchar(255) DEFAULT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `builty_no` varchar(255) DEFAULT NULL,
  `voucher_no` varchar(255) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL DEFAULT 1,
  `created_by_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ordr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ordr`
--


--
-- Table structure for table `ordr_items`
--

CREATE TABLE `ordr_items` (
  `ordr_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `ordr_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `qty` decimal(18,2) DEFAULT NULL,
  `carton_bag` varchar(11) DEFAULT NULL,
  `discount` decimal(18,2) DEFAULT 0.00,
  `batch` varchar(255) DEFAULT NULL,
  `product_sale_price` decimal(18,2) DEFAULT NULL,
  `product_purchase_price` decimal(18,2) DEFAULT NULL,
  `ordr_subtotal` decimal(18,2) DEFAULT 0.00,
  PRIMARY KEY (`ordr_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ordr_items`
--


--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `product_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_category_name` varchar(255) DEFAULT NULL,
  `symbol` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`product_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`product_category_id`, `product_category_name`, `symbol`) VALUES (1,'Cotton','Cotton');

--
-- Table structure for table `product_ledger`
--

CREATE TABLE `product_ledger` (
  `product_ledger_id` int(11) NOT NULL AUTO_INCREMENT,
  `issue_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `debit_qty` decimal(18,5) DEFAULT NULL,
  `credit_qty` decimal(18,5) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `ref_id` int(11) DEFAULT NULL,
  `type` enum('SECTION','WAREHOUSE','PRODUCTION','Invoice') DEFAULT NULL,
  `date_ledger` timestamp NOT NULL DEFAULT current_timestamp(),
  `lost_qty` decimal(18,2) DEFAULT NULL,
  `lost_notes` varchar(255) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `builty` varchar(255) DEFAULT NULL,
  `gate_pass_id` int(11) DEFAULT NULL,
  `builty_no` varchar(255) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `final_product_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`product_ledger_id`),
  KEY `product_id` (`product_id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `date_ledger` (`date_ledger`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_ledger`
--

INSERT INTO `product_ledger` (`product_ledger_id`, `issue_id`, `product_id`, `debit_qty`, `credit_qty`, `description`, `ref_id`, `type`, `date_ledger`, `lost_qty`, `lost_notes`, `invoice_id`, `builty`, `gate_pass_id`, `builty_no`, `account_id`, `final_product_id`) VALUES (1,NULL,3,NULL,3000.00000,' P-V # 00001<br><br><br>',1,'SECTION','2020-04-03 08:06:43',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL),(2,1,3,3000.00000,NULL,'',1,'SECTION','2020-04-05 08:15:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,1,1,NULL,43.00000,'',1,'PRODUCTION','2020-04-05 08:15:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,1,3000.00000,NULL,'S-V # 00001<br><br><br>',1,'PRODUCTION','2020-04-03 08:21:58',NULL,NULL,3,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) DEFAULT NULL,
  `instock` decimal(18,2) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `unit_id` int(11) DEFAULT NULL,
  `purchase_unit_id` int(11) DEFAULT NULL,
  `sale_unit_id` int(11) DEFAULT NULL,
  `product_category_id` int(11) DEFAULT NULL,
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `warehouse_id` int(11) DEFAULT NULL,
  `type` enum('raw','production','process') DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `product_rate` int(11) DEFAULT NULL,
  `is_process` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`product_id`, `product_name`, `instock`, `description`, `unit_id`, `purchase_unit_id`, `sale_unit_id`, `product_category_id`, `date_created`, `warehouse_id`, `type`, `section_id`, `product_rate`, `is_process`) VALUES (1,'Grey Bails',-2957.00,'',10,10,10,1,'2020-04-05 07:35:22',1,'production',NULL,0,0),(2,'Bags',467.00,'',3,3,3,1,'2020-04-05 07:48:04',1,'production',NULL,0,0),(3,'Grey Cotton Waste',0.00,'',10,10,10,1,'2020-04-05 07:55:53',1,'raw',NULL,0,0),(4,'Black Cotton Waste',0.00,'',10,10,10,1,'2020-04-05 07:56:26',1,'raw',NULL,0,0),(6,'White Cotton Waste',0.00,'',10,10,10,1,'2020-04-05 07:59:37',1,'raw',NULL,0,0),(7,'Mix Cotton Waste',0.00,'',10,10,10,1,'2020-04-05 08:00:01',1,'raw',NULL,0,0),(8,'Black Bails',0.00,'',3,3,3,1,'2020-04-05 08:10:21',1,'production',NULL,0,0),(9,'Merun Bail',0.00,'',3,3,3,1,'2020-04-05 08:11:49',1,'production',NULL,0,0);

--
-- Table structure for table `receiving_bay`
--

CREATE TABLE `receiving_bay` (
  `receiving_bay_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `type` enum('Purchase','Sale','Sale Return','Purchase Return') DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  `total_discount` decimal(18,2) DEFAULT 0.00,
  `payment_method` enum('Cash','Bank') DEFAULT NULL,
  `receiving_bay_total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('Confirmed','Pending') DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `receiving_bay_no` varchar(50) DEFAULT NULL,
  `bag` varchar(255) DEFAULT NULL,
  `carton` varchar(255) DEFAULT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `builty_no` varchar(255) DEFAULT NULL,
  `voucher_no` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `driver_name` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(255) DEFAULT NULL,
  `return_invoice_id` int(11) DEFAULT NULL,
  `tax` decimal(18,2) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`receiving_bay_id`),
  KEY `return_invoice_id` (`return_invoice_id`),
  KEY `tax` (`tax`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `receiving_bay`
--


--
-- Table structure for table `receiving_bay_items`
--

CREATE TABLE `receiving_bay_items` (
  `receiving_bay_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `receiving_bay_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `qty` decimal(18,2) DEFAULT NULL,
  `remaining_qty` decimal(18,2) DEFAULT NULL,
  `return_qty` decimal(18,2) DEFAULT NULL,
  `discount` decimal(18,2) DEFAULT 0.00,
  `batch` varchar(255) DEFAULT NULL,
  `product_sale_price` decimal(18,2) DEFAULT NULL,
  `product_purchase_price` decimal(18,2) DEFAULT NULL,
  `receiving_bay_subtotal` decimal(18,2) DEFAULT 0.00,
  PRIMARY KEY (`receiving_bay_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `receiving_bay_items`
--


--
-- Table structure for table `recipe`
--

CREATE TABLE `recipe` (
  `recipe_id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text DEFAULT NULL,
  `check_process` tinyint(4) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`recipe_id`),
  KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recipe`
--


--
-- Table structure for table `recipe_details`
--

CREATE TABLE `recipe_details` (
  `recipe_detail_id` int(11) NOT NULL AUTO_INCREMENT,
  `recipe_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `credit_qty` decimal(18,5) DEFAULT NULL,
  `debit_qty` decimal(18,5) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `type` enum('SECTION','WAREHOUSE','PRODUCTION','Invoice','RAW') DEFAULT NULL,
  `date_ledger` timestamp NOT NULL DEFAULT current_timestamp(),
  `final_product_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`recipe_detail_id`),
  KEY `product_id` (`product_id`),
  KEY `date_ledger` (`date_ledger`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `recipe_details`
--


--
-- Table structure for table `salesman`
--

CREATE TABLE `salesman` (
  `salesman_id` int(11) NOT NULL AUTO_INCREMENT,
  `salesman_name` varchar(255) DEFAULT NULL,
  `salesman_address` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `ph_number` varchar(255) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`salesman_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesman`
--

INSERT INTO `salesman` (`salesman_id`, `salesman_name`, `salesman_address`, `description`, `ph_number`, `date`) VALUES (1,'saleem sb','kamalia','&lt;p&gt;&lt;strong&gt;Test 2&lt;/strong&gt;&lt;/p&gt;','0323-7688036','2020-04-01 13:24:46');

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_name` varchar(255) DEFAULT NULL,
  `section_address` text DEFAULT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`section_id`, `section_name`, `section_address`) VALUES (1,'Factory','Faisalabad');

--
-- Table structure for table `service_invoice`
--

CREATE TABLE `service_invoice` (
  `service_invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `type` enum('Purchase','Sale','Sale Return','Purchase Return') DEFAULT NULL,
  `batch_no` varchar(255) DEFAULT NULL,
  `total_discount` decimal(18,2) DEFAULT 0.00,
  `payment_method` enum('Cash','Bank') DEFAULT NULL,
  `invoice_total` decimal(18,2) NOT NULL DEFAULT 0.00,
  `payment_status` enum('Confirmed','Pending') DEFAULT NULL,
  `description` text DEFAULT NULL,
  `date_created` timestamp NOT NULL DEFAULT current_timestamp(),
  `invoice_no` varchar(50) DEFAULT NULL,
  `bag` varchar(255) DEFAULT NULL,
  `carton` varchar(255) DEFAULT NULL,
  `cargo` varchar(255) DEFAULT NULL,
  `builty_no` varchar(255) DEFAULT NULL COMMENT 'This is invoice no generated by party',
  `voucher_no` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `driver_name` varchar(255) DEFAULT NULL,
  `mobile_no` varchar(255) DEFAULT NULL,
  `return_invoice_id` int(11) DEFAULT NULL,
  `tax` decimal(18,2) DEFAULT NULL,
  `return_invoice_no` varchar(55) DEFAULT NULL,
  PRIMARY KEY (`service_invoice_id`),
  KEY `return_invoice_id` (`return_invoice_id`),
  KEY `tax` (`tax`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `service_invoice`
--


--
-- Table structure for table `service_invoice_items`
--

CREATE TABLE `service_invoice_items` (
  `service_invoice_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_invoice_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `qty` decimal(18,2) DEFAULT NULL,
  `discount` decimal(18,2) DEFAULT 0.00,
  `batch` varchar(255) DEFAULT NULL,
  `product_sale_price` decimal(18,2) DEFAULT NULL,
  `product_purchase_price` decimal(18,2) DEFAULT NULL,
  `invoice_subtotal` decimal(18,2) DEFAULT 0.00,
  PRIMARY KEY (`service_invoice_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `service_invoice_items`
--


--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(255) DEFAULT NULL,
  `service_amount` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services`
--


--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `unit_id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_name` varchar(255) DEFAULT NULL,
  `unit_symbol` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`unit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`unit_id`, `unit_name`, `unit_symbol`) VALUES (1,'Roll','Roll'),(2,'Box','Box'),(3,'Pieces','Pcs'),(4,'Dozens','Doz'),(5,'Bottle','Bottle'),(6,'Tube','Tube'),(7,'inches','inches'),(8,'meter','mt'),(9,'centi meter','cm'),(10,'Kilogram','Kg'),(11,'cans','cans'),(12,'bags','bags'),(13,'plastic drums','plastic drums'),(14,'carton','carton'),(15,'iron drum','iron drum'),(16,'gram','gram'),(17,'bundle','bundle'),(18,'reel','reel'),(19,'mili liter','ml'),(20,'Liters','ltr.'),(21,'Packets','Packets'),(22,'Gazz','Y'),(23,'Caps','caps'),(24,'Maund','maund'),(25,'Sachets','sachet'),(26,'Rim','rim'),(27,'Beam','beam'),(28,'Than','Than'),(29,'RS','Rs'),(30,'Feet','ft'),(31,'Square Feet','Sq.ft');

--
-- Table structure for table `user_group_modules`
--

CREATE TABLE `user_group_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group_id` int(11) DEFAULT NULL,
  `module_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_group_modules`
--

INSERT INTO `user_group_modules` (`id`, `user_group_id`, `module_id`) VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(12,1,12),(13,1,13),(14,1,14),(15,1,15),(16,1,16),(17,1,17),(18,1,18),(19,1,19),(22,1,22),(23,1,23),(24,1,24),(25,1,25),(26,1,26),(27,1,27),(28,1,28),(29,1,29),(30,1,30),(31,1,31),(32,1,32),(33,2,10),(35,3,1),(41,3,5),(46,3,10),(47,3,11),(48,3,12),(50,1,33),(51,2,33),(52,3,26),(53,1,34),(54,1,35),(55,1,36),(56,1,37),(57,1,38),(58,1,39),(59,1,40),(60,1,41),(61,1,42),(62,1,43),(63,1,44),(64,1,45),(65,1,46),(66,1,47),(67,1,48),(68,1,49),(69,1,50),(70,1,51),(71,1,52),(72,1,53),(73,1,54),(74,1,55),(76,3,28),(77,3,29),(79,1,56),(80,1,57),(82,3,0),(83,3,33),(85,1,58),(86,1,59),(87,2,59),(88,3,61),(89,3,59),(91,1,60),(92,1,61),(94,3,37),(95,1,62),(96,1,63),(97,1,64),(98,1,65),(101,3,60),(102,5,55),(103,5,56),(104,5,57),(105,5,63),(106,5,64),(107,3,14),(108,3,30),(109,3,19),(110,3,54),(111,1,66),(113,2,37),(114,4,12),(115,4,60),(116,4,55),(117,4,56),(118,4,57),(119,2,1),(120,2,29),(121,2,7),(122,2,35),(123,1,67),(124,1,68),(125,1,69),(129,4,70),(130,3,70),(132,1,70),(133,2,31),(134,2,14),(135,6,1),(136,6,44),(137,6,45),(138,6,46),(139,6,47),(140,6,48),(141,6,49),(142,1,71),(143,1,72),(144,1,73),(145,1,74),(146,1,75);

--
-- Table structure for table `user_groups`
--

CREATE TABLE `user_groups` (
  `user_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`user_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_groups`
--

INSERT INTO `user_groups` (`user_group_id`, `user_group`, `status`) VALUES (1,'Administrator',1),(2,'Sales',1),(3,'Manager',1),(4,'Production & Sale',1),(5,'Reception',1),(6,'HRM',1);

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `warehouse_id` int(11) NOT NULL AUTO_INCREMENT,
  `warehouse_name` varchar(255) DEFAULT NULL,
  `warehouse_address` text DEFAULT NULL,
  PRIMARY KEY (`warehouse_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `warehouses`
--

INSERT INTO `warehouses` (`warehouse_id`, `warehouse_name`, `warehouse_address`) VALUES (1,'Shop','Shop');

--
-- Dumping events for database 'faisalanwar_zain'
--

--
-- Dumping routines for database 'faisalanwar_zain'
--


