Network System Laboratory - Source of OpenSim/DB/0.9.0/totalsales

View the diff.
Go to OpenSim/DB/0.9.0/totalsales.

*** 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;

« Prev

Backup list of OpenSim/DB/0.9.0/totalsales
Backup source of OpenSim/DB/0.9.0/totalsales(No. All)
- 1: 2016-05-21 (Sat) 18:47:11 iseki
- Cur: 2016-05-21 (Sat) 18:52:08 iseki

Source of OpenSim/DB/0.9.0/totalsales

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of OpenSim​/DB​/0.9.0​/totalsales

Site Search

Login

Sub Menu

Books

mini Calendar

Who's Online

Access Counter

Source of OpenSim/DB/0.9.0/totalsales