X-Git-Url: https://git.sesse.net/?p=remoteglot;a=blobdiff_plain;f=remoteglot.sql;h=4ad748cfa086f03db462611f978e200de04865e9;hp=ed5d1d8f1d44c1c8beb2344f6697b8e8d7251f07;hb=960b6ea34239ae508e3ab9841665fd7ba390fba3;hpb=65d6dd1d5f4d8bf2ddd868339d22d40821b8983c;ds=sidebyside diff --git a/remoteglot.sql b/remoteglot.sql index ed5d1d8..4ad748c 100644 --- a/remoteglot.sql +++ b/remoteglot.sql @@ -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, +);