--
-- ALTER TABLE
--
ALTER TABLE `#prefix#GroupProducts` MODIFY COLUMN `type` enum('productregister','productupgrade','productrenew', 'configurablegroup', 'configurableoption') ;
--
-- `#prefix#ConfigOptionsSubPricing`
--
CREATE TABLE IF NOT EXISTS `#prefix#ConfigOptionsSubPricing` (
    `relid`         int(10) unsigned NOT NULL,
    `currencyid`    int(10) NOT NULL,
    `billingcycle`  VARCHAR(255) NOT NULL,
    `value`         VARCHAR(255) NOT NULL,
    PRIMARY KEY (`relid`, `currencyid`, `billingcycle`)
    ) ENGINE=InnoDB DEFAULT CHARSET=#charset# DEFAULT COLLATE #collation#;
