-- insert into city(id, country, name, state, map) values (1, 'Australia', 'Brisbane', 'Queensland', '-27.470933, 153.023502')

-- INSERT INTO customer (customerid, first_name) VALUES (1,"one name");
insert into role (id, name) values (1,'USER');
insert into role (id, name) values (2,'ADMIN');

INSERT INTO `customer` (`customerid`, `address_line1`, `address_line2`, `address_line3`, `city`, `dob`, `email`, `fax_no`, `first_name`, `gender`, `last_name`, `mobile_no`, `nic`, `telephone_no`, `title`)
VALUES
    (1,'LeodqDFC7erwCKqvheJEcg==',NULL,NULL,'7z6mfQk8DJTtGVqzNhPgYA==',NULL,'hmI9vCp/hv+nldFhmkK7UNL1dwfuIqKi/UovR2LkYPw=',NULL,'68CfpMedv1HxEvU87BVioA==',NULL,'OHgQr2E76/y0lpJHtUQuQA==',NULL,'0Hj6kyOfOG/jfHNiDnnddA==',NULL,NULL),
    (100,'No. 100','Kolonnawa Road',NULL,'Kolonnawa','1993-05-01','sahan@gmail.com',NULL,'Sahan','Male','Gunarathna','0774532145','934562845V','0112587564','Mr'),
    (101,'No 20','Kalidasa Road',NULL,'Matara','1982-07-01','kamala@gmail.com',NULL,'Kamala','Female','Jayarathne','0715324785','824532158V',NULL,'Ms'),
    (102,'No. 52','Vijerama Road',NULL,'Nugegoda','1956-04-05','samantha@gmail.com','0112452124','Samantha','Male','Gunawaradhana','0778547851','567862482V','0114785245','Mr'),
    (103,'No. 35','Vihara Road','Isurupaya','Polonnaruwa','1989-04-01','gihan@yahoo.com',NULL,'Gihan','Male','Samarathunga','0774528961','891435826V','0475682158','Mr'),
    (104,'No 26','Pengiriwattha Road','Delkanda','Nugegoda','1995-06-08','sanathj@ymail.com',NULL,'Sanath','Male','Jayasooriya','0774582156','957832145V','0115789652','Mr'),
    (105,'EKT5r2xDMC07pXV8VbzN1w==',NULL,NULL,'wBRm5fTwd9Qmbs7zf3F/2w==',NULL,'FmYHelO8PnKX9et1FGGU2Q8TjQmv75E7TsF18kcM3TY=',NULL,'gb4ux6Y55VWnz99Dt4qDxg==',NULL,'LgQkAjg1XwGsjC0vydY/dQ==',NULL,'PYWuOfCgbdLzpPXeIdV0yw==',NULL,NULL),
    (106,'7zzLKrNed3KyleSnYO5ULg==',NULL,NULL,'BgZQBiHiLSO2mXTcyfEM6g==',NULL,'9/ymrI/u5klCx3c6u9AvOlQoqiPjH/bvypoA+Z7gWQc=',NULL,'uZE8mKHY36ZAlhCaDzRcGQ==',NULL,'b/i0k3Z9idAbfBjMfGpbuw==',NULL,'FdsxDyF/CDEBgzhNUlaqrg==',NULL,NULL);


INSERT INTO `users` (`user_id`, `creation_date`, `locked`, `password`, `user_type`, `username`, `customer_id`, `merchant_merchantid`)
VALUES
    (1,'2017-07-07 23:00:17',1,'$2a$10$ap2S7QuaPMdJLlZu2tW9NOir9QF9NP6l9Nak6KxBbkkS/s7qRP3jS','CUSTOMER','testinguser1',106,NULL),
    (2,NULL,1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'ADMIN',NULL,NULL),
    (3,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'sahan',100,NULL),
    (4,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'kamala',101,NULL),
    (5,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'samantha',102,NULL),
    (6,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'gihan',103,NULL),
    (7,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'sanath',104,NULL),
    (8,'2017-07-08 00:30:40',1,'$2a$10$0BO0lwXR7ULdSr2VaYrw9OO.Mcq3b3ZayJM/dKZ5v0EgKt6rrQ2g.','CUSTOMER','1111111110006',105,NULL);



insert into user_role(users_user_id, role_id) values(1,1);
insert into user_role(users_user_id, role_id) values(2,2);

-- insert into branch(branch_id, address_line1, address_line2, address_line3, branch_name, city, email, fax_no, telephone_no) values (1,'A','B','C',NULL,NULL,NULL,NULL,NULL);

INSERT INTO `account_type` (`acc_type_id`, `acc_interest_rates`, `acc_name`, `daily_withdraw_limit`, `max_months`, `max_over_draft_amount`, `min_avg_balance`, `min_init_balance`, `min_months`) VALUES
(1, 3.2, 'Savings', 50000, NULL, NULL, NULL, 500, NULL),
(2, 2, 'Current Account', NULL, NULL, 50000, 100000, 1000000, NULL),
(3, 3, 'Fixed Disposit', NULL, 24, NULL, 3000, 50000, 12);

-- insert into account_type (acc_type_id, acc_interest_rates, acc_name, max_months, max_over_draft_amount, min_avg_balance, min_init_balance, min_months) values (1,1,'asd',1,NULL,NULL,NULL,NULL);

INSERT INTO `branch` (`branch_id`, `address_line1`, `address_line2`, `address_line3`, `branch_name`, `city`, `email`, `fax_no`, `telephone_no`) VALUES
(1, '100', 'Anagaraika Dharmapala Road', '', 'Matara-2', 'Matara', 'matara2@abcbank.com', '0412235558', '0412235853'),
(2, 'No 45', 'Highlevel Road', NULL, 'Nugegoda-1', 'Nugegoda', 'nugegoda1@abcbank.com', '0112568432', '0112548558'),
(3, 'No 65', 'Isurupaya', NULL, 'Polonnaruwa-2', 'Polonnaruwa', 'polonnaruwa2@abcbank.com', '0474582357', '0475965826'),
(4, 'No 12', 'Highlevel Road', NULL, 'Nugegoda-2', 'Nugegoda', 'nugegoda1@abcbank.com', '0112568596', '0112548524'),
(5, 'no 23', 'Wellampitiya Road', NULL, 'Kolonnawa', 'Kolonnawa', 'kolonnawa@abcbank.com', '0114568478', '0114567539');


INSERT INTO merchant (merchantid, logourl, orgname, registrationno, taxno) VALUES (1,'asd','asd','1232','12313');
-- insert into city(id, country, name, state, map) values (1, 'Australia', 'Brisbane', 'Queensland', '-27.470933, 153.023502')


INSERT INTO `transaction` (`transactionid`, `amount`, `fromaccountid`, `fromcurrency`, `fromrate`, `message`, `toaccountid`, `tocurrency`, `torate`, `transactiontime`, `transtype`, `userid`)
VALUES(1,1,1,'1',1,'1',1,'1',1,'0000-00-01 00:00:01','T',1);
INSERT INTO `transaction` (`transactionid`, `amount`, `fromaccountid`, `fromcurrency`, `fromrate`, `message`, `toaccountid`, `tocurrency`, `torate`, `transactiontime`, `transtype`, `userid`)
VALUES(2,1,1,'1',1,'1',1,'1',1,'0000-00-02 00:00:02','T',1);
INSERT INTO `transaction` (`transactionid`, `amount`, `fromaccountid`, `fromcurrency`, `fromrate`, `message`, `toaccountid`, `tocurrency`, `torate`, `transactiontime`, `transtype`, `userid`)
VALUES(3,1,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1);


INSERT INTO account (accountid, balance, created_date, currency, expire_date, acctypeid, branchid, userid) VALUES (1,10000,'0001-01-01','USD','0001-01-01',1,1,1);
INSERT INTO account (accountid, balance, created_date, currency, expire_date, acctypeid, branchid, userid) VALUES (2,10000,'0001-01-01','LKR','0001-01-01',1,1,1);

INSERT INTO `account` (`accountid`, `balance`, `created_date`, `currency`, `expire_date`, `acctypeid`, `branchid`, `userid`) VALUES
(110025, 4500, '2017-07-01', 'LKR', NULL, 1, 2, 7),
(553304, 500000, '2017-06-28', 'LKR', NULL, 2, 5, 3),
(753225, 3075, '2017-07-02', 'LKR', NULL, 1, 3, 6),
(853556, 600, '2017-06-14', 'USD', '2018-06-14', 3, 1, 4),
(884423, 8562, '2017-05-09', 'LKR', NULL, 1, 4, 5);

INSERT INTO merchant_services (serviceid, merchantid,accountid,  servicename) VALUES (1,1,2, "New Service");

INSERT INTO security_questions (id, question) values(1,"What is build");
INSERT INTO security_questions (id, question) values(2,"What is your dogs name");
INSERT INTO security_questions (id, question) values(3,"What is your name");