Revision history for WikkaTableStructure
Additions:
~-[[http://wikkawiki.org/WikkaPhysicalDataModel | WikkaPhysicalDataModel]]
Deletions:
Additions:
~-[[http://wikkawiki.org/WikkaPhysicalDataModel WikkaPhysicalDataModel]]
Deletions:
~-[[http://wikkawiki.org/WikkaPhysicalDataModel | WikkaPhysicalDataModel]]
Additions:
||status||enum('invited','signed-up','pending',---'active','suspended','banned','deleted')||||yes||||{{since version="1.1.6.4" display="inline"}} current user status||
Deletions:
Additions:
=====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 ##[[ConfigurationOptions | 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 [[ConfigurationOptions | configuration file]]//
====##wikka_links##====
====##wikka_referrer##====
====##wikka_referrer_blacklist##====
//stores domains blacklisted from the [[ReferrersInfo | referrer pages]]//
====##wikka_user##====
====##wikka_comments##====
====##wikka_sessions##====
//tracks user sessions// {{since version="1.1.6.4" display="inline"}}
Note that they have the prefix you chose in the install process. For example: if you chose prefix: ##""MyWikka_""## (stored in ##[[ConfigurationOptions | 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 [[ConfigurationOptions | configuration file]]//
====##wikka_links##====
====##wikka_referrer##====
====##wikka_referrer_blacklist##====
//stores domains blacklisted from the [[ReferrersInfo | referrer pages]]//
====##wikka_user##====
====##wikka_comments##====
====##wikka_sessions##====
//tracks user sessions// {{since version="1.1.6.4" display="inline"}}
Deletions:
Note that they have the prefix you chose in the install process.
Example: ##$this->config["table_prefix"]."pages"##
your chosen prefix: ##""MyWikka_""## (stored in ##[[ConfigurationOptions | 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 [[ReferrersInfo | referrer pages]]//
==wikka_user==
==wikka_comments==
==wikka_sessions==
//tracks user sessions {{since version="1.1.6.4" align="left"}}
Revision [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 version="1.1.6.4" display="inline"}}||
==wikka_sessions==
//tracks user sessions {{since version="1.1.6.4" align="left"}}
||sessionid||char||32||no||||id of session||
||userid||varchar||75||no||||user profile||
||session_start||datetime||||no||||When this session has started||
==wikka_sessions==
//tracks user sessions {{since version="1.1.6.4" align="left"}}
||sessionid||char||32||no||||id of session||
||userid||varchar||75||no||||user profile||
||session_start||datetime||||no||||When this session has started||
Revision [567]
Edited on 2008-01-31 00:02:25 by DotMG [Ticket #637 : Use table markup instead of table action on docs server]Additions:
|[|
|=|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||
|=|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||
Deletions:
{{table columns="6" cellpadding="1" cells="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"}}
{{table columns="6" cellpadding="1" cells="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"}}
{{table columns="6" cellpadding="1" cells="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 "}}
{{table columns="6" cellpadding="1" cells="Column name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}
{{table columns="6" cellpadding="1" cells="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"}}
{{table columns="6" cellpadding="1" cells="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"}}
Additions:
HomePage
~-[[http://wikkawiki.org/WikkaPhysicalDataModel | WikkaPhysicalDataModel]]
~-[[http://wikkawiki.org/WikkaLogicalDataModel | WikkaLogicalDataModel]]
your chosen prefix: ##""MyWikka_""## (stored in ##[[ConfigurationOptions | wikka.config.php]]##)
=> name of the table: ##""MyWikka""_pages##
CategoryEN
~-[[http://wikkawiki.org/WikkaPhysicalDataModel | WikkaPhysicalDataModel]]
~-[[http://wikkawiki.org/WikkaLogicalDataModel | WikkaLogicalDataModel]]
your chosen prefix: ##""MyWikka_""## (stored in ##[[ConfigurationOptions | wikka.config.php]]##)
=> name of the table: ##""MyWikka""_pages##
CategoryEN
Deletions:
~-WikkaPhysicalDataModel
~-WikkaLogicalDataModel
your chosen prefix: ""MyWikka_"" (stored in ##[[ConfigurationOptions | wikka.config.php]]##)
=> name of the table: ""MyWikka""_pages
CategoryDocumentation
