upgrade_svn2574.sql « sql-files - evol/hercules - The Mana World fork of Hercules. This is vanilla Hercules with a few tiny modifications for our specific needs. Mutually-beneficial modifications are contributed upstream.

summary refs log tree commit diff

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;