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

Revision 2, 392 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 
1ALTER TABLE `petition` 
2  DROP KEY `index_ownerguid_charterguid`,
3  CHANGE COLUMN `charterguid` `petitionguid` int(10) unsigned default '0',
4  ADD UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`);
5ALTER TABLE `petition_sign` 
6  DROP PRIMARY KEY,
7  CHANGE COLUMN `charterguid` `petitionguid` int(10) unsigned default '0',
8  ADD PRIMARY KEY (`petitionguid`,`playerguid`);
Note: See TracBrowser for help on using the browser.