Database Table: ml langs

From Dreamwidth Notes
Revision as of 17:28, 22 March 2009 by SlowSculpture (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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