mailkey on STRICT mode MySQL

**cavedude** · #1 02-07-2009, 05:26 PM

Hey John, nice to see you around. I see EQ2Emu is coming along well

The schema for mailkey that PEQ uses is:

`mailkey` CHAR(16) NOT NULL default '0',

The key should get auto-assigned sometime after character creation. I'm not sure when, Derision would have to tell you that. The default 0 should at least allow you in-game, and the key will probably be assigned when you get the mail server up and running.

John Adams · #2 02-08-2009, 04:03 AM

Ok, thanks Cavedude. I don't think the provided table create has the default '0', because mine was default ''. I'll change the default and let it go that way.

Thanks for the heads up.

**cavedude** · #3 02-08-2009, 02:11 PM

It's good practice to always have a default value in a NOT NULL column anyway. The only exception is in cases were it is imperative that a value is manually entered. This isn't one of them. On PEQ, when a character is created mailkey defaults to 0, and somewhere along the line it gets to changed to an actual key.

EDIT: I just changed the column on SVN to avoid any further confusion.