X-Git-Url: https://git.sesse.net/?p=remoteglot;a=blobdiff_plain;f=remoteglot.sql;h=af0456f03497abd2c5da832770c596103d1d7cc0;hp=ed5d1d8f1d44c1c8beb2344f6697b8e8d7251f07;hb=94f448c82ea3da610c8aca0030f977d1f54741d6;hpb=65d6dd1d5f4d8bf2ddd868339d22d40821b8983c

diff --git a/remoteglot.sql b/remoteglot.sql
index ed5d1d8..af0456f 100644
--- a/remoteglot.sql
+++ b/remoteglot.sql
@@ -1,7 +1,7 @@
 CREATE TABLE scores (
 	id varchar primary key,
-	plot_score integer not null,
-	short_score varchar not null,
+	score_type varchar not null,
+	score_value integer,
 	engine varchar not null,
 	depth bigint not null,
 	nodes bigint not null
@@ -14,3 +14,11 @@ CREATE TABLE clock_info (
 	white_clock_target integer,  -- FIXME: really timestamp with time zone
 	black_clock_target integer   -- FIXME: really timestamp with time zone
 );
+
+CREATE TABLE current_games (
+	id varchar not null primary key,
+	json_path varchar not null,
+	url varchar not null,
+	hashurl varchar not null,
+	priority integer not null default 0,
+);