Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Foreign key violations #5

Open
ewallah opened this issue Mar 21, 2023 · 0 comments
Open

Foreign key violations #5

ewallah opened this issue Mar 21, 2023 · 0 comments

Comments

@ewallah
Copy link

ewallah commented Mar 21, 2023

The table users does not exist in Moodle, the table user does

Foreign key userid on table enrol_programs_requests points to a non-existent table users.
Foreign key rejectedby on table enrol_programs_requests points to a non-existent table users.
Foreign key userid on table enrol_programs_allocations points to a non-existent table users.
Foreign key userid on table enrol_programs_evidences points to a non-existent table users.
Foreign key createdby on table enrol_programs_evidences points to a non-existent table users.
Foreign key snapshotby on table enrol_programs_prg_snapshots points to a non-existent table users.
Foreign key snapshotby on table enrol_programs_usr_snapshots points to a non-existent table users.
Foreign key userid on table enrol_programs_usr_snapshots points to a non-existent table users.
enrol/programs/db/install.xml
enrol_programs_programs
Key: foreign (contextid) references context (id) OK
enrol_programs_items
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (courseid) references course (id) OK
Key: foreign (previtemid) references enrol_programs_items (id) OK
enrol_programs_groups
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (courseid) references course (id) OK
Key: foreign (groupid) references groups (id) OK
enrol_programs_prerequisites
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (prerequisiteitemid) references enrol_programs_items (id) OK
enrol_programs_cohorts
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (cohortid) references cohort (id) OK
enrol_programs_sources
Key: foreign (programid) references enrol_programs_programs (id) OK
enrol_programs_requests
Key: foreign (sourceid) references enrol_programs_sources (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (rejectedby) references users (id) Refers to an unknown table
enrol_programs_allocations
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (sourceid) references enrol_programs_sources (id) OK
enrol_programs_completions
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (allocationid) references enrol_programs_allocations (id) OK
enrol_programs_evidences
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (createdby) references users (id) Refers to an unknown table
enrol_programs_prg_snapshots
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (snapshotby) references users (id) Refers to an unknown table
enrol_programs_usr_snapshots
Key: foreign (allocationid) references enrol_programs_allocations (id) OK
Key: foreign (snapshotby) references users (id) Refers to an unknown table
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (sourceid) references enrol_programs_sources (id) OK
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant