Difference between revisions of "Database Table: ml langs"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'ml_langs =Definition= <source lang="sql"> CREATE TABLE ml_langs ( lnid SMALLINT UNSIGNED NOT NULL, UNIQUE (lnid), lncode VARCHAR(16) ...')
 
Line 1: Line 1:
[[Category: Database Table|ml_langs]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE ml_langs
 
CREATE TABLE ml_langs
Line 15: Line 15:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=Location=
 
 
[[Global database]]
 
[[Global database]]
 +
 +
[[Category: Database Tables|ml_langs]]

Revision as of 11:24, 2 April 2009

Definition

CREATE TABLE ml_langs
(
   lnid      SMALLINT UNSIGNED NOT NULL,
   UNIQUE (lnid),
   lncode   VARCHAR(16) NOT NULL,  # en_US en_LJ en ch_HK ch_B5 etc... de_DE
   UNIQUE (lncode),
   lnname   VARCHAR(60) NOT NULL,   # "Deutsch"
   parenttype   ENUM('diff','sim') NOT NULL,
   parentlnid   SMALLINT UNSIGNED NOT NULL,
   lastupdate  DATETIME NOT NULL
)

Relationships

Location

Global database