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,
`chargeid` varchar(100) NOT NULL,
`invoiceid` varchar(20) NOT NULL,
`type` varchar(10) 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,
`refundurl` varchar(200) NOT NULL,
`transctionid` int(11) NOT NULL,
`object` varchar(15) NOT NULL,
`amount` int(11) NOT NULL,
`amount_refunded` int(11) NOT NULL,
`application` varchar(100) NOT NULL,
`application_fee` int(11) NOT NULL,
`balance_transaction` varchar(100) NOT NULL,
`captured` int(1) NOT NULL,
`created` varchar(50) NOT NULL,
`currency` varchar(6) NOT NULL,
`customer` varchar(100) NOT NULL,
`description` varchar(200) NOT NULL,
`destination` varchar(100) NOT NULL,
`dispute` int(11) NOT NULL,
`failure_code` int(11) NOT NULL,
`failure_message` varchar(200) NOT NULL,
`fraud_details` varchar(200) NOT NULL,
`invoice` varchar(100) NOT NULL,
`livemode` varchar(15) NOT NULL,
`metadata` int(11) NOT NULL,
`on_behalf_of` int(11) NOT NULL,
`transaction_order` varchar(50) NOT NULL,
`outcome` int(11) NOT NULL,
`paid` varchar(10) NOT NULL,
`receipt_email` varchar(200) NOT NULL,
`receipt_number` varchar(100) NOT NULL,
`refunded` int(11) NOT NULL,
`refunds_data` varchar(100) NOT NULL,
`refunds_has_more` int(11) NOT NULL,
`refunds_total_count` int(11) NOT NULL,
`refunds_url` text NOT NULL,
`refunds` int(11) NOT NULL,
`review` int(11) NOT NULL,
`shipping` int(11) NOT NULL,
`source_id` int(11) NOT NULL,
`source_object` int(11) NOT NULL,
`source_brand` varchar(100) NOT NULL,
`source_country` varchar(100) NOT NULL,
`source_customer` int(11) NOT NULL,
`source_cvc_check` varchar(15) NOT NULL,
`source_dynamic_last4` int(11) NOT NULL,
`source_exp_month` int(11) NOT NULL,
`source_exp_year` int(11) NOT NULL,
`source_funding` varchar(100) NOT NULL,
`source_last4` int(11) NOT NULL,
`source_name` varchar(100) NOT NULL,
`source_tokenization_method` varchar(100) 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 ;
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.