20131206.phragment.sql
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

20131206.phragment.sql
View Options

	CREATE TABLE {$NAMESPACE}_phragment.phragment_fragment (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
	path VARCHAR(254) NOT NULL COLLATE utf8_bin,
	depth INT UNSIGNED NOT NULL,
	latestVersionPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
	editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_phid` (phid),
	UNIQUE KEY `key_path` (path)
	) ENGINE=InnoDB, COLLATE utf8_general_ci;

	CREATE TABLE {$NAMESPACE}_phragment.phragment_fragmentversion (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
	sequence INT UNSIGNED NOT NULL,
	fragmentPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
	filePHID VARCHAR(64) NULL COLLATE utf8_bin,
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_version` (fragmentPHID, sequence)
	) ENGINE=InnoDB, COLLATE utf8_general_ci;