ALTER TABLE licenses
    ADD COLUMN flavor_slug VARCHAR(80) NULL AFTER tier;

ALTER TABLE licenses
    ADD COLUMN flavor_label VARCHAR(120) NULL AFTER flavor_slug;

ALTER TABLE licenses
    ADD COLUMN flavor_meta_json JSON NULL AFTER flavor_label;

UPDATE licenses
   SET flavor_slug = 'account-standard',
       flavor_label = 'Account standard licence',
       flavor_meta_json = JSON_OBJECT(
           'label', 'Account standard licence',
           'audience', 'account',
           'delivery_mode', 'account-library',
           'document_title', 'Account License Certificate',
           'qr_caption', 'Open account license',
           'summary', 'Issued to an authenticated account with durable re-download access.'
       )
 WHERE flavor_slug IS NULL OR flavor_slug = '';
