OpenSim/DB/0.9.0/totalsales

Columns†[edit]

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†[edit]

• transactions テーブルから生成

  SELECT receiver,objectUUID,type,COUNT(*),SUM(amount) FROM transactions WHERE sender<>receiver AND status=0
  GROUP BY receiver,objectUUID,type;

最新の30件

[edit]