summaryrefslogtreecommitdiff
path: root/tools/sql/schema.txt
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2021-05-17 00:56:38 +0200
committerTor Andersson <tor@ccxvii.net>2021-05-17 00:56:38 +0200
commit216c4053f4e27d98958151e7dd9bd2894166889b (patch)
tree4e72b1d62d75dd15e57f08533990e4e7efd9ed1a /tools/sql/schema.txt
parent30b4e77af028fc4899df1d7d145be6ff9e4335c8 (diff)
downloadserver-216c4053f4e27d98958151e7dd9bd2894166889b.tar.gz
sql: Tweak schema layout.
Diffstat (limited to 'tools/sql/schema.txt')
-rw-r--r--tools/sql/schema.txt4
1 files changed, 2 insertions, 2 deletions
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
);