Profession Bag Limit

I think [MENTION=2054]Eos[/MENTION]; once said that the BMS database used no indexing, but I could be misremembering.

There are some random indexes here and there, but not many and not where they'd be most useful.

For the tabs they'd be fine to add slots indefinitely, well, up to 2,147,483,647, clearly more than anyone needs, they use an ordinal value positioning system with a separate table per tab. Note the incrementing POS column that defines the ordinal location.

ETC Tab Sample;

 Spoiler

SN	CharacterID	POS	ItemID	Number	ExpireDate	Title	Attribute	ItemSN
1	2	1	4000295	1	2079-01-01		0	0
2	2	2	4000185	1	2079-01-01		0	0
3	2	3	4000057	2	2079-01-01		0	0
4	2	4	4000129	2	2079-01-01		0	0
5	2	5	4031189	1	2079-01-01		0	0
6	2	6	4031170	3	2079-01-01		0	0
7	2	7	4000176	2	2079-01-01		0	0
8	2	8	4000128	1	2079-01-01		0	0
9	2	9	4031175	2	2079-01-01		0	0
10	2	10	4021008	1	2079-01-01		0	0
11	2	11	4000027	1	2079-01-01		0	0
12	2	12	4031222	2	2079-01-01		0	0
13	10	1	4006001	100	2079-01-01		0	0
14	10	2	4000004	17	2079-01-01		0	0
15	10	3	4000000	18	2079-01-01		0	0
16	10	4	4000010	2	2079-01-01		0	0
17	10	5	4010001	1	2079-01-01		0	0
18	10	6	4000001	12	2079-01-01		0	0
19	10	7	4000016	14	2079-01-01		0	0
20	10	8	4000003	5	2079-01-01		0	0
21	10	9	4000012	21	2079-01-01		0	0
22	10	10	4000011	3	2079-01-01		0	0
23	12	1	4000038	1	2079-01-01		0	0
24	8	1	4031475	2	2079-01-01		0	0
25	8	2	4031466	1	2079-01-01		0	0
26	2	13	4000014	2	2079-01-01		0	0
27	2	14	4001077	1	2079-01-01		0	0
28	2	15	4000285	1	2079-01-01		0	0
29	2	16	4000143	1	2079-01-01		0	0
30	2	17	4000049	1	2079-01-01		0	0
31	2	18	4000282	1	2079-01-01		0	0
32	2	19	4031195	1	2079-01-01		0	0
33	2	20	4000173	1	2079-01-01		0	0

There are no indexes on that, though there really should be a clustered index, or even primary key, on CharacterID, POS to immediately grab a specific spot in any character's inventory on demand. One would hope GMS or KMS would've done that by now, but BMS hadn't.

If I recall they use negative POS in the equip table to indicate which ones are being worn and where, so that table covers both items in your equip tab and items you're actually wearing.

Character lists are similarly vertical.

CharacterID	AccountID	WorldID	CharacterName	Gender
2	0	0	Bob	0
8	2	0	Ted	0
9	3	0	George	0
10	1	0	Fredwina	1
11	4	0	Mark	0
12	5	0	James	0
13	1	0	Waffles	0

So no limit on how many characters.