File indexing completed on 2024-04-21 06:00:37
0001 0002 0003 DROP VIEW IF EXISTS `v_support`; 0004 0005 CREATE VIEW `v_support` AS 0006 SELECT `member_id` 0007 , max(`active_time`) AS `active_time_max` 0008 , min(`active_time`) AS `active_time_min` 0009 , DATE_ADD(max(`active_time`), INTERVAL 1 YEAR) AS `valid_till` 0010 , (DATE_ADD(max(`active_time`), INTERVAL 1 YEAR) > now()) AS `is_valid` 0011 , 0 AS `is_subscription` 0012 FROM `support` 0013 WHERE `status_id` = 2 0014 AND `type_id` = 0 0015 GROUP BY `member_id` 0016 0017 UNION 0018 0019 SELECT `member_id` 0020 , max(`active_time`) AS `active_time_max` 0021 , min(`active_time`) AS `active_time_min` 0022 , DATE_ADD(max(`active_time`), INTERVAL 1 MONTH) AS `valid_till` 0023 , (DATE_ADD(max(`active_time`), INTERVAL 1 MONTH) > now()) AS `is_valid` 0024 , 1 AS `is_subscription` 0025 FROM `support` 0026 WHERE `status_id` = 2 0027 AND `type_id` = 2 0028 AND `period` = 'M' 0029 GROUP BY `member_id` 0030 0031 UNION 0032 0033 SELECT `member_id` 0034 , max(`active_time`) AS `active_time_max` 0035 , min(`active_time`) AS `active_time_min` 0036 , DATE_ADD(max(`active_time`), INTERVAL 1 YEAR) AS `valid_till` 0037 , (DATE_ADD(max(`active_time`), INTERVAL 1 YEAR) > now()) AS `is_valid` 0038 , 1 AS `is_subscription` 0039 FROM `support` 0040 WHERE `status_id` = 2 0041 AND `type_id` = 2 0042 AND `period` = 'Y' 0043 GROUP BY `member_id`;