/* Ratings SQL schema */

-- Individual votes
CREATE TABLE IF NOT EXISTS `cot_rated` (
  `rated_id` int unsigned NOT NULL auto_increment,
  `rated_code` varchar(255) collate utf8_unicode_ci default NULL,
  `rated_area` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `rated_userid` int default NULL,
  `rated_value` tinyint unsigned NOT NULL default '0',
  `rated_date` INT NOT NULL DEFAULT 0,
  PRIMARY KEY  (`rated_id`),
  KEY (`rated_area`, `rated_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Item ratings
CREATE TABLE IF NOT EXISTS `cot_ratings` (
  `rating_id` int NOT NULL auto_increment,
  `rating_code` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `rating_area` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `rating_state` tinyint NOT NULL default '0',
  `rating_average` decimal(5,2) NOT NULL default '0.00',
  `rating_creationdate` int NOT NULL default '0',
  `rating_text` varchar(128) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`rating_id`),
  KEY (`rating_area`, `rating_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
