summary refs log tree commit diff stats
diff options
context:
space:
mode:
-rw-r--r--web/schema.sql9
1 files changed, 9 insertions, 0 deletions
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 @@
1CREATE TABLE `lingo_scores` (
2 `id` INTEGER PRIMARY KEY,
3 `user_id` INTEGER,
4 `username` VARCHAR(255),
5 `avatar_url` VARCHAR(255),
6 `score` INTEGER,
7 `created_at` DATETIME NOT NULL,
8 `updated_at` DATETIME NOT NULL
9);