Difference between revisions of "Database Table: captcha session"

From Dreamwidth Notes
Jump to: navigation, search
(Relationships)
Line 13: Line 13:
  
 
=Relationships=
 
=Relationships=
Foreign key lastcapid to [[Database Table: captcha|captcha]].capid
+
Foreign key lastcapid to [[Database Table: captchas|captchas]].capid
  
 
=Location=
 
=Location=
 
[[Clustered database]]
 
[[Clustered database]]

Revision as of 05:08, 21 March 2009

Definition

CREATE TABLE captcha_session (
    sess CHAR(20) NOT NULL DEFAULT '',
    sesstime INT(10) UNSIGNED NOT NULL DEFAULT '0',
    lastcapid INT(11) DEFAULT NULL,
    trynum SMALLINT(6) DEFAULT '0',
    PRIMARY KEY  (`sess`),
    KEY sesstime (`sesstime`)
)

Relationships

Foreign key lastcapid to captchas.capid

Location

Clustered database