Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit0f51d90

Browse files
committed
fixup! chore: update v1 schema
1 parent064c27f commit0f51d90

File tree

2 files changed

+8
-0
lines changed

2 files changed

+8
-0
lines changed

‎coderd/database/migrations/000001_base.down.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -5,6 +5,7 @@ DROP TRIGGER trig_uuid_to_longid_users ON users;
55
DROPTRIGGER trig_uuid_to_longid_organizationsON organizations;
66
DROPTRIGGER trig_uuid_to_longid_organization_members_user_idON organization_members;
77
DROPTRIGGER trig_uuid_to_longid_organization_members_org_idON organization_members;
8+
DROPTRIGGER trig_uuid_to_longid_api_keys_user_idON api_keys;
89

910
DROPFUNCTION org_uuid_to_longid_trigger;
1011
DROPFUNCTION user_uuid_to_longid_trigger;

‎coderd/database/migrations/000001_base.up.sql

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -229,6 +229,13 @@ EXCEPTION
229229
WHEN duplicate_object THENnull;
230230
END $$;
231231

232+
CREATE TRIGGER
233+
trig_uuid_to_longid_api_keys_user_id
234+
BEFORE INSERTON
235+
api_keys
236+
FOR EACH ROW EXECUTE PROCEDURE
237+
user_uuid_to_longid_trigger();
238+
232239
CREATETABLEIF NOT EXISTS licenses (
233240
idserial,
234241
license jsonbNOT NULL,

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp