← back to Patterndesignlab

db/002_designer_accounts.sql

23 lines

-- 002 — designer accounts + full profile fields (additive, idempotent).
-- Turns the bare designers table into patternbank-style studio profiles with sign-in.
ALTER TABLE designers ADD COLUMN IF NOT EXISTS founder_name  TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS tagline       TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS email         TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS password_hash TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS city          TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS state_region  TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS logo          TEXT;   -- designer-uploaded logo (separate from avatar photo)
ALTER TABLE designers ADD COLUMN IF NOT EXISTS accent_hex    TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS website       TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS instagram     TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS pinterest     TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS tiktok        TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS facebook      TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS twitter       TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS youtube       TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS linkedin      TEXT;
ALTER TABLE designers ADD COLUMN IF NOT EXISTS updated_at    TIMESTAMPTZ NOT NULL DEFAULT now();

-- unique login email (partial: only when set)
CREATE UNIQUE INDEX IF NOT EXISTS designers_email_uniq ON designers (lower(email)) WHERE email IS NOT NULL;