resources/sql/patches/065.sshkeys.sql at recaptime-dev/main

@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge

phorge phabricator

fork atom

phorge / resources / sql / patches / 065.sshkeys.sql

at recaptime-dev/main 12 lines 370 B view raw

wrap content

epriestley Provide `bin/storage quickstart` to automate generation of `quickstart.sql` 11y ago

0d7489da

 1CREATE 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;