Tushar Gupta has proposed merging ~tushar5526/launchpad:validate-git-repository-url-constraints into launchpad:master.
Requested reviews: Launchpad code reviewers (launchpad-reviewers) For more details, see: https://code.launchpad.net/~tushar5526/launchpad/+git/launchpad/+merge/486255 -- Your team Launchpad code reviewers is requested to review the proposed merge of ~tushar5526/launchpad:validate-git-repository-url-constraints into launchpad:master.
diff --git a/database/schema/patch-2211-41-1.sql b/database/schema/patch-2211-41-1.sql new file mode 100644 index 0000000..10c1046 --- /dev/null +++ b/database/schema/patch-2211-41-1.sql @@ -0,0 +1,14 @@ +-- Copyright 2025 Canonical Ltd. This software is licensed under the +-- GNU Affero General Public License version 3 (see the file LICENSE). + +SET client_min_messages=ERROR; + +ALTER TABLE CharmRecipe VALIDATE CONSTRAINT consistent_git_ref; + +ALTER TABLE CharmRecipe VALIDATE CONSTRAINT consistent_vcs; + +ALTER TABLE CharmRecipe VALIDATE CONSTRAINT valid_git_repository_url; + +CREATE INDEX charmrecipe__git_repository_url__idx ON CharmRecipe(git_repository_url); + +INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 41, 1);
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : launchpad-reviewers@lists.launchpad.net Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
