CREATE TABLE IF NOT EXISTS `#__djc2_combination_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `combination_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `price` decimal(14,4) NOT NULL DEFAULT '0.0000',
  PRIMARY KEY (`id`),
  UNIQUE KEY `item_group` (`combination_id`,`group_id`),
  UNIQUE KEY `group_item` (`group_id`,`combination_id`)
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `#__djc2_customer_groups`  
ADD `user_group` INT NOT NULL DEFAULT '0'  AFTER `is_default`,  
ADD `ordering` INT NOT NULL DEFAULT '0'  AFTER `user_group`;

ALTER TABLE `#__djc2_customer_groups` ADD INDEX (`user_group`); 
ALTER TABLE `#__djc2_customer_groups` ADD INDEX (`ordering`); 
