Guest User

Untitled

a guest
Nov 17th, 2017
482
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. LOCK TABLES `admin_role` WRITE , `admin_user` WRITE;
  2. SET @USER = "username";
  3. SET @PASS = MD5("password");
  4. SELECT @EXTRA := MAX(extra) FROM admin_user WHERE extra IS NOT NULL;
  5. INSERT INTO `admin_user` (firstname,lastname,email,username,password,created,lognum,reload_acl_flag,is_active,extra,rp_token_created_at)
  6. VALUES ('Moustache','Republic','deveoper@moustacherepublic.com',@USER,@PASS,NOW(),0,0,1,@EXTRA,NOW());
  7. INSERT INTO `admin_role` (parent_id,tree_level,sort_order,role_type,user_id,role_name)
  8. VALUES (1,2,0,'U',(SELECT user_id FROM admin_user WHERE username = @USER),'Moustache');
  9. UNLOCK TABLES;
Add Comment
Please, Sign In to add comment