Unleash / unleash / 15436347120

86%

master: 91%

Build Type

push

github

Committed by web-flow

Commit Message

feat: make lifecycle trends more detailed (#10079)

## ✨ PR Summary: Update `lifecycle_trends` Table Schema

### ✅ What Changed

- **Updated `stage` column constraint**
- **Old values:** `'initial', 'develop', 'production', 'cleanup',
'archived'`
- **New values:** `'initial', 'pre-live', 'live', 'completed',
'archived'`

- **Replaced `flag_type` CHECK constraint with a foreign key**
  - Removed hardcoded values: `'experimental', 'release', 'permanent'`
  - Added foreign key:
    ```sql
FOREIGN KEY (flag_type) REFERENCES feature_types(id) ON DELETE CASCADE
    ```

- **Added down migration** to:
  - Restore original `stage` constraint
- Drop the foreign key on `flag_type` and re-add the original CHECK
constraint

### 💡 Why

- Align `stage` values with lifecycle model
- Use the `feature_types` table to ensure referential integrity

Run Details

7012 of 7061 branches covered (99.31%)

38 of 38 new or added lines in 1 file covered. (100.0%)

25 existing lines in 4 files now uncovered.

66588 of 72805 relevant lines covered (91.46%)

432.08 hits per line