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