[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_project.project
   2    ADD subprojectPHIDs longblob NOT NULL;
   3  UPDATE {$NAMESPACE}_project.project
   4    SET subprojectPHIDs = '[]';
   5  
   6  CREATE TABLE {$NAMESPACE}_project.project_subproject (
   7    projectPHID varchar(64) BINARY NOT NULL,
   8    subprojectPHID varchar(64) BINARY NOT NULL,
   9    PRIMARY KEY (subprojectPHID, projectPHID),
  10    UNIQUE KEY (projectPHID, subprojectPHID)
  11  ) ENGINE=InnoDB;