Social friends

From ArcEmu-Wiki
Revision as of 15:02, 11 March 2010 by Shadoxfix (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

character_guid

Guid of the player.

friend_guid

Guid of friend.

note

Note made by the player.

SQL Structure

CREATE TABLE `social_friends` (
  `character_guid` int(30) NOT NULL,
  `friend_guid` int(30) NOT NULL,
  `note` varchar(100) NOT NULL,
  PRIMARY KEY (`character_guid`,`friend_guid`),
  KEY `a` (`character_guid`),
  KEY `b` (`friend_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Personal tools