diff options
Diffstat (limited to 'sql-files/upgrade_svn2574.sql')
| -rw-r--r-- | sql-files/upgrade_svn2574.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn2574.sql b/sql-files/upgrade_svn2574.sql new file mode 100644 index 000000000..3804f0beb --- /dev/null +++ b/sql-files/upgrade_svn2574.sql @@ -0,0 +1,2 @@ +ALTER TABLE friends ADD `friend_account` int(11) NOT NULL default 0 AFTER `char_id`;
+UPDATE friends, `char` SET friends.friend_account=`char`.account_id where friends.friend_id=`char`.char_id;
|