Форум пользователей MySQL

CREATE FUNCTION `CREATE_ARTICLE_USERS_GRANT`(table_prefix TINYTEXT, table_name TINYTEXT, idnr_field_name TINYTEXT, user_login_field_name TINYTEXT, root_user TINYTEXT)
RETURNS INT
LANGUAGE SQL
 BEGIN
  DECLARE root_user_id INT;
  DECLARE selected_id INT DEFAULT 0;
  DECLARE new_table_name TINYTEXT;
  DECLARE counter INT;
  DECLARE i INT DEFAULT 0;

  SET root_user_id = (SELECT idnr_field FROM table_name WHERE user_login_field_name = root_user LIMIT 1);
  SET new_table_name = CONCAT(table_prefix, "_article_users_grant");
  SET counter = (SELECT count(idnr_field_name) FROM table_name WHERE idnr_field_name <> root_user_id LIMIT 1);

  CREATE TABLE new_table_name (
                               `user_id` MEDIUMINT UNSIGNED NOT NULL,
                               `article_grants_id` TINYINT( 1 ) UNSIGNED NOT NULL ,
                                PRIMARY KEY ( `user_id` ) ,INDEX ( `article_grants_id` )
                              );

  INSERT INTO new_table_name ( `user_id` , `article_grants_id` )
         VALUES (root_user_id, "1");
   WHILE i < counter DO
    SET i = i +1;
    SET selected_id = (SELECT idnr_field FROM table_name WHERE idnr_field_name > selected_id AND  idnr_field_name <> root_user_id ORDER BY idnr_field_name ASC LIMIT 1);
    INSERT INTO new_table_name ( `user_id` , `article_grants_id` )
         VALUES (selected_id, "5");
   END WHILE;
   RETURN selected_id;
 END;