Author: jfthomps Date: Mon Feb 15 19:49:40 2010 New Revision: 910317 URL: http://svn.apache.org/viewvc?rev=910317&view=rev Log: added table loginlog
Modified: incubator/vcl/trunk/mysql/vcl.sql Modified: incubator/vcl/trunk/mysql/vcl.sql URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=910317&r1=910316&r2=910317&view=diff ============================================================================== --- incubator/vcl/trunk/mysql/vcl.sql (original) +++ incubator/vcl/trunk/mysql/vcl.sql Mon Feb 15 19:49:40 2010 @@ -460,6 +460,23 @@ -- -------------------------------------------------------- +-- +-- Table structure for table `loginlog` +-- + +CREATE TABLE IF NOT EXISTS `loginlog` ( + `user` varchar(50) NOT NULL, + `authmech` varchar(30) NOT NULL, + `affiliationid` mediumint(8) unsigned NOT NULL, + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, + `passfail` tinyint(1) unsigned NOT NULL default '0', + `remoteIP` varchar(15) NOT NULL, + KEY `user` (`user`), + KEY `affiliationid` (`affiliationid`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + -- -- Table structure for table `managementnode` --