046.conduittoken.sql
No OneTemporary
Actions

Size

426 B

Referenced Files

None

Subscribers

None

046.conduittoken.sql
View Options

	CREATE TABLE {$NAMESPACE}_conduit.conduit_certificatetoken (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	userPHID VARCHAR(64) BINARY NOT NULL,
	token VARCHAR(64),
	dateCreated INT UNSIGNED NOT NULL,
	dateModified INT UNSIGNED NOT NULL
	);

	ALTER TABLE {$NAMESPACE}_conduit.conduit_certificatetoken
	ADD UNIQUE KEY (userPHID);
	ALTER TABLE {$NAMESPACE}_conduit.conduit_certificatetoken
	ADD UNIQUE KEY (token);