Difference between revisions of "Database Table: s2categories"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table s2categories)
 
m (Robot: Updating: Format, definition)
 
Line 5: Line 5:
 
     s2lid INT UNSIGNED NOT NULL,
 
     s2lid INT UNSIGNED NOT NULL,
 
     kwid INT(10) UNSIGNED NOT NULL,
 
     kwid INT(10) UNSIGNED NOT NULL,
     active TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,  
+
     active TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
  
     PRIMARY KEY (s2lid, kwid)  
+
     PRIMARY KEY (s2lid, kwid)
 
)
 
)
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 19:32, 22 September 2011

This is a global table.

Definition

CREATE TABLE s2categories (
    s2lid INT UNSIGNED NOT NULL,
    kwid INT(10) UNSIGNED NOT NULL,
    active TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
 
    PRIMARY KEY (s2lid, kwid)
)

Relationships