DROP TABLE IF EXISTS `entries`;
CREATE TABLE `entries` (
  `id` varchar(32) BINARY NOT NULL,
  `body` text,
  `user_id` int(11) NOT NULL default 0,
  `user_agent` varchar(255),
  `created_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  INDEX (`created_at`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(64) BINARY,
  `password` varchar(64) BINARY,
  `nickname` varchar(255),
  `email` varchar(255),
  `mobile_id` varchar(255),
  `secret` varchar(32) BINARY,
  `created_at` datetime default NULL,
  `logged_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE (`username`),
  UNIQUE (`secret`),
  INDEX (`username`, `password`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tickets`;
CREATE TABLE `tickets` (
  `id` varchar(32) BINARY NOT NULL,
  `action` varchar(255),
  `user_id` int(11) NOT NULL default 0,
  `closed` tinyint(4) NOT NULL default 0,
  `created_at` datetime default NULL,
  `closed_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  INDEX (`id`, `action`, `closed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;