实现作业集合的最佳算法是什么？

Question

This is what I'm trying to achieve. I have a set of 50 different jobs (by class I mean, soldier, mage, monk, etc)

Each user randomly gets a card each time he/she completes a quest. So at certain point you can have a soldier and a monk, but a mage will be missing. That means your collection will look like

Soldier    Yes
Mage       No
Monk       Yes

At anytime you can get the same card (you can have 10 soldiers, but for your collection is only a yes or no)

At anytime you can drop the job. But you keep the job "collected" Therefore if you drop a Soldier the collection will look like this

Soldier    Yes
Mage       No
Monk       Yes

If you notice, even if I don't have a Soldier right now. I have already "collected" that job.

I was thinking about what would be the best way to implement this in MySQL and PHP?

Mi ideas right now are 2 1. create a new table collection and keep one record for each job you get. 2. create just one field with pipes as separators and implode/explode results

Answer 1

Why don't you use a single bitmask column.

Say Soldier = 1, Mage = 2, Monk = 4.

Thus if you have only mage and monk the value would be 2 | 4 = 6.

This way you allow yourself to easily add different classes later, without the need to change the schema.