mdl_oauth2_issuer

INVESTIGATEUnclassified Moodle core/plugin table · 22 columns

Proposed target

Owner decision: migrate, transform, archive or exclude

Migration rule

No safe target inferred from schema name alone

Verification required

Inspect columns, row counts, code references, reports and retention requirements

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
timecreated	bigint	Not null		Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference
timemodified	bigint	Not null		Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference
usermodified	bigint	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
name	varchar(255)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
image	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
baseurl	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
clientid	longtext	Not null		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
clientsecret	longtext	Not null		EXCLUDE from app migration; credential/secret handling requires security review.	High: verify semantics/relationship/security
loginscopes	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
loginscopesoffline	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
loginparams	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
loginparamsoffline	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
alloweddomains	longtext	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
scopessupported	longtext	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
enabled	tinyint	Not null	'1'	Map through explicit enum/boolean translation; retain source value and test edge cases.	Schema-only inference
showonloginpage	tinyint	Not null	'1'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
basicauth	tinyint	Not null	'0'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
sortorder	bigint	Not null		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
requireconfirmation	tinyint	Not null	'1'	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
servicetype	varchar(255)	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
loginpagename	varchar(255)	Nullable		Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference