Subversion Repositories VORC

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
208 - 1 
## View: v_ticket
2 
#
3 
# +-----------------+------------------+------+-----+---------+-------+
4 
# | Field           | Type             | Null | Key | Default | Extra |
5 
# +-----------------+------------------+------+-----+---------+-------+
6 
# | id              | varchar(24)      | NO   |     | NULL    |       |
7 
# | event_name      | varchar(45)      | YES  |     | NULL    |       |
8 
# | order_date      | datetime         | YES  |     | NULL    |       |
9 
# | ticket_type     | varchar(45)      | YES  |     | NULL    |       |
10 
# | full_name       | varchar(91)      | YES  |     | NULL    |       |
11 
# | email           | varchar(45)      | YES  |     | NULL    |       |
12 
# | derby_name      | varchar(255)     | YES  |     | NULL    |       |
13 
# | RCid            | int(11) unsigned | YES  |     | NULL    |       |
14 
# | vorc_full_name  | varchar(45)      | YES  |     | NULL    |       |
15 
# | vorc_email      | varchar(45)      | YES  |     | NULL    |       |
16 
# | vorc_derby_name | varchar(45)      | YES  |     | NULL    |       |
17 
# +-----------------+------------------+------+-----+---------+-------+
18 
 
19 
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`