View source for Database.pluto main.Text LS

[[Category:Development]]
[[Category:Database]]

The table pluto_main.TextLS contains overlays for the text elements defined in [[Database.pluto_main.Text|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 [[Database.pluto_main.Text|pluto_main.Text.PK_Text]]. Defines the text item that is translated
: FK_Language : Reference to [[Database.pluto_main.Language|pluto_main.Language.PK_Language]]. Defines the language the translation belongs to
: Description : Translated text
: psc_* : All related to version control by [[sqlCVS]]