http://wiki.linuxmce.org/index.php?action=history&feed=atom&title=Database.pluto_main.TextCategory 2026-07-22T03:47:57Z Revision history for this page on the wiki MediaWiki 1.44.0 http://wiki.linuxmce.org/index.php?title=Database.pluto_main.TextCategory&diff=19637&oldid=prev 2009-07-07T17:58:27Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:58, 7 July 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l22">Line 22:</td> <td colspan="2" class="diff-lineno">Line 22:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Field description===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Field description===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: PK_TextCategory : Identification of the text item (primary key)</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: PK_TextCategory : Identification of the text item (primary key)</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>: <del style="font-weight: bold; text-decoration: none;">FK_TextCategory </del>: Reference to PK_TextCategory to define the parent element of the current category. NULL for top level elements</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>: <ins style="font-weight: bold; text-decoration: none;">FK_TextCategory_Parent </ins>: Reference to PK_TextCategory to define the parent element of the current category. NULL for top level elements</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: Description : Name of the category</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: Description : Name of the category</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: psc_* : All related to version control by [[sqlCVS]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>: psc_* : All related to version control by [[sqlCVS]]</div></td></tr> </table>

Chriss http://wiki.linuxmce.org/index.php?title=Database.pluto_main.TextCategory&diff=19636&oldid=prev 2009-07-07T17:57:23Z

<p>DB table pluto_main.TextCategory</p> <p><b>New page</b></p><div>[[Category:Development]]<br /> [[Category:Database]]<br /> <br /> The table pluto_main.TextCategory describes a tree-like category system for the GUI text elements defined in [[Database.pluto_main.Text|pluto_main.Text]]<br /> <br /> ===SQL definition===<br /> CREATE TABLE `TextCategory` (<br /> `PK_TextCategory` int(11) NOT NULL auto_increment,<br /> `FK_TextCategory_Parent` int(11) default NULL,<br /> `Description` varchar(100) default NULL,<br /> `psc_id` int(11) default NULL,<br /> `psc_batch` int(11) default NULL,<br /> `psc_user` int(11) default NULL,<br /> `psc_frozen` tinyint(1) default &#039;0&#039;,<br /> `psc_mod` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,<br /> `psc_restrict` int(11) default NULL,<br /> PRIMARY KEY (`PK_TextCategory`),<br /> UNIQUE KEY `psc_id` (`psc_id`)<br /> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br /> <br /> <br /> ===Field description===<br /> : PK_TextCategory : Identification of the text item (primary key)<br /> : FK_TextCategory : Reference to PK_TextCategory to define the parent element of the current category. NULL for top level elements<br /> : Description : Name of the category<br /> : psc_* : All related to version control by [[sqlCVS]]</div>

Chriss