8 lines
265 B
MySQL
8 lines
265 B
MySQL
|
-- Migration 131: Add group assignment to sager
|
||
|
|
|
||
|
|
ALTER TABLE sag_sager
|
||
|
|
ADD COLUMN IF NOT EXISTS assigned_group_id INTEGER REFERENCES groups(id) ON DELETE SET NULL;
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_sag_sager_assigned_group_id
|
||
|
|
ON sag_sager(assigned_group_id);
|