Delete a Page

Overview

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.

Tables Involved

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

SQL Fragments

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=