api.spaceplanner.app

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

2024-10-14T17:00:02.sql (411B)

      1 BEGIN;
      2 
      3 CREATE TABLE spaceplanner.pointmap_types (
      4 	name varchar PRIMARY KEY
      5 );
      6 
      7 INSERT INTO spaceplanner.pointmap_types (name)
      8 	VALUES ('wall'), ('door'), ('window'), ('railing');
      9 
     10 ALTER TABLE spaceplanner.floorplan_pointmaps
     11 	DROP CONSTRAINT valid_type;
     12 ALTER TABLE spaceplanner.floorplan_pointmaps
     13 	ADD CONSTRAINT pointmaps_type_fkey FOREIGN KEY (type) REFERENCES spaceplanner.pointmap_types(name);
     14 
     15 COMMIT;