Difference between revisions of "Database Table: acctcode"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'acctcode =Definition= <source lang="sql"> CREATE TABLE acctcode ( acid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, userid INT UNSIGNED ...')
 
m (reformat, right category)
Line 1: Line 1:
[[Category: Database Table|acctcode]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE acctcode
 
CREATE TABLE acctcode
Line 13: Line 13:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=Location=
 
 
Global db
 
Global db
 +
 +
[[Category: Database Tables|acctcode]]

Revision as of 08:00, 25 March 2009

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

Location

Global db