Use the prettyprinted files from the protobuf. Leave the old code in place in case...

[remoteglot] / remoteglot.sql

diff --git a/remoteglot.sql b/remoteglot.sql
index ed5d1d8f1d44c1c8beb2344f6697b8e8d7251f07..af0456f03497abd2c5da832770c596103d1d7cc0 100644 (file)
--- 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,
+);