| 208 |
- |
1 |
## Table: log
|
|
|
2 |
#
|
|
|
3 |
# +-----------+--------------------+------+-----+-------------------+-----------------------------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +-----------+--------------------+------+-----+-------------------+-----------------------------+
|
|
|
6 |
# | eventid | bigint(8) unsigned | NO | PRI | NULL | auto_increment |
|
|
|
7 |
# | timestamp | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
|
|
|
8 |
# | RCid | int(11) | YES | | NULL | |
|
|
|
9 |
# | event | mediumtext | NO | | NULL | |
|
|
|
10 |
# +-----------+--------------------+------+-----+-------------------+-----------------------------+
|
|
|
11 |
|
|
|
12 |
CREATE TABLE `log` (
|
|
|
13 |
`eventid` bigint(8) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
14 |
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
|
15 |
`RCid` int(11) DEFAULT NULL,
|
|
|
16 |
`event` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
17 |
PRIMARY KEY (`eventid`),
|
|
|
18 |
UNIQUE KEY `eventid_UNIQUE` (`eventid`)
|
|
|
19 |
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|