This repository has been archived by the owner on Oct 12, 2019. It is now read-only.
/
ddl.sql
75 lines (73 loc) · 3.13 KB
/
ddl.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
CREATE TABLE `securenet_payment_methods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kb_payment_method_id` varchar(255) DEFAULT NULL,
`token` varchar(255) DEFAULT NULL,
`cc_first_name` varchar(255) DEFAULT NULL,
`cc_last_name` varchar(255) DEFAULT NULL,
`cc_type` varchar(255) DEFAULT NULL,
`cc_exp_month` varchar(255) DEFAULT NULL,
`cc_exp_year` varchar(255) DEFAULT NULL,
`cc_number` varchar(255) DEFAULT NULL,
`cc_last_4` varchar(255) DEFAULT NULL,
`cc_start_month` varchar(255) DEFAULT NULL,
`cc_start_year` varchar(255) DEFAULT NULL,
`cc_issue_number` varchar(255) DEFAULT NULL,
`cc_verification_value` varchar(255) DEFAULT NULL,
`cc_track_data` varchar(255) DEFAULT NULL,
`address1` varchar(255) DEFAULT NULL,
`address2` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`zip` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`is_deleted` tinyint(1) NOT NULL DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`kb_account_id` varchar(255) DEFAULT NULL,
`kb_tenant_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_securenet_payment_methods_on_kb_account_id` (`kb_account_id`),
KEY `index_securenet_payment_methods_on_kb_payment_method_id` (`kb_payment_method_id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE `securenet_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`securenet_response_id` int(11) NOT NULL,
`api_call` varchar(255) NOT NULL,
`kb_payment_id` varchar(255) NOT NULL,
`kb_payment_transaction_id` varchar(255) NOT NULL,
`transaction_type` varchar(255) NOT NULL,
`payment_processor_account_id` varchar(255) DEFAULT NULL,
`txn_id` varchar(255) DEFAULT NULL,
`amount_in_cents` int(11) DEFAULT NULL,
`currency` varchar(255) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`kb_account_id` varchar(255) NOT NULL,
`kb_tenant_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_securenet_transactions_on_kb_payment_id` (`kb_payment_id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
CREATE TABLE `securenet_responses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`api_call` varchar(255) NOT NULL,
`kb_payment_id` varchar(255) DEFAULT NULL,
`kb_payment_transaction_id` varchar(255) DEFAULT NULL,
`transaction_type` varchar(255) DEFAULT NULL,
`payment_processor_account_id` varchar(255) DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`authorization` varchar(255) DEFAULT NULL,
`fraud_review` tinyint(1) DEFAULT NULL,
`test` tinyint(1) DEFAULT NULL,
`avs_result_code` varchar(255) DEFAULT NULL,
`avs_result_message` varchar(255) DEFAULT NULL,
`avs_result_street_match` varchar(255) DEFAULT NULL,
`avs_result_postal_match` varchar(255) DEFAULT NULL,
`cvv_result_code` varchar(255) DEFAULT NULL,
`cvv_result_message` varchar(255) DEFAULT NULL,
`success` tinyint(1) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`kb_account_id` varchar(255) DEFAULT NULL,
`kb_tenant_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;