basic stripe table scheme

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 ;

much better

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