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