Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/064.subprojects.sql
| ALTER TABLE {$NAMESPACE}_project.project | ALTER TABLE {$NAMESPACE}_project.project | ||||
| ADD subprojectPHIDs longblob NOT NULL; | ADD subprojectPHIDs longblob NOT NULL; | ||||
| UPDATE {$NAMESPACE}_project.project | UPDATE {$NAMESPACE}_project.project | ||||
| SET subprojectPHIDs = '[]'; | SET subprojectPHIDs = '[]'; | ||||
| CREATE TABLE {$NAMESPACE}_project.project_subproject ( | CREATE TABLE {$NAMESPACE}_project.project_subproject ( | ||||
| projectPHID varchar(64) BINARY NOT NULL, | projectPHID varchar(64) BINARY NOT NULL, | ||||
| subprojectPHID varchar(64) BINARY NOT NULL, | subprojectPHID varchar(64) BINARY NOT NULL, | ||||
| PRIMARY KEY (subprojectPHID, projectPHID), | PRIMARY KEY (subprojectPHID, projectPHID), | ||||
| UNIQUE KEY (projectPHID, subprojectPHID) | UNIQUE KEY (projectPHID, subprojectPHID) | ||||
| ) ENGINE=InnoDB; | ) ENGINE=InnoDB; | ||||
| No newline at end of file | |||||