View file newsub/localhost.sql

CREATE TABLE `mail_rass` (
  `id` int(11) NOT NULL auto_increment,
  `time` text collate cp1251_bin NOT NULL,
  `mail` text collate cp1251_bin NOT NULL,
  `kod` text collate cp1251_bin NOT NULL,
  PRIMARY KEY  (`id`),
    FULLTEXT KEY `mail` (`mail`)
) ENGINE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `news_index` (
  `tema` text collate cp1251_bin,
  `time` int(11) NOT NULL default '0',
  `news` text collate cp1251_bin NOT NULL,
  PRIMARY KEY  (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin;