Размер файла: 1.3Kb
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;