xowiki pages are managed with the OpenACS Content repository.
XOWIKI pages:
For each page there’s an entry in cr_items
projop=# \d cr_items
Table "public.cr_items"
Column | Type | Modifiers
-------------------+------------------------+------------------------------------------------
item_id | integer | not null
parent_id | integer | not null
name | character varying(400) | not null
locale | character varying(4) |
live_revision | integer |
latest_revision | integer |
publish_status | character varying(40) |
content_type | character varying(100) |
storage_type | character varying(10) | not null default 'text'::character varying
storage_area_key | character varying(100) | not null default 'CR_FILES'::character varying
tree_sortkey | bit varying | not null
max_child_sortkey | bit varying |
Page content
Page content is stored in table cr_revisions
projop=# \d cr_revisions
Table "public.cr_revisions"
Column | Type | Modifiers
----------------+--------------------------+-----------------------------------------
revision_id | integer | not null
item_id | integer | not null
title | character varying(1000) |
description | text |
publish_date | timestamp with time zone |
mime_type | character varying(200) | default 'text/plain'::character varying
nls_language | character varying(50) |
lob | integer |
content | text |
content_length | integer |
Finding content that can’t be found using ‘search’ such as links etc.
select r.item_id, r.title, i.name from cr_revisions r, cr_items i where r.content like '%en:install_main%' and r.revision_id = i.live_revision;
Object Model
Pls. see: http://openacs.org/xotcl/show-object?show_source=0&object=%3A%3Axowiki%3A%3APage&show_methods=1
0 Comments.