DROP TABLE IF EXISTS `conf`;
CREATE TABLE `conf` (
  `name` varchar(255) collate utf8_unicode_ci NOT NULL,
  `value` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

LOCK TABLES `conf` WRITE;
INSERT INTO `conf` VALUES ('site.title','bitlog'),('site.desc','a simple bitlog'),('site.admin','test'),('site.url',''),('site.theme','simple'),('site.charset','UTF-8'),('site.tz','USA Eastern'),('site.lang','en-US'),('posts.num','15'),('feed.theme','rss2'),('site.register','single'),('urls.theme','bitlog');
UNLOCK TABLES;

DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `text` tinytext collate utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

LOCK TABLES `log` WRITE;
INSERT INTO `log` VALUES (1,1,'Hello World, this is bitlog.',NOW());
UNLOCK TABLES;

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `password` varchar(40) collate utf8_unicode_ci NOT NULL,
  `location` varchar(75) collate utf8_unicode_ci NOT NULL,
  `is_admin` tinyint(4) NOT NULL,
  `fullname` varchar(75) collate utf8_unicode_ci NOT NULL,
  `timezone` varchar(50) collate utf8_unicode_ci NOT NULL,
  `icon` varchar(255) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

LOCK TABLES `users` WRITE;
INSERT INTO `users` VALUES (1,'test','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8','Somewhere',1,'Test User','USA Eastern','');
UNLOCK TABLES;