Differential D15489 Diff 37338 resources/sql/autopatches/20160317.lfs.01.ref.sql

Changeset View

Standalone View

				CREATE TABLE {$NAMESPACE}_repository.repository_gitlfsref (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				repositoryPHID VARBINARY(64) NOT NULL,
				objectHash BINARY(64) NOT NULL,
				byteSize BIGINT UNSIGNED NOT NULL,
				authorPHID VARBINARY(64) NOT NULL,
				filePHID VARBINARY(64) NOT NULL,
				dateCreated INT UNSIGNED NOT NULL,
				dateModified INT UNSIGNED NOT NULL,
				UNIQUE KEY `key_hash` (repositoryPHID, objectHash)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};