Difference between revisions of "Database Table: sitekeywords"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
m (Robot: Updating: Format, definition)
 
Line 4: Line 4:
 
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