View source for Database.pluto main.Text

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

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_Language_TextPlacement : ''TBD''
: Description : Text string displayed in the GUI
: Define : ''TBD''
: AddToOrbiter : ''TBD''
: psc_* : All related to version control by [[sqlCVS]]