migrations/20251024000000_profile_storage.sql at main

smokesignal.events / smokesignal

fork atom

The smokesignal.events web application

fork atom

smokesignal / migrations / 20251024000000_profile_storage.sql

at main 10 lines 307 B view raw

wrap content

Nick Gerakines feature: profiles 4mo ago

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);