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

From LinuxMCE
Jump to: navigation, search
m (Corrected field description)
m (Maybe I should use the preview button :()
 
Line 23: Line 23:
 
===Field description===
 
===Field description===
 
: PK_Text : Identification of the text item (primary key)
 
: PK_Text : Identification of the text item (primary key)
: FK_TextCategory : Reference to [[Database.pluto_main.TextCategory||pluto_main.TextCategory.PK_TextCategory]] to select the category the text item belongs to
+
: FK_TextCategory : Reference to [[Database.pluto_main.TextCategory|pluto_main.TextCategory.PK_TextCategory]] to select the category the text item belongs to
 
: Description : Text string displayed in the GUI
 
: Description : Text string displayed in the GUI
 
: Define : ''TBD''
 
: Define : ''TBD''
 
: AddToOrbiter : ''TBD''
 
: AddToOrbiter : ''TBD''
 
: psc_* : All related to version control by [[sqlCVS]]
 
: psc_* : All related to version control by [[sqlCVS]]

Latest revision as of 18:54, 7 July 2009


The table pluto_main.Text contains all text elements displayed in the GUI.

SQL definition

CREATE TABLE `Text` (
  `PK_Text` int(11) NOT NULL auto_increment,
  `FK_TextCategory` int(11) NOT NULL default '0',
  `Description` varchar(40) NOT NULL,
  `Define` varchar(40) NOT NULL,
  `AddToOrbiter` tinyint(1) default '0',
  `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_Text`),
  UNIQUE KEY `psc_id` (`psc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Field description

PK_Text : Identification of the text item (primary key)
FK_TextCategory : Reference to pluto_main.TextCategory.PK_TextCategory to select the category the text item belongs to
Description : Text string displayed in the GUI
Define : TBD
AddToOrbiter : TBD
psc_* : All related to version control by sqlCVS