migrations/20230829205506_create_stead_table.up.sql


1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE Stead (
    id SERIAL PRIMARY KEY,
    username TEXT NOT NULL UNIQUE,
    password TEXT NOT NULL,
    inventory JSONB,
    ephemeral_statuses TEXT[]
);

CREATE TABLE stead_plant (
    stead INTEGER references stead(id),
    plant INTEGER references plant(id)
);