vcl-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jftho...@apache.org
Subject svn commit: r1797671 - in /vcl/trunk/mysql: update-vcl.sql vcl.sql
Date Mon, 05 Jun 2017 16:15:46 GMT
Author: jfthomps
Date: Mon Jun  5 16:15:46 2017
New Revision: 1797671

URL: http://svn.apache.org/viewvc?rev=1797671&view=rev
Log:
VCL-1045 - Method of encrypting sensitive database entries

vcl.sql and update-vcl.sql: added algorithm, algorithmoption, and keylength to cryptkey and
cryptsecret

Modified:
    vcl/trunk/mysql/update-vcl.sql
    vcl/trunk/mysql/vcl.sql

Modified: vcl/trunk/mysql/update-vcl.sql
URL: http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1797671&r1=1797670&r2=1797671&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Mon Jun  5 16:15:46 2017
@@ -976,8 +976,11 @@ CREATE TABLE IF NOT EXISTS `cryptkey` (
   `hostid` smallint(6) unsigned NOT NULL,
   `hosttype` enum('managementnode','web') NOT NULL DEFAULT 'managementnode',
   `pubkey` varchar(1000) NOT NULL,
+  `algorithm` varchar(80) NOT NULL,
+  `algorithmoption` varchar(255) NOT NULL,
+  `keylength` smallint(5) unsigned NOT NULL,
   PRIMARY KEY (`id`),
-  KEY `hostid` (`hostid`)
+  UNIQUE KEY `hostid` (`hostid`,`hosttype`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
@@ -991,6 +994,9 @@ CREATE TABLE IF NOT EXISTS `cryptsecret`
   `cryptkeyid` smallint(5) unsigned NOT NULL,
   `secretid` smallint(5) unsigned NOT NULL,
   `cryptsecret` varchar(1000) NOT NULL,
+  `algorithm` varchar(80) NOT NULL,
+  `algorithmoption` varchar(255) NOT NULL,
+  `keylength` smallint(5) unsigned NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `cryptkeyid` (`cryptkeyid`,`secretid`),
   KEY `secretid` (`secretid`)

Modified: vcl/trunk/mysql/vcl.sql
URL: http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1797671&r1=1797670&r2=1797671&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Mon Jun  5 16:15:46 2017
@@ -427,8 +427,11 @@ CREATE TABLE IF NOT EXISTS `cryptkey` (
   `hostid` smallint(6) unsigned NOT NULL,
   `hosttype` enum('managementnode','web') NOT NULL DEFAULT 'managementnode',
   `pubkey` varchar(1000) NOT NULL,
+  `algorithm` varchar(80) NOT NULL,
+  `algorithmoption` varchar(255) NOT NULL,
+  `keylength` smallint(5) unsigned NOT NULL,
   PRIMARY KEY (`id`),
-  KEY `hostid` (`hostid`)
+  UNIQUE KEY `hostid` (`hostid`,`hosttype`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
@@ -442,6 +445,9 @@ CREATE TABLE IF NOT EXISTS `cryptsecret`
   `cryptkeyid` smallint(5) unsigned NOT NULL,
   `secretid` smallint(5) unsigned NOT NULL,
   `cryptsecret` varchar(1000) NOT NULL,
+  `algorithm` varchar(80) NOT NULL,
+  `algorithmoption` varchar(255) NOT NULL,
+  `keylength` smallint(5) unsigned NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE KEY `cryptkeyid` (`cryptkeyid`,`secretid`),
   KEY `secretid` (`secretid`)



Mime
View raw message