View file brands_battle/sql.sql

CREATE TABLE IF NOT EXISTS `brand` (
  `id` int(11) NOT NULL auto_increment,
  `name` text,
  `brand1` text,
  `brand2` text,
  `date` int(30) NOT NULL,
  `time` int(30) NOT NULL,
  `coment` int(1) NOT NULL,
  `f_brand_1` text,
  `f_brand_2` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `brand_coment` (
  `id` int(30) NOT NULL auto_increment,
  `user` int(30) NOT NULL,
  `brand` int(30) NOT NULL,
  `date` int(30) NOT NULL,
  `coment` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `brand_vote` (
  `id` int(11) NOT NULL auto_increment,
  `brand` text,
  `golos` text,
  `date` text,
  `user` int(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;