File indexing completed on 2024-04-28 13:54:19
0001 ALTER TABLE `member` 0002 ADD COLUMN `paypal_valid_status` MEDIUMINT NULL DEFAULT NULL AFTER `paypal_mail`; 0003 0004 CREATE TABLE `paypal_valid_status` 0005 ( 0006 `id` INT(11) NOT NULL, 0007 `title` VARCHAR(50) NULL DEFAULT NULL, 0008 `description` TEXT NULL, 0009 `color` VARCHAR(50) NULL DEFAULT NULL, 0010 `is_active` INT(1) NULL DEFAULT '1', 0011 PRIMARY KEY (`id`) 0012 ) 0013 COLLATE = 'latin1_swedish_ci' 0014 ENGINE = InnoDB 0015 ; 0016 0017 0018 INSERT INTO `paypal_valid_status` (`id`, `title`, `desciption`, `color`) 0019 VALUES (0, 'New', 'New - valid status unknown', 'yellow'); 0020 INSERT INTO `paypal_valid_status` (`id`, `title`, `desciption`, `color`) 0021 VALUES (100, 'Valid', 'Valid - we can send you money per PayPal', 'green'); 0022 INSERT INTO `paypal_valid_status` (`id`, `title`, `desciption`, `color`) 0023 VALUES (404, 'Unknown Address', 'Invalid - Your PayPal-Address could not be found.', 'red'); 0024 INSERT INTO `paypal_valid_status` (`id`, `title`, `desciption`, `color`) 0025 VALUES (500, 'Invalid', 'Invalid - at the moment we can not send you money per PayPal', 'red'); 0026 INSERT INTO `paypal_valid_status` (`id`, `title`, `desciption`, `color`) 0027 VALUES (501, 'Can receive only from homepage.', 0028 'Invalid - You can only receive money from homepage. Please change your Settings on the PayPal Website.', 0029 'red'); 0030 INSERT INTO `paypal_valid_status` (`id`, `title`, `desciption`, `color`) 0031 VALUES (502, 'Can receive only personal payments.', 0032 'Invalid - You can not receive personal payments. Please change your Settings on the PayPal Website.', 'red'); 0033 INSERT INTO `paypal_valid_status` (`id`, `title`, `desciption`, `color`) 0034 VALUES (503, 'Currently unable to receive money.', 0035 'Invalid - You are currently unable to receive money. Please change your Settings on the PayPal Website.', 0036 'red');