I'm looking for any documentation on the MySQL tables that MediaWiki uses. Pointers would be appreciated.
-r
At 6:52 PM -0800 3/7/06, Rich Morin wrote:
I'm looking for any documentation on the MySQL tables that MediaWiki uses. Pointers would be appreciated.
Following Rob's hint, I looked in maintenance/tables.sql and even worked up some pages (eg, User:RichMorin/MySQL_Tables). Today, however, I ran across Help:Database_layout, which has quite a lot of useful information.
Unfortunately, none of these documents spell out the foreign key relationships (etc) used in the tables. If anyone would like to help me document these, please get in touch...
-r
Rich Morin wrote:
Following Rob's hint, I looked in maintenance/tables.sql and even worked up some pages (eg, User:RichMorin/MySQL_Tables). Today, however, I ran across Help:Database_layout, which has quite a lot of useful information.
Unfortunately, none of these documents spell out the foreign key relationships (etc) used in the tables. If anyone would like to help me document these, please get in touch...
maintenance/tables.sql is heavily commented and does spell out foreign key relationships.
We've already provided documentation, so if you have specific questions after reading these documents, you'll need to go ahead and actually ask them... :)
-- brion vibber (brion @ pobox.com)
-- brion vibber (brion @ pobox.com) At 5:57 PM -0800 3/12/06, Brion Vibber wrote:
We've already provided documentation, so if you have specific questions after reading these documents, you'll need to go ahead and actually ask them... :)
Works for me...
-r
Q: Are there any changes in the DB schema for MW 1.6?
Q: Is there any column-level documentation of the tables?
What I'd like is a 1-2 line definition of each column, with extra attention paid to foreign keys, etc. If there isn't such a resource, at present, I'd be willing to set up some templates and keep track (at least, initially :-) of the submitted definitions.
Q: Are ERDs available for 1.5.X and/or 1.6?
http://meta.wikimedia.org/wiki/Image:DER_Mediawiki.PNG
Q: Where did the ERDs come from?
The page doesn't indicate the image's provenance, save for:
* (del) (cur) 15:18, 7 November 2005 . . Lamassa (Talk) . . 870x424 (15614 bytes) (Diagram Entity Relationship from the mediawiki database 1.4.X)
I'd like to know how it was generated, by whom, etc.
Q: General "image map" comment/question
Although the ERD Diagram, is an image map, it has only one "region". Is there a convention for using multi-region image maps? On a diagram such as this, one possibility is to make the "background" link to the "Image" page.
Q: Speculative "image map" comment/question
Would you like to have the icons (and perhaps, edges) on the ERD Diagram link to specific pages? Pop-ups could give short descriptions of each item. And, if you want to get fancy, an image-mapped diagram of the "local neighborhood".
FWIW, I did something very similar to this for a NASA project:
http://www.slac.stanford.edu/exp/glast/flight/web/a_pnp/Pack_LSE.shtml http://www.slac.stanford.edu/exp/glast/flight/web/e_tut/diagrams.shtml http://www.cfcl.com/rdm/MBD/mbd_cs_fsw.php
Q: What is the story on "User_Talk:Foo" links/pages?
The User_talk:Lamassa link brings up a non-existent page. Is this a way to send a note to "Lamassa"? (The page gives no hints.) If not, what is it and where is it documented?
That should get us started (:-).
-r
Rich Morin wrote:
Q: Are there any changes in the DB schema for MW 1.6?
Yes, we have made some changes so far. You can compare the commented tables.sql files between 1.5 and the current 1.6 in CVS HEAD to see all such changes.
Q: Is there any column-level documentation of the tables?
What I'd like is a 1-2 line definition of each column, with extra attention paid to foreign keys, etc. If there isn't such a resource, at present, I'd be willing to set up some templates and keep track (at least, initially :-) of the submitted definitions.
You will find *exactly* this in tables.sql, which is why I referred you to it.
Q: Are ERDs available for 1.5.X and/or 1.6?
No.
Q: Where did the ERDs come from?
We don't have any ERDs. If any exist, they were created by third parties and we have no knowledge of htem.
Q: What is the story on "User_Talk:Foo" links/pages?
The User_talk:Lamassa link brings up a non-existent page. Is this a way to send a note to "Lamassa"? (The page gives no hints.) If not, what is it and where is it documented?
Click "edit" and write a message on the page.
-- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org