diff options
| author | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-16 02:52:52 +0900 |
|---|---|---|
| committer | Masaya Tojo <masaya@tojo.tokyo> | 2024-03-16 02:53:18 +0900 |
| commit | a86f747e0db4bde6bc598a5ade8949cd8b3a4b3f (patch) | |
| tree | 9646eec94b30df5c0e182f18b90761099e0c8f87 /deploy/tags.sql | |
| parent | 5cb0091b87c3f5519dbfffdf1d709cce316d427e (diff) | |
Make primary key type of tags table int.
Diffstat (limited to 'deploy/tags.sql')
| -rw-r--r-- | deploy/tags.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/deploy/tags.sql b/deploy/tags.sql index d66bca5..3bee8ed 100644 --- a/deploy/tags.sql +++ b/deploy/tags.sql @@ -6,8 +6,8 @@ BEGIN; SET search_path to diary; CREATE TABLE tags( - id UUID PRIMARY KEY, - name TEXT UNIQUE NOT NULL + id INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY, + name varchar UNIQUE NOT NULL ); COMMIT; |