aboutsummaryrefslogtreecommitdiff
path: root/apps/web/migrations/0001_nervous_longshot.sql
diff options
context:
space:
mode:
authorcodetorso <[email protected]>2024-07-20 07:17:25 +0530
committercodetorso <[email protected]>2024-07-20 07:17:25 +0530
commit21fe55a96c36892fc50e8198248da825a5a4bd6f (patch)
tree83832e20adb0e4acfa529ac624e7f2b914f7a25a /apps/web/migrations/0001_nervous_longshot.sql
parentfix links (diff)
downloadsupermemory-torso.tar.xz
supermemory-torso.zip
for god's sake this should work ;)torso
Diffstat (limited to 'apps/web/migrations/0001_nervous_longshot.sql')
-rw-r--r--apps/web/migrations/0001_nervous_longshot.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/apps/web/migrations/0001_nervous_longshot.sql b/apps/web/migrations/0001_nervous_longshot.sql
new file mode 100644
index 00000000..a15917c6
--- /dev/null
+++ b/apps/web/migrations/0001_nervous_longshot.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `chatThread` ADD `createdAt` integer;
+UPDATE `chatThread` SET `createdAt` = strftime('%s', 'now') WHERE `createdAt` IS NULL;