Author: jfthomps Date: Mon Mar 19 14:16:13 2012 New Revision: 1302465 URL: http://svn.apache.org/viewvc?rev=1302465&view=rev Log: VCL-463 add ability to deploy images as servers
vcl.sql and update-vcl.sql: -added loginlog.code -added serverrequest.name -added statgraphcache.provisioningid Modified: incubator/vcl/trunk/mysql/update-vcl.sql incubator/vcl/trunk/mysql/vcl.sql Modified: incubator/vcl/trunk/mysql/update-vcl.sql URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-vcl.sql?rev=1302465&r1=1302464&r2=1302465&view=diff ============================================================================== --- incubator/vcl/trunk/mysql/update-vcl.sql (original) +++ incubator/vcl/trunk/mysql/update-vcl.sql Mon Mar 19 14:16:13 2012 @@ -405,10 +405,13 @@ CREATE TABLE IF NOT EXISTS `loginlog` ( `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `passfail` tinyint(1) unsigned NOT NULL default '0', `remoteIP` varchar(15) NOT NULL, + `code` enum('none','invalid credentials') NOT NULL DEFAULT 'none', KEY `user` (`user`), KEY `affiliationid` (`affiliationid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; +CALL AddColumnIfNotExists('loginlog', 'code', "enum('none','invalid credentials') NOT NULL DEFAULT 'none'"); + -- -------------------------------------------------------- -- @@ -521,6 +524,7 @@ CREATE TABLE IF NOT EXISTS `serverprofil CREATE TABLE IF NOT EXISTS `serverrequest` ( `id` mediumint(8) unsigned NOT NULL auto_increment, + `name` varchar(255) NOT NULL, `serverprofileid` smallint(5) unsigned NOT NULL default '0', `requestid` mediumint(8) unsigned NOT NULL, `fixedIP` varchar(15) default NULL, @@ -568,11 +572,16 @@ CREATE TABLE IF NOT EXISTS `statgraphcac `statdate` date NOT NULL, `affiliationid` mediumint(8) unsigned NOT NULL, `value` mediumint(8) unsigned NOT NULL, + `provisioningid` smallint(5) unsigned NOT NULL, KEY `graphtype` (`graphtype`), KEY `statdate` (`statdate`), - KEY `affiliationid` (`affiliationid`) + KEY `affiliationid` (`affiliationid`), + KEY `provisioningid` (`provisioningid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; +CALL AddColumnIfNotExists('statgraphcache', 'provisioningid', "smallint(5) unsigned default NULL"); +CALL AddIndexIfNotExists('statgraphcache', 'provisioningid'); + -- -------------------------------------------------------- -- Modified: incubator/vcl/trunk/mysql/vcl.sql URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1302465&r1=1302464&r2=1302465&view=diff ============================================================================== --- incubator/vcl/trunk/mysql/vcl.sql (original) +++ incubator/vcl/trunk/mysql/vcl.sql Mon Mar 19 14:16:13 2012 @@ -515,6 +515,7 @@ CREATE TABLE IF NOT EXISTS `loginlog` ( `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, `passfail` tinyint(1) unsigned NOT NULL default '0', `remoteIP` varchar(15) NOT NULL, + `code` enum('none','invalid credentials') NOT NULL DEFAULT 'none', KEY `user` (`user`), KEY `affiliationid` (`affiliationid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; @@ -908,6 +909,7 @@ CREATE TABLE IF NOT EXISTS `serverprofil CREATE TABLE IF NOT EXISTS `serverrequest` ( `id` mediumint(8) unsigned NOT NULL auto_increment, + `name` varchar(255) NOT NULL, `serverprofileid` smallint(5) unsigned NOT NULL default '0', `requestid` mediumint(8) unsigned NOT NULL, `fixedIP` varchar(15) default NULL, @@ -983,9 +985,11 @@ CREATE TABLE `statgraphcache` ( `statdate` date NOT NULL, `affiliationid` mediumint(8) unsigned NOT NULL, `value` mediumint(8) unsigned NOT NULL, + `provisioningid` smallint(5) unsigned NOT NULL, KEY `graphtype` (`graphtype`), KEY `statdate` (`statdate`), - KEY `affiliationid` (`affiliationid`) + KEY `affiliationid` (`affiliationid`), + KEY `provisioningid` (`provisioningid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- --------------------------------------------------------