aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorclick <none@none>2010-12-01 18:17:33 +0100
committerclick <none@none>2010-12-01 18:17:33 +0100
commitaa35190c42dd3e9f7282ea5743e78ba5d5d7e087 (patch)
tree93de578cdb1dc758812b435426e529ba11137fbd /sql/base
parent4e0735196ec09fa4af2099e3d4f37a4b7f362469 (diff)
Core/Database: Adjust character database fields to have an existing default value (group_member) - fixes a transactionerror
--HG-- branch : trunk
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index b9916340c19..96a59021971 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1424,10 +1424,10 @@ DROP TABLE IF EXISTS `group_member`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_member` (
`guid` int(11) unsigned NOT NULL,
- `memberGuid` int(11) unsigned NOT NULL,
- `memberFlags` tinyint(2) unsigned NOT NULL,
- `subgroup` smallint(6) unsigned NOT NULL,
- `roles` smallint(6) unsigned NOT NULL default '0',
+ `memberGuid` int(11) unsigned NOT NULL default '0',
+ `memberFlags` tinyint(3) unsigned NOT NULL default '0',
+ `subgroup` tinyint(3) unsigned NOT NULL default '0',
+ `roles` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`memberGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
/*!40101 SET character_set_client = @saved_cs_client */;