Subversion Repositories VORC

## View: v_ticket
#
# +-----------------+------------------+------+-----+---------+-------+
# | Field           | Type             | Null | Key | Default | Extra |
# +-----------------+------------------+------+-----+---------+-------+
# | id              | varchar(24)      | NO   |     | NULL    |       |
# | event_name      | varchar(45)      | YES  |     | NULL    |       |
# | order_date      | datetime         | YES  |     | NULL    |       |
# | ticket_type     | varchar(45)      | YES  |     | NULL    |       |
# | full_name       | varchar(91)      | YES  |     | NULL    |       |
# | email           | varchar(45)      | YES  |     | NULL    |       |
# | derby_name      | varchar(255)     | YES  |     | NULL    |       |
# | RCid            | int(11) unsigned | YES  |     | NULL    |       |
# | vorc_full_name  | varchar(45)      | YES  |     | NULL    |       |
# | vorc_email      | varchar(45)      | YES  |     | NULL    |       |
# | vorc_derby_name | varchar(45)      | YES  |     | NULL    |       |
# +-----------------+------------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_ticket` AS select `ticket`.`id` AS `id`,`ticket`.`event_name` AS `event_name`,`ticket`.`order_date` AS `order_date`,`ticket`.`ticket_type` AS `ticket_type`,concat_ws(' ',`ticket`.`first_name`,`ticket`.`last_name`) AS `full_name`,`ticket`.`email` AS `email`,`ticket`.`derby_name` AS `derby_name`,`RCid_ticket_link`.`RCid` AS `RCid`,`official`.`real_name` AS `vorc_full_name`,`official`.`email` AS `vorc_email`,`official`.`derby_name` AS `vorc_derby_name` from ((`ticket` left join `RCid_ticket_link` on((`ticket`.`id` = `RCid_ticket_link`.`MVPid`))) left join `official` on((`RCid_ticket_link`.`RCid` = `official`.`RCid`))) where (`ticket`.`event_name` = concat_ws(' ','RollerCon',year(now()))) order by `ticket`.`id`