github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/migrations/010_compute_engine.sql (about)

     1  -- +goose Up
     2  CREATE TYPE COMPUTE_MACHINE_TYPE AS ENUM ('e2-standard-4', 'n2-standard-2', 'c2-standard-4');
     3  
     4  CREATE TABLE IF NOT EXISTS compute_instances (
     5      "team_id" TEXT NOT NULL,
     6      "instance_name" TEXT NOT NULL,
     7      "machine_type" COMPUTE_MACHINE_TYPE NOT NULL,
     8      PRIMARY KEY(team_id),
     9      CONSTRAINT fk_compute_instances_team
    10      FOREIGN KEY (team_id)
    11          REFERENCES teams (id) ON DELETE CASCADE
    12  );
    13  
    14  -- +goose Down
    15  DROP TABLE compute_instances;
    16  DROP TYPE COMPUTE_MACHINE_TYPE;