Delete a Page
Sometimes you may want to delete a page because it's junk or you have a better copy/version elsewhere in your heirarchy. Let's investigate how we delete the entirety of a page, i.e. all it's parts and versions.
The tables that contain page related information are:
page - id page_version - page content - page attachment - page comment - page link - from_page, to_page role_privilege - page tag - page wanted_page - from_page
SELECT FROM page WHERE id=5; SELECT FROM page_version WHERE page=5; DELETE FROM page_version WHERE page = 5; select page from content where page = 5; select page from attachment where page = 5; select page from comment where page = 5; select from_page, to_page from link where to_page = 5 or from_page = 5; select page from role_privilege where page = 5; select from_page from wanted_page where from_page=5; WHERE page= WHERE from_page= WHERE to_page=
Showing changes from previous revision.