-- Структура таблицы `forum1`
--
DROP TABLE IF EXISTS `forum1`;
CREATE TABLE `forum1` (
  `id` int(11) NOT NULL auto_increment,
  `refid` int(11) NOT NULL,
  `type` char(1) NOT NULL,
  `time` int(11) NOT NULL,
  `from` varchar(25) NOT NULL,
  `to` varchar(25) NOT NULL,
  `realid` int(3) NOT NULL,
  `ip` text NOT NULL,
  `soft` text NOT NULL,
  `text` text NOT NULL,
  `close` binary(1) NOT NULL,
  `vip` binary(1) NOT NULL,
  `moder` binary(1) NOT NULL,
  `edit` text NOT NULL,
  `tedit` int(11) NOT NULL,
  `kedit` int(2) NOT NULL,
  `attach` text NOT NULL,
  `dlcount` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `refid` (`refid`),
  KEY `type` (`type`),
  KEY `time` (`time`),
  KEY `from` (`from`),
  KEY `to` (`to`),
  KEY `moder` (`moder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;