From 1f52e962086856ddd6981139e2d4aca20201e9cb Mon Sep 17 00:00:00 2001
From: Pinapelz <yukais@pinapelz.com>
Date: Mon, 3 Aug 2026 12:34:55 -0700
Subject: create group streak schema and db scaffold

---
 server/db/groups.ts | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 server/db/groups.ts

(limited to 'server/db/groups.ts')

diff --git a/server/db/groups.ts b/server/db/groups.ts
new file mode 100644
index 0000000..1060501
--- /dev/null
+++ b/server/db/groups.ts
@@ -0,0 +1,27 @@
+import { db } from "./index";
+import crypto from "node:crypto";
+
+export function createGroup(name: string) {
+    const id = crypto.randomUUID();
+    const joinCode = crypto
+        .randomBytes(3)
+        .toString("hex")
+        .toUpperCase();
+
+    db.prepare(`
+        INSERT INTO groups
+        (id, name, join_code, created_at)
+        VALUES (?, ?, ?, ?)
+    `).run(
+        id,
+        name,
+        joinCode,
+        Date.now()
+    );
+
+    return {
+        id,
+        name,
+        joinCode
+    };
+}
-- 
cgit v1.2.3