diff options
Diffstat (limited to 'sql/updates/0.7/3806_petitions.sql')
| -rw-r--r-- | sql/updates/0.7/3806_petitions.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/0.7/3806_petitions.sql b/sql/updates/0.7/3806_petitions.sql new file mode 100644 index 00000000000..5763635faa3 --- /dev/null +++ b/sql/updates/0.7/3806_petitions.sql @@ -0,0 +1,8 @@ +ALTER TABLE `petition` + DROP KEY `index_ownerguid_charterguid`, + CHANGE COLUMN `charterguid` `petitionguid` int(10) unsigned default '0', + ADD UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`); +ALTER TABLE `petition_sign` + DROP PRIMARY KEY, + CHANGE COLUMN `charterguid` `petitionguid` int(10) unsigned default '0', + ADD PRIMARY KEY (`petitionguid`,`playerguid`); |