Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/autopatches/20151219.proj.10.subcolumns.sql
- This file was added.
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); |