mirror of
https://github.com/riperiperi/FreeSO
synced 2026-08-13 20:26:13 -04:00
b2bbaa8288
* Hosts keep track of the servers in the pool. Each server and its role is recorded. This helps with service discovery. * Tasks are async events that have run such as database pruning or top100 calculation. This helps admins know if a task completed or not.
13 lines
No EOL
568 B
SQL
13 lines
No EOL
568 B
SQL
CREATE TABLE IF NOT EXISTS `fso_hosts` (
|
|
`call_sign` varchar(50) NOT NULL,
|
|
`role` enum('city','lot','task') NOT NULL,
|
|
`status` enum('up','down') NOT NULL,
|
|
`internal_host` varchar(100) NOT NULL,
|
|
`public_host` varchar(100) NOT NULL,
|
|
`time_boot` datetime NOT NULL,
|
|
`shard_id` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`call_sign`),
|
|
KEY `FK_fso_hosts_fso_shards` (`shard_id`),
|
|
CONSTRAINT `FK_fso_hosts_fso_shards` FOREIGN KEY (`shard_id`) REFERENCES `fso_shards` (`shard_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
) COLLATE='utf8_general_ci'
|
|
ENGINE=InnoDB; |