api.spaceplanner.app

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

2024-07-27T05:11:12.sql (278B)

      1 CREATE TABLE user_settings (
      2 	username varchar(128),
      3 	name varchar,
      4 	strval varchar,
      5 	numval int,
      6 	boolval bool,
      7 	PRIMARY KEY (username, name),
      8 	CONSTRAINT one_value_type CHECK (
      9 		(strval IS NOT NULL)::int +
     10 		(numval IS NOT NULL)::int +
     11 		(boolval IS NOT NULL)::int = 1
     12 	)
     13 );