From 216c4053f4e27d98958151e7dd9bd2894166889b Mon Sep 17 00:00:00 2001 From: Tor Andersson Date: Mon, 17 May 2021 00:56:38 +0200 Subject: sql: Tweak schema layout. --- tools/sql/schema.txt | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'tools/sql/schema.txt') diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt index d9502c2..227d861 100644 --- a/tools/sql/schema.txt +++ b/tools/sql/schema.txt @@ -32,12 +32,12 @@ CREATE TABLE IF NOT EXISTS games ( owner INTEGER, private BOOLEAN, random BOOLEAN, + description TEXT, ctime TIMESTAMP, mtime TIMESTAMP, - description TEXT, status INTEGER, - active TEXT, result TEXT, + active TEXT, state TEXT, chat TEXT ); -- cgit v1.2.3