· 8 years ago · Mar 09, 2018, 10:10 AM
1
2CREATE TABLE IF NOT EXISTS `ussd_menuitem` (
3 `id` bigint(20) NOT NULL AUTO_INCREMENT,
4 `finalMenu` bit(1) NOT NULL,
5 `makeServiceCallBefore` bit(1) NOT NULL,
6 `menuMessage` varchar(255) DEFAULT NULL,
7 `returnType` varchar(255) DEFAULT NULL,
8 `serviceName` varchar(255) DEFAULT NULL,
9 `serviceSection` varchar(255) DEFAULT NULL,
10 `shortCode` varchar(255) DEFAULT NULL,
11 `menuItem_id` bigint(20) DEFAULT NULL,
12 `merchantIdentifier` varchar(50) DEFAULT NULL,
13 `created` timestamp NULL DEFAULT NULL,
14 `numberOfMenus` int(11) DEFAULT NULL,
15 `modified` timestamp NULL DEFAULT NULL,
16 PRIMARY KEY (`id`),
17 KEY `FKqioic8khtcl7n6xabes4msqcl` (`menuItem_id`),
18 CONSTRAINT `FKqioic8khtcl7n6xabes4msqcl` FOREIGN KEY (`menuItem_id`) REFERENCES `ussd_menuitem` (`id`)
19) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
20
21
22REPLACE INTO `ussd_menuitem` (`id`, `finalMenu`, `makeServiceCallBefore`, `menuMessage`, `returnType`, `serviceName`, `serviceSection`, `shortCode`, `menuItem_id`, `merchantIdentifier`, `created`, `numberOfMenus`, `modified`) VALUES
23 (2, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'SELECTBANK', NULL, 3, NULL, '2017-12-02 23:13:30', NULL, NULL),
24 (3, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'ENTERACCOUNT', NULL, 10, NULL, '2017-12-02 23:13:33', NULL, NULL),
25 (4, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'PROVIDEPIN', NULL, 5, NULL, '2017-12-02 23:13:34', NULL, NULL),
26 (5, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'PROCESSTRANSACTION', NULL, 6, NULL, '2017-12-02 23:13:37', NULL, NULL),
27 (6, b'1', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'FINALANSWER', NULL, NULL, NULL, '2017-12-02 23:13:38', NULL, NULL),
28 (8, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'PROVIDEACCOUNTNUMBER', NULL, 9, NULL, '2017-12-02 23:13:42', NULL, NULL),
29 (9, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'UPDATEACCOUNTDETAILS', NULL, NULL, NULL, '2017-12-02 23:13:45', NULL, NULL),
30 (10, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'ENTERAMOUNT', NULL, 4, NULL, '2017-12-02 23:13:47', NULL, NULL),
31 (16, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'AMOUNTSTRING', NULL, 17, 'MY_NEW_CHURCH', '2017-12-05 15:23:08', NULL, NULL),
32 (17, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'AMOUNTSTRINGENTERPIN', NULL, 18, 'MY_NEW_CHURCH', '2017-12-05 20:27:12', NULL, NULL),
33 (18, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'AMOUNTSTRINGPROCESS', NULL, NULL, 'MY_NEW_CHURCH', '2017-12-05 20:28:45', NULL, NULL),
34 (23, b'0', b'1', 'This Present House Online~1. Sunday Offering~2. Tithe~3. First Fruit~4. Thanksgiving~5. Seed of Faith~6. Special Thanksgiving~7. Others~', 'STATIC', 'com.ucitech.masterussd.impl.TestImpl', NULL, '*966*789#', 2, 'THIS_PRESENT_HOUSE', '2017-12-06 00:00:00', 7, NULL),
35 (24, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'ADDACCOUNT', '*966*789*0#', 8, 'THIS_PRESENT_HOUSE', '2017-12-06 00:00:00', 0, NULL),
36 (25, b'0', b'1', 'This Present House Online~1. Sunday Offering~2. Tithe~3. First Fruit~4. Thanksgiving~5. Seed of Faith~6. Special Thanksgiving~7. Others~', 'STATIC', 'com.ucitech.masterussd.impl.TestImpl', NULL, '*966*789*ANY#', 16, 'THIS_PRESENT_HOUSE', '2017-12-06 00:00:00', 0, NULL),
37 (32, b'0', b'1', 'Welcome to RCCG~1. Offering~2. Tithe~3. Super Offering~4. Thanksgiving~5. Others~', 'STATIC', 'com.ucitech.masterussd.impl.TestImpl', NULL, '*966*2000#', 2, 'RCCG', '2018-02-28 00:00:00', 5, NULL),
38 (33, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.TestImpl', 'ADDACCOUNT', '*966*2000*0#', 8, 'RCCG', '2018-02-28 00:00:00', 0, NULL),
39 (34, b'0', b'1', 'Welcome to RCCG~1. Offering~2. Tithe~3. Super Offering~4. Thanksgiving~5. Others~', 'STATIC', 'com.ucitech.masterussd.impl.TestImpl', NULL, '*966*2000*ANY#', 16, 'RCCG', '2018-02-28 00:00:00', 0, NULL),
40 (35, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.DataImpl', 'START', '*966*6#', 36, 'ZENITH', '2018-03-02 22:32:56', 3, NULL),
41 (36, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.DataImpl', 'GETDATAORSELECTNETWORK', NULL, 37, NULL, '2018-03-02 22:43:45', NULL, NULL),
42 (37, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.DataImpl', 'ENTERPINORCHOOSENETWORK', NULL, 38, NULL, '2018-03-03 00:09:56', NULL, '2018-03-03 00:09:58'),
43 (38, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.DataImpl', 'BUYDATAORGETDATA', NULL, 39, NULL, '2018-03-03 01:12:36', NULL, NULL),
44 (39, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.DataImpl', 'GETPIN', NULL, 40, NULL, '2018-03-03 10:30:39', NULL, NULL),
45 (40, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.DataImpl', 'PROCESSTHIRDPARTY', NULL, NULL, NULL, '2018-03-03 10:30:32', NULL, '2018-03-03 10:30:34'),
46 (41, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.RevPayImpl', 'START', '*966*7#', 42, 'ZENITHREVPAY', '2018-03-05 16:43:32', 1, '2018-03-05 16:43:34'),
47 (42, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.RevPayImpl', 'ENTERPAYMENTREFERENCE', NULL, 44, 'ZENITHREVPAY', '2018-03-05 16:44:36', NULL, '2018-03-05 16:44:36'),
48 (44, b'0', b'1', NULL, 'APPLICATION', 'com.ucitech.masterussd.impl.RevPayImpl', 'TRANSACTIONCOMPLETED', NULL, NULL, 'ZENITHREVPAY', '2018-03-05 16:46:49', NULL, '2018-03-05 16:46:49');
49
50-- Dumping structure for table ussd.ussd_merchant_setup
51CREATE TABLE IF NOT EXISTS `ussd_merchant_setup` (
52 `id` bigint(20) NOT NULL AUTO_INCREMENT,
53 `created` datetime DEFAULT NULL,
54 `description` varchar(255) DEFAULT NULL,
55 `identifier` varchar(255) DEFAULT NULL,
56 `menuPosition` varchar(255) DEFAULT NULL,
57 `merchantCode` varchar(255) DEFAULT NULL,
58 `merchantIdentifier` varchar(255) DEFAULT NULL,
59 `shortCode` varchar(255) DEFAULT NULL,
60 `terminalId` varchar(255) DEFAULT NULL,
61 PRIMARY KEY (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
63
64
65REPLACE INTO `ussd_merchant_setup` (`id`, `created`, `description`, `identifier`, `menuPosition`, `merchantCode`, `merchantIdentifier`, `shortCode`, `terminalId`) VALUES
66 (3, '2017-12-05 11:39:32', 'MFM Otta USSD', '*966*123_DEFAULT', 'DEAFULT', '1278393', 'MFM_OTTA', '*966*123#', '9838833'),
67 (10, '2017-12-06 10:01:04', 'This Present House Collections', '*966*789_DEFAULT', 'DEFAULT', '23627283', 'THIS_PRESENT_HOUSE', '*966*789#', '2327ADFS7887'),
68 (11, '2017-12-06 10:02:30', 'Sunday Offering', '*966*789_1', '1', '8990488AD', 'THIS_PRESENT_HOUSE', '*966*789#', 'ERT77774863'),
69 (14, '2018-02-28 09:37:38', 'fgjbkln;end,bjyjkbd jeererer', '*966*2000_DEFAULT', 'DEFAULT', '345678909', 'RCCG', '*966*2000#', '34578798076'),
70 (15, '2018-03-05 17:20:20', 'dfdfdfdfrrerr', '*966*8_DEFAULT', 'DEFAULT', '232323', 'ZENITHREVPAY2', '*966*8#', '32323'),
71 (16, '2018-03-05 17:31:54', '34324234243', '*966*10_DEFAULT', 'DEFAULT', '65789023424', 'ZENITHREVPAY3', '*966*10#', '32434343'),
72 (17, '2018-03-05 17:32:23', 'dedede', '*488*2932_DEFAULT', 'DEFAULT', NULL, 'DEDEDED', '*488*2932#', 'dededed');
73
74
75-- Dumping structure for table ussd.ussd_subscriber
76CREATE TABLE IF NOT EXISTS `ussd_subscriber` (
77 `ID` bigint(20) NOT NULL AUTO_INCREMENT,
78 `account_no` varchar(255) DEFAULT NULL,
79 `active` bit(1) DEFAULT NULL,
80 `appcode` varchar(25) DEFAULT NULL,
81 `bank_code` varchar(255) DEFAULT NULL,
82 `created` datetime DEFAULT NULL,
83 `lastTranTime` datetime DEFAULT NULL,
84 `mobile_no` varchar(255) DEFAULT NULL,
85 `modified` datetime DEFAULT NULL,
86 PRIMARY KEY (`ID`)
87) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
88
89-- Dumping data for table ussd.ussd_subscriber: ~6 rows (approximately)
90REPLACE INTO `ussd_subscriber` (`ID`, `account_no`, `active`, `appcode`, `bank_code`, `created`, `lastTranTime`, `mobile_no`, `modified`) VALUES
91 (1, '53563636363', b'1', NULL, '058', '2017-12-01 21:24:59', NULL, '2348098753155', '2017-12-01 21:24:59'),
92 (2, '88888888888', b'1', NULL, '057', '2017-12-05 21:49:13', NULL, '2348098753152', '2017-12-05 21:49:13'),
93 (3, '242424424244', b'1', NULL, '063', '2017-12-05 22:06:23', NULL, '2348098753152', '2017-12-05 22:06:23'),
94 (4, '356673483434', b'1', NULL, '011', '2017-12-06 10:12:25', NULL, '2348098753151', '2017-12-06 10:12:25'),
95 (5, '1121212', b'1', NULL, '057', '2017-12-06 10:15:40', NULL, '2348098753151', '2017-12-06 10:15:40'),
96 (6, '0101327373', b'1', NULL, '030', '2017-12-06 10:18:53', NULL, '2348098753151', '2017-12-06 10:18:53'),
97 (7, '99999999999999', b'1', NULL, '044', '2018-02-21 17:47:22', NULL, '2348098753155', '2018-02-21 17:47:22');
98
99-- Dumping structure for table ussd.ussd_template
100CREATE TABLE IF NOT EXISTS `ussd_template` (
101 `id` bigint(20) NOT NULL,
102 `startsection` varchar(50) DEFAULT NULL,
103 `addAccountSection` varchar(50) DEFAULT NULL,
104 `templateName` varchar(50) DEFAULT NULL,
105 `templateDescription` varchar(50) DEFAULT NULL,
106 `templateClass` varchar(100) DEFAULT NULL,
107 `created` timestamp NULL DEFAULT NULL,
108 `modified` timestamp NULL DEFAULT NULL,
109 PRIMARY KEY (`id`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1;
111
112-- Dumping data for table ussd.ussd_template: ~3 rows (approximately)
113REPLACE INTO `ussd_template` (`id`, `startsection`, `addAccountSection`, `templateName`, `templateDescription`, `templateClass`, `created`, `modified`) VALUES
114 (1, 'SELECTBANK', 'ADDACCOUNT', 'CHURCH', 'This is just a test implementation', 'com.ucitech.masterussd.impl.TestImpl', '2017-12-02 23:11:23', '2017-12-02 23:11:26'),
115 (2, 'START', NULL, 'DATA', 'Data Impleentation', 'com.ucitech.masterussd.impl.DataImpl', '2018-03-05 17:15:44', '2018-03-05 17:15:44'),
116 (3, 'START', NULL, 'REVPAY', 'RevPay Implementation', 'com.ucitech.materussd.impl.DataImpl', '2018-03-05 17:16:23', '2018-03-05 17:16:24');
117
118-- Dumping structure for table ussd.ussd_transaction_log
119CREATE TABLE IF NOT EXISTS `ussd_transaction_log` (
120 `ID` bigint(20) NOT NULL AUTO_INCREMENT,
121 `action_type` varchar(255) DEFAULT NULL,
122 `amount` varchar(255) DEFAULT NULL,
123 `appid` varchar(255) DEFAULT NULL,
124 `bank_code` varchar(255) DEFAULT NULL,
125 `mobile_no` varchar(255) DEFAULT NULL,
126 `modified` datetime DEFAULT NULL,
127 `provider` varchar(255) DEFAULT NULL,
128 `response_code` varchar(255) DEFAULT NULL,
129 `response_message` varchar(255) DEFAULT NULL,
130 `short_code` varchar(255) DEFAULT NULL,
131 `trans_date` datetime DEFAULT NULL,
132 `unique_transid` varchar(255) DEFAULT NULL,
133 `user_bank_code` varchar(255) DEFAULT NULL,
134 PRIMARY KEY (`ID`)
135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136
137-- Dumping data for table ussd.ussd_transaction_log: ~0 rows (approximately)
138
139-- Dumping structure for table ussd.ussd_users
140CREATE TABLE IF NOT EXISTS `ussd_users` (
141 `ID` bigint(20) NOT NULL AUTO_INCREMENT,
142 `APPID` varchar(20) DEFAULT NULL,
143 `CREATED` datetime DEFAULT NULL,
144 `CURRENTLOGINDATE` datetime DEFAULT NULL,
145 `DOB` varchar(10) DEFAULT NULL,
146 `EMAIL` varchar(100) DEFAULT NULL,
147 `FIRSTNAME` varchar(30) DEFAULT NULL,
148 `LASTLOGINDATE` datetime DEFAULT NULL,
149 `LASTNAME` varchar(30) DEFAULT NULL,
150 `MODIFIED` datetime DEFAULT NULL,
151 `msisdn` varchar(11) DEFAULT NULL,
152 `PARENTAPPID` varchar(20) DEFAULT NULL,
153 `PASSWORD` varchar(50) DEFAULT NULL,
154 `POINTSBALANCE` int(11) DEFAULT NULL,
155 `BONUSPOINTS` int(11) DEFAULT NULL,
156 `REGISTRATIONCHANNEL` varchar(15) DEFAULT NULL,
157 `SUSPENSIONCOUNT` int(11) DEFAULT NULL,
158 `USERSTATUS` varchar(20) DEFAULT NULL,
159 `NETWORK` varchar(10) DEFAULT NULL,
160 PRIMARY KEY (`ID`),
161 UNIQUE KEY `UNQ_tbl_users_0` (`msisdn`),
162 KEY `created` (`CREATED`)
163) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
164
165REPLACE INTO `ussd_users` (`ID`, `APPID`, `CREATED`, `CURRENTLOGINDATE`, `DOB`, `EMAIL`, `FIRSTNAME`, `LASTLOGINDATE`, `LASTNAME`, `MODIFIED`, `msisdn`, `PARENTAPPID`, `PASSWORD`, `POINTSBALANCE`, `BONUSPOINTS`, `REGISTRATIONCHANNEL`, `SUSPENSIONCOUNT`, `USERSTATUS`, `NETWORK`) VALUES
166 (1, 'STAR', '2017-11-04 09:29:11', '2017-12-06 15:43:22', '4/11/2017', 'adekanmbi.oluremi@gmail.com', 'Oluremi', '2017-12-06 08:55:26', 'Adekanmbi', '2017-11-26 20:32:19', '8098753155', NULL, '8e66356a085bebee3e876f217004ed26', 890, NULL, 'WEB', 0, 'ACTIVE', NULL);