migrations/20250412093710_component.sql - develop - pyo/updater

migrations/20250412093710_component.sql

22 строки549 B

ilovepitsa

restore from another repo

16 июн 2025, 13:25

16 июн 2025, 13:25d7455bb

-- +goose Up
-- +goose StatementBegin
CREATE TABLE component (
    id              BIGSERIAL PRIMARY KEY,
    name            TEXT NOT NULL,
    display_name    TEXT NOT NULL,
    state           TEXT NOT NULL,
    type            INT NOT NULL,
    author          TEXT NOT NULL,
    icon            TEXT NOT NULL,
    price           real NOT NULL,
    homepage        TEXT,
    description     TEXT,
    publisher       TEXT NOT NULL
);

-- +goose StatementEnd

-- +goose Down
-- +goose StatementBegin
DROP TABLE component;
-- +goose StatementEnd