summaryrefslogtreecommitdiffstats
path: root/crates/profile-service/migrations/20250726161947_profile.sql
diff options
context:
space:
mode:
authorrtkay123 <dev@kanjala.com>2025-07-27 18:16:41 +0200
committerrtkay123 <dev@kanjala.com>2025-07-27 18:16:41 +0200
commit3c4d17cf2840c643b8cd111ef775750cc5ae83b3 (patch)
tree2b7d25b24d94141a6d9255426d4f973cced5d278 /crates/profile-service/migrations/20250726161947_profile.sql
parente26d87f4fa18999c6bcfbcf32cfa85adab11acdd (diff)
downloadsellershut-3c4d17cf2840c643b8cd111ef775750cc5ae83b3.tar.bz2
sellershut-3c4d17cf2840c643b8cd111ef775750cc5ae83b3.zip
refactor: profile -> users
Diffstat (limited to 'crates/profile-service/migrations/20250726161947_profile.sql')
-rw-r--r--crates/profile-service/migrations/20250726161947_profile.sql32
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();