diff options
Diffstat (limited to 'res/sql/pg_all.sql')
-rw-r--r-- | res/sql/pg_all.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/res/sql/pg_all.sql b/res/sql/pg_all.sql index b76cb88..5d763e0 100644 --- a/res/sql/pg_all.sql +++ b/res/sql/pg_all.sql | |||
@@ -196,6 +196,7 @@ CREATE OR REPLACE VIEW accounts AS | |||
196 | 196 | ||
197 | SELECT | 197 | SELECT |
198 | users.uuid AS user_uuid, | 198 | users.uuid AS user_uuid, |
199 | users.username AS username, | ||
199 | COALESCE(transactions.balance, 0) AS balance, | 200 | COALESCE(transactions.balance, 0) AS balance, |
200 | COALESCE(sales.open_bids, 0) AS open_bids, | 201 | COALESCE(sales.open_bids, 0) AS open_bids, |
201 | COALESCE(transactions.balance, 0) - COALESCE(sales.open_bids, 0) AS equity | 202 | COALESCE(transactions.balance, 0) - COALESCE(sales.open_bids, 0) AS equity |
@@ -223,6 +224,7 @@ CREATE OR REPLACE VIEW accounts AS | |||
223 | GROUP BY best_bidder_uuid | 224 | GROUP BY best_bidder_uuid |
224 | ) sales | 225 | ) sales |
225 | ON sales.best_bidder_uuid = users.uuid; | 226 | ON sales.best_bidder_uuid = users.uuid; |
227 | |||
226 | INSERT INTO USERS (UUID, USERNAME, EMAIL, USER_PASSWORD, CREATION_DATE, FIRST_NAME, LAST_NAME, COUNTRY_CODE, POSTAL_CODE, ADDRESS, PHONE, BIRTHDATE) | 228 | INSERT INTO USERS (UUID, USERNAME, EMAIL, USER_PASSWORD, CREATION_DATE, FIRST_NAME, LAST_NAME, COUNTRY_CODE, POSTAL_CODE, ADDRESS, PHONE, BIRTHDATE) |
227 | VALUES | 229 | VALUES |
228 | ('0C99BEF9-375F-3E4A-E050-D7936EBE2782', 'duf', 'duf@gmail.com', '123456', '2000-01-01 00:00:00.000000', 'Francis', | 230 | ('0C99BEF9-375F-3E4A-E050-D7936EBE2782', 'duf', 'duf@gmail.com', '123456', '2000-01-01 00:00:00.000000', 'Francis', |