| 208 |
- |
1 |
## Table: official
|
|
|
2 |
#
|
|
|
3 |
# +---------------+------------------------+------+-----+---------+----------------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +---------------+------------------------+------+-----+---------+----------------+
|
|
|
6 |
# | RCid | int(11) | NO | PRI | NULL | auto_increment |
|
|
|
7 |
# | derby_name | varchar(45) | NO | PRI | NULL | |
|
|
|
8 |
# | email | varchar(45) | NO | UNI | NULL | |
|
|
|
9 |
# | real_name | varchar(45) | NO | | NULL | |
|
|
|
10 |
# | level | enum('AA','A','B','C') | NO | | NULL | |
|
|
|
11 |
# | phone | varchar(45) | YES | | NULL | |
|
|
|
12 |
# | activation | varchar(32) | NO | | NULL | |
|
|
|
13 |
# | password | varchar(45) | NO | | NULL | |
|
|
|
14 |
# | access | tinyint(5) | NO | | NULL | |
|
|
|
15 |
# | department | varchar(150) | YES | | NULL | |
|
|
|
16 |
# | discount_code | varchar(10) | YES | UNI | NULL | |
|
|
|
17 |
# | tshirt | varchar(5) | YES | | NULL | |
|
|
|
18 |
# | pronouns | varchar(20) | YES | | NULL | |
|
|
|
19 |
# | timeformat | enum('24hr','ampm') | NO | | 24hr | |
|
|
|
20 |
# | showme | tinyint(4) | NO | | 0 | |
|
|
|
21 |
# | last_login | datetime | YES | | NULL | |
|
|
|
22 |
# | last_active | timestamp | YES | | NULL | |
|
|
|
23 |
# | added | datetime | YES | | NULL | |
|
|
|
24 |
# +---------------+------------------------+------+-----+---------+----------------+
|
|
|
25 |
|
|
|
26 |
CREATE TABLE `official` (
|
|
|
27 |
`RCid` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
28 |
`derby_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
29 |
`email` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
30 |
`real_name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
31 |
`level` enum('AA','A','B','C') COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
32 |
`phone` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
33 |
`activation` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
34 |
`password` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
35 |
`access` tinyint(5) NOT NULL,
|
|
|
36 |
`department` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
37 |
`discount_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
38 |
`tshirt` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
39 |
`pronouns` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
40 |
`timeformat` enum('24hr','ampm') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '24hr',
|
|
|
41 |
`showme` tinyint(4) NOT NULL DEFAULT '0',
|
|
|
42 |
`last_login` datetime DEFAULT NULL,
|
|
|
43 |
`last_active` timestamp NULL DEFAULT NULL,
|
|
|
44 |
`added` datetime DEFAULT NULL,
|
|
|
45 |
PRIMARY KEY (`RCid`,`derby_name`),
|
|
|
46 |
UNIQUE KEY `name_UNIQUE` (`derby_name`),
|
|
|
47 |
UNIQUE KEY `email_UNIQUE` (`email`),
|
|
|
48 |
UNIQUE KEY `RCid_UNIQUE` (`RCid`),
|
|
|
49 |
UNIQUE KEY `discount_code_UNIQUE` (`discount_code`)
|
|
|
50 |
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|