diff options
Diffstat (limited to 'sql/updates/0.7/3802_petitions.sql')
| -rw-r--r-- | sql/updates/0.7/3802_petitions.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/0.7/3802_petitions.sql b/sql/updates/0.7/3802_petitions.sql new file mode 100644 index 00000000000..7b4e9b8f25a --- /dev/null +++ b/sql/updates/0.7/3802_petitions.sql @@ -0,0 +1,6 @@ +RENAME TABLE `guild_charter` TO `petition`; +RENAME TABLE `guild_charter_sign` TO `petition_sign`; +ALTER TABLE `petition` + CHANGE COLUMN `guildname` `name` varchar(255) NOT NULL default '', + ADD `type` int(10) unsigned NOT NULL default '0' AFTER `name`; +UPDATE `petition` SET `type`='9'; |