api.spaceplanner.app

Spaceplanner API
git clone git://jacobedwards.org/api.spaceplanner.app
Log | Files | Refs

2024-09-21T18:24:31.sql (1135B)

      1 BEGIN;
      2 
      3 ALTER TABLE spaceplanner.furniture_varieties DROP CONSTRAINT furniture_varieties_pkey;
      4 ALTER TABLE spaceplanner.furniture_varieties ADD CONSTRAINT furniture_varieties_pkey PRIMARY KEY (name, type);
      5 ALTER TABLE spaceplanner.furniture_varieties DROP CONSTRAINT varieties_unique_name_within_type;
      6 
      7 INSERT INTO spaceplanner.furniture_types (name)
      8 	VALUES ('dresser'), ('nightstand'), ('cabinet'), ('sofa'),
      9 	('chaise'), ('any');
     10 
     11 INSERT INTO spaceplanner.furniture_varieties (name, type, width, depth)
     12 VALUES (
     13 	'Default', 'table', spaceplanner.in(72), spaceplanner.in(72)
     14 ), (
     15 	'Default', 'dresser', spaceplanner.in(60), spaceplanner.in(20)
     16 ), (
     17 	'Default', 'nightstand', spaceplanner.in(28), spaceplanner.in(18)
     18 ), (
     19 	'Default', 'cabinet', spaceplanner.in(38), spaceplanner.in(18)
     20 ), (
     21 	'Club Chair', 'sofa', spaceplanner.in(36), spaceplanner.in(38)
     22 ), (
     23 	'Loveseat', 'sofa', spaceplanner.in(63), spaceplanner.in(38)
     24 ), (
     25 	'Three seats', 'sofa', spaceplanner.in(90), spaceplanner.in(38)
     26 ), (
     27 	'Default', 'chaise', spaceplanner.in(38), spaceplanner.in(80)
     28 ), (
     29 	'Default', 'any', spaceplanner.in(32), spaceplanner.in(32)
     30 );
     31 
     32 END;