Difference between revisions of "Database Table: ml langdomains"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'ml_langdomains =Definition= <source lang="sql"> CREATE TABLE ml_langdomains ( lnid SMALLINT UNSIGNED NOT NULL, dmid TINYINT UNSIGNED NOT NU...')
 
(Robot: Updating: Format)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category: Database Table|ml_langdomains]]
+
{{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]]
+

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