bcgov / bcgov/SIMS

Remove the offering column added for rollback purpose

Open Beginner friendly
#6,516 0 comments 0 reactions 0 assignees View on GitHub
DB Task
Dominant language
TypeScript
Stars
29
Forks
15
PR merge metrics
No merged PRs in 30d

Description

**Describe the task**
During the implementation of the hotfix ticket #6161 a column was added to offerings table to copy the study_breaks calculated values to perform rollback. After few sprints from `Hotfix v4.0.1` this column must be remove as a part of cleanup.

**Acceptance Criteria**
- [ ] Remove the column `study_breaks_before_update` from sims.education_programs_offerings and sims.education_programs_offerings_history.

Contributor guide

No contributing guide indexed for this repository

Research direction

Locate the database schema or migration definitions for sims.education_programs_offerings and sims.education_programs_offerings_history, then inspect how the rollback column was added. Remove study_breaks_before_update from both tables and verify that the schema no longer contains either column.

Written by the indexing model from the issue text.

Assessment

Domain
database
Issue type
Refactor
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Active
Clarity
Clearly specified
Newbie friendliness
78/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.