History of LibertyPackage
A new feature for Clyde, the "common" package allows wiki, blogs, articles, and more to store their data in the same table, called tiki_content. This table holds the text data for all content - blogs, wiki, articles, etc. all in one column. This permits super fast searching, as well as simplified data storage/retrieval & text processing via a common base class.
{img src=http://www.tikipro.org/imagegals/show_image.php?id=27 align=center }
Here is what the tiki_content table looks like:
Table "tiki.tiki_content"
Column | Type | Modifiers
-----------------+------------------------+--------------------------------------------------------------------
content_id | integer | not null default nextval('tiki.tiki_content_content_id_seq'::text)
content_type_id | integer | not null
created | bigint | not null
last_modified | bigint | not null
language | character varying(2) |
title | character varying(160) |
data | text |
And here is the initial contents of the tiki_content_types table:
=> select * from tiki_content_types;
tiki_content_type_id | content_type
----------------------+--------------
1 | Wiki
2 | Blog Post
A few notes:
* Variable languages for the same content_id is not currently implemented. In fact, content_id is a PRIMARY KEY. Eventually, the PRIMARY KEY for tiki_content will probably be (content_id, language)
{img src=http://www.tikipro.org/imagegals/show_image.php?id=27 align=center }
Here is what the tiki_content table looks like:
Table "tiki.tiki_content"
Column | Type | Modifiers
-----------------+------------------------+--------------------------------------------------------------------
content_id | integer | not null default nextval('tiki.tiki_content_content_id_seq'::text)
content_type_id | integer | not null
created | bigint | not null
last_modified | bigint | not null
language | character varying(2) |
title | character varying(160) |
data | text |
And here is the initial contents of the tiki_content_types table:
=> select * from tiki_content_types;
tiki_content_type_id | content_type
----------------------+--------------
1 | Wiki
2 | Blog Post
A few notes:
* Variable languages for the same content_id is not currently implemented. In fact, content_id is a PRIMARY KEY. Eventually, the PRIMARY KEY for tiki_content will probably be (content_id, language)