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
No edit summary
 
(5 intermediate revisions by 3 users not shown)
Line 2: Line 2:


JRR
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

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