20151219.proj.10.subcolumns.sql
571960e71227stable

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);