Difference between revisions of "Database Table: captcha session"

From Dreamwidth Notes
Jump to: navigation, search
(Relationships)
m
Line 1: Line 1:
[[Category: Database Table|captcha_session]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE captcha_session (
 
CREATE TABLE captcha_session (
Line 12: Line 12:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 
Foreign key lastcapid to [[Database Table: captchas|captchas]].capid
 
Foreign key lastcapid to [[Database Table: captchas|captchas]].capid
  
=Location=
+
= Location =
 +
 
 
[[Clustered database]]
 
[[Clustered database]]
 +
 +
[[Category: Database Tables|captcha_session]]

Revision as of 23:32, 26 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