Jump to content

Database.pluto main.Language: Difference between revisions

From LinuxMCE
Chriss (talk | contribs)
Documentation for DB table pluto_main.Language
 
Chriss (talk | contribs)
m Added categories
 
Line 1: Line 1:
[[Category:Development]]
[[Category:Database]]
The table pluto_main.Language contains definitions for all available languages for the GUI.
The table pluto_main.Language contains definitions for all available languages for the GUI.



Latest revision as of 17:41, 7 July 2009


The table pluto_main.Language contains definitions for all available languages for the GUI.

SQL definition

CREATE TABLE `Language` (
  `PK_Language` int(11) NOT NULL auto_increment,
  `Description` varchar(30) NOT NULL,
  `FK_Language_TextPlacement` int(11) 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_Language`),
  UNIQUE KEY `psc_id` (`psc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Field description

PK_Language : Identification of the language (primary key)
Description : Name of the language to be displayed for selection
FK_Language_TextPlacement : TBD
psc_* : All related to version control by sqlCVS