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;

CREATE TABLE `news_vhod` (
  `id` int(11) NOT NULL auto_increment,
  `ent` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=1;
INSERT INTO `news_vhod` SET `id`='1', `ent`='0';

CREATE TABLE `news_antispam` (
  `id` int(11) NOT NULL auto_increment,
  `ip` tinyblob NOT NULL,
  `ban` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=1;

CREATE TABLE `news_komm` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `mess` text collate cp1251_bin NOT NULL,
  `time` int(11) NOT NULL default '0',
  `date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=1;