aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMachiavelli <none@none>2010-03-15 13:24:45 +0100
committerMachiavelli <none@none>2010-03-15 13:24:45 +0100
commitce51f24ff307307470be0429850a0bc5b0690e8e (patch)
tree71c72d0d0722fe56819b1a3f1b3fc3adf3ea4614
parent8268adc93236214986a08f6f58b6ce65037f6749 (diff)
Change field `crc` in characters.addons to int(32) to support proper values.
--HG-- branch : trunk
-rw-r--r--sql/characters.sql2
-rw-r--r--sql/updates/7577_characters_addons.sql1
2 files changed, 2 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql
index 4c14fb56793..2ef0a8553d6 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -49,7 +49,7 @@ DROP TABLE IF EXISTS `addons`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `addons` (
`name` varchar(120) NOT NULL default '',
- `crc` mediumint(32) unsigned NOT NULL default '0',
+ `crc` int(32) unsigned NOT NULL default '0',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Addons';
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/7577_characters_addons.sql b/sql/updates/7577_characters_addons.sql
new file mode 100644
index 00000000000..6fc7ad3ebd1
--- /dev/null
+++ b/sql/updates/7577_characters_addons.sql
@@ -0,0 +1 @@
+ALTER TABLE `addons` CHANGE `crc` `crc` int(32) unsigned NOT NULL default '0';