From 57aac157c8824b972b5fcb5df894772e2d2389f7 Mon Sep 17 00:00:00 2001 From: Yohann Ferreira Date: Sat, 16 Oct 2010 15:12:04 +0200 Subject: Changed the mana_accounts.email field length to 64 characters. Reviewed-by: Crush. Resolves: Mana-mantis #251. --- src/sql/mysql/createTables.sql | 2 +- src/sql/mysql/updates/update_11_to_12.sql | 13 +++++++++++++ src/sql/sqlite/updates/update_11_to_12.sql | 10 ++++++++++ 3 files changed, 24 insertions(+), 1 deletion(-) create mode 100644 src/sql/mysql/updates/update_11_to_12.sql create mode 100644 src/sql/sqlite/updates/update_11_to_12.sql (limited to 'src') diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 84a35308..167359d5 100644 --- a/src/sql/mysql/createTables.sql +++ b/src/sql/mysql/createTables.sql @@ -6,7 +6,7 @@ CREATE TABLE IF NOT EXISTS `mana_accounts` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL, `password` varchar(64) NOT NULL, - `email` varchar(32) NOT NULL, + `email` varchar(64) NOT NULL, `level` tinyint(3) unsigned NOT NULL, `banned` int(10) unsigned NOT NULL, `registration` int(10) unsigned NOT NULL, 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'; diff --git a/src/sql/sqlite/updates/update_11_to_12.sql b/src/sql/sqlite/updates/update_11_to_12.sql new file mode 100644 index 00000000..921bcf82 --- /dev/null +++ b/src/sql/sqlite/updates/update_11_to_12.sql @@ -0,0 +1,10 @@ +-- +-- SQLite - update 11 to 12 doesn't affect Sqlite, +-- so we only change the database version number. +-- + +-- update the database version, and set date of update +UPDATE mana_world_states + SET value = '12', + moddate = strftime('%s','now') + WHERE state_name = 'database_version'; -- cgit v1.2.3-70-g09d2