diff options
Diffstat (limited to 'tools/sql')
| -rw-r--r-- | tools/sql/schema.txt | 3 |
1 files changed, 0 insertions, 3 deletions
diff --git a/tools/sql/schema.txt b/tools/sql/schema.txt index 71b6f72..e731c8c 100644 --- a/tools/sql/schema.txt +++ b/tools/sql/schema.txt @@ -153,12 +153,9 @@ CREATE VIEW game_view AS , games.status , games.result , games.active AS active_role - , active.user_id AS active_id - , active.user_name AS active_name -- , games.state FROM games JOIN titles USING ( title_id ) JOIN users AS owner ON games.owner_id = owner.user_id LEFT JOIN player_list_view AS players USING ( game_id ) - LEFT JOIN player_view AS active ON games.game_id = active.game_id AND games.active = active.role ; |