Difference between revisions of "Database.pluto main.TextCategory"

From LinuxMCE
Jump to: navigation, search
(DB table pluto_main.TextCategory)
 
m
 
Line 22: Line 22:
 
===Field description===
 
===Field description===
 
: PK_TextCategory : Identification of the text item (primary key)
 
: PK_TextCategory : Identification of the text item (primary key)
: FK_TextCategory : Reference to PK_TextCategory to define the parent element of the current category. NULL for top level elements
+
: 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
 
: Description : Name of the category
 
: psc_* : All related to version control by [[sqlCVS]]
 
: psc_* : All related to version control by [[sqlCVS]]

Latest revision as of 18:58, 7 July 2009


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