BBgTK508

1CREATE TABLE IF NOT EXISTS `syslog` (
2  `id` bigint(255) unsigned NOT NULL auto_increment,
3  `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
4  `event` varchar(12) collate utf8_unicode_ci default NULL,
5  `chan` varchar(16) collate utf8_unicode_ci default NULL,
6  `nick` varchar(12) collate utf8_unicode_ci default NULL,
7  `ident` varchar(8) collate utf8_unicode_ci default NULL,
8  `address` varchar(255) collate utf8_unicode_ci default NULL,
9  `mode` varchar(5) collate utf8_unicode_ci default NULL,
10  `text` mediumtext collate utf8_unicode_ci NOT NULL,
11  PRIMARY KEY  (`id`),
12  KEY `event` (`event`),
13  KEY `chan` (`chan`),
14  KEY `nick` (`nick`),
15  KEY `ident` (`ident`),
16  KEY `address` (`address`),
17  KEY `mode` (`mode`),
18  FULLTEXT KEY `text` (`text`)
19) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=596 ;
20
21--
22-- Dumping data for table `syslog`
23--
24
25INSERT INTO `syslog` (`id`, `stamp`, `event`, `chan`, `nick`, `ident`, `address`, `mode`, `text`) VALUES
26(1, '2007-11-27 22:22:42', 'connecting', NULL, NULL, NULL, NULL, NULL, 'starting new session'),
27(2, '2007-11-27 22:22:42', 'connecting', NULL, 'pBot', NULL, NULL, NULL, 'login info sent'),
28(3, '2007-11-27 22:22:42', 'connect', NULL, NULL, NULL, NULL, NULL, 'veeTorServer'),
29(4, '2007-11-27 22:22:42', 'mode', NULL, NULL, NULL, NULL, '+i', 'pBot'),