summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn4726.sql
blob: 006797ce0446ecf5da4ba7fc80ebd09f75dcfc1d (plain) (blame)
1
2
ALTER TABLE `party` ADD COLUMN `leader_char` int(11) NOT NULL DEFAULT '0' AFTER `leader_id`;
UPDATE `party`,`char` SET `leader_char` = `char`.char_id WHERE (`char`.party_id = `party`.party_id AND `party`.leader_id = `char`.account_id);