http://wiki.linuxmce.org/index.php?title=Database.pluto_main.TextCategory&feed=atom&action=history
Database.pluto main.TextCategory - Revision history
2024-03-28T08:57:10Z
Revision history for this page on the wiki
MediaWiki 1.24.1
http://wiki.linuxmce.org/index.php?title=Database.pluto_main.TextCategory&diff=19637&oldid=prev
Chriss at 17:58, 7 July 2009
2009-07-07T17:58:27Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">←Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 17:58, 7 July 2009</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 22:</td>
<td colspan="2" class="diff-lineno">Line 22:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>===Field description===</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>===Field description===</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; 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: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; 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'>−</td><td style="color:black; 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 class="diffchange diffchange-inline">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'>+</td><td style="color:black; 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 class="diffchange diffchange-inline">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: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>: Description : Name of the category</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; 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: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; 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: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; 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
Chriss: DB table pluto_main.TextCategory
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 '0',<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