064.subprojects.sql
No OneTemporary
Actions

Size

398 B

Referenced Files

None

Subscribers

None

064.subprojects.sql
View Options

	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;