All Downloads are FREE. Search and download functionalities are using the official Maven repository.
Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $
You can buy this project and download/modify it how often you want.
sql.payments-mysql.sql Maven / Gradle / Ivy
create table credit_card_transaction (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
created_on timestamp,
created_by bigint(20),
state varchar(16) DEFAULT 'INITIAL',
amount int(11),
organization_key int(11),
recurring_schedule_key int(11),
schedule_iteration int(11),
merchant_account_key int(11),
unique_id varchar(255),
third_party_vault tinyint(1) default false,
ref_authorize_returned_id varchar(255),
token varchar(255),
order_id int(11),
description varchar(255),
authorize_started timestamp,
authorize_completed timestamp,
capture_started timestamp,
capture_completed timestamp,
vault_started timestamp,
vault_completed timestamp,
credit_card_brand varchar(16),
credit_card_number_masked varchar(20),
expiration_month int(11),
expiration_year int(11),
vault_returned_id varchar(255),
vault_response text,
authorize_returned_id varchar(255),
authorize_response text,
capture_returned_id varchar(255),
capture_response text,
result varchar(20),
result_message text
);
CREATE TABLE merchant_account (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
created_on timestamp,
created_by bigint(20),
name varchar(255),
provider varchar(255),
token varchar(255),
type varchar(16),
third_party_vault tinyint(1) default false,
hidden tinyint(1),
credentials text
);
ALTER TABLE merchant_account ADD COLUMN organization_key int(11);
