[wp-hackers] The WordPress schema

[Chris]

@Bull3t
Well, on my install of wordpress 2.2 wp-admin\includes\schema.php does 
not exist, and the source of wp-includes\wp-db.php only lists the 
tables, not the schema!
Perhaps we mean different things by "schema". I would like to see a 
complete map of the tables, the relationships between the (key) fields, 
and a description of ach table purpose, how it is used, and same for 
each field.
Now that would aid understanding when hacking wordpress or writing a plugin!
So, does anyone have a link to an up-to-date article that covers all this?
Chris



Bull3t wrote:
> The Database Schema can be found by searching the WordPress source code. It
> is contained within: wp-includes\wp-db.php and wp-admin\includes\schema.php,
> it's quite simple really. Especially when the file you were looking for was
> named exactly as you named it, "schema"...
>
>
> --------------------------------------------
> Bull3t
> http://www.bull3t.me.uk/
>
>
>   
>> -----Original Message-----
>> From: wp-hackers-bounces at lists.automattic.com [mailto:wp-hackers-
>> bounces at lists.automattic.com] On Behalf Of Chris
>> Sent: 04 November 2007 10:16
>> To: wp-hackers at lists.automattic.com
>> Subject: Re: [wp-hackers] The WordPress schema
>>
>> Well, not terribly helpful, as that shows the tables, but does not
>> describe purpose, relationships or anything else!
>> I have not found anything in the codex that properly pulls this together
>> , but these links are easily found by searching
>> http://codex.wordpress.org/Database_Description
>> and Ryan has described the new taxonomy schema quite well here
>> http://codex.wordpress.org/index.php?title=Version_2.3:New_Taxonomy
>>
>> hope that helps
>> Chris
>>
>>
>> Omry Yadan wrote:
>>     
>>> well, just install WordPress and look :)
>>>
>>> Blast o_O wrote:
>>>       
>>>> Hi everybody!!!
>>>>
>>>> I'm looking for the DB schema of WordPress, any idea about where I can
>>>> find it!!!???
>>>> Thanks to all ;)
>>>>
>>>> B. o_O
>>>>
>>>> PD: This is off-topic but searching the web I didn't find anything, do
>>>> you know where can I find info about the schema of Craigslist.org
>>>>         
> !!!???
>   
>>>> db schema, site schema!? tnkx x 2 ;)
>>>>
>>>> _______________________________________________
>>>> wp-hackers mailing list
>>>> wp-hackers at lists.automattic.com
>>>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>>>
>>>>         
>>> _______________________________________________
>>> wp-hackers mailing list
>>> wp-hackers at lists.automattic.com
>>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>>
>>>       
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>>
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.5.503 / Virus Database: 269.15.20/1108 - Release Date:
>>     
> 03/11/2007
>   
>> 21:42
>>
>>     
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition. 
> Version: 7.5.503 / Virus Database: 269.15.20/1108 - Release Date: 03/11/2007
> 21:42
>  
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
>