Guest User

Untitled

a guest
Jul 3rd, 2025
237
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.36 KB | None | 0 0
  1. UPDATE users
  2. SET role_id = 1
  3. WHERE email = '[email protected]';
  4.  
  5. INSERT INTO model_has_roles (role_id, model_type, model_id)
  6. SELECT 1, 'App\\Model\\User', id
  7. FROM users
  8. WHERE email = '[email protected]'
  9.   AND NOT EXISTS (
  10.       SELECT 1 FROM model_has_roles
  11.       WHERE model_id = users.id
  12.       AND role_id = 1
  13.       AND model_type = 'App\\Model\\User'
  14.   );
Advertisement
Add Comment
Please, Sign In to add comment