Revision history for WikkaTableStructure


Revision [22836]

Last edited on 2016-05-20 07:38:42 by NickDamoulakis [Replaces old-style internal links with new pipe-split links.]
Additions:
This page can now be found on the [[Docs:WikkaTableStructure | Wikka Documentation Server]].
An archive of [[http://wikkawiki.org/WikkaTableStructure/revisions | old revisions of this page]] is still available for reference.<<
Deletions:
This page can now be found on the [[Docs:WikkaTableStructure Wikka Documentation Server]].
An archive of [[http://wikkawiki.org/WikkaTableStructure/revisions
old revisions of this page]] is still available for reference.<<

Revision [18042]

Edited on 2008-01-27 02:34:53 by NickDamoulakis [Migrated to doc server]
Additions:
<<===This page has moved===
This page can now be found on the [[Docs:WikkaTableStructure Wikka Documentation Server]].
Thanks for updating your bookmarks!
An archive of [[http://wikkawiki.org/WikkaTableStructure/revisions
old revisions of this page]] is still available for reference.<<
::c::
CategoryMigratedDocs
Deletions:
[[WikkaDocumentation Wikka Documentation]]
====The structure of the MySQL-Tables of Wikka====
>>See also:
~-WikkaPhysicalDataModel
~-WikkaLogicalDataModel
>>The Wikka installer creates some tables necessary for storing Wikka data.
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
All of the tables have the type [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html 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
{{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 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//
{{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"}}
==wikka_links==
//stores links between Wikka pages//
{{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"}}
==wikka_referrer==
//stores URLs of sites referring to Wikka-pages from external domains//
{{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 "}}
==wikka_referrer_blacklist==
//stores domains masked from the [[ReferrersInfo referrer pages]]//
{{table columns="6" cellpadding="1" cells="Column name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}
==wikka_user==
//stores [[RegisterInfo registered]] users settings//
{{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"}}
==wikka_comments==
//stores comments to Wikka pages//
{{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"}}
CategoryDocumentation

Revision [12113]

Edited on 2005-12-06 09:37:02 by NickDamoulakis [Minor spelling fixes]
Additions:
{{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 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"}}
{{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"}}
Deletions:
{{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 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"}}
{{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 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"}}

Revision [12103]

Edited on 2005-12-05 22:36:46 by DarTar [minor]
Additions:
~- the last version of a page is marked by a ##Y## in the ##latest## field
Deletions:
~- the last version of a page is marked by a ##Y## in the ##latest## field//

Revision [12102]

Edited on 2005-12-05 22:36:17 by DarTar [minor]
Additions:
//stores different versions of Wikka pages//
Deletions:
//stores different versions of Wikka pages

Revision [12098]

Edited on 2005-12-05 21:00:09 by RyeBread [minor sp fix]
Additions:
[[WikkaDocumentation Wikka Documentation]]
----
====The structure of the MySQL-Tables of Wikka====

>>See also:
~-WikkaPhysicalDataModel
~-WikkaLogicalDataModel
>>The Wikka installer creates some tables necessary for storing Wikka data.

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

All of the tables have the type [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html 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//
{{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 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 **if** those rights are different from the defaults defined in the configuration//
{{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"}}

==wikka_links==
//stores links between Wikka pages//
{{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"}}

==wikka_referrer==
//stores URLs of sites referring to Wikka-pages from external domains//
{{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 "}}

==wikka_referrer_blacklist==
//stores domains masked from the [[ReferrersInfo referrer pages]]//
{{table columns="6" cellpadding="1" cells="Column name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}

==wikka_user==
//stores [[RegisterInfo registered]] users settings//
{{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 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//
{{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"}}
----
Deletions:
[[WikkaDocumentation Wikka Documentation]]
----
====The structure of the MySQL-Tables of Wikka====

>>See also:
~-WikkaPhysicalDataModel
~-WikkaLogicalDataModel
>>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 [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html 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//
{{table columns="6" cellpadding="1" cells="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 **if** those rights are different from the defaults defined in the configuration//
{{table columns="6" cellpadding="1" cells="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"}}

==wikka_links==
//stores links between Wikka pages//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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]]//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}

==wikka_user==
//stores [[RegisterInfo registered]] users settings//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}
----

Revision [5930]

Edited on 2005-02-12 05:09:25 by JavaWoman [layout (float does not *need* to be cleared - any problem is the formatter's]
Additions:
[[WikkaDocumentation Wikka Documentation]]
----
====The structure of the MySQL-Tables of Wikka====

>>See also:
~-WikkaPhysicalDataModel
~-WikkaLogicalDataModel
>>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 [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html 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//
{{table columns="6" cellpadding="1" cells="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 **if** those rights are different from the defaults defined in the configuration//
{{table columns="6" cellpadding="1" cells="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"}}

==wikka_links==
//stores links between Wikka pages//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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]]//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}

==wikka_user==
//stores [[RegisterInfo registered]] users settings//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}
----
Deletions:
[[WikkaDocumentation Wikka Documentation]]
----
====The structure of the MySQL-Tables of Wikka====

>>See also:
~-WikkaPhysicalDataModel
~-WikkaLogicalDataModel
>>
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 [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html 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//
{{table columns="6" cellpadding="1" cells="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 **if** those rights are different from the defaults defined in the configuration//
{{table columns="6" cellpadding="1" cells="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"}}

==wikka_links==
//stores links between Wikka pages//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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]]//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}

==wikka_user==
//stores [[RegisterInfo registered]] users settings//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}
----

Revision [5926]

Edited on 2005-02-12 00:02:06 by DarTar [Layout! Floats should be cleared *outside* lists]
Additions:
~-WikkaLogicalDataModel
>>
Deletions:
~-WikkaLogicalDataModel>>

Revision [5921]

Edited on 2005-02-11 19:24:18 by JavaWoman [slight clarification about acls table]
Additions:
//stores the rights for reading/writing/commenting each page **if** those rights are different from the defaults defined in the configuration//
Deletions:
//stores the rights for reading/writing/commenting each page//

Revision [5899]

Edited on 2005-02-10 23:12:08 by JavaWoman [adding references]
Additions:
[[WikkaDocumentation Wikka Documentation]]
----
====The structure of the MySQL-Tables of Wikka====

>>See also:
~-WikkaPhysicalDataModel
~-WikkaLogicalDataModel>>
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 [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html 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//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}

==wikka_links==
//stores links between Wikka pages//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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]]//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}

==wikka_user==
//stores [[RegisterInfo registered]] users settings//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}
----
Deletions:
[[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 [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html 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//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}

==wikka_links==
//stores links between Wikka pages//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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]]//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}

==wikka_user==
//stores [[RegisterInfo registered]] users settings//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}
----

Revision [2519]

Edited on 2004-11-27 12:41:06 by DarTar [Making some minor modifications]
Additions:
[[WikkaDocumentation Wikka Documentation]]
//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//
{{table columns="6" cellpadding="1" cells="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"}}
//stores the rights for reading/writing/commenting each page//
//stores links between Wikka pages//
//stores URLs of sites referring to Wikka-pages from external domains//
{{table columns="6" cellpadding="1" cells="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 "}}
//stores domains masked from the [[ReferrersInfo referrer pages]]//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';blacklisted domain"}}
//stores [[RegisterInfo registered]] users settings//
//stores comments to Wikka pages//
Deletions:
[[HelpInfo Wikka Documentation]]
//a record corresponds to a version of a Wikka page, not only the current one//
{{table columns="6" cellpadding="1" cells="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"}}
//the rights for reading/writing/commenting (on) a page//
//the links between the Wikka-pages//
//list of pages referring to Wikka-pages from other domains?//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;page_tag;varchar;75;no;' ';name of the Wikka-page;referrer;varchar;150;no;' ';name of the referring page;time;datetime;###;no;'0000-00-00 00:00:00';date and time of the link to the page?"}}
//the list of pages not shown on the [[ReferrersInfo referrer pages]]?//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;spammer;varchar;150;no;' ';adress of the spammer?"}}
//obviously the [[RegisterInfo registered]] users of the wikka//
//all the comments in the wikka//

Revision [2505]

Edited on 2004-11-26 18:38:37 by NilsLindenberg [small edit (typing without thinking ;-)]
Additions:
All of the tables have the type [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html MyISAM]].
Deletions:
All of the page have the type [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html MyISAM]].

Revision [2499]

Edited on 2004-11-26 18:01:57 by NilsLindenberg [last table added]
Additions:
All of the page have the type [[http://dev.mysql.com/doc/mysql/en/MyISAM_storage_engine.html MyISAM]].
//list of pages referring to Wikka-pages from other domains?//
{{table columns="6" cellpadding="1" cells="Columm name;Type;Length;Null;Default;Description;page_tag;varchar;75;no;' ';name of the Wikka-page;referrer;varchar;150;no;' ';name of the referring page;time;datetime;###;no;'0000-00-00 00:00:00';date and time of the link to the page?"}}

Revision [2458]

Edited on 2004-11-25 17:34:28 by NilsLindenberg [some tables added]
Additions:
//the links between the Wikka-pages//
{{table columns="6" cellpadding="1" cells="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]]?//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}
Deletions:
//the links between the wikka-pages//
{{table columns="6" cellpadding="1" cells="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;"}}

Revision [2455]

Edited on 2004-11-25 16:58:08 by NilsLindenberg [added wikka_links]
Additions:
==wikka_links==
//the links between the wikka-pages//
{{table columns="6" cellpadding="1" cells="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;"}}

Revision [2415]

Edited on 2004-11-24 12:03:42 by NilsLindenberg [wikka_acls added]
Additions:
{{table columns="6" cellpadding="1" cells="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//
{{table columns="6" cellpadding="1" cells="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"}}
Deletions:
{{table columns="6" cellpadding="1" cells="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"}}

Revision [2393]

Edited on 2004-11-23 16:34:18 by DarTar [Small revision]
Additions:
The Wikka installer creates some tables necessary for storing Wikka data.
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//
{{table columns="6" cellpadding="1" cells="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"}}
Deletions:
The installer of Wikka creates some tables necessary for Wikka.
Example: ["table_prefix"]."pages
your choosen prefix: ""MyWikka""
=> name of the table: ""MyWikka"".pages
The tables presented below are withour the prefix!
==.pages==
//all versions of a page, not only the actuall one//
{{table columns="6" cellpadding="1" cells="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;' ';???;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"}}

Revision [2386]

Edited on 2004-11-23 14:50:03 by NilsLindenberg [minor layout change]
Additions:
{{table columns="6" cellpadding="1" cells="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;' ';???;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"}}
Deletions:
{{table columns="6" cellpadding="1" cells="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;' ';???;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"}}

Revision [2385]

The oldest known version of this page was created on 2004-11-23 14:43:49 by NilsLindenberg [minor layout change]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki