diff options
Diffstat (limited to 'sql/updates/0.10/5297_characters.sql')
| -rw-r--r-- | sql/updates/0.10/5297_characters.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/0.10/5297_characters.sql b/sql/updates/0.10/5297_characters.sql new file mode 100644 index 00000000000..a2055b648db --- /dev/null +++ b/sql/updates/0.10/5297_characters.sql @@ -0,0 +1,16 @@ +ALTER TABLE `character` RENAME TO `characters`; +ALTER TABLE `group` RENAME TO `groups`; + +ALTER TABLE `character_pet` + CHANGE COLUMN `ABData` `abdata` longtext, + CHANGE COLUMN `TeachSpelldata` `teachspelldata` longtext; + +ALTER TABLE `guild` + CHANGE COLUMN `MOTD` `motd` varchar(255) NOT NULL default ''; + +ALTER TABLE `guild_member` + CHANGE COLUMN `Pnote` `pnote` varchar(255) NOT NULL default '', + CHANGE COLUMN `OFFnote` `offnote` varchar(255) NOT NULL default ''; + +ALTER TABLE `guild_bank_right` + CHANGE COLUMN `Right` `gbright` tinyint(3) unsigned NOT NULL default '0';
\ No newline at end of file |