Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE IF NOT EXISTS `transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`transactiontoken` varchar(200) NOT NULL,
`invoiceid` varchar(20) NOT NULL,
`itemname` varchar(100) NOT NULL,
`itemdesc` varchar(100) NOT NULL,
`itemamount` int(10) NOT NULL,
`applicationfee` varchar(11) NOT NULL,
`buyeremail` varchar(300) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`application_fee_id` varchar(100) NOT NULL,
`responsecode` varchar(50) NOT NULL,
`reponsemessage` varchar(600) NOT NULL,
`lastfour` varchar(4) NOT NULL,
`refundurl` varchar(200) NOT NULL,
`adads` int(11) NOT NULL,
`sadsadas` int(11) NOT NULL,
`transctionid` int(11) NOT NULL,
`object` int(11) NOT NULL,
`amount` int(11) NOT NULL,
`amount_refunded` int(11) NOT NULL,
`application` int(11) NOT NULL,
`application_fee` int(11) NOT NULL,
`balance_transaction` int(11) NOT NULL,
`captured` int(11) NOT NULL,
`created` int(11) NOT NULL,
`currency` varchar(6) NOT NULL,
`customer` int(11) NOT NULL,
`description` int(11) NOT NULL,
`destination` int(11) NOT NULL,
`dispute` int(11) NOT NULL,
`failure_code` int(11) NOT NULL,
`failure_message` int(11) NOT NULL,
`fraud_details` int(11) NOT NULL,
`invoice` int(11) NOT NULL,
`livemode` int(11) NOT NULL,
`metadata` int(11) NOT NULL,
`on_behalf_of` int(11) NOT NULL,
`order` int(11) NOT NULL,
`outcome` int(11) NOT NULL,
`paid` varchar(10) NOT NULL,
`receipt_email` int(11) NOT NULL,
`receipt_number` int(11) NOT NULL,
`refunded` int(11) NOT NULL,
`refunded_object` int(11) NOT NULL,
`refunded_data` int(11) NOT NULL,
`refunded_has_more` int(11) NOT NULL,
`refunded_total_count` int(11) NOT NULL,
`refunded_url` int(11) NOT NULL,
`refunds` int(11) NOT NULL,
`review` int(11) NOT NULL,
`shipping` int(11) NOT NULL,
`shipping_id` int(11) NOT NULL,
`shipping_object` int(11) NOT NULL,
`shipping_address_city` int(11) NOT NULL,
`shipping_address_country` int(11) NOT NULL,
`shipping_address_line1` int(11) NOT NULL,
`shipping_address_line1_check` int(11) NOT NULL,
`shipping_address_line2` int(11) NOT NULL,
`shipping_address_state` int(11) NOT NULL,
`shipping_address_zip` int(11) NOT NULL,
`shipping_address_zip_check` int(11) NOT NULL,
`shipping_brand` int(11) NOT NULL,
`shipping_country` int(11) NOT NULL,
`shipping_customer` int(11) NOT NULL,
`shipping_cvc_check` int(11) NOT NULL,
`shipping_dynamic_last4` int(11) NOT NULL,
`shipping_exp_month` int(11) NOT NULL,
`shipping_exp_year` int(11) NOT NULL,
`shipping_funding` int(11) NOT NULL,
`shipping_last4` int(11) NOT NULL,
`shipping_metadata` int(11) NOT NULL,
`shipping_name` int(11) NOT NULL,
`shipping_tokenization_method` int(11) NOT NULL,
`source` int(11) NOT NULL,
`source_transfer` int(11) NOT NULL,
`statement_descriptor` int(11) NOT NULL,
`status` varchar(15) NOT NULL,
`transfer_group` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
@dhiegomaga

This comment has been minimized.

Copy link
Owner Author

@dhiegomaga dhiegomaga commented Feb 19, 2017

much better

@itisnot-me

This comment has been minimized.

Copy link

@itisnot-me itisnot-me commented Feb 19, 2017

I updated the scheme types and fixed a messed up on some names. Also deleted some that didn't seem necessary. some fields are custom (some of the top ones) and need to be pushed through your scripting.

Let me know if something needs updating and i will try to keep it up to date

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.