serendipty01.dev / smokesignal
forked from smokesignal.events/smokesignal
The smokesignal.events web application
fork atom
smokesignal / migrations / 20251024000000_profile_storage.sql
at main 10 lines 307 B view raw
Nick Gerakines feature: profiles
30356aad
1CREATE TABLE profiles ( 2 aturi VARCHAR(1024) PRIMARY KEY, 3 cid VARCHAR(256) NOT NULL, 4 did VARCHAR(256) NOT NULL, 5 display_name VARCHAR(1024) NOT NULL, 6 record JSON NOT NULL, 7 updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW () 8); 9 10CREATE INDEX idx_profiles_did ON profiles (did);