JavjMDuL

1CREATE TABLE IF NOT EXISTS `logs` (
2  `id` bigint(20) unsigned NOT NULL auto_increment,
3  `host` varchar(128) collate utf8_unicode_ci default NULL,
4  `facility` varchar(10) collate utf8_unicode_ci default NULL,
5  `priority` varchar(10) collate utf8_unicode_ci default NULL,
6  `level` varchar(10) collate utf8_unicode_ci default NULL,
7  `tag` varchar(10) collate utf8_unicode_ci default NULL,
8  `datetime` datetime default NULL,
9  `program` varchar(15) collate utf8_unicode_ci default NULL,
10  `msg` text collate utf8_unicode_ci,
11  `seq` bigint(20) unsigned NOT NULL default '0',
12  `counter` int(11) NOT NULL default '1',
13  `fo` datetime default NULL,
14  `lo` datetime default NULL,
15  PRIMARY KEY  (`id`),
16  KEY `datetime` (`datetime`),
17  KEY `sequence` (`seq`),
18  KEY `priority` (`priority`),
19  KEY `facility` (`facility`),
20  KEY `program` (`program`),
21  KEY `host` (`host`)
22) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;