Switch from flat files to PostgreSQL.

[remoteglot] / remoteglot.sql

diff --git a/remoteglot.sql b/remoteglot.sql
new file mode 100644 (file)
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
+);