mirror of
https://github.com/simtactics/mysimulation.git
synced 2025-03-25 18:59:12 +00:00
22191ce648
- NioTSO client isn't needed because we're using RayLib - Added FreeSO's API server to handle most backend operations
15 lines
No EOL
889 B
SQL
Executable file
15 lines
No EOL
889 B
SQL
Executable file
CREATE TABLE `fso_generic_avatar_participation` (
|
|
`participation_name` TEXT(64) NOT NULL,
|
|
`participation_avatar` INT UNSIGNED NOT NULL,
|
|
PRIMARY KEY (`participation_name`(64), `participation_avatar`),
|
|
INDEX `fso_generic_ava_idx` (`participation_avatar` ASC),
|
|
INDEX `fso_generic_name_idx` (`participation_name`(64) ASC),
|
|
CONSTRAINT `fso_generic_avatarp_id`
|
|
FOREIGN KEY (`participation_avatar`)
|
|
REFERENCES `fso_avatars` (`avatar_id`)
|
|
ON DELETE CASCADE
|
|
ON UPDATE CASCADE)
|
|
COMMENT = 'If you need a generic way to track avatar participation in things, here it is. Useful for events and tasks that don\'t have their own per-avatar tracking and need it.';
|
|
|
|
ALTER TABLE `fso_tasks`
|
|
CHANGE COLUMN `task_type` `task_type` ENUM('prune_database', 'bonus', 'shutdown', 'job_balance', 'multi_check', 'prune_abandoned_lots', 'neighborhood_tick', 'birthday_gift') NOT NULL ; |