Differential D8344 Diff 19854 resources/sql/patches/110.commitaudit.sql

Changeset View

Standalone View

	ALTER TABLE {$NAMESPACE}_repository.repository_commit			ALTER TABLE {$NAMESPACE}_repository.repository_commit
	ADD mailKey VARCHAR(20) NOT NULL;			ADD mailKey VARCHAR(20) NOT NULL;

	ALTER TABLE {$NAMESPACE}_repository.repository_commit			ALTER TABLE {$NAMESPACE}_repository.repository_commit
	ADD authorPHID VARCHAR(64) BINARY;			ADD authorPHID VARCHAR(64) BINARY;

	ALTER TABLE {$NAMESPACE}_repository.repository_commit			ALTER TABLE {$NAMESPACE}_repository.repository_commit
	ADD auditStatus INT UNSIGNED NOT NULL;			ADD auditStatus INT UNSIGNED NOT NULL;

	ALTER TABLE {$NAMESPACE}_repository.repository_commit			ALTER TABLE {$NAMESPACE}_repository.repository_commit
	ADD KEY (authorPHID, auditStatus, epoch);			ADD KEY (authorPHID, auditStatus, epoch);
	No newline at end of file