Migration
unknown
mysql
2 years ago
529 B
2
Indexable
Never
alter table api.users drop constraint users_name_key; alter table api.users drop constraint users_email_key; UPDATE api.validators SET validator = 'SELECT NOT 1 = ANY(SELECT 1 FROM API.USERS U WHERE U.name = $1 AND state != ''ELIMINADO'')' WHERE id = 2; UPDATE api.validators SET validator = 'SELECT NOT 1 = ANY(SELECT 1 FROM API.USERS U WHERE U.email = $1 AND state != ''ELIMINADO'')' WHERE id = 3; UPDATE api.queries SET query = 'INSERT INTO API.USERS VALUES (DEFAULT, $1, $2, $3, ''ELIMINADO'') RETURNING ID' WHERE id = 4;