Difference between revisions of "Session management"
From WormBaseWiki
Jump to navigationJump to search (New page: == 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:...) |
|||
Line 29: | Line 29: | ||
); | ); | ||
</nowiki> | </nowiki> | ||
+ | |||
+ | |||
+ | [[Category:Developer documentation]] |
Latest revision as of 22:36, 16 August 2010
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) );