You need to remove the BEGIN and COMMIT statements - the tool we use to apply db patches already wraps the patches in a transaction, and adding them again will break things.
We want an index on Person.registrant (all references to Person have them, including ones like this where the small number of rows means they likely will never be used). Please add the following:
CREATE INDEX distribution__registrant__idx ON Distribution(registrant);
DB patch number is patch-2208-53-0.sql. You need to rename the .sql file and change the value being inserted into LaunchpadDatabaseRevision to match.
The DB change looks fine.
You need to remove the BEGIN and COMMIT statements - the tool we use to apply db patches already wraps the patches in a transaction, and adding them again will break things.
We want an index on Person.registrant (all references to Person have them, including ones like this where the small number of rows means they likely will never be used). Please add the following:
CREATE INDEX distribution_ _registrant_ _idx ON Distribution( registrant) ;
DB patch number is patch-2208- 53-0.sql. You need to rename the .sql file and change the value being inserted into LaunchpadDataba seRevision to match.