web/schema.sql


1
2
3
4
5
6
7
8
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
);