Subversion Repositories VORC

## Table: ticket
#
# +-------------------+--------------+------+-----+---------+-------+
# | Field             | Type         | Null | Key | Default | Extra |
# +-------------------+--------------+------+-----+---------+-------+
# | id                | varchar(24)  | NO   | PRI | NULL    |       |
# | event_name        | varchar(45)  | YES  |     | NULL    |       |
# | order_date        | datetime     | YES  |     | NULL    |       |
# | ticket_type       | varchar(45)  | YES  |     | NULL    |       |
# | first_name        | varchar(45)  | YES  |     | NULL    |       |
# | last_name         | varchar(45)  | YES  |     | NULL    |       |
# | email             | varchar(45)  | YES  |     | NULL    |       |
# | derby_name        | varchar(255) | YES  |     | NULL    |       |
# | wrstbnd_accountid | varchar(24)  | YES  | UNI | NULL    |       |
# +-------------------+--------------+------+-----+---------+-------+

CREATE TABLE `ticket` (
  `id` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `ticket_type` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `derby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wrstbnd_accountid` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `wrstbnd_accountid_UNIQUE` (`wrstbnd_accountid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci