10 February 2009, 14:58

Hi Everybody!

I would like to know if there is a way to see the database structure (tables, fields, etc) of mahara, without having to install it.

Thanks in advance.

10 February 2009, 16:30

Hi - so far I don't think anybody has bothered to generate a pretty picture of the schema. But the XML definition of the database that XMLDB uses to install it is available at htdocs/lib/db/install.xml. There are other tables in XML files in the various plugins too:

 nigel@mahara-trunk:~/mahara/htdocs$ find | grep install.xml
./artefact/blog/db/install.xml
./artefact/file/db/install.xml
./artefact/internal/db/install.xml
./artefact/resume/db/install.xml
./lib/db/install.xml
./notification/emaildigest/db/install.xml
./notification/internal/db/install.xml
./blocktype/externalfeed/db/install.xml
./blocktype/wall/db/install.xml
./interaction/forum/db/install.xml

They might help - but the easiest way is probably to install Mahara and generate a picture from the result.

10 February 2009, 16:42