X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=remoteglot.sql;h=7d06b35635338eee635ef57f25bb533c8415c2f4;hb=83aa0538ddb9037d37295f7e6e68348773661d7a;hp=ed5d1d8f1d44c1c8beb2344f6697b8e8d7251f07;hpb=65d6dd1d5f4d8bf2ddd868339d22d40821b8983c;p=remoteglot

diff --git a/remoteglot.sql b/remoteglot.sql
index ed5d1d8..7d06b35 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,10 @@ 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,
+	priority integer not null default 0,
+);