API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 7th, 2017
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.70 KB | None | 0 0
raw download clone embed print report
  1. # ************************************************************
  2. # Sequel Pro SQL dump
  3. # Version 4096
  4. #
  5. # http://www.sequelpro.com/
  6. # http://code.google.com/p/sequel-pro/
  7. #
  8. # Host: 127.0.0.1 (MySQL 5.6.22)
  9. # Database: test1
  10. # Generation Time: 2017-07-07 19:23:21 +0000
  11. # ************************************************************
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  19. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  20. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  21.  
  22.  
  23. # Dump of table account
  24. # ------------------------------------------------------------
  25.  
  26. LOCK TABLES `account` WRITE;
  27. /*!40000 ALTER TABLE `account` DISABLE KEYS */;
  28.  
  29. INSERT INTO `account` (`accountid`, `balance`, `created_date`, `currency`, `expire_date`, `locked`, `acctypeid`, `branchid`, `userid`)
  30. VALUES
  31. (1,9997,'0001-01-01','USD','0001-01-01',0,1,1,1),
  32. (2,10460.6,'0001-01-01','LKR','0001-01-01',0,1,1,1),
  33. (110025,4500,'2017-07-01','LKR',NULL,0,1,2,7),
  34. (553304,500000,'2017-06-28','LKR',NULL,0,2,5,3),
  35. (753225,3075,'2017-07-02','LKR',NULL,0,1,3,6),
  36. (853556,600,'2017-06-14','USD','2018-06-14',0,3,1,4),
  37. (884423,8562,'2017-05-09','LKR',NULL,0,1,4,5),
  38. (884424,NULL,NULL,NULL,NULL,0,1,1,1);
  39.  
  40. /*!40000 ALTER TABLE `account` ENABLE KEYS */;
  41. UNLOCK TABLES;
  42.  
  43.  
  44. # Dump of table account_type
  45. # ------------------------------------------------------------
  46.  
  47. LOCK TABLES `account_type` WRITE;
  48. /*!40000 ALTER TABLE `account_type` DISABLE KEYS */;
  49.  
  50. 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`)
  51. VALUES
  52. (1,3.2,'Savings',50000,NULL,NULL,NULL,500,NULL),
  53. (2,2,'Current Account',NULL,NULL,50000,100000,1000000,NULL),
  54. (3,3,'Fixed Disposit',NULL,24,NULL,3000,50000,12);
  55.  
  56. /*!40000 ALTER TABLE `account_type` ENABLE KEYS */;
  57. UNLOCK TABLES;
  58.  
  59.  
  60. # Dump of table admin
  61. # ------------------------------------------------------------
  62.  
  63.  
  64.  
  65. # Dump of table branch
  66. # ------------------------------------------------------------
  67.  
  68. LOCK TABLES `branch` WRITE;
  69. /*!40000 ALTER TABLE `branch` DISABLE KEYS */;
  70.  
  71. INSERT INTO `branch` (`branch_id`, `address_line1`, `address_line2`, `address_line3`, `branch_name`, `city`, `email`, `fax_no`, `telephone_no`)
  72. VALUES
  73. (1,'100','Anagaraika Dharmapala Road','','Matara-2','Matara','matara2@abcbank.com','0412235558','0412235853'),
  74. (2,'No 45','Highlevel Road',NULL,'Nugegoda-1','Nugegoda','nugegoda1@abcbank.com','0112568432','0112548558'),
  75. (3,'No 65','Isurupaya',NULL,'Polonnaruwa-2','Polonnaruwa','polonnaruwa2@abcbank.com','0474582357','0475965826'),
  76. (4,'No 12','Highlevel Road',NULL,'Nugegoda-2','Nugegoda','nugegoda1@abcbank.com','0112568596','0112548524'),
  77. (5,'no 23','Wellampitiya Road',NULL,'Kolonnawa','Kolonnawa','kolonnawa@abcbank.com','0114568478','0114567539');
  78.  
  79. /*!40000 ALTER TABLE `branch` ENABLE KEYS */;
  80. UNLOCK TABLES;
  81.  
  82.  
  83. # Dump of table customer
  84. # ------------------------------------------------------------
  85.  
  86. LOCK TABLES `customer` WRITE;
  87. /*!40000 ALTER TABLE `customer` DISABLE KEYS */;
  88.  
  89. 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`)
  90. VALUES
  91. (1,'LeodqDFC7erwCKqvheJEcg==',NULL,NULL,'7z6mfQk8DJTtGVqzNhPgYA==',NULL,'hmI9vCp/hv+nldFhmkK7UNL1dwfuIqKi/UovR2LkYPw=',NULL,'68CfpMedv1HxEvU87BVioA==',NULL,'OHgQr2E76/y0lpJHtUQuQA==',NULL,'0Hj6kyOfOG/jfHNiDnnddA==',NULL,NULL),
  92. (100,'No. 100','Kolonnawa Road',NULL,'Kolonnawa','1993-05-01','sahan@gmail.com',NULL,'Sahan','Male','Gunarathna','0774532145','934562845V','0112587564','Mr'),
  93. (101,'No 20','Kalidasa Road',NULL,'Matara','1982-07-01','kamala@gmail.com',NULL,'Kamala','Female','Jayarathne','0715324785','824532158V',NULL,'Ms'),
  94. (102,'No. 52','Vijerama Road',NULL,'Nugegoda','1956-04-05','samantha@gmail.com','0112452124','Samantha','Male','Gunawaradhana','0778547851','567862482V','0114785245','Mr'),
  95. (103,'No. 35','Vihara Road','Isurupaya','Polonnaruwa','1989-04-01','gihan@yahoo.com',NULL,'Gihan','Male','Samarathunga','0774528961','891435826V','0475682158','Mr'),
  96. (104,'No 26','Pengiriwattha Road','Delkanda','Nugegoda','1995-06-08','sanathj@ymail.com',NULL,'Sanath','Male','Jayasooriya','0774582156','957832145V','0115789652','Mr'),
  97. (105,'EKT5r2xDMC07pXV8VbzN1w==',NULL,NULL,'wBRm5fTwd9Qmbs7zf3F/2w==',NULL,'FmYHelO8PnKX9et1FGGU2Q8TjQmv75E7TsF18kcM3TY=',NULL,'gb4ux6Y55VWnz99Dt4qDxg==',NULL,'LgQkAjg1XwGsjC0vydY/dQ==',NULL,'PYWuOfCgbdLzpPXeIdV0yw==',NULL,NULL),
  98. (106,'7zzLKrNed3KyleSnYO5ULg==',NULL,NULL,'BgZQBiHiLSO2mXTcyfEM6g==',NULL,'9/ymrI/u5klCx3c6u9AvOlQoqiPjH/bvypoA+Z7gWQc=',NULL,'uZE8mKHY36ZAlhCaDzRcGQ==',NULL,'b/i0k3Z9idAbfBjMfGpbuw==',NULL,'FdsxDyF/CDEBgzhNUlaqrg==',NULL,NULL);
  99.  
  100. /*!40000 ALTER TABLE `customer` ENABLE KEYS */;
  101. UNLOCK TABLES;
  102.  
  103.  
  104. # Dump of table login_history
  105. # ------------------------------------------------------------
  106.  
  107. LOCK TABLES `login_history` WRITE;
  108. /*!40000 ALTER TABLE `login_history` DISABLE KEYS */;
  109.  
  110. INSERT INTO `login_history` (`id`, `authorized`, `createdtime`, `ipaddress`, `username`)
  111. VALUES
  112. (1,0,'2017-07-08 00:30:34',NULL,'sahan'),
  113. (2,0,'2017-07-08 00:30:34',NULL,'sahan'),
  114. (3,0,'2017-07-08 00:30:34',NULL,'sahan'),
  115. (4,0,'2017-07-08 01:05:55',NULL,'xyz'),
  116. (5,0,'2017-07-08 01:06:46',NULL,'xyz'),
  117. (6,0,'2017-07-08 02:00:36',NULL,'xyz');
  118.  
  119. /*!40000 ALTER TABLE `login_history` ENABLE KEYS */;
  120. UNLOCK TABLES;
  121.  
  122.  
  123. # Dump of table login_info
  124. # ------------------------------------------------------------
  125.  
  126.  
  127.  
  128. # Dump of table merchant
  129. # ------------------------------------------------------------
  130.  
  131. LOCK TABLES `merchant` WRITE;
  132. /*!40000 ALTER TABLE `merchant` DISABLE KEYS */;
  133.  
  134. INSERT INTO `merchant` (`merchantid`, `logourl`, `orgname`, `registrationno`, `taxno`)
  135. VALUES
  136. (1,'asd','asd','1232','12313');
  137.  
  138. /*!40000 ALTER TABLE `merchant` ENABLE KEYS */;
  139. UNLOCK TABLES;
  140.  
  141.  
  142. # Dump of table merchant_services
  143. # ------------------------------------------------------------
  144.  
  145. LOCK TABLES `merchant_services` WRITE;
  146. /*!40000 ALTER TABLE `merchant_services` DISABLE KEYS */;
  147.  
  148. INSERT INTO `merchant_services` (`serviceid`, `accountid`, `description`, `servicename`, `merchantid`)
  149. VALUES
  150. (1,2,NULL,'New Service',1);
  151.  
  152. /*!40000 ALTER TABLE `merchant_services` ENABLE KEYS */;
  153. UNLOCK TABLES;
  154.  
  155.  
  156. # Dump of table postion
  157. # ------------------------------------------------------------
  158.  
  159.  
  160.  
  161. # Dump of table role
  162. # ------------------------------------------------------------
  163.  
  164. LOCK TABLES `role` WRITE;
  165. /*!40000 ALTER TABLE `role` DISABLE KEYS */;
  166.  
  167. INSERT INTO `role` (`id`, `name`)
  168. VALUES
  169. (1,'USER'),
  170. (2,'ADMIN');
  171.  
  172. /*!40000 ALTER TABLE `role` ENABLE KEYS */;
  173. UNLOCK TABLES;
  174.  
  175.  
  176. # Dump of table security_answers
  177. # ------------------------------------------------------------
  178.  
  179. LOCK TABLES `security_answers` WRITE;
  180. /*!40000 ALTER TABLE `security_answers` DISABLE KEYS */;
  181.  
  182. INSERT INTO `security_answers` (`id`, `answer`, `user_id`, `securityquestionsid`, `security_answers_user_id`)
  183. VALUES
  184. (1,'1',8,1,NULL),
  185. (2,'2',8,2,NULL),
  186. (3,'3',8,1,NULL),
  187. (4,'1',1,1,NULL),
  188. (5,'1',1,2,NULL),
  189. (6,'1',1,1,NULL);
  190.  
  191. /*!40000 ALTER TABLE `security_answers` ENABLE KEYS */;
  192. UNLOCK TABLES;
  193.  
  194.  
  195. # Dump of table security_questions
  196. # ------------------------------------------------------------
  197.  
  198. LOCK TABLES `security_questions` WRITE;
  199. /*!40000 ALTER TABLE `security_questions` DISABLE KEYS */;
  200.  
  201. INSERT INTO `security_questions` (`id`, `question`)
  202. VALUES
  203. (1,'What is build'),
  204. (2,'What is your dogs name'),
  205. (3,'What is your name');
  206.  
  207. /*!40000 ALTER TABLE `security_questions` ENABLE KEYS */;
  208. UNLOCK TABLES;
  209.  
  210.  
  211. # Dump of table suspicious_log
  212. # ------------------------------------------------------------
  213.  
  214. LOCK TABLES `suspicious_log` WRITE;
  215. /*!40000 ALTER TABLE `suspicious_log` DISABLE KEYS */;
  216.  
  217. INSERT INTO `suspicious_log` (`id`, `created_date`, `message`)
  218. VALUES
  219. (1,'0000-00-01','asd');
  220.  
  221. /*!40000 ALTER TABLE `suspicious_log` ENABLE KEYS */;
  222. UNLOCK TABLES;
  223.  
  224.  
  225. # Dump of table transaction
  226. # ------------------------------------------------------------
  227.  
  228. LOCK TABLES `transaction` WRITE;
  229. /*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
  230.  
  231. INSERT INTO `transaction` (`transactionid`, `amount`, `fromaccountid`, `fromcurrency`, `fromrate`, `message`, `toaccountid`, `tocurrency`, `torate`, `transactiontime`, `transtype`, `userid`)
  232. VALUES
  233. (1,1,1,'1',1,'1',1,'1',1,'0000-00-01 00:00:01','T',1),
  234. (2,1,1,'1',1,'1',1,'1',1,'0000-00-02 00:00:02','T',1),
  235. (3,1,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  236. (4,2,1,'USD',1,NULL,1,'USD',1,'2017-07-08 00:30:17','T',1),
  237. (5,1,1,'USD',1,NULL,2,'LKR',153.55,'2017-07-08 00:30:38','T',1),
  238. (6,2,1,'USD',1,NULL,1,'USD',1,'2017-07-08 00:30:39','T',1),
  239. (7,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  240. (8,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  241. (9,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  242. (10,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  243. (11,100,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  244. (12,1000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  245. (13,1000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  246. (14,1000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  247. (15,100000,1,'1',1,'1',1,'1',1,'0000-00-03 00:00:03','T',1),
  248. (16,11,1,'USD',1,'sa',1,'USD',1,'2017-07-08 01:11:15','T',1),
  249. (17,2,1,'USD',1,NULL,2,'LKR',153.55,'2017-07-08 01:11:27','T',1);
  250.  
  251. /*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
  252. UNLOCK TABLES;
  253.  
  254.  
  255. # Dump of table user_role
  256. # ------------------------------------------------------------
  257.  
  258. LOCK TABLES `user_role` WRITE;
  259. /*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
  260.  
  261. INSERT INTO `user_role` (`users_user_id`, `role_id`)
  262. VALUES
  263. (1,1),
  264. (8,1),
  265. (9,1),
  266. (2,2);
  267.  
  268. /*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
  269. UNLOCK TABLES;
  270.  
  271.  
  272. # Dump of table users
  273. # ------------------------------------------------------------
  274.  
  275. LOCK TABLES `users` WRITE;
  276. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  277.  
  278. INSERT INTO `users` (`user_id`, `creation_date`, `locked`, `password`, `user_type`, `username`, `customer_id`, `merchant_merchantid`)
  279. VALUES
  280. (1,'2017-07-07 23:00:17',1,'$2a$10$ap2S7QuaPMdJLlZu2tW9NOir9QF9NP6l9Nak6KxBbkkS/s7qRP3jS','CUSTOMER','testinguser1',106,NULL),
  281. (2,NULL,1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'ADMIN',NULL,NULL),
  282. (3,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'sahan',100,NULL),
  283. (4,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'kamala',101,NULL),
  284. (5,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'samantha',102,NULL),
  285. (6,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'gihan',103,NULL),
  286. (7,'2017-07-02 00:00:00',1,'$2a$10$sLDnONOzHvBR04Xy5aiT2uAyZf3VUKDOKVFAQqNA2/bUsxC0Z0fOm',NULL,'sanath',104,NULL),
  287. (8,'2017-07-08 00:30:40',1,'$2a$10$0BO0lwXR7ULdSr2VaYrw9OO.Mcq3b3ZayJM/dKZ5v0EgKt6rrQ2g.','CUSTOMER','1111111110006',105,NULL);
  288.  
  289. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  290. UNLOCK TABLES;
  291.  
  292.  
  293.  
  294. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  295. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  296. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  297. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  298. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  299. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!