api.spaceplanner.app

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

2024-08-07T22:35:44.sql (253B)

      1 # Hopefully 'This was an empty name' isn't already a floorplan name
      2 UPDATE spaceplanner.floorplans SET name = 'This was an empty name' WHERE LENGTH(name) = 0 ;
      3 
      4 ALTER TABLE spaceplanner.floorplans ADD CONSTRAINT non_zero_name CHECK (LENGTH(name) > 0) ;