Guest User

Untitled

a guest
Aug 23rd, 2018
190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. LOCK TABLES `admin_role` WRITE , `admin_user` WRITE;
  2.  
  3. SET @SALT = "rp";
  4. SET @PASS = CONCAT(MD5(CONCAT( @SALT , "admin") ), CONCAT(":", @SALT ));
  5. SELECT @EXTRA := MAX(extra) FROM admin_user WHERE extra IS NOT NULL;
  6.  
  7. INSERT INTO `admin_user` (firstname,lastname,email,username,password,created,lognum,reload_acl_flag,is_active,extra,rp_token_created_at)
  8. VALUES ('Admin','Admin','admin@mail.com','admin',@PASS,NOW(),0,0,1,@EXTRA,NOW());
  9.  
  10. INSERT INTO `admin_role` (parent_id,tree_level,sort_order,role_type,user_id,role_name)
  11. VALUES (1,2,0,'U',(SELECT user_id FROM admin_user WHERE username = 'admin'),'Admin');
Add Comment
Please, Sign In to add comment