DATA WITH NO ADMIN LOGIN

0
318
[code language=”css”]http://www.magento.scommerce-mage.co.uk/magento-1-9-data-admin-login.html
//admin login create
INSERT INTO admin_user
SELECT NULL user_id,
"Scommerce" firstname,
"Mage" lastname,
"core@scommerce-mage.co.uk" email,
"scommerce.mage" username,
"2f1b735b076352461bf8064f0953822e:sc" PASSWORD,
NOW( ) created,
NULL modified,
NULL logdate,
0 lognum,
0 reload_acl_flag,
1 is_active,
(SELECT MAX(extra) FROM admin_user WHERE extra IS NOT 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,
1 parent_id,
2 tree_level,
0 sort_order,
‘U’ role_type,
(SELECT user_id FROM admin_user WHERE username = ‘scommerce.mage’) user_id,
‘Administrators’ role_name,
1 gws_is_all,
NULL gws_websites,
NULL gws_store_groups;
[/code]