From 3d22cb7d1ee6bdf7b484bbf001c76e81ae351dea Mon Sep 17 00:00:00 2001
From: Pacien TRAN-GIRARD
Date: Sat, 7 Feb 2015 23:57:36 +0100
Subject: Update accounts view to include usernames

---
 res/sql/views/orcl_accounts.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'res/sql/views/orcl_accounts.sql')

diff --git a/res/sql/views/orcl_accounts.sql b/res/sql/views/orcl_accounts.sql
index 400d38f..f3f5d6e 100644
--- a/res/sql/views/orcl_accounts.sql
+++ b/res/sql/views/orcl_accounts.sql
@@ -2,6 +2,7 @@ CREATE OR REPLACE VIEW accounts AS
 
   SELECT
     users.uuid                                                       AS user_uuid,
+    users.username                                                   AS username,
     COALESCE(transactions.balance, 0)                                AS balance,
     COALESCE(sales.open_bids, 0)                                     AS open_bids,
     COALESCE(transactions.balance, 0) - COALESCE(sales.open_bids, 0) AS equity
-- 
cgit v1.2.3

