-- base shop configuration
UPDATE
  oxshops
SET
  oxproductive = 0,
  oxinfoemail = 'shopadmin@dotfly.de',
  oxorderemail = 'shopadmin@dotfly.de',
  oxowneremail = 'shopadmin@dotfly.de',
  oxsmtp = 'wp1157295.mailout.server-he.de',
  oxsmtpuser = 'wp1157295-tmpaccount',
  oxsmtppwd = 'ur2hACOa8R2T';

-- admin password
UPDATE
  oxuser
SET
  oxpassword = '7acdb526a0b63505fd8d610e4eebb6c785c64528077f9e502090371c1d4b2bd5cc8c1b1d5f1783b3faefc57a7489e8143a64a646297c079fc8591ea35a0eacc9',
  oxpasssalt = 'b58d091dadfa0a17249f5b0bd00f5a87'
WHERE
  oxusername = 'shopadmin@dotfly.de';

-- mall urls
UPDATE
  oxconfig
SET
  oxvarvalue = ''
WHERE
  oxvarname IN ('sMallShopURL', 'sMallSSLShopURL');

-- misc
UPDATE
  oxconfig
SET
  oxvarvalue = 0x07
WHERE
  oxvarname IN ('blCheckTemplates', 'iMallMode');

-- content cache
UPDATE
  oxconfig
SET
  oxvarvalue = ''
WHERE
  oxvarname = 'blUseContentCaching';
