[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_user.user_sshkey (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    userPHID varchar(64) BINARY NOT NULL,
   4    key (userPHID),
   5    name varchar(255),
   6    keyType varchar(255),
   7    keyBody LONGBLOB,
   8    unique key (keyBody(128)),
   9    keyComment varchar(255),
  10    dateCreated INT UNSIGNED NOT NULL,
  11    dateModified INT UNSIGNED NOT NULL
  12  ) ENGINE=InnoDB;