Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # ************************************************************
- # Sequel Pro SQL dump
- # Version 4096
- #
- # http://www.sequelpro.com/
- # http://code.google.com/p/sequel-pro/
- #
- # Host: 127.0.0.1 (MySQL 5.6.22)
- # Database: test1
- # Generation Time: 2017-07-07 19:23:21 +0000
- # ************************************************************
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- # Dump of table account
- # ------------------------------------------------------------
- LOCK TABLES `account` WRITE;
- /*!40000 ALTER TABLE `account` DISABLE KEYS */;
- INSERT INTO `account` (`accountid`, `balance`, `created_date`, `currency`, `expire_date`, `locked`, `acctypeid`, `branchid`, `userid`)
- VALUES
- (1,9997,'0001-01-01','USD','0001-01-01',0,1,1,1),
- (2,10460.6,'0001-01-01','LKR','0001-01-01',0,1,1,1),
- (110025,4500,'2017-07-01','LKR',NULL,0,1,2,7),
- (553304,500000,'2017-06-28','LKR',NULL,0,2,5,3),
- (753225,3075,'2017-07-02','LKR',NULL,0,1,3,6),
- (853556,600,'2017-06-14','USD','2018-06-14',0,3,1,4),
- (884423,8562,'2017-05-09','LKR',NULL,0,1,4,5),
- (884424,NULL,NULL,NULL,NULL,0,1,1,1);
- /*!40000 ALTER TABLE `account` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table account_type
- # ------------------------------------------------------------
- LOCK TABLES `account_type` WRITE;
- /*!40000 ALTER TABLE `account_type` DISABLE KEYS */;
- 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);
- /*!40000 ALTER TABLE `account_type` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table admin
- # ------------------------------------------------------------
- # Dump of table branch
- # ------------------------------------------------------------
- LOCK TABLES `branch` WRITE;
- /*!40000 ALTER TABLE `branch` DISABLE KEYS */;
- 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');
- /*!40000 ALTER TABLE `branch` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table customer
- # ------------------------------------------------------------
- LOCK TABLES `customer` WRITE;
- /*!40000 ALTER TABLE `customer` DISABLE KEYS */;
- 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);
- /*!40000 ALTER TABLE `customer` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table login_history
- # ------------------------------------------------------------
- LOCK TABLES `login_history` WRITE;
- /*!40000 ALTER TABLE `login_history` DISABLE KEYS */;
- INSERT INTO `login_history` (`id`, `authorized`, `createdtime`, `ipaddress`, `username`)
- VALUES
- (1,0,'2017-07-08 00:30:34',NULL,'sahan'),
- (2,0,'2017-07-08 00:30:34',NULL,'sahan'),
- (3,0,'2017-07-08 00:30:34',NULL,'sahan'),
- (4,0,'2017-07-08 01:05:55',NULL,'xyz'),
- (5,0,'2017-07-08 01:06:46',NULL,'xyz'),
- (6,0,'2017-07-08 02:00:36',NULL,'xyz');
- /*!40000 ALTER TABLE `login_history` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table login_info
- # ------------------------------------------------------------
- # Dump of table merchant
- # ------------------------------------------------------------
- LOCK TABLES `merchant` WRITE;
- /*!40000 ALTER TABLE `merchant` DISABLE KEYS */;
- INSERT INTO `merchant` (`merchantid`, `logourl`, `orgname`, `registrationno`, `taxno`)
- VALUES
- (1,'asd','asd','1232','12313');
- /*!40000 ALTER TABLE `merchant` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table merchant_services
- # ------------------------------------------------------------
- LOCK TABLES `merchant_services` WRITE;
- /*!40000 ALTER TABLE `merchant_services` DISABLE KEYS */;
- INSERT INTO `merchant_services` (`serviceid`, `accountid`, `description`, `servicename`, `merchantid`)
- VALUES
- (1,2,NULL,'New Service',1);
- /*!40000 ALTER TABLE `merchant_services` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table postion
- # ------------------------------------------------------------
- # Dump of table role
- # ------------------------------------------------------------
- LOCK TABLES `role` WRITE;
- /*!40000 ALTER TABLE `role` DISABLE KEYS */;
- INSERT INTO `role` (`id`, `name`)
- VALUES
- (1,'USER'),
- (2,'ADMIN');
- /*!40000 ALTER TABLE `role` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table security_answers
- # ------------------------------------------------------------
- LOCK TABLES `security_answers` WRITE;
- /*!40000 ALTER TABLE `security_answers` DISABLE KEYS */;
- INSERT INTO `security_answers` (`id`, `answer`, `user_id`, `securityquestionsid`, `security_answers_user_id`)
- VALUES
- (1,'1',8,1,NULL),
- (2,'2',8,2,NULL),
- (3,'3',8,1,NULL),
- (4,'1',1,1,NULL),
- (5,'1',1,2,NULL),
- (6,'1',1,1,NULL);
- /*!40000 ALTER TABLE `security_answers` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table security_questions
- # ------------------------------------------------------------
- LOCK TABLES `security_questions` WRITE;
- /*!40000 ALTER TABLE `security_questions` DISABLE KEYS */;
- INSERT INTO `security_questions` (`id`, `question`)
- VALUES
- (1,'What is build'),
- (2,'What is your dogs name'),
- (3,'What is your name');
- /*!40000 ALTER TABLE `security_questions` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table suspicious_log
- # ------------------------------------------------------------
- LOCK TABLES `suspicious_log` WRITE;
- /*!40000 ALTER TABLE `suspicious_log` DISABLE KEYS */;
- INSERT INTO `suspicious_log` (`id`, `created_date`, `message`)
- VALUES
- (1,'0000-00-01','asd');
- /*!40000 ALTER TABLE `suspicious_log` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table transaction
- # ------------------------------------------------------------
- LOCK TABLES `transaction` WRITE;
- /*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
- 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),
- (2,1,1,'1',1,'1',1,'1',1,'0000-00-02 00:00:02','T',1),
- (3,1,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (4,2,1,'USD',1,NULL,1,'USD',1,'2017-07-08 00:30:17','T',1),
- (5,1,1,'USD',1,NULL,2,'LKR',153.55,'2017-07-08 00:30:38','T',1),
- (6,2,1,'USD',1,NULL,1,'USD',1,'2017-07-08 00:30:39','T',1),
- (7,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (8,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (9,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (10,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (11,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (12,1000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (13,1000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (14,1000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (15,100000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
- (16,11,1,'USD',1,'sa',1,'USD',1,'2017-07-08 01:11:15','T',1),
- (17,2,1,'USD',1,NULL,2,'LKR',153.55,'2017-07-08 01:11:27','T',1);
- /*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table user_role
- # ------------------------------------------------------------
- LOCK TABLES `user_role` WRITE;
- /*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
- INSERT INTO `user_role` (`users_user_id`, `role_id`)
- VALUES
- (1,1),
- (8,1),
- (9,1),
- (2,2);
- /*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
- UNLOCK TABLES;
- # Dump of table users
- # ------------------------------------------------------------
- LOCK TABLES `users` WRITE;
- /*!40000 ALTER TABLE `users` DISABLE KEYS */;
- 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);
- /*!40000 ALTER TABLE `users` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement