Differential D11454 Diff 27586 resources/sql/patches/061.phrictioncontent.sql

Changeset View

Standalone View

Show All 9 Lines	CREATE TABLE {$NAMESPACE}_phriction.phriction_content (
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,		id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
documentID INT UNSIGNED NOT NULL,		documentID INT UNSIGNED NOT NULL,
version INT UNSIGNED NOT NULL,		version INT UNSIGNED NOT NULL,
UNIQUE KEY (documentID, version),		UNIQUE KEY (documentID, version),
authorPHID VARCHAR(64) BINARY NOT NULL,		authorPHID VARCHAR(64) BINARY NOT NULL,
KEY (authorPHID),		KEY (authorPHID),
title VARCHAR(512) NOT NULL,		title VARCHAR(512) NOT NULL,
slug VARCHAR(512) NOT NULL,		slug VARCHAR(512) NOT NULL,
KEY (slug),		KEY (slug(128)),
content LONGBLOB NOT NULL,		content LONGBLOB NOT NULL,
dateCreated INT UNSIGNED NOT NULL,		dateCreated INT UNSIGNED NOT NULL,
dateModified INT UNSIGNED NOT NULL		dateModified INT UNSIGNED NOT NULL
) ENGINE=InnoDB;		) ENGINE=InnoDB;