Revision [2458]
This is an old revision of WikkaTableStructure made by NilsLindenberg on 2004-11-25 17:34:28.
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 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 | ' ' | 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 |
wikka_acls
the rights for reading/writing/commenting (on) a pageColumm name | Type | Length | Null | Default | Description |
page_tag | varchar | 75 | no | ' ' | name of the page |
read_acl | text | no | the access-list for reading a page | ||
write_acl | text | no | the same for writing | ||
comment_acl | text | no | and for setting comments |
wikka_links
the links between the Wikka-pagesColumm name | Type | Length | Null | Default | Description |
from_tag | varchar | 75 | no | ' ' | start-page of the link |
to_tag | varchar | 75 | no | ' ' | target-page for the link |
wikka_referrer
wikka_referrer_blacklist
the list of pages not shown on the ReferrersInfo referrer pages?Columm name | Type | Length | Null | Default | Description |
spammer | varchar | 150 | no | ' ' | adress of the spammer? |
wikka_user
obviously the RegisterInfo registered users of the wikkaColumm name | Type | Length | Null | Default | Description |
name | varchar | 75 | no | ' ' | the name of the user |
password | varchar | 32 | no | ' ' | the md5 encrypt of the password |
varchar | 50 | no | ' ' | the email-address of the user | |
revisioncount | unsigned int | 10 | no | 20 | how many revisions of a page are shown (see PageHistoryInfo) |
changescount | unsigned int | 10 | no | 50 | how many entrys are shown at Recentchanges |
doubleclickedit | enum('Y','N') | no | 'Y' | double-click edit or not | |
signuptime | datetime | no | '0000-00-00 00:00:00' | date and time of the registration | |
show_comments | enum('Y','N') | no | 'Y' | show comments as default or not |
wikka_comments
all the comments in the wikkaColumm name | Type | Length | Null | Default | Description |
id | unsigned int | 10 | no | auto_increment | the unique id for a comment |
page_tag | varchar | 75 | no | ' ' | name of the page to which the comment belongs |
time | datetime | no | '0000-00-00 00:00:00' | date and time of the comment | |
comment | text | no | the text of the comment | ||
user | varchar | 75 | no | ' ' | the author of the comment |
CategoryDocumentation