Revision [2393]

This is an old revision of WikkaTableStructure made by DarTar on 2004-11-23 16:34:18.

 

HelpInfo Wikka Documentation

The structure of the MySQL-Tables of Wikka

The Wikka installer creates some tables necessary for storing Wikka data.

Note that they have the prefix you choose in the install process.

Example: $this->config["table_prefix"]."pages"
your choosen prefix: MyWikka_ (stored in ConfigurationOptions wikka.config.php)
=> name of the table: MyWikka_pages

The tables presented below use the default wikka_ prefix:

wikka_pages
a record corresponds to a version of a Wikka page, not only the current one
Columm name Type Length Null Default Description
id unsigned int 10 no auto_increment the unique id for a page
tag varchar 75 no ' ' the name of the page
time datetime
no '0000-00-00 00:00:00' date and time of this version
body mediumtext
no
the content of the page
owner varchar 75 no ' ' the user which owns this version of the page
user varchar 75 no ' ' author of this version of the page
latest enum('Y','N')
no 'N' indicates if this version of the page is the latest (Y or N)
note varchar 100 no ' ' the note the editor can leave on a edit
handler varchar 30 no 'page' actually there are no other handlers then page




CategoryDocumentation
There are 4 comments on this page. [Show comments]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki