Design log event table including ALL keys in SQL

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

CREATE TABLE `log_event` (
  `id` bigint(20) NOT NULL auto_increment,
  `logtime` datetime default NULL,
  `etype` text,
  `module` text,
  `edata` text,
  `session` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
)