NrHYTrry

1DROP TABLE IF EXISTS `ipn_orders`;
2CREATE TABLE `ipn_orders` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `notify_version` varchar(64) DEFAULT NULL COMMENT 'IPN Version Number',
5  `verify_sign` varchar(127) DEFAULT NULL COMMENT 'Encrypted string used to verify the authenticityof the tansaction',
6  `test_ipn` int(11) DEFAULT NULL,
7  `protection_eligibility` varchar(24) DEFAULT NULL COMMENT 'Which type of seller protection the buyer is protected by',
8  `charset` varchar(127) DEFAULT NULL COMMENT 'Character set used by PayPal',
9  `btn_id` varchar(40) DEFAULT NULL COMMENT 'The PayPal buy button clicked',
10  `address_city` varchar(40) DEFAULT NULL COMMENT 'City of customers address',
11  `address_country` varchar(64) DEFAULT NULL COMMENT 'Country of customers address',
12  `address_country_code` varchar(2) DEFAULT NULL COMMENT 'Two character ISO 3166 country code',
13  `address_name` varchar(128) DEFAULT NULL COMMENT 'Name used with address (included when customer provides a Gift address)',
14  `address_state` varchar(40) DEFAULT NULL COMMENT 'State of customer address',
15  `address_status` varchar(20) DEFAULT NULL COMMENT 'confirmed/unconfirmed',
16  `address_street` varchar(200) DEFAULT NULL COMMENT 'Customer''s street address',
17  `address_zip` varchar(20) DEFAULT NULL COMMENT 'Zip code of customer''s address',
18  `first_name` varchar(64) DEFAULT NULL COMMENT 'Customer''s first name',
19  `last_name` varchar(64) DEFAULT NULL COMMENT 'Customer''s last name',
20  `payer_business_name` varchar(127) DEFAULT NULL COMMENT 'Customer''s company name, if customer represents a business',
21  `payer_email` varchar(127) DEFAULT NULL COMMENT 'Customer''s primary email address. Use this email to provide any credits',
22  `payer_id` varchar(13) DEFAULT NULL COMMENT 'Unique customer ID.',
23  `payer_status` varchar(20) DEFAULT NULL COMMENT 'verified/unverified',
24  `contact_phone` varchar(20) DEFAULT NULL COMMENT 'Customer''s telephone number.',
25  `residence_country` varchar(2) DEFAULT NULL COMMENT 'Two-Character ISO 3166 country code',
26  `business` varchar(127) DEFAULT NULL COMMENT 'Email address or account ID of the payment recipient (that is, the merchant). Equivalent to the values of receiver_email (If payment is sent to primary account) and business set in the Website Payment HTML.',
27  `receiver_email` varchar(127) DEFAULT NULL COMMENT 'Primary email address of the payment recipient (that is, the merchant). If the payment is sent to a non-primary email address on your PayPal account, the receiver_email is still your primary email.',
28  `receiver_id` varchar(13) DEFAULT NULL COMMENT 'Unique account ID of the payment recipient (i.e., the merchant). This is the same as the recipients referral ID.',
29  `custom` varchar(255) DEFAULT NULL COMMENT 'Custom value as passed by you, the merchant. These are pass-through variables that are never presented to your customer.',
30  `invoice` varchar(127) DEFAULT NULL COMMENT 'Pass through variable you can use to identify your invoice number for this purchase. If omitted, no variable is passed back.',
31  `memo` varchar(255) DEFAULT NULL COMMENT 'Memo as entered by your customer in PayPal Website Payments note field.',
32  `tax` decimal(10,2) DEFAULT NULL COMMENT 'Amount of tax charged on payment',
33  `auth_id` varchar(19) DEFAULT NULL COMMENT 'Authorization identification number',
34  `auth_exp` varchar(28) DEFAULT NULL COMMENT 'Authorization expiration date and time, in the following format: HH:MM:SS DD Mmm YY, YYYY PST',
35  `auth_amount` int(11) DEFAULT NULL COMMENT 'Authorization amount',
36  `auth_status` varchar(20) DEFAULT NULL COMMENT 'Status of authorization',
37  `num_cart_items` int(11) DEFAULT NULL COMMENT 'If this is a PayPal shopping cart transaction, number of items in the cart',
38  `parent_txn_id` varchar(19) DEFAULT NULL COMMENT 'In the case of a refund, reversal, or cancelled reversal, this variable contains the txn_id of the original transaction, while txn_id contains a new ID for the new transaction.',
39  `payment_date` varchar(28) DEFAULT NULL COMMENT 'Time/date stamp generated by PayPal, in the following format: HH:MM:SS DD Mmm YY, YYYY PST',
40  `payment_status` varchar(20) DEFAULT NULL COMMENT 'Payment status of the payment',
41  `payment_type` varchar(10) DEFAULT NULL COMMENT 'echeck/instant',
42  `pending_reason` varchar(20) DEFAULT NULL COMMENT 'This variable is only set if payment_status=pending',
43  `reason_code` varchar(20) DEFAULT NULL COMMENT 'This variable is only set if payment_status=reversed',
44  `remaining_settle` int(11) DEFAULT NULL COMMENT 'Remaining amount that can be captured with Authorization and Capture',
45  `shipping_method` varchar(64) DEFAULT NULL COMMENT 'The name of a shipping method from the shipping calculations section of the merchants account profile. The buyer selected the named shipping method for this transaction',
46  `shipping` decimal(10,2) DEFAULT NULL COMMENT 'Shipping charges associated with this transaction. Format unsigned, no currency symbol, two decimal places',
47  `transaction_entity` varchar(20) DEFAULT NULL COMMENT 'Authorization and capture transaction entity',
48  `txn_id` varchar(19) DEFAULT NULL COMMENT 'A unique transaction ID generated by PayPal',
49  `txn_type` varchar(20) DEFAULT NULL COMMENT 'cart/express_checkout/send-money/virtual-terminal/web-accept',
50  `exchange_rate` decimal(10,2) DEFAULT NULL COMMENT 'Exchange rate used if a currency conversion occured',
51  `mc_currency` varchar(3) DEFAULT NULL COMMENT 'Three character country code. For payment IPN notifications, this is the currency of the payment, for non-payment subscription IPN notifications, this is the currency of the subscription.',
52  `mc_fee` decimal(10,2) DEFAULT NULL COMMENT 'Transaction fee associated with the payment, mc_gross minus mc_fee equals the amount deposited into the receiver_email account. Equivalent to payment_fee for USD payments. If this amount is negative, it signifies a refund or reversal, and either ofthose p',
53  `mc_gross` decimal(10,2) DEFAULT NULL COMMENT 'Full amount of the customer''s payment',
54  `mc_handling` text DEFAULT NULL COMMENT 'Total handling charge associated with the transaction',
55  `mc_shipping` text DEFAULT NULL COMMENT 'Total handling charge associated with the transaction',
56  `payment_fee` decimal(10,2) DEFAULT NULL COMMENT 'USD transaction fee associated with the payment',
57  `payment_gross` decimal(10,2) DEFAULT NULL COMMENT 'Full USD amount of the customers payment transaction, before payment_fee is subtracted',
58  `settle_amount` decimal(10,2) DEFAULT NULL COMMENT 'Amount that is deposited into the account''s primary balance after a currency conversion',
59  `settle_currency` varchar(3) DEFAULT NULL COMMENT 'Currency of settle amount. Three digit currency code',
60  `auction_buyer_id` varchar(64) DEFAULT NULL COMMENT 'The customer''s auction ID.',
61  `auction_closing_date` varchar(28) DEFAULT NULL COMMENT 'The auction''s close date. In the format: HH:MM:SS DD Mmm YY, YYYY PSD',
62  `auction_multi_item` int(11) DEFAULT NULL COMMENT 'The number of items purchased in multi-item auction payments',
63  `for_auction` varchar(10) DEFAULT NULL COMMENT 'This is an auction payment - payments made using Pay for eBay Items or Smart Logos - as well as send money/money request payments with the type eBay items or Auction Goods(non-eBay)',
64  `subscr_date` varchar(28) DEFAULT NULL COMMENT 'Start date or cancellation date depending on whether txn_type is subcr_signup or subscr_cancel',
65  `subscr_effective` varchar(28) DEFAULT NULL COMMENT 'Date when a subscription modification becomes effective',
66  `period1` varchar(10) DEFAULT NULL COMMENT '(Optional) Trial subscription interval in days, weeks, months, years (example a 4 day interval is 4 D',
67  `period2` varchar(10) DEFAULT NULL COMMENT '(Optional) Trial period',
68  `period3` varchar(10) DEFAULT NULL COMMENT 'Regular subscription interval in days, weeks, months, years',
69  `amount1` decimal(10,2) DEFAULT NULL COMMENT 'Amount of payment for Trial period 1 for USD',
70  `amount2` decimal(10,2) DEFAULT NULL COMMENT 'Amount of payment for Trial period 2 for USD',
71  `amount3` decimal(10,2) DEFAULT NULL COMMENT 'Amount of payment for regular subscription  period 1 for USD',
72  `mc_amount1` decimal(10,2) DEFAULT NULL COMMENT 'Amount of payment for trial period 1 regardless of currency',
73  `mc_amount2` decimal(10,2) DEFAULT NULL COMMENT 'Amount of payment for trial period 2 regardless of currency',
74  `mc_amount3` decimal(10,2) DEFAULT NULL COMMENT 'Amount of payment for regular subscription period regardless of currency',
75  `recurring` varchar(1) DEFAULT NULL COMMENT 'Indicates whether rate recurs (1 is yes, blank is no)',
76  `reattempt` varchar(1) DEFAULT NULL COMMENT 'Indicates whether reattempts should occur on payment failure (1 is yes, blank is no)',
77  `retry_at` varchar(28) DEFAULT NULL COMMENT 'Date PayPal will retry a failed subscription payment',
78  `recur_times` int(11) DEFAULT NULL COMMENT 'The number of payment installations that will occur at the regular rate',
79  `username` varchar(64) DEFAULT NULL COMMENT '(Optional) Username generated by PayPal and given to subscriber to access the subscription',
80  `password` varchar(24) DEFAULT NULL COMMENT '(Optional) Password generated by PayPal and given to subscriber to access the subscription (Encrypted)',
81  `subscr_id` varchar(19) DEFAULT NULL COMMENT 'ID generated by PayPal for the subscriber',
82  `case_id` varchar(28) DEFAULT NULL COMMENT 'Case identification number',
83  `case_type` varchar(28) DEFAULT NULL COMMENT 'complaint/chargeback',
84  `case_creation_date` varchar(28) DEFAULT NULL COMMENT 'Date/Time the case was registered',
85  `order_status` enum('PAID','WAITING','REJECTED') DEFAULT NULL COMMENT 'Additional variable to make payment_status more actionable',
86  `discount` decimal(10,2) DEFAULT NULL COMMENT 'Additional variable to record the discount made on the order',
87  `shipping_discount` decimal(10,2) DEFAULT NULL COMMENT 'Record the discount made on the shipping',
88  `ipn_track_id` varchar(127) DEFAULT NULL COMMENT 'Internal tracking variable added in April 2011',
89  `transaction_subject` varchar(255) DEFAULT NULL COMMENT 'Describes the product for a button-based purchase',
90  `created_at` datetime NOT NULL,
91  `updated_at` datetime NOT NULL,
92  PRIMARY KEY (`id`),
93  UNIQUE KEY `UniqueTransactionID` (`txn_id`)
94) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
95LOCK TABLES `ipn_orders` WRITE;
96INSERT INTO `ipn_orders` (`id`, `notify_version`, `verify_sign`, `test_ipn`, `protection_eligibility`, `charset`, `btn_id`, `address_city`, `address_country`, `address_country_code`, `address_name`, `address_state`, `address_status`, `address_street`, `address_zip`, `first_name`, `last_name`, `payer_business_name`, `payer_email`, `payer_id`, `payer_status`, `contact_phone`, `residence_country`, `business`, `receiver_email`, `receiver_id`, `custom`, `invoice`, `memo`, `tax`, `auth_id`, `auth_exp`, `auth_amount`, `auth_status`, `num_cart_items`, `parent_txn_id`, `payment_date`, `payment_status`, `payment_type`, `pending_reason`, `reason_code`, `remaining_settle`, `shipping_method`, `shipping`, `transaction_entity`, `txn_id`, `txn_type`, `exchange_rate`, `mc_currency`, `mc_fee`, `mc_gross`, `mc_handling`, `mc_shipping`, `payment_fee`, `payment_gross`, `settle_amount`, `settle_currency`, `auction_buyer_id`, `auction_closing_date`, `auction_multi_item`, `for_auction`, `subscr_date`, `subscr_effective`, `period1`, `period2`, `period3`, `amount1`, `amount2`, `amount3`, `mc_amount1`, `mc_amount2`, `mc_amount3`, `recurring`, `reattempt`, `retry_at`, `recur_times`, `username`, `password`, `subscr_id`, `case_id`, `case_type`, `case_creation_date`, `order_status`, `discount`, `shipping_discount`, `ipn_track_id`, `transaction_subject`, `created_at`, `updated_at`) VALUES ('1', '2.1', 'AFcWxV21C7fd0v3bYYYRCpSSRl31ATx2WjsDTb8wgyTQycCFpmVpjHgQ', '1', '', '', '', 'San Jose', 'United States', 'US', 'John Smith', 'CA', 'confirmed', '123, any street', '95131', 'John', 'Smith', '', 'buyer@paypalsandbox.com', 'TESTBUYERID01', 'verified', '', 'US', 'huia61@yahoo.com', 'huia61@yahoo.com', 'huia61@yahoo.', 'xyz123', 'abc1234', '', '2.02', '', '', '', '', '', '', '00:21:05 17 Jun 2014 PDT', 'Completed', 'instant', '', '', '', '', '3.04', '', '113936691', 'web_accept', '', 'USD', '0.44', '12.34', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'PAID', '0.00', '', '', '', '2014-06-17 10:12:39', '2014-06-17 10:12:39');
97INSERT INTO `ipn_orders` (`id`, `notify_version`, `verify_sign`, `test_ipn`, `protection_eligibility`, `charset`, `btn_id`, `address_city`, `address_country`, `address_country_code`, `address_name`, `address_state`, `address_status`, `address_street`, `address_zip`, `first_name`, `last_name`, `payer_business_name`, `payer_email`, `payer_id`, `payer_status`, `contact_phone`, `residence_country`, `business`, `receiver_email`, `receiver_id`, `custom`, `invoice`, `memo`, `tax`, `auth_id`, `auth_exp`, `auth_amount`, `auth_status`, `num_cart_items`, `parent_txn_id`, `payment_date`, `payment_status`, `payment_type`, `pending_reason`, `reason_code`, `remaining_settle`, `shipping_method`, `shipping`, `transaction_entity`, `txn_id`, `txn_type`, `exchange_rate`, `mc_currency`, `mc_fee`, `mc_gross`, `mc_handling`, `mc_shipping`, `payment_fee`, `payment_gross`, `settle_amount`, `settle_currency`, `auction_buyer_id`, `auction_closing_date`, `auction_multi_item`, `for_auction`, `subscr_date`, `subscr_effective`, `period1`, `period2`, `period3`, `amount1`, `amount2`, `amount3`, `mc_amount1`, `mc_amount2`, `mc_amount3`, `recurring`, `reattempt`, `retry_at`, `recur_times`, `username`, `password`, `subscr_id`, `case_id`, `case_type`, `case_creation_date`, `order_status`, `discount`, `shipping_discount`, `ipn_track_id`, `transaction_subject`, `created_at`, `updated_at`) VALUES ('2', '2.1', 'AJyBW3eg1ptKiBTozVbOYhM7-4CvAtZ-cWs8uNRxDmMtP94Xl6e8GT4D', '1', '', '', '', 'San Jose', 'United States', 'US', 'John Smith', 'CA', 'confirmed', '123, any street', '95131', 'John', 'Smith', '', 'buyer@paypalsandbox.com', 'TESTBUYERID01', 'verified', '', 'US', 'huia61@yahoo.com', 'huia61@yahoo.com', 'huia61@yahoo.', 'xyz123', 'abc1234', '', '2.02', '', '', '', '', '', '', '01:08:34 17 Jun 2014 PDT', 'Completed', 'instant', '', '', '', '', '3.04', '', '272765216', 'web_accept', '', 'USD', '0.44', '12.34', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'PAID', '0.00', '', '', '', '2014-06-17 10:59:40', '2014-06-17 10:59:40');
98INSERT INTO `ipn_orders` (`id`, `notify_version`, `verify_sign`, `test_ipn`, `protection_eligibility`, `charset`, `btn_id`, `address_city`, `address_country`, `address_country_code`, `address_name`, `address_state`, `address_status`, `address_street`, `address_zip`, `first_name`, `last_name`, `payer_business_name`, `payer_email`, `payer_id`, `payer_status`, `contact_phone`, `residence_country`, `business`, `receiver_email`, `receiver_id`, `custom`, `invoice`, `memo`, `tax`, `auth_id`, `auth_exp`, `auth_amount`, `auth_status`, `num_cart_items`, `parent_txn_id`, `payment_date`, `payment_status`, `payment_type`, `pending_reason`, `reason_code`, `remaining_settle`, `shipping_method`, `shipping`, `transaction_entity`, `txn_id`, `txn_type`, `exchange_rate`, `mc_currency`, `mc_fee`, `mc_gross`, `mc_handling`, `mc_shipping`, `payment_fee`, `payment_gross`, `settle_amount`, `settle_currency`, `auction_buyer_id`, `auction_closing_date`, `auction_multi_item`, `for_auction`, `subscr_date`, `subscr_effective`, `period1`, `period2`, `period3`, `amount1`, `amount2`, `amount3`, `mc_amount1`, `mc_amount2`, `mc_amount3`, `recurring`, `reattempt`, `retry_at`, `recur_times`, `username`, `password`, `subscr_id`, `case_id`, `case_type`, `case_creation_date`, `order_status`, `discount`, `shipping_discount`, `ipn_track_id`, `transaction_subject`, `created_at`, `updated_at`) VALUES ('3', '2.1', 'A30VDADn3j14YwA3Pgcy1kUXF2ZXAfbL504rQPqH85qMSfmarMo61UxD', '1', '', '', '', 'San Jose', 'United States', 'US', 'John Smith', 'CA', 'confirmed', '123, any street', '95131', 'John', 'Smith', '', 'buyer@paypalsandbox.com', 'TESTBUYERID01', 'verified', '', 'US', 'huia61@yahoo.com', 'huia61@yahoo.com', 'huia61@yahoo.', 'xyz123', 'abc1234', '', '2.02', '', '', '', '', '', '', '01:11:51 17 Jun 2014 PDT', 'Completed', 'instant', '', '', '', '', '3.04', '', '114930481', 'web_accept', '', 'USD', '0.44', '12.34', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'PAID', '0.00', '', '', '', '2014-06-17 11:03:05', '2014-06-17 11:03:05');
99UNLOCK TABLES;