Revision [2458]

This is an old revision of WikkaTableStructure made by NilsLindenberg on 2004-11-25 17:34:28.

 

HelpInfo 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

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 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
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 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


the links between the 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

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 wikka
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
all the comments in the wikka
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