Subversion Repositories VORC

## View: v_class_signup_new
#
# +------------+------------------+------+-----+---------+-------+
# | Field      | Type             | Null | Key | Default | Extra |
# +------------+------------------+------+-----+---------+-------+
# | id         | int(10) unsigned | NO   |     | 0       |       |
# | name       | varchar(128)     | YES  |     | NULL    |       |
# | date       | date             | YES  |     | NULL    |       |
# | dayofweek  | varchar(9)       | YES  |     | NULL    |       |
# | time       | varchar(23)      | YES  |     | NULL    |       |
# | start_time | varchar(10)      | YES  |     | NULL    |       |
# | end_time   | varchar(10)      | YES  |     | NULL    |       |
# | location   | varchar(45)      | YES  |     | NULL    |       |
# | level      | varchar(45)      | YES  |     | NULL    |       |
# | note       | mediumtext       | YES  |     | NULL    |       |
# | capacity   | int(10) unsigned | YES  |     | NULL    |       |
# | role       | char(8)          | YES  |     | NULL    |       |
# | RCid       | int(11) unsigned | YES  |     | NULL    |       |
# +------------+------------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_class_signup_new` AS select `class`.`id` AS `id`,`class`.`name` AS `name`,`class`.`date` AS `date`,dayname(`class`.`date`) AS `dayofweek`,concat(convert(time_format(`class`.`start_time`,'%H:%i') using utf8mb4),' - ',convert(time_format(`class`.`end_time`,'%H:%i') using utf8mb4)) AS `time`,time_format(`class`.`start_time`,'%H:%i') AS `start_time`,time_format(`class`.`end_time`,'%H:%i') AS `end_time`,`class`.`location` AS `location`,`class`.`level` AS `level`,`class`.`note` AS `note`,`class`.`capacity` AS `capacity`,`assignment`.`role` AS `role`,`assignment`.`RCid` AS `RCid` from (`class` left join `assignment` on(((`class`.`id` = `assignment`.`Gid`) and (`assignment`.`role` like 'CLA%'))))