[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_conduit.conduit_certificatetoken (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    userPHID VARCHAR(64) BINARY NOT NULL,
   4    token VARCHAR(64),
   5    dateCreated INT UNSIGNED NOT NULL,
   6    dateModified INT UNSIGNED NOT NULL
   7  );
   8  
   9  ALTER TABLE {$NAMESPACE}_conduit.conduit_certificatetoken
  10    ADD UNIQUE KEY (userPHID);
  11  ALTER TABLE {$NAMESPACE}_conduit.conduit_certificatetoken
  12    ADD UNIQUE KEY (token);