mdl_editor_atto_autosave

REBUILDMoodle configuration / presentation / plugin settings · 9 columns

Proposed target

Reimplement required settings in Lovable backend/config; do not bulk-copy configuration rows

Migration rule

Moodle-specific settings rarely map 1:1 to a new app

Verification required

Review site config, themes, roles/capabilities, plugin defaults and operational runbooks

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
elementid	varchar(255)	Not null	''	Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
contextid	bigint	Not null		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
pagehash	varchar(64)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
userid	bigint	Not null		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
drafttext	longtext	Not null		Transform text/JSON/HTML as appropriate; sanitize and rewrite embedded Moodle URLs/file references.	Schema-only inference
draftid	bigint	Nullable		Resolve to target foreign key via source-ID crosswalk; do not assume numeric IDs match target IDs.	High: verify semantics/relationship/security
pageinstance	varchar(64)	Not null	''	Map same-named field where semantics match; confirm target type, nullability, defaults and business meaning.	Schema-only inference
timemodified	bigint	Not null	'0'	Convert Unix epoch to UTC timestamp; verify 0/null sentinel and date semantics.	Schema-only inference