Alberto Giampani and Dario Toledo have put together the DB Schemas for Moodle 1.5.3 and 1.7. They've posted them in the Developers forum in the Moodle En Español course, and I've drafted a very simple page in the wiki for the files here http://docs.moodle.org/en/Development:Database_Schema
The files are in DBDesigner4 format -- it is a nice GPL program, and the file format itself is quite readable XML. As Eloy was saying in this thread http://moodle.org/mod/forum/discuss.php?d=58070 -- we may be able to skip manual work and just have an XML transform from the new XMLDB files to DBDesigner files.
The wiki page probably needs some work to flesh out interesting details, data... and if you have schemas for other versions, please post them there!
To save everyone the obvious Google query, the DBDesigner4 web site is http://www.fabforce.net/dbdesigner4/
I've tried downloading the schemas linked from the wiki, get the following error messages extracting them with winRar. It's the same with the 1.7 file.
! db-edudist-assigment-moodle153.xml: The file "db-edudist-assigment-moodle153.xml" header is corrupt
! db-edudist-backup-moodle153.xml: The file "db-edudist-backup-moodle153.xml" header is corrupt
! db-edudist-block-moodle153.xml: The file "db-edudist-block-moodle153.xml" header is corrupt
! db-edudist-cache-moodle153.xml: The file "db-edudist-cache-moodle153.xml" header is corrupt
! db-edudist-chat-moodle153.xml: The file "db-edudist-chat-moodle153.xml" header is corrupt
! db-edudist-choice-moodle153.xml: The file "db-edudist-choice-moodle153.xml" header is corrupt
! db-edudist-config-moodle153.xml: The file "db-edudist-config-moodle153.xml" header is corrupt
! db-edudist-course-moodle153.xml: The file "db-edudist-course-moodle153.xml" header is corrupt
! db-edudist-enrol-moodle153.xml: The file "db-edudist-enrol-moodle153.xml" header is corrupt
! db-edudist-forum-moodle153.xml: The file "db-edudist-forum-moodle153.xml" header is corrupt
! db-edudist-glosary-moodle153.xml: The file "db-edudist-glosary-moodle153.xml" header is corrupt
! db-edudist-grade-moodle153.xml: The file "db-edudist-grade-moodle153.xml" header is corrupt
! db-edudist-groups-moodle153.xml: The file "db-edudist-groups-moodle153.xml" header is corrupt
! db-edudist-hotpot-moodle153.xml: The file "db-edudist-hotpot-moodle153.xml" header is corrupt
! db-edudist-journal-moodle153.xml: The file "db-edudist-journal-moodle153.xml" header is corrupt
! db-edudist-lesson-moodle153.xml: The file "db-edudist-lesson-moodle153.xml" header is corrupt
! db-edudist-message-moodle153.xml: The file "db-edudist-message-moodle153.xml" header is corrupt
! db-edudist-quiz-moodle153.xml: The file "db-edudist-quiz-moodle153.xml" header is corrupt
! db-edudist-scorm-moodle153.xml: The file "db-edudist-scorm-moodle153.xml" header is corrupt
! db-edudist-survey-moodle153.xml: The file "db-edudist-survey-moodle153.xml" header is corrupt
! db-edudist-user-moodle153.xml: The file "db-edudist-user-moodle153.xml" header is corrupt
! db-edudist-wiki-moodle153.xml: The file "db-edudist-wiki-moodle153.xml" header is corrupt
! db-edudist-worlshop-moodle153.xml: The file "db-edudist-worlshop-moodle153.xml" header is corrupt
! db-edudist-assigment-moodle153.xml: The file "db-edudist-assigment-moodle153.xml" header is corrupt
! db-edudist-backup-moodle153.xml: The file "db-edudist-backup-moodle153.xml" header is corrupt
! db-edudist-block-moodle153.xml: The file "db-edudist-block-moodle153.xml" header is corrupt
! db-edudist-cache-moodle153.xml: The file "db-edudist-cache-moodle153.xml" header is corrupt
! db-edudist-chat-moodle153.xml: The file "db-edudist-chat-moodle153.xml" header is corrupt
! db-edudist-choice-moodle153.xml: The file "db-edudist-choice-moodle153.xml" header is corrupt
! db-edudist-config-moodle153.xml: The file "db-edudist-config-moodle153.xml" header is corrupt
! db-edudist-course-moodle153.xml: The file "db-edudist-course-moodle153.xml" header is corrupt
! db-edudist-enrol-moodle153.xml: The file "db-edudist-enrol-moodle153.xml" header is corrupt
! db-edudist-forum-moodle153.xml: The file "db-edudist-forum-moodle153.xml" header is corrupt
! db-edudist-glosary-moodle153.xml: The file "db-edudist-glosary-moodle153.xml" header is corrupt
! db-edudist-grade-moodle153.xml: The file "db-edudist-grade-moodle153.xml" header is corrupt
! db-edudist-groups-moodle153.xml: The file "db-edudist-groups-moodle153.xml" header is corrupt
! db-edudist-hotpot-moodle153.xml: The file "db-edudist-hotpot-moodle153.xml" header is corrupt
! db-edudist-journal-moodle153.xml: The file "db-edudist-journal-moodle153.xml" header is corrupt
! db-edudist-lesson-moodle153.xml: The file "db-edudist-lesson-moodle153.xml" header is corrupt
! db-edudist-message-moodle153.xml: The file "db-edudist-message-moodle153.xml" header is corrupt
! db-edudist-quiz-moodle153.xml: The file "db-edudist-quiz-moodle153.xml" header is corrupt
! db-edudist-scorm-moodle153.xml: The file "db-edudist-scorm-moodle153.xml" header is corrupt
! db-edudist-survey-moodle153.xml: The file "db-edudist-survey-moodle153.xml" header is corrupt
! db-edudist-user-moodle153.xml: The file "db-edudist-user-moodle153.xml" header is corrupt
! db-edudist-wiki-moodle153.xml: The file "db-edudist-wiki-moodle153.xml" header is corrupt
! db-edudist-worlshop-moodle153.xml: The file "db-edudist-worlshop-moodle153.xml" header is corrupt
Strange - I managed to unrar them ok on my Mac using commandline RAR. Ah, I think I know -- if you follow the link, #moodle will probably ask you to enrol to the Moodle en Español course before you get the file. Maybe you right-clicked and saved the HTML page instead?
(Yes, we have to move the file elsewhere
)
(Yes, we have to move the file elsewhere
I'm pretty sure it's the .rar file I am downloading. The error happens in winRAR 2.8. I've tried downloading using IE6 and Firefox 2 on XPhome. I don't get asked to enrol, just go directly to download. I'm tempted to think it's a mac/pc issue but I'd just be guessing. Anyone else have errors on a PC?
I was also getting the header corrupt error and couldn't extract the file using PowerArchiver2000. I used UnRAR and retrieved the files using the command line. (unrar e <filename>)
Thanks,
Matt
Thanks,
Matt
OK I have it extracted now using UnRar for Windows 2.0 (GUI not commandline).
Thanks
Thanks