Revision [5899]

This is an old revision of WikkaTableStructure made by JavaWoman on 2005-02-10 23:12:08.

 

WikkaDocumentation 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

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,
Columm 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 then page


wikka_acls
stores the rights for reading/writing/commenting each page
Columm 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


stores links between Wikka pages
Columm 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
Columm 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 masked from the ReferrersInfo referrer pages
Columm name Type Length Null Default Description
spammer varchar 150 no ' ' blacklisted domain


wikka_user
stores RegisterInfo registered users settings
Columm 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
email 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
stores comments to Wikka pages
Columm 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
There are 4 comments on this page. [Show comments]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki