Database Table: friends

Definition

CREATE TABLE friends (
  userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  friendid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  fgcolor CHAR(7) DEFAULT NULL,
  bgcolor CHAR(7) DEFAULT NULL,
  groupmask BIGINT(20) UNSIGNED NOT NULL DEFAULT '1',
  showbydefault enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY  (userid,friendid),
  KEY (friendid)
)

Location

Global database