[PulseGuardian] Add migration to drop owner_id from pulse_users

NEW
Unassigned

Status

2 years ago
2 years ago

People

(Reporter: mcote, Unassigned)

Tracking

Trunk
Points:
---

Firefox Tracking Flags

(Not tracked)

Details

(Reporter)

Description

2 years ago
In bug 1068447 we added a new table, pulse_user_owners, to record owners of pulse users, so that there could be a many-to-many relationship.  However the owner_id column is still in the pulse_users table, unused, which caused me some confusion when I forgot about pulse_user_owners and tried to update owner_id.  We should add a migration to drop that column (and execute it on production).

Note that sqlite doesn't support dropping columns, but sqlite should just be used for local development so migrations aren't particularly important there.  We could add a more complex migration for sqlite that creates a new table without the column, copies the data over, drop the original table, and renames the new table, but I doubt it's worth it.
(Reporter)

Updated

2 years ago
Summary: Add migration to drop owner_id from pulse_users → [PulseGuardian] Add migration to drop owner_id from pulse_users
You need to log in before you can comment on or make changes to this bug.