Subversion Repositories VORC

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
208 - 1 
## View: v_class_signup_counts
2 
#
3 
# +---------+------------------+------+-----+---------+-------+
4 
# | Field   | Type             | Null | Key | Default | Extra |
5 
# +---------+------------------+------+-----+---------+-------+
6 
# | id      | int(11) unsigned | NO   |     | NULL    |       |
7 
# | signups | bigint(21)       | NO   |     | 0       |       |
8 
# +---------+------------------+------+-----+---------+-------+
9 
 
10 
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`