create database if not exists `dbtest`;
use `dbtest`;
create table if not exists `test` (
  `id` int(11) not null auto_increment,
  `ts` datetime default null,
  `host` varchar(16) default null,
  `service` varchar(16) default null,
  `message` text default null,
  primary key (`id`),
  key `test_ts_idx` (`ts`),
  key `test_host_idx` (`host`),
  key `test_service_idx` (`service`)
);
