Guest User

create table sql

a guest
Oct 9th, 2020
154
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `payments_credit_card` (
  2. `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  3. `payment_id` int(20) unsigned DEFAULT NULL,
  4. `transaction_id` varchar(128) DEFAULT NULL,
  5. `ref_transaction_id` varchar(128) DEFAULT NULL,
  6. `auth_code` varchar(16) DEFAULT NULL,
  7. `response_message` varchar(128) DEFAULT NULL,
  8. `gateway_extra_id` varchar(128) DEFAULT NULL,
  9. `first` varchar(128) DEFAULT NULL,
  10. `last` varchar(128) DEFAULT NULL,
  11. `address` varchar(128) DEFAULT NULL,
  12. `address2` varchar(128) DEFAULT NULL,
  13. `city` varchar(128) DEFAULT NULL,
  14. `state_province` char(64) DEFAULT NULL,
  15. `postal_code` varchar(18) DEFAULT NULL,
  16. `country_code` char(2) DEFAULT NULL,
  17. `card_number` varchar(20) DEFAULT NULL,
  18. `card_type` varchar(10) DEFAULT NULL,
  19. `card_exp_date` char(4) DEFAULT NULL,
  20. `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  21. `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  22. `response_code` int(11) DEFAULT NULL,
  23. PRIMARY KEY (`id`),
  24. KEY `auth_code` (`auth_code`),
  25. KEY `card_number` (`card_number`),
  26. KEY `ref_transaction_id` (`ref_transaction_id`),
  27. KEY `first` (`first`),
  28. KEY `last` (`last`),
  29. KEY `payment_id` (`payment_id`),
  30. KEY `transaction_id` (`transaction_id`)
  31. ) ENGINE=InnoDB AUTO_INCREMENT=477148 DEFAULT CHARSET=latin1
  32.  
  33. CREATE TABLE `gateway_fees_stripe` (
  34. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  35. `fee_id` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  36. `organization_id` int(11) NOT NULL,
  37. `transaction_id` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  38. `amount` decimal(8,2) NOT NULL,
  39. `fee_type` enum('fee','refund') COLLATE utf8_unicode_ci NOT NULL,
  40. `amount_refunded` decimal(8,2) NOT NULL,
  41. `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  42. `deleted_at` timestamp NULL DEFAULT NULL,
  43. `date_charged` datetime NOT NULL,
  44. `created_at` timestamp NULL DEFAULT NULL,
  45. `updated_at` timestamp NULL DEFAULT NULL,
  46. `ref_transaction_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  47. `processing_fee_bp` int(11) DEFAULT NULL,
  48. `surcharge_fee` decimal(5,2) DEFAULT '0.00',
  49. `gateway_stripe_id` int(11) NOT NULL,
  50. PRIMARY KEY (`id`),
  51. KEY `fee_id` (`fee_id`),
  52. KEY `organization_id` (`organization_id`),
  53. KEY `transaction_id` (`transaction_id`),
  54. KEY `date_charged` (`date_charged`),
  55. KEY `ref_tx_id` (`ref_transaction_id`),
  56. KEY `fee_type` (`fee_type`),
  57. KEY `gateway_stripe_id` (`gateway_stripe_id`),
  58. KEY `organization_id_2` (`organization_id`,`transaction_id`)
  59. ) ENGINE=InnoDB AUTO_INCREMENT=21799 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
  60.  
RAW Paste Data