api.spaceplanner.app

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

2024-09-19T19:22:03.sql (258B)

      1 BEGIN;
      2 
      3 ALTER TABLE spaceplanner.floorplan_pointmaps ADD COLUMN door_swing varchar;
      4 ALTER TABLE spaceplanner.floorplan_pointmaps ADD CONSTRAINT check_door_swing
      5 	CHECK (door_swing = 'a+' OR door_swing = 'a-' OR door_swing = 'b+' OR door_swing = 'b-');
      6 
      7 END;