Revision [2386]

This is an old revision of WikkaTableStructure made by NilsLindenberg on 2004-11-23 14:50:03.


HelpInfo Wikka Documentation

The structure of the MySQL-Tables of Wikka

The installer of Wikka creates some tables necessary for Wikka.

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

Example: ["table_prefix"]."pages
your choosen prefix: MyWikka
=> name of the table: MyWikka.pages

The tables presented below are withour the prefix!

all versions of a page, not only the actuall 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
the content of the page
owner varchar 75 no ' ' the user which owns this version of the page
user varchar 75 no ' ' ???
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

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