You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ALTER TABLE contracts_v2 ADD COLUMN proof_height INTEGER NOT NULL;
ALTER TABLE contracts_v2 ADD COLUMN expiration_height INTEGER NOT NULL;
ALTER TABLE contracts_v2 DROP COLUMN window_start;
ALTER TABLE contracts_v2 DROP COLUMN window_end;
DROP INDEX contracts_v2_window_start;
DROP INDEX contracts_v2_window_end;
DROP INDEX contracts_v2_confirmation_index_resolution_index_window_start;
DROP INDEX contracts_v2_confirmation_index_resolution_index_window_end;
DROP INDEX contracts_v2_confirmation_index_window_start;
CREATE INDEX contracts_v2_proof_height ON contracts_v2(proof_height);
CREATE INDEX contracts_v2_expiration_height ON contracts_v2(expiration_height);
CREATE INDEX contracts_v2_confirmation_index_resolution_index_proof_height ON contracts_v2(confirmation_index, resolution_index, proof_height);
CREATE INDEX contracts_v2_confirmation_index_resolution_index_expiration_height ON contracts_v2(confirmation_index, resolution_index, expiration_height);
CREATE INDEX contracts_v2_confirmation_index_proof_height ON contracts_v2(confirmation_index, proof_height);
Expected Behavior
indexes should be dropped before altering tables.
Steps to Reproduce
No response
Version
master
What operating system did the problem occur on (e.g. Ubuntu 22.04, macOS 12.0, Windows 11)?
Linux Docker
Anything else?
No response
The text was updated successfully, but these errors were encountered:
Current Behavior
db migration from 31 to 32
ALTER TABLE contracts_v2 ADD COLUMN proof_height INTEGER NOT NULL;
ALTER TABLE contracts_v2 ADD COLUMN expiration_height INTEGER NOT NULL;
ALTER TABLE contracts_v2 DROP COLUMN window_start;
ALTER TABLE contracts_v2 DROP COLUMN window_end;
DROP INDEX contracts_v2_window_start;
DROP INDEX contracts_v2_window_end;
DROP INDEX contracts_v2_confirmation_index_resolution_index_window_start;
DROP INDEX contracts_v2_confirmation_index_resolution_index_window_end;
DROP INDEX contracts_v2_confirmation_index_window_start;
CREATE INDEX contracts_v2_proof_height ON contracts_v2(proof_height);
CREATE INDEX contracts_v2_expiration_height ON contracts_v2(expiration_height);
CREATE INDEX contracts_v2_confirmation_index_resolution_index_proof_height ON contracts_v2(confirmation_index, resolution_index, proof_height);
CREATE INDEX contracts_v2_confirmation_index_resolution_index_expiration_height ON contracts_v2(confirmation_index, resolution_index, expiration_height);
CREATE INDEX contracts_v2_confirmation_index_proof_height ON contracts_v2(confirmation_index, proof_height);
Expected Behavior
indexes should be dropped before altering tables.
Steps to Reproduce
No response
Version
master
What operating system did the problem occur on (e.g. Ubuntu 22.04, macOS 12.0, Windows 11)?
Linux Docker
Anything else?
No response
The text was updated successfully, but these errors were encountered: