CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(110) default NULL,
  `mail` varchar(110) default NULL,
  `phone` varchar(20) default NULL,
  `phone2` varchar(20) NOT NULL,
  `address` text,
  `description` text NOT NULL,
  `owner` varchar(85) default NULL,
  `www` varchar(45) default NULL,
  `accept` tinyint(4) default '0',
  `closed` tinyint(4) default '0',
  `addtime` datetime default NULL,
  `user` int(11) default NULL,
  `counter` int(11) NOT NULL,
  `tag` varchar(240) NOT NULL,
  `membertype` tinyint(4) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  FULLTEXT KEY `name` (`name`,`description`,`tag`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin5 AUTO_INCREMENT=97 ;