INSERT INTO [CURRENCIES] ([name], [is_pivot], [code], [is_swapped]) VALUES ('USD', 1, 'USD', 0)
GO

INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('1011','10101','Cash',0,1,'CASH',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('20311','10913','Cash Credit individual loan',0,1,'CASH_CREDIT_INDIVIDUAL_LOAN',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('20312','10913','Cash Credit group loan',0,1,'CASH_CREDIT_GROUP_LOAN',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2032','11113','Rescheduled Loans',0,1,'RESCHEDULED_LOANS',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2037','11113','Accrued interests receivable',0,1,'ACCRUED_INTERESTS_LOANS',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2038','11113','Accrued interests on rescheduled loans',0,1,'ACCRUED_INTERESTS_RESCHEDULED_LOANS',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2911','10923','Bad Loans',0,1,'BAD_LOANS',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2921','10923','Unrecoverable Bad Loans',0,1,'UNRECO_BAD_LOANS',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2971','40260','Interest and Penalties on Past Due Loans',0,1,'IPOPDL',1, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2991','10989','Loan Loss Reserve',0,0,'LOAN_LOSS_RESERVE',2, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('3882','42820','Deferred Income',0,0,'DEFERRED_INCOME',2, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('6712','57101','Provision on bad loans',0,1,'PROVISION_ON_BAD_LOANS',3, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('6751','57107','Loan Loss',0,1,'LOAN_LOSS',3, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('70211','40260','Interests on cash credit individual loan',0,0,'INTERESTS_ON_CASH_CREDIT_INDIVIDUAL_LOAN',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('70212','40260','Interests on cash credit group loan',0,0,'INTERESTS_ON_CASH_CREDIT_GROUP_LOAN',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('7022','40222','Interests on rescheduled loans',0,0,'INTERESTS_ON_RESCHEDULED_LOANS',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('70271','70270','Penalties on past due loans individual loan',0,0,'PENALTIES_ON_PAST_DUE_LOANS_INDIVIDUAL_LOAN',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('70272','70270','Penalties on past due loans group loan',0,0,'PENALTIES_ON_PAST_DUE_LOANS_GROUP_LOAN',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('7028','40260','Interests on bad loans',0,0,'INTERESTS_ON_BAD_LOANS',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('7029','40402','Commissions',0,0,'COMMISSIONS',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('7712','42802','Provision write off',0,0,'PROVISION_WRITE_OFF',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('5211','42802','Loan Loss Allowance on Current Loans',0,0,'LIABILITIES_LOAN_LOSS_CURRENT',2, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('6731','42802','Loan Loss Allowance on Current Loans',0,1,'EXPENSES_LOAN_LOSS_CURRENT',3, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('7731','42802','Resumption of Loan Loss allowance on current loans',0,0,'INCOME_LOAN_LOSS_CURRENT',4, 1,1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('1322','1322','Accounts and Terms Loans',0,0,'ACCOUNTS_AND_TERM_LOANS', 2, 1, 1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2551','2551','Savings',0,0,'SAVINGS', 2, 1, 1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('2000','2000','Account payable interests',0,0,'ACCOUNT_PAYABLE_INTERESTS',3, 1, 1)
INSERT INTO [Accounts]([account_number], [local_account_number], [label], [balance], [debit_plus], [type_code], [description], [type], [currency_id]) VALUES('60132','60132','Interests on deposit account',0,1,'INTERESTS_ON_DEPOSIT_ACCOUNT',3, 1, 1)
GO

INSERT INTO [GeneralParameters]([key], [value]) VALUES('EXTERNAL_CURRENCY','ERE')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('INTERNAL_CURRENCY','AFA')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('BRANCH_CODE','CR')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('COUNTRY','Afghanistan')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('WEEK_END_DAY1',5)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('WEEK_END_DAY2',6)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('PAY_FIRST_INSTALLMENT_REAL_VALUE',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('CITY_MANDATORY',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('GROUP_MIN_MEMBERS',3)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('CITY_IS_AN_OPEN_VALUE',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('CURRENCY_CODE','820')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('LOAN_OFFICER_PORTFOLIO_FILTER',0)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('GROUPED_CASH_RECEIPTS',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('CASH_RECEIPT_BEFORE_CONFIRMATION',0)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('CONSO_NUMBER',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('USE_CENTS',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('DISABLE_FUTURE_REPAYMENTS',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('WEEKLY_CONSOLIDATION_DAY',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('INN','Not set')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('LATE_DAYS_AFTER_ACCRUAL_CEASES',NULL)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('ALLOWS_MULTIPLE_LOANS',0)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('ACCOUNTING_PROCESS',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('SENT_QUESTIONNAIRE',0)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('NAME_FORMAT','L U')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('DONOT_SKIP_WEEKENDS_IN_INSTALLMENTS_DATE',0)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('INCREMENTAL_DURING_DAYOFFS',1)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('USE_PROJECTS', 0)
INSERT INTO [GeneralParameters]([key], [value]) VALUES('CONTRACT_CODE_TEMPLATE', 'BC/YY/PC-LC/ID')
INSERT INTO [GeneralParameters]([key], [value]) VALUES('INTERESTS_ALSO_CREDITED_IN_FL', 0)
GO

INSERT INTO [InstallmentTypes]([name], [nb_of_days], [nb_of_months]) VALUES('Monthly', 0,1)
INSERT INTO [InstallmentTypes]([name], [nb_of_days], [nb_of_months]) VALUES('Biweekly', 14,0)
INSERT INTO [InstallmentTypes]([name], [nb_of_days], [nb_of_months]) VALUES('Weekly', 7,0)
GO

INSERT INTO [ProvisioningRules]([id], [number_of_days_min], [number_of_days_max], [provisioning_value]) VALUES(1, 0, 0, 0.02)
INSERT INTO [ProvisioningRules]([id], [number_of_days_min], [number_of_days_max], [provisioning_value]) VALUES(2, 1, 30, 0.1)
INSERT INTO [ProvisioningRules]([id], [number_of_days_min], [number_of_days_max], [provisioning_value]) VALUES(3, 31, 60, 0.25)
INSERT INTO [ProvisioningRules]([id], [number_of_days_min], [number_of_days_max], [provisioning_value]) VALUES(4, 61, 90, 0.5)
INSERT INTO [ProvisioningRules]([id], [number_of_days_min], [number_of_days_max], [provisioning_value]) VALUES(5, 91, 180, 0.75)
INSERT INTO [ProvisioningRules]([id], [number_of_days_min], [number_of_days_max], [provisioning_value]) VALUES(6, 181, 365, 1)
INSERT INTO [ProvisioningRules]([id], [number_of_days_min], [number_of_days_max], [provisioning_value]) VALUES(7, 366, 99999, 1)
GO

INSERT INTO [Provinces]([name],[deleted]) VALUES('Paris',0)
INSERT INTO [Districts]([name], [province_id],[deleted]) VALUES('Paris', 1,0)
INSERT INTO [DomainOfApplications]([name], [deleted]) VALUES('Agriculture',0)
INSERT INTO [Users]([deleted], [user_name], [user_pass], [role_code], [first_name], [last_name], [mail]) VALUES(0, 'admin', 'admin', 'SUPER', 'admin','admin','Not Set')
GO

INSERT INTO [Cycles] ([name]) VALUES ('Default')
GO

INSERT INTO [AmountCycles] ([cycle_id],[number],[amount_min],[amount_max]) VALUES (1,1,100,1000)
INSERT INTO [AmountCycles] ([cycle_id],[number],[amount_min],[amount_max]) VALUES (1,2,100,10000)
INSERT INTO [AmountCycles] ([cycle_id],[number],[amount_min],[amount_max]) VALUES (1,3,100,100000)
INSERT INTO [AmountCycles] ([cycle_id],[number],[amount_min],[amount_max]) VALUES (1,4,100,1000000)
INSERT INTO [AmountCycles] ([cycle_id],[number],[amount_min],[amount_max]) VALUES (1,5,100,10000000)
GO

INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(1,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(2,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(3,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(4,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(5,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(6,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(7,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(8,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(9,0,'','',0)
INSERT INTO [CustomizableFieldsSettings]([number],[use],[name],[type],[mandatory]) VALUES(10,0,'','',0)
GO

INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(1,1,100)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(2,101,500)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(3,501,1000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(4,1001,2000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(5,2001,5000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(6,5001,10000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(7,10001,20000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(8,20001,50000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(9,50001,100000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(10,100001,200001)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(11,200001,500000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(12,500001,600000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(13,600001,700000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(14,700001,800000)
INSERT INTO [LoanScale]([id],[ScaleMin],[ScaleMax]) VALUES(15,800001,1000000)
GO

INSERT INTO [TechnicalParameters]([name], [value]) VALUES ('version', 'v2.7.0')
GO