35908-vm/db/migrations/003_add_note_id_to_alarms.sql
2025-11-21 19:17:14 +00:00

1 line
135 B
SQL

ALTER TABLE alarms ADD COLUMN note_id INT NULL, ADD CONSTRAINT fk_note_id FOREIGN KEY (note_id) REFERENCES notes(id) ON DELETE CASCADE;