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, needs desc, definition)
Line 1: Line 1:
{{Database Table|name=ml_langdomains|table type=global}}
+
{{Database Table|name=ml_langdomains|table type=global|need desc=1}}
[[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}}

Revision as of 07:07, 28 January 2010

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. 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