Codex

Interested in functions, hooks, classes, or methods? Check out the new WordPress Code Reference!

User:MichaelH/Testing/Revisions

Version 2.6 bleeding2 at R7986 showing progression of wp_posts table through several revisions of a post. Final step shows reverting back to the very first post revision.


Enter post title 'My Post' and tab to content box

ID post_content post_name post_status post_type post_parent post_date post_modified
5 draft post 0 0000-00-00 00:00:00 -

Enter 'This is line 1' and hit enter in content box

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 draft post 0 0000-00-00 00:00:00 -

Publish post, click Visit Site

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 my-post publish post 0 2008-05-23 11:57:34 -
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 -

Edit post from blog page. Do nothing until it says Draft Saved

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 my-post publish post 0 2008-05-23 11:57:34 -
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 -
7 This is line 1 5-autosave inherit revision 5 2008-05-23 12:02:24 -

Add 'more txt' to post content and wait for Draft Saved

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 my-post publish post 0 2008-05-23 11:57:34 -
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 -
7 This is line 1 more txt 5-autosave inherit revision 5 2008-05-23 12:04:24 -

Save post, click Visit Site

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 more txt my-post publish post 0 2008-05-23 11:57:34 -
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 -
7 This is line 1 more txt 5-autosave inherit revision 5 2008-05-23 12:04:24 -
8 This is line 1 5-revision-2 inherit revision 5 2008-05-23 11:57:34 -|-

Edit post from blog page, do nothing wait until Draft Saved, click Visit Site

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 more txt my-post publish post 0 2008-05-23 11:57:34 2008-05-23 12:05:14
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 2008-05-23 11:56:17
7 This is line 1 more txt 5-autosave inherit revision 5 2008-05-23 13:13:03 2008-05-23 13:13:03
8 This is line 1 5-revision-2 inherit revision 5 2008-05-23 11:57:34 2008-05-23 11:57:34

Edit post from blog page, see message, click Visit Site

Get this message "There is an autosave of this post that is more recent than the version below. View the autosave." The "View the autosave" links to revision=7 but just click Visit Site.

Edit post from blog page, and add '. More Text.' to post content, Save post, click Visit Site

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 more txt. More txt. my-post publish post 0 2008-05-23 11:57:34 2008-05-23 13:35:33
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 2008-05-23 11:56:17
7 This is line 1 more txt 5-autosave inherit revision 5 2008-05-23 13:13:03 2008-05-23 13:13:03
8 This is line 1 5-revision-2 inherit revision 5 2008-05-23 11:57:34 2008-05-23 11:57:34
9 This is line 1 more txt 5-revision-3 inherit revision 5 2008-05-23 12:05:14 2008-05-23 12:05:14

Edit post from blog page, do nothing wait until Draft Saved, click Visit Site

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 more txt. More txt. my-post publish post 0 2008-05-23 11:57:34 2008-05-23 13:35:33
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 2008-05-23 11:56:17
7 This is line 1 more txt. More txt. 5-autosave inherit revision 5 2008-05-23 13:49:21 2008-05-23 13:49:21
8 This is line 1 5-revision-2 inherit revision 5 2008-05-23 11:57:34 2008-05-23 11:57:34
9 This is line 1 more txt 5-revision-3 inherit revision 5 2008-05-23 12:05:14 2008-05-23 12:05:14

Edit post from blog page, see message, click View Autosave, click Restore revision 6, click View Site

Get this message "There is an autosave of this post that is more recent than the version below. View the autosave." Click "View the autosave" link, but in table click to Restore revision 6, and then will get message "Post restored to revision from 23 May, 2008 @ 11:56", click to Visit Site.

ID post_content post_name post_status post_type post_parent post_date post_modified
5 This is line 1 my-post publish post 0 2008-05-23 11:57:34 2008-05-23 14:17:40
6 This is line 1 5-revision inherit revision 5 2008-05-23 11:56:17 2008-05-23 11:56:17
7 This is line 1 more txt. More txt. 5-autosave inherit revision 5 2008-05-23 13:49:21 2008-05-23 13:49:21
8 This is line 1 5-revision-2 inherit revision 5 2008-05-23 11:57:34 2008-05-23 11:57:34
9 This is line 1 more txt 5-revision-3 inherit revision 5 2008-05-23 12:05:14 2008-05-23 12:05:14
10 This is line 1 more txt. More txt. 5-revision-4 inherit revision 5 2008-05-23 13:35:33 2008-05-23 13:35:33