Wikka Documentation: WikkaTableStructure

[1779] Latest edit on 2009-01-31 01:48:46 by DarTar [Removed carriage return]

No Differences

[1196] Edited on 2008-11-01 23:23:06 by DarTar [Removed HomePage link]

Deletions:
~~HomePage~~

[570] Edited on 2008-01-31 01:32:16 by DarTar [adding field desc]

Additions:

Deletions:

[569] Edited on 2008-01-31 01:31:18 by DarTar [minor formatting]

Additions:

status	enum('invited','signed-up','pending', 'active','suspended','banned','deleted')		yes		since 1.1.6.4 current user status
status	enum('invited','signed-up','pending', 'active','suspended','banned','deleted')		yes		since 1.1.6.4

The structure of the MySQL-Tables of Wikka

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.

`wikka_pages`

`wikka_acls`

stores the rights for reading/writing/commenting each page if those rights are different from the defaults defined in the configuration file

`wikka_links`

`wikka_referrer`

`wikka_referrer_blacklist`

stores domains blacklisted from the referrer pages

`wikka_user`

`wikka_comments`

`wikka_sessions`

tracks user sessions

since 1.1.6.4

status	enum('invited','signed-up','pending', 'active','suspended','banned','deleted')		yes		since 1.1.6.4

Deletions:
The structure of the MySQL-Tables of Wikka
Note that they have the prefix you chose in the install process.
Example: $this->config["table_prefix"]."pages"
your chosen prefix: MyWikka_ (stored in wikka.config.php)
=> name of the table: MyWikka_pages

wikka_pages

wikka_acls
stores the rights for reading/writing/commenting each page if those rights are different from the defaults defined in the configuration

wikka_links

wikka_referrer

wikka_referrer_blacklist
stores domains masked from the referrer pages

wikka_user

wikka_comments

wikka_sessions
tracks user sessions

NOTE

This feature is available since:
WikkaWiki 1.1.6.4

[568] Edited on 2008-01-31 00:11:50 by DotMG [Documenting new fields and table since 1.1.6.4]

Additions:

status enum('invited','signed-up','pending',
'active','suspended','banned','deleted') yes
since 1.1.6.4

wikka_sessions
tracks user sessions

NOTE

This feature is available since:
WikkaWiki 1.1.6.4

[567] Edited on 2008-01-31 00:02:25 by DotMG [Ticket #637 : Use table markup instead of table action on docs server]

Additions:

Deletions:

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
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
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
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
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
Column name	Type	Length	Null	Default	Description
spammer	varchar	150	no	' '	blacklisted domain
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
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 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
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

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

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

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

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

Column name	Type	Length	Null	Default	Description
spammer	varchar	150	no	' '	blacklisted domain

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

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

[360] Edited on 2006-11-19 11:43:16 by YanB [update links, cat.]

Additions:
HomePage

your chosen prefix: MyWikka_ (stored in wikka.config.php)
=> name of the table: MyWikka_pages
CategoryEN
Deletions:
Wikka Documentation

WikkaPhysicalDataModel
WikkaLogicalDataModel
your chosen prefix: MyWikka_ (stored in wikka.config.php)
=> name of the table: MyWikka_pages
CategoryDocumentation

[151] The oldest known version of this page was created on 2005-12-06 09:37:02 by NickDamoulakis [Minor spelling fixes]

History of recent changes for WikkaTableStructure

Wikka Documentation

The structure of the MySQL-Tables of Wikka

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

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

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

CategoryDocumentation