Subversion Repositories VORC

## Table: official
#
# +---------------+------------------------+------+-----+---------+----------------+
# | Field         | Type                   | Null | Key | Default | Extra          |
# +---------------+------------------------+------+-----+---------+----------------+
# | RCid          | int(11)                | NO   | PRI | NULL    | auto_increment |
# | derby_name    | varchar(45)            | NO   | PRI | NULL    |                |
# | email         | varchar(45)            | NO   | UNI | NULL    |                |
# | real_name     | varchar(45)            | NO   |     | NULL    |                |
# | level         | enum('AA','A','B','C') | NO   |     | NULL    |                |
# | phone         | varchar(45)            | YES  |     | NULL    |                |
# | activation    | varchar(32)            | NO   |     | NULL    |                |
# | password      | varchar(45)            | NO   |     | NULL    |                |
# | access        | tinyint(5)             | NO   |     | NULL    |                |
# | department    | varchar(150)           | YES  |     | NULL    |                |
# | discount_code | varchar(10)            | YES  | UNI | NULL    |                |
# | tshirt        | varchar(5)             | YES  |     | NULL    |                |
# | pronouns      | varchar(20)            | YES  |     | NULL    |                |
# | timeformat    | enum('24hr','ampm')    | NO   |     | 24hr    |                |
# | showme        | tinyint(4)             | NO   |     | 0       |                |
# | last_login    | datetime               | YES  |     | NULL    |                |
# | last_active   | timestamp              | YES  |     | NULL    |                |
# | added         | datetime               | YES  |     | NULL    |                |
# +---------------+------------------------+------+-----+---------+----------------+

CREATE TABLE `official` (
  `RCid` int(11) NOT NULL AUTO_INCREMENT,
  `derby_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `real_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` enum('AA','A','B','C') COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activation` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access` tinyint(5) NOT NULL,
  `department` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tshirt` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pronouns` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timeformat` enum('24hr','ampm') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '24hr',
  `showme` tinyint(4) NOT NULL DEFAULT '0',
  `last_login` datetime DEFAULT NULL,
  `last_active` timestamp NULL DEFAULT NULL,
  `added` datetime DEFAULT NULL,
  PRIMARY KEY (`RCid`,`derby_name`),
  UNIQUE KEY `name_UNIQUE` (`derby_name`),
  UNIQUE KEY `email_UNIQUE` (`email`),
  UNIQUE KEY `RCid_UNIQUE` (`RCid`),
  UNIQUE KEY `discount_code_UNIQUE` (`discount_code`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci