root/trunk/sql/updates/0.7/3802_petitions.sql @ 2

Revision 2, 290 bytes (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00
Line 
1RENAME TABLE `guild_charter` TO `petition`;
2RENAME TABLE `guild_charter_sign` TO `petition_sign`;
3ALTER TABLE `petition` 
4  CHANGE COLUMN `guildname` `name` varchar(255) NOT NULL default '',
5  ADD `type` int(10) unsigned NOT NULL default '0' AFTER `name`;
6UPDATE `petition` SET `type`='9';
Note: See TracBrowser for help on using the browser.