Changeset 980
- Timestamp:
- 08/26/08 09:50:35 (3 months ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/DataBase/mysql-5.x/a2billing-mysql-schema-MYSQL.5.X-v1.3.0-NDBCLUSTER.sql
r959 r980 96 96 CREATE TABLE cc_paypal ( 97 97 id INT (11) NOT NULL AUTO_INCREMENT, 98 payer_id VARCHAR( 60) DEFAULT NULL,99 payment_date VARCHAR( 50) DEFAULT NULL,100 txn_id VARCHAR( 50) DEFAULT NULL,101 first_name VARCHAR( 50) DEFAULT NULL,102 last_name VARCHAR( 50) DEFAULT NULL,103 payer_email VARCHAR( 75) DEFAULT NULL,104 payer_status VARCHAR( 50) DEFAULT NULL,105 payment_type VARCHAR( 50) DEFAULT NULL,98 payer_id VARCHAR(50) DEFAULT NULL, 99 payment_date VARCHAR(30) DEFAULT NULL, 100 txn_id VARCHAR(30) DEFAULT NULL, 101 first_name VARCHAR(40) DEFAULT NULL, 102 last_name VARCHAR(40) DEFAULT NULL, 103 payer_email VARCHAR(55) DEFAULT NULL, 104 payer_status VARCHAR(30) DEFAULT NULL, 105 payment_type VARCHAR(30) DEFAULT NULL, 106 106 memo TINYTEXT, 107 item_name VARCHAR( 127) DEFAULT NULL,108 item_number VARCHAR( 127) DEFAULT NULL,107 item_name VARCHAR(70) DEFAULT NULL, 108 item_number VARCHAR(70) DEFAULT NULL, 109 109 quantity INT (11) NOT NULL DEFAULT '0', 110 110 mc_gross DECIMAL(9,2) DEFAULT NULL, … … 112 112 tax DECIMAL(9,2) DEFAULT NULL, 113 113 mc_currency CHAR(3) DEFAULT NULL, 114 address_name VARCHAR( 255) NOT NULL DEFAULT '',115 address_street VARCHAR( 255) NOT NULL DEFAULT '',116 address_city VARCHAR( 255) NOT NULL DEFAULT '',117 address_state VARCHAR( 255) NOT NULL DEFAULT '',118 address_zip VARCHAR(2 55) NOT NULL DEFAULT '',119 address_country VARCHAR( 255) NOT NULL DEFAULT '',120 address_status VARCHAR( 255) NOT NULL DEFAULT '',121 payer_business_name VARCHAR( 255) NOT NULL DEFAULT '',122 payment_status VARCHAR( 255) NOT NULL DEFAULT '',123 pending_reason VARCHAR( 255) NOT NULL DEFAULT '',124 reason_code VARCHAR( 255) NOT NULL DEFAULT '',125 txn_type VARCHAR( 255) NOT NULL DEFAULT '',114 address_name VARCHAR(50) NOT NULL DEFAULT '', 115 address_street VARCHAR(80) NOT NULL DEFAULT '', 116 address_city VARCHAR(40) NOT NULL DEFAULT '', 117 address_state VARCHAR(40) NOT NULL DEFAULT '', 118 address_zip VARCHAR(20) NOT NULL DEFAULT '', 119 address_country VARCHAR(30) NOT NULL DEFAULT '', 120 address_status VARCHAR(30) NOT NULL DEFAULT '', 121 payer_business_name VARCHAR(40) NOT NULL DEFAULT '', 122 payment_status VARCHAR(30) NOT NULL DEFAULT '', 123 pending_reason VARCHAR(50) NOT NULL DEFAULT '', 124 reason_code VARCHAR(30) NOT NULL DEFAULT '', 125 txn_type VARCHAR(30) NOT NULL DEFAULT '', 126 126 PRIMARY KEY (id), 127 127 UNIQUE KEY txn_id (txn_id), trunk/DataBase/mysql-5.x/a2billing-mysql-schema-MYSQL.5.X-v1.3.0.sql
r880 r980 96 96 CREATE TABLE cc_paypal ( 97 97 id INT (11) NOT NULL AUTO_INCREMENT, 98 payer_id VARCHAR( 60) DEFAULT NULL,99 payment_date VARCHAR( 50) DEFAULT NULL,100 txn_id VARCHAR( 50) DEFAULT NULL,101 first_name VARCHAR( 50) DEFAULT NULL,102 last_name VARCHAR( 50) DEFAULT NULL,103 payer_email VARCHAR( 75) DEFAULT NULL,104 payer_status VARCHAR( 50) DEFAULT NULL,105 payment_type VARCHAR( 50) DEFAULT NULL,98 payer_id VARCHAR(50) DEFAULT NULL, 99 payment_date VARCHAR(30) DEFAULT NULL, 100 txn_id VARCHAR(30) DEFAULT NULL, 101 first_name VARCHAR(40) DEFAULT NULL, 102 last_name VARCHAR(40) DEFAULT NULL, 103 payer_email VARCHAR(55) DEFAULT NULL, 104 payer_status VARCHAR(30) DEFAULT NULL, 105 payment_type VARCHAR(30) DEFAULT NULL, 106 106 memo TINYTEXT, 107 item_name VARCHAR( 127) DEFAULT NULL,108 item_number VARCHAR( 127) DEFAULT NULL,107 item_name VARCHAR(70) DEFAULT NULL, 108 item_number VARCHAR(70) DEFAULT NULL, 109 109 quantity INT (11) NOT NULL DEFAULT '0', 110 110 mc_gross DECIMAL(9,2) DEFAULT NULL, … … 112 112 tax DECIMAL(9,2) DEFAULT NULL, 113 113 mc_currency CHAR(3) DEFAULT NULL, 114 address_name VARCHAR( 255) NOT NULL DEFAULT '',115 address_street VARCHAR( 255) NOT NULL DEFAULT '',116 address_city VARCHAR( 255) NOT NULL DEFAULT '',117 address_state VARCHAR( 255) NOT NULL DEFAULT '',118 address_zip VARCHAR(2 55) NOT NULL DEFAULT '',119 address_country VARCHAR( 255) NOT NULL DEFAULT '',120 address_status VARCHAR( 255) NOT NULL DEFAULT '',121 payer_business_name VARCHAR( 255) NOT NULL DEFAULT '',122 payment_status VARCHAR( 255) NOT NULL DEFAULT '',123 pending_reason VARCHAR( 255) NOT NULL DEFAULT '',124 reason_code VARCHAR( 255) NOT NULL DEFAULT '',125 txn_type VARCHAR( 255) NOT NULL DEFAULT '',114 address_name VARCHAR(50) NOT NULL DEFAULT '', 115 address_street VARCHAR(80) NOT NULL DEFAULT '', 116 address_city VARCHAR(40) NOT NULL DEFAULT '', 117 address_state VARCHAR(40) NOT NULL DEFAULT '', 118 address_zip VARCHAR(20) NOT NULL DEFAULT '', 119 address_country VARCHAR(30) NOT NULL DEFAULT '', 120 address_status VARCHAR(30) NOT NULL DEFAULT '', 121 payer_business_name VARCHAR(40) NOT NULL DEFAULT '', 122 payment_status VARCHAR(30) NOT NULL DEFAULT '', 123 pending_reason VARCHAR(50) NOT NULL DEFAULT '', 124 reason_code VARCHAR(30) NOT NULL DEFAULT '', 125 txn_type VARCHAR(30) NOT NULL DEFAULT '', 126 126 PRIMARY KEY (id), 127 127 UNIQUE KEY txn_id (txn_id),
