diff options
Diffstat (limited to 'sql-files/upgrade_svn4726.sql')
| -rw-r--r-- | sql-files/upgrade_svn4726.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn4726.sql b/sql-files/upgrade_svn4726.sql new file mode 100644 index 000000000..006797ce0 --- /dev/null +++ b/sql-files/upgrade_svn4726.sql @@ -0,0 +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); |