mirror of
https://github.com/ysoftdevs/odc-analyzer.git
synced 2026-01-13 15:23:59 +01:00
18 lines
1001 B
SQL
18 lines
1001 B
SQL
# --- !Ups
|
|
ALTER TABLE "exported_diff_db_vulnerabilities" ADD "done" BOOLEAN NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE "exported_email_vulnerabilities" ADD "done" BOOLEAN NOT NULL DEFAULT FALSE;
|
|
ALTER TABLE "exported_issue_tracker_vulnerabilities" ADD "done" BOOLEAN NOT NULL DEFAULT FALSE;
|
|
|
|
CREATE INDEX "idx_exported_diff_db_vulnerabilities_done" ON "exported_diff_db_vulnerabilities" ("done");
|
|
CREATE INDEX "idx_exported_email_vulnerabilities_done" ON "exported_email_vulnerabilities" ("done");
|
|
CREATE INDEX "idx_exported_issue_tracker_vulnerabilities_done" ON "exported_issue_tracker_vulnerabilities" ("done");
|
|
|
|
# --- !Downs
|
|
DROP INDEX "idx_exported_diff_db_vulnerabilities_done";
|
|
DROP INDEX "idx_exported_email_vulnerabilities_done";
|
|
DROP INDEX "idx_exported_issue_tracker_vulnerabilities_done";
|
|
|
|
ALTER TABLE "exported_diff_db_vulnerabilities" DROP COLUMN "done";
|
|
ALTER TABLE "exported_email_vulnerabilities" DROP COLUMN "done";
|
|
ALTER TABLE "exported_issue_tracker_vulnerabilities" DROP COLUMN "done";
|