aboutsummaryrefslogtreecommitdiff
path: root/res/sql/pg_all.sql
diff options
context:
space:
mode:
Diffstat (limited to 'res/sql/pg_all.sql')
-rw-r--r--res/sql/pg_all.sql2
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
226INSERT INTO USERS (UUID, USERNAME, EMAIL, USER_PASSWORD, CREATION_DATE, FIRST_NAME, LAST_NAME, COUNTRY_CODE, POSTAL_CODE, ADDRESS, PHONE, BIRTHDATE) 228INSERT INTO USERS (UUID, USERNAME, EMAIL, USER_PASSWORD, CREATION_DATE, FIRST_NAME, LAST_NAME, COUNTRY_CODE, POSTAL_CODE, ADDRESS, PHONE, BIRTHDATE)
227VALUES 229VALUES
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',