Difference between revisions of "Database Table: sitekeywords"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with '{{Database Table|name=sitekeywords|table type=global}} Category:Database Tables Needing Description = Definition = <source lang="sql"> CREATE TABLE sitekeywords ( kwid IN…')
 
m (Robot: Updating: Format, definition)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Database Table|name=sitekeywords|table type=global}}
+
{{Database Table|name=sitekeywords|table type=global|need desc=1|repo=dw-free}}
[[Category:Database Tables Needing Description]]
+
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE sitekeywords (
 
CREATE TABLE sitekeywords (
 
     kwid INT(10) UNSIGNED NOT NULL,
 
     kwid INT(10) UNSIGNED NOT NULL,
     keyword VARCHAR(255) NOT NULL,
+
     keyword VARCHAR(255) BINARY NOT NULL,
  
 
     PRIMARY KEY (kwid),
 
     PRIMARY KEY (kwid),

Latest revision as of 17:21, 29 October 2010

This is a global table.

Definition

CREATE TABLE sitekeywords (
    kwid INT(10) UNSIGNED NOT NULL,
    keyword VARCHAR(255) BINARY NOT NULL,
 
    PRIMARY KEY (kwid),
    UNIQUE KEY (keyword)
)

Relationships