Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20190116.contact.01.number.sql
- This file was added.
CREATE TABLE {$NAMESPACE}_auth.auth_contactnumber ( | |||||
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | |||||
phid VARBINARY(64) NOT NULL, | |||||
objectPHID VARBINARY(64) NOT NULL, | |||||
contactNumber VARCHAR(255) NOT NULL COLLATE {$COLLATE_TEXT}, | |||||
status VARCHAR(32) NOT NULL COLLATE {$COLLATE_TEXT}, | |||||
properties LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT}, | |||||
uniqueKey BINARY(12), | |||||
dateCreated INT UNSIGNED NOT NULL, | |||||
dateModified INT UNSIGNED NOT NULL | |||||
) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT}; |