CREATE TABLE `def_image` (
`ImageCode` char(255) NOT NULL,
`Package` char(255) NOT NULL,
`Module` VARCHAR(255) DEFAULT NULL,
`BaseFolder` char(255) DEFAULT NULL,
`Description` text DEFAULT NULL,
`ImageData` text DEFAULT NULL,
`MasterImage` text DEFAULT NULL,
`Width` int(11) DEFAULT NULL,
`Height` int(11) DEFAULT NULL,
`ResizeWidth` int(11) DEFAULT 0,
`ResizeHeight` int(11) DEFAULT 0,
`XOffset` int(11) DEFAULT 0,
`YOffset` int(11) DEFAULT 0,
`Format` char(50) DEFAULT NULL,
`GenerateMethod` char(255) DEFAULT NULL,
`GenerateFont` char(255) DEFAULT NULL,
`GenerateSql` text DEFAULT NULL,
PRIMARY KEY (`ImageCode`,`Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation}
CREATE TABLE `def_image_overlay` (
`ImageCode` varchar(191) NOT NULL,
`OverlayCode` varchar(191) NOT NULL,
`Package` varchar(191) NOT NULL,
`Module` VARCHAR(255) DEFAULT NULL,
`Rank` int(11) DEFAULT NULL,
PRIMARY KEY (`ImageCode`,`OverlayCode`,`Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation} ROW_FORMAT=DYNAMIC
SELECT * FROM def_image
WHERE coalesce(Package, '{package}') in ('{package}', '{archetype}', 'ALL', 'SYSTEM')
AND ImageCode = '{image_code}'
SELECT OverlayCode FROM def_image_overlay
WHERE coalesce(Package, 'ALL') in ('{package}', '{archetype}', 'ALL', 'SYSTEM')
AND ImageCode = '{image_code}'
ORDER BY rank