diff options
Diffstat (limited to 'crates/profile-service/migrations')
-rw-r--r-- | crates/profile-service/migrations/20250726161947_profile.sql | 32 |
1 files changed, 0 insertions, 32 deletions
diff --git a/crates/profile-service/migrations/20250726161947_profile.sql b/crates/profile-service/migrations/20250726161947_profile.sql deleted file mode 100644 index 15822c8..0000000 --- a/crates/profile-service/migrations/20250726161947_profile.sql +++ /dev/null @@ -1,32 +0,0 @@ -create table profile ( - id text primary key, - username varchar(30) not null, - inbox text not null, - outbox text, - local boolean not null, - avatar_url text, - description text, - user_type text not null check ( - user_type IN ('PERSON', 'APPLICATION', 'GROUP', 'ORGANIZATION', 'SERVICE') - ), - created_at timestamptz not null default now(), - updated_at timestamptz not null default now(), - public_key text not null -); - -create unique index unique_username_local - on profile (username) - where local = true; - -create or replace function set_updated_at() -returns trigger as $$ -begin - new.updated_at := now(); - return new; -end; -$$ language plpgsql; - -create trigger trigger_set_updated_at -before update on profile -for each row -execute function set_updated_at(); |