mdl_assign_overrides

MIGRATECore learning content / activity / progress / assessment · 9 columns

Proposed target

Transform into target course, module, attempt, grade, completion, credential and content models

Migration rule

Preserve history and relationships; retain original IDs in legacy_id fields

Verification required

Plugin behavior, attempt state, grading rules, file references and completion logic require application-level verification

Tracking

Column	Type	Null	Default	Target mapping	Risk
id	bigint	Not null		Preserve as legacy source ID; generate target PK unless target accepts stable legacy key.	High: verify semantics/relationship/security
assignid	bigint	Not null	'0'	Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
groupid	bigint	Nullable		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
userid	bigint	Nullable		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
sortorder	bigint	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
allowsubmissionsfromdate	bigint	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
duedate	bigint	Nullable		Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference
cutoffdate	bigint	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
timelimit	bigint	Nullable		Map through explicit enum/boolean translation; retain source value and test edge cases.	Schema-only inference