Subversion Repositories VORC

## View: v_coaches
#
# +---------------+------------------------+------+-----+---------+-------+
# | 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    |       |
# | password      | varchar(45)            | NO   |     | NULL    |       |
# | access        | tinyint(5)             | NO   |     | NULL    |       |
# | department    | varchar(150)           | 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    |       |
# | last_login    | datetime               | YES  |     | NULL    |       |
# | added         | datetime               | YES  |     | NULL    |       |
# +---------------+------------------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_coaches` 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`.`password` AS `password`,`v_official`.`access` AS `access`,`v_official`.`department` AS `department`,`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`.`last_login` AS `last_login`,`v_official`.`added` AS `added` from `v_official` where ((`v_official`.`department` like '%COA-%') and (not((`v_official`.`department` like '%COA-0%'))))