From a86f747e0db4bde6bc598a5ade8949cd8b3a4b3f Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Sat, 16 Mar 2024 02:52:52 +0900 Subject: Make primary key type of tags table int. --- deploy/tags.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'deploy/tags.sql') 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; -- cgit v1.2.3