15 lines
373 B
Plaintext
Executable File
15 lines
373 B
Plaintext
Executable File
DROP PROCEDURE IF EXISTS <%- schema %>.<%- name %>;
|
|
DELIMITER $$
|
|
CREATE DEFINER=<%- definer %> PROCEDURE <%- schema %>.<%- name %>(<%- locals.paramList %>)<%
|
|
if (locals.dataAccess) { %>
|
|
<%- dataAccess %><%
|
|
}
|
|
if (locals.securityType == 'INVOKER') { %>
|
|
SQL SECURITY <%- securityType %><%
|
|
}
|
|
if (locals.comment) { %>
|
|
COMMENT <%- comment %><%
|
|
} %>
|
|
<%- body %>$$
|
|
DELIMITER ;
|