diff options
| author | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2010-10-16 15:12:04 +0200 |
|---|---|---|
| committer | Yohann Ferreira <yohann_dot_ferreira_at_orange_dot_efer> | 2010-10-17 17:54:02 +0200 |
| commit | 57aac157c8824b972b5fcb5df894772e2d2389f7 (patch) | |
| tree | e7d1db433d26a2cd0715f300dd1dfc9560bca245 /src/sql/mysql | |
| parent | a500c675a87bf11e7d5980d208555002149d8ccc (diff) | |
| download | manaserv-57aac157c8824b972b5fcb5df894772e2d2389f7.tar.gz manaserv-57aac157c8824b972b5fcb5df894772e2d2389f7.tar.xz manaserv-57aac157c8824b972b5fcb5df894772e2d2389f7.zip | |
Changed the mana_accounts.email field length to 64 characters.
Reviewed-by: Crush.
Resolves: Mana-mantis #251.
Diffstat (limited to 'src/sql/mysql')
| -rw-r--r-- | src/sql/mysql/createTables.sql | 2 | ||||
| -rw-r--r-- | src/sql/mysql/updates/update_11_to_12.sql | 13 |
2 files changed, 14 insertions, 1 deletions
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql index 84a3530..167359d 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 0000000..5029a6d --- /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'; |