← Back to team overview

launchpad-reviewers team mailing list archive

[Merge] ~alvarocs/launchpad:update-patch-craft-platforms into launchpad:db-devel

 

Alvaro Crespo Serrano has proposed merging ~alvarocs/launchpad:update-patch-craft-platforms into launchpad:db-devel.

Commit message:
Remove index creation for 'craft_platform' in recipe build tables

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~alvarocs/launchpad/+git/launchpad/+merge/483919
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~alvarocs/launchpad:update-patch-craft-platforms into launchpad:db-devel.
diff --git a/database/schema/patch-2211-33-0.sql b/database/schema/patch-2211-33-0.sql
index 96e2d07..def35ae 100644
--- a/database/schema/patch-2211-33-0.sql
+++ b/database/schema/patch-2211-33-0.sql
@@ -13,13 +13,4 @@ COMMENT ON COLUMN RockRecipeBuild.craft_platform IS 'The platform name from the 
 COMMENT ON COLUMN SnapBuild.craft_platform IS 'The platform name from the Snap recipe for which the Snap artifact is built.';
 COMMENT ON COLUMN SourcePackageRecipeBuild.craft_platform IS 'The platform name from the Source recipe for which the Source artifact is built.';
 
-CREATE INDEX charmrecipebuild__craft_platform__idx
-    ON CharmRecipeBuild (craft_platform);
-CREATE INDEX rockrecipebuild__craft_platform__idx
-    ON RockRecipeBuild (craft_platform);
-CREATE INDEX snapbuild__craft_platform__idx
-    ON SnapBuild (craft_platform);
-CREATE INDEX sourcepackagerecipebuild__craft_platform__idx
-    ON SourcePackageRecipeBuild (craft_platform);
-
 INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 33, 0);

References