diff --git a/resources/sql/autopatches/20140927.schema.02.pholio1.sql b/resources/sql/autopatches/20140927.schema.02.pholio1.sql new file mode 100644 --- /dev/null +++ b/resources/sql/autopatches/20140927.schema.02.pholio1.sql @@ -0,0 +1,2 @@ +ALTER TABLE {$NAMESPACE}_pholio.pholio_transaction_comment + DROP KEY `key_draft`; diff --git a/resources/sql/autopatches/20140927.schema.03.pholio2.sql b/resources/sql/autopatches/20140927.schema.03.pholio2.sql new file mode 100644 --- /dev/null +++ b/resources/sql/autopatches/20140927.schema.03.pholio2.sql @@ -0,0 +1,2 @@ +ALTER TABLE {$NAMESPACE}_pholio.pholio_transaction_comment + ADD UNIQUE KEY `key_draft` (authorPHID, imageID, transactionPHID); diff --git a/resources/sql/autopatches/20140927.schema.04.pholio3.sql b/resources/sql/autopatches/20140927.schema.04.pholio3.sql new file mode 100644 --- /dev/null +++ b/resources/sql/autopatches/20140927.schema.04.pholio3.sql @@ -0,0 +1,2 @@ +ALTER TABLE {$NAMESPACE}_pholio.pholio_transaction_comment + DROP COLUMN mockID; diff --git a/resources/sql/autopatches/20140927.schema.05.phragment1.sql b/resources/sql/autopatches/20140927.schema.05.phragment1.sql new file mode 100644 --- /dev/null +++ b/resources/sql/autopatches/20140927.schema.05.phragment1.sql @@ -0,0 +1,2 @@ +ALTER TABLE {$NAMESPACE}_phragment.phragment_snapshot + DROP COLUMN description; diff --git a/resources/sql/autopatches/20140927.schema.06.releeph1.sql b/resources/sql/autopatches/20140927.schema.06.releeph1.sql new file mode 100644 --- /dev/null +++ b/resources/sql/autopatches/20140927.schema.06.releeph1.sql @@ -0,0 +1,2 @@ +ALTER TABLE {$NAMESPACE}_releeph.releeph_request + DROP COLUMN summary; diff --git a/src/applications/releeph/storage/ReleephRequest.php b/src/applications/releeph/storage/ReleephRequest.php --- a/src/applications/releeph/storage/ReleephRequest.php +++ b/src/applications/releeph/storage/ReleephRequest.php @@ -154,8 +154,7 @@ 'userIntents' => self::SERIALIZATION_JSON, ), self::CONFIG_COLUMN_SCHEMA => array( - 'summary' => 'text', - 'requstCommitPHID' => 'phid?', + 'requestCommitPHID' => 'phid?', 'commitIdentifier' => 'text40', 'pickStatus' => 'uint32', 'inBranch' => 'bool',