Differential D8344 Diff 19854 resources/sql/patches/064.subprojects.sql

Changeset View

Standalone View

	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