| @@ -1,10 +1,10 @@ |
| -=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''
|
| + 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_nexus_menu_items__: item_id, menu_id, parent_id, po, title, hint, rsrc, rsrc_type, perm |
|
|
| __tiki_categories__: category_id, name, description, parent_id, hits
|
| __tiki_category_objects__: cat_object_id, category_id
|
|
|
| @@ -13,11 +13,11 @@ |
| ''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''
|
| + ''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=-
|
| +-=New Structure & Structure Type Tables=- |
| __tiki_structure__ (primary key is structure_id):
|
| structure_id, content_id, user_id, name, description, parent_id, created_on, last_modified_on
|
|
|
|
|
| @@ -50,15 +50,15 @@ |
| __tiki_structure_types__ (primary key is structure_type_id):
|
| structure_type_id, description, maintainer_url, handler_package, handler_class, handler_file
|
|
|
| -This table is used as way to specify which objects are able to use tikipro structures and to provide reference to those objects. This is somewhat similar to how tiki_content_types table is used.
|
| +This table is used as way to specify which objects are able to use bitweaver structures and to provide reference to those objects. This is somewhat similar to how tiki_content_types table is used. |
|
|
| ===Structure_Type_ID=== - unique id used when referring to this type of object
|
|
|
| ===Description=== - descrition of the type of object using the scructure. Example: ''Blog'' or ''Category''
|
|
|
| -===Maintainer_URL=== - URL referring to the organization that maintains this type of structured object. Usually this would be "http://www.tikipro.org"
|
| +===Maintainer_URL=== - URL referring to the organization that maintains this type of structured object. Usually this would be "http://www.bitweaver.org" |
|
|
| -===Handler_Package=== - TikiPro package where the class is defined. Examples: ''Wiki'' and ''Blogs''
|
| +===Handler_Package=== - bitweaver package where the class is defined. Examples: ''Wiki'' and ''Blogs'' |
|
|
| ===Handler_Class=== - PHP class responsible for handling this structure type. Examples: ''TikiBook'' and ''TikiBlogPost''
|
|
|
|
|
| @@ -78,7 +78,7 @@ |
| __tiki_structure_item__ (primary key is structure_item_id):
|
| structure_item_id, item_type, item_id, url, name, description, created_on, last_modified_on,
|
|
|
| -This table is used to store information about specific item in the structure, including its name and description and which actual item (content of tikipro or reference to somewhere else) it refers to.
|
| +This table is used to store information about specific item in the structure, including its name and description and which actual item (content of bitweaver or reference to somewhere else) it refers to. |
|
|
| ===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
|
|
|
| @@ -89,15 +89,15 @@ |
| structure_id - Item_ID = Structure_ID
|
| URL - Item_Id is not used, instead URL specifies full URL
|
| Equivalent to:
|
| - tiki_categorized_objects: object_type, tiki_nexus_menu_items: url_type
|
| + tiki_categorized_objects: object_type, tiki_nexus_menu_items: rsrc_type |
|
|
| ===Item_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
|
| + tiki_categorized_objects: object_id, tiki_nexus_menu_items: rsrc, tiki_structures: content_id, tiki_blog_posts: content_id |
|
|
| Note: ''Possibly get rid of Item_type and replace Item_id in table with Content_ID''
|
|
|
| ===URL=== - when its non-standard or external object, it specifies full URL to redirect to, this is used when item_id is NULL. Equivalent to:
|
| - tiki_categorized_objects: href, tiki_nexus_menu_items: url
|
| + tiki_categorized_objects: href, tiki_nexus_menu_items: rsrc |
|
|
| ===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
|
|
|
| @@ -110,15 +110,15 @@ |
|
|
| ===Last_Modified_On=== - Date when this structure item was last modified
|
|
|
| -__tiki_structure_item_position__ (primary_key is combination of tiki_structure_id and tiki_structure_item_id):
|
| -structure_id, structure_item_id, parent_id, pos
|
| +__tiki_structure_item_position__ (primary_key is combination of tiki_structure_id, tiki_structure_item_id and pos): |
| +structure_id, structure_item_id, pos, parent_id |
|
|
| This table is used to link structure items to actual structure that they belong to and describes how those items are positioned inside the structure
|
|
|
| ===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
|
|
|
| -===Parent_id=== - integer specifying top level for multi-level menus & structures; Equivalent to:
|
| +===Parent_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:
|
|
|
| @@ -131,7 +131,7 @@ |
|
|
| ===Structure_Attrib_Name_ID=== - ID for this attribute name
|
|
|
| -===Attrib_name=== - Name of the attribute, such as "trackback_to" and "trackback_from" for blogs
|
| +===Attrib_name=== - Name of the attribute, such as "trackback_to" and "trackback_from" for blogs |
|
|
| ===Structure_Type_ID=== - ID for type of structure that uses these attribute, see tiki_structure_types tables
|
|
|
|
|