OpenSim/DB/0.9.0/totalsales の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• OpenSim/DB/0.9.0/totalsales へ行く。
• OpenSim/DB/0.9.0/totalsales の差分を削除

#author("2024-09-02T04:45:29+00:00","default:iseki","iseki")
*** Columns [#wf28b968]
 mysql> show columns from totalsales;
 +-------------+--------------+------+-----+---------+-------+
 | Field       | Type         | Null | Key | Default | Extra |
 +-------------+--------------+------+-----+---------+-------+
 | UUID        | varchar(36)  | NO   | PRI | NULL    |       |
 | user        | varchar(128) | NO   |     | NULL    |       |
 | objectUUID  | varchar(36)  | YES  |     | NULL    |       |
 | type        | int(10)      | NO   |     | NULL    |       |
 | TotalCount  | int(10)      | NO   |     | 0       |       |
 | TotalAmount | int(10)      | NO   |     | 0       |       |
 +-------------+--------------+------+-----+---------+-------+
 7 rows in set (0.00 sec)
*** Command [#ja0fcc59]
- transactions テーブルから生成
 SELECT receiver,objectUUID,type,COUNT(*),SUM(amount) FROM transactions WHERE sender<>receiver AND status=0
 GROUP BY receiver,objectUUID,type;