View file prikol_img/sql.txt

CREATE TABLE IF NOT EXISTS `prikol_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `act` enum('0','1','2') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;


CREATE TABLE IF NOT EXISTS `prikol_img_komm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `id_img` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `prikol_img_rating` (
  `id_user` int(11) NOT NULL,
  `id_img` int(11) NOT NULL,
  `rating` int(1) NOT NULL DEFAULT '0',
  `id_post` int(11) DEFAULT '0',
  KEY `id_user` (`id_user`,`id_img`),
  KEY `rating` (`rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;