File indexing completed on 2024-04-28 17:16:07
0001 CREATE TABLE `payout_status` 0002 ( 0003 `id` INT(11) NOT NULL, 0004 `type` VARCHAR(50) NOT NULL DEFAULT 'info', 0005 `title` VARCHAR(50) NULL DEFAULT NULL, 0006 `description` TEXT NULL, 0007 `color` VARCHAR(50) NULL DEFAULT NULL, 0008 `icon` VARCHAR(50) NULL DEFAULT 'glyphicon-info-sign', 0009 `is_active` INT(1) NULL DEFAULT '1', 0010 PRIMARY KEY (`id`) 0011 ) 0012 COLLATE = 'latin1_swedish_ci' 0013 ENGINE = InnoDB 0014 ; 0015 0016 /** 0017 public static $PAYOUT_STATUS_NEW = 0; 0018 public static $PAYOUT_STATUS_REQUESTED = 1; 0019 public static $PAYOUT_STATUS_PROCESSED = 10; 0020 public static $PAYOUT_STATUS_PENDING = 50; 0021 public static $PAYOUT_STATUS_COMPLETED = 100; 0022 public static $PAYOUT_STATUS_DENIED = 999; 0023 public static $PAYOUT_STATUS_REFUND = 900; 0024 public static $PAYOUT_STATUS_ERROR = 99; 0025 **/ 0026 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`, `icon`) 0027 VALUES (0, 'New', 'New - valid status unknown', '#31708f;', 'glyphicon-info-sign'); 0028 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`) 0029 VALUES (1, 'Status: Requested', 'We send your payout. The actual status is: Requested.', '#31708f;', 0030 'glyphicon-info-sign'); 0031 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`) 0032 VALUES (10, 'Status: Processed', 'We send your payout. The actual status is: Processed.', '#31708f;', 0033 'glyphicon-info-sign'); 0034 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`) 0035 VALUES (50, 'Status: Pending', 'We send your payout. The actual status is: Pending.', '#31708f;', 0036 'glyphicon-info-sign'); 0037 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`) 0038 VALUES (100, 'Status: Completed', 'For this month we has successfully paid you.', '#3c763d;', 'glyphicon-ok-sign'); 0039 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`) 0040 VALUES (999, 'Status: Denied', 'We tried to payout your plings, but your payment was denied.', '#a94442;', 0041 'glyphicon-exclamation-sign'); 0042 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`) 0043 VALUES (900, 'Status: Refund', 'We tried to payout your plings, but your payment was refund.', '#a94442;', 0044 'glyphicon-exclamation-sign'); 0045 INSERT INTO `payout_status` (`id`, `title`, `description`, `color`) 0046 VALUES (99, 'Status: Error', 'We tried to payout your plings, but there was an error.', '#a94442;', 0047 'glyphicon-exclamation-sign'); 0048