Subversion Repositories VORC

## View: v_official
#
# +---------------+------------------------+------+-----+---------+-------+
# | 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               | YES  |     | NULL    |       |
# | added         | datetime               | YES  |     | NULL    |       |
# +---------------+------------------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_official` AS select `official`.`RCid` AS `RCid`,`official`.`derby_name` AS `derby_name`,`official`.`email` AS `email`,`official`.`real_name` AS `real_name`,`official`.`level` AS `level`,`official`.`phone` AS `phone`,`official`.`activation` AS `activation`,`official`.`password` AS `password`,`official`.`access` AS `access`,`official`.`department` AS `department`,if((locate('EMT',`official`.`department`) > 0),if(isnull(`emt_credential_verified`.`date`),0,1),NULL) AS `emt_verified`,`RCid_ticket_link`.`MVPid` AS `MVPid`,`official`.`discount_code` AS `discount_code`,`official`.`tshirt` AS `tshirt`,`official`.`pronouns` AS `pronouns`,`official`.`timeformat` AS `timeformat`,`official`.`showme` AS `showme`,`official`.`last_login` AS `last_login`,`official`.`added` AS `added` from ((`official` left join `RCid_ticket_link` on(((`official`.`RCid` = `RCid_ticket_link`.`RCid`) and (`RCid_ticket_link`.`year` = year(now()))))) left join `emt_credential_verified` on(((`official`.`RCid` = `emt_credential_verified`.`RCid`) and (year(`emt_credential_verified`.`date`) = year(now())))))