--
-- notepad
--

CREATE TABLE IF NOT EXISTS `notepad` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL,
  `title` tinytext collate utf8_bin NOT NULL,
  `unregistered_nick` tinytext collate utf8_bin NOT NULL,
  `registered_id` int(11) NOT NULL,
  `author_ip` varchar(15) collate utf8_bin NOT NULL,
  `language` tinytext collate utf8_bin NOT NULL,
  `source` text collate utf8_bin NOT NULL,
  `time` enum('d','m','f') collate utf8_bin NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;