Differential D8344 Diff 19854 resources/sql/patches/060.phriction.sql

Changeset View

Standalone View



	CREATE TABLE {$NAMESPACE}_phriction.phriction_document (			CREATE TABLE {$NAMESPACE}_phriction.phriction_document (
	id INT UNSIGNED NOT NULL,			id INT UNSIGNED NOT NULL,
	phid VARCHAR(64) BINARY NOT NULL,			phid VARCHAR(64) BINARY NOT NULL,
	UNIQUE KEY (phid),			UNIQUE KEY (phid),
	slug VARCHAR(128) NOT NULL,			slug VARCHAR(128) NOT NULL,
	UNIQUE KEY (slug),			UNIQUE KEY (slug),
	depth INT UNSIGNED NOT NULL,			depth INT UNSIGNED NOT NULL,
	UNIQUE KEY (depth, slug),			UNIQUE KEY (depth, slug),
	contentID INT UNSIGNED NOT NULL			contentID INT UNSIGNED NOT NULL
	) ENGINE=InnoDB;			) ENGINE=InnoDB;