mirror of
https://github.com/simtactics/mysimulation.git
synced 2025-03-23 01:42:24 +00:00
22191ce648
- NioTSO client isn't needed because we're using RayLib - Added FreeSO's API server to handle most backend operations
11 lines
No EOL
467 B
SQL
Executable file
11 lines
No EOL
467 B
SQL
Executable file
CREATE TABLE IF NOT EXISTS `fso_transactions` (
|
|
`from_id` int(11) unsigned NOT NULL,
|
|
`to_id` int(11) unsigned NOT NULL,
|
|
`transaction_type` int(11) unsigned NOT NULL,
|
|
`value` int(11) unsigned NOT NULL,
|
|
`time_first` int(11) unsigned NOT NULL,
|
|
`time_last` int(11) unsigned NOT NULL,
|
|
`count` int(11) unsigned NOT NULL,
|
|
`value_per_hour` double unsigned NOT NULL,
|
|
PRIMARY KEY (`from_id`,`to_id`,`transaction_type`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |