From a86f747e0db4bde6bc598a5ade8949cd8b3a4b3f Mon Sep 17 00:00:00 2001
From: Masaya Tojo <masaya@tojo.tokyo>
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

