--
-- Host: localhost    Database: pelita.dev
-- ------------------------------------------------------


--
-- Table structure for table `_ref_acct_group`
--

CREATE TABLE `_ref_acct_group` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `acctTypeID` int(11) NOT NULL,
  `acctGroupName` varchar(128) NOT NULL,
  `acctCode` char(9) NOT NULL,
  `orderNo` int(11) DEFAULT NULL,
  `parentID` int(11) DEFAULT NULL,
  `title` tinyint(4) DEFAULT '0',
  `status` tinyint(4) DEFAULT '0',
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`),
  KEY `ID_2` (`ID`),
  KEY `acctCode` (`acctCode`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_ref_acct_group`
--

INSERT INTO `_ref_acct_group` VALUES (1,5,'CapitalRetainedEarnings','1200',40,40,1,1,1,'2014-05-29 15:47:09',0,'2014-09-23 17:26:31'),(2,1,'FixedAssets','1200',10,42,1,0,1,'2014-05-29 15:47:09',0,'2014-09-21 09:32:35'),(3,1,'CurrentAssets','1200',30,39,1,0,1,'2014-05-29 15:47:09',0,'2014-09-21 09:32:35'),(4,2,'CurrentLiabilities','1200',40,39,1,1,1,'2014-05-29 15:47:09',0,'2014-09-21 09:32:35'),(5,2,'OtherLiabilites','1200',70,40,1,1,1,'2014-05-29 15:47:09',0,'2014-09-21 09:32:35'),(6,2,'LongTermLiabilities','1200',50,40,1,1,1,'2014-05-29 15:47:09',0,'2014-09-21 09:32:35'),(7,3,'revenue','1200',1,33,1,1,1,'2014-05-29 15:47:09',0,'2016-08-31 18:49:04'),(8,4,'COGS','1200',2,33,1,0,1,'2014-05-29 15:47:09',0,'2016-08-31 18:49:14'),(9,3,'othersincome','1200',1,35,1,1,1,'2014-12-18 16:23:01',0,'2016-08-31 18:50:35'),(10,4,'operatingexpenses','1200',2,35,1,0,1,'2014-05-29 15:47:09',0,'2016-08-31 18:50:37'),(12,4,'taxation','1200',400,38,1,0,1,'2014-05-29 15:47:09',0,'2014-09-21 09:32:35'),(31,1,'OthersAssets','1200',20,42,1,0,1,'2014-05-29 15:47:09',0,'2014-09-21 09:32:35'),(32,4,'otheroperatingexpenses','1200',500,35,1,0,1,'2014-05-29 15:47:09',0,'2016-08-31 18:37:16'),(33,3,'grossprofit','1200',100,34,1,1,1,'2014-05-29 15:47:09',0,'2016-09-27 03:40:24'),(34,3,'operatingprofit','1200',1,0,0,0,1,'2014-05-29 15:47:09',0,'2016-09-27 03:40:51'),(35,3,'operatingincome','1200',130,34,1,1,1,'2014-05-29 15:47:09',0,'2016-09-27 03:40:24'),(36,3,'financeincome','1200',20,43,1,1,1,'2014-05-29 15:47:09',0,'2016-08-31 18:35:55'),(37,4,'profitNlossb4tax','1200',2,0,1,0,1,'2014-05-29 15:47:09',0,'2016-09-27 03:40:24'),(38,4,'currentyear','1200',3,0,1,0,1,'2014-05-29 15:47:09',0,'2016-09-27 03:40:24'),(39,1,'NetCurrent','1200',30,42,1,0,1,'2014-05-29 15:47:09',0,'2016-09-27 03:40:24'),(40,2,'LiabilitiesNCapital','1200',50,0,1,1,0,'2014-08-26 16:53:04',0,'2016-09-27 03:40:24'),(42,1,'AssetNLiability','1200',30,0,1,0,0,'2014-09-02 11:27:27',0,'2016-09-27 03:40:24'),(43,4,'financeIncomeCost','1200',20,37,0,0,1,'2014-10-27 11:57:42',1,'2016-09-27 03:40:55'),(44,4,'financeCost','1200',30,43,1,0,1,'2014-05-29 15:47:09',0,'2014-10-27 11:59:05'),(45,6,'current','1200',1,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(46,6,'cash','1200',2,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(47,6,'assetturnover','1200',3,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(48,6,'tradereceivablesturnover','1200',4,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(49,6,'tradepayableturnover','1200',5,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(50,6,'debt','1200',6,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(51,7,'grossprofitmargin','1200',1,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(52,7,'operatingmargin','1200',2,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(53,7,'netprofitmargin','1200',3,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24'),(54,7,'returnofequity','1200',4,NULL,1,0,0,'2016-08-29 02:53:56',0,'2016-09-27 03:40:24');

--
-- Table structure for table `_ref_business_type`
--

CREATE TABLE `_ref_business_type` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `industryID` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_ref_business_type`
--

INSERT INTO `_ref_business_type` VALUES (1,1,'General',1,'2014-05-06 01:32:56',0,'2015-03-05 04:14:36'),(2,2,'Audio Visual',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(3,2,'Bakery',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(4,2,'Cafe',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(5,2,'Car Dealer',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(6,2,'Furniture Dealer',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(7,2,'Gift Shop',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(8,2,'Hardware Store',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(9,2,'Restaurant',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(10,2,'Video Store',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(11,3,'Accounting Firm',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(12,3,'Advertising Agency',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(13,3,'Architect',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(14,3,'Banquet Facilty',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(15,3,'Beauty Salon',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(16,3,'Cleaning Services',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(17,3,'Construction Company',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(18,3,'Education Institution',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(19,3,'Financial Services',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(20,3,'Insurance Agency',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(21,3,'Legal Firm',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(22,3,'Non-profit Organization',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(23,3,'Travel Agency',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(24,4,'Partnership',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(25,4,'sole Proprietorship',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(26,4,'Wholesale Business',1,'2014-05-06 01:32:56',0,'0000-00-00 00:00:00'),(28,3,'Bekalan Air',1,'2016-07-14 03:36:42',0,'0000-00-00 00:00:00'),(29,3,'SALIHIN',0,'2018-01-30 03:16:53',0,'0000-00-00 00:00:00');

--
-- Table structure for table `_ref_chart_of_acct`
--

CREATE TABLE `_ref_chart_of_acct` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `businessTypeID` int(11) NOT NULL,
  `acctGroupID` int(11) NOT NULL,
  `acctCode` char(9) NOT NULL,
  `parentID` int(11) NOT NULL,
  `acctName` varchar(128) NOT NULL,
  `acctDescription` varchar(128) NOT NULL,
  `defaultID` int(11) DEFAULT NULL COMMENT 'id default acct for general setup',
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_ref_chart_of_acct`
--

INSERT INTO `_ref_chart_of_acct` VALUES (1,1,1,'110000000',0,'Share Capital','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(2,1,1,'120000000',0,'Retained Earnings-Prior Year','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(3,1,1,'130000000',0,'Current Year Earnings','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(4,1,2,'200000000',0,'Property, Plant & Equipment','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(5,1,2,'200010000',0,'Intangible Assets','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(6,1,2,'200020000',0,'Deferred Tax Assets','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(7,1,3,'230100000',0,'Inventories','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(8,1,3,'230200000',0,'Trade Receivables','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(9,1,3,'230200100',0,'Other Receivables','',NULL,0,'2016-08-10 10:07:05',0,'2016-08-25 10:01:30'),(10,1,3,'230300000',0,'Tax Receivables','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(11,1,3,'230400000',0,'Amount Due From Director','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(12,1,3,'230500000',0,'Amount Due From Related Companies','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(13,1,3,'230600000',0,'Fixed Deposits','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(14,1,3,'230700000',0,'Cash & Bank Balances','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(15,1,4,'300000000',0,'Trade Payable','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(16,1,4,'310000000',0,'Other Payables & Accruals','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(17,1,4,'32000000',0,'Tax Payable','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(18,1,4,'330000000',0,'Bank Overdraft','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(19,1,4,'340000000',0,'Bankers\' Acceptance','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(20,1,4,'350000000',0,'Term Loans','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(21,1,4,'360000000',0,'Provision For Taxation','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(22,1,6,'370000000',0,'Long-Term Liabilities','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(23,1,6,'380000000',0,'Deferred Tax Liabilities','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(24,1,7,'400000000',0,'Revenue','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(25,1,8,'500000000',0,'Direct Expenses','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(26,1,9,'700000000',0,'Other Income','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(27,1,10,'810000000',0,'Administration Expenses','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(28,1,10,'820000000',0,'Other Operating Expenses','',NULL,0,'2016-08-10 10:07:05',0,'2016-09-01 04:15:50'),(29,1,44,'830000000',0,'Finance Cost','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(30,1,12,'840000000',0,'Taxation','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(31,2,1,'110000000',0,'Modal Saham','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(32,2,1,'120000000',0,'Keuntungan Tertahan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(33,2,1,'130000000',0,'Pendapatan Tahun Semasa','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(34,2,2,'200000000',0,'Hartanah, Loji & Peralatan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(35,2,2,'200010000',0,'Aset Tak Nyata','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(36,2,2,'200020000',0,'Aset Cukai Tertunda','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(37,2,3,'230100000',0,'Inventori','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(38,2,3,'230200000',0,'Penghutang Dagangan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(39,2,3,'230200100',0,'Lain-lain Penghutang','',NULL,0,'2016-08-10 10:07:05',0,'2016-08-25 10:01:41'),(40,2,3,'230300000',0,'Cukai Belum Terima','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(41,2,3,'230400000',0,'Jumlah Terhutang Daripada Pengarah','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(42,2,3,'230500000',0,'Jumlah Terhutang Daripada Syarikat','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(43,2,3,'230600000',0,'Deposit Tetap','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(44,2,3,'230700000',0,'Baki Tunai & Di Bank','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(45,2,4,'300000000',0,'Pemiutang','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(46,2,4,'310000000',0,'Lain-lain Pemiutang & Terakru','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(47,2,4,'32000000',0,'Cukai Kena Bayar','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(48,2,4,'330000000',0,'Overdraf Bank','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(49,2,4,'340000000',0,'Penerimaan Oleh Bank','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(50,2,4,'350000000',0,'Pinjaman Berjangka','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(51,2,4,'360000000',0,'Peruntukan Cukai','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(52,2,6,'370000000',0,'Liabiliti Jangka Panjang','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(53,2,6,'380000000',0,'Liabiliti Cukai Tertunda','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(54,2,7,'400000000',0,'Pendapatan / Hasil / Perolehan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(55,2,8,'500000000',0,'Kos Jualan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(56,2,9,'700000000',0,'Lain-lain Pendapatan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(57,2,10,'810000000',0,'Belanja Pentadbiran','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(58,2,10,'820000000',0,'Lain-lain Belanja Operasi','',NULL,0,'2016-08-10 10:07:05',0,'2016-09-01 04:15:53'),(59,2,44,'830000000',0,'Kos Kewangan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(60,2,12,'840000000',0,'Perbelanjaan Cukai Pendapatan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(61,2,4,'311000000',0,'Jumlah Pemiutang Daripada Pengarah','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(62,2,4,'312000000',0,'Jumlah Pemiutang Daripada Syarikat','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(63,2,2,'200030000',0,'Lain-lain Pelaburan','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00'),(64,2,1,'111000000',0,'Saham Premium','',NULL,0,'2016-08-10 10:07:05',0,'0000-00-00 00:00:00');

--
-- Table structure for table `audit_scope`
--

CREATE TABLE `audit_scope` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `scope` text NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audit_scope`
--

INSERT INTO `audit_scope` VALUES (1,'To review of the compliance to the concluded Joint Venture Agreement by the respective defined parties, in respect to the followings :',0,0,'2020-01-29 08:18:12',0,'0000-00-00 00:00:00'),(2,'To review operational performance of the projects since its inception at the spirit of the concluded agreements, in respect to the followings:\n',0,0,'2020-01-29 02:30:43',0,'0000-00-00 00:00:00'),(3,'To review financial performance of the projects since its inception at the spirit of the concluded agreements, in respect to the followings:\n',0,0,'2020-01-29 02:30:56',0,'0000-00-00 00:00:00'),(4,'To review the current governance structure and monitoring mechanism of the projects',0,0,'2020-01-28 09:24:30',0,'0000-00-00 00:00:00'),(5,'To benchmark the operational and planting practices as well as the yield and productivity of companies / projects against best industry practices and indicators',0,0,'2020-01-29 02:31:30',0,'0000-00-00 00:00:00'),(6,'To recommend measure to increase revenue of the companies',0,0,'2020-01-28 09:24:30',0,'0000-00-00 00:00:00'),(7,'To examine the sustainability and long-term viability of the existing business model',0,0,'2020-01-29 08:18:43',0,'0000-00-00 00:00:00'),(8,'To examine the effectiveness of the existing compliance and reporting mechanism',0,0,'2020-01-28 09:24:30',0,'0000-00-00 00:00:00'),(9,'To examine the organizational capacity of PELITA in monitoring and supervising the various projects development',0,0,'2020-01-28 09:24:30',0,'0000-00-00 00:00:00'),(10,'To define and elaborate on the noted exception, pertinent matter and finding based on the review performed as defined in the earlier paragraph',0,0,'2020-01-29 08:19:21',0,'0000-00-00 00:00:00'),(11,'To propose for corrective action and recommendations for improvements in respects to vision, direction, policy frameworks, strategies, approaches, implementation, new legislation and effective action plans of the projects',0,0,'2020-01-29 02:32:42',0,'0000-00-00 00:00:00');

--
-- Table structure for table `audit_scope_details`
--

CREATE TABLE `audit_scope_details` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `scope_id` int(11) NOT NULL,
  `details_number` int(11) NOT NULL,
  `scope_details` varchar(128) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audit_scope_details`
--

INSERT INTO `audit_scope_details` VALUES (1,1,1,'Fulfillment of Condition Precedent',0,0,'2020-01-29 07:14:19',0,'0000-00-00 00:00:00'),(2,1,2,'Incorporation, governance, & responsibilities of Joint Venture Company (\"JVC\")',0,0,'2020-01-29 07:40:25',0,'0000-00-00 00:00:00'),(3,1,3,'Equity Structure & Shares Allotment of JVC',0,0,'2020-01-29 07:15:08',0,'0000-00-00 00:00:00'),(4,1,4,'PELITA\'s right, representations & warranties, and duties & responsibilities',0,0,'2020-01-29 07:40:45',0,'0000-00-00 00:00:00'),(5,1,5,'Investor\'s right, representations & warranties, and duties & responsibilities',0,0,'2020-01-29 07:40:54',0,'0000-00-00 00:00:00'),(6,1,6,'Acts to be done by Parties',0,0,'2020-01-29 07:15:21',0,'0000-00-00 00:00:00'),(7,1,7,'The JVS\'s Business & Financing',0,0,'2020-01-29 07:41:01',0,'0000-00-00 00:00:00'),(8,1,8,'Dividend Policy',0,0,'2020-01-29 07:15:30',0,'0000-00-00 00:00:00'),(9,2,1,'Development of Plantation',0,0,'2020-01-29 07:15:38',0,'0000-00-00 00:00:00'),(10,2,2,'Replanting',0,0,'2020-01-29 07:15:42',0,'0000-00-00 00:00:00'),(11,2,3,'Nursery',0,0,'2020-01-29 07:15:48',0,'0000-00-00 00:00:00'),(12,2,4,'Planting',0,0,'2020-01-29 07:15:51',0,'0000-00-00 00:00:00'),(13,2,5,'Harvesting',0,0,'2020-01-29 07:15:55',0,'0000-00-00 00:00:00'),(14,2,6,'Oil Mill Operations',0,0,'2020-01-29 07:15:58',0,'0000-00-00 00:00:00'),(15,2,7,'Milling Operations',0,0,'2020-01-29 07:16:02',0,'0000-00-00 00:00:00'),(16,2,8,'Engineering Stores',0,0,'2020-01-29 07:16:05',0,'0000-00-00 00:00:00'),(17,2,9,'Plant & Equipment Maintenance',0,0,'2020-01-29 07:16:09',0,'0000-00-00 00:00:00'),(18,2,10,'Processing FFB for CPO & KERNEL',0,0,'2020-01-29 08:13:50',0,'0000-00-00 00:00:00'),(19,2,11,'Stock Controls',0,0,'2020-01-29 07:16:21',0,'0000-00-00 00:00:00'),(20,2,12,'Sales & Dispatch of CPO & KERNEL',0,0,'2020-01-29 07:16:25',0,'0000-00-00 00:00:00'),(21,2,13,'Check Roll Operations',0,0,'2020-01-29 07:16:31',0,'0000-00-00 00:00:00'),(22,3,1,'Statements of Financial Position',0,0,'2020-01-29 08:14:22',0,'0000-00-00 00:00:00'),(23,3,2,'Statements of Comprehensive Income',0,0,'2020-01-29 08:14:27',0,'0000-00-00 00:00:00'),(24,3,3,'Financial Ratios',0,0,'2020-01-29 07:16:53',0,'0000-00-00 00:00:00'),(25,3,4,'Financial Account Treatment',0,0,'2020-02-13 01:11:24',0,'0000-00-00 00:00:00'),(26,3,5,'Statement of Cash Flow',0,0,'2020-02-13 01:11:24',0,'0000-00-00 00:00:00'),(27,3,6,'Inter/intra party transactions, its extent and appropriateness',0,0,'2020-02-13 01:11:24',0,'0000-00-00 00:00:00'),(28,3,7,'Plantation development/operating cost structure',0,0,'2020-02-13 01:11:24',0,'0000-00-00 00:00:00');

--
-- Table structure for table `audit_working`
--

CREATE TABLE `audit_working` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `scope_id` int(11) NOT NULL,
  `scope_details_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `status` int(11) NOT NULL COMMENT '0 = open, 1 = close',
  `reason_reopening` text NOT NULL,
  `comment` text NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `audit_working`
--

INSERT INTO `audit_working` VALUES (1,1,1,1,'<pre>\nType your preference here. aizat.. <span style=\"font-family:Century Gothic\">Century Gothic Font</span></pre>\n',1,'dfsdfsdfsd','',0,0,'2020-03-02 00:49:03',265,'2020-02-19 08:01:06'),(2,1,1,2,'',1,'try close','',0,0,'2020-02-13 00:49:03',265,'2020-02-13 00:49:03'),(3,7,1,8,'',0,'','',0,0,'2020-02-06 02:37:32',0,'0000-00-00 00:00:00'),(4,1,3,22,'',0,'','',0,0,'2020-02-06 02:41:41',0,'0000-00-00 00:00:00'),(5,1,3,24,'',0,'','',0,0,'2020-02-06 02:42:36',0,'0000-00-00 00:00:00'),(6,1,6,0,'<p>test to check if post at &quot;requiremenDetails/1/6/0&quot;, does it appear at others &quot;requiremenDetails/1/scope_id/0&quot;.</p>\n',0,'','',0,0,'2020-03-02 00:48:58',0,'0000-00-00 00:00:00'),(7,1,1,3,'<p>this is the testing for this page.asdasdasd</p>\n',1,'Saja','',0,19,'2020-03-02 00:49:14',19,'2020-02-13 07:48:30'),(8,1,1,6,'<p><span style=\"font-family:Century Gothic\">Using century gothic font for testing&nbsp;</span></p>\n',0,'bukak jap\r\n','',0,19,'2020-03-02 00:49:11',265,'2020-02-14 02:23:08'),(9,1,1,8,'',0,'trtrtr','',0,19,'2020-02-17 01:19:23',309,'2020-02-17 01:19:23'),(10,1,1,7,'',1,'','',0,19,'2020-02-11 06:12:33',265,'2020-02-11 06:12:33'),(11,7,1,1,'',0,'','',0,79,'2020-02-06 06:05:56',0,'0000-00-00 00:00:00'),(12,1,1,4,'<p><span style=\"font-family:Century Gothic\">testtt&nbsp;</span>sdfsdfsd&nbsp;<span style=\"font-family:Comic Sans MS,cursive\">sdfsdfsdf</span></p>\n',0,'try open','',0,19,'2020-03-02 00:49:08',24,'2020-02-13 01:23:56'),(13,1,1,5,'',1,'','',0,19,'2020-02-12 08:31:14',24,'2020-02-12 08:31:14'),(14,8,1,1,'',1,'','',0,19,'2020-02-12 08:33:05',265,'2020-02-12 08:33:05'),(15,8,1,2,'',0,'','',0,19,'2020-02-06 06:16:29',0,'0000-00-00 00:00:00'),(16,8,1,3,'',0,'','',0,19,'2020-02-06 06:18:19',0,'0000-00-00 00:00:00'),(17,8,1,4,'',0,'','',0,19,'2020-02-06 06:30:41',0,'0000-00-00 00:00:00'),(18,8,1,5,'',0,'','',0,19,'2020-02-06 06:31:37',0,'0000-00-00 00:00:00'),(19,8,1,6,'',0,'','',0,19,'2020-02-06 06:32:29',0,'0000-00-00 00:00:00'),(20,8,1,7,'',0,'','',0,19,'2020-02-06 06:32:39',0,'0000-00-00 00:00:00'),(21,8,1,8,'',0,'','',0,19,'2020-02-06 06:32:54',0,'0000-00-00 00:00:00'),(22,5,3,23,'',0,'','',0,242,'2020-02-06 07:57:00',0,'0000-00-00 00:00:00'),(23,5,1,8,'',0,'','',0,242,'2020-02-06 08:00:26',0,'0000-00-00 00:00:00'),(24,5,1,7,'',0,'','',0,242,'2020-02-06 08:01:53',0,'0000-00-00 00:00:00'),(25,5,1,2,'',0,'','',0,242,'2020-02-06 08:02:40',0,'0000-00-00 00:00:00'),(28,5,1,5,'',0,'','',0,242,'2020-02-06 08:12:56',0,'0000-00-00 00:00:00'),(29,5,1,4,'',0,'','',0,242,'2020-02-06 08:15:23',0,'0000-00-00 00:00:00'),(30,5,2,9,'',0,'','',0,242,'2020-02-06 08:17:21',0,'0000-00-00 00:00:00'),(31,5,2,12,'',0,'','',0,242,'2020-02-06 08:19:09',0,'0000-00-00 00:00:00'),(32,2,1,2,'',0,'','',0,242,'2020-02-06 08:55:02',0,'0000-00-00 00:00:00'),(33,6,1,4,'',0,'','',0,242,'2020-02-06 10:36:32',0,'0000-00-00 00:00:00'),(34,7,1,4,'',0,'','',0,242,'2020-02-06 10:36:47',0,'0000-00-00 00:00:00'),(35,4,2,10,'',0,'','',0,242,'2020-02-07 03:25:33',0,'0000-00-00 00:00:00'),(36,4,1,3,'',0,'','',0,242,'2020-02-07 03:28:20',0,'0000-00-00 00:00:00'),(37,2,1,1,'',0,'fafafa','',0,79,'2020-02-17 01:02:56',265,'2020-02-14 04:19:13'),(38,6,1,8,'<p>test</p>\r\n',0,'','',0,265,'2020-02-10 02:50:16',265,'2020-02-10 02:50:16'),(39,2,2,9,'',0,' sdfsdf  ddfgdfg','',0,265,'2020-02-11 07:28:53',265,'2020-02-11 07:28:53'),(40,2,1,3,'',0,' Testing reason  2','',0,242,'2020-02-12 07:30:29',265,'2020-02-12 07:30:29'),(41,5,3,22,'<p>Anything you want to talk about. Please write it here.&nbsp;</p>\r\n',0,'','',0,265,'2020-02-10 07:24:15',0,'0000-00-00 00:00:00'),(42,1,2,9,'',1,'','',0,265,'2020-02-10 09:13:20',265,'2020-02-10 09:13:20'),(43,1,2,10,'',0,'','',0,19,'2020-02-10 09:00:11',0,'0000-00-00 00:00:00'),(44,8,4,0,'',0,'','',0,19,'2020-02-10 09:01:38',0,'0000-00-00 00:00:00'),(45,3,1,8,'',0,'','',0,242,'2020-02-10 09:12:16',0,'0000-00-00 00:00:00'),(46,2,4,0,'',0,'','',0,304,'2020-02-11 02:30:57',0,'0000-00-00 00:00:00'),(47,2,1,4,'',0,'','',0,242,'2020-02-11 04:16:22',0,'0000-00-00 00:00:00'),(48,2,1,5,'',0,'','',0,242,'2020-02-11 04:16:24',0,'0000-00-00 00:00:00'),(49,2,1,6,'',0,'','',0,242,'2020-02-11 04:16:25',0,'0000-00-00 00:00:00'),(50,2,1,7,'',0,'','',0,242,'2020-02-11 04:16:26',0,'0000-00-00 00:00:00'),(51,2,1,8,'',0,'','',0,242,'2020-02-11 04:16:27',0,'0000-00-00 00:00:00'),(52,2,2,10,'',0,'','',0,304,'2020-02-11 04:31:43',0,'0000-00-00 00:00:00'),(53,2,2,11,'',0,'','',0,304,'2020-02-11 04:31:45',0,'0000-00-00 00:00:00'),(54,2,2,21,'',0,'','',0,304,'2020-02-11 04:32:06',0,'0000-00-00 00:00:00'),(55,2,2,20,'',0,'','',0,304,'2020-02-11 04:33:05',0,'0000-00-00 00:00:00'),(56,2,3,22,'',0,'','',0,304,'2020-02-11 04:33:23',0,'0000-00-00 00:00:00'),(57,2,3,23,'',0,'','',0,304,'2020-02-11 04:33:37',0,'0000-00-00 00:00:00'),(58,2,3,24,'',0,'','',0,304,'2020-02-11 04:33:43',0,'0000-00-00 00:00:00'),(59,13,1,1,'',1,'','',0,265,'2020-02-11 06:09:27',265,'2020-02-11 06:09:27'),(60,3,1,1,'',0,'','',0,24,'2020-02-11 04:36:54',0,'0000-00-00 00:00:00'),(61,2,4,0,'',0,'','',0,304,'2020-02-12 06:52:55',0,'0000-00-00 00:00:00'),(62,16,1,2,'',1,'','',0,265,'2020-02-11 06:24:39',265,'2020-02-11 06:24:39'),(63,2,2,12,'',0,'','',0,304,'2020-02-11 06:38:15',0,'0000-00-00 00:00:00'),(64,2,2,13,'',0,'','',0,304,'2020-02-11 06:38:17',0,'0000-00-00 00:00:00'),(65,2,2,14,'',0,'','',0,304,'2020-02-11 06:38:20',0,'0000-00-00 00:00:00'),(66,2,2,15,'',0,'','',0,304,'2020-02-11 06:38:23',0,'0000-00-00 00:00:00'),(67,2,2,16,'',0,'','',0,304,'2020-02-11 06:38:24',0,'0000-00-00 00:00:00'),(68,2,2,17,'',0,'','',0,304,'2020-02-11 06:38:25',0,'0000-00-00 00:00:00'),(69,2,2,18,'',0,'','',0,304,'2020-02-11 06:38:27',0,'0000-00-00 00:00:00'),(70,2,2,19,'',0,'','',0,304,'2020-02-11 06:38:28',0,'0000-00-00 00:00:00'),(71,16,1,8,'',0,'','',0,24,'2020-02-11 06:57:04',0,'0000-00-00 00:00:00'),(72,16,2,9,'',0,'','',0,24,'2020-02-12 06:45:44',0,'0000-00-00 00:00:00'),(73,16,2,10,'',0,'','',0,24,'2020-02-12 06:45:57',0,'0000-00-00 00:00:00'),(74,16,2,11,'',0,'','',0,24,'2020-02-12 06:45:59',0,'0000-00-00 00:00:00'),(75,1,2,11,'',0,'','',0,304,'2020-02-11 07:48:00',0,'0000-00-00 00:00:00'),(76,1,2,12,'',0,'','',0,304,'2020-02-11 07:48:01',0,'0000-00-00 00:00:00'),(77,1,2,13,'',0,'','',0,304,'2020-02-11 07:48:02',0,'0000-00-00 00:00:00'),(78,1,2,14,'',0,'','',0,304,'2020-02-11 07:48:03',0,'0000-00-00 00:00:00'),(79,1,2,15,'',0,'','',0,304,'2020-02-11 07:48:04',0,'0000-00-00 00:00:00'),(80,1,2,16,'',0,'','',0,304,'2020-02-11 07:48:05',0,'0000-00-00 00:00:00'),(81,1,2,17,'',0,'','',0,304,'2020-02-11 07:48:06',0,'0000-00-00 00:00:00'),(82,1,2,18,'',0,'','',0,304,'2020-02-11 07:48:06',0,'0000-00-00 00:00:00'),(83,1,2,19,'',1,' test sahaja  yaaa','',0,304,'2020-02-12 07:24:27',24,'2020-02-12 07:24:27'),(84,1,2,20,'',0,'','',0,304,'2020-02-11 07:48:08',0,'0000-00-00 00:00:00'),(85,1,2,21,'',0,'','',0,304,'2020-02-11 07:48:09',0,'0000-00-00 00:00:00'),(86,1,3,23,'',0,'','',0,304,'2020-02-11 07:49:08',0,'0000-00-00 00:00:00'),(87,16,1,1,'',0,'','',0,304,'2020-02-12 01:05:24',0,'0000-00-00 00:00:00'),(88,16,1,3,'',0,'','',0,304,'2020-02-12 01:05:30',0,'0000-00-00 00:00:00'),(89,16,1,4,'',0,'','',0,304,'2020-02-12 01:05:34',0,'0000-00-00 00:00:00'),(90,16,1,5,'',0,'','',0,304,'2020-02-12 01:05:37',0,'0000-00-00 00:00:00'),(91,16,1,6,'',0,'','',0,304,'2020-02-12 01:05:39',0,'0000-00-00 00:00:00'),(92,16,1,7,'',0,'','',0,304,'2020-02-12 01:05:40',0,'0000-00-00 00:00:00'),(93,16,3,24,'',0,'','',0,304,'2020-02-12 06:52:32',0,'0000-00-00 00:00:00'),(94,16,3,23,'',0,'','',0,304,'2020-02-12 06:52:33',0,'0000-00-00 00:00:00'),(95,16,3,22,'',0,'','',0,304,'2020-02-12 06:52:35',0,'0000-00-00 00:00:00'),(96,16,2,21,'',0,'','',0,304,'2020-02-12 06:46:02',0,'0000-00-00 00:00:00'),(97,16,4,0,'',0,'','',0,304,'2020-02-12 01:06:50',0,'0000-00-00 00:00:00'),(98,12,1,7,'',0,'','',0,24,'2020-02-12 01:10:14',0,'0000-00-00 00:00:00'),(99,4,1,1,'',0,'','',0,24,'2020-02-12 01:33:24',0,'0000-00-00 00:00:00'),(100,4,2,13,'',0,'','',0,24,'2020-02-12 01:33:34',0,'0000-00-00 00:00:00'),(101,4,1,6,'',0,'','',0,24,'2020-02-12 01:33:42',0,'0000-00-00 00:00:00'),(102,4,2,11,'',0,'','',0,24,'2020-02-12 01:34:04',0,'0000-00-00 00:00:00'),(103,4,1,5,'',0,'','',0,24,'2020-02-12 01:35:25',0,'0000-00-00 00:00:00'),(104,4,1,7,'',0,'','',0,24,'2020-02-12 01:36:51',0,'0000-00-00 00:00:00'),(105,4,1,8,'',0,'','',0,24,'2020-02-12 01:36:53',0,'0000-00-00 00:00:00'),(106,13,1,4,'',0,'','',0,242,'2020-02-12 02:41:24',0,'0000-00-00 00:00:00'),(107,16,2,16,'',0,'','',0,242,'2020-02-12 06:39:51',0,'0000-00-00 00:00:00'),(108,3,1,6,'',0,'','',0,242,'2020-02-12 06:43:23',0,'0000-00-00 00:00:00'),(109,3,1,5,'',0,'','',0,242,'2020-02-12 06:43:56',0,'0000-00-00 00:00:00'),(110,3,2,13,'',0,'','',0,242,'2020-02-12 06:44:17',0,'0000-00-00 00:00:00'),(111,3,2,16,'',0,'','',0,242,'2020-02-12 06:44:25',0,'0000-00-00 00:00:00'),(112,3,2,10,'',0,'','',0,242,'2020-02-12 06:44:57',0,'0000-00-00 00:00:00'),(113,3,1,4,'',0,'','',0,242,'2020-02-12 07:02:14',0,'0000-00-00 00:00:00'),(114,7,1,6,'',0,'','',0,265,'2020-02-12 07:14:33',0,'0000-00-00 00:00:00'),(117,3,10,0,'',0,'','',0,242,'2020-02-12 07:19:49',0,'0000-00-00 00:00:00'),(118,3,4,0,'<p>Audit working term 4&nbsp;</p>\r\n',0,'','',0,242,'2020-02-13 01:50:58',0,'0000-00-00 00:00:00'),(119,3,1,2,'',0,'','',0,242,'2020-02-12 07:23:17',0,'0000-00-00 00:00:00'),(120,3,5,0,'',0,'','',0,242,'2020-02-12 07:23:35',0,'0000-00-00 00:00:00'),(121,3,7,0,'',0,'','',0,242,'2020-02-12 07:23:45',0,'0000-00-00 00:00:00'),(122,1,4,0,'',0,'','',0,304,'2020-02-12 07:24:47',0,'0000-00-00 00:00:00'),(123,1,8,0,'',0,'','',0,304,'2020-02-12 07:24:59',0,'0000-00-00 00:00:00'),(124,1,7,0,'',0,'','',0,304,'2020-02-12 07:25:46',0,'0000-00-00 00:00:00'),(125,4,1,2,'',1,'','',0,265,'2020-02-12 09:02:38',265,'2020-02-12 09:02:38'),(127,11,1,1,'',0,'','',0,242,'2020-02-12 08:31:19',0,'0000-00-00 00:00:00'),(128,3,1,3,'',0,'','',0,265,'2020-02-13 00:40:12',0,'0000-00-00 00:00:00'),(129,1,11,0,'',0,'','',0,265,'2020-02-13 00:55:18',0,'0000-00-00 00:00:00'),(130,1,3,26,'',0,'','',0,79,'2020-02-13 01:11:42',0,'0000-00-00 00:00:00'),(131,1,3,28,'',0,'','',0,24,'2020-02-13 01:29:39',0,'0000-00-00 00:00:00'),(132,1,3,27,'',0,'','',0,24,'2020-02-13 01:30:17',0,'0000-00-00 00:00:00'),(133,2,3,25,'',0,'','',0,242,'2020-02-13 01:31:42',0,'0000-00-00 00:00:00'),(134,1,3,25,'',0,'','',0,304,'2020-02-13 01:34:57',0,'0000-00-00 00:00:00'),(135,1,5,0,'',0,'','',0,304,'2020-02-13 01:36:10',0,'0000-00-00 00:00:00'),(136,3,24,1,'',0,'','',0,304,'2020-02-13 01:36:15',0,'0000-00-00 00:00:00'),(137,3,2,9,'',0,'','',0,265,'2020-02-13 01:36:45',0,'0000-00-00 00:00:00'),(138,3,3,22,'<h4>Statements of Financial Position</h4>\r\n',0,'','',0,24,'2020-02-13 01:52:20',0,'0000-00-00 00:00:00'),(139,3,3,23,'',0,'','',0,24,'2020-02-13 01:37:30',0,'0000-00-00 00:00:00'),(140,3,3,24,'',0,'','',0,24,'2020-02-13 01:37:32',0,'0000-00-00 00:00:00'),(141,3,3,25,'',0,'','',0,24,'2020-02-13 01:37:35',0,'0000-00-00 00:00:00'),(142,3,3,26,'',0,'','',0,24,'2020-02-13 01:37:37',0,'0000-00-00 00:00:00'),(143,3,3,27,'',0,'','',0,24,'2020-02-13 01:37:39',0,'0000-00-00 00:00:00'),(144,3,3,28,'',0,'','',0,24,'2020-02-13 01:37:41',0,'0000-00-00 00:00:00'),(145,3,6,0,'',0,'','',0,24,'2020-02-13 01:38:06',0,'0000-00-00 00:00:00'),(146,3,8,0,'',0,'','',0,24,'2020-02-13 01:38:15',0,'0000-00-00 00:00:00'),(147,3,9,0,'',0,'','',0,24,'2020-02-13 01:40:58',0,'0000-00-00 00:00:00'),(148,3,11,0,'',0,'','',0,24,'2020-02-13 01:41:07',0,'0000-00-00 00:00:00'),(149,3,28,1,'',0,'','',0,304,'2020-02-13 01:41:45',0,'0000-00-00 00:00:00'),(150,3,28,3,'',0,'','',0,24,'2020-02-13 01:42:06',0,'0000-00-00 00:00:00'),(151,3,28,2,'',0,'','',0,24,'2020-02-13 01:42:10',0,'0000-00-00 00:00:00'),(152,3,28,4,'',0,'','',0,24,'2020-02-13 01:42:37',0,'0000-00-00 00:00:00'),(153,3,28,5,'',0,'','',0,24,'2020-02-13 01:42:39',0,'0000-00-00 00:00:00'),(154,3,28,6,'',0,'','',0,24,'2020-02-13 01:42:42',0,'0000-00-00 00:00:00'),(155,3,28,7,'',0,'','',0,24,'2020-02-13 01:43:23',0,'0000-00-00 00:00:00'),(156,3,28,8,'',0,'','',0,24,'2020-02-13 01:43:24',0,'0000-00-00 00:00:00'),(157,3,29,9,'',0,'','',0,24,'2020-02-13 01:43:25',0,'0000-00-00 00:00:00'),(158,3,1,28,'',0,'','',0,304,'2020-02-13 01:43:49',0,'0000-00-00 00:00:00'),(159,3,2,21,'',0,'','',0,24,'2020-02-13 01:44:46',0,'0000-00-00 00:00:00'),(160,3,2,20,'',0,'','',0,24,'2020-02-13 01:44:49',0,'0000-00-00 00:00:00'),(161,3,2,19,'',0,'','',0,24,'2020-02-13 01:44:50',0,'0000-00-00 00:00:00'),(162,3,2,18,'',0,'','',0,24,'2020-02-13 01:44:52',0,'0000-00-00 00:00:00'),(163,3,2,17,'',0,'','',0,24,'2020-02-13 01:44:53',0,'0000-00-00 00:00:00'),(164,3,2,15,'',0,'','',0,24,'2020-02-13 01:44:56',0,'0000-00-00 00:00:00'),(165,3,2,14,'',0,'','',0,24,'2020-02-13 01:44:57',0,'0000-00-00 00:00:00'),(166,3,2,12,'',0,'','',0,24,'2020-02-13 01:45:00',0,'0000-00-00 00:00:00'),(167,3,2,11,'',0,'','',0,24,'2020-02-13 01:45:01',0,'0000-00-00 00:00:00'),(168,3,1,7,'',0,'','',0,24,'2020-02-13 01:45:06',0,'0000-00-00 00:00:00'),(169,2,3,26,'',0,'','',0,242,'2020-02-13 01:45:40',0,'0000-00-00 00:00:00'),(170,2,3,27,'',0,'','',0,242,'2020-02-13 01:45:42',0,'0000-00-00 00:00:00'),(171,1,9,0,'',0,'','',0,304,'2020-02-13 01:46:01',0,'0000-00-00 00:00:00'),(172,1,10,0,'',0,'','',0,304,'2020-02-13 01:46:01',0,'0000-00-00 00:00:00'),(173,4,1,4,'',1,' try reason  only','',0,24,'2020-02-13 02:00:59',24,'2020-02-13 02:00:59'),(174,1,2,1,'',0,'','',0,304,'2020-02-13 08:28:59',0,'0000-00-00 00:00:00'),(175,9,1,1,'',0,'','',0,242,'2020-02-14 01:55:31',0,'0000-00-00 00:00:00'),(176,1,2,22,'',0,'','',0,304,'2020-02-14 02:04:51',0,'0000-00-00 00:00:00'),(177,1,3,29,'',0,'','',0,304,'2020-02-14 02:05:05',0,'0000-00-00 00:00:00'),(178,9,2,9,'',0,'','',0,242,'2020-02-14 02:24:22',0,'0000-00-00 00:00:00'),(179,1,3,0,'',0,'','',0,304,'2020-02-14 03:04:31',0,'0000-00-00 00:00:00'),(180,1,4,29,'',0,'','',1,304,'2020-02-18 01:46:26',0,'0000-00-00 00:00:00'),(181,9,1,2,'',0,'','',0,242,'2020-02-14 04:21:23',0,'0000-00-00 00:00:00'),(182,9,2,13,'',0,'','',0,242,'2020-02-14 08:32:45',0,'0000-00-00 00:00:00'),(183,5,4,0,'',0,'','',0,242,'2020-02-14 08:34:54',0,'0000-00-00 00:00:00'),(184,5,3,0,'',0,'','',0,242,'2020-02-14 08:34:58',0,'0000-00-00 00:00:00'),(185,5,1,1,'',0,'','',0,242,'2020-02-14 08:35:04',0,'0000-00-00 00:00:00'),(186,5,1,3,'',0,'','',0,242,'2020-02-14 08:35:16',0,'0000-00-00 00:00:00'),(187,5,1,6,'',0,'','',0,242,'2020-02-14 08:35:22',0,'0000-00-00 00:00:00'),(188,5,2,10,'',0,'','',0,242,'2020-02-14 08:35:29',0,'0000-00-00 00:00:00'),(189,5,2,11,'',0,'','',0,242,'2020-02-14 08:35:32',0,'0000-00-00 00:00:00'),(190,5,2,13,'',0,'','',0,242,'2020-02-14 08:35:36',0,'0000-00-00 00:00:00'),(191,5,2,14,'',0,'','',0,242,'2020-02-14 08:35:37',0,'0000-00-00 00:00:00'),(192,5,2,15,'',0,'','',0,242,'2020-02-14 08:35:39',0,'0000-00-00 00:00:00'),(193,5,2,16,'',0,'','',0,242,'2020-02-14 08:35:41',0,'0000-00-00 00:00:00'),(194,5,2,17,'',0,'','',0,242,'2020-02-14 08:35:44',0,'0000-00-00 00:00:00'),(195,5,2,18,'',0,'','',0,242,'2020-02-14 08:35:46',0,'0000-00-00 00:00:00'),(196,5,2,19,'',0,'','',0,242,'2020-02-14 08:35:48',0,'0000-00-00 00:00:00'),(197,5,2,20,'',0,'','',0,242,'2020-02-14 08:35:50',0,'0000-00-00 00:00:00'),(198,5,2,21,'',0,'','',0,242,'2020-02-14 08:35:54',0,'0000-00-00 00:00:00'),(199,5,3,24,'',0,'','',0,242,'2020-02-14 08:36:06',0,'0000-00-00 00:00:00'),(200,5,3,25,'',0,'','',0,242,'2020-02-14 08:36:08',0,'0000-00-00 00:00:00'),(201,5,3,26,'',0,'','',0,242,'2020-02-14 08:36:10',0,'0000-00-00 00:00:00'),(202,5,3,27,'',0,'','',0,242,'2020-02-14 08:36:12',0,'0000-00-00 00:00:00'),(203,5,3,28,'',0,'','',0,242,'2020-02-14 08:36:13',0,'0000-00-00 00:00:00'),(204,5,5,0,'',0,'','',0,242,'2020-02-14 08:36:17',0,'0000-00-00 00:00:00'),(205,5,6,0,'',0,'','',0,242,'2020-02-14 08:36:19',0,'0000-00-00 00:00:00'),(206,5,7,0,'',0,'','',0,242,'2020-02-14 08:36:21',0,'0000-00-00 00:00:00'),(207,5,8,0,'',0,'','',0,242,'2020-02-14 08:36:23',0,'0000-00-00 00:00:00'),(208,5,9,0,'',0,'','',0,242,'2020-02-14 08:36:25',0,'0000-00-00 00:00:00'),(209,5,10,0,'',0,'','',0,242,'2020-02-14 08:36:27',0,'0000-00-00 00:00:00'),(210,5,11,0,'',0,'','',0,242,'2020-02-14 08:36:29',0,'0000-00-00 00:00:00'),(211,15,1,6,'',0,'','',0,24,'2020-02-14 08:48:24',0,'0000-00-00 00:00:00'),(212,9,1,3,'',0,'','',0,242,'2020-02-14 09:14:12',0,'0000-00-00 00:00:00'),(213,9,1,4,'',0,'','',0,242,'2020-02-14 09:14:13',0,'0000-00-00 00:00:00'),(214,9,1,5,'',0,'','',0,242,'2020-02-14 09:14:20',0,'0000-00-00 00:00:00'),(215,15,1,1,'',0,'','',0,304,'2020-02-14 09:19:14',0,'0000-00-00 00:00:00'),(216,15,1,2,'',0,'','',0,304,'2020-02-14 09:19:30',0,'0000-00-00 00:00:00'),(217,15,1,3,'',0,'','',0,304,'2020-02-14 09:19:31',0,'0000-00-00 00:00:00'),(218,15,1,4,'',0,'','',0,304,'2020-02-14 09:19:32',0,'0000-00-00 00:00:00'),(219,15,1,5,'',0,'','',0,304,'2020-02-14 09:19:33',0,'0000-00-00 00:00:00'),(220,15,1,7,'',0,'','',0,304,'2020-02-14 09:19:34',0,'0000-00-00 00:00:00'),(221,15,1,8,'',0,'','',0,304,'2020-02-14 09:19:35',0,'0000-00-00 00:00:00'),(222,15,2,9,'',0,'','',0,304,'2020-02-14 09:19:36',0,'0000-00-00 00:00:00'),(223,15,2,10,'',0,'','',0,304,'2020-02-14 09:19:37',0,'0000-00-00 00:00:00'),(224,15,2,11,'',0,'','',0,304,'2020-02-14 09:19:42',0,'0000-00-00 00:00:00'),(225,15,2,12,'',0,'','',0,304,'2020-02-14 09:19:43',0,'0000-00-00 00:00:00'),(226,2,5,0,'',0,'','',0,242,'2020-02-17 00:50:36',0,'0000-00-00 00:00:00'),(227,2,3,28,'',0,'','',0,242,'2020-02-17 00:51:30',0,'0000-00-00 00:00:00'),(228,1,1,0,'',0,'','',0,265,'2020-02-18 02:05:23',0,'0000-00-00 00:00:00'),(229,1,2,0,'',0,'','',0,304,'2020-02-20 00:50:06',0,'0000-00-00 00:00:00'),(230,10,1,1,'',0,'','',0,304,'2020-02-20 00:51:34',0,'0000-00-00 00:00:00'),(231,10,1,0,'',0,'','',0,304,'2020-02-20 00:51:35',0,'0000-00-00 00:00:00'),(232,10,1,2,'',0,'','',0,304,'2020-02-20 00:52:05',0,'0000-00-00 00:00:00'),(233,10,1,3,'',0,'','',0,304,'2020-02-20 00:52:13',0,'0000-00-00 00:00:00'),(234,12,1,2,'',0,'','',0,265,'2020-02-20 01:42:49',0,'0000-00-00 00:00:00'),(235,12,1,0,'',0,'','',0,265,'2020-02-20 01:42:50',0,'0000-00-00 00:00:00'),(236,1,1,10,'',0,'','',0,309,'2020-02-26 09:12:53',0,'0000-00-00 00:00:00'),(237,1,1,15,'',0,'','',0,309,'2020-02-26 09:13:28',0,'0000-00-00 00:00:00'),(238,2,3,0,'',0,'','',0,79,'2020-02-27 01:51:09',0,'0000-00-00 00:00:00'),(239,14,3,22,'',0,'','',0,79,'2020-03-02 08:26:27',0,'0000-00-00 00:00:00'),(240,14,3,0,'',0,'','',0,79,'2020-03-02 08:26:28',0,'0000-00-00 00:00:00'),(241,2,1,0,'',0,'','',0,265,'2020-03-10 09:04:16',0,'0000-00-00 00:00:00'),(242,6,1,1,'',0,'','',0,79,'2020-03-16 09:59:45',0,'0000-00-00 00:00:00'),(243,6,1,0,'',0,'','',0,79,'2020-03-16 09:59:46',0,'0000-00-00 00:00:00'),(244,4,1,0,'',0,'','',0,79,'2020-03-16 10:04:29',0,'0000-00-00 00:00:00'),(245,8,1,0,'',0,'','',0,79,'2020-03-16 10:04:41',0,'0000-00-00 00:00:00'),(246,7,1,0,'',0,'','',0,79,'2020-03-17 00:51:54',0,'0000-00-00 00:00:00'),(247,7,1,2,'',0,'','',0,79,'2020-03-17 01:01:10',0,'0000-00-00 00:00:00'),(248,7,1,3,'',0,'','',0,79,'2020-03-17 01:15:33',0,'0000-00-00 00:00:00'),(249,5,2,0,'',0,'','',0,79,'2020-03-17 01:25:01',0,'0000-00-00 00:00:00'),(250,5,1,0,'',0,'','',0,79,'2020-03-17 01:25:30',0,'0000-00-00 00:00:00'),(251,7,3,22,'',0,'','',0,79,'2020-03-17 01:26:51',0,'0000-00-00 00:00:00'),(252,7,3,0,'',0,'','',0,79,'2020-03-17 01:26:52',0,'0000-00-00 00:00:00'),(253,7,8,0,'',0,'','',0,79,'2020-03-17 01:26:59',0,'0000-00-00 00:00:00'),(254,1,1,1,'',0,'','',1,304,'2020-03-17 06:28:23',0,'0000-00-00 00:00:00'),(255,1,1,0,'',0,'','',0,304,'2020-03-17 01:39:46',0,'0000-00-00 00:00:00');

--
-- Temporary table structure for view `company__branch`
--

/*!50001 DROP VIEW IF EXISTS `company__branch`*/;
/*!50001 CREATE TABLE `company__branch` (
  `id` tinyint NOT NULL,
  `company_id` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `address` tinyint NOT NULL,
  `postcode` tinyint NOT NULL,
  `city` tinyint NOT NULL,
  `state_id` tinyint NOT NULL,
  `country_id` tinyint NOT NULL,
  `latitude` tinyint NOT NULL,
  `longitude` tinyint NOT NULL,
  `phone` tinyint NOT NULL,
  `fax` tinyint NOT NULL,
  `email` tinyint NOT NULL,
  `status` tinyint NOT NULL,
  `created_by` tinyint NOT NULL,
  `created_ts` tinyint NOT NULL,
  `updated_by` tinyint NOT NULL,
  `updated_ts` tinyint NOT NULL,
  `is_delete` tinyint NOT NULL,
  `deleted_by` tinyint NOT NULL,
  `deleted_ts` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `company__department`
--

/*!50001 DROP VIEW IF EXISTS `company__department`*/;
/*!50001 CREATE TABLE `company__department` (
  `id` tinyint NOT NULL,
  `branch_id` tinyint NOT NULL,
  `division_id` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `description` tinyint NOT NULL,
  `hod_id` tinyint NOT NULL,
  `status` tinyint NOT NULL,
  `created_by` tinyint NOT NULL,
  `created_ts` tinyint NOT NULL,
  `updated_by` tinyint NOT NULL,
  `updated_ts` tinyint NOT NULL,
  `is_delete` tinyint NOT NULL,
  `deleted_by` tinyint NOT NULL,
  `deleted_ts` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `company__position`
--

CREATE TABLE `company__position` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `position` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` tinyint(1) DEFAULT '0' COMMENT '0 = active, 1= inactive',
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int(11) DEFAULT NULL,
  `updated_ts` timestamp NULL DEFAULT NULL,
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = no, 1 = yes',
  `deleted_by` int(11) DEFAULT NULL,
  `deleted_ts` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parentid` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company__position`
--

INSERT INTO `company__position` VALUES (1,0,'Top Management','',0,1,'2017-12-18 03:24:10',NULL,NULL,0,NULL,NULL),(2,0,'Management','',0,1,'2017-12-18 03:24:10',NULL,NULL,0,NULL,NULL),(3,0,'Middle Management','',0,1,'2017-12-18 03:25:01',NULL,NULL,0,NULL,NULL),(4,0,'Executive','',0,1,'2017-12-18 03:25:01',NULL,NULL,0,NULL,NULL),(5,0,'Non Executive','',0,1,'2017-12-18 03:25:49',NULL,NULL,0,NULL,NULL),(6,1,'Partner','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(7,1,'Managing Partner','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(8,2,'Junior Partner','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(9,2,'Director','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(10,2,'Associate Director','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(11,2,'Senior Manager','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(12,2,'Manager','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(13,3,'Assistant Manager','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(14,3,'Supervisor','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(15,4,'Senior Executive','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(16,4,'Executive','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(17,5,'Admin Assistant','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(18,5,'Office Assistant','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(19,5,'Dispatch & Driver','',0,1,'2017-12-18 03:30:29',NULL,NULL,0,NULL,NULL),(20,0,'Contract Staff','',0,1,'2018-01-08 09:59:49',NULL,NULL,0,NULL,NULL),(21,20,'Contract Staff','',0,1,'2018-01-08 10:00:07',NULL,NULL,0,NULL,NULL),(22,1,'','',0,0,'2019-01-03 09:56:40',NULL,NULL,1,NULL,NULL),(23,20,'Trainee','',0,0,'2019-01-04 01:48:59',NULL,NULL,0,NULL,NULL),(24,20,'Account Assistant','',0,0,'2019-02-11 04:34:19',NULL,NULL,0,NULL,NULL),(25,20,'','',0,0,'2019-02-15 02:05:30',NULL,NULL,1,NULL,NULL),(26,1,'Senior Analyst','',0,0,'2019-03-11 07:16:21',NULL,NULL,0,NULL,NULL),(27,16,'SECRETARY ASSISTANT','',0,0,'2019-03-18 01:59:42',NULL,NULL,0,NULL,NULL),(28,1,'Secretary Assistant','',0,0,'2019-03-18 02:37:21',NULL,NULL,0,NULL,NULL),(29,16,'Company Secretary Assistant','',0,0,'2019-03-18 02:40:04',NULL,NULL,0,NULL,NULL),(30,16,'GST Assistant','',0,0,'2019-03-18 04:18:19',NULL,NULL,0,NULL,NULL),(31,16,'GST Executive','',0,0,'2019-03-18 04:54:23',NULL,NULL,0,NULL,NULL),(32,15,'Senior Company Secretary Assistant','',0,0,'2019-04-03 01:05:56',NULL,NULL,0,NULL,NULL),(33,1,'Assistant Director','',0,0,'2019-04-04 01:53:34',NULL,NULL,0,NULL,NULL),(34,5,'Receptionist cum Admin','',0,0,'2019-04-09 01:57:31',NULL,NULL,0,NULL,NULL),(35,1,'contract','',0,0,'2019-05-07 06:25:16',NULL,NULL,0,NULL,NULL),(36,5,'Admin Executive','',0,0,'2019-05-08 02:37:39',NULL,NULL,0,NULL,NULL),(37,4,'Senior Admin Executive','',0,0,'2019-05-08 03:03:55',NULL,NULL,0,NULL,NULL),(38,4,'Admin Executive','',0,0,'2019-05-08 03:12:52',NULL,NULL,0,NULL,NULL),(39,4,'IT Administration Executive','',0,0,'2019-05-08 03:26:19',NULL,NULL,0,NULL,NULL),(40,4,'IT Technician','',0,0,'2019-05-08 03:48:15',NULL,NULL,0,NULL,NULL),(41,4,'IT Executive','',0,0,'2019-05-08 04:18:39',NULL,NULL,0,NULL,NULL),(42,4,'Senior IT Executive','',0,0,'2019-05-08 04:30:28',NULL,NULL,0,NULL,NULL),(43,4,'Senior Accounts Executive','',0,0,'2019-05-08 06:01:25',NULL,NULL,0,NULL,NULL),(44,2,'Accounts Manager','',0,0,'2019-05-08 07:03:29',NULL,NULL,0,NULL,NULL),(45,3,'Accounts  Supervisor','',0,0,'2019-05-08 07:16:28',NULL,NULL,0,NULL,NULL),(46,3,'Accounts  Supervisor','',0,0,'2019-05-08 07:16:34',NULL,NULL,0,NULL,NULL),(47,2,'Tax Manager','',0,0,'2019-05-08 07:43:29',NULL,NULL,0,NULL,NULL),(48,16,'Audit Associate','',0,0,'2019-05-09 05:41:45',NULL,NULL,0,NULL,NULL),(49,4,'Assistant Audit','',0,0,'2019-05-10 06:54:32',NULL,NULL,0,NULL,NULL),(50,4,'Senior Audit II','',0,0,'2019-05-13 01:06:08',NULL,NULL,0,NULL,NULL),(51,3,'Audit Supervisor','',0,0,'2019-05-13 01:12:35',NULL,NULL,0,NULL,NULL),(52,3,'Assistant Manager Audit','',0,0,'2019-05-13 01:42:56',NULL,NULL,0,NULL,NULL),(53,3,'Audit Supervisor II','',0,0,'2019-05-13 02:29:49',NULL,NULL,0,NULL,NULL),(54,2,'Audit Manager','',0,0,'2019-05-13 04:05:13',NULL,NULL,0,NULL,NULL),(55,4,'Analyst','',0,0,'2019-05-13 08:17:04',NULL,NULL,0,NULL,NULL),(56,3,'Assistant Manager Analyst II','',0,0,'2019-05-14 00:44:49',NULL,NULL,0,NULL,NULL),(57,2,'Transaction Services Manager','',0,0,'2019-05-14 00:58:05',NULL,NULL,0,NULL,NULL),(58,2,'Tax Director','',0,0,'2019-05-14 02:26:00',NULL,NULL,0,NULL,NULL),(59,3,'Assistant Manager Transaction Service','',0,0,'2019-05-15 00:20:30',NULL,NULL,0,NULL,NULL),(60,4,'Product Consultant','',0,0,'2019-05-15 00:43:24',NULL,NULL,0,NULL,NULL),(61,4,'Corporate Communication Executive','',0,0,'2019-05-15 01:41:25',NULL,NULL,0,NULL,NULL),(62,15,'Senior Corporate Communication','',0,0,'2019-05-15 01:46:53',NULL,NULL,0,NULL,NULL),(63,3,'Supervisor Company Secretary','',0,0,'2019-05-15 05:53:14',NULL,NULL,0,NULL,NULL),(64,4,'TAF Executive','',0,0,'2019-05-16 02:05:46',NULL,NULL,0,NULL,NULL),(65,4,'Senior Audit I','',0,0,'2019-05-17 00:57:25',NULL,NULL,0,NULL,NULL),(66,2,'Consultant Manager','',0,0,'2019-05-17 02:37:04',NULL,NULL,0,NULL,NULL),(67,4,'Senior Audit','',0,0,'2019-05-17 02:56:26',NULL,NULL,0,NULL,NULL),(68,3,'Assistant Manager Indirect Tax','',0,0,'2019-05-17 03:10:07',NULL,NULL,0,NULL,NULL),(69,4,'Assistant Account','',0,0,'2019-05-17 03:25:58',NULL,NULL,0,NULL,NULL),(70,3,'Assistant Manager Account','',0,0,'2019-05-17 04:22:14',NULL,NULL,0,NULL,NULL),(71,2,'Indirect Tax Manager','',0,0,'2019-05-17 04:48:03',NULL,NULL,0,NULL,NULL),(72,15,'Senior Finance Executive','',0,0,'2019-05-17 07:20:12',NULL,NULL,0,NULL,NULL),(73,20,'Junior Programmer','',0,0,'2019-05-20 03:53:19',NULL,NULL,0,NULL,NULL),(74,13,'Assistant Manager Shariah Advisory','',0,0,'2019-05-20 04:01:33',NULL,NULL,0,NULL,NULL),(75,4,'Finance & Accounts Executive','',0,0,'2019-05-20 04:21:32',NULL,NULL,0,NULL,NULL),(76,1,'Audit Trainee','',0,0,'2019-05-20 04:45:24',NULL,NULL,0,NULL,NULL),(77,23,'Audit Trainee','',0,0,'2019-05-20 04:45:58',NULL,NULL,0,NULL,NULL),(78,20,'Administrative and Marketing Executive','',0,0,'2019-05-20 04:56:56',NULL,NULL,0,NULL,NULL),(79,23,'Indirect Tax Trainee','',0,0,'2019-05-20 05:45:54',NULL,NULL,0,NULL,NULL),(80,15,'Senior HR Executive','',0,0,'2019-05-21 02:25:17',NULL,NULL,0,NULL,NULL),(81,15,'Office Manager','',0,0,'2019-05-21 02:59:24',NULL,NULL,0,NULL,NULL),(82,2,'Audit Director','',0,0,'2019-05-22 00:54:32',NULL,NULL,0,NULL,NULL),(83,3,'Assistant Manager HR','',0,0,'2019-05-22 01:23:56',NULL,NULL,0,NULL,NULL),(84,4,'Research Associate','',0,0,'2019-05-22 02:05:28',NULL,NULL,0,NULL,NULL),(85,1,'Cheif Executive Officer','CEO',0,164,'2019-05-30 00:37:52',NULL,NULL,0,NULL,NULL),(86,1,'Cheif Executive Officer','',0,0,'2019-05-30 00:42:07',NULL,NULL,1,NULL,NULL),(87,1,'Advisory','',0,164,'2019-05-30 03:08:56',NULL,NULL,0,NULL,NULL);

--
-- Table structure for table `investor`
--

CREATE TABLE `investor` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `investor` varchar(128) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `investor`
--

INSERT INTO `investor` VALUES (1,'Kuala Sidim Bhd.',0,0,'2020-01-28 08:40:55',0,'0000-00-00 00:00:00'),(2,'Rimbunan Sawit Bhd',0,0,'2020-01-28 08:40:55',0,'0000-00-00 00:00:00'),(3,'Premium Dragon',0,0,'2020-01-28 08:40:55',0,'0000-00-00 00:00:00'),(4,'TH Plantation Bhd',0,0,'2020-01-28 08:40:55',0,'0000-00-00 00:00:00'),(5,'FELCRA Bhd',0,0,'2020-01-28 08:40:55',0,'0000-00-00 00:00:00'),(6,'RISDA',0,0,'2020-01-28 08:40:55',0,'0000-00-00 00:00:00');

--
-- Table structure for table `ip_visit`
--

CREATE TABLE `ip_visit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(30) NOT NULL,
  `page_view` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=539 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ip_visit`
--

INSERT INTO `ip_visit` VALUES (1,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:03:16'),(2,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:03:54'),(3,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:08:59'),(4,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:12:18'),(5,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:14:39'),(6,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:14:58'),(7,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:15:13'),(8,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:15:50'),(9,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:16:08'),(10,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:17:05'),(11,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:18:41'),(12,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:19:25'),(13,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:20:00'),(14,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:20:45'),(15,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:21:08'),(16,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:21:50'),(17,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:22:12'),(18,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:22:24'),(19,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:23:18'),(20,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:23:22'),(21,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:24:37'),(22,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:25:38'),(23,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:26:42'),(24,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:27:09'),(25,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:28:57'),(26,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 01:29:05'),(27,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 03:07:44'),(28,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 03:10:30'),(29,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 03:11:10'),(30,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 03:11:14'),(31,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 03:12:04'),(32,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:12:38'),(33,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/account','2020-01-28 03:12:47'),(34,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 03:13:29'),(35,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:13:31'),(36,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:14:29'),(37,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:15:13'),(38,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:15:22'),(39,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:15:46'),(40,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:19:02'),(41,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:20:45'),(42,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:20:55'),(43,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:21:03'),(44,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:25:02'),(45,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:29:46'),(46,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:32:13'),(47,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:32:59'),(48,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:33:20'),(49,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:33:40'),(50,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:33:47'),(51,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:35:36'),(52,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:35:45'),(53,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:36:10'),(54,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:36:17'),(55,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:36:33'),(56,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:36:43'),(57,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:39:58'),(58,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:40:34'),(59,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/account','2020-01-28 03:46:02'),(60,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/account','2020-01-28 03:47:06'),(61,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/account','2020-01-28 03:48:03'),(62,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:52:29'),(63,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:52:42'),(64,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:53:02'),(65,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:53:41'),(66,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:54:07'),(67,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:54:31'),(68,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:59:27'),(69,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:59:44'),(70,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 03:59:57'),(71,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:00:48'),(72,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:00:59'),(73,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:01:31'),(74,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:01:34'),(75,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 04:02:59'),(76,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/account','2020-01-28 04:03:04'),(77,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:03:51'),(78,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:14:23'),(79,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:15:47'),(80,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:15:59'),(81,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:16:19'),(82,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:16:53'),(83,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:26:26'),(84,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:26:40'),(85,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:27:09'),(86,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:39:30'),(87,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:40:05'),(88,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:40:10'),(89,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 04:40:32'),(90,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:42:00'),(91,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:45:18'),(92,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:45:37'),(93,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:46:07'),(94,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 04:46:28'),(95,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:46:34'),(96,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:47:41'),(97,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:48:50'),(98,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 04:49:21'),(99,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:49:25'),(100,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:51:38'),(101,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:52:01'),(102,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:54:35'),(103,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:55:00'),(104,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:55:08'),(105,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:57:07'),(106,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:58:36'),(107,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:58:59'),(108,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 04:59:38'),(109,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:04:38'),(110,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:04:55'),(111,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:06:40'),(112,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:08:06'),(113,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:08:14'),(114,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 05:09:00'),(115,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:09:27'),(116,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:09:48'),(117,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:09:59'),(118,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:13:09'),(119,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 05:13:23'),(120,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:14:10'),(121,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:14:54'),(122,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:15:03'),(123,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:15:13'),(124,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 05:15:23'),(125,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 05:15:38'),(126,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 05:15:47'),(127,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:13:11'),(128,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:17:07'),(129,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:18:02'),(130,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 06:18:42'),(131,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:18:52'),(132,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 06:21:00'),(133,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:24:04'),(134,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 06:25:17'),(135,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 06:25:27'),(136,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 06:25:37'),(137,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/edit_coop','2020-01-28 06:25:42'),(138,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 06:26:28'),(139,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/add_new','2020-01-28 06:26:33'),(140,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 06:26:38'),(141,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 06:32:59'),(142,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:33:12'),(143,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:33:15'),(144,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:33:25'),(145,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:33:45'),(146,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 06:33:59'),(147,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 07:43:26'),(148,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 07:44:33'),(149,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 08:02:55'),(150,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 08:02:59'),(151,'192.168.1.200','http://192.168.1.2/pelita.dev/','2020-01-28 08:16:47'),(152,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 08:16:49'),(153,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:16:54'),(154,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:21:09'),(155,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:22:45'),(156,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:23:26'),(157,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:23:37'),(158,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:24:02'),(159,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:25:22'),(160,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:25:46'),(161,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:26:06'),(162,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:26:18'),(163,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:26:31'),(164,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:27:14'),(165,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 08:27:36'),(166,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 08:48:54'),(167,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/index','2020-01-28 08:49:41'),(168,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/index','2020-01-28 08:49:52'),(169,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/add_new','2020-01-28 08:50:06'),(170,'192.168.1.200','http://192.168.1.2/pelita.dev/Cooperative/all','2020-01-28 08:55:20'),(171,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:55:24'),(172,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 08:56:44'),(173,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 08:56:46'),(174,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 08:58:20'),(175,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 08:58:23'),(176,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 08:58:28'),(177,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:00:36'),(178,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:00:38'),(179,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:00:43'),(180,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:00:51'),(181,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:00:58'),(182,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:01:15'),(183,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:01:16'),(184,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:01:19'),(185,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:01:22'),(186,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:01:29'),(187,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:01:34'),(188,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:01:40'),(189,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:01:50'),(190,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:01:57'),(191,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:02:01'),(192,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:02:08'),(193,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:02:11'),(194,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:02:47'),(195,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:03:17'),(196,'192.168.1.200','http://192.168.1.2/pelita.dev/Charts/index','2020-01-28 09:04:28'),(197,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:05:26'),(198,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:06:56'),(199,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:06:59'),(200,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:07:15'),(201,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:07:54'),(202,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:08:01'),(203,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:08:10'),(204,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:08:14'),(205,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:14:55'),(206,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:31:12'),(207,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:31:49'),(208,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/index','2020-01-28 09:31:55'),(209,'192.168.1.200','http://192.168.1.2/pelita.dev/Audits/requirementDetails/Fulfillment_of_Condition_Precedent','2020-01-28 09:32:09'),(210,'192.168.1.200','http://192.168.1.2/pelita.dev/dashboard','2020-01-28 09:38:35'),(211,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 00:58:20'),(212,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 00:58:25'),(213,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 00:58:36'),(214,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 00:58:52'),(215,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 00:59:14'),(216,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 00:59:16'),(217,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 00:59:28'),(218,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 01:00:39'),(219,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 01:00:41'),(220,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 01:00:44'),(221,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 01:00:46'),(222,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 01:00:49'),(223,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 01:01:27'),(224,'42.153.46.105','http://salihin.noip.me/pelita.dev/','2020-01-29 01:01:38'),(225,'42.153.40.175','http://salihin.noip.me/pelita.dev/dashboard','2020-01-29 09:15:46'),(226,'42.153.40.175','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-01-29 09:16:13'),(227,'42.153.40.175','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-01-29 09:16:27'),(228,'42.153.40.175','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-01-29 09:16:46'),(229,'42.153.40.175','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-01-29 09:19:18'),(230,'42.153.40.175','http://salihin.noip.me/pelita.dev/dashboard','2020-01-29 09:21:33'),(231,'42.153.40.175','http://salihin.noip.me/pelita.dev/dashboard','2020-01-29 09:36:08'),(232,'42.153.40.175','http://salihin.noip.me/pelita.dev/dashboard','2020-01-29 09:36:15'),(233,'42.153.40.175','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-01-29 09:36:42'),(234,'42.153.40.175','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-01-29 09:36:49'),(235,'42.153.40.175','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-01-29 09:40:24'),(236,'113.210.75.172','http://salihin.noip.me/pelita.dev/dashboard','2020-01-30 05:57:42'),(237,'113.210.75.172','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-01-30 05:58:27'),(238,'113.210.75.172','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-01-30 05:58:33'),(239,'113.210.75.172','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-01-30 05:59:00'),(240,'210.195.50.58','http://salihin.noip.me/pelita.dev/dashboard','2020-02-05 13:29:44'),(241,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-05 13:31:14'),(242,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:31:21'),(243,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:46:06'),(244,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:46:34'),(245,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:49:34'),(246,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:50:54'),(247,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:50:57'),(248,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-05 13:51:19'),(249,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:51:19'),(250,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-05 13:51:36'),(251,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:51:36'),(252,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-05 13:51:41'),(253,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:51:42'),(254,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 13:59:59'),(255,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:00:48'),(256,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:01:17'),(257,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:02:08'),(258,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:02:54'),(259,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:04:19'),(260,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:06:35'),(261,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:07:22'),(262,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:10:04'),(263,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:10:26'),(264,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:11:15'),(265,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:13:55'),(266,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:18:01'),(267,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:19:02'),(268,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:19:24'),(269,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-05 14:20:28'),(270,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:20:29'),(271,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-05 14:20:41'),(272,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:20:41'),(273,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:28:23'),(274,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:37:35'),(275,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:37:40'),(276,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:57:27'),(277,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 14:57:30'),(278,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-05 15:01:45'),(279,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-05 15:01:49'),(280,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-05 15:02:09'),(281,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-05 15:04:46'),(282,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 15:04:49'),(283,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 15:04:52'),(284,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 15:19:07'),(285,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 15:21:19'),(286,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 15:22:03'),(287,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 15:22:46'),(288,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-05 15:23:20'),(289,'210.195.50.58','http://salihin.noip.me/pelita.dev/dashboard','2020-02-12 19:26:48'),(290,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 19:27:12'),(291,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 19:27:16'),(292,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 19:40:13'),(293,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:01:57'),(294,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:16:33'),(295,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:16:41'),(296,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:17:36'),(297,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:17:50'),(298,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:19:25'),(299,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:20:03'),(300,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:23:07'),(301,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:23:52'),(302,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:24:19'),(303,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:25:18'),(304,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:27:52'),(305,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:28:28'),(306,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:28:32'),(307,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:29:26'),(308,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:33:56'),(309,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:34:54'),(310,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:42:05'),(311,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:44:21'),(312,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 20:57:21'),(313,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:01:49'),(314,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:02:38'),(315,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:03:20'),(316,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:04:06'),(317,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:06:03'),(318,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:09:46'),(319,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:10:55'),(320,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:12:15'),(321,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:28:30'),(322,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:28:33'),(323,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:28:38'),(324,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:30:12'),(325,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:31:15'),(326,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:35:52'),(327,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:36:03'),(328,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:37:03'),(329,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:41:48'),(330,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:41:57'),(331,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:42:01'),(332,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:42:21'),(333,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:42:56'),(334,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:48:24'),(335,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:51:22'),(336,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 21:52:02'),(337,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 21:52:19'),(338,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:52:22'),(339,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:52:33'),(340,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:58:47'),(341,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:58:52'),(342,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-12 21:59:16'),(343,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:59:16'),(344,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-12 21:59:21'),(345,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:59:22'),(346,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/updatebalance','2020-02-12 21:59:24'),(347,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:59:24'),(348,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup','2020-02-12 21:59:42'),(349,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 21:59:59'),(350,'210.195.50.58','http://salihin.noip.me/pelita.dev/dashboard','2020-02-12 22:00:03'),(351,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:00:35'),(352,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:00:37'),(353,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:02:30'),(354,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:03:27'),(355,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:04:20'),(356,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:04:47'),(357,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:04:51'),(358,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:06:18'),(359,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:06:23'),(360,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:06:27'),(361,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:08:07'),(362,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:08:13'),(363,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:08:20'),(364,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:08:22'),(365,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:10:07'),(366,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:10:11'),(367,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:10:14'),(368,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:10:17'),(369,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:10:20'),(370,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:10:25'),(371,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:10:28'),(372,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-12 22:11:31'),(373,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:11:45'),(374,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/2','2020-02-12 22:11:48'),(375,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:12:12'),(376,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/3','2020-02-12 22:12:15'),(377,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:12:59'),(378,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/8','2020-02-12 22:13:05'),(379,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/8','2020-02-12 22:13:26'),(380,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/8','2020-02-12 22:20:00'),(381,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:20:10'),(382,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/9','2020-02-12 22:20:14'),(383,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/9','2020-02-12 22:20:32'),(384,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-12 22:24:21'),(385,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/11','2020-02-12 22:24:28'),(386,'210.195.50.58','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/11','2020-02-12 22:24:29'),(387,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-02-18 08:37:12'),(388,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/project_setup','2020-02-18 08:37:22'),(389,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-18 08:44:12'),(390,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-18 08:44:23'),(391,'42.153.131.161','http://salihin.noip.me/pelita.dev/dashboard','2020-02-27 03:50:49'),(392,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-02-27 03:51:12'),(393,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-02-27 03:56:37'),(394,'42.153.131.161','http://salihin.noip.me/pelita.dev/dashboard','2020-02-27 04:14:02'),(395,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-02-28 01:34:42'),(396,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-02-28 01:34:55'),(397,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-02-28 01:35:01'),(398,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-02-28 01:35:09'),(399,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-02-28 01:35:22'),(400,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-02-28 01:35:23'),(401,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-02-28 01:35:46'),(402,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-02-28 01:36:13'),(403,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-02-28 01:36:22'),(404,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/get_attachment','2020-02-28 01:36:35'),(405,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-02-28 01:36:40'),(406,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-02-28 01:36:42'),(407,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-02-28 01:39:53'),(408,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/4/0','2020-02-28 01:40:04'),(409,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/4/fonts.css','2020-02-28 01:40:04'),(410,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-02-28 01:40:26'),(411,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/project_setup','2020-02-28 01:40:47'),(412,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/person_in_charge_setup/1','2020-02-28 01:41:04'),(413,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/get_Dept_Pic','2020-02-28 01:41:26'),(414,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-02-28 01:41:42'),(415,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-02-28 01:41:45'),(416,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-02-28 01:41:55'),(417,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-02-28 01:42:01'),(418,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-02-28 01:42:08'),(419,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/22','2020-02-28 01:44:30'),(420,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/fonts.css','2020-02-28 01:44:31'),(421,'115.164.185.205','http://salihin.noip.me/pelita.dev/dashboard','2020-02-28 08:09:51'),(422,'115.164.185.205','http://salihin.noip.me/pelita.dev/dashboard','2020-02-28 08:10:48'),(423,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-02-28 08:11:32'),(424,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-02-28 08:11:41'),(425,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-02-28 08:11:46'),(426,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-02-28 08:11:48'),(427,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-02-28 08:12:59'),(428,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/2','2020-02-28 08:13:28'),(429,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-02-28 08:13:29'),(430,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-02-28 08:13:54'),(431,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-02-28 08:14:13'),(432,'115.164.185.205','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-02-28 08:14:14'),(433,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-03-04 03:05:20'),(434,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-04 03:05:26'),(435,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-04 03:05:28'),(436,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-04 03:05:31'),(437,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-04 03:05:32'),(438,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-04 03:06:02'),(439,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-04 03:06:05'),(440,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-04 03:06:40'),(441,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-04 03:06:41'),(442,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-04 03:07:33'),(443,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-04 03:07:36'),(444,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-04 03:07:54'),(445,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-04 03:07:55'),(446,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-04 03:08:04'),(447,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-03-04 03:09:51'),(448,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-03-04 03:09:56'),(449,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-03-16 08:46:29'),(450,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 08:53:13'),(451,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 08:53:24'),(452,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 08:53:45'),(453,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 08:54:04'),(454,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 08:54:05'),(455,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/readFile','2020-03-16 08:54:20'),(456,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-03-16 09:00:50'),(457,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:01:43'),(458,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:01:46'),(459,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:02:02'),(460,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:02:03'),(461,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:04:52'),(462,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/2','2020-03-16 09:05:27'),(463,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:05:28'),(464,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:05:30'),(465,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:06:22'),(466,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:06:23'),(467,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:08:33'),(468,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:08:53'),(469,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/6','2020-03-16 09:09:17'),(470,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:09:18'),(471,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:09:51'),(472,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/2/9','2020-03-16 09:10:28'),(473,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/2/fonts.css','2020-03-16 09:10:28'),(474,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:10:31'),(475,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/22','2020-03-16 09:10:35'),(476,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/fonts.css','2020-03-16 09:10:36'),(477,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:10:42'),(478,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-03-16 09:10:48'),(479,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/project_setup','2020-03-16 09:10:51'),(480,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:11:14'),(481,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:11:17'),(482,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:11:21'),(483,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/24','2020-03-16 09:11:27'),(484,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/fonts.css','2020-03-16 09:11:28'),(485,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:11:35'),(486,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/4/0','2020-03-16 09:11:49'),(487,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/4/fonts.css','2020-03-16 09:11:49'),(488,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:11:56'),(489,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/2','2020-03-16 09:11:57'),(490,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:11:58'),(491,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:11:59'),(492,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/7/0','2020-03-16 09:12:02'),(493,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/7/fonts.css','2020-03-16 09:12:03'),(494,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:12:04'),(495,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/7','2020-03-16 09:12:06'),(496,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:12:07'),(497,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:12:09'),(498,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-03-16 09:12:24'),(499,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:24:16'),(500,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:24:24'),(501,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:24:35'),(502,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:24:35'),(503,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:24:38'),(504,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:24:40'),(505,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:24:40'),(506,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:24:46'),(507,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:25:01'),(508,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:25:01'),(509,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:26:28'),(510,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:26:33'),(511,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:26:46'),(512,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:26:47'),(513,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:27:36'),(514,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/2/9','2020-03-16 09:27:47'),(515,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/2/fonts.css','2020-03-16 09:27:48'),(516,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:27:50'),(517,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/2/9','2020-03-16 09:28:25'),(518,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/2/fonts.css','2020-03-16 09:28:26'),(519,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:28:31'),(520,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/22','2020-03-16 09:28:35'),(521,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/3/fonts.css','2020-03-16 09:28:35'),(522,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_setup','2020-03-16 09:28:47'),(523,'175.138.91.123','http://salihin.noip.me/pelita.dev/Setup/financial_details_setup/1','2020-03-16 09:28:50'),(524,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:29:00'),(525,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:29:05'),(526,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:29:15'),(527,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:29:16'),(528,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:30:45'),(529,'175.138.91.123','http://salihin.noip.me/pelita.dev/dashboard','2020-03-16 09:47:53'),(530,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:48:39'),(531,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:48:47'),(532,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/1','2020-03-16 09:49:08'),(533,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/requirementDetails/1/1/fonts.css','2020-03-16 09:49:09'),(534,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/project_list','2020-03-16 09:50:01'),(535,'175.138.91.123','http://salihin.noip.me/pelita.dev/Audits/index/1','2020-03-16 09:52:00'),(536,'210.195.51.25','http://salihin.noip.me/pelita.dev/dashboard','2020-03-16 15:09:46'),(537,'210.195.51.25','http://salihin.noip.me/pelita.dev/dashboard','2020-03-16 15:12:08'),(538,'42.153.140.33','http://salihin.noip.me/pelita.dev/dashboard','2020-03-16 15:19:21');

--
-- Table structure for table `jvc`
--

CREATE TABLE `jvc` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `jvc` varchar(128) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jvc`
--

INSERT INTO `jvc` VALUES (1,'Bousted Pelita Kanawit',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00'),(2,'PJP Pelita Selangau Plantation S/B',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00'),(3,'Harn Lern Pelita Bangunan S/B',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00'),(4,'PJP Pelita Ulu Teru Plantation S/B',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00'),(5,'TH Pelita Beladin S/B',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00'),(6,'PJP Pelita Ekang-Banyak Plantation S/B',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00'),(7,'TH Pelita Simunjan S/B',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00'),(8,'PELITA',0,0,'2020-01-28 08:47:50',0,'0000-00-00 00:00:00');

--
-- Table structure for table `project__pic`
--

CREATE TABLE `project__pic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `is_leader` tinyint(1) NOT NULL DEFAULT '0',
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project__pic`
--

INSERT INTO `project__pic` VALUES (1,0,0,13,0,1,309,'2020-02-19 03:21:27',309,'0000-00-00 00:00:00'),(2,1,0,1,0,1,309,'2020-02-19 03:21:29',309,'0000-00-00 00:00:00'),(3,1,0,1,0,1,309,'2020-02-19 03:21:32',309,'0000-00-00 00:00:00'),(4,1,0,5,0,1,309,'2020-02-19 03:21:36',309,'0000-00-00 00:00:00'),(5,1,0,242,0,1,309,'2020-02-19 03:21:38',0,'0000-00-00 00:00:00'),(6,1,1,309,0,1,309,'2020-02-19 13:33:33',309,'2020-02-19 21:33:33'),(7,1,1,265,0,1,309,'2020-02-19 13:35:02',309,'2020-02-19 21:35:02'),(8,2,1,265,0,0,309,'2020-02-19 03:56:21',0,'0000-00-00 00:00:00'),(9,1,1,18,0,1,309,'2020-02-19 13:45:24',309,'2020-02-19 21:45:24'),(10,1,2,80,0,1,309,'2020-02-19 13:47:06',309,'2020-02-19 21:47:06'),(11,1,1,374,0,1,265,'2020-02-19 13:58:58',309,'2020-02-19 21:58:58'),(12,1,10,173,1,0,309,'2020-02-20 06:12:10',309,'0000-00-00 00:00:00'),(13,1,9,308,1,0,309,'2020-02-20 06:19:15',309,'0000-00-00 00:00:00'),(14,0,1,18,0,0,309,'2020-02-19 08:34:18',0,'0000-00-00 00:00:00'),(15,0,1,304,0,0,309,'2020-02-19 09:20:21',0,'0000-00-00 00:00:00'),(16,1,1,304,0,1,309,'2020-02-19 13:58:54',309,'2020-02-19 21:58:54'),(17,1,1,79,0,1,309,'2020-02-19 13:59:38',309,'2020-02-19 21:59:38'),(18,1,1,54,0,0,309,'2020-02-19 13:47:17',0,'0000-00-00 00:00:00'),(19,1,2,16,0,0,309,'2020-02-19 13:47:38',0,'0000-00-00 00:00:00'),(20,1,1,164,0,1,309,'2020-02-19 13:59:33',309,'2020-02-19 21:59:33'),(21,1,1,19,0,0,309,'2020-02-19 13:49:22',0,'0000-00-00 00:00:00'),(22,1,4,95,1,0,164,'2020-02-26 00:51:46',164,'0000-00-00 00:00:00'),(23,2,1,309,0,1,309,'2020-02-19 14:01:16',309,'2020-02-19 22:01:16'),(24,2,1,54,0,0,309,'2020-02-20 06:24:03',309,'0000-00-00 00:00:00'),(25,3,1,265,0,0,164,'2020-02-20 06:35:13',0,'0000-00-00 00:00:00'),(26,3,2,83,0,1,164,'2020-02-20 06:36:13',164,'2020-02-20 14:36:13'),(27,3,10,367,0,0,164,'2020-02-20 06:35:48',164,'0000-00-00 00:00:00');

--
-- Table structure for table `project_acct_type`
--

CREATE TABLE `project_acct_type` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `acctTypeName` varchar(128) NOT NULL,
  `acctClass` smallint(6) NOT NULL,
  `balance` smallint(1) NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_acct_type`
--

INSERT INTO `project_acct_type` VALUES (1,'Assets',0,0,1,'2014-05-07 21:01:48',0,'0000-00-00 00:00:00'),(2,'Liability',0,1,1,'2014-05-07 21:01:48',0,'2014-09-02 19:00:33'),(3,'Income',1,0,1,'2014-05-07 21:01:48',0,'0000-00-00 00:00:00'),(4,'Expenses',1,1,1,'2014-05-07 21:01:48',0,'2014-09-21 17:59:38'),(5,'Equity',0,1,1,'2014-08-06 18:49:35',0,'2014-09-02 19:00:39'),(6,'Financial Ratio',0,0,0,'2016-08-28 16:00:00',0,'2016-08-28 22:06:26'),(7,'Income Ratio',1,0,0,'2016-08-28 16:00:00',0,'2016-08-28 22:06:29');

--
-- Table structure for table `project_chart_of_acct`
--

CREATE TABLE `project_chart_of_acct` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `acctGroupID` int(11) NOT NULL,
  `acctCode` char(9) NOT NULL,
  `acctName` varchar(128) NOT NULL,
  `acctDesc` varchar(128) NOT NULL,
  `openingBalanceDr` double NOT NULL,
  `openingBalanceCr` double NOT NULL,
  `createdBy` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBy` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `is_delete` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `companyID` (`project_id`),
  KEY `acctGroupID` (`acctGroupID`),
  KEY `acctCode` (`acctCode`),
  KEY `acctName` (`acctName`),
  KEY `ID` (`ID`),
  KEY `companyID_2` (`project_id`),
  KEY `acctGroupID_2` (`acctGroupID`),
  KEY `is_delete` (`is_delete`)
) ENGINE=InnoDB AUTO_INCREMENT=434 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_chart_of_acct`
--

INSERT INTO `project_chart_of_acct` VALUES (1,1,1,'110000000','Share Capital','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(2,1,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(3,1,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(4,1,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(5,1,2,'200010000','Intangible Assets','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(6,1,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(7,1,3,'230100000','Inventories','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(8,1,3,'230200000','Trade Receivables','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(9,1,3,'230200100','Other Receivables','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(10,1,3,'230300000','Tax Receivables','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(11,1,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(12,1,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(13,1,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(14,1,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(15,1,4,'300000000','Trade Payable','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(16,1,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(17,1,4,'32000000','Tax Payable','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(18,1,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(19,1,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(20,1,4,'350000000','Term Loans','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(21,1,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(22,1,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(23,1,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(24,1,7,'400000000','Revenue','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(25,1,8,'500000000','Direct Expenses','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(26,1,9,'700000000','Other Income','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(27,1,10,'810000000','Administration Expenses','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(28,1,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(29,1,44,'830000000','Finance Cost','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(30,1,12,'840000000','Taxation','',0,0,0,'2020-02-03 02:55:17',0,'0000-00-00 00:00:00',0),(32,2,1,'110000000','Share Capital','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(33,2,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(34,2,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(35,2,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(36,2,2,'200010000','Intangible Assets','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(37,2,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(38,2,3,'230100000','Inventories','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(39,2,3,'230200000','Trade Receivables','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(40,2,3,'230200100','Other Receivables','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(41,2,3,'230300000','Tax Receivables','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(42,2,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(43,2,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(44,2,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(45,2,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(46,2,4,'300000000','Trade Payable','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(47,2,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(48,2,4,'32000000','Tax Payable','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(49,2,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(50,2,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(51,2,4,'350000000','Term Loans','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(52,2,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(53,2,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(54,2,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(55,2,7,'400000000','Revenue','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(56,2,8,'500000000','Direct Expenses','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(57,2,9,'700000000','Other Income','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(58,2,10,'810000000','Administration Expenses','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(59,2,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(60,2,44,'830000000','Finance Cost','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(61,2,12,'840000000','Taxation','',0,0,0,'2020-02-03 02:59:00',0,'0000-00-00 00:00:00',0),(63,4,1,'110000000','Share Capital','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(64,4,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(65,4,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(66,4,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(67,4,2,'200010000','Intangible Assets','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(68,4,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(69,4,3,'230100000','Inventories','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(70,4,3,'230200000','Trade Receivables','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(71,4,3,'230200100','Other Receivables','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(72,4,3,'230300000','Tax Receivables','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(73,4,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(74,4,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(75,4,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(76,4,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(77,4,4,'300000000','Trade Payable','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(78,4,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(79,4,4,'32000000','Tax Payable','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(80,4,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(81,4,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(82,4,4,'350000000','Term Loans','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(83,4,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(84,4,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(85,4,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(86,4,7,'400000000','Revenue','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(87,4,8,'500000000','Direct Expenses','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(88,4,9,'700000000','Other Income','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(89,4,10,'810000000','Administration Expenses','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(90,4,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(91,4,44,'830000000','Finance Cost','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(92,4,12,'840000000','Taxation','',0,0,0,'2020-02-11 08:39:19',0,'0000-00-00 00:00:00',0),(94,7,1,'110000000','Share Capital','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(95,7,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(96,7,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(97,7,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(98,7,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(99,7,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(100,7,3,'230100000','Inventories','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(101,7,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(102,7,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(103,7,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(104,7,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(105,7,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(106,7,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(107,7,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(108,7,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(109,7,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(110,7,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(111,7,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(112,7,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(113,7,4,'350000000','Term Loans','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(114,7,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(115,7,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(116,7,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(117,7,7,'400000000','Revenue','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(118,7,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(119,7,9,'700000000','Other Income','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(120,7,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(121,7,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(122,7,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(123,7,12,'840000000','Taxation','',0,0,0,'2020-02-12 07:50:07',0,'0000-00-00 00:00:00',0),(125,3,1,'110000000','Share Capital','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(126,3,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(127,3,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(128,3,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(129,3,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(130,3,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(131,3,3,'230100000','Inventories','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(132,3,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(133,3,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(134,3,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(135,3,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(136,3,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(137,3,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(138,3,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(139,3,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(140,3,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(141,3,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(142,3,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(143,3,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(144,3,4,'350000000','Term Loans','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(145,3,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(146,3,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(147,3,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(148,3,7,'400000000','Revenue','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(149,3,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(150,3,9,'700000000','Other Income','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(151,3,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(152,3,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(153,3,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(154,3,12,'840000000','Taxation','',0,0,0,'2020-02-12 07:50:32',0,'0000-00-00 00:00:00',0),(156,6,1,'110000000','Share Capital','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(157,6,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(158,6,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(159,6,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(160,6,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(161,6,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(162,6,3,'230100000','Inventories','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(163,6,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(164,6,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(165,6,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(166,6,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(167,6,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(168,6,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(169,6,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(170,6,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(171,6,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(172,6,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(173,6,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(174,6,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(175,6,4,'350000000','Term Loans','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(176,6,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(177,6,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(178,6,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(179,6,7,'400000000','Revenue','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(180,6,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(181,6,9,'700000000','Other Income','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(182,6,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(183,6,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(184,6,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(185,6,12,'840000000','Taxation','',0,0,0,'2020-02-12 07:52:31',0,'0000-00-00 00:00:00',0),(187,5,1,'110000000','Share Capital','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(188,5,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(189,5,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(190,5,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(191,5,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(192,5,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(193,5,3,'230100000','Inventories','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(194,5,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(195,5,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(196,5,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(197,5,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(198,5,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(199,5,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(200,5,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(201,5,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(202,5,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(203,5,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(204,5,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(205,5,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(206,5,4,'350000000','Term Loans','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(207,5,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(208,5,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(209,5,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(210,5,7,'400000000','Revenue','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(211,5,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(212,5,9,'700000000','Other Income','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(213,5,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(214,5,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(215,5,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(216,5,12,'840000000','Taxation','',0,0,0,'2020-02-12 07:53:11',0,'0000-00-00 00:00:00',0),(218,10,1,'110000000','Share Capital','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(219,10,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(220,10,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(221,10,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(222,10,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(223,10,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(224,10,3,'230100000','Inventories','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(225,10,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(226,10,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(227,10,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(228,10,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(229,10,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(230,10,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(231,10,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(232,10,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(233,10,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(234,10,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(235,10,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(236,10,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(237,10,4,'350000000','Term Loans','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(238,10,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(239,10,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(240,10,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(241,10,7,'400000000','Revenue','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(242,10,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(243,10,9,'700000000','Other Income','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(244,10,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(245,10,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(246,10,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(247,10,12,'840000000','Taxation','',0,0,0,'2020-02-12 07:54:18',0,'0000-00-00 00:00:00',0),(249,8,1,'110000000','Share Capital','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(250,8,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(251,8,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(252,8,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(253,8,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(254,8,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(255,8,3,'230100000','Inventories','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(256,8,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(257,8,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(258,8,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(259,8,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(260,8,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(261,8,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(262,8,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(263,8,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(264,8,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(265,8,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(266,8,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(267,8,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(268,8,4,'350000000','Term Loans','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(269,8,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(270,8,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(271,8,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(272,8,7,'400000000','Revenue','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(273,8,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(274,8,9,'700000000','Other Income','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(275,8,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(276,8,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(277,8,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(278,8,12,'840000000','Taxation','',0,0,0,'2020-02-12 22:13:05',0,'0000-00-00 00:00:00',0),(280,9,1,'110000000','Share Capital','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(281,9,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(282,9,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(283,9,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(284,9,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(285,9,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(286,9,3,'230100000','Inventories','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(287,9,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(288,9,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(289,9,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(290,9,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(291,9,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(292,9,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(293,9,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(294,9,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(295,9,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(296,9,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(297,9,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(298,9,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(299,9,4,'350000000','Term Loans','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(300,9,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(301,9,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(302,9,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(303,9,7,'400000000','Revenue','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(304,9,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(305,9,9,'700000000','Other Income','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(306,9,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(307,9,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(308,9,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(309,9,12,'840000000','Taxation','',0,0,0,'2020-02-12 22:20:14',0,'0000-00-00 00:00:00',0),(311,11,1,'110000000','Share Capital','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(312,11,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(313,11,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(314,11,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(315,11,2,'200010000','Intangible Assets','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(316,11,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(317,11,3,'230100000','Inventories','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(318,11,3,'230200000','Trade Receivables','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(319,11,3,'230200100','Other Receivables','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(320,11,3,'230300000','Tax Receivables','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(321,11,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(322,11,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(323,11,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(324,11,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(325,11,4,'300000000','Trade Payable','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(326,11,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(327,11,4,'32000000','Tax Payable','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(328,11,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(329,11,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(330,11,4,'350000000','Term Loans','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(331,11,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(332,11,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(333,11,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(334,11,7,'400000000','Revenue','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(335,11,8,'500000000','Direct Expenses','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(336,11,9,'700000000','Other Income','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(337,11,10,'810000000','Administration Expenses','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(338,11,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(339,11,44,'830000000','Finance Cost','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(340,11,12,'840000000','Taxation','',0,0,0,'2020-02-12 22:24:28',0,'0000-00-00 00:00:00',0),(342,16,1,'110000000','Share Capital','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(343,16,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(344,16,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(345,16,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(346,16,2,'200010000','Intangible Assets','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(347,16,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(348,16,3,'230100000','Inventories','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(349,16,3,'230200000','Trade Receivables','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(350,16,3,'230200100','Other Receivables','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(351,16,3,'230300000','Tax Receivables','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(352,16,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(353,16,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(354,16,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(355,16,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(356,16,4,'300000000','Trade Payable','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(357,16,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(358,16,4,'32000000','Tax Payable','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(359,16,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(360,16,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(361,16,4,'350000000','Term Loans','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(362,16,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(363,16,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(364,16,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(365,16,7,'400000000','Revenue','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(366,16,8,'500000000','Direct Expenses','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(367,16,9,'700000000','Other Income','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(368,16,10,'810000000','Administration Expenses','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(369,16,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(370,16,44,'830000000','Finance Cost','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(371,16,12,'840000000','Taxation','',0,0,0,'2020-02-14 08:52:01',0,'0000-00-00 00:00:00',0),(373,12,1,'110000000','Share Capital','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(374,12,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(375,12,1,'130000000','Current Year Earnings','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(376,12,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(377,12,2,'200010000','Intangible Assets','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(378,12,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(379,12,3,'230100000','Inventories','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(380,12,3,'230200000','Trade Receivables','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(381,12,3,'230200100','Other Receivables','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(382,12,3,'230300000','Tax Receivables','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(383,12,3,'230400000','Amount Due From Director','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(384,12,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(385,12,3,'230600000','Fixed Deposits','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(386,12,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(387,12,4,'300000000','Trade Payable','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(388,12,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(389,12,4,'32000000','Tax Payable','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(390,12,4,'330000000','Bank Overdraft','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(391,12,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(392,12,4,'350000000','Term Loans','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(393,12,4,'360000000','Provision For Taxation','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(394,12,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(395,12,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(396,12,7,'400000000','Revenue','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(397,12,8,'500000000','Direct Expenses','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(398,12,9,'700000000','Other Income','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(399,12,10,'810000000','Administration Expenses','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(400,12,10,'820000000','Other Operating Expenses','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(401,12,44,'830000000','Finance Cost','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(402,12,12,'840000000','Taxation','',0,0,0,'2020-02-17 00:48:31',0,'0000-00-00 00:00:00',0),(404,14,1,'110000000','Share Capital','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(405,14,1,'120000000','Retained Earnings-Prior Year','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(406,14,1,'130000000','Current Year Earnings','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(407,14,2,'200000000','Property, Plant & Equipment','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(408,14,2,'200010000','Intangible Assets','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(409,14,2,'200020000','Deferred Tax Assets','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(410,14,3,'230100000','Inventories','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(411,14,3,'230200000','Trade Receivables','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(412,14,3,'230200100','Other Receivables','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(413,14,3,'230300000','Tax Receivables','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(414,14,3,'230400000','Amount Due From Director','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(415,14,3,'230500000','Amount Due From Related Companies','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(416,14,3,'230600000','Fixed Deposits','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(417,14,3,'230700000','Cash & Bank Balances','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(418,14,4,'300000000','Trade Payable','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(419,14,4,'310000000','Other Payables & Accruals','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(420,14,4,'32000000','Tax Payable','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(421,14,4,'330000000','Bank Overdraft','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(422,14,4,'340000000','Bankers\' Acceptance','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(423,14,4,'350000000','Term Loans','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(424,14,4,'360000000','Provision For Taxation','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(425,14,6,'370000000','Long-Term Liabilities','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(426,14,6,'380000000','Deferred Tax Liabilities','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(427,14,7,'400000000','Revenue','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(428,14,8,'500000000','Direct Expenses','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(429,14,9,'700000000','Other Income','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(430,14,10,'810000000','Administration Expenses','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(431,14,10,'820000000','Other Operating Expenses','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(432,14,44,'830000000','Finance Cost','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0),(433,14,12,'840000000','Taxation','',0,0,0,'2020-03-02 08:27:00',0,'0000-00-00 00:00:00',0);

--
-- Table structure for table `project_comment`
--

CREATE TABLE `project_comment` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `working_id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `summary` text NOT NULL,
  `createdBY` int(11) NOT NULL,
  `createdTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedBY` int(11) NOT NULL,
  `updatedTS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_delete` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_comment`
--

INSERT INTO `project_comment` VALUES (1,1,24,'You have to submit this before 29/2/2019\r\n\r\n1. satu\r\n2. dua \r\n3. tiga\r\n4. empat\r\n5. Lima\r\n6. enam',0,'2020-02-07 08:44:20',265,'2020-02-13 09:12:37',0),(2,1,24,'<p>w</p>',0,'2020-02-07 08:44:20',0,'2020-02-06 03:49:03',1),(3,1,24,'<p><br></p>',0,'2020-02-07 08:44:20',0,'2020-02-06 04:09:32',1),(4,0,24,'<p>try</p>',0,'2020-02-07 08:44:20',0,'2020-02-06 09:25:26',1),(5,0,24,'<p><br></p>',0,'2020-02-07 08:44:20',0,'2020-02-06 09:26:13',1),(6,1,24,'<p>try ttt tttt 66 tt</p>',0,'2020-02-07 08:44:20',0,'2020-02-07 02:01:14',1),(7,1,271,'<p>salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas salah halas </p>',0,'2020-02-07 08:44:20',0,'2020-02-07 04:26:39',1),(8,2,19,'<p>asfdsgfdshh</p><p><br></p>',0,'2020-02-07 08:44:20',0,'2020-02-07 04:55:39',1),(9,3,19,'<p>kdhbsagjkbagub</p>',0,'2020-02-07 08:44:20',0,'2020-02-07 06:51:55',1),(10,1,24,'<p>tttttttttttttt</p>',0,'2020-02-07 08:44:20',0,'2020-02-07 07:51:37',1),(11,1,24,'<p>csdcsdcsttttttt</p>',0,'2020-02-07 08:44:20',24,'2020-02-10 04:41:50',1),(12,1,24,'<p>csdcsdcstttt</p>',0,'2020-02-07 08:44:20',24,'2020-02-10 04:40:40',1),(13,1,24,'<p>aaaa</p>',0,'2020-02-07 08:44:20',0,'2020-02-07 07:53:33',1),(14,1,265,'<p>test</p>',265,'2020-02-10 02:45:10',0,'2020-02-10 02:45:10',1),(15,40,242,'<p>Testing 1</p>',242,'2020-02-10 03:18:26',242,'2020-02-10 03:20:41',1),(16,1,265,'<p>testing asdasd</p>',265,'2020-02-10 07:14:56',0,'2020-02-10 07:14:56',1),(17,41,265,'<p>cuba try test	</p>',265,'2020-02-10 07:24:28',0,'2020-02-10 07:24:28',1),(25,45,242,'Testing insert',242,'2020-02-10 09:31:15',0,'2020-02-10 09:31:15',0),(26,45,242,'Testing update',242,'2020-02-10 09:31:51',0,'2020-02-10 09:31:51',0),(27,45,242,'Testing update bb',242,'2020-02-10 09:38:58',0,'2020-02-10 09:38:58',0),(28,45,242,'Testing update bbbb',242,'2020-02-10 09:42:07',0,'2020-02-10 09:42:07',0),(29,38,24,'try',24,'2020-02-10 09:46:35',0,'2020-02-10 09:46:35',0),(30,38,24,'try 123',24,'2020-02-10 09:46:59',0,'2020-02-10 09:46:59',0),(31,38,24,'try 123 1213131',24,'2020-02-10 09:48:07',0,'2020-02-10 09:48:07',0),(32,37,24,'Testing Comment project 2!',24,'2020-02-10 09:54:09',242,'2020-02-17 01:06:55',0),(33,46,304,'selesai sudah',304,'2020-02-11 02:31:46',0,'2020-02-11 02:31:46',0),(34,2,24,'Testing komen 2',24,'2020-02-12 06:26:39',242,'2020-02-12 06:32:55',0),(35,48,242,'Testing KOMEN',242,'2020-02-12 06:30:22',242,'2020-02-12 06:32:07',0),(36,12,24,'try commentss',24,'2020-02-13 01:08:43',24,'2020-02-13 01:13:06',0),(37,118,265,'Comment for audit working term 4',265,'2020-02-13 01:51:20',0,'2020-02-13 01:51:20',0),(38,138,265,'Comment for audit working term 3',265,'2020-02-13 01:53:28',265,'2020-02-13 01:53:58',0),(39,7,19,'dasddsdd',19,'2020-02-13 07:48:55',0,'2020-02-13 07:48:55',0),(40,182,242,'testing',242,'2020-02-14 08:33:14',0,'2020-02-14 08:33:14',0);

--
-- Table structure for table `project_details`
--

CREATE TABLE `project_details` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `phase` int(11) NOT NULL,
  `land_id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `jvc_id` int(11) NOT NULL,
  `division_id` int(11) NOT NULL,
  `ga_ha` varchar(128) NOT NULL,
  `pa_ha` varchar(128) NOT NULL,
  `investor_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_details`
--

INSERT INTO `project_details` VALUES (1,1,1,'Kanawit Block B & D',1,1,'14384.00','10363.10',1,0,0,309,'2020-02-18 08:11:28',309,'0000-00-00 00:00:00'),(2,1,1,'Ulu Selangau',2,1,'5824.00','3303.00',2,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(3,1,1,'Punggu, Ran Gua',3,4,'4276.00','5587.91',3,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(4,1,1,'Kpg. Semada, Simunjan (Semada Block)',3,11,'1136.00','430.27',3,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(5,1,1,'Ulu Teru, Baram',4,7,'5506.00','3890.80',2,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(6,1,1,'Beladin, Meludam',5,12,'1577.00','991.85',4,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(7,1,1,'Long Ikang (Ekang), Long Banyak, Baram, Marudi',6,7,'3367.00','1653.74',2,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(8,1,1,'Kepayang Semalatong, Simunjan',7,2,'9629.60','3348.78',4,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(9,1,2,'\"Tumbuhak (Kpg. Punang)\"',8,6,'900.00','212.75',5,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(10,1,2,'Sungai Sui',8,2,'1134.20','892.00',5,0,0,0,'2020-02-18 02:56:45',242,'2020-02-14 08:25:19'),(11,1,2,'Bintangor-Bunut',8,10,'3200.00','1250.00',5,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(12,1,2,'Kg.Empila',8,2,'608.00','337.38',5,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(13,1,3,'Batang Sadong',8,2,'1921.00','314.00',5,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(14,1,3,'Batang Lupar',8,4,'1600.00','1505.00',5,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(15,1,3,'Pulau Bruit',8,8,'4651.00','495.00',5,0,0,0,'2020-02-18 02:56:45',0,'0000-00-00 00:00:00'),(16,1,3,'Nanga Sekuau (RISDA)',8,1,'897.00','494.00',6,0,0,242,'2020-02-18 02:56:45',242,'2020-02-14 01:57:39'),(17,1,1,'try',1,1,'1234.00','1234.56',1,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(18,1,2,'try',2,2,'1234.00','1234.56',2,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(19,1,3,'try',1,1,'11111','11111',1,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(20,1,1,'try',1,1,'11111','11111',1,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(21,1,1,'why',2,2,'33','33',5,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(22,1,3,'Batang Lupar',8,4,'0','472.00',5,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(23,1,1,'tryyyy',1,1,'55','55',1,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(24,1,1,'www',2,1,'1122','1122',2,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(25,3,1,'test',1,1,'0','33',1,0,1,24,'2020-02-18 04:14:02',304,'2020-02-18 04:14:02'),(26,2,3,'Testing project',1,1,'34234','436543',6,0,1,265,'2020-02-18 04:14:09',304,'2020-02-18 04:14:09'),(27,1,1,'just want to try add new project setup',1,1,'1234.00','1234.56',1,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(28,1,2,'try jerr',2,2,'1212','1212',2,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(29,1,1,'eeeeee',1,1,'1312312','412313',4,0,1,24,'2020-02-18 02:56:45',24,'0000-00-00 00:00:00'),(30,1,1,'tak tau',3,2,'1122','1122',1,0,1,24,'2020-02-18 02:56:45',24,'2020-02-13 03:47:48'),(31,1,1,'Testing 2',2,2,'2','2',1,0,1,242,'2020-02-18 02:56:45',242,'2020-02-17 01:17:00'),(32,3,1,'test project name',1,4,'10000','12000',1,0,1,304,'2020-02-18 07:22:47',304,'2020-02-18 07:22:47'),(33,1,2,'sfsdfsdf',2,2,'33','2323',1,0,1,309,'2020-02-18 08:08:23',309,'2020-02-18 08:08:23');

--
-- Table structure for table `project_discussion`
--

CREATE TABLE `project_discussion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `working_id` int(11) NOT NULL,
  `discussion` text NOT NULL,
  `is_pinned` int(1) NOT NULL DEFAULT '0',
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_discussion`
--

INSERT INTO `project_discussion` VALUES (1,0,1,'tryyy',0,1,24,'2020-02-06 06:43:06',24,'2020-02-10 08:26:18'),(2,0,1,'<p>www.salihin</p>',0,0,24,'2020-02-06 07:51:30',24,'2020-02-10 05:00:02'),(3,0,2,'<p>www</p>',0,0,24,'2020-02-06 07:51:35',0,'0000-00-00 00:00:00'),(4,0,2,'<p>trty ttt aaaaaa</p>',0,0,24,'2020-02-07 01:45:35',0,'0000-00-00 00:00:00'),(5,0,2,'<p>test</p>',0,0,265,'2020-02-07 01:48:11',0,'0000-00-00 00:00:00'),(6,0,3,'<p>yy</p>',0,0,24,'2020-02-07 02:01:19',0,'0000-00-00 00:00:00'),(7,0,1,'<p>tttttttttttttttttttttttttttttttt&nbsp; yyyy</p>',0,1,24,'2020-02-07 07:53:38',24,'2020-02-11 04:11:00'),(8,0,40,'',0,0,242,'2020-02-10 03:20:30',242,'2020-02-10 03:30:51'),(9,0,32,'<p>qw</p>',0,1,242,'2020-02-10 03:52:32',242,'2020-02-14 02:15:43'),(10,0,1,'<p>asasdasda</p>',0,0,265,'2020-02-10 07:15:00',0,'0000-00-00 00:00:00'),(11,0,41,'<p>cuba try test satu kali</p>',0,0,265,'2020-02-10 07:24:41',0,'0000-00-00 00:00:00'),(12,0,42,'<p>test</p>',0,0,265,'2020-02-10 08:29:21',0,'0000-00-00 00:00:00'),(13,0,1,'<p>aizat</p>',0,0,19,'2020-02-10 08:48:51',0,'0000-00-00 00:00:00'),(14,0,1,'<p>satu</p>',0,0,242,'2020-02-11 03:52:10',0,'0000-00-00 00:00:00'),(15,0,7,'<p>testing</p>',0,0,265,'2020-02-11 08:20:55',0,'0000-00-00 00:00:00'),(16,0,7,'<p>teestttt</p>',0,0,265,'2020-02-11 08:26:47',0,'0000-00-00 00:00:00'),(17,0,1,'<p>test</p>',0,0,265,'2020-02-12 03:12:54',0,'0000-00-00 00:00:00'),(18,0,1,'<p>why me</p>',0,0,24,'2020-02-12 03:19:39',0,'0000-00-00 00:00:00'),(19,0,1,'<p>Testing SCROLL View</p>',0,0,242,'2020-02-12 03:54:42',0,'0000-00-00 00:00:00'),(20,0,1,'<ol><li>ayu</li><li>nad</li><li>kak biha</li><li>arep</li><li>ayed</li></ol>',0,0,24,'2020-02-12 04:00:27',24,'2020-02-13 01:51:39'),(21,0,2,'<p>change</p>',0,0,24,'2020-02-12 06:18:50',0,'0000-00-00 00:00:00'),(22,0,37,'<p>Please use this Column for any further issues. TQ. Next.</p>',0,0,265,'2020-02-13 01:11:35',265,'2020-02-13 01:22:08'),(23,0,12,'<p>try discussion rrr</p>',0,0,24,'2020-02-13 01:13:22',24,'2020-02-13 01:22:33'),(24,0,37,'<p>Noted. Thanks</p>',0,1,242,'2020-02-13 01:22:54',242,'2020-02-14 02:13:55'),(25,0,1,'<p>test comment only</p>',0,1,24,'2020-02-13 01:50:39',24,'2020-02-13 01:51:17'),(26,0,118,'<p>discuss on audit working term 4</p>',0,0,265,'2020-02-13 01:51:39',0,'0000-00-00 00:00:00'),(27,0,138,'<p>Project discussion for audit working term 3</p>',0,0,265,'2020-02-13 01:53:51',0,'0000-00-00 00:00:00'),(28,0,1,'<p>try post edit</p>',0,1,24,'2020-02-13 01:59:01',24,'2020-02-13 01:59:27'),(29,0,10,'<p>New Issues. Please take note.</p>',0,1,242,'2020-02-13 01:59:20',242,'2020-02-13 01:59:37'),(30,0,10,'<p>New Issues. Please take note.</p>',0,1,242,'2020-02-13 01:59:42',242,'2020-02-13 02:06:44'),(31,0,10,'<p>Take note next issue. Thanks.</p>',0,0,242,'2020-02-13 02:08:01',242,'2020-02-13 02:08:13'),(32,0,119,'<p>Noted</p>',0,1,242,'2020-02-13 02:39:11',242,'2020-02-13 08:13:54'),(33,0,119,'<p>Noted</p>',0,1,242,'2020-02-13 07:26:13',242,'2020-02-13 07:58:16'),(34,0,119,'<p>Post here</p>',0,1,242,'2020-02-13 07:30:18',242,'2020-02-13 07:57:00'),(35,0,1,'<p>testingdsada</p>',0,0,19,'2020-02-13 07:46:04',19,'2020-02-13 07:46:22'),(36,0,1,'<p>Testing 1234</p>',0,0,19,'2020-02-13 07:46:30',0,'0000-00-00 00:00:00'),(37,0,1,'<p>test kewtuuu</p>',0,0,265,'2020-02-13 09:12:48',0,'0000-00-00 00:00:00'),(38,0,12,'<p>Discussion about working details</p><p><br></p>',0,0,265,'2020-02-14 02:20:45',0,'0000-00-00 00:00:00'),(39,0,8,'',0,1,265,'2020-02-14 02:23:24',265,'2020-02-14 02:31:46'),(40,0,8,'<p><img src=\"data:image/jpeg;base64,[BLOB]',0,1,265,'2020-02-14 02:23:58',265,'2020-02-14 02:24:28'),(41,0,8,'<p>testing 123</p>',0,0,265,'2020-02-14 02:31:53',265,'2020-02-14 02:32:18'),(42,0,8,'<p>123 test edit without quill</p><p><br></p>',0,0,265,'2020-02-14 02:34:13',265,'2020-02-14 02:45:03'),(43,0,85,'<p>test123456</p>',0,0,304,'2020-02-14 02:52:41',304,'2020-02-14 02:55:38'),(44,0,1,'try again',0,0,24,'2020-02-14 03:38:42',0,'0000-00-00 00:00:00'),(45,0,1,'cuba je',0,0,24,'2020-02-14 03:40:11',0,'0000-00-00 00:00:00'),(46,0,1,'try again for test',0,0,24,'2020-02-14 03:43:00',0,'0000-00-00 00:00:00'),(47,0,1,'weyy',0,0,24,'2020-02-14 03:44:33',0,'0000-00-00 00:00:00'),(48,0,1,'hoiii',0,0,24,'2020-02-14 03:45:27',0,'0000-00-00 00:00:00'),(49,0,1,'one\r\ntwo\r\nthree\r\nfour\r\nfive\r\nsix\r\nseven\r\n',0,1,24,'2020-02-14 03:52:28',24,'2020-02-14 03:56:26'),(50,0,60,'Testing sizing',0,1,242,'2020-02-14 09:06:23',242,'2020-02-14 09:08:44'),(51,0,1,'Testing scroll \r\n1\r\n2\r\n3\r\n4\r\n',0,0,242,'2020-02-14 09:26:34',0,'0000-00-00 00:00:00'),(52,0,1,'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32. Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.',0,0,242,'2020-02-14 09:28:22',0,'0000-00-00 00:00:00'),(53,0,1,'try',0,0,24,'2020-02-17 00:44:55',0,'0000-00-00 00:00:00'),(54,0,1,'whyyyyyyyyyyyyyyyyyyyyyy',0,1,24,'2020-02-17 00:58:47',24,'2020-02-17 01:02:34'),(55,0,37,'Noted.',0,0,242,'2020-02-17 01:07:46',0,'0000-00-00 00:00:00');

--
-- Table structure for table `project_division`
--

CREATE TABLE `project_division` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_division`
--

INSERT INTO `project_division` VALUES (1,'Sibu',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(2,'Samarahan',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(3,'Bintulu',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(4,'Sri Aman',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(5,'Simunjan',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(6,'Limbang',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(7,'Miri',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(8,'Mukah',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(9,'Kuching',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(10,'Sarikei',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(11,'Serian',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(12,'Betong',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00'),(13,'Kapit',0,0,'2020-01-28 08:15:49',0,'0000-00-00 00:00:00');

--
-- Table structure for table `project_financial_year`
--

CREATE TABLE `project_financial_year` (
  `ID` int(11) NOT NULL,
  `year` year(4) NOT NULL,
  `is_delete` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_financial_year`
--

INSERT INTO `project_financial_year` VALUES (0,2018,0),(0,2019,0);

--
-- Table structure for table `project_land`
--

CREATE TABLE `project_land` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `land` varchar(128) NOT NULL,
  `hectare` varchar(128) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_land`
--

INSERT INTO `project_land` VALUES (1,'NCR Land','0',0,0,'2020-01-28 07:50:27',0,0),(2,'Ladang Rakyat','0',0,0,'2020-01-28 07:50:27',0,0),(3,'Ladang Sejahtera','0',0,0,'2020-01-28 07:50:27',0,0);

--
-- Table structure for table `project_opening_balance`
--

CREATE TABLE `project_opening_balance` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `debit` double NOT NULL,
  `credit` double NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `companyID` (`project_id`),
  KEY `accountID` (`account_id`),
  KEY `year` (`year`),
  KEY `debit` (`debit`),
  KEY `credit` (`credit`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_opening_balance`
--

INSERT INTO `project_opening_balance` VALUES (1,1,1,2019,0,0,0,'2020-02-05 08:44:13',309,'0000-00-00 00:00:00',309),(2,1,1,2018,0,1000000,0,'2020-02-05 08:44:17',79,'0000-00-00 00:00:00',79),(3,1,2,2019,0,1639205,0,'2020-02-05 08:44:30',79,'0000-00-00 00:00:00',79),(4,1,2,2018,0,1466438,0,'2020-02-05 08:44:35',79,'0000-00-00 00:00:00',79),(5,1,24,2019,0,477127,0,'2020-02-05 08:45:21',309,'0000-00-00 00:00:00',309),(6,1,24,2018,0,474994,0,'2020-02-05 08:45:27',79,'0000-00-00 00:00:00',79),(7,1,25,2019,414354,0,0,'2020-02-05 12:17:32',79,'0000-00-00 00:00:00',79),(8,1,25,2018,291238,0,0,'2020-02-05 12:35:41',79,'0000-00-00 00:00:00',79),(9,1,4,2019,3720080,0,0,'2020-02-06 03:09:31',79,'0000-00-00 00:00:00',79),(10,1,4,2018,3721309,0,0,'2020-02-06 03:09:38',79,'0000-00-00 00:00:00',79),(11,1,8,2019,0,0,0,'2020-02-06 03:56:02',79,'0000-00-00 00:00:00',79),(12,1,15,2019,0,3022535,0,'2020-02-06 03:56:30',79,'0000-00-00 00:00:00',79),(13,1,15,2018,0,2608289,0,'2020-02-06 04:09:07',79,'0000-00-00 00:00:00',79),(14,1,8,2018,1854716,0,0,'2020-02-06 04:09:20',79,'0000-00-00 00:00:00',79),(15,1,9,2019,1952530,0,0,'2020-02-06 06:47:23',79,'0000-00-00 00:00:00',79),(16,1,9,2018,0,0,0,'2020-02-06 06:47:43',79,'0000-00-00 00:00:00',79),(17,2,54,2019,0,82028,0,'2020-02-11 08:39:44',79,'0000-00-00 00:00:00',79),(18,2,61,2019,119720,0,0,'2020-02-11 08:40:01',79,'0000-00-00 00:00:00',79),(19,1,26,2019,0,0,0,'2020-02-12 01:32:39',79,'0000-00-00 00:00:00',79),(20,1,27,2019,19378,0,0,'2020-02-12 01:33:25',79,'0000-00-00 00:00:00',79),(21,1,28,2019,0,0,0,'2020-02-12 01:33:30',79,'0000-00-00 00:00:00',79),(22,1,29,2019,91713,0,0,'2020-02-12 01:40:54',79,'0000-00-00 00:00:00',79),(23,1,30,2019,100,0,0,'2020-02-12 01:43:17',79,'0000-00-00 00:00:00',79),(24,1,3,2019,0,0,0,'2020-02-12 06:23:40',18,'0000-00-00 00:00:00',18),(25,1,3,2018,0,0,0,'2020-02-12 06:23:52',79,'0000-00-00 00:00:00',79),(26,1,6,2019,34740,0,0,'2020-02-12 06:26:19',79,'0000-00-00 00:00:00',79),(27,1,6,2018,34740,0,0,'2020-02-12 06:26:22',79,'0000-00-00 00:00:00',79),(28,1,7,2019,783057,0,0,'2020-02-12 06:26:45',79,'0000-00-00 00:00:00',79),(29,1,7,2018,590223,0,0,'2020-02-12 06:26:54',79,'0000-00-00 00:00:00',79),(30,1,14,2019,65510,0,0,'2020-02-12 06:27:53',79,'0000-00-00 00:00:00',79),(31,1,14,2018,1867,0,0,'2020-02-12 06:28:08',79,'0000-00-00 00:00:00',79),(32,1,20,2019,0,103740,0,'2020-02-12 06:28:41',79,'0000-00-00 00:00:00',79),(33,1,20,2018,0,104074,0,'2020-02-12 06:28:53',79,'0000-00-00 00:00:00',79),(34,1,22,2019,0,938755,0,'2020-02-12 06:29:05',79,'0000-00-00 00:00:00',79),(35,1,22,2018,0,951287,0,'2020-02-12 06:29:15',79,'0000-00-00 00:00:00',79),(36,1,26,2018,0,15000,0,'2020-02-12 06:30:31',79,'0000-00-00 00:00:00',79),(37,1,27,2018,32272,0,0,'2020-02-12 06:30:49',79,'0000-00-00 00:00:00',79),(38,1,29,2018,93717,0,0,'2020-02-12 06:31:09',79,'0000-00-00 00:00:00',79),(39,1,23,2019,0,0,0,'2020-02-13 02:48:42',242,'0000-00-00 00:00:00',242),(40,2,32,2019,0,2500000,0,'2020-02-14 07:41:05',79,'0000-00-00 00:00:00',79),(41,2,33,2019,0,10539557,0,'2020-02-14 07:41:20',79,'0000-00-00 00:00:00',79),(42,2,35,2019,11400252,0,0,'2020-02-14 07:41:31',79,'0000-00-00 00:00:00',79),(43,2,38,2019,10145488,0,0,'2020-02-14 07:46:13',79,'0000-00-00 00:00:00',79),(44,2,39,2019,2067804,0,0,'2020-02-14 07:46:40',79,'0000-00-00 00:00:00',79),(45,2,40,2019,211240,0,0,'2020-02-14 07:46:53',79,'0000-00-00 00:00:00',79),(46,2,41,2019,162903,0,0,'2020-02-14 07:47:07',79,'0000-00-00 00:00:00',79),(47,2,42,2019,1355000,0,0,'2020-02-14 07:47:15',79,'0000-00-00 00:00:00',79),(48,2,43,2019,3289768,0,0,'2020-02-14 07:47:32',79,'0000-00-00 00:00:00',79),(49,2,44,2019,874839,0,0,'2020-02-14 07:47:45',79,'0000-00-00 00:00:00',79),(50,2,45,2019,28119,0,0,'2020-02-14 07:47:55',79,'0000-00-00 00:00:00',79),(51,2,37,2019,500100,0,0,'2020-02-14 07:48:09',79,'0000-00-00 00:00:00',79),(52,2,46,2019,0,5120711,0,'2020-02-14 07:48:27',79,'0000-00-00 00:00:00',79),(53,2,47,2019,0,3330994,0,'2020-02-14 07:48:36',79,'0000-00-00 00:00:00',79),(54,2,49,2019,0,6077754,0,'2020-02-14 07:48:55',79,'0000-00-00 00:00:00',79),(55,2,50,2019,0,555519,0,'2020-02-14 07:49:02',79,'0000-00-00 00:00:00',79),(56,2,51,2019,0,490682,0,'2020-02-14 07:49:15',79,'0000-00-00 00:00:00',79),(57,2,53,2019,0,1700538,0,'2020-02-14 07:49:26',79,'0000-00-00 00:00:00',79),(58,2,32,2018,0,2500000,0,'2020-02-14 07:49:52',79,'0000-00-00 00:00:00',79),(59,2,33,2018,0,9971056,0,'2020-02-14 07:50:03',79,'0000-00-00 00:00:00',79),(60,2,35,2018,11380427,0,0,'2020-02-14 07:50:19',79,'0000-00-00 00:00:00',79),(61,2,37,2018,500100,0,0,'2020-02-14 07:50:25',79,'0000-00-00 00:00:00',79),(62,2,38,2018,5662782,0,0,'2020-02-14 07:50:36',79,'0000-00-00 00:00:00',79),(63,2,39,2018,3538118,0,0,'2020-02-14 07:50:49',79,'0000-00-00 00:00:00',79),(64,2,40,2018,510077,0,0,'2020-02-14 07:51:00',79,'0000-00-00 00:00:00',79),(65,2,43,2018,1584524,0,0,'2020-02-14 07:51:17',79,'0000-00-00 00:00:00',79),(66,2,44,2018,850253,0,0,'2020-02-14 07:51:28',79,'0000-00-00 00:00:00',79),(67,2,45,2018,2772276,0,0,'2020-02-14 07:51:39',79,'0000-00-00 00:00:00',79),(68,2,46,2018,0,2937800,0,'2020-02-14 07:51:58',79,'0000-00-00 00:00:00',79),(69,2,47,2018,0,2860667,0,'2020-02-14 07:52:07',79,'0000-00-00 00:00:00',79),(70,2,48,2018,0,67599,0,'2020-02-14 07:52:32',79,'0000-00-00 00:00:00',79),(71,2,49,2018,0,5114055,0,'2020-02-14 07:52:43',79,'0000-00-00 00:00:00',79),(72,2,50,2018,0,483905,0,'2020-02-14 07:52:53',79,'0000-00-00 00:00:00',79),(73,2,51,2018,0,442311,0,'2020-02-14 07:53:00',79,'0000-00-00 00:00:00',79),(74,2,53,2018,0,1788810,0,'2020-02-14 07:53:11',79,'0000-00-00 00:00:00',79),(75,2,54,2018,0,63853,0,'2020-02-14 07:53:20',79,'0000-00-00 00:00:00',79),(76,2,55,2019,0,9919529,0,'2020-02-14 07:53:35',79,'0000-00-00 00:00:00',79),(77,2,55,2018,0,18953816,0,'2020-02-14 07:53:45',79,'0000-00-00 00:00:00',79),(78,2,56,2019,7386065,0,0,'2020-02-14 07:54:14',79,'0000-00-00 00:00:00',79),(79,2,56,2018,15920493,0,0,'2020-02-14 07:54:26',79,'0000-00-00 00:00:00',79),(80,2,57,2019,0,43472,0,'2020-02-14 07:54:34',79,'0000-00-00 00:00:00',79),(81,2,57,2018,0,180782,0,'2020-02-14 07:54:45',79,'0000-00-00 00:00:00',79),(82,2,58,2019,2317922,0,0,'2020-02-14 07:54:55',79,'0000-00-00 00:00:00',79),(83,2,58,2018,2091713,0,0,'2020-02-14 07:55:04',79,'0000-00-00 00:00:00',79),(84,2,60,2019,501564,0,0,'2020-02-14 07:55:13',79,'0000-00-00 00:00:00',79),(85,2,60,2018,223948,0,0,'2020-02-14 07:55:28',79,'0000-00-00 00:00:00',79),(86,2,61,2018,329943,0,0,'2020-02-14 07:55:37',79,'0000-00-00 00:00:00',79),(87,3,125,2019,0,4200000,0,'2020-02-17 03:23:43',79,'0000-00-00 00:00:00',79),(88,3,125,2018,0,4200000,0,'2020-02-17 03:36:10',79,'0000-00-00 00:00:00',79),(89,3,126,2019,262827,0,0,'2020-02-17 03:37:19',79,'0000-00-00 00:00:00',79),(90,3,126,2018,0,678190,0,'2020-02-17 03:37:32',79,'0000-00-00 00:00:00',79),(91,3,128,2019,1285081,0,0,'2020-02-17 03:37:53',79,'0000-00-00 00:00:00',79),(92,3,128,2018,1355586,0,0,'2020-02-17 03:53:08',79,'0000-00-00 00:00:00',79),(93,3,131,2019,29595124,0,0,'2020-02-17 03:53:21',79,'0000-00-00 00:00:00',79),(94,3,132,2019,3962958,0,0,'2020-02-17 03:53:37',79,'0000-00-00 00:00:00',79),(95,3,133,2019,1764091,0,0,'2020-02-17 03:53:48',79,'0000-00-00 00:00:00',79),(96,3,134,2019,721326,0,0,'2020-02-17 03:53:59',79,'0000-00-00 00:00:00',79),(97,3,131,2018,33164096,0,0,'2020-02-17 03:54:11',79,'0000-00-00 00:00:00',79),(98,3,132,2018,6589975,0,0,'2020-02-17 03:54:23',79,'0000-00-00 00:00:00',79),(99,3,133,2018,1302207,0,0,'2020-02-17 03:54:32',79,'0000-00-00 00:00:00',79),(100,3,134,2018,473326,0,0,'2020-02-17 03:54:40',79,'0000-00-00 00:00:00',79),(101,3,137,2019,375353,0,0,'2020-02-17 03:56:40',79,'0000-00-00 00:00:00',79),(102,3,138,2019,1594798,0,0,'2020-02-17 03:56:52',79,'0000-00-00 00:00:00',79),(103,3,137,2018,361908,0,0,'2020-02-17 03:57:01',79,'0000-00-00 00:00:00',79),(104,3,138,2018,1915132,0,0,'2020-02-17 03:57:10',79,'0000-00-00 00:00:00',79),(105,3,139,2019,0,29930995,0,'2020-02-17 03:57:23',79,'0000-00-00 00:00:00',79),(106,3,140,2019,0,2639960,0,'2020-02-17 03:57:34',79,'0000-00-00 00:00:00',79),(107,3,141,2019,0,1204274,0,'2020-02-17 03:57:42',79,'0000-00-00 00:00:00',79),(108,3,139,2018,0,31434050,0,'2020-02-17 03:57:52',79,'0000-00-00 00:00:00',79),(109,3,140,2018,0,4767283,0,'2020-02-17 03:58:01',79,'0000-00-00 00:00:00',79),(110,3,141,2018,0,4635385,0,'2020-02-17 03:58:15',79,'0000-00-00 00:00:00',79),(111,3,147,2019,0,17400,0,'2020-02-17 04:00:21',79,'0000-00-00 00:00:00',79),(112,3,146,2019,0,767902,0,'2020-02-17 04:00:29',79,'0000-00-00 00:00:00',79),(113,3,144,2019,0,98665,0,'2020-02-17 04:00:44',79,'0000-00-00 00:00:00',79),(114,3,143,2019,0,0,0,'2020-02-17 04:01:10',79,'0000-00-00 00:00:00',79),(115,3,142,2019,0,351645,0,'2020-02-17 04:01:30',79,'0000-00-00 00:00:00',79),(116,3,144,2018,0,108702,0,'2020-02-17 04:01:46',79,'0000-00-00 00:00:00',79),(117,3,146,2018,0,261937,0,'2020-02-17 04:01:55',79,'0000-00-00 00:00:00',79),(118,3,147,2018,0,17700,0,'2020-02-17 04:02:01',79,'0000-00-00 00:00:00',79),(119,3,148,2019,0,166993142,0,'2020-02-17 04:02:22',79,'0000-00-00 00:00:00',79),(120,3,148,2018,0,182447751,0,'2020-02-17 04:02:34',79,'0000-00-00 00:00:00',79),(121,3,149,2019,159883155,0,0,'2020-02-17 04:02:45',79,'0000-00-00 00:00:00',79),(122,3,149,2018,177689837,0,0,'2020-02-17 04:02:57',79,'0000-00-00 00:00:00',79),(123,3,150,2019,0,298892,0,'2020-02-17 04:03:08',79,'0000-00-00 00:00:00',79),(124,3,150,2018,0,386865,0,'2020-02-17 04:03:18',79,'0000-00-00 00:00:00',79),(125,3,151,2019,6585516,0,0,'2020-02-17 04:03:32',79,'0000-00-00 00:00:00',79),(126,3,152,2019,57002,0,0,'2020-02-17 04:03:41',79,'0000-00-00 00:00:00',79),(127,3,153,2019,27976,0,0,'2020-02-17 04:03:48',79,'0000-00-00 00:00:00',79),(128,3,154,2019,387668,0,0,'2020-02-17 04:03:57',79,'0000-00-00 00:00:00',79),(129,3,151,2018,5732746,0,0,'2020-02-17 04:04:08',79,'0000-00-00 00:00:00',79),(130,3,152,2018,97739,0,0,'2020-02-17 04:04:18',79,'0000-00-00 00:00:00',79),(131,3,153,2018,5719,0,0,'2020-02-17 04:04:25',79,'0000-00-00 00:00:00',79),(132,3,154,2018,249592,0,0,'2020-02-17 04:04:35',79,'0000-00-00 00:00:00',79);

--
-- Table structure for table `project_requirement`
--

CREATE TABLE `project_requirement` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `working_id` int(11) NOT NULL,
  `paragraph` text NOT NULL,
  `description` text NOT NULL,
  `status` text NOT NULL,
  `remarks` text NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_requirement`
--


--
-- Temporary table structure for view `user`
--

/*!50001 DROP VIEW IF EXISTS `user`*/;
/*!50001 CREATE TABLE `user` (
  `id` tinyint NOT NULL,
  `staff_id` tinyint NOT NULL,
  `ic_no` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `title_id` tinyint NOT NULL,
  `gender_id` tinyint NOT NULL,
  `email` tinyint NOT NULL,
  `email_secondary` tinyint NOT NULL,
  `profile` tinyint NOT NULL,
  `marital_status` tinyint NOT NULL,
  `married_date` tinyint NOT NULL,
  `profile_picture_id` tinyint NOT NULL,
  `phone` tinyint NOT NULL,
  `address` tinyint NOT NULL,
  `postcode` tinyint NOT NULL,
  `city` tinyint NOT NULL,
  `state_id` tinyint NOT NULL,
  `country_id` tinyint NOT NULL,
  `citizen_id` tinyint NOT NULL,
  `race_id` tinyint NOT NULL,
  `religion_id` tinyint NOT NULL,
  `birth_date` tinyint NOT NULL,
  `birth_place` tinyint NOT NULL,
  `residential_id` tinyint NOT NULL,
  `status` tinyint NOT NULL,
  `hobby` tinyint NOT NULL,
  `created_by` tinyint NOT NULL,
  `created_ts` tinyint NOT NULL,
  `updated_by` tinyint NOT NULL,
  `updated_ts` tinyint NOT NULL,
  `is_delete` tinyint NOT NULL,
  `deleted_by` tinyint NOT NULL,
  `deleted_ts` tinyint NOT NULL,
  `religion` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `user__employement_detail`
--

/*!50001 DROP VIEW IF EXISTS `user__employement_detail`*/;
/*!50001 CREATE TABLE `user__employement_detail` (
  `id` tinyint NOT NULL,
  `user_id` tinyint NOT NULL,
  `staff_id` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `profiling_id` tinyint NOT NULL,
  `company_id` tinyint NOT NULL,
  `reporting_to` tinyint NOT NULL,
  `business_entity_id` tinyint NOT NULL,
  `department_id` tinyint NOT NULL,
  `division_id` tinyint NOT NULL,
  `position_id` tinyint NOT NULL,
  `employee_grade` tinyint NOT NULL,
  `title` tinyint NOT NULL,
  `contract_id` tinyint NOT NULL,
  `date_joined` tinyint NOT NULL,
  `basic_pay` tinyint NOT NULL,
  `basic_pay_start_date` tinyint NOT NULL,
  `date_commencement` tinyint NOT NULL,
  `date_termination` tinyint NOT NULL,
  `status` tinyint NOT NULL,
  `created_ts` tinyint NOT NULL,
  `is_delete` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `user__role`
--

CREATE TABLE `user__role` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `user_ID` int(11) NOT NULL,
  `role` varchar(12) NOT NULL COMMENT 'ADMIN, USER, SUPERVISOR',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `userID` (`user_ID`),
  KEY `is_delete` (`is_delete`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user__role`
--

INSERT INTO `user__role` VALUES (1,54,'ADMIN',0),(2,164,'SUPERVISOR',0),(3,79,'ADMIN',0),(5,1,'SUPERVISOR',1),(6,309,'SUPERVISOR',0),(7,304,'SUPERVISOR',0),(9,265,'ADMIN',0),(10,18,'SUPERVISOR',0),(11,19,'ADMIN',0),(34,12,'SUPERVISOR',0),(37,242,'USER',0),(38,24,'USER',1),(39,132,'USER',0),(40,129,'SUPERVISOR',0),(41,403,'USER',0);

--
-- Table structure for table `working_attachment`
--

CREATE TABLE `working_attachment` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `working_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_location` varchar(255) NOT NULL,
  `file_type` text NOT NULL,
  `description` text NOT NULL,
  `unique_id` varchar(128) NOT NULL,
  `is_delete` tinyint(1) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_ts` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `working_attachment`
--

INSERT INTO `working_attachment` VALUES (1,1,'Testing_jpg.png','','','Testing picss','',1,242,'2020-02-07 03:20:56',242,'0000-00-00 00:00:00'),(2,1,'','','','testing 3','',1,242,'2020-02-07 00:34:03',271,'0000-00-00 00:00:00'),(3,1,'','','','testing 5','',1,242,'2020-02-07 01:36:14',271,'0000-00-00 00:00:00'),(4,1,'','','','dsasa','',1,242,'2020-02-07 01:36:17',271,'0000-00-00 00:00:00'),(5,1,'','','','123456789','',1,19,'2020-02-07 01:36:20',271,'0000-00-00 00:00:00'),(6,32,'testing_PP.pdf','working_attachment/32','','we','',1,242,'2020-02-07 02:45:09',0,'0000-00-00 00:00:00'),(7,32,'testing.pdf','working_attachment/32','application/pdf','we','',1,242,'2020-02-07 04:42:56',0,'0000-00-00 00:00:00'),(8,7,'testing.pdf','working_attachment/7','application/pdf','huhuhu','',1,242,'2020-02-07 04:43:02',271,'0000-00-00 00:00:00'),(9,34,'testing.pdf','working_attachment/34','','qw','',1,242,'2020-02-07 02:45:17',0,'0000-00-00 00:00:00'),(10,7,'test_file.pdf','working_attachment/7','','lol','',1,271,'2020-02-07 04:44:12',0,'0000-00-00 00:00:00'),(11,1,'testing_PP.pptx','working_attachment/1','','Testing 1','',1,242,'2020-02-07 02:45:43',0,'0000-00-00 00:00:00'),(12,1,'testing.pdf','working_attachment/1','','Testing 2','',1,242,'2020-02-07 02:45:53',0,'0000-00-00 00:00:00'),(13,1,'Testing_jpg.png','working_attachment/1','image/png','Testing pic','',1,242,'2020-02-07 04:44:16',0,'0000-00-00 00:00:00'),(14,1,'Testing_jpg1.png','working_attachment/1','image/png','Testing add ffile types','',1,242,'2020-02-07 04:44:18',0,'0000-00-00 00:00:00'),(15,35,'Testing_jpg1.png','working_attachment/35','image/jpeg','11','5e3cd8d9b717b',0,242,'2020-02-07 03:33:37',242,'0000-00-00 00:00:00'),(16,35,'Testing_jpg2.png','working_attachment/35','image/png','a','5e3ce00177ebd',0,242,'2020-02-07 03:56:49',0,'0000-00-00 00:00:00'),(17,1,'Testing_jpg2.png','working_attachment/1','image/png','as','5e3ce0c4282e4',1,242,'2020-02-10 08:21:48',242,'0000-00-00 00:00:00'),(18,1,'testing1.pdf','working_attachment/1','application/pdf','qw','5e3cea0db748c',1,242,'2020-02-10 08:20:42',242,'0000-00-00 00:00:00'),(19,1,'test_file_(2)1.xlsx','working_attachment/1','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','1234','5e3cec5750b8d',0,242,'2020-02-14 07:14:06',24,'0000-00-00 00:00:00'),(20,7,'testing_PP.pptx','working_attachment/7','application/vnd.openxmlformats-officedocument.presentationml.presentation','ppdasdasd','5e3d0aabbac6f',0,242,'2020-02-13 07:48:48',19,'0000-00-00 00:00:00'),(21,7,'testing2.pdf','working_attachment/7','application/pdf','pdf','5e3d0aba819f9',0,242,'2020-02-07 06:59:06',0,'0000-00-00 00:00:00'),(22,7,'Testing_jpg.png','working_attachment/7','image/png','png','5e3d0ac920f72',0,242,'2020-02-07 06:59:21',0,'0000-00-00 00:00:00'),(23,1,'Testing_jpg3.png','working_attachment/1','image/png','as','5e3d1b5300e74',0,242,'2020-02-10 08:20:12',242,'0000-00-00 00:00:00'),(24,6,'Testing_jpg.png','working_attachment/6','image/png','qw','5e3d1f9f39986',1,242,'2020-02-12 07:13:48',304,'0000-00-00 00:00:00'),(25,38,'Untitled.png','working_attachment/38','image/png','testing upload','5e40c3791291a',0,265,'2020-02-10 02:44:09',0,'0000-00-00 00:00:00'),(26,2,'Testing_jpg.png','working_attachment/2','image/png','Testing 2','5e410ac19eb52',1,242,'2020-02-10 08:09:24',242,'0000-00-00 00:00:00'),(27,46,'test_file.pdf','working_attachment/46','application/pdf','testing testung','5e4211f71baf2',0,304,'2020-02-11 02:31:19',0,'0000-00-00 00:00:00'),(28,18,'Testing_jpg.png','working_attachment/18','image/png','q','5e4230d972a27',1,242,'2020-02-11 04:43:12',242,'0000-00-00 00:00:00'),(29,40,'Testing_jpg.png','working_attachment/40','image/png','Testing\r\n','5e43a2ce8435b',0,242,'2020-02-12 07:01:34',0,'0000-00-00 00:00:00'),(30,113,'Testing_jpg2.png','working_attachment/113','image/png','Testing 2','5e43a307aedf5',0,242,'2020-02-12 07:06:25',242,'0000-00-00 00:00:00'),(31,113,'Testing_jpg1.png','working_attachment/113','image/png','Testing','5e43a3c00e127',0,242,'2020-02-12 07:05:36',0,'0000-00-00 00:00:00'),(32,6,'test_file.pdf','working_attachment/6','application/pdf','test to check if upload at \"requiremenDetails/1/5/0\", does it appear at \"requiremenDetails/1/6/0\".','5e43a60901f16',1,304,'2020-02-18 01:51:18',0,'0000-00-00 00:00:00'),(33,125,'Testing_jpg.png','working_attachment/125','image/png','.','5e43bee67f96d',0,265,'2020-02-12 09:01:26',0,'0000-00-00 00:00:00'),(34,32,'Testing_jpg.png','working_attachment/32','image/png','Testing eyes','5e44a197b8f7b',1,265,'2020-02-14 02:16:51',242,'0000-00-00 00:00:00'),(35,12,'test_file_(2).xlsx','working_attachment/12','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','try add attachment','5e44a55480d4e',1,24,'2020-02-13 01:25:59',24,'0000-00-00 00:00:00'),(36,12,'fax-vector-6.png','working_attachment/12','image/png','try 2','5e44a58ae8c2a',0,24,'2020-03-16 01:37:50',265,'0000-00-00 00:00:00'),(37,137,'test_file.xlsx','working_attachment/137','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','Audit file','5e44a84b88e1c',0,265,'2020-02-13 01:37:15',0,'0000-00-00 00:00:00'),(38,1,'test_file_(2).xlsx','working_attachment/1','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','try','5e44aa7ea8158',1,24,'2020-02-13 01:50:08',24,'0000-00-00 00:00:00'),(39,118,'test_file.xlsx','working_attachment/118','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','Audit file attachment 4','5e44ab4619ebc',0,265,'2020-02-13 01:49:58',0,'0000-00-00 00:00:00'),(40,138,'test_file.xlsx','working_attachment/138','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','Attachment file for audit working term 3','5e44abf5ce557',0,265,'2020-02-13 01:54:07',265,'0000-00-00 00:00:00'),(41,119,'test_file_(2).xlsx','working_attachment/119','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','1','5e44b6201dad6',0,242,'2020-02-17 03:21:55',242,'0000-00-00 00:00:00'),(42,175,'Testing_jpg.png','working_attachment/175','image/png','Testing','5e45fe2554bd3',1,242,'2020-02-14 02:08:01',242,'0000-00-00 00:00:00'),(43,60,'Testing_jpg.png','working_attachment/60','image/png','Testing','5e4658bee8dbe',1,242,'2020-02-14 08:23:01',242,'0000-00-00 00:00:00'),(44,60,'Testing_jpg1.png','working_attachment/60','image/png','testing','5e46590b2887d',1,242,'2020-02-14 08:23:49',242,'0000-00-00 00:00:00'),(45,37,'testing_PP_(2).pptx','working_attachment/37','application/vnd.openxmlformats-officedocument.presentationml.presentation','testing ','5e49e651c6a06',1,242,'2020-02-17 01:06:21',242,'0000-00-00 00:00:00'),(46,37,'testing.pdf','working_attachment/37','application/pdf','T','5e49e664d75e7',0,242,'2020-02-17 01:03:32',0,'0000-00-00 00:00:00'),(47,37,'testing_PP.pptx','working_attachment/37','application/vnd.openxmlformats-officedocument.presentationml.presentation','T','5e49e67701947',0,242,'2020-02-17 01:03:51',0,'0000-00-00 00:00:00'),(48,37,'test_file_(2).xlsx','working_attachment/37','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','T','5e49e69a68532',1,242,'2020-02-17 01:06:31',242,'0000-00-00 00:00:00'),(49,9,'test_file_(2)3.xlsx','working_attachment/9','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','tryyyyy','5e49e808f0032',0,24,'2020-02-17 01:10:32',0,'0000-00-00 00:00:00'),(50,9,'test_file_(2)4.xlsx','working_attachment/9','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','trtrtr','5e49ea2812646',0,309,'2020-02-17 01:19:36',0,'0000-00-00 00:00:00'),(51,6,'test_file1.pdf','working_attachment/6','application/pdf','test file 1','5e4b43525d599',0,304,'2020-02-18 01:52:18',0,'0000-00-00 00:00:00'),(52,6,'test_file2.pdf','working_attachment/6','application/pdf','test file 2','5e4b436f157f9',0,304,'2020-02-18 01:52:47',0,'0000-00-00 00:00:00'),(53,135,'test_file.pdf','working_attachment/135','application/pdf','again','5e4b4c0c19a37',0,304,'2020-02-18 02:29:32',0,'0000-00-00 00:00:00'),(54,135,'test_file.xlsx','working_attachment/135','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','againnnnn','5e4b4c2f58748',0,304,'2020-02-18 02:30:07',0,'0000-00-00 00:00:00');

--
-- Final view structure for view `company__branch`
--

/*!50001 DROP TABLE IF EXISTS `company__branch`*/;
/*!50001 DROP VIEW IF EXISTS `company__branch`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `company__branch` AS select `spserp_master`.`company__branch`.`id` AS `id`,`spserp_master`.`company__branch`.`company_id` AS `company_id`,`spserp_master`.`company__branch`.`name` AS `name`,`spserp_master`.`company__branch`.`address` AS `address`,`spserp_master`.`company__branch`.`postcode` AS `postcode`,`spserp_master`.`company__branch`.`city` AS `city`,`spserp_master`.`company__branch`.`state_id` AS `state_id`,`spserp_master`.`company__branch`.`country_id` AS `country_id`,`spserp_master`.`company__branch`.`latitude` AS `latitude`,`spserp_master`.`company__branch`.`longitude` AS `longitude`,`spserp_master`.`company__branch`.`phone` AS `phone`,`spserp_master`.`company__branch`.`fax` AS `fax`,`spserp_master`.`company__branch`.`email` AS `email`,`spserp_master`.`company__branch`.`status` AS `status`,`spserp_master`.`company__branch`.`created_by` AS `created_by`,`spserp_master`.`company__branch`.`created_ts` AS `created_ts`,`spserp_master`.`company__branch`.`updated_by` AS `updated_by`,`spserp_master`.`company__branch`.`updated_ts` AS `updated_ts`,`spserp_master`.`company__branch`.`is_delete` AS `is_delete`,`spserp_master`.`company__branch`.`deleted_by` AS `deleted_by`,`spserp_master`.`company__branch`.`deleted_ts` AS `deleted_ts` from `spserp_master`.`company__branch` */;

--
-- Final view structure for view `company__department`
--

/*!50001 DROP TABLE IF EXISTS `company__department`*/;
/*!50001 DROP VIEW IF EXISTS `company__department`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `company__department` AS select `spserp_master`.`company__department`.`id` AS `id`,`spserp_master`.`company__department`.`branch_id` AS `branch_id`,`spserp_master`.`company__department`.`division_id` AS `division_id`,`spserp_master`.`company__department`.`name` AS `name`,`spserp_master`.`company__department`.`description` AS `description`,`spserp_master`.`company__department`.`hod_id` AS `hod_id`,`spserp_master`.`company__department`.`status` AS `status`,`spserp_master`.`company__department`.`created_by` AS `created_by`,`spserp_master`.`company__department`.`created_ts` AS `created_ts`,`spserp_master`.`company__department`.`updated_by` AS `updated_by`,`spserp_master`.`company__department`.`updated_ts` AS `updated_ts`,`spserp_master`.`company__department`.`is_delete` AS `is_delete`,`spserp_master`.`company__department`.`deleted_by` AS `deleted_by`,`spserp_master`.`company__department`.`deleted_ts` AS `deleted_ts` from `spserp_master`.`company__department` */;

--
-- Final view structure for view `user`
--

/*!50001 DROP TABLE IF EXISTS `user`*/;
/*!50001 DROP VIEW IF EXISTS `user`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user` AS select `spserp_master`.`user`.`id` AS `id`,`spserp_master`.`user`.`staff_id` AS `staff_id`,`spserp_master`.`user`.`ic_no` AS `ic_no`,`spserp_master`.`user`.`name` AS `name`,`spserp_master`.`user`.`title_id` AS `title_id`,`spserp_master`.`user`.`gender_id` AS `gender_id`,`spserp_master`.`user`.`email` AS `email`,`spserp_master`.`user`.`email_secondary` AS `email_secondary`,`spserp_master`.`user`.`profile` AS `profile`,`spserp_master`.`user`.`marital_status` AS `marital_status`,`spserp_master`.`user`.`married_date` AS `married_date`,`spserp_master`.`user`.`profile_picture_id` AS `profile_picture_id`,`spserp_master`.`user`.`phone` AS `phone`,`spserp_master`.`user`.`address` AS `address`,`spserp_master`.`user`.`postcode` AS `postcode`,`spserp_master`.`user`.`city` AS `city`,`spserp_master`.`user`.`state_id` AS `state_id`,`spserp_master`.`user`.`country_id` AS `country_id`,`spserp_master`.`user`.`citizen_id` AS `citizen_id`,`spserp_master`.`user`.`race_id` AS `race_id`,`spserp_master`.`user`.`religion_id` AS `religion_id`,`spserp_master`.`user`.`birth_date` AS `birth_date`,`spserp_master`.`user`.`birth_place` AS `birth_place`,`spserp_master`.`user`.`residential_id` AS `residential_id`,`spserp_master`.`user`.`status` AS `status`,`spserp_master`.`user`.`hobby` AS `hobby`,`spserp_master`.`user`.`created_by` AS `created_by`,`spserp_master`.`user`.`created_ts` AS `created_ts`,`spserp_master`.`user`.`updated_by` AS `updated_by`,`spserp_master`.`user`.`updated_ts` AS `updated_ts`,`spserp_master`.`user`.`is_delete` AS `is_delete`,`spserp_master`.`user`.`deleted_by` AS `deleted_by`,`spserp_master`.`user`.`deleted_ts` AS `deleted_ts`,`spserp_master`.`user`.`religion` AS `religion` from `spserp_master`.`user` */;

--
-- Final view structure for view `user__employement_detail`
--

/*!50001 DROP TABLE IF EXISTS `user__employement_detail`*/;
/*!50001 DROP VIEW IF EXISTS `user__employement_detail`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user__employement_detail` AS select `user__employment_detail`.`id` AS `id`,`user__employment_detail`.`user_id` AS `user_id`,`user__employment_detail`.`staff_id` AS `staff_id`,`user__employment_detail`.`name` AS `name`,`user__employment_detail`.`profiling_id` AS `profiling_id`,`user__employment_detail`.`company_id` AS `company_id`,`user__employment_detail`.`reporting_to` AS `reporting_to`,`user__employment_detail`.`business_entity_id` AS `business_entity_id`,`user__employment_detail`.`department_id` AS `department_id`,`user__employment_detail`.`division_id` AS `division_id`,`user__employment_detail`.`position_id` AS `position_id`,`user__employment_detail`.`employee_grade` AS `employee_grade`,`user__employment_detail`.`title` AS `title`,`user__employment_detail`.`contract_id` AS `contract_id`,`user__employment_detail`.`date_joined` AS `date_joined`,`user__employment_detail`.`basic_pay` AS `basic_pay`,`user__employment_detail`.`basic_pay_start_date` AS `basic_pay_start_date`,`user__employment_detail`.`date_commencement` AS `date_commencement`,`user__employment_detail`.`date_termination` AS `date_termination`,`user__employment_detail`.`status` AS `status`,`user__employment_detail`.`created_ts` AS `created_ts`,`user__employment_detail`.`is_delete` AS `is_delete` from `spserp_master`.`user__employment_detail` */;


