From a7d56ba0f54273920743109fe1a6541030f3c003 Mon Sep 17 00:00:00 2001
From: Ilion Beyst <ilion.beyst@gmail.com>
Date: Mon, 9 May 2022 19:41:33 +0200
Subject: add ratings table

---
 .../migrations/2022-04-28-171349_create_rating/up.sql              | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 planetwars-server/migrations/2022-04-28-171349_create_rating/up.sql

(limited to 'planetwars-server/migrations/2022-04-28-171349_create_rating/up.sql')

diff --git a/planetwars-server/migrations/2022-04-28-171349_create_rating/up.sql b/planetwars-server/migrations/2022-04-28-171349_create_rating/up.sql
new file mode 100644
index 0000000..39fe6fe
--- /dev/null
+++ b/planetwars-server/migrations/2022-04-28-171349_create_rating/up.sql
@@ -0,0 +1,7 @@
+-- Your SQL goes here
+-- this table could later be expanded to include more information,
+-- such as rating state (eg. number of matches played) or scope (eg. map)
+create table ratings (
+    bot_id integer PRIMARY KEY REFERENCES bots(id),
+    rating float NOT NULL
+)
\ No newline at end of file
-- 
cgit v1.2.3

