Subversion Repositories VORC

## View: v_leadership
#
# +---------------+----------------------------+------+-----+---------+-------+
# | Field         | Type                       | Null | Key | Default | Extra |
# +---------------+----------------------------+------+-----+---------+-------+
# | RCid          | int(11)                    | NO   |     | 0       |       |
# | derby_name    | varchar(45)                | NO   |     | NULL    |       |
# | email         | varchar(45)                | NO   |     | NULL    |       |
# | real_name     | varchar(45)                | NO   |     | NULL    |       |
# | level         | enum('AA','A','B','C')     | NO   |     | NULL    |       |
# | phone         | varchar(45)                | YES  |     | NULL    |       |
# | activation    | varchar(32)                | NO   |     | NULL    |       |
# | password      | varchar(45)                | NO   |     | NULL    |       |
# | access        | tinyint(5)                 | NO   |     | NULL    |       |
# | department    | varchar(150)               | YES  |     | NULL    |       |
# | emt_verified  | int(1)                     | YES  |     | NULL    |       |
# | MVPid         | varchar(24)                | YES  |     | NULL    |       |
# | discount_code | varchar(10)                | YES  |     | NULL    |       |
# | tshirt        | varchar(5)                 | YES  |     | NULL    |       |
# | pronouns      | varchar(20)                | YES  |     | NULL    |       |
# | timeformat    | enum('24hr','ampm')        | NO   |     | 24hr    |       |
# | showme        | tinyint(4)                 | NO   |     | 0       |       |
# | last_login    | datetime /* mariadb-5.3 */ | YES  |     | NULL    |       |
# | added         | datetime /* mariadb-5.3 */ | YES  |     | NULL    |       |
# +---------------+----------------------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_leadership` AS select `v_official`.`RCid` AS `RCid`,`v_official`.`derby_name` AS `derby_name`,`v_official`.`email` AS `email`,`v_official`.`real_name` AS `real_name`,`v_official`.`level` AS `level`,`v_official`.`phone` AS `phone`,`v_official`.`activation` AS `activation`,`v_official`.`password` AS `password`,`v_official`.`access` AS `access`,`v_official`.`department` AS `department`,`v_official`.`emt_verified` AS `emt_verified`,`v_official`.`MVPid` AS `MVPid`,`v_official`.`discount_code` AS `discount_code`,`v_official`.`tshirt` AS `tshirt`,`v_official`.`pronouns` AS `pronouns`,`v_official`.`timeformat` AS `timeformat`,`v_official`.`showme` AS `showme`,`v_official`.`last_login` AS `last_login`,`v_official`.`added` AS `added` from `v_official` where `v_official`.`department` like '%-2%' or `v_official`.`department` like '%-3%' or `v_official`.`department` like '%-4%' or `v_official`.`access` > 1