Migration

avatar
unknown
mysql
3 years ago
529 B
3
Indexable
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;