github.com/google/syzkaller@v0.0.0-20251211124644-a066d2bc4b02/syz-cluster/pkg/db/migrations/1_initialize.down.sql (about)

     1  -- Delete constraints first as these may create ciruclar dependencies.
     2  ALTER TABLE Patches DROP CONSTRAINT FK_SeriesPatches;
     3  ALTER TABLE Builds DROP CONSTRAINT FK_Series;
     4  ALTER TABLE Sessions DROP CONSTRAINT FK_SeriesSessions;
     5  ALTER TABLE Series DROP CONSTRAINT FK_SeriesLatestSession;
     6  ALTER TABLE SessionTests DROP CONSTRAINT FK_SessionResults;
     7  ALTER TABLE SessionTests DROP CONSTRAINT FK_BaseBuild;
     8  ALTER TABLE SessionTests DROP CONSTRAINT FK_PatchedBuild;
     9  ALTER TABLE Findings DROP CONSTRAINT FK_SessionCrashes;
    10  ALTER TABLE Findings DROP CONSTRAINT FK_TestCrashes;
    11  ALTER TABLE SessionReports DROP CONSTRAINT FK_SessionReports;
    12  ALTER TABLE ReportReplies DROP CONSTRAINT FK_ReplyReportID;
    13  
    14  -- Spanner does not let drop tables without first deleting the indices.
    15  DROP INDEX SeriesByPublishedAt;
    16  DROP INDEX SeriesByExtID;
    17  DROP INDEX PatchesBySeriesAndSeq;
    18  DROP INDEX LastSuccessfulBuild;
    19  DROP INDEX SessionsByFinishedAt;
    20  DROP INDEX NoDupFindings;
    21  DROP INDEX NoDupSessionReports;
    22  DROP INDEX SessionReportsByStatus;
    23  
    24  DROP TABLE ReportReplies;
    25  DROP TABLE Findings;
    26  DROP TABLE SessionTests;
    27  DROP TABLE SessionReports;
    28  DROP TABLE Patches;
    29  DROP TABLE Builds;
    30  DROP TABLE Sessions;
    31  DROP TABLE Series;