From 87f48c963423f26d04791bc402bd45fb8dbbdb46 Mon Sep 17 00:00:00 2001
From: Star Rauchenberger <fefferburbia@gmail.com>
Date: Wed, 29 Nov 2023 23:36:03 -0500
Subject: Added web schema

---
 web/schema.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 web/schema.sql

(limited to 'web/schema.sql')

diff --git a/web/schema.sql b/web/schema.sql
new file mode 100644
index 0000000..2f87906
--- /dev/null
+++ b/web/schema.sql
@@ -0,0 +1,9 @@
+CREATE TABLE `lingo_scores` (
+  `id` INTEGER PRIMARY KEY,
+  `user_id` INTEGER,
+  `username` VARCHAR(255),
+  `avatar_url` VARCHAR(255),
+  `score` INTEGER,
+  `created_at` DATETIME NOT NULL,
+  `updated_at` DATETIME NOT NULL
+);
-- 
cgit 1.4.1

