Differential D14011 Diff 33879 resources/sql/autopatches/20150828.webpush.create.sql

Changeset View

Standalone View

				CREATE TABLE {$NAMESPACE}_user.user_webpushsubscriber (
				id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
				userPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
				subscriptionId VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_bin,
				endpoint VARCHAR(128) CHARACTER SET latin1 COLLATE latin1_bin,
				userAgent VARCHAR(255),
				dateCreated INT UNSIGNED NOT NULL,
				dateModified INT UNSIGNED NOT NULL,
				UNIQUE KEY `key_subscriber` (subscriptionId, endpoint),
				KEY `key_user` (subscriptionId, endpoint)
				) ENGINE=InnoDB, COLLATE utf8_general_ci;