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`
--
