From 87f48c963423f26d04791bc402bd45fb8dbbdb46 Mon Sep 17 00:00:00 2001 From: Star Rauchenberger 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