905b95aacb
Adds ms precision to GM Command Logging to prevent duplicate key errors when commands from the same character come at the same second.
12 lines
355 B
SQL
12 lines
355 B
SQL
--
|
|
-- Table structure for table `audit_gm`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `audit_gm`;
|
|
CREATE TABLE `audit_gm` (
|
|
`date_time` DATETIME(3) NOT NULL,
|
|
`gm_name` VARCHAR(16) NOT NULL,
|
|
`command` VARCHAR(40) NOT NULL,
|
|
`full_string` VARCHAR(200) NOT NULL,
|
|
PRIMARY KEY (`date_time`,`gm_name`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|