path: root/migrations/20230829204517_create_plant_table.up.sql

CREATE TYPE plant_kind AS ENUM('bbc', 'hvv', 'cyl', 'dirt');
CREATE TABLE Plant (
    id SERIAL PRIMARY KEY,
    kind plant_kind NOT NULL DEFAULT 'dirt',
    xp INTEGER NOT NULL DEFAULT 0,
    xp_multiplier FLOAT NOT NULL DEFAULT 1,
    next_yield TIMESTAMP
);