From 6fd1663d8c27fbfd5adc93a3aa973f78a2eeb719 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Sat, 22 Feb 2025 13:35:17 +0100
Subject: chore(tfstated): change database state id and version id formats to
 uuidv7

---
 pkg/database/sql/000_init.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'pkg/database/sql/000_init.sql')

diff --git a/pkg/database/sql/000_init.sql b/pkg/database/sql/000_init.sql
index 3530e52..0e52c60 100644
--- a/pkg/database/sql/000_init.sql
+++ b/pkg/database/sql/000_init.sql
@@ -24,7 +24,7 @@ CREATE TABLE sessions (
 ) STRICT;
 
 CREATE TABLE states (
-  id INTEGER PRIMARY KEY,
+  id TEXT PRIMARY KEY,
   path TEXT NOT NULL,
   lock TEXT,
   created INTEGER DEFAULT (unixepoch()),
@@ -33,9 +33,9 @@ CREATE TABLE states (
 CREATE UNIQUE INDEX states_path on states(path);
 
 CREATE TABLE versions (
-  id INTEGER PRIMARY KEY,
+  id TEXT PRIMARY KEY,
   account_id TEXT NOT NULL,
-  state_id INTEGER,
+  state_id TEXT,
   data BLOB,
   lock TEXT,
   created INTEGER DEFAULT (unixepoch()),
-- 
cgit v1.2.3

