Note:

If you want to create a new page for developers, you should create it on the Moodle Developer Resource site.

Talk:Database Schema: Difference between revisions

From MoodleDocs
No edit summary
 
(4 intermediate revisions by 3 users not shown)
Line 3: Line 3:
JRR
JRR


== problem importing 1.8 data strucutre file into MySQL workbench  ==
 
Download link is not working.
-Dorian
 
None of the links to RAR files appear to be working and getting a 1.9 would be REALLY helpful. Surely someone has one of these somewhere?
Mark H.
 
== problem importing 1.8 data structure file into MySQL workbench  ==


Comment:
Comment:
Line 18: Line 25:


LP
LP
Downloaded and installed DB Designer4.
Downloaded and saved the moodle_1.8_data_structure.rar.
Opened DB Designer and couldn't "Import" anything except .xml files.
Gave up - for now.
SK

Latest revision as of 19:00, 16 February 2011

Note: You can't right-click and download the link: click on it and download the .rar file. Right-click/download results in a corrupted file that can't be unRar'ed.

JRR


Download link is not working. -Dorian

None of the links to RAR files appear to be working and getting a 1.9 would be REALLY helpful. Surely someone has one of these somewhere? Mark H.

problem importing 1.8 data structure file into MySQL workbench

Comment: The data structure file here does not import successfully into MySQL workbench 5 (which replaced DBDesigner4) http://moodle.org/file.php/5/moddata/forum/28/376698/moodle_1.8_data_structure.rar the import gets partway through then give this error:-

  Type mismatch expected type INT but got STRING 

(To get round this I imported into DBDesigner4 then generated a create script then brought that into MySQL Workbench.)

It would be very helpful to have the 1.9+ data model as XML or (preferably) the create script.

LP

Downloaded and installed DB Designer4. Downloaded and saved the moodle_1.8_data_structure.rar. Opened DB Designer and couldn't "Import" anything except .xml files. Gave up - for now. SK