19 lines
600 B
SQL
19 lines
600 B
SQL
-- Rollback migration: Remove ISO timestamp columns
|
|
|
|
-- Drop triggers
|
|
DROP TRIGGER IF EXISTS trigger_transactions_timestamp_iso ON transactions;
|
|
DROP TRIGGER IF EXISTS trigger_blocks_timestamp_iso ON blocks;
|
|
|
|
-- Drop functions
|
|
DROP FUNCTION IF EXISTS update_transaction_timestamp_iso();
|
|
DROP FUNCTION IF EXISTS update_timestamp_iso();
|
|
|
|
-- Drop indexes
|
|
DROP INDEX IF EXISTS idx_transactions_chain_timestamp_iso;
|
|
DROP INDEX IF EXISTS idx_blocks_chain_timestamp_iso;
|
|
|
|
-- Drop columns
|
|
ALTER TABLE transactions DROP COLUMN IF EXISTS timestamp_iso;
|
|
ALTER TABLE blocks DROP COLUMN IF EXISTS timestamp_iso;
|
|
|