DROP TABLE IF EXISTS  `t1`;

CREATE TABLE `t1` (

                           `id` binary(16) NOT NULL,

                           `configurator_group_config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`configurator_group_config`)),

                           `main_variant_id` binary(16) DEFAULT NULL,

                           `display_parent` tinyint(1) DEFAULT NULL,

                           PRIMARY KEY (`id`),

                           CONSTRAINT `fk.t1.main_variant_id` FOREIGN KEY (`main_variant_id`) REFERENCES `t1` (`id`) ON DELETE SET NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `t1`

    ADD COLUMN `variant_listing_config` JSON

        GENERATED ALWAYS AS (

            CASE

                WHEN `display_parent` IS NOT NULL OR `main_variant_id` IS NOT NULL OR

                     `configurator_group_config` IS NOT NULL

                    THEN (JSON_OBJECT('displayParent', `display_parent`, 'mainVariantId', LOWER(HEX(`main_variant_id`)),

                                      'configuratorGroupConfig', JSON_EXTRACT(`configurator_group_config`, '$')))

                END) VIRTUAL

;