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;