History of TP-Structures

Version 3


Ideas for TikiPro Universal Structures

Created by: William Leibzon, Last modification: 27 Jan 2005 (15:51 UTC) by William Leibzon
Current Database Tables
tiki_blogs: blog_id, user_id, created, last_modified, title, description, public, posts, max_posts, hits, activitiy, heading, use_find, use_title, add_date, add_poster, allow_comments, tiki_blog_posts: post_id, content_id, blog_id, trackback_to,trackbacks_from
Notes: trackbacks_to and trackbacks_from are default "a:():{}" almost always

tiki_nexus_menu: menu_id, plugin_guid, title, description, type, editable
tiki_nexus_menu_items: item_id, menu_id, parent_id, po, title, hint, url, url_type, perm

tiki_categories: category_id, name, description, parent_id, hits
tiki_category_objects: cat_object_id, category_id
tiki_categorized_objects: cat_object_id, object_type, object_id, description, created, name, href, hits
object_type is tikipage, blog, etc
description is somewhat similar to hint
name is similar to title
href is "/wiki/index.php?pge_id=7" etc

tiki_structures: structure_id, root_structure_id, content_id, level, pos, page_alias, parent_id

New Structure & Structure Type Tables
tiki_structure_types (primary key is tiki_structure_type):
structure_type_id, structure_type_description, handler_class, handler_package, handler_file

Note: See tiki_content_types for reference as to what above is

tiki_structure_objects (primary key is structure_object_id):
structure_object_id, structure_id, structure_type_id, object_id

tiki_structure (primary key is structure_id):
structure_id, user_id, structure_name, structure_description, parent_id, created_on, last_modified_on

tiki_blogs(replaces original, primary key is blog_id):
blog_id, public, posts, max_posts, hits, activity, heading, use_find, use_title, add_data, add_poster, allow_comments

New Structure Item Tables
tiki_structure_item (primary key is structure_item_id):
structure_item_id, object_type, object_id, url, name, description, created_on, last_modified_on,

tiki_structure_pos (primary_key is combination of tiki_structure_id and tiki_structure_item_id):
structure_id, structure_item_id, top_level_item_id, pos

structure_item_id attrib_name attrib_value

Note: Unsure if needed or how to do: tiki_structures: level, tiki_categorized_objects: hits, tiki_nexus_menu_item: perm

Structure_item_id - integer used to specify each line/item in the structure. Equivalent to:
tiki_structures: structure_id, tiki_nexus_menu_items: item_id, tiki_blog_posts: post_id, tiki_categorized_objects: cat_object_id

Structure_id - integer used to specify one structure. Equvalent to:
tiki_structures: root_structure_id, tiki_nexus_menu_items: menu_id, tiki_blog_posts: blog_id, tiki_categorized_objects: category_id

Top_Level_Item_id - integer specifying top level for multi-level menus & structures; Equivalent to:
tiki_structures: parent_id, tiki_nexus_menu_items: parent_id

Pos - integer which specifies position of the menu relates to ALL other items (no matter what level, within same level highier position is displayed lower and parent_id must have position that is lower then any child). Equivalent to:
tiki_structures: pos, tiki_nexus_menu_items: po

Object_type - Type of object, describes what type of object_id this is. Can be:
content_id - Object_ID is Content_id
blog_id - Object_ID is Blog_id
structure_id - Object_ID = Structure_ID
URL - Object_Id is not used, instead URL specifies full URL
Equivalent to:
tiki_categorized_objects: object_type, tiki_nexus_menu_items: url_type

Object_id - id of the content for this item, usually same as Content_ID. Equivalent to:
tiki_categorized_objects: object_id, tiki_nexus_menu_items: url, tiki_structures: content_id, tiki_blog_posts: content_id

URL - when its non-standard or external object, it specifies full URL to redirect to, this is used when object_id is NULL. Equivalent to:
tiki_categorized_objects: href, tiki_nexus_menu_items: url

Name - Short name that will appear when listing this structure instead of original page_name (if not present, original name from structure is to be used). Equivalent to:
tiki_categorized_objects: name, tiki_nexus_menu_items: title, tiki_structure: page_alias

Description - Longer description that maybe used. Equivalent to:
tiki_categorized_objects: description, tiki_nexus_menu_items: hint

Created_On - Date when this structure item was created. Equivalent to:
tiki_categorized_objects: created

Last_Modified_On - Date when this structure item was last modified

Attrib_name - name of the additional attribute (specific to certain structures). This can be: "trackback_to", "trackback_from"

Attrib_value - arbitrary data value

Note: Possibly get rid of Object_type and replace Object_id in table with Content_ID
Page History
28 Jan 2005 (12:48 UTC)
William Leibzon216.151.194.22617
Current • Source
William Leibzon216.151.194.22616
View • Compare • Difference • Source
William Leibzon216.151.194.22615
View • Compare • Difference • Source
William Leibzon216.151.194.22614
View • Compare • Difference • Source
William Leibzon216.151.194.22613
View • Compare • Difference • Source
William Leibzon216.151.194.22612
View • Compare • Difference • Source
William Leibzon216.151.194.22611
View • Compare • Difference • Source
William Leibzon216.151.194.22610
View • Compare • Difference • Source
William Leibzon216.151.194.2269
View • Compare • Difference • Source
William Leibzon216.151.194.2268
View • Compare • Difference • Source
William Leibzon216.151.194.2267
View • Compare • Difference • Source
William Leibzon216.151.194.2266
View • Compare • Difference • Source
William Leibzon216.151.194.2265
View • Compare • Difference • Source
William Leibzon216.151.194.2264
View • Compare • Difference • Source
William Leibzon216.151.194.2263
View • Compare • Difference • Source
William Leibzon216.151.194.2262
View • Compare • Difference • Source