Revision [2385]
This is an old revision of WikkaTableStructure made by NilsLindenberg on 2004-11-23 14:43:49.
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!
.pages
all versions of a page, not only the actuall oneColumm 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 | ' ' | ??? |
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