Not sure if this is the right forum for this topic but I am seeking help with a database query.
We previously had courses created through courseupload.php with 'manual' and 'self' defined as enrollment methods in the CSV along with a enrollment key. Participants are added to courses from a flatfile but it was also possible to self enroll if the key was known. This process has been modified to still include self enrollment as an option but disable it for newly created courses.
I'm wondering if there's a way to identify courses where self enrollment is enabled and disable that enrollment method for the course in the database. Having trouble finding the right tables to get/modify this info and hoping someone might be able to point me in the right direction.
Moodle version is 3.11 and database is MariaDB 10.5.9.