Database.pluto main.TextCategory
From LinuxMCE
The table pluto_main.TextCategory describes a tree-like category system for the GUI text elements defined in pluto_main.Text
SQL definition
CREATE TABLE `TextCategory` ( `PK_TextCategory` int(11) NOT NULL auto_increment, `FK_TextCategory_Parent` int(11) default NULL, `Description` varchar(100) default NULL, `psc_id` int(11) default NULL, `psc_batch` int(11) default NULL, `psc_user` int(11) default NULL, `psc_frozen` tinyint(1) default '0', `psc_mod` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `psc_restrict` int(11) default NULL, PRIMARY KEY (`PK_TextCategory`), UNIQUE KEY `psc_id` (`psc_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Field description
- PK_TextCategory : Identification of the text item (primary key)
- FK_TextCategory_Parent : Reference to PK_TextCategory to define the parent element of the current category. NULL for top level elements
- Description : Name of the category
- psc_* : All related to version control by sqlCVS