ALTER TABLE `reso_group` ADD `rg_capacity` INT NOT NULL AFTER `rg_desc`, ADD `rg_rate` DECIMAL(11,2) NOT NULL AFTER `rg_capacity`, ADD `rg_extra_rate` DECIMAL(11,2) NOT NULL AFTER `rg_rate`;

CREATE TABLE `reso_meta` (
    `rm_id` int(11) NOT NULL,
    `rm_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'group',
    `rm_ref_id` int(11) NOT NULL,
    `rm_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `rm_val` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `deleted` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `reso_meta`
ADD PRIMARY KEY (`rm_id`);
ALTER TABLE `reso_meta`
MODIFY `rm_id` int(11) NOT NULL AUTO_INCREMENT;

