Subversion Repositories VORC

## Table: log
#
# +-----------+--------------------+------+-----+-------------------+-----------------------------+
# | Field     | Type               | Null | Key | Default           | Extra                       |
# +-----------+--------------------+------+-----+-------------------+-----------------------------+
# | eventid   | bigint(8) unsigned | NO   | PRI | NULL              | auto_increment              |
# | timestamp | timestamp          | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
# | RCid      | int(11)            | YES  |     | NULL              |                             |
# | event     | mediumtext         | NO   |     | NULL              |                             |
# +-----------+--------------------+------+-----+-------------------+-----------------------------+

CREATE TABLE `log` (
  `eventid` bigint(8) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `RCid` int(11) DEFAULT NULL,
  `event` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`eventid`),
  UNIQUE KEY `eventid_UNIQUE` (`eventid`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci