· 7 years ago · Feb 20, 2019, 10:10 AM
1-- MySQL dump 10.13 Distrib 5.7.12, for Win64 (x86_64)
2--
3-- Host: localhost Database: ipay_banking_module_lofc
4-- ------------------------------------------------------
5-- Server version 5.7.15-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `app_seq_store`
20--
21
22DROP TABLE IF EXISTS `app_seq_store`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `app_seq_store` (
26 `APP_SEQ_NAME` varchar(255) NOT NULL,
27 `APP_SEQ_VALUE` bigint(20) NOT NULL,
28 PRIMARY KEY (`APP_SEQ_NAME`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1;
30/*!40101 SET character_set_client = @saved_cs_client */;
31
32--
33-- Table structure for table `credit_card_token`
34--
35
36DROP TABLE IF EXISTS `credit_card_token`;
37/*!40101 SET @saved_cs_client = @@character_set_client */;
38/*!40101 SET character_set_client = utf8 */;
39CREATE TABLE `credit_card_token` (
40 `id` bigint(20) NOT NULL,
41 `card_no` varchar(45) DEFAULT NULL,
42 `token` varchar(45) DEFAULT NULL,
43 `bank_code` varchar(45) DEFAULT NULL,
44 `created_date` datetime DEFAULT NULL,
45 `created_user` varchar(45) DEFAULT NULL,
46 `modified_date` datetime DEFAULT NULL,
47 `modified_user` varchar(45) DEFAULT NULL,
48 `status` varchar(45) DEFAULT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB DEFAULT CHARSET=latin1;
51/*!40101 SET character_set_client = @saved_cs_client */;
52
53--
54-- Table structure for table `ipay_bank_account`
55--
56
57DROP TABLE IF EXISTS `ipay_bank_account`;
58/*!40101 SET @saved_cs_client = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `ipay_bank_account` (
61 `id` bigint(20) NOT NULL,
62 `account_no` varchar(30) NOT NULL,
63 `bank` varchar(10) NOT NULL,
64 `token` varchar(50) NOT NULL,
65 `status` varchar(10) NOT NULL DEFAULT 'PENDING',
66 `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
67 `created_user` varchar(45) NOT NULL,
68 `modified_date` timestamp NULL DEFAULT NULL,
69 `modified_user` varchar(45) DEFAULT NULL,
70 PRIMARY KEY (`id`)
71) ENGINE=InnoDB DEFAULT CHARSET=latin1;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Table structure for table `ipay_banking_transaction`
76--
77
78DROP TABLE IF EXISTS `ipay_banking_transaction`;
79/*!40101 SET @saved_cs_client = @@character_set_client */;
80/*!40101 SET character_set_client = utf8 */;
81CREATE TABLE `ipay_banking_transaction` (
82 `id` bigint(20) NOT NULL,
83 `message` varchar(4000) NOT NULL,
84 `message_type` varchar(3) NOT NULL,
85 `transactionid` bigint(20) NOT NULL,
86 `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
87 `created_user` varchar(45) NOT NULL,
88 PRIMARY KEY (`id`)
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Table structure for table `ipay_identity`
94--
95
96DROP TABLE IF EXISTS `ipay_identity`;
97/*!40101 SET @saved_cs_client = @@character_set_client */;
98/*!40101 SET character_set_client = utf8 */;
99CREATE TABLE `ipay_identity` (
100 `id` bigint(20) NOT NULL,
101 `justpay_code` varchar(45) NOT NULL,
102 `devide_id` varchar(45) NOT NULL,
103 `user_id` varchar(45) NOT NULL,
104 `user_name` varchar(45) NOT NULL,
105 `user_mobile` varchar(15) NOT NULL,
106 `user_email` varchar(45) NOT NULL,
107 `platform` varchar(10) NOT NULL,
108 `challenge` varchar(400) DEFAULT NULL,
109 `challenge_issued` varchar(45) DEFAULT NULL,
110 `certificate_issued` varchar(45) DEFAULT NULL,
111 `status` varchar(10) DEFAULT 'PENDING',
112 `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
113 PRIMARY KEY (`id`)
114) ENGINE=InnoDB DEFAULT CHARSET=latin1;
115/*!40101 SET character_set_client = @saved_cs_client */;
116
117--
118-- Table structure for table `ipay_identity_log`
119--
120
121DROP TABLE IF EXISTS `ipay_identity_log`;
122/*!40101 SET @saved_cs_client = @@character_set_client */;
123/*!40101 SET character_set_client = utf8 */;
124CREATE TABLE `ipay_identity_log` (
125 `id` bigint(20) NOT NULL,
126 `message` longblob,
127 `message_type` varchar(3) DEFAULT NULL,
128 `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
129 PRIMARY KEY (`id`)
130) ENGINE=InnoDB DEFAULT CHARSET=latin1;
131/*!40101 SET character_set_client = @saved_cs_client */;
132
133--
134-- Table structure for table `ipay_mandate`
135--
136
137DROP TABLE IF EXISTS `ipay_mandate`;
138/*!40101 SET @saved_cs_client = @@character_set_client */;
139/*!40101 SET character_set_client = utf8 */;
140CREATE TABLE `ipay_mandate` (
141 `id` bigint(20) NOT NULL,
142 `device_id` varchar(45) NOT NULL,
143 `user_id` varchar(45) NOT NULL,
144 `mandate` longblob NOT NULL,
145 `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
146 `challenge_id` bigint(20) NOT NULL,
147 PRIMARY KEY (`id`),
148 KEY `fk_IPAY_MANDATE_IPAY_IDENTITY_idx` (`challenge_id`),
149 CONSTRAINT `fk_IPAY_MANDATE_IPAY_IDENTITY` FOREIGN KEY (`challenge_id`) REFERENCES `ipay_identity` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
150) ENGINE=InnoDB DEFAULT CHARSET=latin1;
151/*!40101 SET character_set_client = @saved_cs_client */;
152
153--
154-- Table structure for table `ipay_settings`
155--
156
157DROP TABLE IF EXISTS `ipay_settings`;
158/*!40101 SET @saved_cs_client = @@character_set_client */;
159/*!40101 SET character_set_client = utf8 */;
160CREATE TABLE `ipay_settings` (
161 `id` int(11) NOT NULL,
162 `settings_key` varchar(45) DEFAULT NULL,
163 `settings_value` varchar(45) DEFAULT NULL,
164 PRIMARY KEY (`id`)
165) ENGINE=InnoDB DEFAULT CHARSET=latin1;
166/*!40101 SET character_set_client = @saved_cs_client */;
167
168--
169-- Table structure for table `ipay_transaction`
170--
171
172DROP TABLE IF EXISTS `ipay_transaction`;
173/*!40101 SET @saved_cs_client = @@character_set_client */;
174/*!40101 SET character_set_client = utf8 */;
175CREATE TABLE `ipay_transaction` (
176 `id` bigint(20) NOT NULL,
177 `amount` decimal(19,2) DEFAULT NULL,
178 `payee_account_no` varchar(30) DEFAULT NULL,
179 `payee_bank` varchar(10) DEFAULT NULL,
180 `payee_name` varchar(255) DEFAULT NULL,
181 `payer_account_no` varchar(30) NOT NULL,
182 `payer_bank` varchar(10) NOT NULL,
183 `payer_name` varchar(255) NOT NULL,
184 `request_type` varchar(20) NOT NULL,
185 `status` varchar(10) DEFAULT 'PENDING',
186 `transactionid` bigint(20) NOT NULL,
187 `created_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
188 `created_user` varchar(45) NOT NULL,
189 `utility_merchant_id` varchar(45) DEFAULT NULL,
190 `utility_provider_id` varchar(45) DEFAULT NULL,
191 `utility_account_no` varchar(45) DEFAULT NULL,
192 `currency` varchar(45) DEFAULT NULL,
193 `utility_req_type` varchar(45) DEFAULT NULL,
194 `utility_token` varchar(1000) DEFAULT NULL,
195 `utility_channel` varchar(45) DEFAULT NULL,
196 `ceft_stan` varchar(45) DEFAULT NULL,
197 `ceft_ret_ref` varchar(45) DEFAULT NULL,
198 `ceft_txn_datetime` varchar(45) DEFAULT NULL,
199 `reference1` varchar(45) DEFAULT NULL,
200 `reference2` varchar(45) DEFAULT NULL,
201 `reference3` varchar(45) DEFAULT NULL,
202 `reference4` varchar(45) DEFAULT NULL,
203 `txn_currency_type` varchar(45) DEFAULT NULL,
204 PRIMARY KEY (`id`)
205) ENGINE=InnoDB DEFAULT CHARSET=latin1;
206/*!40101 SET character_set_client = @saved_cs_client */;
207/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
208
209/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
210/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
211/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
212/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
213/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
214/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
215/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
216
217-- Dump completed on 2019-02-20 15:21:53