Database.pluto main.Text LS

From LinuxMCE
Revision as of 18:50, 7 July 2009 by Chriss (Talk | contribs) (DB table pluto_main.TextLS)

(diff) ←Older revision | view current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search


The table pluto_main.TextLS contains overlays for the text elements defined in Text to allow for localization of the GUI.

SQL definition

CREATE TABLE `Text_LS` (
  `FK_Text` int(11) NOT NULL default '0',
  `FK_Language` int(11) NOT NULL default '0',
  `Description` longtext NOT 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  (`FK_Text`,`FK_Language`),
  UNIQUE KEY `psc_id` (`psc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Field description

FK_Text : Reference to pluto_main.Text.PK_Text. Defines the text item that is translated
FK_Language : Reference to pluto_main.Language.PK_Language. Defines the language the translation belongs to
Description : Translated text
psc_* : All related to version control by sqlCVS