From 190bd7f073e77eb538731506a92a175880aef24e Mon Sep 17 00:00:00 2001
From: Cara Salter <cara@devcara.com>
Date: Tue, 29 Aug 2023 20:51:38 -0400
Subject: Init database connector

---
 migrations/20230829204517_create_plant_table.up.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 migrations/20230829204517_create_plant_table.up.sql

(limited to 'migrations/20230829204517_create_plant_table.up.sql')

diff --git a/migrations/20230829204517_create_plant_table.up.sql b/migrations/20230829204517_create_plant_table.up.sql
new file mode 100644
index 0000000..0302a0d
--- /dev/null
+++ b/migrations/20230829204517_create_plant_table.up.sql
@@ -0,0 +1,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
+);
-- 
cgit v1.2.3

