mirror of
https://github.com/simtactics/mysimulation.git
synced 2025-03-23 18:02:23 +00:00
22191ce648
- NioTSO client isn't needed because we're using RayLib - Added FreeSO's API server to handle most backend operations
12 lines
No EOL
604 B
SQL
Executable file
12 lines
No EOL
604 B
SQL
Executable file
CREATE TABLE IF NOT EXISTS `fso_tasks` (
|
|
`task_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`task_type` enum('prune_database','bonus') NOT NULL,
|
|
`task_status` enum('in_progress','completed','failed') NOT NULL,
|
|
`time_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`time_completed` datetime DEFAULT NULL,
|
|
`shard_id` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`task_id`),
|
|
KEY `FK_fso_tasks_fso_shards` (`shard_id`),
|
|
CONSTRAINT `FK_fso_tasks_fso_shards` FOREIGN KEY (`shard_id`) REFERENCES `fso_shards` (`shard_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
) COLLATE='utf8_general_ci'
|
|
ENGINE=InnoDB; |