basic stripe table scheme

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 ;