diff options
-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; |