Hello,
I am trying to located where the Moodle "course" tables are located. I need to add two fields to the "course" table and see if it will automatically install with the rest of the course tables. This will let me know if some code changes I made will works
Thanks in advance.
WP1
WP,
Your database should have a name like servername_mdle1(whatever you called it at setup) and will be located on the servers MySQL database spelled out in your config.php file. If you don't have root access, you probably won't be able to see the database directory. Tables are prefixed with mdl_ and then a name. There are several tables you may be concerned with, including:
- mdl_course
- mdl_course_categories
- mdl_course_display
- mdl_course_modules
- mdl_course_sections
The easiest way to manipulate your Moodle database is by using that great little gizmo Martin has included in the Modules and Add-ons area called MySQL Admin 1.2. If you have cPanel access on your server, you probably also have access to phpMyAdmin, which is the same thing. You should be able to easily add the two fields for your development project.
Good luck,
Bryan