phorge-phorge/resources/sql/autopatches/20140115.legalpadsigkey.sql at master - revi-archive/phorge-phorge - SiliconForest Atelier

revi-archive/phorge-phorge

mirror of https://we.phorge.it/source/phorge.git synced 2024-09-19 16:58:48 +02:00

Bob Trahan d740374cca Legalpad - add policy rule for legalpad document signatures

Summary:
Ref T3116. This creates a policy rule where you can require a signature on a given legalpad document.

NOTE: signatures must be for the *latest* document version.

Test Plan: made a task have a custom policy requiring a legalpad signature. verified non-signers were locked out.

Reviewers: epriestley

Reviewed By: epriestley

CC: Korvin, epriestley, aran

Maniphest Tasks: T3116

Differential Revision: https://secure.phabricator.com/D7977

2014-01-15 16:48:44 -08:00

5 lines

225 B

SQL

Raw Permalink Blame History

 ALTER TABLE {$NAMESPACE}_legalpad.legalpad_documentsignature
   DROP KEY `key_document`;
 ALTER TABLE {$NAMESPACE}_legalpad.legalpad_documentsignature
   ADD KEY `key_document` (`documentPHID`,`signerPHID`, `documentVersion`);