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

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