blob: 0302a0dd49730937d0a3c386179e467082c85940 (
plain) (
blame)
1
2
3
4
5
6
7
8
|
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
);
|