DELIMITER //

CREATE PROCEDURE CreateTemplate (IN sTemplateName VARCHAR (255))
  BEGIN
    INSERT INTO jos_extensions (name, type, element, client_id, enabled, access, protected, manifest_cache, params, checked_out, checked_out_time, ordering, state) 
      VALUES (sTemplateName, 'template', sTemplateName, 0, 1, 1, 0, '{}', '{}', 0, '0000-00-00 00:00:00', 0, 0);

    INSERT INTO jos_template_styles (template, client_id, home, title, params)
      VALUES (sTemplateName, 0, 0, sTemplateName, '{}');
  END //

DELIMITER ;