Session management

From WormBaseWiki
Revision as of 22:36, 16 August 2010 by Cgrove (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Session / User database

Session and user management uses a single database (wormbase_users). It is comprised of the following tables:

The default sessions table (as defined by CGI::Session::Driver::DBI):


CREATE TABLE sessions (
        id CHAR(32) NOT NULL PRIMARY KEY,
        a_session TEXT NOT NULL
 );


The default user and IP tables as defined by CGI::Session::Auth::DBI. Note that at WormBase, we will probably not use authentication via IP.

 CREATE TABLE auth_user (
            userid char(32) NOT NULL,
            username varchar(30) NOT NULL,
            passwd varchar(30) NOT NULL default '',
            PRIMARY KEY (userid),
            UNIQUE username (username)
 );
 
 CREATE TABLE auth_ip (
            network char(15) NOT NULL,
            netmask char(15) NOT NULL,
            userid char(32) NOT NULL,
            PRIMARY KEY (network, netmask)
 );