Просмотр файла newsub/komment.sql

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;

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;