Author: jfthomps
Date: Tue May 30 19:01:48 2017
New Revision: 1796914
URL: http://svn.apache.org/viewvc?rev=1796914&view=rev
Log:
VCL-1045 - Method of encrypting sensitive database entries
vclsql and update-vcl.sql: removed constraints for addomain.secretid - the
constraint doesn't work out well because there can be duplicate entries for
secretid in 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=1796914&r1=1796913&r2=1796914&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Tue May 30 19:01:48 2017
@@ -2090,16 +2090,6 @@ UPDATE vmprofile SET vmprofile.datastore
-- --------------------------------------------------------
--
--- Constraints for table `addomain`
---
-
-CALL DropExistingConstraints('addomain', 'secretid');
-
-CALL AddConstraintIfNotExists('addomain', 'secretid', 'cryptsecret',
'secretid', 'none', '');
-
--- --------------------------------------------------------
-
---
-- Constraints for table `blockComputers`
--
Modified: vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1796914&r1=1796913&r2=1796914&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Tue May 30 19:01:48 2017
@@ -2306,11 +2306,6 @@ INSERT IGNORE INTO `vmtype` (`id`, `name
--
--
--- Constraints for table `addomain`
---
-ALTER TABLE `addomain` ADD CONSTRAINT FOREIGN KEY (`secretid`) REFERENCES
`cryptsecret` (`secretid`);
-
---
-- Constraints for table `blockComputers`
--
ALTER TABLE `blockComputers` ADD CONSTRAINT FOREIGN KEY (`blockTimeid`)
REFERENCES `blockTimes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
