The Joomla! Forum ™






Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Database structure
PostPosted: Tue Apr 25, 2006 10:55 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Apr 24, 2006 1:25 pm
Posts: 45
Location: Grimbergen, Belgium
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 ...


Top
 Profile  
 
 Post subject: Re: Database structure
PostPosted: Tue Apr 25, 2006 3:38 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Mon Aug 22, 2005 9:35 pm
Posts: 183
Location: Pittsburgh, PA
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.


Top
 Profile  
 
 Post subject: Re: Database structure
PostPosted: 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


Top
  
 
 Post subject: Re: Database structure
PostPosted: Wed Apr 26, 2006 4:39 pm 
User avatar
Joomla! Enthusiast
Joomla! Enthusiast

Joined: Thu Apr 13, 2006 9:46 pm
Posts: 203
Location: Lisbon
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


Top
 Profile  
 
 Post subject: Re: Database structure
PostPosted: Tue May 02, 2006 7:27 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Apr 24, 2006 1:25 pm
Posts: 45
Location: Grimbergen, Belgium
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 ...


Top
 Profile  
 
 Post subject: Re: Database structure
PostPosted: Wed May 03, 2006 2:35 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Thu Aug 18, 2005 8:57 am
Posts: 1382
Location: Shrewsbury, Shropshire, United Kingdom
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/


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 



Who is online

Users browsing this forum: No registered users and 17 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group