ALTER TABLE {$NAMESPACE}_file.file
  ADD COLUMN authorPHID VARCHAR(64) BINARY,
  ADD KEY (authorPHID);