Skip to content

Instantly share code, notes, and snippets.

@Luke-23ae
Created November 15, 2010 15:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Luke-23ae/9f809113cc11eb56a765 to your computer and use it in GitHub Desktop.
Save Luke-23ae/9f809113cc11eb56a765 to your computer and use it in GitHub Desktop.
INSERT INTO builder_template_setting (`type`, `template_id`, `name`, `value`, `category_id`, `options`)
VALUES
('0', 20, 'builder_cfg_page_title', 'Seitentitel 1', '', ''),
('0', 20, 'builder_css_title_color', '#a9cc64', '', ''),
('0', 20, 'builder_css_title_font', '\'Times New Roman\', Times, serif', '', ''),
('0', 20, 'builder_css_title_size', '64.81927710843374', '', ''),
('0', 20, 'builder_css_title_vert_pos_three', '112', '', ''),
('0', 20, 'builder_css_title_hor_pos_three', '218', '', '')
ON DUPLICATE KEY UPDATE
value=VALUES(value),
type=IF(VALUES(type)='',type,VALUES(type)),
category_id=IF(VALUES(category_id)='',category_id,VALUES(category_id)),
options=IF(VALUES(options)='',options,VALUES(options))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment