magento创建后台用户sql 1.9.2.4+

INSERT INTO `admin_role` VALUES (1,0,1,1,'G',0,'Administrators',1,NULL,NULL); INSERT INTO admin_user SELECT NULL user_id, "fname" firstname, "lname" lastname, "demo@163.com" email, "admin" username, MD5('demodemo') password, NOW() created, NULL modified, NULL logdate, 0 lognum, 0 reload_acl_flag, 1 is_active, NULL extra, NULL rp_token, NOW() rp_token_created_at, NULL failures_num, NULL first_failure, NULL lock_expires; INSERT INTO admin_role SELECT NULL role_id, ( SELECT role_id FROM admin_role WHERE role_name = 'Administrators' ) parent_id, 2 tree_level, 0 sort_order, 'U' role_type, ( SELECT user_id FROM admin_user WHERE username = 'admin' ) user_id, 'fname' role_name, 1 gws_is_all, NULL gws_websites, NULL gws_store_groups;