sql.payments-mysql.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of platform Show documentation
Show all versions of platform Show documentation
A standard set of utilities that makes it easy to build systems that need users, billing, etc giving the usefulness of a PaaS with the control of a local application
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);