How tables are modified after making an article

[kh99]

I was kind of hoping that someone would answer this, because I'm not a database person and I was wondering if there was some way to montior changes to the database. But I can think of a couple of ways I might try: one is to put the site in debug mode and create an article, then look at the list of queries that were done and figure out which ones had to do with creating the article. Another would be to save the database to sql (probably using a test site without a lot of posts or threads), then create an article and save the sql again, and diff the two sql files (I have no idea how well this would work - it may be that table rows don't always come out in the same order when you dump a database so there'd be too many changes).

Of course you can always look at the code and see what's done when an article is created.