Subversion Repositories VORC

## Table: badgescans
#
# +-----------+------------+------+-----+---------+-------+
# | Field     | Type       | Null | Key | Default | Extra |
# +-----------+------------+------+-----+---------+-------+
# | Timestamp | datetime   | YES  |     | NULL    |       |
# | UID       | mediumtext | YES  |     | NULL    |       |
# | Serial    | mediumtext | YES  |     | NULL    |       |
# | Type      | mediumtext | YES  |     | NULL    |       |
# | Zone      | mediumtext | YES  |     | NULL    |       |
# | Gate      | mediumtext | YES  |     | NULL    |       |
# | Portal    | mediumtext | YES  |     | NULL    |       |
# | Name      | mediumtext | YES  |     | NULL    |       |
# | Meta1     | mediumtext | YES  |     | NULL    |       |
# | Response  | mediumtext | YES  |     | NULL    |       |
# +-----------+------------+------+-----+---------+-------+

CREATE TABLE `badgescans` (
  `Timestamp` datetime DEFAULT NULL,
  `UID` mediumtext COLLATE utf8mb4_unicode_ci,
  `Serial` mediumtext COLLATE utf8mb4_unicode_ci,
  `Type` mediumtext COLLATE utf8mb4_unicode_ci,
  `Zone` mediumtext COLLATE utf8mb4_unicode_ci,
  `Gate` mediumtext COLLATE utf8mb4_unicode_ci,
  `Portal` mediumtext COLLATE utf8mb4_unicode_ci,
  `Name` mediumtext COLLATE utf8mb4_unicode_ci,
  `Meta1` mediumtext COLLATE utf8mb4_unicode_ci,
  `Response` mediumtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci