Revision [1196]
This is an old revision of WikkaTableStructure made by DarTar on 2008-11-01 23:23:06.
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 chose in the install process. For example: if you chose prefix: MyWikka_ (stored in wikka.config.php), $this->config["table_prefix"]."pages" will result in a MySQL table named MyWikka_pages.
All of the tables have the type MyISAM.
The tables presented below use the default wikka_ prefix:
wikka_pages
stores different versions of Wikka pages- a version is identified by a unique id,
- a page is identified by a tag,
- the last version of a page is marked by a Y in the latest field
| Column name | Type | Length | Null | Default | Description |
|---|---|---|---|---|---|
| id | unsigned int | 10 | no | auto_increment | the unique id for a page version |
| 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 than page |
wikka_acls
stores the rights for reading/writing/commenting each page if those rights are different from the defaults defined in the configuration file| Column 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
stores links between Wikka pages| Column 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
stores URLs of sites referring to Wikka-pages from external domains| Column name | Type | Length | Null | Default | Description |
|---|---|---|---|---|---|
| page_tag | varchar | 75 | no | ' ' | tag of the referred Wikka page |
| referrer | varchar | 150 | no | ' ' | URL of the referrer |
| time | datetime | no | '0000-00-00 00:00:00' | date and time of the last hit |
wikka_referrer_blacklist
stores domains blacklisted from the referrer pages| Column name | Type | Length | Null | Default | Description |
|---|---|---|---|---|---|
| spammer | varchar | 150 | no | ' ' | blacklisted domain |
wikka_user
stores registered users settings| Column 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 entries 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 | |
| status | enum('invited','signed-up','pending', 'active','suspended','banned','deleted') | yes |
since 1.1.6.4
current user status |
wikka_comments
stores comments to Wikka pages| Column 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 |
wikka_sessions
tracks user sessions
since 1.1.6.4
| Column name | Type | Length | Null | Default | Description |
|---|---|---|---|---|---|
| sessionid | char | 32 | no | id of session | |
| userid | varchar | 75 | no | user profile | |
| session_start | datetime | no | When this session has started |
CategoryEN
