Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20150828.webpush.create.sql
- This file was added.
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; |