23 lines
626 B
SQL
23 lines
626 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
CREATE TABLE IF NOT EXISTS "opportunity_marks" (
|
|
"uuid" TEXT NOT NULL UNIQUE,
|
|
"hidden" BOOLEAN NOT NULL DEFAULT 0,
|
|
"skipped" BOOLEAN NOT NULL DEFAULT 0,
|
|
"interested" BOOLEAN NOT NULL DEFAULT 0,
|
|
"bid_submitted" BOOLEAN NOT NULL DEFAULT 0,
|
|
"lost" BOOLEAN NOT NULL DEFAULT 0,
|
|
"won" BOOLEAN NOT NULL DEFAULT 0,
|
|
CHECK (NOT ("won" AND "lost")),
|
|
PRIMARY KEY ("uuid"),
|
|
FOREIGN KEY ("uuid")
|
|
REFERENCES "opportunities" ("uuid")
|
|
ON DELETE CASCADE
|
|
);
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
DROP TABLE IF EXISTS "opportunity_marks";
|
|
-- +goose StatementEnd
|