History of LibertyPackage

Version 11

LibertyPackage

Explanation of the ))tiki_content(( table.

Created by: spiderr, Last modification: 26 Aug 2004 (00:04 UTC) by spiderr
A new feature for Clyde, CommonContent 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.

Image


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)

Page History
Date/CommentUserIPVersion
18 Dec 2008 (03:09 UTC)
new page link
Will69.203.72.16143
Current • Source
laetzer85.178.14.21642
View • Compare • Difference • Source
Kozuch85.207.244.16041
View • Compare • Difference • Source
Will69.203.72.16139
View • Compare • Difference • Source
laetzer85.178.62.11738
View • Compare • Difference • Source
Will206.83.76.1536
View • Compare • Difference • Source
Will206.83.76.1535
View • Compare • Difference • Source
Will206.83.76.1534
View • Compare • Difference • Source
dspt213.184.224.332
View • Compare • Difference • Source
spiderr66.93.240.20431
View • Compare • Difference • Source
spiderr66.93.240.20430
View • Compare • Difference • Source
spiderr68.125.207.11628
View • Compare • Difference • Source
spiderr66.93.240.20427
View • Compare • Difference • Source
Stephan Borg218.214.1.11324
View • Compare • Difference • Source
spiderr66.93.240.20423
View • Compare • Difference • Source
SEWilco207.195.192.922
View • Compare • Difference • Source
SEWilco207.195.192.920
View • Compare • Difference • Source
spiderr66.93.240.20419
View • Compare • Difference • Source
spiderr66.93.240.20418
View • Compare • Difference • Source
spiderr66.93.240.20417
View • Compare • Difference • Source
spiderr66.93.240.20416
View • Compare • Difference • Source
spiderr66.93.240.20415
View • Compare • Difference • Source
spiderr66.93.240.20414
View • Compare • Difference • Source
spiderr66.93.240.20413
View • Compare • Difference • Source
spiderr66.93.240.20412
View • Compare • Difference • Source
spiderr66.93.240.20411
View • Compare • Difference • Source