api.spaceplanner.app

commit 4865e3c543765cce96f2054b143ed911eca3275b
parent 6b319947d4ffa38e70529fd9f909c722aca88293
Author: Jacob R. Edwards <jacob@jacobedwards.org>
Date:   Mon, 23 Sep 2024 13:37:48 -0700

Add more furniture types

I believe I'm going to rework the furniture type system to allow
any number of sub-types, or at least one sub-type in the future,
but this will let us get by for now.

Diffstat:
A
cmd/api/migration/2024-09-21T18:24:31.sql
 | 
32
++++++++++++++++++++++++++++++++

1 file changed, 32 insertions(+), 0 deletions(-)
diff --git a/cmd/api/migration/2024-09-21T18:24:31.sql b/cmd/api/migration/2024-09-21T18:24:31.sql
@@ -0,0 +1,32 @@
+BEGIN;
+
+ALTER TABLE spaceplanner.furniture_varieties DROP CONSTRAINT furniture_varieties_pkey;
+ALTER TABLE spaceplanner.furniture_varieties ADD CONSTRAINT furniture_varieties_pkey PRIMARY KEY (name, type);
+ALTER TABLE spaceplanner.furniture_varieties DROP CONSTRAINT varieties_unique_name_within_type;
+
+INSERT INTO spaceplanner.furniture_types (name)
+	VALUES ('dresser'), ('nightstand'), ('cabinet'), ('sofa'),
+	('chaise'), ('any');
+
+INSERT INTO spaceplanner.furniture_varieties (name, type, width, depth)
+VALUES (
+	'Default', 'table', spaceplanner.in(72), spaceplanner.in(72)
+), (
+	'Default', 'dresser', spaceplanner.in(60), spaceplanner.in(20)
+), (
+	'Default', 'nightstand', spaceplanner.in(28), spaceplanner.in(18)
+), (
+	'Default', 'cabinet', spaceplanner.in(38), spaceplanner.in(18)
+), (
+	'Club Chair', 'sofa', spaceplanner.in(36), spaceplanner.in(38)
+), (
+	'Loveseat', 'sofa', spaceplanner.in(63), spaceplanner.in(38)
+), (
+	'Three seats', 'sofa', spaceplanner.in(90), spaceplanner.in(38)
+), (
+	'Default', 'chaise', spaceplanner.in(38), spaceplanner.in(80)
+), (
+	'Default', 'any', spaceplanner.in(32), spaceplanner.in(32)
+);
+
+END;