Difference between revisions of "Pages, Revisions, Text, and RecentChanges"
Jason Parmer (talk | contribs) (add table linkages) |
Jason Parmer (talk | contribs) |
||
| Line 30: | Line 30: | ||
|rev.rev_id | |rev.rev_id | ||
|---- | |---- | ||
| + | | | ||
| + | |rc_last_oldid | ||
| + | |rev.rev_id | ||
|Revision | |Revision | ||
|rev_page | |rev_page | ||
Revision as of 22:41, 12 October 2007
| Table | Primary Key |
| page | page_id |
| revision | rev_id |
| text | old_id |
| recentchanges | rc_id |
| Table | Field | References | |||
| RecentChanges | rc_cur_id | page.page_id | |||
| rc_this_oldid | rev.rev_id | ||||
| rc_last_oldid | rev.rev_id | Revision | rev_page | page.page_id | |
| rev_text_id | text.old_id | ||||
| Page | page_latest | revision.rev_id |
