Difference between revisions of "Database Table: ml langdomains"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{Database Table|name=ml_langdomains|table type=global|need desc=1|repo=dw-free}}
 
= 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}}
= Relationships =
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|ml_langdomains]]
+

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