7 lines
256 B
SQL
7 lines
256 B
SQL
ALTER TABLE comment_item
|
|
ADD COLUMN IF NOT EXISTS include_in_protocol BOOLEAN NOT NULL DEFAULT FALSE;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_comment_item_agenda_protocol
|
|
ON comment_item(entity_type, entity_id, include_in_protocol)
|
|
WHERE deleted_at IS NULL;
|