Subversion Repositories VORC

## Table: class
#
# +------------+------------------+------+-----+---------+----------------+
# | Field      | Type             | Null | Key | Default | Extra          |
# +------------+------------------+------+-----+---------+----------------+
# | id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
# | name       | varchar(128)     | YES  |     | NULL    |                |
# | coach      | int(10) unsigned | YES  |     | NULL    |                |
# | assistant  | int(10) unsigned | YES  |     | NULL    |                |
# | date       | date             | YES  |     | NULL    |                |
# | location   | varchar(45)      | YES  |     | NULL    |                |
# | level      | varchar(45)      | YES  |     | NULL    |                |
# | start_time | time             | YES  |     | NULL    |                |
# | end_time   | time             | YES  |     | NULL    |                |
# | note       | mediumtext       | YES  |     | NULL    |                |
# | capacity   | int(10) unsigned | YES  |     | NULL    |                |
# | wrstbnd_id | varchar(24)      | YES  | UNI | NULL    |                |
# +------------+------------------+------+-----+---------+----------------+

CREATE TABLE `class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coach` int(10) unsigned DEFAULT NULL,
  `assistant` int(10) unsigned DEFAULT NULL,
  `date` date DEFAULT NULL,
  `location` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `note` mediumtext COLLATE utf8mb4_unicode_ci,
  `capacity` int(10) unsigned DEFAULT NULL,
  `wrstbnd_id` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `wrstbnd_id_UNIQUE` (`wrstbnd_id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci