Magento 1 Create Admin User DB queries

magento_1_create_admin.sql

SET @LOGIN_PW  = "password_goes_here";
SET @USERNAME  = "username_goes_here";
SET @FIRSTNAME = "Test";
SET @LASTNAME  = "Tester";
SET @EMAIL     = '[email protected]';

SET @SALT = "rp";
SET @PASS = CONCAT(MD5(CONCAT( @SALT , @LOGIN_PW) ), CONCAT(":", @SALT ));
SELECT @EXTRA := MAX(extra) FROM admin_user WHERE extra IS NOT NULL;

INSERT INTO `admin_user` (firstname,lastname,email,username,password,created,lognum,reload_acl_flag,is_active,extra,rp_token_created_at) 
VALUES (@FIRSTNAME,@LASTNAME,@EMAIL,@USERNAME,@PASS,NOW(),0,0,1,@EXTRA,NOW());

INSERT INTO `admin_role` (parent_id,tree_level,sort_order,role_type,user_id,role_name) 
VALUES (1,2,0,'U',(SELECT user_id FROM admin_user WHERE username = @USERNAME),@FIRSTNAME);