sql/updates/0.10/5297_characters.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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';