Differential D16783 Diff 40423 resources/sql/autopatches/20161031.calendar.02.notifylog.sql

Changeset View

Standalone View

				CREATE TABLE {$NAMESPACE}_calendar.calendar_notification (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				eventPHID VARBINARY(64) NOT NULL,
				utcInitialEpoch INT UNSIGNED NOT NULL,
				targetPHID VARBINARY(64) NOT NULL,
				didNotifyEpoch INT UNSIGNED NOT NULL,
				UNIQUE KEY `key_notify` (eventPHID, utcInitialEpoch, targetPHID)
				) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};