mirror of
https://github.com/riperiperi/FreeSO
synced 2026-08-13 20:26:13 -04:00
15 lines
889 B
MySQL
15 lines
889 B
MySQL
|
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 ;
|