Subversion Repositories VORC

## Table: sign_up_count
#
# +------------+------------------+------+-----+---------+-------+
# | Field      | Type             | Null | Key | Default | Extra |
# +------------+------------------+------+-----+---------+-------+
# | date       | date             | NO   | PRI | NULL    |       |
# | RCid       | int(45) unsigned | NO   | PRI | NULL    |       |
# | department | varchar(15)      | NO   | PRI |         |       |
# | sign_ups   | int(5) unsigned  | NO   |     | NULL    |       |
# +------------+------------------+------+-----+---------+-------+

CREATE TABLE `sign_up_count` (
  `date` date NOT NULL,
  `RCid` int(45) unsigned NOT NULL,
  `department` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `sign_ups` int(5) unsigned NOT NULL,
  PRIMARY KEY (`date`,`RCid`,`department`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci