20151219.proj.10.subcolumns.sql
47d8cee39e23production

20151219.proj.10.subcolumns.sql
View Options

			ALTER TABLE {$NAMESPACE}_project.project
			ADD parentProjectPHID VARBINARY(64);

			ALTER TABLE {$NAMESPACE}_project.project
			ADD hasWorkboard BOOL NOT NULL;

			ALTER TABLE {$NAMESPACE}_project.project
			ADD hasMilestones BOOL NOT NULL;

			ALTER TABLE {$NAMESPACE}_project.project
			ADD hasSubprojects BOOL NOT NULL;

			ALTER TABLE {$NAMESPACE}_project.project
			ADD milestoneNumber INT UNSIGNED;

			ALTER TABLE {$NAMESPACE}_project.project
			ADD UNIQUE KEY `key_milestone` (parentProjectPHID, milestoneNumber);