Difference between revisions of "Database Table: logslugs"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table logslugs)
 
(No difference)

Latest revision as of 04:04, 8 June 2013

This is a clustered table.

Definition

CREATE TABLE `logslugs` (
  `journalid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `jitemid` mediumint(8) UNSIGNED NOT NULL,
  `slug` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`journalid`,`jitemid`),
  UNIQUE KEY `journalid` (`journalid`,`slug`)
)

Relationships