Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE users
- SET role_id = 1
- INSERT INTO model_has_roles (role_id, model_type, model_id)
- SELECT 1, 'App\\Model\\User', id
- FROM users
- AND NOT EXISTS (
- SELECT 1 FROM model_has_roles
- WHERE model_id = users.id
- AND role_id = 1
- AND model_type = 'App\\Model\\User'
- );
Advertisement
Add Comment
Please, Sign In to add comment