blob: 5029a6d9c4605d8170e4d5c0307a14bc118501fc (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
--
-- Modify the table `mana_accouns` to change the email field length.
-- Since the email is hashed, it needs a length of 64.
--
-- Note: `email` `email` isn't a copy paste error ;) See MySQL syntax.
ALTER TABLE `mana_accounts` CHANGE COLUMN `email` `email` varchar(64) NOT NULL;
-- Update database version.
UPDATE mana_world_states
SET value = '12',
moddate = UNIX_TIMESTAMP()
WHERE state_name = 'database_version';
|
