change TelemetryItem's key to PK

coder · hugodutka · Jan 31, 2025 · Jan 29, 2025 · Jan 30, 2025 · Jan 30, 2025
commit 6554aa31eface2a15ebee877972b66f1255ca96e
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000288_telemetry_items.up.sql b/coderd/database/migrations/000288_telemetry_items.up.sql
@@ -1,8 +1,6 @@
 CREATE TABLE telemetry_items (
-    key TEXT NOT NULL,
+    key TEXT NOT NULL PRIMARY KEY,
     value TEXT NOT NULL,
     created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
     updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
 );
-
-CREATE UNIQUE INDEX telemetry_items_key_idx ON telemetry_items (key);
diff --git a/coderd/database/unique_constraint.go b/coderd/database/unique_constraint.go