Database Table: acctcode

From Dreamwidth Notes
Revision as of 02:22, 2 October 2009 by Exor674 (Talk | contribs)

Jump to: navigation, search


Definition

CREATE TABLE acctcode
(
  acid    INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  userid  INT UNSIGNED NOT NULL,
  rcptid  INT UNSIGNED NOT NULL DEFAULT 0,
  auth    CHAR(5) NOT NULL,
  INDEX (userid),
  INDEX (rcptid)
)

Relationships

Outgoing

  • Foreign key: userid to user.userid