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/orcl_all.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'res/sql/orcl_all.sql') diff --git a/res/sql/orcl_all.sql b/res/sql/orcl_all.sql index b0367de..08015f4 100644 --- a/res/sql/orcl_all.sql +++ b/res/sql/orcl_all.sql @@ -222,6 +222,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 @@ -249,6 +250,7 @@ CREATE OR REPLACE VIEW accounts AS GROUP BY best_bidder_uuid ) sales ON sales.best_bidder_uuid = users.uuid; + INSERT INTO USERS (UUID, USERNAME, EMAIL, USER_PASSWORD, CREATION_DATE, FIRST_NAME, LAST_NAME, COUNTRY_CODE, POSTAL_CODE, ADDRESS, PHONE, BIRTHDATE) VALUES ('0C99BEF9-375F-3E4A-E050-D7936EBE2782', 'duf', 'duf@gmail.com', '123456', TO_TIMESTAMP_TZ('2000-01-01 00:00:00.000000', 'YYYY-MM-DD Hh24:MI:SS.FF'), 'Francis', 'Dumas', 'FR', '86544', -- cgit v1.2.3