api.spaceplanner.app

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

2024-08-26T21:38:46.sql (436B)

      1 BEGIN;
      2 
      3 ALTER TABLE spaceplanner.users ADD COLUMN stripe_customer_id varchar UNIQUE;
      4 ALTER TABLE spaceplanner.users ADD COLUMN verified_email varchar;
      5 
      6 CREATE TABLE spaceplanner.email_codes (
      7 	username varchar REFERENCES spaceplanner.users(name) ON DELETE CASCADE NOT NULL,
      8 	email varchar NOT NULL,
      9 	code varchar NOT NULL,
     10 	created timestamp DEFAULT now() NOT NULL,
     11 	CONSTRAINT unique_user_email_pair UNIQUE (username, email)
     12 ) ;
     13 
     14 END;