I write originally (In mysql workbanch because heidisql does not have live syntax check yet but thats not critical probem):
CREATE DEFINER=`root`@`localhost` PROCEDURE `transfer_win_free`(
IN free_user INTEGER,
IN free_provider SMALLINT,
IN free_game SMALLINT,
IN free_round BIGINT,
IN free_currency SMALLINT,
IN free_amount DECIMAL(23,9),
OUT return_result DECIMAL(23,9)
)
MODIFIES SQL DATA
COMMENT 'RETURNS CURRENT BALANCE'
And HeidiSQL Reformats it like:
CREATE DEFINER=`root`@`localhost` PROCEDURE `transfer_win_free`(IN `free_user` INTEGER, IN `free_provider` SMALLINT, IN `free_game` SMALLINT, IN `free_round` BIGINT, IN `free_currency` SMALLINT, IN `free_amount` DECIMAL(23,9), OUT `return_result` DECIMAL(23,9)
)
LANGUAGE SQL
NOT DETERMINISTIC
MODIFIES SQL DATA
SQL SECURITY DEFINER
COMMENT 'RETURNS CURRENT BALANCE'
Is it possible to do not reformat stored routine header ?
At least all I care about is that I can not read that input params when they are on same line.
And the best thing would be If you allow me to edit entire routine including header by myself imagine If I were allowed to edit in create code texbox.