Development talk:Database Schema: Difference between revisions
Linda Petty (talk | contribs) mNo edit summary |
No edit summary |
||
Line 18: | Line 18: | ||
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. |
Revision as of 19:23, 20 July 2009
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
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.