mysql_upgrade_zencart_114_to_120.sql

Zen Cart是真正的电子商务艺术

  payment_type int(11) NOT NULL default '0',
  payment_status int(11) NOT NULL default '0',
  pending_reason int(11) default NULL,
  invoice varchar(64) default NULL,
  mc_currency int(11) NOT NULL default '1',
  first_name varchar(32) NOT NULL default '',
  last_name varchar(32) NOT NULL default '',
  payer_business_name varchar(32) default NULL,
  address_name varchar(32) NOT NULL default '',
  address_street varchar(64) NOT NULL default '',
  address_city varchar(32) NOT NULL default '',
  address_state varchar(32) NOT NULL default '',
  address_zip varchar(64) NOT NULL default '',
  address_country varchar(32) NOT NULL default '',
  address_status varchar(64) NOT NULL default '',
  address_owner varchar(64) NOT NULL default '0',
  payer_email varchar(96) NOT NULL default '',
  ebay_address_id varchar(96) default NULL,
  payer_id varchar(32) NOT NULL default '',
  payer_status varchar(32) NOT NULL default '',
  payment_date varchar(32) NOT NULL default '',
  business varchar(32) NOT NULL default '',
  receiver_email varchar(96) NOT NULL default '',
  receiver_id varchar(32) NOT NULL default '',
  paypal_address_id varchar(64) NOT NULL default '',
  txn_id varchar(17) NOT NULL default '',
  notify_version varchar(17) NOT NULL default '',
  verify_sign varchar(64) NOT NULL default '',
  date_added datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (paypal_ipn_id,txn_id),
  KEY idx_paypal_ipn_paypal_ipn_id (paypal_ipn_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_address_status (
  address_status_id int(11) NOT NULL auto_increment,
  language_id int(11) NOT NULL default '1',
  address_status_name varchar(64) NOT NULL default '',
  PRIMARY KEY  (address_status_id,language_id)
) TYPE=MyISAM;

INSERT INTO paypal_ipn_address_status VALUES (1, 1, 'confirmed');
INSERT INTO paypal_ipn_address_status VALUES (1, 2, 'confirmed');
INSERT INTO paypal_ipn_address_status VALUES (1, 3, 'confirmed');
INSERT INTO paypal_ipn_address_status VALUES (2, 1, 'unconfirmed');
INSERT INTO paypal_ipn_address_status VALUES (2, 2, 'unconfirmed');
INSERT INTO paypal_ipn_address_status VALUES (2, 3, 'unconfirmed');


CREATE TABLE paypal_ipn_mc_currency (
  mc_currency_id int(11) NOT NULL auto_increment,
  language_id int(11) NOT NULL default '1',
  mc_currency_name varchar(64) NOT NULL default '',
  PRIMARY KEY  (mc_currency_id,language_id)
) TYPE=MyISAM;

INSERT INTO paypal_ipn_mc_currency VALUES (1, 1, 'USD');
INSERT INTO paypal_ipn_mc_currency VALUES (1, 2, 'USD');
INSERT INTO paypal_ipn_mc_currency VALUES (1, 3, 'USD');
INSERT INTO paypal_ipn_mc_currency VALUES (2, 1, 'GBP');
INSERT INTO paypal_ipn_mc_currency VALUES (2, 2, 'GBP');
INSERT INTO paypal_ipn_mc_currency VALUES (2, 3, 'GBP');
INSERT INTO paypal_ipn_mc_currency VALUES (3, 1, 'EUR');
INSERT INTO paypal_ipn_mc_currency VALUES (3, 2, 'EUR');
INSERT INTO paypal_ipn_mc_currency VALUES (3, 3, 'EUR');
INSERT INTO paypal_ipn_mc_currency VALUES (4, 1, 'CAD');
INSERT INTO paypal_ipn_mc_currency VALUES (4, 2, 'CAD');
INSERT INTO paypal_ipn_mc_currency VALUES (4, 3, 'CAD');
INSERT INTO paypal_ipn_mc_currency VALUES (5, 1, 'JPY');
INSERT INTO paypal_ipn_mc_currency VALUES (5, 2, 'JPY');
INSERT INTO paypal_ipn_mc_currency VALUES (5, 3, 'JPY');


CREATE TABLE paypal_ipn_orders (
  paypal_ipn_orders_id int(11) NOT NULL auto_increment,
  paypal_ipn_id int(11) NOT NULL default '0',
  num_cart_items tinyint(4) NOT NULL default '0',
  mc_gross decimal(7,2) NOT NULL default '0.00',
  mc_fee decimal(7,2) NOT NULL default '0.00',
  payment_gross decimal(7,2) NOT NULL default '0.00',
  payment_fee decimal(7,2) NOT NULL default '0.00',
  settle_amount decimal(7,2) NOT NULL default '0.00',
  settle_currency decimal(7,2) NOT NULL default '0.00',
  exchange_rate decimal(7,2) default '0.00',
  PRIMARY KEY  (paypal_ipn_orders_id,paypal_ipn_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_orders_memo (
  orders_memo_id int(11) NOT NULL auto_increment,
  paypal_ipn_id int(11) NOT NULL default '1',
  memo text,
  PRIMARY KEY  (orders_memo_id,paypal_ipn_id)
) TYPE=MyISAM;

CREATE TABLE paypal_ipn_payment_status (
  payment_status_id int(11) NOT NULL auto_increment,
  language_id int(11) NOT NULL default '1',
  payment_status_name varchar(64) NOT NULL default '',
  PRIMARY KEY  (payment_status_id,language_id)
) TYPE=MyISAM;

INSERT INTO paypal_ipn_payment_status VALUES (1, 1, 'Completed');
INSERT INTO paypal_ipn_payment_status VALUES (1, 2, 'Completed');
INSERT INTO paypal_ipn_payment_status VALUES (1, 3, 'Completed');
INSERT INTO paypal_ipn_payment_status VALUES (2, 1, 'Pending');
INSERT INTO paypal_ipn_payment_status VALUES (2, 2, 'Pending');
INSERT INTO paypal_ipn_payment_status VALUES (2, 3, 'Pending');
INSERT INTO paypal_ipn_payment_status VALUES (3, 1, 'Failed');
INSERT INTO paypal_ipn_payment_status VALUES (3, 2, 'Failed');
INSERT INTO paypal_ipn_payment_status VALUES (3, 3, 'Failed');
INSERT INTO paypal_ipn_payment_status VALUES (4, 1, 'Denied');
INSERT INTO paypal_ipn_payment_status VALUES (4, 2, 'Denied');
INSERT INTO paypal_ipn_payment_status VALUES (4, 3, 'Denied');
INSERT INTO paypal_ipn_payment_status VALUES (5, 1, 'Refunded');
INSERT INTO paypal_ipn_payment_status VALUES (5, 2, 'Refunded');
INSERT INTO paypal_ipn_payment_status VALUES (5, 3, 'Refunded');
INSERT INTO paypal_ipn_payment_status VALUES (6, 1, 'Cancelled');
INSERT INTO paypal_ipn_payment_status VALUES (6, 2, 'Cancelled');
INSERT INTO paypal_ipn_payment_status VALUES (6, 3, 'Cancelled');


CREATE TABLE paypal_ipn_payment_type (