Difference between revisions of "Database Table: ml langdomains"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: This table needs a description.)
(Robot: Updating: Format)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{Database Table|name=ml_langdomains|table type=global}}
+
{{Database Table|name=ml_langdomains|table type=global|need desc=1|repo=dw-free}}
[[Category:Database Tables Needing Description]]
+
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
CREATE TABLE ml_langdomains
+
CREATE TABLE ml_langdomains (
(
+
    lnid  SMALLINT UNSIGNED NOT NULL,
  lnid  SMALLINT UNSIGNED NOT NULL,
+
    dmid  TINYINT UNSIGNED NOT NULL,
  dmid  TINYINT UNSIGNED NOT NULL,
+
    PRIMARY KEY (lnid, dmid),
  PRIMARY KEY (lnid, dmid),
+
    dmmaster ENUM('0','1') NOT NULL,
  dmmaster ENUM('0','1') NOT NULL,
+
    lastgetnew DATETIME,
  lastgetnew DATETIME,
+
    lastpublish DATETIME,
  lastpublish DATETIME,
+
    countokay    SMALLINT UNSIGNED NOT NULL,
  countokay    SMALLINT UNSIGNED NOT NULL,
+
    counttotal  SMALLINT UNSIGNED NOT NULL
  counttotal  SMALLINT UNSIGNED NOT NULL
+
 
)
 
)
 
</source>
 
</source>
 
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 16:01, 22 July 2010

This is a global table.

Definition

CREATE TABLE ml_langdomains (
    lnid   SMALLINT UNSIGNED NOT NULL,
    dmid   TINYINT UNSIGNED NOT NULL,
    PRIMARY KEY (lnid, dmid),
    dmmaster ENUM('0','1') NOT NULL,
    lastgetnew DATETIME,
    lastpublish DATETIME,
    countokay    SMALLINT UNSIGNED NOT NULL,
    counttotal   SMALLINT UNSIGNED NOT NULL
)

Relationships