Database structure

Joomla! Documentation Workgroup
pdemaers
Joomla! Apprentice
Joomla! Apprentice
Posts: 45
Joined: Mon Apr 24, 2006 1:25 pm
Location: Grimbergen, Belgium
Contact:

Database structure

Postby pdemaers » Tue Apr 25, 2006 10:55 am

Hi,

is there any document showing the full Joomla database structure ? I guess I can install Joomla and do an export of the table creation scripts via MySQL, but I was hoping something more complete exists already, maybe with some explanatory notes for the tables and fields ?

Thanks,

Patrick
This post is made of 100% recycled electrons ...

User avatar
visionspin
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 183
Joined: Mon Aug 22, 2005 9:35 pm
Location: Pittsburgh, PA
Contact:

Re: Database structure

Postby visionspin » Tue Apr 25, 2006 3:38 pm

Hey guys, I moved this over to your realm as I am guessing that you guys have more understanding of the database tables and fields.

AmyStephen

Re: Database structure

Postby AmyStephen » Wed Apr 26, 2006 12:56 pm

Torkil has documented v 1.5 < http://forum.joomla.org/index.php/topic,55622.0.html >

I posted a diagram of v 1.0 that I found somewhere some time ago here: < http://forum.joomla.org/index.php/topic,54850.0.html >

There are only minor changes between the two releases.

Thanks!
Amy

User avatar
DanielMD
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 203
Joined: Thu Apr 13, 2006 9:46 pm
Location: Lisbon
Contact:

Re: Database structure

Postby DanielMD » Wed Apr 26, 2006 4:39 pm

wow this is sweet great resource, this should be stiky stiky
-> Documentation is the key to Joomla sucess if you have the time contribute to the Documentation Team
Check out: Joomla Video Tutorials @ http://joejoomla.com/index.php?option=c ... &Itemid=87

pdemaers
Joomla! Apprentice
Joomla! Apprentice
Posts: 45
Joined: Mon Apr 24, 2006 1:25 pm
Location: Grimbergen, Belgium
Contact:

Re: Database structure

Postby pdemaers » Tue May 02, 2006 7:27 pm

Hi,

yes, the diagram is indeed fantastic !! Made me look into dbdesigner (currently known as mysql workbench) and install it myself.

I was just wondering if a graphical representation is enough as documentation. Would a text based document with detailed description of each table, field, primary and foreign key not be more flexible ? If this is something the documentation team would like to consider, I would me more then happy to offer some of my time to get involved.

Kind regards,

Patrick
This post is made of 100% recycled electrons ...

User avatar
Chris Davenport
Joomla! Ace
Joomla! Ace
Posts: 1382
Joined: Thu Aug 18, 2005 8:57 am
Location: Shrewsbury, Shropshire, United Kingdom

Re: Database structure

Postby Chris Davenport » Wed May 03, 2006 2:35 pm

Hi Patrick,

Yes, we would certainly consider a contribution along the lines you suggested.  At the moment we are pretty focussed on getting the 1.5 API documented and so database issues are taking a bit of a back seat. :'(  Perhaps you could put together a sample of what you have in mind and submit it here: http://forum.joomla.org/index.php/board,287.0.htmll then we can see how we might integrate it with the existing docs.  I'm thinking maybe one page per table, plus some overview pages, but maybe you have other ideas.  Is this something you could do on your own, or would you need others to assist?

Regards,
Chris.
Chris Davenport - Joomla Production Leadership Team

Lion Coppice http://www.lioncoppice.org/
Davenport Technology Services http://www.davenporttechnology.com/


Return to “Documentation - Feedback/Information/Suggestions”

Who is online

Users browsing this forum: No registered users and 4 guests