Subversion Repositories VORC

## View: v_class_signup_counts
#
# +---------+------------------+------+-----+---------+-------+
# | Field   | Type             | Null | Key | Default | Extra |
# +---------+------------------+------+-----+---------+-------+
# | id      | int(11) unsigned | NO   |     | NULL    |       |
# | signups | bigint(21)       | NO   |     | 0       |       |
# +---------+------------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_class_signup_counts` AS select `assignment`.`Gid` AS `id`,count(0) AS `signups` from `assignment` where (`assignment`.`role` like 'CLA%') group by `assignment`.`Gid`