Difference between revisions of "Database Table: captcha session"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'captcha_session =Definition= <source lang="sql"> CREATE TABLE captcha_session ( sess char(20) NOT NULL default '', sesstime int(10) unsigned ...')
 
Line 13: Line 13:
  
 
=Relationships=
 
=Relationships=
 +
Foreign key lastcapid to [[Database Table: captcha|captcha]].capid
  
 
=Location=
 
=Location=
 
[[Clustered database]]
 
[[Clustered database]]

Revision as of 05:07, 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 captcha.capid

Location

Clustered database