Changed the mana_accounts.email field length to 64 characters.

Reviewed-by: Crush.

Resolves: Mana-mantis #251.

1 files changed, 13 insertions, 0 deletions

diff --git a/src/sql/mysql/updates/update_11_to_12.sql b/src/sql/mysql/updates/update_11_to_12.sql
new file mode 100644
index 00000000..5029a6d9
--- /dev/null
+++ b/src/sql/mysql/updates/update_11_to_12.sql
@@ -0,0 +1,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';