| 208 |
- |
1 |
## Table: badgescans
|
|
|
2 |
#
|
|
|
3 |
# +-----------+------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +-----------+------------+------+-----+---------+-------+
|
|
|
6 |
# | Timestamp | datetime | YES | | NULL | |
|
|
|
7 |
# | UID | mediumtext | YES | | NULL | |
|
|
|
8 |
# | Serial | mediumtext | YES | | NULL | |
|
|
|
9 |
# | Type | mediumtext | YES | | NULL | |
|
|
|
10 |
# | Zone | mediumtext | YES | | NULL | |
|
|
|
11 |
# | Gate | mediumtext | YES | | NULL | |
|
|
|
12 |
# | Portal | mediumtext | YES | | NULL | |
|
|
|
13 |
# | Name | mediumtext | YES | | NULL | |
|
|
|
14 |
# | Meta1 | mediumtext | YES | | NULL | |
|
|
|
15 |
# | Response | mediumtext | YES | | NULL | |
|
|
|
16 |
# +-----------+------------+------+-----+---------+-------+
|
|
|
17 |
|
|
|
18 |
CREATE TABLE `badgescans` (
|
|
|
19 |
`Timestamp` datetime DEFAULT NULL,
|
|
|
20 |
`UID` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
21 |
`Serial` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
22 |
`Type` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
23 |
`Zone` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
24 |
`Gate` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
25 |
`Portal` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
26 |
`Name` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
27 |
`Meta1` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
28 |
`Response` mediumtext COLLATE utf8mb4_unicode_ci
|
|
|
29 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|