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

diff --git a/remoteglot.sql b/remoteglot.sql
new file mode 100644
index 0000000..ed5d1d8
--- /dev/null
+++ b/remoteglot.sql
@@ -0,0 +1,16 @@
+CREATE TABLE scores (
+	id varchar primary key,
+	plot_score integer not null,
+	short_score varchar not null,
+	engine varchar not null,
+	depth bigint not null,
+	nodes bigint not null
+);
+
+CREATE TABLE clock_info (
+	id varchar primary key,
+	white_clock integer,
+	black_clock integer,
+	white_clock_target integer,  -- FIXME: really timestamp with time zone
+	black_clock_target integer   -- FIXME: really timestamp with time zone
+);