CREATE TABLE `def_colour_palette` (
`Palette_name` varchar(255) NOT NULL,
`package` varchar(255) DEFAULT NULL,
`Module` VARCHAR(255) DEFAULT NULL,
`primary` varchar(255) DEFAULT NULL,
`secondary` varchar(255) DEFAULT NULL,
`accent` varchar(255) DEFAULT NULL,
`danger` varchar(255) DEFAULT NULL,
`success` varchar(255) DEFAULT NULL,
`info` varchar(255) DEFAULT NULL,
`warning` varchar(255) DEFAULT NULL,
`colour_1` varchar(255) DEFAULT NULL,
`colour_2` varchar(255) DEFAULT NULL,
`colour_3` varchar(255) DEFAULT NULL,
`colour_4` varchar(255) DEFAULT NULL,
`colour_5` varchar(255) DEFAULT NULL,
`colour_6` varchar(255) DEFAULT NULL,
`colour_7` varchar(255) DEFAULT NULL,
`colour_8` varchar(255) DEFAULT NULL,
`colour_9` varchar(255) DEFAULT NULL,
`colour_10` varchar(255) DEFAULT NULL,
`light` varchar(255) DEFAULT NULL,
`dark` varchar(255) DEFAULT NULL,
`background` varchar(255) DEFAULT NULL,
`text` varchar(255) DEFAULT NULL,
`Gray-100` varchar(255) DEFAULT NULL,
`Gray-200` varchar(255) DEFAULT NULL,
`Gray-300` varchar(255) DEFAULT NULL,
`Gray-400` varchar(255) DEFAULT NULL,
`Gray-500` varchar(255) DEFAULT NULL,
`Gray-600` varchar(255) DEFAULT NULL,
`Gray-700` varchar(255) DEFAULT NULL,
`Gray-800` varchar(255) DEFAULT NULL,
`Gray-900` varchar(255) DEFAULT NULL,
`Blue` varchar(255) DEFAULT NULL,
`Indigo` varchar(255) DEFAULT NULL,
`Purple` varchar(255) DEFAULT NULL,
`Pink` varchar(255) DEFAULT NULL,
`Red` varchar(255) DEFAULT NULL,
`Orange` varchar(255) DEFAULT NULL,
`Yellow` varchar(255) DEFAULT NULL,
`Green` varchar(255) DEFAULT NULL,
`Teal` varchar(255) DEFAULT NULL,
`Cyan` varchar(255) DEFAULT NULL,
`Body-Color` varchar(255) DEFAULT NULL,
`Body-Bg` varchar(255) DEFAULT NULL,
`delta_e_threshold` float DEFAULT NULL,
`wcag_level` varchar(10) DEFAULT NULL,
`is_default` char(1) DEFAULT NULL,
`SetName` varchar(255) DEFAULT NULL,
`Font` varchar(255) DEFAULT NULL,
`FontUrl` varchar(512) DEFAULT NULL,
PRIMARY KEY (`Palette_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
SELECT * FROM def_colour_palette
WHERE Palette_name = '{palette_name}'
AND coalesce(Package, '{package}') in ('{package}', '{archetype}', 'ALL', 'SYSTEM')
INSERT INTO def_colour_palette (`Palette_name`, `package`, {columns})
VALUES ('{palette_name}', '{package}', {values})
ON DUPLICATE KEY UPDATE {updates};
SELECT * FROM def_colour_palette WHERE Palette_name = 'REFERENCE'
SELECT * FROM def_colour_palette
UPDATE def_colour_palette
SET {updates}
WHERE Palette_name = '{palette_name}'
UPDATE def_colour_palette
SET Palette_name = '{normalized_name}'
WHERE Palette_name = '{original_name}'
SELECT * FROM def_colour_palette
WHERE is_default = 'Y'
AND package = '{package}'
LIMIT 1
UPDATE def_colour_palette
SET is_default = NULL
WHERE package = '{package}'
UPDATE def_colour_palette
SET is_default = 'Y'
WHERE Palette_name = '{palette_name}'
AND package = '{package}'
SELECT * FROM def_colour_palette
WHERE Palette_name = '{palette_name}'
AND package = '{package}'
UNION
SELECT * FROM def_colour_palette
WHERE Palette_name = '{palette_name}'
AND package = 'ALL'
LIMIT 1
SELECT * FROM def_colour_palette
WHERE active = 'Y'
AND package = '{package}'
UNION
SELECT * FROM def_colour_palette
WHERE active = 'Y'
AND package = 'ALL'
LIMIT 1
UPDATE def_colour_palette
SET {updates}
WHERE Palette_name = '{palette_name}'