Create a MySQL table for PayPal

CREATE TABLE IF NOT EXISTS paypal (
Date varchar(255) NOT NULL,
Time varchar(255) DEFAULT NULL,
Time_Zone varchar(255) DEFAULT NULL,
Name varchar(255) DEFAULT NULL,
Type varchar(255) DEFAULT NULL,
Status varchar(255) DEFAULT NULL,
Currency varchar(255) DEFAULT NULL,
Gross varchar(255) DEFAULT NULL,
Fee varchar(255) DEFAULT NULL,
Net varchar(255) DEFAULT NULL,
From_Email_Address varchar(255) DEFAULT NULL,
To_Email_Address varchar(255) DEFAULT NULL,
Transaction_ID varchar(255) DEFAULT NULL,
Counterparty_Status varchar(255) DEFAULT NULL,
Shipping_Address varchar(255) DEFAULT NULL,
Address_Status varchar(255) DEFAULT NULL,
Item_Title varchar(255) DEFAULT NULL,
Item_ID varchar(255) DEFAULT NULL,
Shipping_and_Handling_Amount varchar(255) DEFAULT NULL,
Insurance_Amount varchar(255) DEFAULT NULL,
Sales_Tax varchar(255) DEFAULT NULL,
Option_1_Name varchar(255) DEFAULT NULL,
Option_1_Value varchar(255) DEFAULT NULL,
Option_2_Name varchar(255) DEFAULT NULL,
Option_2_Value varchar(255) DEFAULT NULL,
Auction_Site varchar(255) DEFAULT NULL,
Buyer_ID varchar(255) DEFAULT NULL,
Item_URL varchar(255) DEFAULT NULL,
Closing_Date varchar(255) DEFAULT NULL,
Reference_Txn_ID varchar(255) DEFAULT NULL,
Invoice_Number varchar(255) DEFAULT NULL,
Custom_Number varchar(255) DEFAULT NULL,
Receipt_ID varchar(255) DEFAULT NULL,
Balance varchar(255) DEFAULT NULL,
Address_Line_1 varchar(255) DEFAULT NULL,
Address_Line_2DistrictNeighborhood varchar(255) DEFAULT NULL,
TownCity varchar(255) DEFAULT NULL,
StateProvinceRegionCountyTerritoryPrefectureRepublic varchar(255) DEFAULT NULL,
ZipPostal_Code varchar(255) DEFAULT NULL,
Country varchar(255) DEFAULT NULL,
Contact_Phone_Number varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Leave a Reply

Your email address will not be published. Required fields are marked *