← All tables

mdl_quizaccess_seb_quizsettings

MIGRATECore learning content / activity / progress / assessment · 29 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

Sign in to update status, owner and notes.

ColumnTypeNullDefaultTarget mappingRisk
idbigintNot nullPreserve as legacy source ID; generate target PK unless target accepts stable legacy key.High: verify semantics/relationship/security
quizidbigintNot nullResolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.High: verify semantics/relationship/security
cmidbigintNot nullResolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.High: verify semantics/relationship/security
templateidbigintNot nullResolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.High: verify semantics/relationship/security
requiresafeexambrowsertinyint(1)Not nullMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
showsebtaskbartinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
showwificontroltinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
showreloadbuttontinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
showtimetinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
showkeyboardlayouttinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
allowuserquitsebtinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
quitpasswordlongtextNullableEXCLUDE from app migration; credential/secret handling requires security review.High: verify semantics/relationship/security
linkquitseblongtextNullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
userconfirmquittinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
enableaudiocontroltinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
muteonstartuptinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
allowspellcheckingtinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
allowreloadinexamtinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
activateurlfilteringtinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
filterembeddedcontenttinyint(1)NullableTransform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.High: verify semantics/relationship/security
expressionsallowedlongtextNullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
regexallowedlongtextNullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
expressionsblockedlongtextNullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
regexblockedlongtextNullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
allowedbrowserexamkeyslongtextNullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
showsebdownloadlinktinyint(1)NullableMap same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
usermodifiedbigintNot null'0'Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.Schema-only inference
timecreatedbigintNot null'0'Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.Schema-only inference
timemodifiedbigintNot null'0'Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.Schema-only inference