CREATE TABLE IF NOT EXISTS `stat` (
  `id` int(11) NOT NULL auto_increment,
  `category` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `date` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

CREATE TABLE IF NOT EXISTS `user_notes` (
  `id` int(11) NOT NULL auto_increment,
  `time` datetime NOT NULL,
  `nick` varchar(32) NOT NULL default '',
  `title` varchar(64) NOT NULL default '',
  `content` varchar(255) NOT NULL default '',
  `remote_addr` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
