Viewing File: /home/ubuntu/code-backup/code_review/phabricator/resources/sql/patches/064.subprojects.sql

ALTER TABLE {$NAMESPACE}_project.project
  ADD subprojectPHIDs longblob NOT NULL;
UPDATE {$NAMESPACE}_project.project
  SET subprojectPHIDs = '[]';

CREATE TABLE {$NAMESPACE}_project.project_subproject (
  projectPHID varchar(64) BINARY NOT NULL,
  subprojectPHID varchar(64) BINARY NOT NULL,
  PRIMARY KEY (subprojectPHID, projectPHID),
  UNIQUE KEY (projectPHID, subprojectPHID)
) ENGINE=InnoDB;