-- --------------------------------------------------------

--
-- Table structure for table `engine4_classified_ratings`
--

DROP TABLE IF EXISTS `engine4_classified_ratings`;
CREATE TABLE IF NOT EXISTS `engine4_classified_ratings` (
  `classified_id` int(10) unsigned NOT NULL,
  `user_id` int(9) unsigned NOT NULL,
  `rating` tinyint(1) unsigned default NULL,
  PRIMARY KEY  (`classified_id`,`user_id`),
  KEY `INDEX` (`classified_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ;

ALTER TABLE `engine4_classified_classifieds` ADD `rating` FLOAT NOT NULL;
