diff options
| author | Tor Andersson <tor@ccxvii.net> | 2021-05-17 00:56:38 +0200 |
|---|---|---|
| committer | Tor Andersson <tor@ccxvii.net> | 2021-05-17 00:56:38 +0200 |
| commit | 216c4053f4e27d98958151e7dd9bd2894166889b (patch) | |
| tree | 4e72b1d62d75dd15e57f08533990e4e7efd9ed1a /tools/sql | |
| parent | 30b4e77af028fc4899df1d7d145be6ff9e4335c8 (diff) | |
| download | server-216c4053f4e27d98958151e7dd9bd2894166889b.tar.gz | |
sql: Tweak schema layout.
Diffstat (limited to 'tools/sql')
| -rw-r--r-- | tools/sql/schema.txt | 4 |
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 ); |