summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn2574.sql
blob: 35e4441060018ae20bedda88834ab59d65d3bfe0 (plain) (blame)
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;