Kopiert Theme-Einstellungen von Azure Theme zu eigenem Theme (Oxid-Kochbuch)

copy-OXIDthemeOptions.sql

SET @sourceTheme='theme:azure';
SET @targetTheme='theme:kochbuch';
INSERT INTO oxconfig (OXID, OXSHOPID, OXMODULE, OXVARNAME, OXVARTYPE, OXVARVALUE )
(SELECT UUID(), OXSHOPID, @targetTheme, OXVARNAME, OXVARTYPE, OXVARVALUE FROM oxconfig WHERE OXMODULE = @sourceTheme);
INSERT INTO oxconfigdisplay (OXID, OXCFGMODULE, OXCFGVARNAME, OXGROUPING, OXVARCONSTRAINT, OXPOS)
(SELECT UUID(), @targetTheme,OXCFGVARNAME, OXGROUPING, OXVARCONSTRAINT, OXPOS FROM oxconfigdisplay WHERE OXCFGMODULE = @sourceTheme);