text: CREATE TABLE `accounts`(`id` int NOT NULL AUTO_INCREMENT, `AccountNumber` varchar(50) NOT NULL, `AccountBalance` decimal(10,2) NOT NULL DEFAULT 0.00, `AccountHolder` int NOT NULL, `LastTransactionDate` datetime NULL, `OpeningBalance` decimal(10,2) NOT NULL DEFAULT 0.00, `InterestRate` decimal(10,2) NULL DEFAULT 0.00, `SetWithdrawDate` date NULL, `AccountType` varchar(30) NULL, `AccountHolderKey` varchar(75) NULL, `ClientNo` varchar(50) NULL, `AccountName` varchar(75) NULL, `LastModifiedBy` varchar(50) NULL, `LastModifiedDate` datetime NULL, `LoanCreditPaymentPurpose` varchar(50) NULL, `LoanCreditWitness` varchar(50) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
  CREATE TABLE `finance_searches`(`ID` int NOT NULL AUTO_INCREMENT, `NAME` mediumtext NULL, `USERNAME` mediumtext NULL, `COOKIE` varchar(500) NULL, `SEARCH` mediumtext NULL, `TABLENAME` varchar(300) NULL, PRIMARY KEY (`ID`))CHARACTER SET utf8;
  CREATE TABLE `finance_uggroups`(`GroupID` int NOT NULL AUTO_INCREMENT, `Label` varchar(300) NULL, PRIMARY KEY (`GroupID`))CHARACTER SET utf8;
  CREATE TABLE `finance_ugmembers`(`UserName` varchar(300) NOT NULL, `GroupID` int NOT NULL, PRIMARY KEY (`UserName`(50),`GroupID`))CHARACTER SET utf8;
  CREATE TABLE `finance_ugrights`(`TableName` varchar(300) NOT NULL, `GroupID` int NOT NULL, `AccessMask` varchar(10) NULL, PRIMARY KEY (`TableName`(50),`GroupID`))CHARACTER SET utf8;
  CREATE TABLE `loan`(`id` int NOT NULL AUTO_INCREMENT, `LoanID` varchar(50) NULL, `AccountName` varchar(50) NULL, `ClientNo` varchar(50) NULL, `AccountNumber` varchar(50) NULL, `TelephoneNo` varchar(50) NULL, `DateLoanApproved` date NULL, `LoanAmount` decimal(10,2) NULL, `LoanInterest` decimal(10,2) NULL, `LoanPeriod` int NULL, `FirstPaymentDate` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
  CREATE TABLE `lookups`(`id` int NOT NULL AUTO_INCREMENT, `Type` varchar(50) NOT NULL, `Value` varchar(50) NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
  CREATE TABLE `recordidcounter`(`Name` varchar(50) NOT NULL, `Prefix` varchar(50) NULL, `Sufix` varchar(50) NULL, `Number` int NULL, `flag` int NOT NULL DEFAULT 0, `useflag` int NOT NULL DEFAULT 0, PRIMARY KEY (`Name`(50)))CHARACTER SET utf8;
  CREATE TABLE `schedule`(`id` int NOT NULL AUTO_INCREMENT, `AccountNumber` varchar(50) NULL, `PaymentNo` varchar(11) NULL, `PaymentDate` date NULL, `PaymentAmount` decimal(10,2) NULL, `LoanInterest` decimal(10,2) NULL, `Depreciation` decimal(10,2) NULL, `AmountPay` decimal(10,2) NULL, `Remark` varchar(50) NULL, `LoanID` varchar(11) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
  CREATE TABLE `transactions`(`id` int NOT NULL AUTO_INCREMENT, `DebitAccount` int NOT NULL, `CreditAccount` int NOT NULL, `DebitAccountTransactionCharge` decimal(10,2) NOT NULL DEFAULT 0.00, `CreditAccountTransactionCharge` decimal(10,2) NOT NULL DEFAULT 0.00, `Amount` decimal(10,2) NOT NULL, `DateTime` datetime NOT NULL DEFAULT 0, `Description` varchar(100) NULL, `CashDepositNo` varchar(50) NULL, `CashDepositorName` varchar(50) NULL, `CashDepositType` varchar(20) NULL, `WithdrawlNo` varchar(50) NULL, `WithdrawlName` varchar(50) NULL, `WithdrawlType` varchar(20) NULL, `LoanPaymentNo` varchar(50) NULL, `LoanPaymentName` varchar(50) NULL, `LoanPaymentPurpose` varchar(20) NULL, `LoanCreditPaymentNo` varchar(50) NULL, `LoanCreditPaymentName` varchar(50) NULL, `LoanCreditPaymentPurpose` varchar(20) NULL, `AccountType` varchar(20) NULL, `InterestAmount` decimal(10,2) NULL, `PrincipalAmount` varchar(10) NULL, `WithdrawlStatus` varchar(20) NULL, `NEFTTransferStatus` varchar(20) NULL, `LoanCreditApplicationStatus` varchar(20) NULL, `LoanCreditWitness` varchar(50) NULL, `NEFTTransferNo` varchar(50) NULL, `NEFTTransferDepositorName` varchar(50) NULL, `TransactionType` varchar(50) NULL, `Balance` decimal(10,2) NULL, `AccountNumber` varchar(50) NULL, `ClientNo` varchar(50) NULL, `LastModifiedBy` varchar(50) NULL, `LastModifiedDate` datetime NULL, `AccountName` varchar(75) NULL, `TransactionNo` varchar(50) NULL, `TransactionStatus` varchar(50) NULL, `SelectedClientNo` varchar(50) NULL, `LoanPaymentStatus` varchar(50) NULL, `CashDepositStatus` varchar(50) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
  CREATE TABLE `users`(`id` int NOT NULL AUTO_INCREMENT, `FirstName` varchar(50) NOT NULL, `LastName` varchar(50) NOT NULL, `Sex` tinyint NULL DEFAULT 0, `DateOfBirth` date NULL, `TelephoneNo` varchar(20) NULL, `EmailAddress` varchar(75) NULL, `CurrentAddress` mediumtext NULL, `PlaceOfBirth` varchar(50) NULL, `PassportOrID` varchar(20) NULL DEFAULT '0', `ProfilePhoto` mediumtext NULL, `AttachedFile` mediumtext NULL, `ClientNo` varchar(50) NULL, `EmergencyContactPerson` varchar(50) NULL, `EmergencyContactRelation` int NULL, `EmergencyContactTel` varchar(20) NULL, `Username` varchar(50) NULL, `Password` varchar(50) NULL, `LastModifiedBy` varchar(50) NULL, `LastModifiedDate` datetime NULL, `AccountName` varchar(75) NULL, `AccountNumber` varchar(50) NULL, `OpeningAccountDate` datetime NULL, `OpeningAccountBalance` decimal(10,2) NULL, `UserLevel` varchar(50) NULL, `InterestRate` varchar(50) NULL, `SetWithdrawDate` date NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `accounts` (`id`,`AccountNumber`,`AccountBalance`,`AccountHolder`,`LastTransactionDate`,`OpeningBalance`,`InterestRate`,`SetWithdrawDate`,`AccountType`,`AccountHolderKey`,`ClientNo`,`AccountName`,`LastModifiedBy`,`LastModifiedDate`,`LoanCreditPaymentPurpose`,`LoanCreditWitness`) VALUES (50,'10000003',0.00,0,'0000-00-00 00:00:00',1.00,1.00,'2016-12-04','Savings',NULL,'CD000003','ClientF ClientL','AdminF','2016-12-12 14:13:30',NULL,NULL);
  INSERT INTO `accounts` (`id`,`AccountNumber`,`AccountBalance`,`AccountHolder`,`LastTransactionDate`,`OpeningBalance`,`InterestRate`,`SetWithdrawDate`,`AccountType`,`AccountHolderKey`,`ClientNo`,`AccountName`,`LastModifiedBy`,`LastModifiedDate`,`LoanCreditPaymentPurpose`,`LoanCreditWitness`) VALUES (51,'10000007',0.00,0,'0000-00-00 00:00:00',1.00,1.00,'2016-12-01','Savings',NULL,'CD000007','Client2 Client2','AdminF','2016-12-12 14:20:04',NULL,NULL);
  INSERT INTO `accounts` (`id`,`AccountNumber`,`AccountBalance`,`AccountHolder`,`LastTransactionDate`,`OpeningBalance`,`InterestRate`,`SetWithdrawDate`,`AccountType`,`AccountHolderKey`,`ClientNo`,`AccountName`,`LastModifiedBy`,`LastModifiedDate`,`LoanCreditPaymentPurpose`,`LoanCreditWitness`) VALUES (52,'L000001',100.00,0,'2016-12-12 14:21:32',100.00,3.00,'2016-12-04','Loan',NULL,'CD000003','ClientF ClientL','AdminF','2016-12-12 14:21:32','Loan Amount','Witness1');
  INSERT INTO `accounts` (`id`,`AccountNumber`,`AccountBalance`,`AccountHolder`,`LastTransactionDate`,`OpeningBalance`,`InterestRate`,`SetWithdrawDate`,`AccountType`,`AccountHolderKey`,`ClientNo`,`AccountName`,`LastModifiedBy`,`LastModifiedDate`,`LoanCreditPaymentPurpose`,`LoanCreditWitness`) VALUES (53,'L000002',397.00,0,'2016-12-12 14:22:37',200.00,3.00,'2016-12-08','Loan',NULL,'CD000007','Client2 Client2','AdminF','2016-12-12 14:22:37','Pawn Amount','witness2');
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (1,'User Level = Client','admin',NULL,'a:2:{s:1:"q";s:25:"(UserLevel~equals~Client)";s:8:"criteria";N;}','ClientAccounts');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (2,'User Level = Admin','admin',NULL,'a:2:{s:1:"q";s:24:"(UserLevel~equals~Admin)";s:8:"criteria";N;}','ClientAccounts');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (3,'User Level = Finance','admin',NULL,'a:2:{s:1:"q";s:26:"(UserLevel~equals~Finance)";s:8:"criteria";N;}','ClientAccounts');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (5,'Loan Credit Payment Purpose = Pawn Amount','admin',NULL,'a:2:{s:1:"q";s:45:"(LoanCreditPaymentPurpose~equals~Pawn Amount)";s:8:"criteria";N;}','loanaccounts');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (6,'Loan Credit Payment Purpose = Loan Amount','admin',NULL,'a:2:{s:1:"q";s:45:"(LoanCreditPaymentPurpose~equals~Loan Amount)";s:8:"criteria";N;}','loanaccounts');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (7,'Cash Deposit Type = Cash','admin',NULL,'a:2:{s:1:"q";s:29:"(CashDepositType~equals~Cash)";s:8:"criteria";N;}','CashDeposit');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (8,'Cash Deposit Type = Cheque','admin',NULL,'a:2:{s:1:"q";s:31:"(CashDepositType~equals~Cheque)";s:8:"criteria";N;}','CashDeposit');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (9,'Date Between','admin',NULL,'a:2:{s:1:"q";s:40:"(DateTime~between~2015-12-1~~2016-12-12)";s:8:"criteria";N;}','TransactionLog');
  INSERT INTO `finance_searches` (`ID`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES (10,'Date Between','sorphorn',NULL,'a:2:{s:1:"q";s:43:"(DateTime~between~2016-12-11 ~~2016-12-11 )";s:8:"criteria";N;}','TransactionLog');
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `finance_uggroups` (`GroupID`,`Label`) VALUES (1,'Clients');
  INSERT INTO `finance_uggroups` (`GroupID`,`Label`) VALUES (2,'Admin');
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `finance_ugmembers` (`UserName`,`GroupID`) VALUES ('admin',-1);
  INSERT INTO `finance_ugmembers` (`UserName`,`GroupID`) VALUES ('ApplicationAdmin',1);
  INSERT INTO `finance_ugmembers` (`UserName`,`GroupID`) VALUES ('client',1);
  INSERT INTO `finance_ugmembers` (`UserName`,`GroupID`) VALUES ('Client1',1);
  INSERT INTO `finance_ugmembers` (`UserName`,`GroupID`) VALUES ('Client2',1);
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accounts',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accounts',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accounts',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accountsLookUp',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accountsLookUp',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accountsLookUp',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accountsLookUpFiltered',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accountsLookUpFiltered',1,'AEDSPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('accountsLookUpFiltered',2,'AEDSPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('admin_members',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('admin_users',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('BalaceEnquiry',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('BalaceEnquiry',2,'SPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('CashDeposit',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('CashDeposit',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('CashWithdrawl',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('CashWithdrawl',2,'ADSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientAccounts',-1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientAccounts',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientCashWithdrawl',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientCashWithdrawl',1,'AESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientLoanAccounts',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientLoanAccounts',1,'SPM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientLoanCredit',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientLoanCredit',1,'AESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientSavingsAccounts',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('ClientSavingsAccounts',1,'SPM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('loan',-1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('loan',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('loan',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('loanaccounts',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('loanaccounts',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanCredit',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanCredit',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanInfo',-1,'S');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanInfo',1,'S');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanPayment',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanPayment',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanStatements',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LoanStatements',2,'DSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('LookUps',-1,'AM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('lookups',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('lookups',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('MonthlyBalanceSheet',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('MonthlyBalanceSheet',2,'SP');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('MonthlyStatement',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('MonthlyStatement',1,'SPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('NEFTTransfer',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('NEFTTransfer',1,'AEDSPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('recordidcounter',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('recordidcounter',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('recordidcounter',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('SavingsAccounts',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('SavingsAccounts',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('SavingsStatements',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('SavingsStatements',2,'DSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('schedule',-1,'ADESPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('schedule',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('schedule',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('TransactionLog',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('TransactionLog',1,'SPM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('TransactionLog',2,'SPM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('transactions',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('transactions',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('transactions',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('users',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('users',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('users',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('usersLookUp',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('usersLookUp',1,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('usersLookUp',2,'AEDSPI');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('usersLookupFiltered',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('usersLookupFiltered',1,'AEDSPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('usersLookupFiltered',2,'AEDSPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('YearlyBalanceSheet',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('YearlyBalanceSheet',2,'SP');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('YearlyStatement',-1,'ADESPIM');
  INSERT INTO `finance_ugrights` (`TableName`,`GroupID`,`AccessMask`) VALUES ('YearlyStatement',1,'SPM');
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (1,'UserType','User');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (2,'UserType','Admin');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (3,'UserType','Finance');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (4,'AccountType','Loan');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (5,'AccountType','Savings');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (6,'Sex','Male');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (7,'Sex','Female');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (8,'EmergencyContactRelation','Wife');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (9,'EmergencyContactRelation','Husband');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (10,'EmergencyContactRelation','Son');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (11,'EmergencyContactRelation','Daughter');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (12,'EmergencyContactRelation','Brother');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (13,'EmergencyContactRelation','Sister');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (14,'EmergencyContactRelation','Friend');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (15,'EmergencyContactRelation','Relative');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (16,'CashDepositType','Cash');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (17,'CashDepositType','Cheque');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (18,'WithdrawlType','Cash');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (19,'WithdrawlType','Cheque');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (20,'LoanPaymentPurpose','Loan Amount');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (21,'LoanPaymentPurpose','Pawn Amount');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (22,'LoanCreditPaymentPurpose','Loan Amount');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (23,'LoanCreditPaymentPurpose','Pawn Amount');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (24,'WithdrawlStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (25,'WithdrawlStatus','Approved');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (26,'WithdrawlStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (27,'NEFTStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (28,'NEFTStatus','Approved');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (29,'NEFTStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (30,'LoanCreditApplicationStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (31,'LoanCreditApplicationStatus','Approved');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (32,'LoanCreditApplicationStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (36,'NEFTTransferStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (37,'NEFTTransferStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (38,'NEFTTransferStatus','Approved');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (39,'UserLevel','Client');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (40,'UserLevel','Admin');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (41,'UserLevel','Finance');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (42,'CashDepositTransactionStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (43,'CashDepositTransactionStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (44,'CashDepositTransactionStatus','Approved');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (45,'CashWithdrawlTransactionStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (46,'CashWithdrawlTransactionStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (47,'CashWithdrawlTransactionStatus','Approved');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (48,'LoanPaymentStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (49,'LoanPaymentStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (50,'LoanPaymentStatus','Approved');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (51,'TransactionStatus','Pending');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (52,'TransactionStatus','Cancelled');
  INSERT INTO `lookups` (`id`,`Type`,`Value`) VALUES (53,'TransactionStatus','Approved');
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('CashDepositNo','DS',NULL,37,0,0);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('ClientNo','CD',NULL,7,0,0);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('LoanAccountNo','L',NULL,2,1,0);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('LoanCreditPaymentNo','LC',NULL,25,0,1);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('LoanID','LN',NULL,0,0,0);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('LoanPaymentNo','LD',NULL,16,0,0);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('NEFTTransferNo','NF',NULL,0,0,0);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('SavingsAccountNumber',NULL,NULL,10000007,0,0);
  INSERT INTO `recordidcounter` (`Name`,`Prefix`,`Sufix`,`Number`,`flag`,`useflag`) VALUES ('WithdrawlNo','WD',NULL,20,0,1);
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (76,0,0,0.00,0.00,1.00,'0000-00-00 00:00:00','Deposit of[1] for [ClientF ClientL - 10000003]','DS000001','ClientF ClientL','Cash',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Savings',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Cash Deposit',1.00,'10000003','CD000003','AdminF','2016-12-12 16:58:27','ClientF ClientL','DS000001','Cancelled',NULL,NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (77,0,0,0.00,0.00,1.00,'0000-00-00 00:00:00','Deposit of[1] for [Client2 Client2 - 10000007]','DS000002','Client2 Client2','Cash',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Savings',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Cash Deposit',1.00,'10000007','CD000007','AdminF','2016-12-12 16:50:26','Client2 Client2','DS000002','Approved',NULL,NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (78,0,0,0.00,0.00,100.00,'0000-00-00 00:00:00','Lending of[100] for [ClientF ClientL - L000001]','DS000003',NULL,'ClientF ClientL',NULL,NULL,NULL,NULL,NULL,NULL,'DS000003','ClientF ClientL','Loan Amount','Loan',NULL,NULL,NULL,NULL,'Cancelled','Witness1',NULL,NULL,'Loan Credit',100.00,'L000001','','AdminF','2016-12-12 17:58:11','ClientF ClientL','DS000003','Cancelled',NULL,NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (79,0,0,0.00,0.00,200.00,'0000-00-00 00:00:00','Lending of[200] for [Client2 Client2 - L000002]','DS000004',NULL,'Client2 Client2',NULL,NULL,NULL,NULL,NULL,NULL,'DS000004','Client2 Client2','Pawn Amount','Loan',NULL,NULL,NULL,NULL,'Approved','witness2',NULL,NULL,'Loan Credit',400.00,'L000002','','AdminF','2016-12-12 17:57:59','Client2 Client2','DS000004','Approved',NULL,NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (80,0,0,0.00,0.00,1.00,'2016-12-12 17:14:25','Withdrawl of[1] for [Client2 Client2 - 10000007]',NULL,NULL,NULL,'WD000009',NULL,'Cash',NULL,NULL,NULL,NULL,NULL,NULL,'Savings',NULL,NULL,'Pending',NULL,NULL,NULL,NULL,NULL,'Cash Withdrawl',0.00,'10000007','CD000007','AdminF','2016-12-12 17:22:01','Client2 Client2','WD000009','Approved','CD000007',NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (81,0,0,0.00,0.00,1.00,'2016-12-12 17:58:29','Withdrawl of[1] for [ClientF ClientL - L000001]',NULL,NULL,NULL,NULL,NULL,NULL,'LD000002','ClientF ClientL','Loan Amount',NULL,NULL,NULL,'Loan',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Loan Payment',99.00,'L000001','CD000003','AdminF','2016-12-12 17:59:33','ClientF ClientL','','Approved','CD000003','Approved',NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (82,0,0,0.00,0.00,1.00,'2016-12-12 18:13:20','Withdrawl of[1] for [Client2 Client2 - L000002]',NULL,NULL,NULL,NULL,NULL,NULL,'LD000003','Client2 Client2','Loan Amount',NULL,NULL,NULL,'Loan',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Loan Payment',400.00,'L000002','CD000007','AdminF','2016-12-12 18:13:20','Client2 Client2','','Pending','CD000007','Pending',NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (83,0,0,0.00,0.00,1.00,'2016-12-12 18:23:32','Withdrawl of[1] for [Client2 Client2 - L000002]',NULL,NULL,NULL,NULL,NULL,NULL,'','Client2 Client2','Loan Amount',NULL,NULL,NULL,'Loan',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Loan Payment',399.00,'L000002','CD000007','AdminF','2016-12-12 18:54:54','Client2 Client2','','Approved','CD000007','Approved',NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (84,0,0,0.00,0.00,1.00,'2016-12-12 18:49:10','Withdrawl of[1] for [Client2 Client2 - 10000007]','DS000031',NULL,'Cash',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Savings',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,'10000007',NULL,'AdminF','2016-12-12 18:49:10','Client2 Client2','DS000030','Pending','CD000007',NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (85,0,0,0.00,0.00,1.00,'2016-12-12 18:57:14','Withdrawl of[1] for [ClientF ClientL - L000001]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LC000012','ClientF ClientL','Loan Amount','Loan',NULL,NULL,NULL,NULL,'Approved','Witness1',NULL,NULL,'Loan Credit',100.00,'L000001','CD000003','AdminF','2016-12-12 18:59:46','ClientF ClientL','LC000012','Approved','CD000003',NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (86,0,0,0.00,0.00,1.00,'2016-12-12 19:00:10','Withdrawl of[1] for [ClientF ClientL - 10000003]',NULL,NULL,NULL,'',NULL,'Cash',NULL,NULL,NULL,NULL,NULL,NULL,'Savings',NULL,NULL,'Pending',NULL,NULL,NULL,NULL,NULL,'Cash Withdrawl',1.00,'10000003','CD000003','AdminF','2016-12-12 19:00:10','ClientF ClientL',NULL,'Pending','CD000003',NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (87,0,0,0.00,0.00,2.00,'2016-12-12 19:00:48','Withdrawl of[2] for [Client2 Client2 - L000002]',NULL,NULL,NULL,'',NULL,'Cash',NULL,NULL,NULL,NULL,NULL,NULL,'Loan',NULL,NULL,'Approved',NULL,NULL,NULL,NULL,NULL,'Cash Withdrawl',397.00,'L000002','CD000007','AdminF','2016-12-12 19:01:16','Client2 Client2','','Approved','CD000007',NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (88,0,0,0.00,0.00,2.00,'2016-12-12 19:02:16','Withdrawl of[2] for [ClientF ClientL - 10000003]','DS000033',NULL,'Cash',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Savings',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Cash Deposit',3.00,'10000003','CD000003','AdminF','2016-12-12 19:02:37','ClientF ClientL','DS000033','Approved','CD000003',NULL,'Approved');
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (89,0,0,0.00,0.00,3.00,'2016-12-12 19:10:54','Withdrawl of[3] for [ClientF ClientL - 10000003]',NULL,NULL,NULL,'WD000018',NULL,'Cash',NULL,NULL,NULL,NULL,NULL,NULL,'Savings',NULL,NULL,'Approved',NULL,NULL,NULL,NULL,NULL,'Cash Withdrawl',0.00,'10000003','CD000003','AdminF','2016-12-12 19:11:25','ClientF ClientL','WD000018','Approved','CD000003',NULL,NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (90,0,0,0.00,0.00,1.00,'2016-12-12 19:13:16','Withdrawl of[1] for [Client2 Client2 - L000002]',NULL,NULL,NULL,NULL,NULL,NULL,'LD000015','Client2 Client2','Loan Amount',NULL,NULL,NULL,'Loan',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Loan Payment',397.00,'L000002','CD000007','AdminF','2016-12-12 19:13:16','Client2 Client2','LD000015','Pending','CD000007','Pending',NULL);
  INSERT INTO `transactions` (`id`,`DebitAccount`,`CreditAccount`,`DebitAccountTransactionCharge`,`CreditAccountTransactionCharge`,`Amount`,`DateTime`,`Description`,`CashDepositNo`,`CashDepositorName`,`CashDepositType`,`WithdrawlNo`,`WithdrawlName`,`WithdrawlType`,`LoanPaymentNo`,`LoanPaymentName`,`LoanPaymentPurpose`,`LoanCreditPaymentNo`,`LoanCreditPaymentName`,`LoanCreditPaymentPurpose`,`AccountType`,`InterestAmount`,`PrincipalAmount`,`WithdrawlStatus`,`NEFTTransferStatus`,`LoanCreditApplicationStatus`,`LoanCreditWitness`,`NEFTTransferNo`,`NEFTTransferDepositorName`,`TransactionType`,`Balance`,`AccountNumber`,`ClientNo`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`TransactionNo`,`TransactionStatus`,`SelectedClientNo`,`LoanPaymentStatus`,`CashDepositStatus`) VALUES (91,0,0,0.00,0.00,1.00,'2016-12-12 19:14:02','Withdrawl of[1] for [ClientF ClientL - L000001]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'LC000024','ClientF ClientL','Loan Amount','Loan',NULL,NULL,NULL,NULL,'Pending','Witness1',NULL,NULL,'Loan Credit',100.00,'L000001','CD000003','AdminF','2016-12-12 19:14:02','ClientF ClientL','LC000024','Pending','CD000003',NULL,NULL);
  SET FOREIGN_KEY_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 0;
  INSERT INTO `users` (`id`,`FirstName`,`LastName`,`Sex`,`DateOfBirth`,`TelephoneNo`,`EmailAddress`,`CurrentAddress`,`PlaceOfBirth`,`PassportOrID`,`ProfilePhoto`,`AttachedFile`,`ClientNo`,`EmergencyContactPerson`,`EmergencyContactRelation`,`EmergencyContactTel`,`Username`,`Password`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`AccountNumber`,`OpeningAccountDate`,`OpeningAccountBalance`,`UserLevel`,`InterestRate`,`SetWithdrawDate`) VALUES (25,'AdminF','AdminL',6,'2016-12-01','1','1@1.com','1','1','1',NULL,NULL,'CD000001','1',11,'1','admin','admin','AdminFirst','2016-12-11 16:54:51','AdminF AdminL','10000045','2016-12-11 16:54:51',1000.00,'Admin','3','2016-12-01');
  INSERT INTO `users` (`id`,`FirstName`,`LastName`,`Sex`,`DateOfBirth`,`TelephoneNo`,`EmailAddress`,`CurrentAddress`,`PlaceOfBirth`,`PassportOrID`,`ProfilePhoto`,`AttachedFile`,`ClientNo`,`EmergencyContactPerson`,`EmergencyContactRelation`,`EmergencyContactTel`,`Username`,`Password`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`AccountNumber`,`OpeningAccountDate`,`OpeningAccountBalance`,`UserLevel`,`InterestRate`,`SetWithdrawDate`) VALUES (28,'Application','Admin',7,'2016-12-01','1','1@11.com','1','1','1',NULL,NULL,'CD000001','1',12,'1','ApplicationAdmin','admin','AdminF','2016-12-12 14:05:08','Application Admin','10000001','2016-12-12 14:05:08',1.00,'Admin','1','2016-12-01');
  INSERT INTO `users` (`id`,`FirstName`,`LastName`,`Sex`,`DateOfBirth`,`TelephoneNo`,`EmailAddress`,`CurrentAddress`,`PlaceOfBirth`,`PassportOrID`,`ProfilePhoto`,`AttachedFile`,`ClientNo`,`EmergencyContactPerson`,`EmergencyContactRelation`,`EmergencyContactTel`,`Username`,`Password`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`AccountNumber`,`OpeningAccountDate`,`OpeningAccountBalance`,`UserLevel`,`InterestRate`,`SetWithdrawDate`) VALUES (29,'ClientF','ClientL',6,'2016-12-02','1','1@111.com','1','1','1',NULL,NULL,'CD000003','1',11,'1','Client1','admin','AdminF','2016-12-12 14:13:30','ClientF ClientL','10000003','2016-12-12 14:13:30',1.00,'Client','1','2016-12-04');
  INSERT INTO `users` (`id`,`FirstName`,`LastName`,`Sex`,`DateOfBirth`,`TelephoneNo`,`EmailAddress`,`CurrentAddress`,`PlaceOfBirth`,`PassportOrID`,`ProfilePhoto`,`AttachedFile`,`ClientNo`,`EmergencyContactPerson`,`EmergencyContactRelation`,`EmergencyContactTel`,`Username`,`Password`,`LastModifiedBy`,`LastModifiedDate`,`AccountName`,`AccountNumber`,`OpeningAccountDate`,`OpeningAccountBalance`,`UserLevel`,`InterestRate`,`SetWithdrawDate`) VALUES (30,'Client2','Client2',6,'2016-12-01','1','1@1111.com','1','1','1',NULL,NULL,'CD000007','1',14,'1','Client2','admin','AdminF','2016-12-12 14:20:04','Client2 Client2','10000007','2016-12-12 14:20:04',1.00,'Client','1','2016-12-01');
  SET FOREIGN_KEY_CHECKS = 1;
  